Table Description
Plan Item Contract Text: A link between a plan item and contract text record.

This entity is focused on the administration of the relationship between plan items and contract text within the Service Planning Administration component.

Example

A case worker creates a Return to Work service plan for participant Linda Smith as she has recently become unemployed. A goal of Sustainable Employment is selected for this service plan. A Find a Job sub-goal is added to the service plan. A Full-time Job Search plan item is added to the service plan as activity for Linda Smith to achieve the service plan goal of Sustainable Employment. An expected outcome of Full-time Employment is selected for the Full time Job Search plan item.

The service plan is approved and a contract is issued. The contract text displayed for the Full-time Job Search plan item is in Spanish as it is the preferred language of the plan participant Linda Smith.

The following has been set up within the Curam Service Planning Administration component to achieve to this:

This link entity enables the sharing of contract text across multiple 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::PlanItem::LinkTables::PlanItemContractText::Entity::PlanItemContractText
Controlling File: ServicePlans\model\Packages\Service Layer\Administration\PlanItem\LinkTables\PlanItemContractText\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
planItemContractTextIDkeynoUnique reference number assigned by the system to a plan item contact text record.PLAN_ITEM_CONTRACT_TEXT_ID SVR_INT64
contractTextIDdetailsnoUnique reference number of the contract text which was created for the associated plan item.CONTRACT_TEXT_ID SVR_INT64
planItemIDdetailsnoUnique reference number of the plan item for which the contract text is being created.PLAN_ITEM_ID SVR_INT64
Foreign Keys (2)
ChildParent
PlanItemContractText.contractTextIDContractText.contractTextID
PlanItemContractText.planItemIDPlanItem.planItemID
Indices (1)
Index NameAttributes
PlanItemIndex1planItemID, contractTextID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: planItemContractTextID
AUTO_ID_KEY: SERCPLANBO
Standard Operation 
readread Standard Operation 
removeremove Standard Operation 
countByPlanItemIDLanguageAndRecordStatusns Used to check if an plan item has a related contract text in a specific language with a particular record status.SQL
removeByPlanItemIDAndContractTextIDnsremove Removes a contract text from a plan item. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a row of data from plan item contract text table. 
searchByPlanItemIDreadmulti Returns all columns of plan item contract text for the given plan item ID. 
insertPlanItemContractTextinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts plan item contract text record. This method expects the planItemContractTextID to be set. It is preferred to call <font color="#000000">insertPlanItemContractText</font> method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
Related Pages (2)