Table Description
ProgramDenial: Stores the details of a program denial. The worker can manually deny a program on an application. A program may be denied multiple times, if the organization allows workers to reopen programs that have been denied.

Example

James Smith has a Social Benefits application case for Food Allowance and Rent Allowance. A worker processing the application determines that James is ineligible for Food Allowance and denies the program on the application case. The Food Allowance program status is updated to Denied on the application case and a ProgramDenial record is created on the application case.
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::Authorisation::Entity::ProgramDenial::ProgramDenial
Controlling File: CommonIntake\model\Packages\Authorisation\Entity\ProgramDenial.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
programDenialIDkeynoUnique identifier of the program denial record.INTERNAL_ID SVR_INT64
intakeProgramApplicationIDdetailsnoUnique identifier of the intake program application record to which the program denial is associated. INTAKE_PROGRAM_APPLICATION_ID SVR_INT64
commentsdetailsyesComments on the denial record.RICH_TEXT_COMMENTS SVR_STRING<2000>
createdBydetailsnoThe username of the user who created this denial record.USER_FULL_NAME SVR_STRING<131>
denialDatedetailsnoThe date on which the denial was recorded. This is automatically set to the current date.CURAM_DATE SVR_DATE
reasondetailsnoThe reason for the denial.PROGRAM_DENIAL_REASONIntakeProgApplDenyReasonSVR_STRING<10>
Foreign Keys (1)
ChildParent
ProgramDenial.intakeProgramApplicationIDIntakeProgramApplication.intakeProgramApplicationID
Indices (1)
Index NameAttributes
PrgDenProgAppIDIdxintakeProgramApplicationID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: programDenialID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByIntakeProgramApplicationreadmulti Retrieves a list of program denial records for a given intake program application. 
Related Pages (2)