Table Description
Service Center Provider Offering: The period during which a provider service center may deliver a provider offering to the organizations clients.

The period during which a provider service center may deliver a provider offering to the organizations clients.

Example

Carry's family clinic may deliver pediatric services from its East Zone Office from 01/01/2007 onwards to the organizations clients.
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::CPM::Service Layer::Provider Service::Service Center Provider Offering::Entity::ServiceCenterProviderOffering
Controlling File: CPM\model\Packages\Service Layer\Provider Service\Service Center Provider Offering\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
servCenterProviderOfferingIDkeynoThe unique system generated identifier for the Service Center Provider Offering record.INTERNAL_ID SVR_INT64
providerServiceCenterIDdetailsnoThe unique system generated identifier for the provider service center record.INTERNAL_ID SVR_INT64
providerOfferingIDdetailsnoThe unique system generated identifier for the provider offering record.INTERNAL_ID SVR_INT64
startDatedetails The date from which the service center may deliver the provider offering.CURAM_DATE SVR_DATE
endDatedetails The last date on which the service center delivers the provider offering.CURAM_DATE SVR_DATE
recordStatusdetails The status is used to indicate if the service center provider offering has been logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Comments recorded by the user relating to service center provider offering.COMMENTS SVR_STRING<300>
Foreign Keys (2)
ChildParent
ServiceCenterProviderOffering.providerOfferingIDProviderOffering.providerOfferingID
ServiceCenterProviderOffering.providerServiceCenterIDProviderServiceCenter.providerServiceCenterID
Indices (2)
Index NameAttributes
ServiceCenterPOIndex1providerOfferingID
ServiceCenterPOIndex2providerServiceCenterID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: servCenterProviderOfferingID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchByreadmulti Lists service center provider offerings for the service center. 
searchByProviderOfferingreadmulti Lists service center provider offerings for a provider offering. 
Related Pages (19)