Table Description
Service Plan Approval Request: A request for acceptance of a service plan approval request.

When a service plan is submitted for approval and subsequently approved, a submission and approval baseline is created. An approval request record and a service plan approval request record is also created. The service plan approval request table contains details of the baselines created during the approval process. The approval request table contains the remaining information relating to the approval request e.g. requested by, request date.

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. Plan item Mileage Reimbursement 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. A Childcare Provision plan item is added to the Childcare sub-goal.

The service plan is submitted for approval. An Approval Submission baseline is created and records the Sustainable Employment goal, the Transportation and Childcare sub-goals and the Mileage Reimbursement and Childcare Provision plan items. The identifier of this baseline is stored in the service plan approval request table.
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::ServicePlanApprovalRequest::Entity::SPApprovalRequest
Controlling File: ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\ServicePlanApprovalRequest\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
servicePlanApprovalRequestIDkeynoUnique reference number assigned by the system to a service plan approval request record..SERVICE_PLAN_APPROVAL_REQUEST_ID SVR_INT64
caseIDdetailsnoUnique reference number of the service plan case for which the approval request was created.CASE_ID SVR_INT64
approvalRequestIDdetailsnoUnique reference number of the approval request which was created in association with this service plan approval request.APPROVAL_REQUEST_ID SVR_INT64
submitBaselineIDdetails Unique reference number of the baseline that was created when the approval request was submitted.BASELINE_ID SVR_INT64
approvalBaselineIDdetails Unique reference number of the baseline that was created when the approval request was approved.BASELINE_ID SVR_INT64
Foreign Keys (2)
ChildParent
SPApprovalRequest.approvalRequestIDApprovalRequest.approvalRequestID
SPApprovalRequest.caseIDServicePlanDelivery.caseID
Indices (1)
Index NameAttributes
SPApprReqIdxcaseID, approvalRequestID
Operations (16)
OperationStereotypeOptionsDescriptionSQL
searchApprovalRequestByCaseIDnsmulti Retrieves a list of approval request details based on the case id.SQL
readSubmissionAndApprovalBaselineIDAndNamens Reads all details about the planned item approval request record based on approval request id..SQL
readByCaseIDnsread Reads all details about the planned item approval request record and the related approval request record based on the case id.. 
insertinsertAUTO_ID: servicePlanApprovalRequestID
Inserts a Service Plan Approval Request 
searchByCaseIDnsmulti Selects all service plan approval requests related to a single service planSQL
readread Standard Operation 
searchIDAndVersionNoByCaseIDAndApprovalRequestStatusnsmulti Search for service plan approval request ID and version number by case ID and approval request status.SQL
modifyApprovalBaselineIDnsmodify Modifies approval baseline ID. 
readApprovalRequestIDAndVersionNoByCaseIDAndApprovalRequestStatusns Reads approvalRequestID and versionNo of the approval request record for a service plan delivery with specified approval request status.SQL
readSPApprovalRequestDetailsForModifyns Reads approval request ID, approval request version number, rejection reason, rejection comment and case ID.SQL
readSubmitBaselineDetailsns Reads submission baseline ID and name.SQL
readApproveBaselineDetailsns Reads approval baseline ID and name.SQL
readApprovalRequestStatusns Reads approval request status by service plan approval request key.SQL
modifySubmitApprovalBaselineIDnsmodify Modifies both the submit and approval baseline ID's. 
readSPApprovalRequestIDByCaseIDApprovalRequestIDnsread Reads back the SPApprovalRequestID for a specified caseID & approvalRequestID 
readSPApprovalRequestIDSubmitBaselineIDVersionNoDetailsns Reads servicePlanApprovalRequestID and submitbaselineID from SPApprovalRequest and versionNo from ApprovalRequest based on the specified caseID and status of a service plan.SQL
Related Pages (8)