Table Description
IntakeProgramApplication: An application made by a citizen for a program. 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 created.

Example

James Smith submits a Social Benefits application form for Rent Allowance and Food Allowance programs online. When he submits the application form, an IntakeProgramApplication record is created for the Rent Allowance and Food Allowance programs that he is applying for.
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::IntakeProgramApplication::IntakeProgramApplication
Controlling File: WorkspaceServices\model\Packages\Entity\IntakeProgramApplication\IntakeProgramApplication_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
intakeProgramApplicationIDkeynoUnique identifier for this record.INTAKE_PROGRAM_APPLICATION_ID SVR_INT64
intakeApplicationIDdetailsnoA reference to the intake application that was created in response to the receipt of an application form, e.g. an intake application is created on submission of an online application from the Citizen Portal. INTAKE_APPLICATION_ID SVR_INT64
programTypeIDdetailsnoA reference to the program for which the citizen is applying. PROGRAM_TYPE_ID SVR_INT64
statusdetailsnoThe status of the intake program application, e.g. Pending, Approved, Denied, Authorized. INTAKE_PROGRAM_APPLICATION_STATUSIntakeProgApplStatusSVR_STRING<10>
denialReasondetailsyesThe reason why this application for the program was denied. INTAKE_PROGRAM_APPLICATION_DENIAL_REASONIntakeProgApplDenyReasonSVR_STRING<10>
enteredByUserdetails The user that entered this intake program application.USER_NAME SVR_STRING<64>
disposedDateTimedetails The date time the application was disposed.CURAM_DATETIME SVR_DATETIME
deadlineDatedetails The date before which the program application must be disposed, e.g. a decision (disposition) must be reached within five days of the filing date. CURAM_DATE SVR_DATE
submittedDateTimedetailsnoThe date time the program application was made. CURAM_DATETIME SVR_DATETIME
dateProgramAddeddetailsyesThe date on which the program was added to the application case. This is set to the application date for programs associated when the application is submitted online or internally.CURAM_DATE SVR_DATE
Foreign Keys (10)
ChildParent
IntakeProgramApplication.intakeApplicationIDIntakeApplication.intakeApplicationID
IntakeProgramApplication.programTypeIDProgramType.programTypeID
AuthorisationDataLog.programIDIntakeProgramApplication.intakeProgramApplicationID
IntakeProgramAppCaseLink.intakeProgramApplicationIDIntakeProgramApplication.intakeProgramApplicationID
IntakeProgramMilestoneLink.intakeProgramApplicationIDIntakeProgramApplication.intakeProgramApplicationID
ProgramAuthorisationData.programIDIntakeProgramApplication.intakeProgramApplicationID
ProgramDenial.intakeProgramApplicationIDIntakeProgramApplication.intakeProgramApplicationID
ProgramReopenInfo.intakeProgramApplicationIDIntakeProgramApplication.intakeProgramApplicationID
WMAuthorisationInstanceData.intakeProgramApplicationIDIntakeProgramApplication.intakeProgramApplicationID
WithdrawalRequest.intakeProgramApplicationIDIntakeProgramApplication.intakeProgramApplicationID
Indices (5)
Index NameAttributes
IPAIAStatusIdxintakeApplicationID, status
INTKPRGAPPIDX2status
INTKPRGAPPIDX1submittedDateTime
IND_197782962enteredByUser
IND__979117550programTypeID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: intakeProgramApplicationID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByIntakeApplicationreadmulti   
searchByIntakeApplicationAndStatusreadmulti Retrieves IntakeProgramApplications for a specific IntakeApplication and status 
searchByUsernameAndStatusreadmulti Searches by username and status 
searchByIntakeApplicationAndTargetSystemnsmulti Returns list of intake program application for a given intake application which will be processed at specified target system.SQL
searchByProgramTypeStatusAndConcernRolereadmultiWHERE: programTypeID = :programTypeID and status = :status and intakeApplicationID in ( select intakeApplicationID from IntakeAppConcernRoleLink where concernRoleID = :concernRoleID )
  
Related Pages (101)
Authorize Application (ApplicationAuthorisation_createNew)
Authorize Application (ApplicationAuthorisation_forICAndOP)
Authorize Application (ApplicationAuthorisation_useExistingAnyClientsMatchOrCreateNew)
Authorize Application (ApplicationAuthorisation_useExistingExactClientsMatch_reuseIC)
Authorize Application (ApplicationAuthorisation_useExistingExactClientsMatch_selectIC)
Authorize Application (ApplicationAuthorisation_useExistingExactClientsMatchOrCreateNew)
Intake Home (ApplicationHome)
Intake Home (ApplicationHomeDetails)
Applications Home (ApplicationsHome)
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)
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 And Approve Timer Extension (CommonIntake_editAndApproveTimerExtension)
Edit Application (CommonIntake_editApplicationCase)
Edit Date Program Added (CommonIntake_editProgramDateAdded)
Edit Withdrawal (CommonIntake_editProgramOnlineWithdrawal)
Edit Withdrawal (CommonIntake_editProgramWithdrawal)
Extend Timer (CommonIntake_extendTimers)
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)
HCR Applications (CommonIntake_listHCRApplicationCaseByConcernRole)
New Application Form (CommonIntake_listInternalIntakePrograms)
New Application Form (CommonIntake_listInternalIntakeProgramsForST)
Programs (CommonIntake_listPrograms)
CommonIntake_listProgramsDueByOwner
New Program Appeal (CommonIntake_listProgramsToAppeal)
Applications (CommonIntake_listReferralCaseByConcernRole)
CommonIntake_listReferralCaseByOwnerDetails
Timers (CommonIntake_listTimers)
Edit Reopen Details (CommonIntake_modifyProgramReopenDetails)
Withdrawal Details (CommonIntake_readProgramWithdrawal)
CommonIntake_referralCaseDetails
Select Match (CommonIntake_selectMatchConfirmation)
Submit Application Form (CommonIntake_submitApplicationForm)
Authorization (CommonIntake_viewApplicationAuthorization)
Withdraw Program (CommonIntake_withdrawProgram)
Program Summary (Eligibility_createProgram)
Eligibility Result (Eligibility_viewResults)
Eligibility Result (Eligibility_viewResultsFromIC)
Submit Application (HCR_finishInternalIntakeScriptRenewal)
Disable Shopping Experience (HealthCare_disableCaseMotivation)
Enable Shopping Experience (HealthCare_enableCaseMotivation)
Navigators Assisted (HealthCare_listNavigatorsAssisted)
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)
View Withdrawal Request (Intake_viewWithdrawalRequest)
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)
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)