Table Description
Training: Configuration details for a training program that an organization can record participation against.

Details of a training course that can be provided to potential provider on behalf of the organization

Example

For example, the organization creates a training course called Communicating Effectively in the Workplace, in order to be able to track which Providers have completed that training.

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::Training::Training::Entity::Training
Controlling File: CPM\model\Packages\Service Layer\Training\Training\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
trainingIDkeynoThe unique system generated reference number for the training record.TRAINING_ID SVR_INT64
trainingNamedetails The name of the training, e.g. Condition ManagementTRAINING_NAME SVR_STRING<50>
trainingTypedetails The type of training, e.g. training for education or employment.TRAINING_TYPETrainingTypeSVR_STRING<10>
startDatedetails The date from which the training can be used by the agency.CURAM_DATE SVR_DATE
endDatedetails The date to which the training can be used by the agency.CURAM_DATE SVR_DATE
recordStatusdetails The status is used to indicate if the training is Active or logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
trainingNameUpperdetails The upper case version of the training name.TRAINING_NAME SVR_STRING<50>
Foreign Keys (5)
ChildParent
LicenseTrainingRequirement.trainingIDTraining.trainingID
SOTrainingRequirement.trainingIDTraining.trainingID
TrainingCredit.trainingIDTraining.trainingID
TrainingProgram.trainingIDTraining.trainingID
TrainingServiceOffering.trainingIDTraining.trainingID
Indices (1)
Index NameAttributes
TrainingTrainingNameUpperIdxtrainingNameUpper
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: trainingID
AUTO_ID_KEY: TRAIN
Creates a new record on Training table. 
readread Reads an existing record on Training table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing record on training table. 
searchByreadmultiORDER_BY: trainingName
WHERE: ( :searchByName = '0' OR Training.trainingNameUpper like :trainingName ) AND ( :searchByType = '0' OR Training.trainingType = :trainingType ) AND Training.recordStatus = :recordStatus
Searches for the records in Training table matching the search criteria entered . 
readAllnkreadmultiORDER_BY: trainingName
Retrieves all the records from the Training table. 
searchByNamereadmulti Searches for the records in Training table matching the training name. 
insertTrainingnsinsert Inserts record to Training entity. This method expects Training ID to be set by the caller, if not set it delegates the call to insert() which is modeled to auto generate primary key field Training ID). It's preferred to call insertTraining only in scenario's where caller wants to set the value of primary key by itself. 
Related Pages (91)
Update to Training (ProviderManagement_addTrainingForServiceOffering)
Delete Training (ProviderManagement_cancelTraining)
New Service (ProviderManagement_createNewTrainingServiceOffering)
New Training (ProviderManagement_createTraining)
New Training Credit (ProviderManagement_createTrainingCredit)
New Training Requirement (ProviderManagement_createTrainingRequirementForLicenseType)
New Training Requirement (ProviderManagement_createTrainingRequirementForServiceOffering)
New Training Service (ProviderManagement_createTrainingServiceOffering)
Edit Training (ProviderManagement_editCompletedTrainingProgramForProviderGroupMember)
Edit Training (ProviderManagement_editTrainingProgramForProviderGroupMember)
Edit Training Requirement (ProviderManagement_editTrainingRequirementForServiceOffering)
Edit Training Service (ProviderManagement_editTrainingServiceOffering)
Edit Training Service (ProviderManagement_editTrainingServiceOfferingFrmView)
Training Details (ProviderManagement_enterPersonTrainingDetails)
Training Details (ProviderManagement_enterProviderGroupMemberTrainingDetails)
Training Details (ProviderManagement_enterProviderGroupMemberTrainingDetailsBasedOnTrainingRequirement)
Training Details (ProviderManagement_enterProviderGroupTrainingDetails)
Training Details (ProviderManagement_enterProviderMemberTrainingDetails)
Training Details (ProviderManagement_enterProviderMemberTrainingDetailsBasedOnTrainingRequirement)
Training Details (ProviderManagement_enterProviderMemberTrainingProgramDetails)
Training Details (ProviderManagement_enterProviderTrainingDetails)
ProviderManagement_listTraining
ProviderManagement_listTrainingProgramForPerson
Training (ProviderManagement_listTrainingProgramForProvider)
Training (ProviderManagement_listTrainingProgramForProviderForFacilityManager)
Training (ProviderManagement_listTrainingProgramForProviderGroup)
Training (ProviderManagement_listTrainingProgramForProviderGroupMember)
Training: (ProviderManagement_listTrainingProgramForProviderMember)
Training: (ProviderManagement_listTrainingProgramInfoForProviderGroupMember)
Training (ProviderManagement_listTrainingProgramInfoForProviderMember)
Training Requirements for License Type: (ProviderManagement_listTrainingRequirementForLicenseType)
Training Requirements (ProviderManagement_listTrainingRequirementsForServiceOffering)
Edit Training Credit (ProviderManagement_modifyTrainingCredit)
Edit Training (ProviderManagement_modifyTrainingFrmList)
Edit Training (ProviderManagement_modifyTrainingFrmView)
Edit Training (ProviderManagement_modifyTrainingProgramForProvider)
Edit Training (ProviderManagement_modifyTrainingProgramForProviderGroup)
Edit Training Requirement (ProviderManagement_modifyTrainingRequirementForLicenseType)
Remove Training Requirement (ProviderManagement_removeTrainingRequirementForLicenseType)
Remove Training Requirement (ProviderManagement_removeTrainingRequirementFromServiceOffering)
Search By Training Name (ProviderManagement_searchByTrainingNameUnitMeasureForProvider)
Search By Training Name (ProviderManagement_searchByTrainingNameUnitMeasureForProviderGroup)
Search By Training Results (ProviderManagement_searchByTrainingNameUnitMeasureResultsForProviderGroup)
Search By Training Type (ProviderManagement_searchByTrainingTypeForProvider)
Search By Training Type (ProviderManagement_searchByTrainingTypeForProviderGroup)
Search By Training Type Results (ProviderManagement_searchByTrainingTypeResultsForProviderGroup)
Search By Training Name (ProviderManagement_searchTrainingByTrainingNameUnitMeasureForPerson)
Search By Training Name (ProviderManagement_searchTrainingByTrainingNameUnitMeasureForProviderGroupMember)
Search By Training Name (ProviderManagement_searchTrainingByTrainingNameUnitMeasureForProviderMember)
Search By Training Type (ProviderManagement_searchTrainingByTrainingTypeForPerson)
Search By Training Type (ProviderManagement_searchTrainingByTrainingTypeForProviderGroupMember)
Search By Training Type (ProviderManagement_searchTrainingByTrainingTypeForProviderMember)
Training Search (ProviderManagement_searchTrainingPopup)
Select From Training Requirements (ProviderManagement_selectTrainingForProvider)
Select From Training Requirements (ProviderManagement_selectTrainingForProviderGroup)
Edit Training (ProviderManagement_updateCompletedTrainingForProvider)
Edit Training (ProviderManagement_updateCompletedTrainingForProviderGroup)
Update Completed Training For Provider Group Member: (ProviderManagement_updateCompletedTrainingProgramDetailsForProviderGroupMember)
Edit Training (ProviderManagement_updateCompletedTrainingProgramDetailsForProviderMember)
Edit Training Program (ProviderManagement_updateCompletedTrainingProgramForPerson)
Edit Training (ProviderManagement_updateCompletedTrainingProgramForProviderGroupMember)
Edit Training (ProviderManagement_updateCompletedTrainingProgramForProviderMember)
Edit Training (ProviderManagement_updateMemberTrainingProgramForProvider)
Edit Training (ProviderManagement_updateMemberTrainingProgramForProviderGroup)
Update Training For Provider Group Member (ProviderManagement_updateTrainingProgramDetailsForProviderGroupMember)
Edit Training (ProviderManagement_updateTrainingProgramDetailsForProviderMember)
Edit Training Program (ProviderManagement_updateTrainingProgramForPerson)
Edit Training (ProviderManagement_updateTrainingProgramForProviderGroupMember)
Edit Training (ProviderManagement_updateTrainingProgramForProviderMember)
View Completed Training for Unassigned Provider Member: (ProviderManagement_viewCompletedPersonTraining)
View Completed Training For Provider Group Member: (ProviderManagement_viewCompletedProviderGroupMemberTraining)
View Completed Training For Provider Group Member: (ProviderManagement_viewCompletedProviderGroupMemberTrainingDetails)
View Completed Training For Provider Group: (ProviderManagement_viewCompletedProviderGroupTraining)
View Completed Training For Provider Member: (ProviderManagement_viewCompletedProviderMemberTraining)
View Completed Training For Provider Member: (ProviderManagement_viewCompletedProviderMemberTrainingDetails)
View Completed Training For Provider: (ProviderManagement_viewCompletedProviderTraining)
ProviderManagement_viewCompletedProviderTrainingForFacilityManager
View Training Program for Unassigned Provider Member: (ProviderManagement_viewManagedPersonTraining)
View Training For Provider Group Member: (ProviderManagement_viewManagedProviderGroupMemberTraining)
View Training For Provider Group Member: (ProviderManagement_viewManagedProviderGroupMemberTrainingDetails)
View Provider Group Training: (ProviderManagement_viewManagedProviderGroupTraining)
View Training For Provider Member: (ProviderManagement_viewManagedProviderMemberTraining)
View Training For Provider Member: (ProviderManagement_viewManagedProviderMemberTrainingDetails)
View Training For Provider: (ProviderManagement_viewManagedProviderTraining)
ProviderManagement_viewManagedProviderTrainingForFacilityManager
View Provider Group Member Training: (ProviderManagement_viewProviderGroupManagedTrainingForMember)
View Training For Provider Member: (ProviderManagement_viewProviderManagedTrainingForMember)
ProviderManagement_viewProviderManagedTrainingForMemberForFacilityManager
View Training: (ProviderManagement_viewTraining)
Training (ProviderManagement_viewTrainingDetails)
Home (ProviderManagement_viewTrainingServiceOfferingFrmList)