Table Description
Location Facility: A facility offered at a provision location.
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::Products::Entity Objects::LocationFacilities::LocationFacilities
Controlling File: core\model\Packages\Products\LocationFacilities_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
locationFacilitiesIDkeynoUnique reference number assigned by the systemINTERNAL_ID SVR_INT64
providerLocationIDdetailsnoUnique reference number assigned by the system to a ProductLocation.PROVIDER_LOCATION_ID SVR_INT64
typeCodedetails Code value to indicate a type of facility offered at a ProductLocation. Codetable name is 'LocationFacilitiesType'LOCATION_FACILITIES_TYPE_CODELocationFacilitiesTypeSVR_STRING<10>
Foreign Keys (1)
ChildParent
LocationFacilities.providerLocationIDProviderLocation.providerLocationID
Indices (1)
Index NameAttributes
RLFacilityIdxproviderLocationID, typeCode
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
searchAllLocationFacilitiesnsmultiREADMULTI_LIM: 0
 		Returns a list of all LocationFacility codes in the codetable.SQL
searchByLocationnsreadmultiPRE_DATA_ACCESS: yes
READMULTI_LIM: 0
Reads all facilities that are provided at the specified location. 
searchAllFacilitiesNotForLocationnsmultiPRE_DATA_ACCESS: yes
READMULTI_LIM: 0
 		Reads all facilities that are NOT provided at the specified location.SQL
removeLocationnsremove Removes all records containing the specified ProductLocation. 
removeLocationFacilitynsremove Removes a location facility. 
searchUnAllocatedFacilitiesByLocalensmulti Reads all facilities that are NOT provided at the specified location based on the locale.SQL
Related Pages (6)