Table Description
Provider Status History: The status history of a provider.

The status of a provider throughout the lifecycle of their relationship with the organization.

Example

The status for a provider is set to Open upon creation, and then may be changed to Approved once approved or Rejected once rejected etc.
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::Provider Status History::Entity::ProviderStatusHistory
Controlling File: CPM\model\Packages\Service Layer\Provider\Provider Status History\Entity\Entity_cat.efx
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
providerStatusHistoryIDkeynoThe unique system generated identifier for the provider status history record.INTERNAL_ID SVR_INT64
providerConcernRoleIDdetailsnoThe unique system generated identifier for the provider.CONCERN_ID SVR_INT64
userNamedetailsyesThe user who performed the action.USER_NAME SVR_STRING<64>
reasondetails The reason for the change in provider status. A reason can be added on rejection or suspension of the provider.PROVIDER_STATUS_REASON_HIERARCHYProStatusReasonHrchySVR_STRING<10>
effectiveDateTimedetails The date and time that the provider status is effective from.CURAM_DATETIME SVR_DATETIME
recordStatusdetails The status of a provider. The status will change through the lifecycle of the provider e.g. when registered the status of a provider would be set to open and change to active following approval.PROVIDER_STATUSProviderStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
ProviderStatusHistory.providerConcernRoleIDProvider.providerConcernRoleID
ProviderStatusHistory.userNameUsers.userName
Indices (2)
Index NameAttributes
ProviderStatusHistoryIndex1providerConcernRoleID
IND__1903893564userName
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: providerStatusHistoryID
Creates a new row on ProviderStatusHistory table.  
readread Reads a row of data from ProviderStatusHistory table.  
modifymodify Modifies an existing row on ProviderStatusHistory table. 
removeremove Removes an existing row from ProviderStatusHistory table.  
searchProviderStatusHistoryreadmultiORDER_BY: effectiveDateTime
Returns the list of provider status history for the provider. 
Related Pages (1)