Table Description
Training Credit: Credits awarded to the recipient of a training course upon its completion.

Defines the number and type of credits awarded upon completion of a training course. Providers in different categories may be awarded different numbers of credits, and their training courses may have different validity periods.

Example

For example, the Child Care Early Years training is common to both child care and foster care related certifications. For the category child care, completing the Child Care Early Years training will earn more credits, and have a greater period of validity, than for the category foster care, due to the different natures of the certifications towards which the credits are allocated.
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 Credit::Entity::TrainingCredit
Controlling File: CPM\model\Packages\Service Layer\Training\Training Credit\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
trainingCreditIDkeynoThe unique system generated identifier for the Training Credit record.TRAINING_CREDIT_ID SVR_INT64
trainingIDdetailsnoThe unique system generated identifier for the Training record.TRAINING_ID SVR_INT64
providerCategorydetails The general classification of a provider e.g. Housing Facility, Child Care Facility, Medical Practitioner, Kinship Care.CPM_PROVIDER_CATEGORYTrainingProviderCategorySVR_STRING<10>
providerTypedetails The type of provider e.g. Family Day Home, Group Home etc.CPM_PROVIDER_TYPETrainingProviderTypeSVR_STRING<10>
typedetailsnoType of credit available on training completion.TRAINING_CREDIT_TYPETrainingCreditTypeSVR_STRING<10>
valuedetailsnoNumber of points awarded on completion of the training.CPM_COMMON_INTVALUE SVR_INT32
validityPerioddetails Number of periods after which the training completion expires.CPM_COMMON_INTVALUE SVR_INT32
validityPeriodUnitdetails Units of measure of validity period, after which the completed training is not valid. For example, Weeks, Months.PERIOD_UNITPeriodUnitSVR_STRING<10>
recordStatusdetailsnoThe status is used to indicate if the training credit is Active or logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
TrainingCredit.trainingIDTraining.trainingID
Indices (1)
Index NameAttributes
TrainingCreditTrainingIDIdxtrainingID
Operations (10)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: trainingCreditID
AUTO_ID_KEY: TRAIN
Creates a new record on TrainingCredit table. 
readread Reads a row of data from TrainingCredit table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing record on TrainingCredit table. 
removeremove Removes an existing row from TrainingCredit table. 
searchByTrainingreadmultiORDER_BY: providerType
Searches for all the Training Credit records for a given Training ID. 
countTrainingCreditsForProviderCategoryns Gets Training Credit records count for the given Training ID and Provider Category.SQL
countTrainingCreditsForProviderTypens Gets Training Credit records count for the given Training ID and Provider Type.SQL
countTrainingCreditsForProviderCategoryAndTypens Gets Training Credit records count for the given Training ID, Provider Category and Provider Type.SQL
countTrainingCreditsWithoutProviderCategoryAndTypens Gets Training Credit records count for the given Training ID and without Provider Category , Provider Type.SQL
insertTrainingCreditnsinsert Inserts record to TrainingCredit entity. This method expects TrainingCredit 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 TrainingCredit ID). It's preferred to call insertTrainingCredit only in scenario's where caller wants to set the value of primary key by itself. 
Related Pages (25)
Delete Training Credit (ProviderManagement_cancelTrainingCredit)
New Training Credit (ProviderManagement_createTrainingCredit)
Edit Training (ProviderManagement_editTrainingProgramForProviderGroupMember)
Edit Training Service (ProviderManagement_editTrainingServiceOffering)
Edit Training Service (ProviderManagement_editTrainingServiceOfferingFrmView)
Edit Training Credit (ProviderManagement_modifyTrainingCredit)
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 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 Training For Provider Member: (ProviderManagement_viewManagedProviderMemberTraining)
View Training For Provider Member: (ProviderManagement_viewManagedProviderMemberTrainingDetails)
View Provider Group Member Training: (ProviderManagement_viewProviderGroupManagedTrainingForMember)
View Training For Provider Member: (ProviderManagement_viewProviderManagedTrainingForMember)
ProviderManagement_viewProviderManagedTrainingForMemberForFacilityManager
View Training: (ProviderManagement_viewTraining)
View Training Credit (ProviderManagement_viewTrainingCredit)
Training (ProviderManagement_viewTrainingDetails)
Home (ProviderManagement_viewTrainingServiceOfferingFrmList)