D:PlannedItemLink

Database Table: PlannedItemLink

Table Description

Planned Item Link: The Planned Item Link entity allows other constructs link to a Planned Item, e.g. a Referral.

Model Details

Location in Model:	Logical View::MetaModel::Curam::ServicePlans::Service Plan Deliveries::PlannedItem::Entity::PlannedItemLink
Controlling File:	ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\PlannedItem\Entity\Entity_cat.efx

Attributes (5)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
plannedItemLinkID	key	no	Unique reference number of a Planned Item Link record.	INTERNAL_ID		SVR_INT64
plannedItemID	details		Unique reference number of a Planned Item record.	PLANNED_ITEM_ID		SVR_INT64
relatedID	details		Unique reference number of the record being linked to the Planned Item.	INTERNAL_ID		SVR_INT64
relatedType	details		Identifies the construct being related to the Planned Item, e.g. a Referral.	PLANNED_ITEM_RELATED_TYPE	PlannedItemRelatedType	SVR_STRING<10>
comments	details		Comments provided for the Planned Item link.	COMMENTS		SVR_STRING<300>

Indices (2)

Index Name	Attributes
plannedItemLinkRelIDTypeIdx	relatedID, relatedType
PlItLnkPlItIDIdx	plannedItemID

Operations (6)

Operation	Stereotype	Options	Description	SQL
insert	insert	AUTO_ID: plannedItemLinkID POST_DATA_ACCESS: yes PRE_DATA_ACCESS: yes	Method to create Planned Item Link Details
read	read	POST_DATA_ACCESS: yes PRE_DATA_ACCESS: yes	Method to read Planned Item Link Details
modify	modify	POST_DATA_ACCESS: yes PRE_DATA_ACCESS: yes	Method to modify Planned Item Link Details
remove	remove	POST_DATA_ACCESS: yes PRE_DATA_ACCESS: yes	Method to remove Planned Item Link Details
searchByRelatedIDAndType	readmulti	POST_DATA_ACCESS: yes PRE_DATA_ACCESS: yes	Method to search Planned Item Link Details by related id and type
searchByPlannedItem	nsreadmulti	POST_DATA_ACCESS: yes PRE_DATA_ACCESS: yes	Method to search Planned Item Link Details by planned item id

Related Pages (0)