Table Description
Provider Location: A record label utilized by the organization or the product provider to uniquely identify the venue where a product is physically provided to a customer.
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::ProviderLocation::ProviderLocation
Controlling File: core\model\Packages\Products\ProviderLocation_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
VALIDATION_EXIT_POINTyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
providerLocationIDkeynoUnique reference number assigned by the system to the location for the Provider.PROVIDER_LOCATION_ID SVR_INT64
namedetails The governing label utilized by the Organization or an external Product Provider to define the venue where a Product is physically provided to a customer.NAME SVR_STRING<131>
startDatedetails Date from which this ProductLocation commenced effectiveness.CURAM_DATE SVR_DATE
endDatedetails Date on which this ProductLocation was no longer effective.CURAM_DATE SVR_DATE
statusCodedetails Code value to denote the status of the Product Location. Codetable is 'ProductLocationStatus'.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
addressIDdetailsnoForeign key to the Address table. This record is the postal address of the Location.ADDRESS_ID SVR_INT64
productProviderIDdetailsnoForeign key to the ProductProvider table. This record is the product location for a product provider.CONCERN_ROLE_ID SVR_INT64
Foreign Keys (5)
ChildParent
ProviderLocation.addressIDAddress.addressID
ProviderLocation.productProviderIDProductProvider.concernRoleID
LocationFacilities.providerLocationIDProviderLocation.providerLocationID
ProductDelivery.providerLocationIDProviderLocation.providerLocationID
ProvisionLocation.providerLocationIDProviderLocation.providerLocationID
Indices (4)
Index NameAttributes
ProvLocNameIndexname
ProductProvIDIndexproductProviderID
IND__1497872904statusCode
IND__290138122addressID
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsert inserts a record 
modifymodifyOPTIMISTIC_LOCKING: yes
modifies a record 
readread reads a record 
searchAllProviderLocationsnsmultiREADMULTI_LIM: 0
 		Returns a list of all ProviderLocations in the system.SQL
readProviderLocationNamensread Returns the name of the provision location identified by the input key 
searchByProductProviderIDnsreadmulti reads all the provider locations for a given product provider id 
searchUnassignedProviderLocationsByProviderIDnsmulti function to read all provider location that have not been assigned to the given product provisionSQL
readByNameAndProvidernsread checks if the locations with the same name for the same provider exist 
searchProviderLocationsByProductProviderIDreadmulti Return&nbsp;a&nbsp;list&nbsp;of&nbsp;ProviderLocation&nbsp;records&nbsp;by given&nbsp;product&nbsp;provider&nbsp;ID. 
insertProviderLocationinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts provider location record. This method expects the providerLocationID to be set. It is preferred to call <font color="#000000">insertProviderLocation</font> method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
readAllnkreadmulti Retrieves a list of all provider locations. 
Related Pages (120)
Sample Benefit Overpayment Evidence (BenefitSampleOverpayment_viewEvidence)
Modify Case Details (CHIPProductDelivery_modifyHeader)
Edit Case (DefaultICProduct_modifyHeader)
Home (ICBenefitUnderPayment_home)
Edit Case (ICProductSample_modifyHeader)
Edit Case (ICSportingGrantSample_modifyHeader)
Benefit Underpayment Home (PDBenefitUnderPayment_home)
New Product (Product_benefitWizardSummary)
New Product (Product_benefitWizardSummary1)
New Product (Product_createProductProvisionForBenefitWizard)
New Product (Product_createProductProvisionForLiabilityWizard)
New Provision Location (Product_createProvisionLocation)
New Product (Product_createProvisionLocationForBenefitWizard)
New Product (Product_createProvisionLocationForLiabilityWizard)
Provider Locations (Product_listProviderLocationPopup)
Provider Locations (Product_listProviderLocations)
Edit Provision Location (Product_modifyProvisionLocationFromList)
Edit Provision Location (Product_modifyProvisionLocationFromView)
New Product (Product_summaryForBenefitWizard)
New Product (Product_summaryForLiabilityWizard)
View Provision Location (Product_viewProvisionLocation)
Edit Case Details (ProductDelivery_modifyHeader)
Edit Case (ProductDelivery_modifyHeader1)
Add Facility (ProductProvider_addFacilityToLocation)
Delete Location (ProductProvider_cancelLocation)
New Location (ProductProvider_createLocation)
Locations (ProductProvider_listLocation)
Edit Location (ProductProvider_modifyLocationFromList)
Edit Location (ProductProvider_modifyLocationFromView)
Remove Facility (ProductProvider_removeFacilityFromLocation)
View Location (ProductProvider_viewLocation)
Activate Contract (ProviderManagement_activateContract)
New Text Translation (ProviderManagement_addDescriptionTranslationToServiceOffering)
New Text Translation (ProviderManagement_addNameTranslationToServiceOffering)
Add Service Authorization Line Item: (ProviderManagement_addSampleServiceAuthorizationLineItem)
New Service (ProviderManagement_addServicesToProviderContract)
Add Services to Contract (ProviderManagement_addServicesToProviderGroupContract)
New Service (ProviderManagement_addServicesToProviderGroupContract_fromView)
Update to Training (ProviderManagement_addTrainingForServiceOffering)
Submit Service Invoice Line Item for Processing (ProviderManagement_allowSILIForProcessingAsDuplicate)
Amend Utilization Contract (ProviderManagement_amendProviderGroupUtilizationContract)
Amend Contract (ProviderManagement_amendUtilizationContract)
Approve Line Item (ProviderManagement_approveLineItemCorrections)
Approve Line Item (ProviderManagement_approvePendingSILI)
Approve Line Item (ProviderManagement_approvePendingSILICorrections)
Approve Line Item (ProviderManagement_approveServiceInvoiceLineItem)
Approve Service Invoice Line Items (ProviderManagement_approveServiceInvoiceLineItems)
Approve Line Item (ProviderManagement_approveSILI)
Approve Service Invoice Line Item as Duplicate (ProviderManagement_approveSILIAsDuplicate)
Approve Line Item (ProviderManagement_approveSILICorrections)
Approve Line Items (ProviderManagement_approveSubmittedSILI)
Approve Line Items (ProviderManagement_confirmApproveServiceInvoiceLineItems)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveResForAnyClient)
Confirm Modify Overlapping Placements (ProviderManagement_confirmModifyOverlappingPlacementPrd)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
New Service (ProviderManagement_createNewServiceOffering)
New Service (ProviderManagement_createNewTrainingServiceOffering)
New Service Rate (ProviderManagement_createProviderGroupUtilizationContractProviderOfferingRate)
New Payment Options (ProviderManagement_createProviderPaymentOption)
New Rate (ProviderManagement_createProviderServiceOfferingRate)
Create Emergency Placement (ProviderManagement_createSampleEmergencyPlacement)
Create Service Authorization Line Items (ProviderManagement_createSampleSAWithSALI)
New Service (ProviderManagement_createServiceOffering)
New Payment Options (ProviderManagement_createServicePaymentOption)
New Service Rate (ProviderManagement_createServiceRate)
New Training Service (ProviderManagement_createTrainingServiceOffering)
New Utilization Contract (ProviderManagement_createUtilizationContractForProvider)
New Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
Edit Payment Option (ProviderManagement_editProviderPaymentOption)
Edit Service (ProviderManagement_editServiceOffering)
Edit Service (ProviderManagement_editServiceOfferingFrmView)
Edit Payment Options (ProviderManagement_editServicePaymentOption)
Edit Service Rate (ProviderManagement_editServiceRate)
Edit Training Service (ProviderManagement_editTrainingServiceOffering)
Edit Training Service (ProviderManagement_editTrainingServiceOfferingFrmView)
Edit Text Translation (ProviderManagement_modifyLocalizableSODescriptionTextTranslation)
Edit Text Translation (ProviderManagement_modifyLocalizableSONameTextTranslation)
Confirm Placement (ProviderManagement_modifyPlaceDuringConfirmation)
Edit Placement (ProviderManagement_modifyPlacementDetails)
Modify Placement Information (ProviderManagement_modifyPlacementInformation)
Confirm Cancel Reservation (ProviderManagement_modifyPlacementInformationConfirmCancelReservation)
Allocate Place (ProviderManagement_modifyPlaceProviderOfferingAllocate)
Edit Service Rate (ProviderManagement_modifyProviderGroupUtilizationContractProviderOfferingRate)
Edit Rate (ProviderManagement_modifyProviderServiceOfferingRate)
Confirm Placement: (ProviderManagement_modifySamplePlaceDuringConfirmation)
Modify Service Authorization Line Item: (ProviderManagement_modifySampleServiceAuthorizationLineItem)
Edit Delivery Configuration (ProviderManagement_modifySecurityRightsAndServiceDeliveryConfiguration)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Edit Rate (ProviderManagement_modifyUtilizationContractProviderOfferingRate)
Place Client (ProviderManagement_placeSampleClient)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Submit Line Item (ProviderManagement_submitOpenSILIForProcessing)
Submit Line Item (ProviderManagement_submitServiceInvoiceLineItemForProcessing)
Submit Line Items (ProviderManagement_submitServiceInvoiceLineItems)
Submit Line Item (ProviderManagement_submitSILI)
Submit Service Invoice Line Item for Processing (ProviderManagement_submitSILIForProcessingFromTask)
Submit Service Invoice (ProviderManagement_submittServiceInvoiceForProcessing)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Add Plan Item (ServicePlanDelivery_addCustomServicePlanItem)
Add Plan Item (ServicePlanDelivery_addServicePlanItem)
Edit Plan Item (ServicePlanDelivery_modifyCustomPlanItem)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyPlanItem_NameEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanBasicPlanItem)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyServiceUnitPlanItem)
Modify Case Details (TBBCCProductDelivery_modifyHeader)
New Product (Wizard_benefitSummary)
New Product (Wizard_liabilitySummary)
Provider Locations (Wizard_listProviderLocationPopup)
New Product (Wizard_productProvisionForBenefit)
New Product (Wizard_productProvisionForLiability)
New Product (Wizard_provisionLocationForBenefit)
New Product (Wizard_provisionLocationForLiability)