Table Description
ApplicationCaseAdmin: An application case is used to process an application for a program. This entity is used to store the configuration details of an application case. When an application for a program is submitted, an application case is created. This entity stores details which dictate the behaviour of that application case.

Example

An organization delivers Rent Allowance and Food Allowance programs to citizens. Both program applications are processed using a Social Benefits application case.
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::CommonIntake::CommonIntake::Entity::ApplicationCaseAdmin::ApplicationCaseAdmin
Controlling File: CommonIntake\model\Packages\Entity\ApplicationCaseAdmin.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (42)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
applicationCaseAdminIDkeynoUnique identifier for the Application Case Administration.INTERNAL_ID SVR_INT64
evidenceIssuesEnabledIndicatordetailsyesAn indicator to dictate if the Evidence Issues page is included in the application case.CURAM_BOOLEAN_TYPECuramBooleanTypeSVR_STRING<10>
verEnabledIndicatordetailsyesAn indicator to dictate if the Verification details are included in the application case.CURAM_BOOLEAN_TYPECuramBooleanTypeSVR_STRING<10>
nameTextIDdetailsnoThe identifier of the localizable name of the application case.INTERNAL_ID SVR_INT64
eligibilityCheckRulesetIDdetailsyesThe identifier of the ruleset used to check program eligibility.INTERNAL_ID SVR_INT64
homePagedetailsyesThe application case home page to be used. If not specified a default application case home page (and therefore tab) is used. PAGE_IDENTIFIER SVR_STRING<200>
eligibilityCheckStrategydetailsyesThe strategy to be used when checking a client's eligibility for programs associated with an application. This is only applicable when the Eligibility Check Rule Set is specified.ELIGIBILITY_CHECK_STRATEGYEligibilityCheckStrategySVR_STRING<10>
evidenceDashboardEnabledInddetailsnoAn indicator to dictate if the evidence dashboard page is included in the evidence page group. CURAM_INDICATOR SVR_BOOLEAN
directCreationAllowedInddetailsnoAn indicator to dictate if this type of application case can be created directly from a New Application Case modal dialog rather than as a result of the execution of an internal application (IEG) script.CURAM_INDICATOR SVR_BOOLEAN
rdyForDeterminStateEnabledInddetailsnoAn indicator to dictate if the Ready For Determination state is to be used within the application case. CURAM_INDICATOR SVR_BOOLEAN
programAuthorizationStrategydetailsnoThe strategy to be used when authorizing a program. PROGRAM_AUTHORIZATION_STRATGEYProgramAuthorizeStrategySVR_STRING<10>
programAuthorizationRulesetIDdetailsyesThe identifier of the rule set used for program authorization when the program authorization strategy is 'Application'. INTERNAL_ID SVR_INT64
integratedCaseStrategydetailsyesThis dictates whether the sucessful authorization will result in the creation of a new integrated case or update of an existing integrated case. This must be specified if the Program Authorization Strategy is 'Application'.INTEGRATED_CASE_STRATEGYIntegratedCaseStrategySVR_STRING<10>
applicationCreatedWorkflowdetailsyesThe name of the workflow process that is invoked when an application case is created.WORKFLOW_PROCESS_NAME SVR_STRING<254>
straightThroughWorkflowdetailsyesThe name of the workflow process used to drive straight through processing, i.e. from creation of the application to creation of an ongoing case and closure of the application. If not specified, straight through processing is not undertaken for the application. If specified, this process is invoked upon creation of the application from an online submission if all of the clients have been successfully matched or registered.WORKFLOW_PROCESS_NAME SVR_STRING<254>
readyForDeterminWorkflowdetailsyesThe name of the workflow process that is invoked when the application case enters the Ready for Determination state. This may only be set if the Ready For Determination State Enabled attribute is set to true.WORKFLOW_PROCESS_NAME SVR_STRING<254>
withdrawalRequestWorkflowdetailsyesThe name of the workflow process that is invoked in response to an online request by a citizen to withdraw the application for a particular program.WORKFLOW_PROCESS_NAME SVR_STRING<254>
createdBydetailsnoThe username of the user who created the Application Case.USER_NAME SVR_STRING<64>
creationDatedetailsnoThe date on which the Application Case was created.CURAM_DATE SVR_DATE
recordStatusdetailsnoThe status of the Application Case i.e 'Active' or 'Cancelled'.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
referencedetailsyesThe unique reference of the Application Case Administration.REFERENCE_TEXT SVR_STRING<40>
descriptionTextIDdetailsnoThe identifier of the localizable text description of the application case administration.INTERNAL_ID SVR_INT64
internalOwnerCurrentUserInddetailsnoIndicates that the owner of the application case should be set to the current user, i.e. the one who created the application.CURAM_INDICATOR SVR_BOOLEAN
integratedCaseTypedetailsyesDefines the type of integrated case that is created when autorization is performed at the application level.PRODUCT_CATEGORY_CODEProductCategorySVR_STRING<10>
displayRulesResultsPagedetailsyesThe display page to be used to display the results of an eligibilty check. PAGE_IDENTIFIER SVR_STRING<200>
onlineOwnerOrgObjectRefdetailsyesThe identifier of the organization object which should be set as the owner of an Application Case for online applications.ORGANISATION_OBJECT_REFERENCE_NAME SVR_STRING<100>
onlineOwnerOrgObjectTypedetailsyesThe type of organization object which should be set as the owner of an Application Case for online applications.ORG_OBJECT_TYPEOrgObjectTypeSVR_STRING<10>
internalOwnerOrgObjectRefdetailsyesThe identifier of the organization object which should be set as the owner of an Application Case for internal applications.ORGANISATION_OBJECT_REFERENCE_NAME SVR_STRING<100>
internalOwnerOrgObjectTypedetailsyesThe type of organization object which should be set as the owner of an Application Case for internal applications.ORG_OBJECT_TYPEOrgObjectTypeSVR_STRING<10>
appealAllProgramsInddetailsyesAn indicator to dictate whether programs with a status of Denied can be appealed or whether programs with a status of Pending, Approved and Denied can be appealed from an Application Case.CURAM_INDICATOR SVR_BOOLEAN
issueOwnerOrgObjectRefdetailsyesThe identifier of the organization object which should be set as the owner of an Application Case for online applications.ORGANISATION_OBJECT_REFERENCE_NAME SVR_STRING<100>
issueOwnerOrgObjectTypedetailsyesThe type of organization object which should be set as the owner of an Application Case for internal applications.ORG_OBJECT_TYPEOrgObjectTypeSVR_STRING<10>
resolutionHomePagedetailsyesThe application case home page to be used. If not specified a default application case home page (and therefore tab) is used. PAGE_IDENTIFIER SVR_STRING<200>
pcrIndicatordetailsyesAn indicator to dictate if the PCR details are included in the application case.CURAM_BOOLEAN_TYPECuramBooleanTypeSVR_STRING<10>
eligibilityChecksIndicatordetailsyesAn indicator to dictate if the Eligibility Checks page is included in the application case.CURAM_BOOLEAN_TYPECuramBooleanTypeSVR_STRING<10>
timersIndicatordetailsyesAn indicator to dictate if the Timers page is included in the application case.CURAM_BOOLEAN_TYPECuramBooleanTypeSVR_STRING<10>
outcomePlanTypedetailsyesThe outcome plan type which is created on successful program authorisation. This is used to identify the type of outcome plan to be created when the Authorisation Strategy is Application.INTERNAL_ID SVR_INT64
outcomePlanStrategydetailsyesOn successful program authorization a new outcome plan or an existing outcome plan is updated for program delivery. This field is used to dictate the behaviour.OUTCOME_PLAN_STRATEGYOutcomePlanStrategySVR_STRING<10>
clientSelectionStrategydetailsyesThe strategy to be used when adding clients from the application case to the outcome plan created as a result of authorization of this program.CLIENT_SELECTION_STRATEGYClientSelectionStrategySVR_STRING<10>
clientSelectionRulesetdetailsyesRuleset used for client selection when the Client Selection Strategy is Rules.INTERNAL_ID SVR_INT64
externalOwnerOrgObjectTypedetailsyesThe type of organization object which should be set as the owner of an Application Case for externall applications.ORG_OBJECT_TYPEOrgObjectTypeSVR_STRING<10>
externalOwnerOrgObjectRefdetailsyesThe identifier of the organization object which should be set as the owner of an Application Case for external applications.ORGANISATION_OBJECT_REFERENCE_NAME SVR_STRING<100>
Foreign Keys (6)
ChildParent
ApplicationCaseAdmin.eligibilityCheckRulesetIDCREOLERuleSet.creoleRuleSetID
ApplicationCaseAdmin.programAuthorizationRulesetIDCREOLERuleSet.creoleRuleSetID
ApplicationCaseAdmin.nameTextIDLocalizableText.localizableTextID
ApplicationCaseAdmin.descriptionTextIDLocalizableText.localizableTextID
ApplicationCaseAdmin.createdByUsers.userName
ApplicationCase.applicationCaseAdminIDApplicationCaseAdmin.applicationCaseAdminID
Indices (4)
Index NameAttributes
ApCaseAdStatRefIdxrecordStatus, reference
IND_1644825859nameTextID
IND_857134228descriptionTextID
IND__17664049createdBy
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: applicationCaseAdminID
Standard insert operation. 
readread Standard read operation. 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard modify with optimistc locking enabled operation. 
searchByStatusreadmulti Returns a list of Application Case Administration records for the given status. 
searchByStatusAndReferencereadmulti Returns a list of Application Case Administration records for the given reference and status code. 
Related Pages (54)
Application Search (Application_searchPopup)
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)
Add Program (CommonIntake_addProgram)
CommonIntake_applicationCaseAdminContextPanel
Home (CommonIntake_applicationCaseAdminHome)
Application Cases (CommonIntake_applicationCaseAdminVerificationSearchPopup)
Check Eligibility (CommonIntake_applicationCaseConfirmCheckEligibilty)
Home (CommonIntake_applicationCaseHome)
CommonIntake_applicationCaseHomeContextPanel
CommonIntake_applicationCaseSearch
Delete Application Case (CommonIntake_cancelApplicationCaseAdmin)
New Application Case (CommonIntake_createApplicationCaseAdmin)
New Application Case (CommonIntake_createApplicationCaseForConcernRole)
Reopen Program (CommonIntake_createProgramReopening)
New Referral (CommonIntake_createReferralApplicationCaseForConcernRole)
Deny Program (CommonIntake_denyProgram)
Edit Application (CommonIntake_editApplicationCase)
Edit Application Case (CommonIntake_editApplicationCaseAdmin)
Find Match (CommonIntake_findMatch)
CommonIntake_listApplicationCaseAdmin
Applications (CommonIntake_listApplicationCaseByConcernRole)
Denials (CommonIntake_listApplicationDenials)
Applications (CommonIntake_listApplicationFormByConcernRole)
Check Eligibility (CommonIntake_listEligibilityCheckPrograms)
Eligibility Checks (CommonIntake_listEligibilityChecks)
HCR Applications (CommonIntake_listHCRApplicationCaseByConcernRole)
HCR Applications (CommonIntake_listHCRApplicationFormByConcernRole)
Programs (CommonIntake_listPrograms)
New Program Appeal (CommonIntake_listProgramsToAppeal)
Applications (CommonIntake_listReferralCaseByConcernRole)
Ready For Determination (CommonIntake_readyForDetermination)
CommonIntake_referralCaseSearch
Select Match (CommonIntake_selectMatchConfirmation)
Authorization (CommonIntake_viewApplicationAuthorization)
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)