Table Description
Location Resource Link: Links a resource to its location
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::Organisation::Entity Objects::LocationResourceLink::LocationResourceLink
Controlling File: core\model\Packages\Organisation\LocationResourceLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
locationResourceLinkIDkeynoUnique reference number assigned by the system to the location resource link record.LOCATION_RESOURCE_LINK_ID SVR_INT64
locationIDdetailsnoUnique reference number of the location record which is associated with the resource. This is the foreign key to the Location record.LOCATION_ID SVR_INT64
resourceIDdetailsnoUnique reference number of the resource record which is associated with the location. This is the foreign key to the Resource record.RESOURCE_ID SVR_INT64
Foreign Keys (2)
ChildParent
LocationResourceLink.locationIDLocation.locationID
LocationResourceLink.resourceIDResources.resourceID
Indices (2)
Index NameAttributes
IND_1435910002locationID
IND__1451576949resourceID
Operations (10)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: locationResourceLinkID
AUTO_ID_KEY: LOCNSTREBO
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
countByResourceIDns  SQL
readLocationIDByResourceIDns  SQL
readLocationResourceLinkIDns Fetch locationResourceLinkID for a given locationID and resourceIDSQL
readLocationsAttachedToResourcensmulti List all locations attached to a resource.SQL
searchByLocationIDreadmulti <p> Reads all the records for a location id. </p> 
insertLocationResourceLinkinsert <p> Inserts&nbsp;record&nbsp;to&nbsp;location&nbsp;resource&nbsp;link&nbsp;entity.&nbsp;This&nbsp;method&nbsp;expects&nbsp;location&nbsp;resource&nbsp;link&nbsp;ID&nbsp;to&nbsp;be&nbsp;set&nbsp;by&nbsp;the&nbsp;caller. It's&nbsp;preferred&nbsp;to&nbsp;call&nbsp;this&nbsp;method&nbsp;only&nbsp;in&nbsp;scenario's&nbsp;where&nbsp;caller&nbsp;wants&nbsp;to&nbsp;set&nbsp;the&nbsp;value&nbsp;of&nbsp;primary&nbsp;key&nbsp;(location&nbsp;resource<br /> link&nbsp;ID)&nbsp;by&nbsp;itself. </p> 
Related Pages (313)
Acknowledge Receipts (Appeal_acknowledgeReceipts)
Acknowledge Receipts (Appeal_acknowledgeReceiptsAppellant)
Add Case to Hearing Case (Appeal_addHearingCase)
Add Case to Hearing Case (Appeal_addHearingCaseIC)
Add Case to Hearing Case (Appeal_addHearingCaseObject)
Add Hearing Review (Appeal_addHearingReviewCase)
Add Hearing Review (Appeal_addHearingReviewCaseIC)
Add Hearing Review (Appeal_addHearingReviewIssueCase)
Add Hearing Review (Appeal_addHearingReviewIssueCaseIC)
Add Hearing Review (Appeal_addHearingReviewObjectCase)
Add Issue to Hearing Case (Appeal_addIssueToHearingCase)
Add Issue to Hearing Review (Appeal_addIssueToHearingReview)
Add Issue to Judicial Review (Appeal_addIssueToJudicialReview)
Add Case to Judicial Review (Appeal_addJudicialReviewCase)
Add Case to Judicial Review (Appeal_addJudicialReviewCaseIC)
Add Case to Judicial Review (Appeal_addJudicialReviewIssueCase)
Add Case to Judicial Review (Appeal_addJudicialReviewIssueCaseIC)
Add Case to Judicial Review (Appeal_addJudicialReviewObjectCase)
Adjourn Hearing (Appeal_adjournHearing)
Adjourn Hearing (Appeal_adjournHearingForIC)
Adjourn Hearing (Appeal_adjournHearingReview)
Approve Resolution (Appeal_approveDecision)
Cancel Appeal Hearing (Appeal_cancelHearingCase)
Cancel Hearing Case (Appeal_cancelHearingIssueCase)
Cancel Hearing Review (Appeal_cancelHearingReview)
Cancel Judicial Review (Appeal_cancelJudicialReview)
Close Judicial Review (Appeal_closeJudicialReview)
Close Judicial Review (Appeal_closeJudicialReview1)
Confirm Location Hearing (Appeal_confirmExternalLocationHearingIC)
Confirm Hearing Review (Appeal_confirmHearing_HearingReviewForIC)
Confirm Hearing Review (Appeal_confirmHearingReviewHearing)
Confirm Hearing Review (Appeal_confirmHearingReviewHearingForIC)
Confirm Home Hearing (Appeal_confirmHomeHearing)
Confirm Home Hearing (Appeal_confirmHomeHearingIC)
Confirm Home Hearing (Appeal_confirmHomeHearingType)
Confirm Home Hearing (Appeal_confirmHomeHearingTypeIC)
Confirm Location Hearing (Appeal_confirmIssueExternalLocationHearingIC)
Confirm Location Hearing (Appeal_confirmIssueLocationHearingIC)
Confirm Location Hearing (Appeal_confirmLocationHearing)
Confirm Location Hearing (Appeal_confirmLocationHearingIC)
Confirm Phone Hearing (Appeal_confirmPhoneHearing)
Confirm Phone Hearing (Appeal_confirmPhoneHearingIC)
Confirm Phone Hearing (Appeal_confirmPhoneHearingType)
Confirm Phone Hearing (Appeal_confirmPhoneHearingTypeIC)
Confirm Reschedule External Location Hearing (Appeal_ConfirmReScheduleExternalLocationHearingIC)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleHearingReviewHearing)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleHearingReviewHearingForIC)
Confirm Reschedule Home Hearing (Appeal_confirmRescheduleHomeHearing)
Confirm Reschedule Home Hearing (Appeal_confirmRescheduleHomeHearingIC)
Confirm Reschedule Location Hearing (Appeal_confirmRescheduleLocationHearing)
Reschedule Hearing (Appeal_confirmRescheduleLocationHearingIC)
Confirm Reschedule Telephone Hearing (Appeal_confirmReschedulePhoneHearing)
Reschedule Telephone Hearing (Appeal_confirmReschedulePhoneHearingIC)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleReviewHearingDateTimeForIC)
Continue Hearing (Appeal_continueHearing)
Continue Hearing (Appeal_continueHearingReviewHearing)
New Appellant (Appeal_createAppellant)
New Hearing (Appeal_createHearingCaseMultipleCases)
New Hearing (Appeal_createHearingCaseMultipleCasesIC)
New Hearing (Appeal_createHearingCaseObjectMultipleCases)
New Hearing Review (Appeal_createHearingReviewMultipleCases)
New Hearing Review (Appeal_createHearingReviewMultipleCasesIC)
New Hearing Review (Appeal_createHearingReviewObjectMultipleCases)
New Interpreter (Appeal_createInterpreter)
New Hearing Case (Appeal_createIssueHearingCaseMultipleCases)
New Hearing Case (Appeal_createIssueHearingCaseMultipleCasesIC)
New Hearing Review (Appeal_createIssueHearingReviewMultipleCases)
New Hearing Review (Appeal_createIssueHearingReviewMultipleCasesIC)
New Judicial Review (Appeal_createIssueJudicialReviewMultipleCases)
New Judicial Review (Appeal_createIssueJudicialReviewMultipleCasesIC)
New Judicial Review (Appeal_createJudicialReviewMultipleCases)
New Judicial Review (Appeal_createJudicialReviewMultipleCasesIC)
New Judicial Review (Appeal_createJudicialReviewObjectMultipleCases)
New Case Appeal (Appeal_createProductAppeal)
Attach Statement (Appeal_createStatement)
New Third Party (Appeal_createThirdParty)
New Witness (Appeal_createWitness)
New Case Appeal (Appeal_createWizard)
Remove Appellant (Appeal_deleteAppellant)
Edit Hearing Representative Fee (Appeal_IC_modifyHearingReviewRepresentativeFee)
Edit Fee (Appeal_IC_modifyRepresentativeFee)
Edit Hearing Representative Fee (Appeal_modifyRepresentativeFee)
Edit Witness (Appeal_modifyWitnessFromList)
Edit Witness (Appeal_modifyWitnessFromListIC)
Edit Witness (Appeal_modifyWitnessFromView)
Edit Witness (Appeal_modifyWitnessFromViewIC)
New Case Appeal (Appeal_newCaseAppeal)
New Appeal (Appeal_nextStageAppeal)
Remove Third Party (Appeal_removeThirdParty)
Reschedule Desk-Based Hearing (Appeal_rescheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleIssueDeskHearing)
Submit Resolution (Appeal_submitDecision)
Reject Appealed Case (AppealedCase_rejectCase)
New Program Appeal (AppealWizard_createAppeal)
New Determination Appeal (AppealWizard_DeterminationCreateAppeal)
New Pro Forma Communication (Application_createProFormaCommunication)
Create Case (BenefitSample_createCase)
New Email Communication (Case_createEmailCommunication)
New Free Form Communication (Case_createFreeFormCommunication)
Create Pro Forma Communication: (Case_createProForma)
New Pro Forma Communication (Case_createProFormaCommunication)
New Pro Forma Communication (Case_createProFormaCommunication1)
New Referral (Case_createReferral)
Edit Referral (Case_modifyReferralFromList)
Edit Referral (Case_modifyReferralFromView)
Record Communication (Case_recordCommunication)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Reactivate Case (CHIPProductDelivery_reactivate)
Suspend Case (CHIPProductDelivery_suspend)
Unsuspend Case (CHIPProductDelivery_unsuspend)
Authorize (CREOLEProgramRecommendation_confirmAuthorize)
New Product Delivery (DefaultIC_createProductDelivery)
New Case (DefaultICMember_createProductDelivery)
Program Summary (Eligibility_createProgram)
Print Pro Forma Communication (ExternalParty_confirmModifyPrintForProFormaCommunication)
Print Pro Forma Communication (ExternalParty_confirmModifyPrintForProFormaCommunication1)
Edit External Party (ExternalParty_modifyExternalParty)
Edit Pro Forma Communication (ExternalParty_modifyProFormaCommunicationFromView1)
Register External Party (ExternalParty_register)
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 Case (ICMember_createProductDelivery)
Create Delivery (ICSample_createProductDelivery)
Confirm Appointment: (IncomeScreening_confirmAppointment)
Confirm Appointment: (IncomeSupportScreening_createAppointment)
Eligibility Summary Communication: (IncomeSupportScreening_generateEligibilitySummaryComm)
New Program Appeal (IntakeAppealWizard_createAppeal)
New Referral (IntegratedCase_createReferral)
Edit Referral (IntegratedCase_modifyReferralFromList)
Edit Referral (IntegratedCase_modifyReferralFromView)
Print Contract (IntegratedCase_printContract)
Close Investigation (InvestigationDelivery_close)
Change Closure Details (InvestigationDelivery_modifyClose)
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)
Reuse Program (ISPSpendDown_reuseProgram)
Reuse Program (ISPSpendDown_reuseRetroactiveProgram)
Schedule Hearing (LegalAction_scheduleHearing)
Create Case (LiabilitySample_createCase)
Assign Resource (Organization_assignLocationResource)
Assign Resource (Organization_assignResource)
Remove Resource (Organization_cancelLocationResource)
Delete Resource (Organization_cancelResource)
New Resource (Organization_createLocationResource)
Edit Resource (Organization_modifyLocationResourceFromList)
Edit Resource (Organization_modifyLocationResourceFromView)
Edit Resource (Organization_modifyResourceFromList)
Edit Resource (Organization_modifyResourceFromView)
Issue Agreement (OutcomePlanAgreement_issueEmail)
Issue Agreement (OutcomePlanAgreement_issueEmailOrPost)
Issue Agreement (OutcomePlanAgreement_issuePost)
Issue Agreement (OutcomePlanAgreement_reissueEmail)
Issue Agreement (OutcomePlanAgreement_reissueEmailOrPost)
Issue Agreement (OutcomePlanAgreement_reissuePost)
New Referral (OutcomePlanCollaborationPreselectedReferralWizard_details)
New Referral: (OutcomePlanCollaborationPreselectedReferralWizard_factors)
New Referral (OutcomePlanCollaborationPreselectedReferralWizard_notification)
OutcomePlanCollaborationPreselectedReferralWizard_provider
OutcomePlanCollaborationPreselectedReferralWizard_sharing
New Referral (OutcomePlanCollaborationReferralWizard_details)
New Referral (OutcomePlanCollaborationReferralWizard_factors)
New Referral (OutcomePlanCollaborationReferralWizard_notification)
OutcomePlanCollaborationReferralWizard_provider
New Referral (OutcomePlanCollaborationReferralWizard_service)
OutcomePlanCollaborationReferralWizard_sharing
New Referral (OutcomePlanPreselectedReferralWizard_details)
New Referral: (OutcomePlanPreselectedReferralWizard_factors)
New Referral (OutcomePlanPreselectedReferralWizard_notification)
OutcomePlanPreselectedReferralWizard_provider
New Referral (OutcomePlanReferralWizard_details)
New Referral (OutcomePlanReferralWizard_factors)
New Referral (OutcomePlanReferralWizard_notification)
OutcomePlanReferralWizard_provider
New Referral (OutcomePlanReferralWizard_service)
Print Pro Forma Communication (Participant_confirmModifyPrintForProFormaCommunication)
Print Pro Forma Communication (Participant_confirmModifyPrintForProFormaCommunication1)
Preview Pro Forma Communication (Participant_confirmPreviewForProFormaCommunication)
Print Pro Forma Communication (Participant_confirmPrintForProFormaCommunication)
New Free Form Communication (Participant_createFreeFormCommunication)
Reverse Line Item (Participant_createLineItemReversal)
New Pro Forma Communication (Participant_createProFormaCommunication)
New Pro Forma Communication (Participant_createProFormaCommunication1)
Edit Pro Forma Communication (Participant_modifyProFormaCommunicationFromList1)
Edit Pro Forma Communication (Participant_modifyProFormaCommunicationFromView1)
Edit Pro Forma Communication (Participant_modifySentProFormaCommunicationFromList)
Edit Pro Forma Communication (Participant_modifySentProFormaCommunicationFromView)
View Pro Forma Communication (Participant_viewProFormaCommunication)
Reactivate Case (ProductDelivery_reactivate)
Suspend Case (ProductDelivery_suspend)
Unsuspend Case (ProductDelivery_unsuspend)
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)
Print Pro Forma Communication (ProviderManagement_confirmPrintProFormaCommunication)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
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 Referral (ProviderManagement_editReferralNotificationsNotSent)
Edit Referral (ProviderManagement_editReferralNotificationsSent)
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)
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 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)
Preview Contract (ProviderManagement_previewContract)
Print Contract (ProviderManagement_printContract)
New Referral (ProviderManagement_referralWizardAddDetails)
New Referral (ProviderManagement_referralWizardAddNotification)
ProviderManagement_referralWizardAddProvider
New Referral (ProviderManagement_referralWizardAddService)
ProviderManagement_referralWizardLinkAddProvider
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)
Register External Party (RegisterExternalParty_registerWizard)
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)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)
Print Contract (ServicePlanDelivery_printContract)
Print Contract (ServicePlanDelivery_savePrintContract)
Print Pro Forma Communication (SocalEnterpriseFolder_confirmPrintProFormaCommunication)
New Pro Forma Communication (SocialEnterpriseFolder_createProFormaCommunication)
Edit Pro Forma Communication (SocialEnterpriseFolder_modifyProFormaCommunication)
Modify Pro Forma Communication: (SocialEnterpriseFolder_modifyProFormaCommunicationFromView)
Reactivate Case (TBBCCProductDelivery_reactivate)
Suspend Case (TBBCCProductDelivery_suspend)
Unsuspend Case (TBBCCProductDelivery_unsuspend)