Table Description
Service Offering Training Requirement: The training requirements defined by the organization for a service offering.

Training courses can be identified for a service offering as required or recommended. This means that it is required or recommended that people complete these training courses, if they are associated with a Provider that wishes to deliver that service offering.

Example

For Example, Fire Prevention and Safety Procedures will be a required training for people delivering the Foster Care service.
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::Service Offering Training Requirement::Entity::SOTrainingRequirement
Controlling File: CPM\model\Packages\Service Layer\Service Offering\Service Offering Training Requirement\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
soTrainingRequirementIDkeynoThe unique system generated reference number for the service offering training requirement record.SERVICE_OFFERING_TRAINING_REQUIREMENT_ID SVR_INT64
trainingIDdetailsnoThe unique system generated reference number for the training record.TRAINING_ID SVR_INT64
serviceOfferingIDdetailsnoThe unique system generated reference number for the service offering record.SERVICE_OFFERING_ID SVR_INT64
completiondetails Indicates whether completion of the training is required or recommended in order to provide the service offering.TRAINING_COMPLETIONTrainingCompletionSVR_STRING<10>
removalReasondetails Reason for removing the training requirement for the service offering.TRAINING_REMOVAL_REASONTrainingRemovalReasonSVR_STRING<10>
statusdetails Status of the service offering training requirement.SERVICE_TRAINING_STATUSTrainingRequirementStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
SOTrainingRequirement.serviceOfferingIDServiceOffering.serviceOfferingID
SOTrainingRequirement.trainingIDTraining.trainingID
Indices (2)
Index NameAttributes
SOTrainingRequirementSOIDIdxserviceOfferingID
SOTrainingRequTrainingIDIdxtrainingID
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: soTrainingRequirementID
AUTO_ID_KEY: SEROFF
Inserts the Training Requirements record for a Service Offering on the ServiceOfferingTrainingRequirement table. 
readread Reads the Service Offering Training Requirement record from the ServiceOfferingTrainingRequirement table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies the existing Service Offering Training Requirement record on the ServiceOfferingTrainingRequirement table. 
searchByreadmulti Searches the Training requirements for a specified Service Offering on the ServiceOfferingTrainingRequirement table. 
countTrainingRequirementByTrainingServicens Gets the count of active Training Requirements for a specified service offering and training.SQL
searchByProvidernsmulti Searches for all the trainings that are listed as training requirement of any active provider offerings currently held by a provider.SQL
searchByProviderGroupnsmulti Searches for all the trainings that are listed as training requirement of any active provider offerings currently held by a provider group.SQL
searchByProviderMembernsmulti Searches for all the trainings that are listed as training requirement of any active provider offerings currently held by a provider member.SQL
searchByProviderGroupMembernsmulti Searches for all the trainings that are listed as training requirement of any active provider offerings currently held by a provider group member.SQL
searchByTrainingreadmulti Searches the Training requirements for a specified Training. 
insertSOTrainingRequirementnsinsert Inserts the SO Training Requirements table and it should be used only when the user is passing the primary id. 
Related Pages (17)