Table Description
Training Service Offering: Configuration details for training service offering.

Additional criteria that are specific to the management of a training service offering.

Example

For example, an agency may identify that Separation, Placement, and Reunification in Family-Centered Child Protective Services training requires approval to authorize a provider member to receive this training service. The agency further confirms that the provider member needs to undergo 10 units of training before it can be marked as completed.

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::Service Offering::Training Service Offering::Entity::TrainingServiceOffering
Controlling File: CPM\model\Packages\Service Layer\Service Offering\Training Service Offering\Training Service Offering_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
trainingServiceOfferingIDkeynoThe unique system generated identifier for the Training Service Offering record.TRAINING_SERVICE_OFFERING_ID SVR_INT64
serviceOfferingIDdetailsnoThe unique system generated identifier for the service offering record.SERVICE_OFFERING_ID SVR_INT64
trainingIDdetailsnoThe unique system generated identifier for the training record.TRAINING_ID SVR_INT64
approvalRequireddetailsyesIndicates whether approval is required for the training to be authorized.BOOLEAN_TYPE SVR_BOOLEAN
unitsRequireddetails Number of units required in order to mark the training as completed.CPM_COMMON_INTVALUE SVR_INT32
Foreign Keys (2)
ChildParent
TrainingServiceOffering.serviceOfferingIDServiceOffering.serviceOfferingID
TrainingServiceOffering.trainingIDTraining.trainingID
Indices (2)
Index NameAttributes
TrainSOTrainingIDIdxtrainingID
TrainSOServiceOfferingIDIdxserviceOfferingID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: trainingServiceOfferingID
AUTO_ID_KEY: SEROFF
Creates a new row on TrainingServiceOffering table. 
removeremove Standard Operation 
readread Reads a row of data from TrainingServiceOffering table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on TrainingServiceOffering table. 
searchByTrainingTypensmulti Searches for trainings which are currently offered as services for a given training type. SQL
searchByTrainingNameAndUnitOfMeasurensmulti Search for trainings which are currently offered as services for the specified training name or unit of measure. SQL
readByServiceOfferingnsread Reads training service offering details for the specified service offering.  
searchByTrainingreadmulti Searches the training service offering details for the specified training. 
insertTrainingServiceOfferingnsinsert Creates a new row on TrainingServiceOffering table and it should be used the user is passing the primary id. 
Related Pages (49)
New Member (ProviderManagement_addProviderGroupMemberToATrainingProgram)
New Provider Member (ProviderManagement_addProviderMemberToATrainingProgram)
Update to Training (ProviderManagement_addTrainingForServiceOffering)
Delete Training (ProviderManagement_cancelTraining)
New Service (ProviderManagement_createNewTrainingServiceOffering)
New Training Service (ProviderManagement_createTrainingServiceOffering)
Edit Training (ProviderManagement_editTrainingProgramForProviderGroupMember)
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_listServiceOffering
Edit Training (ProviderManagement_modifyTrainingProgramForProvider)
Edit Training (ProviderManagement_modifyTrainingProgramForProviderGroup)
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)
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)
Select From Training Requirements (ProviderManagement_selectTrainingForProvider)
Select From Training Requirements (ProviderManagement_selectTrainingForProviderGroup)
Select From Training Requirements (ProviderManagement_selectTrainingForProviderGroupMember)
Select From Training Requirements (ProviderManagement_selectTrainingForProviderMember)
Edit Training (ProviderManagement_updateCompletedTrainingForProvider)
Edit Training (ProviderManagement_updateCompletedTrainingForProviderGroup)
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)
Home (ProviderManagement_viewTrainingServiceOfferingFrmList)