Table Description
Position Reporting Link: The relationship between a child position and a parent position.
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::Core::Reference Model::Service Layer::PositionReportingLink::Entity::PositionReportingLink::PositionReportingLink
Controlling File: core\model\Packages\Reference Model\Service Layer\PositionReportingLink\Entity\PositionReportingLink\PositionReportingLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTno
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
positionRepLinkIDkeynoThe unique identifier of the position reporting link record.POSITION_REPORTING_LINK_ID SVR_INT64
organisationStructureIDdetailsnoThe organization structure of the position reporting link record.ORGANISATION_STRUCTURE_ID SVR_INT64
positionIDdetailsnoThe position id of the position reporting link record.POSITION_ID SVR_INT64
recordStatusdetails The position reporting link record status.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
reportsToIDdetailsnoThe position id of the position this record reports to.POSITION_ID SVR_INT64
Foreign Keys (3)
ChildParent
PositionReportingLink.organisationStructureIDOrganisationStructure.organisationStructureID
PositionReportingLink.positionIDPosition.positionID
PositionReportingLink.reportsToIDPosition.positionID
Indices (4)
Index NameAttributes
PosRepLinkIdx1organisationStructureID, recordStatus
PosRepLinkIdx2organisationStructureID, positionID, recordStatus
PosRepLinkIdx3reportsToID, recordStatus
PosRepLinkIdx4positionID
Operations (16)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: positionRepLinkID
AUTO_ID_KEY: ORGNSTREBO
PRE_DATA_ACCESS: yes
Inserts the position reporting link. 
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Cancels the position reporting link. 
validateDetails  Validates the position reporting link details. 
validateCancelDetails  Validates the position reporting link record before canceling. 
readRecordStatusnsread Reads the record status of position reporting link 
readByOrgStructurePositionAndStatusnsread Read position reporting link by organization structure, position and record status. 
insertCloneinsertAUTO_ID: positionRepLinkID
Clones a position reporting link. 
searchByOrgStructureAndStatusreadmulti Searches position reporting link by organization structure and record status. 
modifyReportsTonsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Modifies the reportsTo position for the position reporting link. 
validateInsertDetails  Validates the position reporting link details before creation. 
countByOrgStructurePositionAndStatusns Returns the number of position reporting link records by organization structure, position and record status.SQL
searchByReportsToPositionAndStatusnsreadmulti Searches position reporting link by reports to position and record status. 
clone  @superseded - replaced by insertClone 
insertPositionReportingLinkinsertPRE_DATA_ACCESS: no
Inserts record to position reporting link entity. This method expects position reporting link ID to be set by the caller, if not set it delegates the call to insert() which is modeled to auto generate primary key field (position reporting link ID). It's preferred to call this method only in scenario's where caller wants to set the value of primary key (position reporting link ID) by itself. 
modifymodify Modify a postion reporting record 
readread Reads&nbsp;a postion reporting record 
Related Pages (11)