Table Description
Location Holiday Link: The relationship between a location and a holiday.
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::Organisation::Entity Objects::LocationHolidayLink::LocationHolidayLink
Controlling File: core\model\Packages\Organisation\LocationHolidayLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
locationHolidayLinkIDkeynoUnique reference number assigned by the system to the location holiday link record.LOCATION_HOLIDAY_LINK_ID SVR_INT64
locationIDdetailsnoUnique reference number of the location record which is associated with the location holiday. This is the foreign key to the location record.LOCATION_ID SVR_INT64
locationHolidayIDdetailsnoUnique reference number of the location holiday record which is associated with the location. This is the foreign key to the location holiday record.LOCATION_HOLIDAY_ID SVR_INT64
Foreign Keys (2)
ChildParent
LocationHolidayLink.locationHolidayIDLocationHoliday.locationHolidayID
LocationHolidayLink.locationIDLocation.locationID
Indices (1)
Index NameAttributes
LocHolidayIdxlocationID, locationHolidayID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: locationHolidayLinkID
AUTO_ID_KEY: LOCNSTREBO
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
readLocationHolidayLinkIDnsread Reads Location HolidayLinkID for a given LocationID and LocationHolidayID. 
removeremove Standard Operation 
readLocationsAttachedToHolidaynsmulti  SQL
searchByLocationIDreadmulti Reads all the records for a location holiday link id. 
insertLocationHolidayLinkinsert Inserts&nbsp;record&nbsp;to&nbsp;location&nbsp;holiday&nbsp;link&nbsp;entity.&nbsp;This&nbsp;method&nbsp;expects&nbsp;location&nbsp;holiday&nbsp;link&nbsp;ID&nbsp;to&nbsp;be&nbsp;set&nbsp;by&nbsp;the&nbsp;caller.<br /> It's&nbsp;preferred&nbsp;to&nbsp;call&nbsp;this&nbsp;method&nbsp;only&nbsp;in&nbsp;scenario's&nbsp;where&nbsp;caller&nbsp;wants&nbsp;to&nbsp;set&nbsp;the&nbsp;value&nbsp;of&nbsp;primary&nbsp;key&nbsp;(location&nbsp;holiday<br /> link&nbsp;ID)&nbsp;by&nbsp;itself. 
Related Pages (8)