Table Description
AppCaseEligibilityResult: Stores the results of the eligibility check. When the user selects to check the client's eligibility for a program, the results for that program are stored on this table.

Example

James Smith has a Social Benefits application case for Food Allowance and Rent Allowance. The worker processing the application checks eligibility for both programs. The eligibility check determines that James is eligible for both programs, and that he will receive $200 per month for Food Allowance and $100 per month for Rent Allowance. The results of the eligibility check for each program are stored and can be viewed by the worker at any time.
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::ApplicationCaseCheckEligibility::AppCaseEligibilityResult
Controlling File: CommonIntake\model\Packages\Entity\ApplicationCaseEligibilityResult.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
appCaseEligibilityResultIDkeynoUnique identifier of the Application Case Eligibility Result.INTERNAL_ID SVR_INT64
caseIDdetailsnoUnique identifier for the Application Case.CASE_ID SVR_INT64
createdBydetailsnoThe name of the user who created the eligibility record.USER_NAME SVR_STRING<64>
createdDateTimedetailsnoThe date and time that the eligibility record was created.CURAM_DATETIME SVR_DATETIME
programIDdetailsnoThe unique identifier of the intake program application record for which eligibility is being checked. INTERNAL_ID SVR_INT64
appCaseEligibilityResultDataIDdetailsnoThe identifier of the record that stores the check eligibility results in XML format.INTERNAL_ID SVR_INT64
decisiondetailsnoThe eligibility decision determined by the rules execution.APPLICATION_CASE_ELIGIBILITY_RESULTAppCaseEligibilityResultSVR_STRING<10>
entitlementdetailsyesThe entitlement for the program determined by the rules execution.ELIGIBILITY_CHECK_ENTITLEMENT SVR_STRING<5000>
Foreign Keys (4)
ChildParent
AppCaseEligibilityResult.appCaseEligibilityResultDataIDAppCaseEligibilityResultData.appCaseEligibilityResultDataID
AppCaseEligibilityResult.caseIDCaseHeader.caseID
AppCaseEligibilityResult.programIDProgramType.programTypeID
AppCaseEligibilityResult.createdByUsers.userName
Indices (4)
Index NameAttributes
ApCaseElResCaseIdxcaseID
IND__426217340appCaseEligibilityResultDataID
IND__101553383programID
IND_1465598425createdBy
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: appCaseEligibilityResultID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByCaseIDreadmulti   
Related Pages (3)