Table Description
ApplicationCaseLink: Application Case Link record maintains the relationship between active integrated cases and intake application cases.

Used by the system to determine which active integrated case an intake application case is assocaited with.

Example
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::Income Support Product::Service Layer::entity::IntakeApplication::ApplicationCaseLink::ApplicationCaseLink
Controlling File: ISProduct\model\Service Layer\entity\IntakeApplication\ApplicationCaseLink\ApplicationCaseLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
activeCaseLinkIDkeynoSystem generated unique identifier for the Application Case Link record.INTERNAL_ID SVR_INT64
caseIDdetailsnoThe active integrated case ID for the associated intake application case ID.CASE_ID SVR_INT64
intakeApplicationIDdetailsnoThe intake application case ID for the associated active integrated case.INTAKE_APPLICATION_ID SVR_INT64
Foreign Keys (2)
ChildParent
ApplicationCaseLink.caseIDCaseHeader.caseID
ApplicationCaseLink.intakeApplicationIDIntakeApplication.intakeApplicationID
Indices (2)
Index NameAttributes
applCaseLinkIndexintakeApplicationID
searchByCaseIDIndexcaseID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: activeCaseLinkID
Used to insert the active case link record. 
readread Used to read the active case link record. 
modifymodify Used to modify the active case link record. 
removeremove Used to remove the active case link record. 
searchByIntakeApplicationIDreadmulti Used to search by application intake ID and get the associated active case ID. 
searchByCaseIDreadmulti This method returns a list of application records associated with the integrated case 
Related Pages (29)
Intake Home (ApplicationHome)
Intake Home (ApplicationHomeDetails)
Applications Home (ApplicationsHome)
Check Eligibility (CheckEligibility)
Check Eligibility (CheckMAEligibility)
Check Eligibility (CheckMAEligibilityFromIC)
Remove Applicant (confirmDeleteApplicant)
Eligibility Result (Eligibility_viewResults)
Confirm Withdrawal Request (Intake_confirmWithdrawalRequest)
New Withdrawal Request (Intake_createWithdrawalRequest)
Related Persons (Intake_listRelatedPerson)
Merge Duplicate (Intake_mergeProspectToPersonSummary)
Person Search Results (Intake_personSearchResult)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
View Withdrawal Request (Intake_viewWithdrawalRequest)
New Interview Details (Interview_create)
Interview List (Interview_list)
Modify Interview Details (Interview_modify)
View Interview Details (Interview_view)
Medical Assistance with Spend Down Eligibility Result (ISP_viewMedicalAssistanceWithSDEligibilityDetails)
Medical Assistance with Spend Down Retroactive Eligibility Result (ISP_viewRetroactiveMedicalAssistanceWithSDEligibilityDetails)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Basic Intake Information (ISPIntakeInformation_createWithIntegratedCase)
Applications Home (ListApplicationsByUser)
Applications (listApplicationsForIntegratedCase)
Add Primary Applicant (listRemoveApplicant)