Table Description
License Training Requirement: A Training Requirement recorded for a License Type.

Training that is required or recommended to be completed by the provider, in order to be licensed.

Example

A child care provider must have completed Child abuse and neglect prevention, detection, and reporting policies and procedures training in order to be licensed.
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::License::License Training Requirement ::Entity::LicenseTrainingRequirement
Controlling File: CPM\model\Packages\Service Layer\Provider\Licenses\License Training Requirement\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
licenseTrainingRequirementIDkeynoThe unique system generated identifier for the license training requirement record.LICENSE_TRAINING_REQUIREMENT_ID SVR_INT64
trainingIDdetailsnoThe unique system generated identifier for the training recordTRAINING_ID SVR_INT64
licenseTypedetailsnoThe type of the license.LICENSE_TYPELicenseTypeSVR_STRING<10>
completiondetailsnoIndicates whether completion of the training is required in order to get licensed.TRAINING_COMPLETIONTrainingCompletionSVR_STRING<10>
removalReasondetails Reason for removing the training requirement for the license type.TRAINING_REMOVAL_REASONTrainingRemovalReasonSVR_STRING<10>
statusdetailsnoThe status of the training requirement for the license type.SERVICE_TRAINING_STATUSTrainingRequirementStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
LicenseTrainingRequirement.trainingIDTraining.trainingID
Indices (2)
Index NameAttributes
LicenceTrainReqLicenseTypeIdxlicenseType
LicenceTrainReqTrainingIDIdxtrainingID
Operations (10)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: licenseTrainingRequirementID
Creates a new row on LicenseTrainingRequirement table. 
readread Reads an existing record on LicenseTrainingRequirement table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing record on LicenseTrainingRequirement table. 
searchByLicenceTypereadmulti Searches for all the Training Requirement records for a given License Type. 
countTrainingRequirementByTrainingLicenseTypens Gets the count of training requirement for the specified training and license type.SQL
searchByTrainingreadmulti Searches for all the License Training Requirements for a given Training. 
searchByProvidernsmulti Searches for all the trainings that are listed as training requirement of any license types currently held by a provider.SQL
searchByProviderGroupnsmulti Searches for all the trainings that are listed as training requirement of any license types currently held by a provider group.SQL
searchByProviderMembernsmulti Searches for all the trainings that are listed as training requirement of any license types currently held by a provider member.SQL
searchByProviderGroupMembernsmulti Searches for all the trainings that are listed as training requirement of any license types currently held by a provider group member.SQL
Related Pages (14)