Table Description
User Skill: A skill offered by a user in relation to the organization's business.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::UserSkill::Entity::UserSkill::UserSkill
Controlling File: core\model\Packages\Reference Model\Service Layer\UserSkill\Entity\UserSkill\UserSkill_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
userSkillIDkeynoUser Skill unique ID.USER_SKILL_ID SVR_INT64
userNamedetailsnoThe user name of the user skill record.USER_NAME SVR_STRING<64>
skillLeveldetailsnoThe level of the user skill.SKILL_LEVEL_CODESkillLevelSVR_STRING<10>
skillTypedetailsnoThe type of user skill.SKILL_TYPE_CODESkillTypeSVR_STRING<10>
descriptiondetails A description of the user skill.DESCRIPTION SVR_STRING<300>
recordStatusdetailsnoUser Skill record status.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Indices (1)
Index NameAttributes
UsrSkillNamTypIdxuserName, skillType
Operations (15)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: userSkillID
AUTO_ID_KEY: USERBO
PRE_DATA_ACCESS: yes
Inserts a user skill record. 
readread Read the details of a user skill record. 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Updates a user skill record. 
searchByUserreadmulti Reads a list of user skills based on userID 
validateInsert  Validates the user skill record before insertion. 
validateModify  Validates the user skill record before modification. 
validateCancel  Validates the record before updating. 
readByUserSkillTypeAndStatusnsread Searches for user skill record based on userName, status and skill type. 
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Cancels the user skill record. 
validate  validates the details before insertion or modification. 
readRecordStatusnsread Reads the user skill record status. 
readUserNameAndSkillTypensread Reads the user name and skill type for a user skill. 
readUserNamensread Reads the user name for the user skill. 
insertUserSkillinsertPRE_DATA_ACCESS: no
Inserts record to user skill entity. This method expects user skill 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 (user skill ID). It's preferred to call this method only in scenario's where caller wants to set the value of primary key (user skill ID) by itself. 
modifyUserSkillmodifyOPTIMISTIC_LOCKING: yes
This modify operation will be called while re-applying a change set in the target system. Entity level validations that will happen during a standard modify operation will not be applicable in this case. This modify operation will update all the attributes defined for this entity. 
Related Pages (191)
Match Client (Application_matchClientConfirmation)
Create Case (BenefitSample_createCase)
New Member (Case_createCaseMember)
Add Family as Case Members (Case_createCaseRelatedMember)
New Owner (Case_modifyCaseOwner)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCase)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCasePDC)
Register Prospect Person and Create a Case (Case_registerProspectPersonAndCreateIntegratedCase)
Register Prospect Person and Create an Integrated Case (Case_registerProspectPersonAndCreateIntegratedCasePDC)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Authorize (CREOLEProgramRecommendation_confirmAuthorize)
New Product Delivery (DefaultIC_createProductDelivery)
New Case (DefaultICMember_createProductDelivery)
Program Summary (Eligibility_createProgram)
Cancel Payment (Financial_cancelPayment)
Cancel Payment (Financial_cancelPayment1)
Cancel Issued Payment (Financial_cancelPaymentInstrument)
Reverse Instruction (Financial_createInstructionReversal)
Reverse Details (Financial_createLineItemReversal)
Invalidate Payment (Financial_invalidatePayment)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
New Investigation (ICInvestigationSample_create)
New Case (ICMember_createProductDelivery)
Create Delivery (ICSample_createProductDelivery)
New Case (ICSample_selectIntegratedCaseType)
New Investigation (InvestigationSample_selectType)
New Investigation (InvestigationSample_selectTypeForPerson)
New Investigation (InvestigationSample_selectTypeFromNonRegisteredPerson)
Cancel Sanction (ISP_cancelSanctionEvidence)
Cancel Disregard (ISP_cancelSanctionOverride)
Retroactive Program Summary (ISP_createRetroactiveProgram)
New Sanction (ISP_createSanctionEvidence)
New Disregard (ISP_createSanctionOverride)
Edit Sanction (ISP_modifySanctionEvidence_fromList)
Edit Sanction (ISP_modifySanctionEvidence_fromView)
Edit Disregard (ISP_modifySanctionOverride_fromList)
Modify Sanction Override Details: (ISP_modifySanctionOverride_fromView)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Create Case (LiabilitySample_createCase)
Delete Skill (MultidisciplinaryTeamMember_cancelSkill)
New Multidisciplinary Team Member Skill (MultidisciplinaryTeamMember_createSkill)
Edit Multidisciplinary Team Member (MultidisciplinaryTeamMember_modifyFromAdministrationList)
Edit Multidisciplinary Team Member (MultidisciplinaryTeamMember_modifyFromList)
Edit Multidisciplinary Team Member (MultidisciplinaryTeamMember_modifyFromView)
Edit Skill (MultidisciplinaryTeamMember_modifySkillFromList)
View Multidisciplinary Team Member: (MultidisciplinaryTeamMember_view)
MultidisciplinaryTeamMember_viewDetails
MultidisciplinaryTeamMember_viewExternalRoles
MultidisciplinaryTeamMember_viewExternalSharing
MultidisciplinaryTeamMember_viewExternalSkills
MultidisciplinaryTeamMember_viewExternalTeams
MDT Member Contact (MultidisciplinaryTeamMember_viewFromCCV)
MDT Member Contact (MultidisciplinaryTeamMember_viewFromCEF)
MultidisciplinaryTeamMember_viewInternalSkills
MultidisciplinaryTeamMember_viewInternalTeams
Multidisciplinary Member Details (MultidisciplinaryTeamMember_viewModal)
MDT Member Contact (MultidisciplinaryTeamMember_viewModalForMinutes)
MultidisciplinaryTeamMember_viewRoles
MultidisciplinaryTeamMember_viewSkills
MultidisciplinaryTeamMember_viewTeams
Delete Skill (Organization_cancelUserSkill)
New User Skill: (Organization_createUserSkill)
New Skill (Organization_createUserSkill1)
Skills (Organization_listUserSkillsForUser)
Edit User's Language Skills (Organization_modifyUserLanguageSkills)
Edit Skill (Organization_modifyUserSkillFromList)
Edit Skill (Organization_modifyUserSkillFromView)
New User Language Skills (Organization_userLanguageSkills)
User Skill Details: (Organization_viewUserSkill)
Reverse Line Item (Participant_createLineItemReversal)
Edit Person (Person_evidenceModify)
Edit Client Details (Person_evidenceModifyClient)
Edit Person (Person_modifyPerson)
Authorize (ProgramRecommendation_confirmAuthorize)
Authorize (ProgramRecommendation_listHouseholdMembersForMA)
Authorize (ProgramRecommendation_PremiumCoPaymentDetails)
Activate Contract (ProviderManagement_activateContract)
New Text Translation (ProviderManagement_addDescriptionTranslationToServiceOffering)
New Text Translation (ProviderManagement_addNameTranslationToServiceOffering)
Add Service Authorization Line Item: (ProviderManagement_addSampleServiceAuthorizationLineItem)
New Service (ProviderManagement_addServicesToProviderContract)
Add Services to Contract (ProviderManagement_addServicesToProviderGroupContract)
New Service (ProviderManagement_addServicesToProviderGroupContract_fromView)
Update to Training (ProviderManagement_addTrainingForServiceOffering)
Submit Service Invoice Line Item for Processing (ProviderManagement_allowSILIForProcessingAsDuplicate)
Amend Utilization Contract (ProviderManagement_amendProviderGroupUtilizationContract)
Amend Contract (ProviderManagement_amendUtilizationContract)
Approve Line Item (ProviderManagement_approveLineItemCorrections)
Approve Line Item (ProviderManagement_approvePendingSILI)
Approve Line Item (ProviderManagement_approvePendingSILICorrections)
Approve Line Item (ProviderManagement_approveServiceInvoiceLineItem)
Approve Service Invoice Line Items (ProviderManagement_approveServiceInvoiceLineItems)
Approve Line Item (ProviderManagement_approveSILI)
Approve Service Invoice Line Item as Duplicate (ProviderManagement_approveSILIAsDuplicate)
Approve Line Item (ProviderManagement_approveSILICorrections)
Approve Line Items (ProviderManagement_approveSubmittedSILI)
Approve Line Items (ProviderManagement_confirmApproveServiceInvoiceLineItems)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveResForAnyClient)
Confirm Modify Overlapping Placements (ProviderManagement_confirmModifyOverlappingPlacementPrd)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
New Investigation Case (ProviderManagement_createInvestigation)
New Service (ProviderManagement_createNewServiceOffering)
New Service (ProviderManagement_createNewTrainingServiceOffering)
New Service Rate (ProviderManagement_createProviderGroupUtilizationContractProviderOfferingRate)
New Payment Options (ProviderManagement_createProviderPaymentOption)
New Rate (ProviderManagement_createProviderServiceOfferingRate)
Create Emergency Placement (ProviderManagement_createSampleEmergencyPlacement)
Create Service Authorization Line Items (ProviderManagement_createSampleSAWithSALI)
New Service (ProviderManagement_createServiceOffering)
New Payment Options (ProviderManagement_createServicePaymentOption)
New Service Rate (ProviderManagement_createServiceRate)
New Training Service (ProviderManagement_createTrainingServiceOffering)
New Utilization Contract (ProviderManagement_createUtilizationContractForProvider)
New Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
Edit Payment Option (ProviderManagement_editProviderPaymentOption)
Edit Service (ProviderManagement_editServiceOffering)
Edit Service (ProviderManagement_editServiceOfferingFrmView)
Edit Payment Options (ProviderManagement_editServicePaymentOption)
Edit Service Rate (ProviderManagement_editServiceRate)
Edit Training Service (ProviderManagement_editTrainingServiceOffering)
Edit Training Service (ProviderManagement_editTrainingServiceOfferingFrmView)
- (ProviderManagement_enrollProviderComplete)
- (ProviderManagement_enrollProviderRegistered)
Edit Text Translation (ProviderManagement_modifyLocalizableSODescriptionTextTranslation)
Edit Text Translation (ProviderManagement_modifyLocalizableSONameTextTranslation)
Confirm Placement (ProviderManagement_modifyPlaceDuringConfirmation)
Edit Placement (ProviderManagement_modifyPlacementDetails)
Modify Placement Information (ProviderManagement_modifyPlacementInformation)
Confirm Cancel Reservation (ProviderManagement_modifyPlacementInformationConfirmCancelReservation)
Allocate Place (ProviderManagement_modifyPlaceProviderOfferingAllocate)
Edit Provider Details (ProviderManagement_modifyProvider)
Edit Service Rate (ProviderManagement_modifyProviderGroupUtilizationContractProviderOfferingRate)
Edit Rate (ProviderManagement_modifyProviderServiceOfferingRate)
Confirm Placement: (ProviderManagement_modifySamplePlaceDuringConfirmation)
Modify Service Authorization Line Item: (ProviderManagement_modifySampleServiceAuthorizationLineItem)
Edit Delivery Configuration (ProviderManagement_modifySecurityRightsAndServiceDeliveryConfiguration)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Edit Rate (ProviderManagement_modifyUtilizationContractProviderOfferingRate)
Place Client (ProviderManagement_placeSampleClient)
Provider Enquiry Successfully Created (ProviderManagement_providerEnquiryRegistered)
Home (ProviderManagement_providerGroupHome)
Home (ProviderManagement_providerHome)
Home (ProviderManagement_providerHomeForFacilityManager)
ProviderManagement_providerHomeTabDetailsPreview
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Submit Line Item (ProviderManagement_submitOpenSILIForProcessing)
Submit Line Item (ProviderManagement_submitServiceInvoiceLineItemForProcessing)
Submit Line Items (ProviderManagement_submitServiceInvoiceLineItems)
Submit Line Item (ProviderManagement_submitSILI)
Submit Service Invoice Line Item for Processing (ProviderManagement_submitSILIForProcessingFromTask)
Submit Service Invoice (ProviderManagement_submittServiceInvoiceForProcessing)
Transfer Client (ProviderManagement_transferClient)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
ProviderManagement_viewProviderEnquiry
Provider Enquiry Preferred Language (ProviderManagement_viewProviderEnquiryOwnerLanguageSkillInformational)
Provider Group Preferred Language (ProviderManagement_viewProviderGroupOwnerLanguageSkillInformational)
Provider Preferred Language (ProviderManagement_viewProviderOwnerLanguageSkillInformational)
ProviderManagement_viewProviderTabDetails
Application (RightsAndResponsibilitiesForCase)
Application (RightsAndResponsibilitiesForCaseSubmit)
New Disregard (SanctionAssessment_createDisregard_CREOLE)
New Sanction (SanctionAssessment_createSanction_CREOLE)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)
Add Plan Item (ServicePlanDelivery_addCustomServicePlanItem)
Add Plan Item (ServicePlanDelivery_addServicePlanItem)
Change Plan Owner (ServicePlanDelivery_changePlanOwner)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Set Plan Owner (ServicePlanDelivery_modifyPlanOwner)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)
New Owner (SocialEnterpriseFolder_modifyCaseOwner)
Multidisciplinary Team Member Contact: (SocialEnterpriseFolder_viewMDTContactDetails)
SocialEnterpriseFolder_viewMDTMemberTransaction
User Details (SocialEnterpriseFolder_viewUserDetails)
User Details: (SocialEnterpriseFolder_viewUserDetailsForMinutes)
Delete user skill (Supervisor_cancelUserSkill)
New Skill (Supervisor_createUserSkill)
Edit Skill (Supervisor_modifyUserSkillFromList)
Edit Skill (Supervisor_modifyUserSkillFromView)
Skills (Supervisor_userSkills)
User Skill Details: (Supervisor_viewUserSkill)