Table Description
Issue Approval Request: A link between an approval request and an issue.

When an issue resolution is submitted for approval and subsequently approved or rejected, an approval request and issue approval request are created. The issue approval request table stores the comments added by a user when a resolution is submitted for approval. The approval request table contains the remaining information relating to the approval request e.g. requested by, request date.

Example

During case processing a discrepancy is identified between the earned income details provided by the client and those provided by the client's employer. An earned income issue is automatically created. A user reviews the issue and renders a resolution on the issue favoring the employer's information. A resolution status history record is created with a value of In Edit. This resolution is then submitted for approval. This table stores the approval request details specific to an issue e.g. comments. The remaining information is stored on the approval request table.

Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::IssueApprovalRequest::Entity::IssueApprovalRequest
Controlling File: core\model\Packages\Reference Model\Service Layer\IssueApprovalRequest\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
issueApprovalRequestIDkeynoUnique identifier for the issue approval request record.ISSUE_APPROVAL_REQUEST_ID SVR_INT64
caseIDdetailsnoUnique identifier of the issue that the approval request has been made in respect of.CASE_ID SVR_INT64
approvalRequestIDdetailsnoUnique identifier of the approval request record that stores information about the approval request.APPROVAL_REQUEST_ID SVR_INT64
submitCommentsdetailsyesComments entered by a user when submitting a resolution for approval.COMMENTS SVR_STRING<300>
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: issueApprovalRequestID
This method is used to insert the Issue Approval Request details 
readApprovalRequestHomePagens This method is used to read the Issue Approval Request detailsSQL
modifymodifyOPTIMISTIC_LOCKING: yes
This method is used to modify the Issue Approval Request details 
readIssueAppReqIDAndAppReqIDDetailsnsPRE_DATA_ACCESS: yes
 
This method is used to retrieve the issueApprovalRequestID and associated approvalRequestID for a caseSQL
searchByCaseIDnsmulti Retrieves a list of Issue Approval Requests for an Issue Delivery.SQL
readread Reads the Issue Approval Request details. 
readApprovalRequestIDnsread Reads the approval request id. 
Related Pages (12)