Table Description
Planned Item Task Configuration: This entity holds the task details associated to a planned item of type task. This is the link entity between a planned item and a task configuration.

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 a job search, therefore a Find a Job sub-goal is added to the service plan. The Full-time Job Search plan item is added to the service plan to achieve the service plan sub-goal. The plan item is submitted for approval. On approval by a supervisor, a task is created and allocated to the owner of the planned item to assist Linda Smith with her job search. This link entity holds the task details associated to the planned 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::Service Plan Deliveries::PlannedItem::Entity::PlannedItemTaskConfiguration
Controlling File: ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\PlannedItem\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
plannedItemTaskConfigurationIDkeynoPlanned Item Task Configuration Id. Primary key of the entity. INTERNAL_ID SVR_INT64
plannedItemIDdetailsnoPlanned Item Id.INTERNAL_ID SVR_INT64
subjectdetails Subject of the task to be created.SUBJECT SVR_STRING<80>
reserveToPlannedItemOwnerdetails Indicator to determine if task is created for the planned item owner.CURAM_INDICATOR SVR_BOOLEAN
assignToIDdetails ID of the 'assign to' selected component (i.e. job, position, user, etc).TASK_ASSIGNEE_ID_STRING SVR_STRING<64>
assignToTypedetails Type of the 'assign to' selected component (i.e. job, position, user, etc).ALLOCATION_TARGET_ITEM_TYPETargetItemTypeSVR_STRING<10>
actionLinkdetails Code will be used to identify what URL link of the task action is requiredTASK_CONFIG_ACTION_LINKTaskConfigActionLinkSVR_STRING<10>
actionTextdetails Text that will be used as the URL text of the action associated to a task.TASK_ACTION_TEXT SVR_STRING<200>
prioritydetails Priority to be assigned to the task when created.TASK_PRIORITY_CODETaskPrioritySVR_STRING<10>
statusdetails Status of the planned item task record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
taskSentInddetails Indicator to hold the details if the task has been create already on the planned item.Values True if Task has been create for the planned item, FALSE if Task has not been created on the planned item. By default the value will be FALSE.CURAM_INDICATOR SVR_BOOLEAN
commentsdetails Comments for the planned item task configuration recordCOMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
PlannedItemTaskConfiguration.plannedItemIDPlannedItem.plannedItemID
Indices (1)
Index NameAttributes
plannedItemIDIdx2plannedItemID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: plannedItemTaskConfigurationID
Insert method for planned item task configuration. 
readPlannedItemTaskByPlannedItemIDnsread Method to read a single record from the table using the planned item id passed in. 
removePlannedItemTaskConfigurationnsremove Method to perform soft delete of the task configuration for planned item when the planned item is deleted. 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
Related Pages (12)