Database Table: ProgramAuthorisationData
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. |
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
|
|
Location in Model: | Logical View::MetaModel::Curam::CommonIntake::CommonIntake::Authorisation::Entity::ProgramAuthorisationData::ProgramAuthorisationData |
Controlling File: | CommonIntake\model\Packages\Authorisation\Entity\ProgramAuthorisationData.efx |
ALLOW_OPTIMISTIC_LOCKING | yes |
Attribute | Stereotype | Nullable | Description | Domain Definition | Codetable | DDL Type |
programAuthorisationDataID | key | no | Unique identifier of the Program Authorisation Data record. | INTERNAL_ID | | SVR_INT64 |
programID | details | no | The unique identifier of the intake program application being authorized. | INTERNAL_ID | | SVR_INT64 |
authorisedBy | details | no | The username of the user who authorized the program. | USER_NAME | | SVR_STRING<64> |
| details | yes | Comments 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> |
applicationCaseID | details | no | The unique identifier of the Application Case. | CASE_ID | | SVR_INT64 |
integratedCaseID | details | yes | The 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 |
authorisationDate | details | no | The date on which the program was authorized. | CURAM_DATE | | SVR_DATE |
productDeliveryCaseID | details | yes | The 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 |
outcomePlanID | details | yes | The 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 |
|
Index Name | Attributes |
ProgAthDataCaseIdx | applicationCaseID |
ProgAthDataProgIdx | programID |
IND_815897237 | productDeliveryCaseID |
IND__1809881929 | integratedCaseID |
|
Operation | Stereotype | Options | Description | SQL |
insert | insert | AUTO_ID: programAuthorisationDataID
| Standard Operation | |
modify | modify | OPTIMISTIC_LOCKING: yes
| Standard Operation | |
read | read | | Standard Operation | |
searchByApplicationCaseID | readmulti | | Retrieves a list of Program Authorisation Data records for the specified ApplicationCase. | |
searchByProgramID | readmulti | | Retrieves a list of Program Authorisation Data records for the specified Intake Program Application. | |
|