Table Description
Program Application: nbsp; An application form may be submitted for one or more programs. This entity represents an application made for a particular program as part of the receipt of an application form (IntakeApplication).

  An application form may be submitted for one or more programs. This entity represents an application made for a particular program as part of the receipt of an application form (IntakeApplication).

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::ProgramApplication
Controlling File: Intake\model\Packages\IntakeModules\IntakeApplication\Entity\Entity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
programApplicationIDkeynoUnique identifier for this record.INTERNAL_ID SVR_INT64
applicationIDdetailsnoA 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. INTERNAL_ID SVR_INT64
programTypedetails A reference to the program for which the citizen is applying. PROGRAM_TYPEProgramTypeSVR_STRING<10>
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
submittedDateTimedetails The date time the program application was made. CURAM_DATETIME SVR_DATETIME
programRequestDatedetails 

The date time on which the program request was added to the application.

CURAM_DATETIME SVR_DATETIME
programApplicationStatusIDdetailsyesA reference to the current status of this program, PROGRAM_APPLICATION_STATUS_ID SVR_INT64
numWarningDaysdetails The number of working days countNUMBER_OF_DAYS SVR_INT32
Foreign Keys (5)
ChildParent
ProgramApplication.applicationIDApplication.applicationID
ProgramApplication.programApplicationStatusIDProgramApplicationStatus.programApplicationStatusID
ProgramApplicationStatus.programApplicationIDProgramApplication.programApplicationID
ProgramMilestoneLink.programApplicationIDProgramApplication.programApplicationID
ProgramWithdrawalRequest.programApplicationIDProgramApplication.programApplicationID
Indices (2)
Index NameAttributes
ProgAppProgAppStatIDIdxprogramApplicationStatusID
ProgramApplicationAppIDIdxapplicationID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: programApplicationID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByApplicationreadmulti   
readByApplicationProgramTypensread   
searchByApplicationAndProgStatusnsmulti Returns a list of standard program application details structs for the specified application and program application status.SQL
searchByApplicationWithProgramTypeAndStatusnsmulti Returns a list of standard program application details structs for the specified application and program application status.SQL
Related Pages (88)
Select Program Denials (Appeal_selectAppealableProgram)
Select Program Denials (Appeal_selectProgramDenialsForHearing)
Select Program Denials (Appeal_selectProgramDenialsForHearingReview)
Select Program Denials (Appeal_selectProgramDenialsForJudicialReview)
Application_ClientDetails
Reassign Application (Application_confirmChangeOwnerToMe)
Reassign Application (Application_confirmReassigment)
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)
Communications (Application_listCommunication)
Related Cases (Application_listExistingCasesByApplication)
New Owner (Application_modifyOwner)
Ready For Determination (Application_readyForDetermination)
Transfer Application (Application_transferApplicationToExistingCase)
Undo Transfer Application (Application_undoTransferApplicationToExistingCase)
Clients (ApplicationClients)
ApplicationContextPanel
Application Details (ApplicationDefaultPreviewPanel)
Application Details (ApplicationISCompletePreviewPanel)
Application Details (ApplicationISDisposedPreviewPanel)
Application Details (ApplicationISInprogressPreviewPanel)
Programs (ApplicationPrograms)
Programs (ApplicationPrograms1)
Applications (ApplicationSearch_TabDetails)
Applications (ApplicationSearch_TabDetails1)
Home (ApplicationSummary)
CGISSApplicationContextPanel
CGISSApplicationContextPanel1
Deny (CREOLEProgramRecommendation_confirmDenyProgramApplication)
Review Eligibility Results (CREOLEProgramRecommendation_readLatestForApplication)
Check Eligibility (CREOLEProgramRecommendation_selectProgramsForApplication)
Status Details (CREOLEProgramRecommendation_viewProgramApplicationStatusDetails)
Add Program (Intake_addProgramApplication)
Confirm Withdrawal Request (Intake_confirmProgramWithdrawalRequest)
Confirm Withdrawal Request (Intake_confirmProgramWithdrawalRequestFromTask)
New Interview (Intake_createInterview)
Withdraw Program Request (Intake_createProgramWithdrawalRequest)
Withdraw Program Request (Intake_createProgramWithdrawalRequest1)
Reopen Program Application (Intake_createReopening)
Edit Special Requirement (Intake_editSpecialRequirement)
Invite Attendees (Intake_inviteAttendee)
Cases (Intake_listActionableIndividualExistingCasesByConcernRole)
Applications (Intake_listApplications)
Applications (Intake_listApplicationsForPerson)
Cases (Intake_listIndividualExistingCasesByConcernRole)
Select Program Denials (Intake_listProgramsToAppeal)
Withdrawal Details (Intake_listProgramWithdrawalRequests)
View Withdrawals (Intake_listProgramWithdrawalsFromApplicationHome)
Intake_quickSearch
View Withdrawal Request (Intake_viewProgramWithdrawalRequest)
IS Applications (IntakePerson_listApplicationsForPerson)
IS Applications (IntakeProspectPerson_listApplicationsForPerson)
Home (IntakeSummary_listDetails)
Work Eligibility (IntegratedCase_caParticipationWorkEligibility)
Work Eligibility (IntegratedCase_faParticipationWorkEligibility)
Add Household Member (ISAddMemberWizard_employmentDetails)
Add Household Member (ISAddMemberWizard_programDetails)
Add Household Member (ISAddMemberWizard_relationshipDetails)
Add Household Member (ISAddMemberWizard_summaryDetails)
ISP_listApplications
Guided Change (ISPApplication_listGuidedChange)
Application Details (ISPApplicationISCompletePreviewPanel)
Application Details (ISPApplicationISDisposedPreviewPanel)
Applications (MyApplications_TabDetails)
Home (Person_homePagePDC)
Applications (Person_listApplicationsForPerson)
Authorize (ProgramRecommendation_confirmAuthorize)
Deny (ProgramRecommendation_confirmDenyProgramApplication)
Decline (ProgramRecommendation_decline)
Authorize (ProgramRecommendation_listHouseholdMembersForMA)
Authorize (ProgramRecommendation_readLatestForApplication)
Check Eligibility (ProgramRecommendation_selectProgramsForApplication)
Status Details (ProgramRecommendation_viewProgramApplicationStatusDetails)
Home (ProspectPerson_homePagePDC)
Applications (ProspectPerson_listApplicationsForPerson)
New Application (RightsAndResponsibilities)
Application (RightsAndResponsibilitiesForAdditionalCase)
Application (RightsAndResponsibilitiesForCase)
Application (RightsAndResponsibilitiesForCaseSubmit)
New Application (RightsAndResponsibilitiesFromApplicationsList)
New Application (RightsAndResponsibilitiesFromScript)
Assign to user (TaskAllocationToUser)