Table Description
Application: This entity is used to store data regarding an application for one or more programs.

The Application list is made for the programs applied There is a separate application submited for each program applied. The Application can be resumed for future completion.

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::Intake::IntakeModules::Application::Entity::Application
Controlling File: Intake\model\Packages\IntakeModules\IntakeApplication\Entity\Entity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (19)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
applicationIDkeynoUnique identifier for this record.INTERNAL_ID SVR_INT64
submittedDateTimedetails The date and time that the application was submitted by the citizen.CURAM_DATETIME SVR_DATETIME
filingDatedetails The 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
referencedetails The 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. APPLICATION_REFERENCE SVR_STRING<20>
applicationMethoddetails The method by which the application was received by the agency, e.g. Online or Paper. APPLICATION_METHODApplicationMethodSVR_STRING<10>
rootEntityIDdetailsyesThe unique ID of the root data store entity for this application. Note: A missing foreign key was created for this field in Curam 6.0 SP3. The Allow Nulls on this foreign key field was changed from 'Not Specified' to 'Yes' as this needs to be specifed on creation of the foreign key. However this should be 'No' but to prevent upgrade impact, the constraint could not be tightened from 'Not Specified' to 'No'.APPLICATION_ROOT_ENTITY_ID SVR_INT64
schemaNamedetailsyesThe name of the data store schema under which this application was made. Note: A missing foreign key was created for this field in Curam 6.0 SP3. The Allow Nulls on this foreign key field was changed from 'Not Specified' to 'Yes' as this needs to be specifed on creation of the foreign key. However this should be 'No' but to prevent upgrade impact, the constraint could not be tightened from 'Not Specified' to 'No'.DATASTORE_SCHEMA_NAME SVR_STRING<40>
interpreterReqInddetails 

Indicates whether an interpreter is required for the interview.

BOOLEAN_TYPE SVR_BOOLEAN
interpreterLanguageCodedetails 

The interpreter language required for the interview.

LANGUAGE_CODELanguageSVR_STRING<10>
specialAssistanceInddetails 

Indicates whether the client(s) require special assistance for the interview (recorded on the online application only).

BOOLEAN_TYPE SVR_BOOLEAN
specialAssistanceRequirementsdetails 

Free-form text recording the special requirements of the client(s).

COMMENTS SVR_STRING<300>
applicationTypedetails The Application Type of the application Ex. Income, Unemployement InsuranceAPPLICATION_TYPEApplicationTypeSVR_STRING<10>
currentApplicationStatusIDdetailsyesThe indicator for currentApplicationStatusIDINTERNAL_ID SVR_INT64
pdfIDdetails pdfId to track pdf generationINTERNAL_ID SVR_INT64
caseIDdetailsyesTo Associate the Application with the caseINTERNAL_ID SVR_INT64
referenceAddendumdetails Application reference detailsAPPLICATION_REFERENCE SVR_STRING<20>
iegExecutionIDdetailsyesThe iegExecutionID related to the applicaton ieg script. INTERNAL_ID SVR_INT64
recordStatusdetails  RECORD_STATUS_CODERecordStatusSVR_STRING<10>
assigneedetailsyes USER_NAME SVR_STRING<64>
Foreign Keys (19)
ChildParent
Application.currentApplicationStatusIDApplicationStatus.applicationStatusID
Application.caseIDCaseHeader.caseID
Application.rootEntityIDDatastoreEntity.entityID
Application.schemaNameDatastoreSchema.schemaName
Application.iegExecutionIDIEGExecutionState.executionID
ApplicationCommunicationLink.applicationIDApplication.applicationID
ApplicationInterview.applicationIDApplication.applicationID
ApplicationLink.applicationIDApplication.applicationID
ApplicationRole.applicationIDApplication.applicationID
ApplicationStatus.applicationIDApplication.applicationID
CREOLEProgramRecommendation.applicationIDApplication.applicationID
ClientApplicationLink.applicationIDApplication.applicationID
IntakeApplicant.applicationIDApplication.applicationID
InternalReferral.applicationIDApplication.applicationID
InterviewRequestDate.applicationIDApplication.applicationID
ProgramApplication.applicationIDApplication.applicationID
TransferredApplication.applicationIDApplication.applicationID
WMApplicationSubmitData.applicationIDApplication.applicationID
WMProgRecInstanceData.applicationIDApplication.applicationID
Indices (8)
Index NameAttributes
ApplicationReadByIEGIdxiegExecutionID
ApplnReadByRootEntityIdxrootEntityID
ApplicationReadRefKeyIdxreference
ApplicationAssigneeIdxassignee
ApplicationCurrAppStatusIDIdxcurrentApplicationStatusID
ApplicationAppTypeIdxapplicationType
ApplicationCaseIDIdxcaseID
IND_1241642555schemaName
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: applicationID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
readByReferencensread Method to read the IntakeApplication record by reference. 
readByRootEntityIDnsread Reads an IntakeApplication record by it's datastore root entity ID 
readByExecutionIDreadmulti   
searchByCaseIDreadmulti   
searchByConcernRoleIDnsmulti  SQL
searchByApplicationTypereadmulti   
searchByConcernRoleNamensmulti  SQL
searchByAssignedToUserRolensmulti  SQL
Related Pages (171)
Select Program Denials (Appeal_selectAppealableProgram)
Select Program Denials (Appeal_selectProgramDenialsForHearing)
Select Program Denials (Appeal_selectProgramDenialsForHearingReview)
Select Program Denials (Appeal_selectProgramDenialsForJudicialReview)
Add Client (Application_AddClientConfirmation)
Application_ClientDetails
Reassign Application (Application_confirmChangeOwnerToMe)
Reassign Application (Application_confirmReassigment)
Edit Document (Application_controlMSWord1)
New Attachment (Application_createAttachment)
New MS Word Communication (Application_createMSWordCommunicationCaseMember)
Edit (Application_editApplicationDetails)
Edit Date Added (Application_editClientDetails)
Edit Program Request Date (Application_editProgramApplicationDetails)
New Email Communication (Application_getEmailCorrespondent)
New MS Word Communication (Application_getMSWordCorrespondentCaseMember)
New Pro Forma Communication (Application_getProFormaCorrespondent)
Record Communication (Application_getRecordCommCorrespondent)
Related Cases (Application_listActionableExistingCasesByApplication)
Advisement (Application_listAdvisements)
Appeals (Application_listAppeals)
Communications (Application_listCommunication)
Communications (Application_listCommunication1)
Related Cases (Application_listExistingCasesByApplication)
Ineligibility Period (Application_listPeriodOfIneligibilities)
Match Client (Application_matchClientConfirmation)
Edit Attachment (Application_modifyAttachmentFromList)
New Owner (Application_modifyOwner)
Edit User Role (Application_modifyOwnerDetails)
) (Application_participantNewReferral)
Ready For Determination (Application_readyForDetermination)
Record Communication (Application_recordCommunication)
Remove Client (Application_removeClientConfirmation)
Application_smartPanel
Transfer Application (Application_transferApplicationToExistingCase)
Undo Transfer Application (Application_undoTransferApplicationToExistingCase)
View User Role Details (Application_viewRole)
Work Eligibility (Application_workEligibility)
History (Application_workEligibilityHistory)
History (Application_WorkEligibilityHistoryDetails)
Incoming Evidence (ApplicationAdvancedEvidenceSharing_listIncomingEvidence)
Attachments (ApplicationAttachments)
Clients (ApplicationClients)
ApplicationContextPanel
Application Details (ApplicationDefaultPreviewPanel)
Dashboard (ApplicationEvidence_dashboard)
Dashboard (ApplicationEvidence_dashboardWithFilter)
Verifications (ApplicationEvidence_listAllVerificationsForCase)
Issues (ApplicationEvidence_listIssuesForCase)
Verifications (ApplicationEvidence_listVerificationsForCase)
Active Evidence (ApplicationEvidence_workspaceActiveHighLevel)
Evidence (ApplicationEvidence_workspaceEvidenceHighLevel)
In Edit Evidence (ApplicationEvidence_workspaceInEditHighLevel)
Incoming Evidence (ApplicationEvidenceBroker_listIdenticalIncomingEvidenceFromETab)
Application Details (ApplicationISCompletePreviewPanel)
Application Details (ApplicationISDisposedPreviewPanel)
Application Details (ApplicationISInprogressPreviewPanel)
Opening Microsoft Word Document (ApplicationParticipant_controlMSWord)
Edit Recorded Communication (ApplicationParticipant_modifyRecordedCommunicationFromList)
Programs (ApplicationPrograms)
Programs (ApplicationPrograms1)
Notes (ApplicationQuickNotes)
Applications (ApplicationSearch_TabDetails)
Applications (ApplicationSearch_TabDetails1)
Home (ApplicationSummary)
Timers (ApplicationTimers)
Add Attachment (ApplicationVerificationApplication_addAttachmentForItem)
Add Proof (ApplicationVerificationApplication_createVerificationItemProvision)
Edit Attachment Details (ApplicationVerificationApplication_modifyAttachmentDetails)
CAProductHomeDetails
CGISSApplicationContextPanel
CGISSApplicationContextPanel1
Check Eligibility (CheckEligibility)
Check Eligibility (CheckMAEligibility)
Check Eligibility (CheckMAEligibilityFromIC)
Grace Period (CHIP_listGracePeriod)
New Grace Period (CHIPCreole_createGracePeriod)
Grace Period (CHIPCreole_listGracePeriod)
CHIPProductHomeDetails
CREOLECAProductHomeDetails
CREOLECHIPProductHomeDetails
CREOLEFAProductHomeDetails
CREOLEMAProductHomeDetails
Deny (CREOLEProgramRecommendation_confirmDenyProgramApplication)
Eligibility Checks (CREOLEProgramRecommendation_listProgramRecommendationsForApplication)
Eligibility Checks (CREOLEProgramRecommendation_listProgramRecommendationsForApplication1)
Review Eligibility Results (CREOLEProgramRecommendation_readLatestForApplication)
Check Eligibility (CREOLEProgramRecommendation_selectProgramsForApplication)
Eligibility Checks (Eligibility_listExistingEligibleResults)
FAProductHomeDetails
Add Program (Intake_addProgramApplication)
Application Summary: (Intake_applicationSummary)
Interviews (Intake_calendarView)
Cancel Interview (Intake_cancelInterview)
Confirm Withdrawal Request (Intake_confirmProgramWithdrawalRequest)
Confirm Withdrawal Request (Intake_confirmProgramWithdrawalRequestFromTask)
Save Application (Intake_confirmSaveApplicationScriptExecution)
Save Application: (Intake_confirmSaveApplicationScriptExecutionForCase)
Save Application: (Intake_confirmSaveApplicationScriptExecutionForCaseSubmit)
New Application (Intake_confirmSaveApplicationScriptExecutionFromScript)
New Interview (Intake_createInterview)
Withdraw Program Request (Intake_createProgramWithdrawalRequest)
Withdraw Program Request (Intake_createProgramWithdrawalRequest1)
Reopen Program Application (Intake_createReopening)
Edit Interview (Intake_editInterview)
Edit Special Requirement (Intake_editSpecialRequirement)
Invite Attendees (Intake_inviteAttendee)
Cases (Intake_listActionableIndividualExistingCasesByConcernRole)
Applications (Intake_listApplications)
Applications (Intake_listApplicationsForPerson)
PCR (Intake_listCasePCR)
Cases (Intake_listIndividualExistingCasesByConcernRole)
Notes (Intake_listLifeEventQuickNotes)
Select Program Denials (Intake_listProgramsToAppeal)
Notes (Intake_ListScreeningQuickNotes)
Notes (Intake_ListTriageQuickNotes)
Intake_quickSearch
Interviews (Intake_viewInterview)
Interviews (Intake_viewInterview1)
IS Applications (IntakePerson_listApplicationsForPerson)
IS Applications (IntakeProspectPerson_listApplicationsForPerson)
Home (IntakeSummary_listDetails)
Work Eligibility (IntegratedCase_caParticipationWorkEligibility)
Work Eligibility (IntegratedCase_faParticipationWorkEligibility)
Referrals (InternalReferral_listReferralsForApplication)
Referrals (InternalReferralWizard_clients)
) (InternalReferralWizard_office)
Add Household Member (ISAddMemberWizard_employmentDetails)
Add Household Member (ISAddMemberWizard_participantDetails)
Add Household Member (ISAddMemberWizard_programDetails)
Add Household Member (ISAddMemberWizard_relationshipDetails)
Add Household Member (ISAddMemberWizard_summaryDetails)
ISP_listApplications
Guided Change (ISPApplication_listCompletedGuidedChange)
Guided Change (ISPApplication_listGuidedChange)
Application Details (ISPApplicationISCompletePreviewPanel)
Application Details (ISPApplicationISDisposedPreviewPanel)
ISPCaseHomeDetails
LIFCProductHomeDetails
LTCProductHomeDetails
Applications (MyApplications_TabDetails)
Home (Person_homePagePDC)
Applications (Person_listApplicationsForPerson)
ProductHomeDetails
Authorize (ProgramRecommendation_confirmAuthorize)
Deny (ProgramRecommendation_confirmDenyProgramApplication)
Decline (ProgramRecommendation_decline)
Authorize (ProgramRecommendation_listHouseholdMembersForMA)
Eligibility Checks (ProgramRecommendation_listProgramRecommendations)
Eligibility Checks (ProgramRecommendation_listProgramRecommendations1)
Eligibility Checks (ProgramRecommendation_listProgramRecommendationsForApplication)
Eligibility Checks (ProgramRecommendation_listProgramRecommendationsForApplication1)
Eligibility Checks (ProgramRecommendation_listProgramRecommendationsForApplication2)
Eligibility Checks (ProgramRecommendation_listProgramRecommendationsForRetroactiveApplication)
Authorize (ProgramRecommendation_readLatestForApplication)
Retroactive (ProgramRecommendation_retroactiveEligibility)
Check Eligibility (ProgramRecommendation_selectProgramsForApplication)
Home (ProspectPerson_homePagePDC)
Applications (ProspectPerson_listApplicationsForPerson)
RefugeeProductHomeDetails
New Application (RightsAndResponsibilities)
Application (RightsAndResponsibilitiesForAdditionalCase)
Application (RightsAndResponsibilitiesForCase)
Application (RightsAndResponsibilitiesForCaseSubmit)
New Application (RightsAndResponsibilitiesFromApplicationsList)
New Application (RightsAndResponsibilitiesFromScript)
SpendDownProductHomeDetails
Assign to user (TaskAllocationToUser)
TBBCCProductHomeDetails
Results: (WorkQueue_determinationTabDetails)
Results: (WorkQueue_TabDetails)