Database Table: AuthorisationDataLog
| AuthorisationDataLog:
Captures authorization process related log.
This entity captures the application case and the associated product delivery case, integrated case and datastore map as part of authorization process.
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 AuthorizedInProgress and a AuthorisationDataLog record is created with record status "NORMAL". If the Evidence Broker fails, rollback handler is invoked and puts the program to 'AuthorizationFailure' status and the record status of AuthorisationDataLog will be set to 'CANCELLED'. |
|
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::AuthorisationDataLog::AuthorisationDataLog |
| Controlling File: | CommonIntake\model\Packages\Authorisation\Entity\Entity.efx |
| ALLOW_OPTIMISTIC_LOCKING | yes |
| Attribute | Stereotype | Nullable | Description | Domain Definition | Codetable | DDL Type |
| authorisationLogID | key | no | The unique identifier of the AuthorisationDataLog. | INTERNAL_ID | | SVR_INT64 |
| isIntegratedCaseCreatedOrReuse | details | yes | Indicates whether the associated integrated case is newly created or reused. | CURAM_INDICATOR | | SVR_BOOLEAN |
| details | yes | The comments entered by the user while authorizing the program. | RICH_TEXT_COMMENTS | | SVR_STRING<2000> |
| recordStatus | details | no | The record status of the authorisation process log. In case of authorisation failure, the status will be set to 'CANCELLED' and if the authorization is in progress/completes, the record status will be 'NORMAL'. | RECORD_STATUS | RecordStatus | SVR_STRING<10> |
| createdBy | details | yes | The username of the user who authorizes the program or application. | USER_NAME | | SVR_STRING<64> |
| createdTimestamp | details | yes | The timestamp when the authorisation process log has been captured. | CURAM_DATETIME | | SVR_DATETIME |
| applicationCaseID | details | no | @curam.logicalname AuthorisationDataLog
@curam.definition Captures authorization process related log.
@curam.description This entity captures the application case and the associated product delivery case, integrated case and datastore map as part of authorization process.
| INTERNAL_ID | | SVR_INT64 |
| integratedCaseID | details | yes | The unique identifier of the ongoing Integrated Case associated with the application case being authorized. | INTERNAL_ID | | SVR_INT64 |
| 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. | INTERNAL_ID | | SVR_INT64 |
| programID | details | no | The unique identifier of the intake program application being authorized. | INTERNAL_ID | | SVR_INT64 |
| datastorelinkID | details | no | The data store link identifier which maps the authorization to Evidence Broker deferred process and returns back the same. | INTERNAL_ID | | SVR_INT64 |
| outcomePlanID | details | yes | The unique identifier of the outcome plan associated with the application case being authorized. | INTERNAL_ID | | SVR_INT64 |
| isOutcomePlanCreatedOrReuse | details | yes | Indicates whether the associated outcome plan is newly created or reused. | CURAM_INDICATOR | | SVR_BOOLEAN |
|
| Index Name | Attributes |
| AuthDataLogCaseProgIdx | applicationCaseID, programID, recordStatus |
| AuthDataLogDataStrIdx | datastorelinkID |
| IND_460341763 | integratedCaseID |
| IND_1543711945 | productDeliveryCaseID |
|
| Operation | Stereotype | Options | Description | SQL |
| insert | insert | AUTO_ID: authorisationLogID
| Standard Operation | |
| modify | modify | OPTIMISTIC_LOCKING: yes
| Standard Operation | |
| read | read | | Standard Operation | |
| searchByApplicationCaseIDAndProgramID | readmulti | | Retrieves a list of Authorization Data Log records for the specified Application Case and Intake Program . | |
| searchByDatastoreLinkID | readmulti | | Retrieves a list of Authorization Data Log records for the specified data store link identifier. | |
|
