Table Description
Training Program Member: The provider member or provider group member or person attending the training.

The provider member or provider group member or person attending the training.

Example

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

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::TrainingProgramMember::Entity::TrainingProgramMember
Controlling File: CPM\model\Packages\Service Layer\Training\TrainingProgramMember\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
trainingProgramMemberIDkeynoThe unique system generated identifier for the training program member record.TRAINING_PROGRAM_MEMBER_ID SVR_INT64
trainingProgramIDdetailsyesThe unique system generated identifier for the training program record.TRAINING_PROGRAM_ID SVR_INT64
partyConcernRoleIDdetailsyesThe unique system generated identifier for the party concern role record.CONCERN_ROLE_ID SVR_INT64
completiondetails Indicates whether completion of the training is required or recommended for a provider or provider group member, or unassigned provider member.TRAINING_COMPLETIONTrainingCompletionSVR_STRING<10>
dateCompleteddetails The date on which the training was completed by a provider or provider group member, or unassigned provider member.CURAM_DATE SVR_DATE
unitsCompleteddetails The number of units of the training completed by a provider or provider group member, or unassigned provider member.NUMBER_WORK_UNITS SVR_INT32
unitsRequireddetails number of units of the training required for a provider or provider group member, or unassigned provider member.NUMBER_WORK_UNITS SVR_INT32
waiverExpiryDatedetails The date to which the training waiver is effective.CURAM_DATE SVR_DATE
creditsAchieveddetailsyesNumber of points accumulated by a provider or provider group member, or unassigned provider member on completion of the training.CPM_COMMON_INTVALUE SVR_INT32
statusdetails The status of training program member record.TRAINING_PROGRAM_PARTY_STATUSTrainingPrgramPartyStatusSVR_STRING<10>
Foreign Keys (3)
ChildParent
TrainingProgramMember.partyConcernRoleIDConcernRole.concernRoleID
TrainingProgramMember.trainingProgramIDTrainingProgram.trainingProgramID
TrainingStatusHistory.trainingProgramMemberIDTrainingProgramMember.trainingProgramMemberID
Indices (2)
Index NameAttributes
TrainPrgMemPrtyCncrnRoleIDIdxpartyConcernRoleID
TrainPrgMemTrainingProgIDIdxtrainingProgramID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: trainingProgramMemberID
Creates a new row on TrainingProgramMember table. 
readread Reads a row of data from TrainingProgramMember table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on TrainingProgramMember table. 
removeremove Removes an existing row from TrainingProgramMember table. 
searchTrainingProgramMembersForConcernRolensmulti  SQL
searchTrainingProgramsForPartynsmulti  SQL
searchTrainingProgramMembersreadmulti   
searchMemberTrainingProgramsreadmultiWHERE: partyConcernRoleID= :partyConcernRoleID and status <> :status
  
Related Pages (83)
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)
Approve Provider Service (ProviderManagement_approveProviderServiceOffering)
Delete Member (ProviderManagement_confirmDeletePerson)
New Member (ProviderManagement_createMemberForProvider)
New Member (ProviderManagement_createMemberForProviderForFacilityManager)
New Member Service (ProviderManagement_createProviderMemberOffering)
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_listTrainingProgramForProviderGroupMember)
Training: (ProviderManagement_listTrainingProgramForProviderMember)
Training: (ProviderManagement_listTrainingProgramInfoForProviderGroupMember)
Training (ProviderManagement_listTrainingProgramInfoForProviderMember)
Edit Member (ProviderManagement_modifyProviderGroupMemberList)
Edit Member (ProviderManagement_modifyProviderGroupMemberView)
Edit Member (ProviderManagement_modifyProviderMemberRelationship)
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)