Table Description
Intake Application: This entity is used to store data regarding an application for one or more programs. When an application is submitted from the Universal Access portal or the case worker application an IntakeApplication record is created. An application may contain one or more programs. As a result of submission of an application, one or more IntakeProgramApplication records are also created.
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::IntakeApplication::IntakeApplication
Controlling File: WorkspaceServices\model\Packages\Entity\IntakeApplication\IntakeApplication_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
Attributes (14)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
intakeApplicationIDkeynoUnique identifier for this record.INTAKE_APPLICATION_ID SVR_INT64
statusdetailsnoRepresents whether the or not the program applications that comprise this application have been disposed.INTAKE_APPLICATION_STATUSIntakeApplicationStatusSVR_STRING<10>
submittedDateTimedetailsyesThe date and time that the application was submitted by the citizen.CURAM_DATETIME SVR_DATETIME
localeCodedetailsyesThe Citizen Portal language selected by the citizen, e.g. English, French etc.LOCALE_CODELocaleSVR_STRING<10>
filingDatedetailsyesThe filing date for the application. This is not necessarily the date on which the application was submitted, e.g. if the application is submitted outside of office hours, the filing date is set to the next working day. CURAM_DATE SVR_DATE
referencedetailsnoThe unique reference number generated for the application. This is presented to the citizen and may be used by the citizen to refer to the application in any further communication with the agency. INTAKE_APPLICATION_REFERENCE SVR_STRING<20>
applicationMethoddetails The method by which the application was received by the agency, e.g. Online or Paper. INTAKE_APPLICATION_METHODIntakeApplicationMethodSVR_STRING<10>
enteredByUserdetails The user name of the person who entered this application.USER_NAME SVR_STRING<64>
intakeApplicationTypeIDdetailsnoA reference to the type of application for which the citizen is applying. INTERNAL_ID SVR_INT64
rootEntityIDdetails The unique ID of the root data store entity for this application.INTAKE_APPLICATION_ROOT_ENTITY_ID SVR_INT64
schemaNamedetails The name of the data store schema under which this application was made.INTAKE_APPLICATION_SCHEMA_NAME SVR_STRING<256>
attachmentIDdetailsyesThe unique ID of the PDF report data generated from the Intake Application.ATTACHMENT_ID SVR_INT64
dataStoreMappingsIDdetailsyesReference to the Data Store CEF Mappings. These are stored as XML in the LinkedString entity. These mapping describe how entities in the data store map to entities in the Curam Enterprise Framework (CEF). For example, during the intake process, the data store entity of type Person with ID 123 maps to the Concern Role with id 356757. INTERNAL_ID SVR_INT64
hasIntakeCheckedExdetailsyesThis optional attribute is set to the value ITYN4001 when the intake process throws a checked exception (as opposed to a runtime exception). Such checked exceptions are caused by conditions such as attribute validation issues that can be corrected by a case worker whereas runtime exceptions must be addressed by a technician.INTAKE_CHECKED_EXIntakeYesNoSVR_STRING<10>
Foreign Keys (13)
ChildParent
IntakeApplication.intakeApplicationTypeIDIntakeApplicationType.intakeApplicationTypeID
IntakeApplication.dataStoreMappingsIDLinkedString.linkedStringID
Applicant.intakeApplicationIDIntakeApplication.intakeApplicationID
ApplicationCaseLink.intakeApplicationIDIntakeApplication.intakeApplicationID
ApplicationForm.intakeApplicationIDIntakeApplication.intakeApplicationID
ApplicationLink.intakeApplicationIDIntakeApplication.intakeApplicationID
IntakeAppCWAccLink.intakeApplicationIDIntakeApplication.intakeApplicationID
IntakeAppConcernRoleLink.intakeApplicationIDIntakeApplication.intakeApplicationID
IntakeApplicationDisposition.intakeApplicationIDIntakeApplication.intakeApplicationID
IntakeInformation.intakeApplicationIDIntakeApplication.intakeApplicationID
IntakeProgramApplication.intakeApplicationIDIntakeApplication.intakeApplicationID
Interview.intakeApplicationIDIntakeApplication.intakeApplicationID
MotivationIntakeAppLink.intakeAppIDIntakeApplication.intakeApplicationID
Indices (6)
Index NameAttributes
IntakeAppIdx1enteredByUser
IntakeAppIdx2reference
IntakeAppIdx3rootEntityID
INTAKEAPPIDX4submittedDateTime
IND_1057171614intakeApplicationTypeID
IND_1832237468dataStoreMappingsID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: intakeApplicationID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readByReferencensread Method to read the IntakeApplication record by reference. 
searchByEnteredByUserAndAppTypereadmulti Searches for submitted user applications 
searchByEnteredByUserreadmulti   
readByRootEntityIDnsread Reads an IntakeApplication record by it's datastore root entity ID 
Related Pages (55)
Intake Home (ApplicationHome)
Intake Home (ApplicationHomeDetails)
Applications Home (ApplicationsHome)
Check Eligibility (CheckEligibility)
Check Eligibility (CheckMAEligibility)
Check Eligibility (CheckMAEligibilityFromIC)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Add Client (CommonIntake_addClient)
Add Program (CommonIntake_addProgram)
Remove Client (CommonIntake_cancelApplicationClient)
New Application Case (CommonIntake_createApplicationCaseForConcernRole)
Reopen Program (CommonIntake_createProgramReopening)
New Referral (CommonIntake_createReferralApplicationCaseForConcernRole)
Delete Application Form (CommonIntake_deleteApplicationForm)
Deny Program (CommonIntake_denyProgram)
Find Client (CommonIntake_findClient)
Find Match (CommonIntake_findMatch)
New Application Form (CommonIntake_listInternalIntakePrograms)
New Application Form (CommonIntake_listInternalIntakeProgramsForST)
Select Match (CommonIntake_selectMatchConfirmation)
Submit Application Form (CommonIntake_submitApplicationForm)
Program Summary (Eligibility_createProgram)
Eligibility Result (Eligibility_viewResults)
Eligibility Result (Eligibility_viewResultsFromIC)
Submit Application Form (HCR_finishInternalIntakeScript)
Submit Application (HCR_finishInternalIntakeScriptRenewal)
Enable Shopping Experience (HealthCare_enableCaseMotivation)
Confirm Withdrawal Request (Intake_confirmProgramWithdrawalRequest)
Confirm Withdrawal Request (Intake_confirmProgramWithdrawalRequestFromTask)
Confirm Withdrawal Request (Intake_confirmWithdrawalRequest)
New Withdrawal Request (Intake_createWithdrawalRequest)
Related Persons (Intake_listRelatedPerson)
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)
New Interview Details (Interview_create)
Modify Interview Details (Interview_modify)
Apply To Period (ISP_ApplyToPeriod)
Medical Assistance with Spend Down Eligibility Result (ISP_viewMedicalAssistanceWithSDEligibilityDetails)
Medical Assistance with Spend Down Retroactive Eligibility Result (ISP_viewRetroactiveMedicalAssistanceWithSDEligibilityDetails)
Basic Intake Information (ISPIntakeInformation_create)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Basic Intake Information (ISPIntakeInformation_createWithIntegratedCase)
Edit Basic Intake Information (ISPIntakeInformation_modify)
Edit Basic Intake Information (ISPIntakeInformation_modifyNoCase)
View Basic Intake Information (ISPIntakeInformation_view)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Applications Home (ListApplicationsByUser)
Applications (listApplicationsForIntegratedCase)