Table Description
ProgramAuthorisationData: A Program Authorisation Data record is used to store the details of a program authorization on the application case. This entity is used to store information on the program authorization action which is then available for user review.

Example

James Smith has a Social Benefits application case for Food Allowance and Rent Allowance. A worker processing the application determines that James is eligible for Food Allowance and authorizes the program on the application case. The Food Allowance program status is updated to Authorized, and a ProgramAuthorisationData 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::Authorisation::Entity::ProgramAuthorisationData::ProgramAuthorisationData
Controlling File: CommonIntake\model\Packages\Authorisation\Entity\ProgramAuthorisationData.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
programAuthorisationDataIDkeynoUnique identifier of the Program Authorisation Data record.INTERNAL_ID SVR_INT64
programIDdetailsnoThe unique identifier of the intake program application being authorized.INTERNAL_ID SVR_INT64
authorisedBydetailsnoThe username of the user who authorized the program.USER_NAME SVR_STRING<64>
commentsdetailsyesComments on the authorization. These may be comments entered by the worker or text output at the end of the authorization rule set execution.RICH_TEXT_COMMENTS SVR_STRING<2000>
applicationCaseIDdetailsnoThe unique identifier of the Application Case.CASE_ID SVR_INT64
integratedCaseIDdetailsyesThe unique identifier of the ongoing Integrated Case. An integrated case identifier may not be specified because the authorization process may be handled by another system.CASE_ID SVR_INT64
authorisationDatedetailsnoThe date on which the program was authorized.CURAM_DATE SVR_DATE
productDeliveryCaseIDdetailsyesThe unique identifier of the Product Delivery. A product delivery case ID may not be specified simply because the authorization process is not configured to create on, or alternatively another system may be responsible for managing the delivery of benefits.CASE_ID SVR_INT64
outcomePlanIDdetailsyesThe unique identifier of the OutcomePlan. A outcome plan identifier may not be specified because the authorization process may be handled by another system.CASE_ID SVR_INT64
Foreign Keys (5)
ChildParent
ProgramAuthorisationData.productDeliveryCaseIDCaseHeader.caseID
ProgramAuthorisationData.applicationCaseIDCaseHeader.caseID
ProgramAuthorisationData.integratedCaseIDCaseHeader.caseID
ProgramAuthorisationData.programIDIntakeProgramApplication.intakeProgramApplicationID
ProgAuthorDataEvidLink.programAuthorisationDataIDProgramAuthorisationData.programAuthorisationDataID
Indices (4)
Index NameAttributes
ProgAthDataCaseIdxapplicationCaseID
ProgAthDataProgIdxprogramID
IND_815897237productDeliveryCaseID
IND__1809881929integratedCaseID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: programAuthorisationDataID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByApplicationCaseIDreadmulti Retrieves a list of Program Authorisation Data records for the specified ApplicationCase. 
searchByProgramIDreadmulti Retrieves a list of Program Authorisation Data records for the specified Intake Program Application. 
Related Pages (2)