Table Description
Plan Item Approval Check: Entity for storing the user plan item approval check details. Service planned item approval checks can be configured at the user level.

Example

The following service plan group approval check can be created: 10% of Childcare Provision planned items where the estimated cost exceeds $500 submitted for approval require manual approval by the supervisor of the user that submitted the planned item. The remaining 90% of planned items will be automatically approved by the system. Currently no Service Planning related processing makes use of this type of approval check.
Model Details
Location in Model: Logical View::MetaModel::Curam::ServicePlans::Administration::PlanItemApprovalCheck::Entity::PlanItemApprovalCheck
Controlling File: ServicePlans\model\Packages\Service Layer\Administration\PlanItemApprovalCheck\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
appliesToAllInddetails States if approval check applies to all plan item types.CURAM_INDICATOR SVR_BOOLEAN
descriptiondetails Description details for the Plan Item Approval Check.DESCRIPTION SVR_STRING<300>
estimatedCostdetails Plan Items costing over this amount must be manually approved.APPROVAL_CHECK_ESTIMATED_COST SVR_MONEY
organisationUnitIDdetails Reference of the organization unit for which this approval check has been created for. ORGANISATION_UNIT_ID SVR_INT64
percentagedetails Percentage of plan items that must be manually approved.APPROVAL_CHECK_PERCENTAGE SVR_INT16
planItemApprovalCheckIDkeynoPrimary key of entity. Unique reference number assigned by the system to a Plan Item approval check record PLAN_ITEM_APPROVAL_CHECK_ID SVR_INT64
statusCodedetails  Status of the plan item approval check record. The values are Active or Canceled. Logical deletion is supported. RECORD_STATUS_CODERecordStatusSVR_STRING<10>
typeCodedetails Type of approval check, plan item approval check or user approval check. PLAN_ITEM_APPROVAL_CHECK_TYPE_CODEPlanItemApprovalCheckSVR_STRING<10>
userNamedetails Reference of the user for which this approval check has been created for.USER_NAME SVR_STRING<64>
planItemIDdetails Reference of plan item that the check has been created for.PLAN_ITEM_ID SVR_INT64
dateCreateddetails Date on which the Plan Item approval check is created.CURAM_DATE SVR_DATE
Operations (14)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: planItemApprovalCheckID
PRE_DATA_ACCESS: yes
Method to insert the Plan Item Approval Check details 
readWithPITypens Method to read the Plan Item Approval Check details and Plan Item Type details for the PIApprovalCheck id that is given as input.SQL
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Method to modify the Plan Item Approval Check details 
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Method to cancel the Plan Item Approval Check details. 
searchWithPITypeByUsernamensmulti Method to get the list if the Plan Item Approval Check details and the PI type details for the user name that is passed as input.SQL
validateCancel  Method to validate the details for cancel. 
validateDetails  Ensures common validations are done before inserting and modifying data 
validateInsert  Ensures validations are performed before the data modification 
validateModify  Ensures validations are done before data modification 
countByUsernamens Count existing entries that match for estimatedCost, planItemID, statusCode, and userName. Essentially look for duplicate entriesSQL
countByUsernameAllTypesns Count all entries that match userName, estimatedCost, statusCode and a null planItemID.SQL
countByUsernameForModifyns Count entries that match this one based on userName, estimatedCost, statusCode, planItemID and which do not match the provided unique ID. Essentially this is checking for duplicates of an entry that is about to be modified.SQL
countByUsernameAllTypesForModifyns Count entries that match this one based on userName, estimatedCost, statusCode, have a null plan item ID, and which do not match the provided unique ID. Essentially this is checking for duplicates of an entry that is about to be modified.SQL
readStatusnsread Return the status details for a given entry 
Related Pages (5)