Table Description
Provision Location: A product provided at a location.

It implements the facts that a Product can be provided at many Locations and a Location can provide many Products (many-to-many relationship).
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::ProvisionLocation::ProvisionLocation
Controlling File: core\model\Packages\Products\ProvisionLocation_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
provisionLocationIDkeynoUnique reference number assigned by the systemPRODUCT_PROVISION_LOCATION_ID SVR_INT64
providerLocationIDdetailsnoUnique reference number assigned by the system to the location for the Product.PROVIDER_LOCATION_ID SVR_INT64
productProvisionIDdetailsnoUnique reference number to a product provision record.PRODUCT_PROVISION_ID SVR_INT64
startDatedetails Start date of the product being offered by a product provider at a location.CURAM_DATE SVR_DATE
endDatedetails End date of a product being offered by a product provider at a location.CURAM_DATE SVR_DATE
creationDatedetails Creation date of a product being offered by a product provider at a location.CURAM_DATE SVR_DATE
statusCodedetails Product Location Link status.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Product Location Link comments.COMMENTS SVR_STRING<300>
estimateCostdetails The estimated cost of a product being offered by a product provider at a location.CURAM_AMOUNT SVR_MONEY
Foreign Keys (2)
ChildParent
ProvisionLocation.productProvisionIDProductProvision.productProvisionID
ProvisionLocation.providerLocationIDProviderLocation.providerLocationID
Indices (2)
Index NameAttributes
ProvLocationIndproductProvisionID, providerLocationID, statusCode
ProvLocationIndex1providerLocationID
Operations (14)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchProvisionLocationByProvisionIDnsmulti @deprecated by searchProvisionLocationByProvisionID1. @deprecated-since V6.0. Reads a summary list of Provision Location details for ProvisionID.SQL
readByProviderIDAndLocationIDnsread Reads a Product Provision Location by Product Provider ID and Provision Location ID. 
removeByProductProvisionIDnsremove removes the provision location for a given product provision 
searchProvisionLocationByProviderIDnsmultiREADMULTI_LIM: 100
 		This method will return all provision locations associated with a particular provider location.SQL
readEstimatedCostByProviderIDAndLocationIDnsread Retrieves the estimated cost for a provision location. 
searchByProviderLocationIDreadmulti Return a list of ProvisionLocation records by given provider location ID. 
insertProvisionLocationinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts provision location record. This method expects the provisionLocationID to be set. It is preferred to call insertProvisionLocation method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
searchProvisionLocationByProvisionID1nsmulti Reads a summary list of Provision Location details for ProvisionIDSQL
modifyProvisionLocationmodifyOPTIMISTIC_LOCKING: yes
This modify operation will be called while re-applying a change set in the target system. Entity level validations that will happen during a standard modify operation will not be applicable in this case. This modify operation will update all the attributes defined for this entity. 
searchByProductProvisionIDreadmulti Return a list of provision location records by given product provision ID. 
Related Pages (21)