Table Description
Program App Status Transition: nbsp;This entity is to store the information about the program status transition for a specific program application.

This entity will record any transition status records for a program application, e.g. reopening a program application.

Example
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::Intake::IntakeModules::Application::Entity::ProgramAppStatusTransition
Controlling File: Intake\model\Packages\IntakeModules\IntakeApplication\Entity\Entity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
programAppStatusTransitionIDkeynoUnique identifier for this record.INTERNAL_ID SVR_INT64
programApplicationStatusIDdetailsnoReference to the status of this program application.INTERNAL_ID SVR_INT64
reasondetailsnoThe reason for the program application status transition. PROGRAM_STATUS_TRANSITION_REASONProgAppStatusTransReasonSVR_STRING<10>
commentsdetails The comments in relation to the program application status transition. COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
ProgramAppStatusTransition.programApplicationStatusIDProgramApplicationStatus.programApplicationStatusID
Indices (1)
Index NameAttributes
ProgStatProgStatTransIdxprogramApplicationStatusID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: programAppStatusTransitionID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByProgAppIDandProgAppStatusnsmulti Retrieves a list of record by the programApplicationID and the programApplication status.SQL
Related Pages (2)