Table Description
Training Program: Training planned for or received by a provider or provider group member.

Training planned for or received by a provider/provider group member.

Example

For example, the Child Care Early Years training is received by child care provider.

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::TrainingProgram::Entity::TrainingProgram
Controlling File: CPM\model\Packages\Service Layer\Training\TrainingProgram\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
trainingProgramIDkeynoThe unique system generated identifier for the training program record.TRAINING_PROGRAM_ID SVR_INT64
referenceNumberdetails The unique reference number assigned for the training program record.REFERENCE_NUMBER SVR_STRING<20>
concernRoleIDdetailsyesThe unique system generated identifier for the concern role record.CONCERN_ROLE_ID SVR_INT64
unitAmountdetailsyesThe stipulated amount per unit that the agency authorizes for payment to a provider for delivering the training.CURAM_AMOUNT SVR_MONEY
trainingIDdetailsyesThe unique system generated identifier for the training record.TRAINING_ID SVR_INT64
trainingNamedetails The name of the external training that is not being managed by the organization.TRAINING_NAME SVR_STRING<50>
trainingProviderIDdetailsyesThe unique system generated identifier for the training provider record.PROVIDER_ID SVR_INT64
trainingProviderDetailsdetails The details of the provider from whom a provider or provider group member received the external training.COMMENTS SVR_STRING<300>
managedThroughAgencydetailsyesIndicates whether the training is authorized and managed by the organization.BOOLEAN_TYPE SVR_BOOLEAN
authorizedFromdetails The date from which a provider or provider group member is authorized to receive training.CURAM_DATE SVR_DATE
toBeCompletedBydetails The date by which all provider or provider group members authorized for a training must complete the training.CURAM_DATE SVR_DATE
recordStatusdetails The status of the training program record.RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (4)
ChildParent
TrainingProgram.concernRoleIDConcernRole.concernRoleID
TrainingProgram.trainingProviderIDProvider.providerConcernRoleID
TrainingProgram.trainingIDTraining.trainingID
TrainingProgramMember.trainingProgramIDTrainingProgram.trainingProgramID
Indices (3)
Index NameAttributes
TrainingProgramTrainingIDIdxtrainingID
TrainingProgConcernRoleIDIdxconcernRoleID
IND_650824059trainingProviderID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: trainingProgramID
Creates a new row on TrainingProgram table. 
readread Reads a row of data from TrainingProgram table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on TrainingProgram table. 
removeremove Removes an existing row from TrainingProgram table. 
searchByConcernRolereadmultiORDER_BY: trainingProgramID
WHERE: concernRoleID = :concernRoleID and managedThroughAgency = :managedThroughAgency and recordStatus = :status
  
searchByTrainingreadmulti Searches for all the Training Programs for a given Training. 
Related Pages (84)
New Member (ProviderManagement_addProviderGroupMemberToATrainingProgram)
New Provider Member (ProviderManagement_addProviderMemberToATrainingProgram)
Approve License (ProviderManagement_approveLicense)
Approve Training Program (ProviderManagement_approvePersonTrainingProgram)
Approve Training (ProviderManagement_approveProviderGroupMemberTrainingProgram)
Approve Training Program (ProviderManagement_approveProviderMemberTrainingProgram)
Delete Training (ProviderManagement_cancelTraining)
Delete Training Program (ProviderManagement_deleteCompletedTrainingProgramForPerson)
Delete Training Program for Unassigned Provider Member (ProviderManagement_deleteTrainingProgramForPerson)
Delete Training (ProviderManagement_deleteTrainingProgramForProvider)
Delete Training (ProviderManagement_deleteTrainingProgramForProviderGroup)
Delete Training (ProviderManagement_deleteTrainingProgramForProviderGroupMember)
Delete Training (ProviderManagement_deleteTrainingProgramForProviderMember)
Edit Training (ProviderManagement_editCompletedTrainingProgramForProviderGroupMember)
Edit Training (ProviderManagement_editTrainingProgramForProviderGroupMember)
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_listTrainingProgramForPerson
Training (ProviderManagement_listTrainingProgramForProvider)
Training (ProviderManagement_listTrainingProgramForProviderForFacilityManager)
Training (ProviderManagement_listTrainingProgramForProviderGroup)
Training (ProviderManagement_listTrainingProgramForProviderGroupMember)
Training: (ProviderManagement_listTrainingProgramForProviderMember)
Training: (ProviderManagement_listTrainingProgramInfoForProviderGroupMember)
Training (ProviderManagement_listTrainingProgramInfoForProviderMember)
Edit Member (ProviderManagement_modifyProviderGroupMemberList)
Edit Member (ProviderManagement_modifyProviderGroupMemberView)
Edit Member (ProviderManagement_modifyProviderMemberRelationship)
Edit Training (ProviderManagement_modifyTrainingProgramForProvider)
Edit Training (ProviderManagement_modifyTrainingProgramForProviderGroup)
Edit Period (ProviderManagement_modifyUnassignedProviderMember)
New Non-Managed Training (ProviderManagement_recordCompletedTrainingForPerson)
New Non-Managed Training Program (ProviderManagement_recordCompletedTrainingForProvider)
New Non-Managed Training Program (ProviderManagement_recordCompletedTrainingForProviderGroup)
New Non-Managed Training Program (ProviderManagement_recordCompletedTrainingForProviderGroupMember)
New Non-Managed Training Program (ProviderManagement_recordCompletedTrainingForProviderMember)
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 Completed Training For Provider Group Member: (ProviderManagement_viewCompletedTrainingForProviderGroupMember)
View Completed Training For Provider: (ProviderManagement_viewCompletedTrainingForProviderMember)
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
Waive Training (ProviderManagement_waiveProviderGroupManagedTrainingForMember)
Waive Training (ProviderManagement_waiveProviderManagedTrainingForMember)
Waive Provider Group Member Training (ProviderManagement_waiveTrainingProgramDetailsForProviderGroupMember)
Waive Training (ProviderManagement_waiveTrainingProgramDetailsForProviderMember)
Waive Training Program (ProviderManagement_waiveTrainingProgramForPerson)
Waive Training (ProviderManagement_waiveTrainingProgramForProviderGroupMember)
Waive Training (ProviderManagement_waiveTrainingProgramForProviderMember)