Table Description
Plan Item Approval Request: An relationship between a plan item and an approval request.

When a plan item is submitted for approval, this table provides the link between the plan item and the associated approval request record.

Example

A case worker creates a Return to Work service plan for participant Linda Smith who has recently become unemployed. A goal of Sustainable Employment is selected for this service plan. A Transportation sub-goal is added to the service plan as she is unable to pay for transport to get to work. A Mileage Reimbursement plan item is added to the service plan to achieve the service plan sub-goal.

Linda also needs assistance with paying for childcare and as such a Childcare sub-goal is added to the service plan. Plan item Childcare Provision is added to the Childcare sub-goal.

These plan items are submitted for approval. A record is stored in the plan item approval request table to link the Mileage Reimbursement and Childcare Provision plan item records to the approval request records.
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::ServicePlans::Service Plan Deliveries::ApprovalRequest::PlannedItemApprovalRequest::Entity::PAApprovalRequest
Controlling File: ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\PlannedItemApprovalRequest\Entity\Entity_cat.efx
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
plannedItemApprovalRequestIDkeynoUnique reference number assigned by the system to the planned item approval request record.PLANNED_ITEM_APPROVAL_REQUEST_ID SVR_INT64
plannedItemIDdetailsnoUnique reference number of the planned item record for which the approval request was created.PLANNED_ITEM_ID SVR_INT64
approvalRequestIDdetailsnoUnique reference number of the approval request record which was created for the approval of the planned item.APPROVAL_REQUEST_ID SVR_INT64
Foreign Keys (1)
ChildParent
PAApprovalRequest.approvalRequestIDApprovalRequest.approvalRequestID
Indices (1)
Index NameAttributes
PAApprReqIXplannedItemID, approvalRequestID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: plannedItemApprovalRequestID
Standard Operation 
readread Standard Operation 
readRejectionDetailsForModifyns Reads planned item rejection details for modify.SQL
readApprovalRequestIDAndVersionNoByPlannedItemIDAndApprovalRequestStatusns Reads approvalRequestID and versionNo of the approval request record for a planned item with specified approval request status.SQL
searchApprovalRequestByPlannedItemIDnsmulti Retrieves a list of approval request details based on the planned item ID.SQL
readApprovalRequestStatusns Reads approval request status by planned item approval request key.SQL
Related Pages (11)