Table Description
ProgramReopenInfo: Stores the reopen details for a program application. A program that has been withdrawn or denied may be reopened by a worker. For example, the client may appeal a denial of a program. A program may be reopened multiple times.

Example

James Smith has a Social Benefits application case for Food Allowance and Rent Allowance. The worker processing the application denied the Food Allowance program as James was ineligible. James contacts the agency with some additional information that he forgot to include on his initial application for benefits. The worker reopens the Food Allowance program on the application case and a ProgramReopenInfo record is created.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::CommonIntake::CommonIntake::Entity::ProgramReopenInfo::ProgramReopenInfo
Controlling File: CommonIntake\model\Packages\Entity\ProgramReopenInfo.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
programReopenInfoIDkeynoUnique identifier of the program reopen details record.INTERNAL_ID SVR_INT64
commentsdetailsyesThe comments in relation to the program reopen info. COMMENTS SVR_STRING<300>
reasondetailsnoThe reason for reopening the program. PROGRAM_STATUS_TRANSITION_REASONProgAppStatusTransReasonSVR_STRING<10>
createdBydetailsnoThe username of the user who reopened the program application.USER_NAME SVR_STRING<64>
reopenDatedetailsnoThe date on which the program was reopened.CURAM_DATE SVR_DATE
intakeProgramApplicationIDdetailsnoThe unique identifier of the intake program application record to which the program reopen info record is associated.INTERNAL_ID SVR_INT64
Foreign Keys (1)
ChildParent
ProgramReopenInfo.intakeProgramApplicationIDIntakeProgramApplication.intakeProgramApplicationID
Indices (1)
Index NameAttributes
ProReopenIntakeIdxintakeProgramApplicationID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: programReopenInfoID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByProgramApplicationreadmultiORDER_BY: reopenDate
Returns a list of all Program Reopen Info records that are related to the given Intake Program Application. 
Related Pages (2)