Table Description
Intake Program Application Case Link: Represents a relationship between a intake program application made by a citizen, and a case created for that citizen.
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::WorkspaceServices::Entity::Intake::IntakeProgramAppCaseLink::IntakeProgramAppCaseLink
Controlling File: WorkspaceServices\model\Packages\Entity\IntakeApplicationCaseLink\IntakeApplicationCaseLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
intakeProgramAppCaseLinkIDkeynoUnique ID for this record.INTAKE_APP_CASE_LINK_ID SVR_INT64
intakeProgramApplicationIDdetailsnoReference to the program application made by a citizen.INTAKE_PROGRAM_APPLICATION_ID SVR_INT64
caseIDdetailsnoReference to a case created for a citizen.CASE_ID SVR_INT64
Foreign Keys (2)
ChildParent
IntakeProgramAppCaseLink.caseIDCaseHeader.caseID
IntakeProgramAppCaseLink.intakeProgramApplicationIDIntakeProgramApplication.intakeProgramApplicationID
Indices (2)
Index NameAttributes
IND__1380337097caseID
IND__962534529intakeProgramApplicationID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: intakeProgramAppCaseLinkID
Standard Operation 
readread Standard Operation 
searchByCaseIDreadmulti   
searchByIntakeProgramApplicationIDreadmulti   
readByProgAppCasensread   
removeremove Standard Operation 
Related Pages (68)
Authorize Application (ApplicationAuthorisation_createNew)
Authorize Application (ApplicationAuthorisation_useExistingAnyClientsMatchOrCreateNew)
Authorize Application (ApplicationAuthorisation_useExistingExactClientsMatch_reuseIC)
Authorize Application (ApplicationAuthorisation_useExistingExactClientsMatch_selectIC)
Authorize Application (ApplicationAuthorisation_useExistingExactClientsMatchOrCreateNew)
Add Client (CommonIntake_addClient)
Add Program (CommonIntake_addProgram)
Check Eligibility (CommonIntake_applicationCaseConfirmCheckEligibilty)
CommonIntake_applicationCaseDetails
Home (CommonIntake_applicationCaseHome)
CommonIntake_applicationCaseHomeContextPanel
Remove Client (CommonIntake_cancelApplicationClient)
New Application Case (CommonIntake_createApplicationCaseForConcernRole)
Reopen Program (CommonIntake_createProgramReopening)
New Referral (CommonIntake_createReferralApplicationCaseForConcernRole)
Deny Program (CommonIntake_denyProgram)
Edit Application (CommonIntake_editApplicationCase)
Edit Withdrawal (CommonIntake_editProgramOnlineWithdrawal)
Edit Withdrawal (CommonIntake_editProgramWithdrawal)
Find Client (CommonIntake_findClient)
Find Match (CommonIntake_findMatch)
CommonIntake_listAppCaseByOwnerDetails
Applications (CommonIntake_listApplicationCaseByConcernRole)
Current Clients (CommonIntake_listApplicationCurrentClients)
Denials (CommonIntake_listApplicationDenials)
Reopen Details (CommonIntake_listApplicationRopenings)
Withdrawals (CommonIntake_listApplicationWithdrawals)
PCR (CommonIntake_listCasePCR)
Eligibility Checks (CommonIntake_listEligibilityChecks)
HCR Applications (CommonIntake_listHCRApplicationCaseByConcernRole)
New Application Form (CommonIntake_listInternalIntakePrograms)
New Application Form (CommonIntake_listInternalIntakeProgramsForST)
Programs (CommonIntake_listPrograms)
New Program Appeal (CommonIntake_listProgramsToAppeal)
Applications (CommonIntake_listReferralCaseByConcernRole)
CommonIntake_listReferralCaseByOwnerDetails
Edit Reopen Details (CommonIntake_modifyProgramReopenDetails)
Withdrawal Details (CommonIntake_readProgramWithdrawal)
CommonIntake_referralCaseDetails
Select Match (CommonIntake_selectMatchConfirmation)
Authorization (CommonIntake_viewApplicationAuthorization)
Withdraw Program (CommonIntake_withdrawProgram)
Program Summary (Eligibility_createProgram)
Eligibility Result (Eligibility_viewResults)
Eligibility Result (Eligibility_viewResultsFromIC)
Disable Shopping Experience (HealthCare_disableCaseMotivation)
Enable Shopping Experience (HealthCare_enableCaseMotivation)
Navigators Assisted (HealthCare_listNavigatorsAssisted)
New Withdrawal Request (Intake_createWithdrawalRequest)
Medical Assistance with Spend Down Eligibility Result (ISP_viewMedicalAssistanceWithSDEligibilityDetails)
Medical Assistance with Spend Down Retroactive Eligibility Result (ISP_viewRetroactiveMedicalAssistanceWithSDEligibilityDetails)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Authorize Program (ProgramAuthorisation_anyClientSelectICOrCreateNewAndSelectClients)
Authorize Program (ProgramAuthorisation_createNew)
Authorize Program (ProgramAuthorisation_createNewAndSelectClients)
Authorize Program (ProgramAuthorisation_forICAndOP)
Authorize Program (ProgramAuthorisation_listExistingCasesAnyClientMatch)
Authorize Program (ProgramAuthorisation_selectICOrCreateNewAndSelectClients)
Authorize Program (ProgramAuthorisation_useExistingAnyClientsMatch_reuseIC)
Authorize Program (ProgramAuthorisation_useExistingAnyClientsMatch_reuseICAndSelectClients)
Authorize Program (ProgramAuthorisation_useExistingAnyClientsMatch_selectIC)
Authorize Program (ProgramAuthorisation_useExistingAnyClientsMatchOrCreateNew)
Authorize Program (ProgramAuthorisation_useExistingExactClientsMatch_reuseIC)
Authorize Program (ProgramAuthorisation_useExistingExactClientsMatch_reuseICAndSelectClients)
Authorize Program (ProgramAuthorisation_useExistingExactClientsMatch_selectIC)
Authorize Program (ProgramAuthorisation_useExistingExactClientsMatch_selectICAndClients)
Authorize Program (ProgramAuthorisation_useExistingExactClientsMatchOrCreateNew)