Table Description
Withdrawal Request: This entity represents a request by a citizen to withdraw an application for a program that the citizen has already submitted to the social agency.
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::WorkspaceServices::Entity::Intake::WithdrawalRequest::WithdrawalRequest
Controlling File: WorkspaceServices\model\Packages\Entity\WithdrawalRequest\WithdrawalRequest_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (14)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
withdrawalRequestIDkeynoUnique identifier for this record. INTERNAL_ID SVR_INT64
intakeProgramApplicationIDdetailsnoThe submitted application for which the request to withdraw the program is being made. INTAKE_PROGRAM_APPLICATION_ID SVR_INT64
statusdetailsnoThe status of the withdrawal request, e.g. Pending, Approved or Denied. WITHDRAWAL_REQUEST_STATUSWithdrawalRequestStatusSVR_STRING<10>
submittedDateTimedetailsnoThe date and time that the citizen submitted the withdrawal request. CURAM_DATETIME SVR_DATETIME
resolvedDateTimedetails The date and time that the decision to approve or deny the withdrawal request was made. CURAM_DATETIME SVR_DATETIME
withdrawalRequestReasondetails The reason why the citizen wants to withdraw the application. Specific withdrawal reasons can be defined for each different type on online applications present in the Citizen Portal. WITHDRAWAL_REQUEST_REASON_CODEWithdrawalRequestReasonSVR_STRING<10>
denialReasondetailsyesThe reason why a case worker decided to deny a withdrawal request. COMMENTS SVR_STRING<300>
commentsdetailsyesAdditional text entered by the case worker pertaining to the withdrawal request. COMMENTS SVR_STRING<300>
requestMethoddetailsyesThe method by which the withdrawal request was submitted by the citizen, e.g. online. INTAKE_APPLICATION_METHODIntakeApplicationMethodSVR_STRING<10>
otherWReqReasondetailsyesIf the reason for the withdrawal request is not present in the list of withdrawal request reasons, the citizen can choose to enter free text detailing the reason why the citizen would like to withdraw the application. COMMENTS SVR_STRING<300>
firstNamedetailsyesThe first name of the citizen making the withdrawal request. FIRST_FORENAME SVR_STRING<65>
middleNamedetailsyesThe middle name of the citizen making the withdrawal request. OTHER_FORENAME SVR_STRING<65>
surnamedetailsyesThe surname of the citizen making the withdrawal request. SURNAME SVR_STRING<65>
withdrawnBydetailsyesThe name of the user who withdrew the application. This field is only populated for programs that are withdrawn by an internal user. This field is not populated for programs that are withdrawn online by the citizen.USER_NAME SVR_STRING<64>
Foreign Keys (2)
ChildParent
WithdrawalRequest.intakeProgramApplicationIDIntakeProgramApplication.intakeProgramApplicationID
WithdrawalRequest.withdrawnByUsers.userName
Indices (2)
Index NameAttributes
WReqIdx1intakeProgramApplicationID, status
IND__1109523114withdrawnBy
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: withdrawalRequestID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByIntakeProgramApplicationreadmulti Searches for withdrawal requests by parent intake program application. 
readByProgramApplicationAndStatusnsread Reads a record by IntakeProgramApplicationID and request status. 
Related Pages (13)