Table Description
Organization Unit Position Link: The relationship between an organization unit and a position.
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::Core::Reference Model::Service Layer::OrgUnitPositionLink::Entity::OrgUnitPositionLink::OrgUnitPositionLink
Controlling File: core\model\Packages\Reference Model\Service Layer\OrgUnitPositionLink\Entity\OrgUnitPositionLink\OrgUnitPositionLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
VALIDATION_EXIT_POINTno
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
orgUnitPositionLinkIDkeynoThe unique identifier of the orgUnitPosition record.ORG_UNIT_POSITION_LINK_ID SVR_INT64
organisationStructureIDdetailsnoThe organization structure id of this orgUnitPositionLink record.ORGANISATION_STRUCTURE_ID SVR_INT64
positionIDdetailsnoThe position id of this orgUnitPositionLink record.POSITION_ID SVR_INT64
recordStatusdetails The orgUnitPositionLink record status.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
organisationUnitIDdetailsnoThe organization unit id of this orgUnitPositionLink record.ORGANISATION_UNIT_ID SVR_INT64
Foreign Keys (3)
ChildParent
OrgUnitPositionLink.organisationStructureIDOrganisationStructure.organisationStructureID
OrgUnitPositionLink.organisationUnitIDOrganisationUnit.organisationUnitID
OrgUnitPositionLink.positionIDPosition.positionID
Indices (4)
Index NameAttributes
PositionIDIdxpositionID
OrgUnitPosLinkIdx1organisationStructureID, recordStatus
OrgUnitPosLinkIdx2organisationStructureID, positionID, recordStatus
OrgUnitPosLinkIdx3organisationUnitID, recordStatus
Operations (16)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: orgUnitPositionLinkID
AUTO_ID_KEY: ORGNSTREBO
PRE_DATA_ACCESS: yes
Inserts an orgUnitParentLink record into database. 
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Cancels an organization unit position link. 
readRecordStatusnsread Reads the record status of an organization unit position link. 
readByOrgStructurePositionAndStatusnsread Read the org unit position link record by org structure, position and record status. 
validateDetails  Validates the organization unit position link details. 
validateCancelDetails  Validates the organization unit position details before canceling. 
insertCloneinsertAUTO_ID: orgUnitPositionLinkID
Clones an organization unit position link. 
searchByOrgStructureAndStatusreadmulti Searches by organization structure and record status. 
validateInsertDetails  Validates the organization unit position link details before creation. 
countByOrgStructurePositionAndStatusns Returns the number of organization unit position link records by organization structure, position and record status.SQL
searchByOrgUnitAndStatusnsreadmulti Searches by organization unit and record status. 
clone  @superseded - replaced by insertClone 
readread Standard Operation 
insertOrgUnitPositionLinkinsertPRE_DATA_ACCESS: no
Inserts record to organisation&nbsp;unit position link&nbsp;entity. This method expects organisation structure 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 (organisation unit position link&nbsp; ID). It's preferred to call insertOrgUnitPositionLink only in scenario's where caller wants to set the value of primary key (organisation unit position link&nbsp;ID) by itself.<br /> 
modifymodify Modifies a organisation unit position link record. 
searchByPositionIDAndStatusnsmulti Returns a list of all the organisation structure identifiers for the specified position identifier.SQL
Related Pages (244)
Welcome to Cúram (Admin_workspace)
Approve Resolution (Appeal_approveResolution)
Confirm Location Hearing (Appeal_confirmIssueLocationHearingIC)
Confirm Location Hearing (Appeal_confirmLocationHearing)
Confirm Location Hearing (Appeal_confirmLocationHearingIC)
Schedule Hearing (Appeal_displaySchedule_HearingReview)
Schedule Hearing Review (Appeal_displaySchedule_HearingReviewForIC)
Schedule Hearing (Appeal_displaySchedule_HomeHearing)
Schedule Hearing (Appeal_displaySchedule_HomeHearingForIC)
Schedule Hearing (Appeal_displaySchedule_HomeHearingForIC1)
Schedule Hearing REVIEW (Appeal_displaySchedule_IssueHearingReviewForIC)
Schedule Hearing (Appeal_displaySchedule_IssueHomeHearingForIC)
Schedule Hearing (Appeal_displaySchedule_IssueLocationHearingIC)
Schedule Hearing (Appeal_displaySchedule_IssuePhoneHearingForIC)
Schedule Hearing (Appeal_displaySchedule_LocationHearing)
Schedule Hearing (Appeal_displaySchedule_LocationHearingIC)
Schedule Hearing (Appeal_displaySchedule_PhoneHearing)
Schedule Hearing (Appeal_displaySchedule_PhoneHearingForIC)
Schedule Hearing (Appeal_displaySchedule_PhoneHearingForIC1)
Reject Resolution (Appeal_rejectResolution)
Reschedule Hearing Review Hearing (Appeal_rescheduleHearingReviewHearing)
Reschedule Hearing Review Hearing (Appeal_rescheduleHearingReviewHearingForIC)
Reschedule Home Hearing (Appeal_rescheduleHomeHearing)
Reschedule Home Hearing (Appeal_rescheduleHomeHearingIC)
Reschedule Home Hearing (Appeal_rescheduleHomeHearingIC1)
Reschedule Location Hearing (Appeal_rescheduleLocationHearing)
Reschedule Location Hearing (Appeal_rescheduleLocationHearingIC)
Reschedule Telephone Hearing (Appeal_reschedulePhoneHearing)
Reschedule Telephone Hearing (Appeal_reschedulePhoneHearingIC)
Reschedule Telephone Hearing (Appeal_reschedulePhoneHearingIC1)
Schedule Hearing Review (Appeal_scheduleHearingReviewHearing)
Schedule Hearing Review (Appeal_scheduleHearingReviewHearingForIC)
Schedule Home Hearing (Appeal_scheduleHomeHearing)
Schedule Home Hearing (Appeal_scheduleHomeHearingIC)
Schedule Home Hearing (Appeal_scheduleHomeHearingIC1)
Schedule Hearing Review (Appeal_scheduleIssueHearingReviewHearingForIC)
Schedule Home Hearing (Appeal_scheduleIssueHomeHearingIC)
Schedule Hearing (Appeal_scheduleIssueLocationHearingIC)
Schedule Phone Hearing (Appeal_scheduleIssuePhoneHearingIC)
Schedule Location Hearing (Appeal_scheduleLocationHearing)
Schedule Hearing (Appeal_scheduleLocationHearingIC)
Schedule Phone Hearing (Appeal_schedulePhoneHearing)
Schedule Phone Hearing (Appeal_schedulePhoneHearingIC)
Schedule Phone Hearing (Appeal_schedulePhoneHearingIC1)
Submit Resolution For Approval (Appeal_submitResolutionForApproval)
Cúram - Administration Home (Application_administrationHome)
Cúram (Application_home)
Welcome to Cúram (Application_workspace)
Approve Assessment (AssessmentApproval_confirmApproval)
Assessment Results (AssessmentDelivery_listAssessmentResults)
Reject Assessment (AssessmentDelivery_reject)
New Assessment (AssessmentDelivery_selectAssessmentDefinition)
Edit Review (Case_modifyReviewFromList1)
Edit Review (Case_modifyReviewFromView1)
Complete Findings (CaseAudit_confirmCompleteFindings)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Approve Timer Extension (CommonIntake_approveTimerExtension)
Edit And Approve Timer Extension (CommonIntake_editAndApproveTimerExtension)
Extend Timer (CommonIntake_extendTimers)
List Timer Extensions (CommonIntake_listTimerExtension)
Reject Timer Extension (CommonIntake_rejectTimerExtension)
Program Summary (Eligibility_createProgram)
Close User (ExternalParty_closeOrganizationUser)
Close User (ExternalParty_closeUser)
Cúram Financials (Financial_home)
Welcome to Cúram (Financial_workspace)
Welcome to Cúram (FundPM_fundManagerHome)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
Approve Milestone Waiver Request: (ICInvestigationDelivery_approveWaiver)
Request Milestone Waiver (ICInvestigationDelivery_createWaiverForMilestone)
Edit And Approve Milestone Waiver Request (ICInvestigationDelivery_modifyAndApproveWaiver)
Reject Milestone Waiver Request (ICInvestigationDelivery_rejectWaiver)
Capture Head of Household Details: (IncomeScreening_createCase)
Schedule Appointment: (IncomeScreening_scheduleAppointment)
Schedule Appointment: (IncomeSupportScreening_checkUserAvailability)
Transfer Evidence: (IncomeSupportScreening_confirmTransferEvidence)
Capture Head of Household Details: (IncomeSupportScreening_createCase)
Select the Head of the Household (IncomeSupportScreening_transferEvidence)
Approve (Intake_approveTimerExtension)
Edit And Approve (Intake_editAndApproveTimerExtension)
Extend (Intake_extendTimers)
List Timer Extensions (Intake_listTimerExtension)
Reject (Intake_rejectTimerExtension)
Close Case (IntegratedCase_close)
New Assessment (IntegratedCase_createAssessment)
Plans (IntegratedCase_listExistingOutcomePlan)
Integrated Social Enterprise (IntegratedSocialEnterprise_home)
Approve Investigation Case (InvestigationDelivery_approve)
Close Investigation (InvestigationDelivery_close)
New Assessment (InvestigationDelivery_createAssessment)
Change Closure Details (InvestigationDelivery_modifyClose)
Reject Request For Approval (InvestigationDelivery_reject)
Reopen Investigation (InvestigationDelivery_reopen)
Submit For Approval (InvestigationDelivery_submit)
Cúram (ISPApplication_home)
ISPApplication_workspace
ISSApplication_workspace
Approve Resolution (IssueDelivery_approveResolution)
Reject Resolution (IssueDelivery_rejectResolution)
Submit Resolution for Approval (IssueDelivery_submitResolutionForApproval)
New Position (Organization_addPositionForOrgUnit)
Delete Position (Organization_cancelPosition)
Delete Position (Organization_cancelPositionByWorkflow)
Clone Organization Structure (Organization_cloneOrgStructure)
Close User (Organization_closeOrganizationUser)
Close User (Organization_closeUser)
Events (Organization_currentUserCalendar)
Supervisor Users For Position (Organization_listSupervisorUsersForPosition)
Calendar (Organization_selectedUserCalendar)
Organization_viewPosition
Position Home (Organization_viewPositionByUser)
Supervisor Users (Organization_viewPositionSupervisorUsers)
Agreements (OutcomePlan_listAgreements)
Assessments (OutcomePlan_listAssessments)
Assessments (OutcomePlan_listAssessmentsForReview)
Assessments (OutcomePlan_listOutcomePlanAssessments)
New Assessment (OutcomePlan_selectAssessmentDefinition)
New Assessment (OutcomePlan_selectPlanReviewAssessmentDefinition)
Approve Agreement (OutcomePlanAgreement_approve)
Complete Agreement (OutcomePlanAgreement_complete)
Reject Agreement (OutcomePlanAgreement_reject)
OutcomesPlan_agreementDetails
Approve Case (ProductDelivery_approve)
Approve Evidence (ProductDelivery_approveEffectiveDatedEvidence)
New Assessment (ProductDelivery_createAssessment)
Reject Request For Approval (ProductDelivery_reject)
Submit Case For Approval (ProductDelivery_submit)
New Supervisor (Provider_createOwnerSupervisorRole)
ProviderEnquiry_listAdminRole
Set Supervisor (ProviderGroup_createOwnerSupervisorRole)
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)
Close Enquiry (ProviderManagement_closeProviderEnquiry)
Approve Line Items (ProviderManagement_confirmApproveServiceInvoiceLineItems)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveResForAnyClient)
Confirm Modify Overlapping Placements (ProviderManagement_confirmModifyOverlappingPlacementPrd)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Approve Service (ProviderManagement_confirmServiceApproval)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
Confirm Transfer of Enquiry (ProviderManagement_confirmTransferEnquiryToEnrollProvider)
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 Supervisor (ProviderManagement_createSupervisorRole)
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)
Enroll Provider (ProviderManagement_enrollAsProvider)
Enroll Provider Group (ProviderManagement_enrollAsProviderGroup)
Enroll Provider (ProviderManagement_enrollProvider)
Transfer to Provider (ProviderManagement_enrollProviderFromEnquiry)
Enroll Provider Group (ProviderManagement_enrollProviderGroup)
My Workspace: Welcome to Cúram (ProviderManagement_facilityMgrHome)
ProviderManagement_listProvidersForResourceManagerSupervisor
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 Enquiry (ProviderManagement_modifyProviderEnquiry)
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)
Reject Service (ProviderManagement_rejectServiceApproval)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
My Workspace: Welcome to Cúram (ProviderManagement_resourceMgrHome)
My Workspace: Welcome to Cúram (ProviderManagement_resourceMgrSupervisorHome)
Step 2: Enroll Provider (ProviderManagement_sampleEnrollProvider)
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)
Add Plan Item (ServicePlanDelivery_addCustomServicePlanItem)
Add Plan Item (ServicePlanDelivery_addServicePlanItem)
Approve Milestone Waiver Request (ServicePlanDelivery_approveWaiver)
Request Milestone Waiver (ServicePlanDelivery_createWaiverForMilestone)
Edit And Approve Milestone Waiver Request (ServicePlanDelivery_modifyAndApproveWaiver)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)
Reject Milestone Waiver Request (ServicePlanDelivery_rejectWaiver)
New Social Enterprise Folder (SocialEnterpriseFolder_create)
New Social Enterprise Folder (SocialEnterpriseFolder_enhancedCreate)
Calendar (Supervisor_calendar)
Calendar (Supervisor_caseUserCalendar)
Forward Case Tasks Reserved By User (Supervisor_forwardCaseTasksReservedByUser)
Forward Task (Supervisor_taskForward)
Position Details: (Supervisor_viewPosition)
Welcome to Cúram (Supervisor_workspace)
Welcome to Cúram (SysAdmin_workspace)
Forward Task (TaskManagement_forward)
Forward Task: (WorkAllocation_forwardTask)
View Allocation Target: (WorkAllocation_viewAllocationTarget)
Confirm Supervisor exists for this case (WorkflowEvents_confirmSupervisorExists)