Table Description
Provider Background Check: Background checks undertaken on employees or household members of a provider.

Background checks undertaken on employees or household members of a provider.

Example

An SEM agency may wish to conduct both a Criminal Investigation check and a Child Protective Service check on all employees of each of their Day Care Centers. The actual background check may be conducted by the agency itself (e.g. in the case of a Child Protective Service check) or may be conducted by an outside body.
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 Background Check::Entity::ProviderBackgroundCheck
Controlling File: CPM\model\Packages\Service Layer\Provider\Provider Background Check\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
providerBackgroundCheckIDkeynoThe unique system generated identifier for the background check record.INTERNAL_ID SVR_INT64
providerPartyIDdetailsnoThe unique system generated identifier for the provider party record.INTERNAL_ID SVR_INT64
typedetails The type of background check being conducted, e.g. Criminal Investigation.BACKGROUND_CHECK_TYPEBackgroundCheckTypeSVR_STRING<10>
resultdetails The result of the background check.BACKGROUND_CHECK_RESULTBackgroundCheckResultSVR_STRING<10>
requestDatedetails The date on which a request for a background check was initiated.CURAM_DATE SVR_DATE
receiptDatedetails The date on which the result of a background check is received by the agency.CURAM_DATE SVR_DATE
commentsdetails Comments recorded by a user relating to the background check.COMMENTS SVR_STRING<300>
recordStatusdetails The status is used to indicate if the background check has been logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
providerConcernRoleIDdetailsyesThe unique system generated identifier for the provider concern role record.CONCERN_ID SVR_INT64
expiryDatedetails Date of expiry of the provider participant background check.CURAM_DATE SVR_DATE
Foreign Keys (2)
ChildParent
ProviderBackgroundCheck.providerPartyIDProviderParty.providerPartyID
BackgroundCheckFailureReason.providerBackgroundCheckIDProviderBackgroundCheck.providerBackgroundCheckID
Indices (2)
Index NameAttributes
ProviderBackgroundCheckIndex1providerPartyID
ProvBGChkProvdrCncrnRoleIDIdxproviderConcernRoleID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: providerBackgroundCheckID
Creates a new row on ProviderBackgroundCheck table. 
readread Reads a row of data from ProviderBackgroundCheck table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on ProviderBackgroundCheck table. 
removeremove Removes an existing row from ProviderBackgroundCheck table. 
searchByreadmulti Searches for the ProviderBackgroundCheck records associated with the provider. 
searchByProviderMemberreadmulti Searches for the active backgroundCheck records associated with the provider member. 
Related Pages (9)