Table Description
Program ApplicationWithdrawalStatus: This entity is to store the information about the program withdrawal request status history. A client can make an online request for a program application to be withdrawn.

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::ProgramWithdrawalRequest
Controlling File: Intake\model\Packages\IntakeModules\IntakeApplication\Entity\Entity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
programWithdrawalRequestIDkeynoThe unique identifier of the entityINTERNAL_ID SVR_INT64
programApplicationIDdetailsnoThe program id associated with the withdraw the requestINTERNAL_ID SVR_INT64
requestMethoddetails The method of request associated with the withdrawal ApplicationREQUEST_METHODProgWithdrawalReqMethodSVR_STRING<10>
withdrawalReasondetails Withdrawal Reason for the Application MadeWITHDRAWAL_REASONProgWithdrawalReqReasonSVR_STRING<10>
commentsdetails comments regarding ProgramApplicationiWithdrawalRequestCOMMENTS SVR_STRING<300>
statusdetails The status of the withdrawal ApplicationWITHDRAWAL_STATUSProgWithdrawalReqStatusSVR_STRING<10>
submittedDateTimedetailsnoThe date time the program application was made. CURAM_DATETIME SVR_DATETIME
resolvedDateTimedetails The date time the resolved application was made. CURAM_DATETIME SVR_DATETIME
denialReasondetails denial reason for ProgramApplicationiWithdrawalRequestDENIAL_REASONDenialReasonSVR_STRING<10>
requestedByConcernRoleIDdetailsyesThe concern role ID of the applicant.CONCERN_ROLE_ID SVR_INT64
withDrawalOtherReasondetails Withdrawal other reason for the Application MadeWITHDRAWAL_OTHER_REASON SVR_STRING<500>
Foreign Keys (2)
ChildParent
ProgramWithdrawalRequest.requestedByConcernRoleIDConcernRole.concernRoleID
ProgramWithdrawalRequest.programApplicationIDProgramApplication.programApplicationID
Indices (2)
Index NameAttributes
IND__759447344programApplicationID
IND__101415819requestedByConcernRoleID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: programWithdrawalRequestID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByProgramApplicationreadmulti   
readByProgramApplicationnsread @deprecated Since Curam 6.0 SP1 EP, this method has been replaced by searchByProgramApplication 
readOpenWithdrawalRequestns This method retrieves the current OPEN programWithdrawalRequest record for an application.SQL
Related Pages (8)