Table Description
Approval Criteria: Entity used to store configured approval criteria. This entity is focused on the administration of approval criteria within the Service Planning Administration component. An approval criteria can be associated with one or more plan items. Pre-approval criteria define the events that must be completed before a planned item can be approved and post-approval criteria define the events that will occur after the planned item is approved.

Example

A case worker creates a Back to Work service plan for participant Linda Smith as she has recently become unemployed. A Gain Sustainable Employment goal is selected for this service plan. Linda requires assistance with child care, therefore a Childcare sub-goal is added to the service plan. The Childcare Provision planned item is added to the service plan to achieve the service plan sub-goal. The approval criteria that has been configured for the plan item in the Administration component is added to the planned item. The plan item is submitted for approval. Prior to approval of the planned item, the system verifies that the expected cost of the child care service does not exceed a particular amount and the planned item is approved because the pre-approval criteria has been satisfied. The following has been set up in the Administration component to achieve this: An administrator creates a Back to Work service plan. A Gain Sustainable Employment goal is then added. A Childcare sub-goal is linked to the goal, and a Childcare Provision plan item is linked to the Childcare sub-goal. An approval criteria of type pre-approval is created to define the conditions that must be satisfied prior to approval. The approval criteria is associated with the Childcare Provision plan item.
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::Administration::ApprovalCriteria::Entity::ApprovalCriteria
Controlling File: ServicePlans\model\Packages\Service Layer\Administration\ApprovalCriteria\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
workflowEventdetails The event raised when this approval criteria is processed. Used to trigger a workflow or other processing as part of the approval process.PDT_EVENT_CLASS_AND_TYPE SVR_STRING<200>
approvalCriteriaIDkeynoThe unique identifier for approval criteria recordsAPPROVAL_CRITERIA_ID SVR_INT64
criteriaNamedetails The name for the approval criteriaAPPROVAL_CRITERIA_NAME_CODEApprovalCriteriaNameSVR_STRING<10>
occursWhendetails When the approval criteria should occur, pre or post approvalAPPROVAL_CRITERIA_OCCURS_CODEApprovalCriteriaWhenSVR_STRING<10>
prioritydetails The priority value for this approval criteriaAPPROVAL_CRITERIA_PRIORITY SVR_INT32
recordStatusdetails The record status, indicating if this record is active of cancelledRECORD_STATUS_CODERecordStatusSVR_STRING<10>
descriptiondetailsyesFree-form text description for the approval criteriaDESCRIPTION SVR_STRING<300>
dateCreateddetails Date when this record was createdCURAM_DATE SVR_DATE
descriptionTextIDdetailsyesDescription TextID for the approval criteria.LOCALIZABLE_TEXT_ID SVR_INT64
Foreign Keys (2)
ChildParent
ApprovalCriteria.descriptionTextIDLocalizableText.localizableTextID
PlanItemApprovalCriteriaLink.approvalCriteriaIDApprovalCriteria.approvalCriteriaID
Indices (2)
Index NameAttributes
ACNameStatusIndexrecordStatus, criteriaName
IND__1253316089descriptionTextID
Operations (18)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: approvalCriteriaID
AUTO_ID_KEY: SERCPLANBO
PRE_DATA_ACCESS: yes
Insert a new record into the database 
readread Read an existing approval criteria record 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Modify an existing approval criteria record 
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Cancel an existing approval criteria record 
searchByRecordStatusreadmultiORDER_BY: occursWhen, priority
Search for all approval criteria records with a given status 
readAllnkreadmultiORDER_BY: occursWhen, priority
List all of the entries irrespective of record status. Used for the list view page. 
searchPriorityDetailsByOccursWhennsreadmultiORDER_BY: priority
Return records based on when they occur and status. The list returned contains the ID and priority for each entry only. 
modifyPrioritynsmodifyOPTIMISTIC_LOCKING: yes
Modify the priority value alone when these need to be reordered 
countByCriteriaNameAndStatusns This operation returns back a count of approval criteria records that have the same criteriaName as that of the criteriaName passed in. This will help prevent duplicates being created.SQL
validateDuplicates  Method will ensure no approval criteria records will be created which have the same criteriaName. 
validateDetails  Validate details for approval criteria operations 
validateInsert  Validate data for an insert operation 
validateModify  Validate details for a modify operation 
validateCancel  Validate details for cancellation of an existing entry 
insertApprovalCriteriainsert Inserts approval criteria record. This method expects the approvalCriteriaID to be set. It is preferred to call only in scenarios where calling method wants to set the value of primary key by itself.  
modifyDescriptionnsmodify Modifies approval criteria description. 
modifyDescriptionTextIDnsmodify Modifies descriptionTextID. 
modifyApprovalCriteriamodifyOPTIMISTIC_LOCKING: yes
This modify operation will be called while re-applying a change set in the target system. Entity level validations that will happen during a standard modify operation will not be applicable in this case. This modify operation will update all the attributes defined for this entity. 
Related Pages (21)