Database Table: PositionLocationLink
Position Location Link:
The relationship between a position and a location.
|
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
|
|
Location in Model: | Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::PositionLocationLink::Entity::PositionLocationLink::PositionLocationLink |
Controlling File: | core\model\Packages\Reference Model\Service Layer\PositionLocationLink\Entity\PositionLocationLink_cat.efx |
ALLOW_OPTIMISTIC_LOCKING | yes |
Attribute | Stereotype | Nullable | Description | Domain Definition | Codetable | DDL Type |
positionLocationLinkID | key | no | Unique reference number assigned by the system to the position location link record. | POSITIONLOCATIONLINK_ID | | SVR_INT64 |
positionID | details | no | Unique reference number of the position record which is associated with the location. This is the foreign key to the position record. | POSITION_ID | | SVR_INT64 |
locationID | details | no | Unique reference number of the location record which is associated with the position. This is the foreign key to the location record. | LOCATION_ID | | SVR_INT64 |
|
Index Name | Attributes |
PosLocationIdx | locationID, positionID |
|
Operation | Stereotype | Options | Description | SQL |
insert | insert | AUTO_ID: positionLocationLinkID
AUTO_ID_KEY: ORGNSTREBO
PRE_DATA_ACCESS: yes
| Standard Operation | |
read | read | | Standard Operation | |
modify | modify | | Standard Operation | |
remove | remove | | Standard Operation | |
readmulti | readmulti | | @deprecated-since V6.0 SP2
This method is deprecated as this is taking primary key as the input which returns a single record and hence is not relevant for readmulti
operation. Instead, the methods searchByLocationID() and searchByPositionID() may be used to work on this entity. | |
countLocationAssignedToPosition | ns | | check if location is already assigned to position | SQL |
insertPositionLocationLink | insert | PRE_DATA_ACCESS: no
| Inserts record to position location link entity. This method expects position location 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 location link ID).
It's preferred to call this method only in scenario's where caller wants to set the value of primary key (position location
link ID) by itself. | |
searchByPositionID | readmulti | | <p>
Reads all the records for a postion ID.
</p> | |
searchByLocationID | readmulti | | Reads all the records of Position Location Link for a location ID. | |
|