Table Description
Planned Item Absence Link: A relationship between a planned item and an absence period.

This entity stores the association between planned items and absence periods within Service Plan Delivery client participation.

Example

For example, a child was scheduled to receive 80 units of Child Care between 01/05/2008-08/05/2008 but he/she received 60 units of it and 20 units remained unattended due to various absence reasons. When these absence details are recorded a link record is also created storing the association between the planned item that the client is participating in and the absence period record.

Model Details
Location in Model: Logical View::MetaModel::Curam::ServicePlans::Service Plan Deliveries::Absence::Entity::PlannedItemAbsenceLink
Controlling File: ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\Absence\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
plannedItemAbsenceLinkIDkeynoUnique reference number assigned by the system to the record that captures the association between a a planned item and an absence period record.PLANNED_ITEM_ABSENCE_LINK_ID SVR_INT64
plannedItemIDdetailsnoUnique reference number of the planned item record against which the absence period was recorded.PLANNED_ITEM_ID SVR_INT64
absencePeriodIDdetailsnoUnique reference number of the absence period with which the planned item has been associated.ABSENCEPERIOD_ID SVR_INT64
recordStatusdetails Code value to denote the status of the absence details. The values are 'Active' or 'Canceled'.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Indices (1)
Index NameAttributes
IND__620112326absencePeriodID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
readread Standard Operation 
insertinsertAUTO_ID: plannedItemAbsenceLinkID
Standard Operation 
searchAbsenceByPlannedItemIDnsmulti Retrieves a list of absence records for the specified planned item.SQL
modifyStatusnsmodify Method to update the status of a PlannedItemAbsenceLink record. 
readVersionNonsread Returns the version number for a PlannedItemAbsenceLink record. 
searchByAbsencePeriodIDreadmulti Searches the PlannedItemAbsenceLink table using the absence period id. 
removeAbsenceByRosterLineItemID  Deletes all absence link records based on the roster line item id. 
searchAbsenceByServicePlanDeliveryIDnsmulti Searches the PlannedItemAbsenceLink table using the service plan delivery id.SQL
removeremove Standard Operation 
Related Pages (9)