Table Description
Assistance Unit Selection: A CHIP product delivery assistance unit.

The assistance unit selection processing entity is used to store and process the assistance unit members selected during the creation of a CHIP product delivery 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::Income Support Product::Service Layer::entity::CHIP::Processing Entities::AssistanceUnitSelection::AssistanceUnitSelection
Controlling File: ISProduct\model\Service Layer\entity\CHIP\Processing Entities\AssisstanceUnitSelection\AssistanceUnitSelection_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (17)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
assistanceUnitSelectionIDkeynoSystem generated unique identifier for the assistance unit selection.ISP_ASSISTANCE_UNIT_SELECTION_ID SVR_INT64
userNamedetailsnoCurrently working user name.USER_NAME SVR_STRING<64>
unitNodetails Assistance unit number.ISP_UNIT_NO SVR_INT16
integratedCaseIDdetailsnoIntegrated case ID to which this selection record is related to.CASE_ID SVR_INT64
caseIDdetails Created product delivery case ID.CASE_ID SVR_INT64
primaryParticipantIDdetails Primary participant selected for the assessment unit.CONCERN_ROLE_ID SVR_INT64
caseDecisionIDdetails Check eligibility workflow result case decision ID.CASE_DECISION_ID SVR_INT64
selectedMembersdetails Tab delimited list of selected participant role ID's for the assistance unit.ISP_PARTICIPANT_TAB_LIST SVR_STRING<1024>
exemptMembersdetails Tab delimited list of exempt participant role ID's for the assistance unit.ISP_PARTICIPANT_TAB_LIST SVR_STRING<1024>
numOfAssesUnitMembersdetails Number of members in the assessment unit.ISP_NUMBER_OF_MEMBERS SVR_INT16
premiumAmountdetails Calculated premium amount.CURAM_AMOUNT SVR_MONEY
premiumPlanLeveldetails Determined premium plan level.ISP_PREMIUM_PLAN_LEVELPremiumPlanLevelSVR_STRING<10>
frequencydetails Determined premium frequency.FREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
householdIncomedetails Household gross income minus deductions.CURAM_AMOUNT SVR_MONEY
householdIncomeLimitdetails Federal Poverty Level income limit for the assessment unit.CURAM_AMOUNT SVR_MONEY
maxCoPayLimitdetails Determined Co-payment limit.CURAM_AMOUNT SVR_MONEY
recordStatusdetails Assistance unit selection record status.ISP_ASSISTANCE_UNIT_RECORD_STATUSAssistUnitRecordStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
AssistanceUnitSelection.integratedCaseIDCaseHeader.caseID
AssistanceUnitSelection.userNameUsers.userName
Indices (4)
Index NameAttributes
AstUntCaseIdxcaseID
IND_459887717userName
IND_1590597613integratedCaseID
IND_494179702caseDecisionID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: assistanceUnitSelectionID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByUserAndStatusreadmulti Retrieves assistance units by user and record status specified. 
searchByCaseAndStatusreadmulti Retrieves assistance units by case ID and record status specified. 
searchByIntCaseAndStatusreadmulti Retrieves assistance units by integrated case ID and record status specified. 
searchByIntCaseUserAndStatusreadmulti Retrieves assistance units by integrated case ID, user and record status specified. 
searchByDecisionUserAndStatusreadmulti Retrieves assistance units by case decision ID, user and record status specified. 
Related Pages (49)
Add Member (addGroupMemberLIFC)
Add Member (addGroupMemberRefugee1)
Add Member (CHIPProduct_addAssistanceGroupMember)
Add Member (CHIPProduct_addBenefitGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Assistance (CHIPProduct_listAssistanceGroupMember)
Assistance (CHIPProduct_listBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Program Summary (Eligibility_createProgram)
Eligibility Result (Eligibility_viewResults)
Check Retroactive Spend Down Eligibility (ISP_checkSpendDownRetroactiveEligibility)
Renew Program (ISP_confirmProgramRenewal)
Retroactive Program Summary (ISP_createRetroactiveProgram)
Renew Program (ISP_renewProductDeliveryConfirmation)
Select Assistance Unit Members (ISP_selectChipAssistanceUnitMemberForRenewal)
Select Assistance Unit Members (ISP_selectChipAssistanceUnitMembers)
Retroactive Medical Assistance Eligibility Result (ISP_viewCurrentRetroactiveMedicalAssistanceEligibilityResults)
Retroactive Spend Down Eligibility Result (ISP_viewCurrentRetroactiveSpendDownEligibilityResults)
Medical Assistance with Spend Down Eligibility Result (ISP_viewMedicalAssistanceWithSDEligibilityDetails)
View Premium and Co-Payment Limit (ISP_viewPremiumAndCoPaymentLimit)
View Premium and Co-Payment Limit (ISP_viewPremiumAndCoPaymentLimitForRenewal)
Medical Assistance with Spend Down Retroactive Eligibility Result (ISP_viewRetroactiveMedicalAssistanceWithSDEligibilityDetails)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Reuse Program (ISPSpendDown_reuseProgram)
Reuse Program (ISPSpendDown_reuseRetroactiveProgram)
Select Application Date (ISPSpendDown_selectApplicationDate)
Assistance (ISPSpendDownProduct_listBenefitGroupMembers)
Financial (ISPSpendDownProduct_listFinancialGroupMembers)
Member (ISPSpendDownProduct_listGroupMembers)
Assistance (LIFCProduct_listBenefitGroupMembers)
Financial (LIFCProduct_listFinancialGroupMembers)
Assistance (listBenefitGroupMembers)
Financial (listFinancialGroupMembers)
Member (listGroupMembers)
Member (listGroupMembersLIFC)
Member (listGroupMembersLTC)
Member (listGroupMembersRefugee)
Member (listGroupMembersTBBCC)
Member (listPreviousCurrentGroupMembersLIFC)
Member (listPreviousCurrentGroupMembersRefugee)
Assistance (LTCProduct_listBenefitGroupMembers)
Financial (LTCProduct_listFinancialGroupMembers)
Assistance (RefugeeProduct_listBenefitGroupMembers)
Financial (RefugeeProduct_listFinancialGroupMembers)
Remove Member (removeGroupMember)
Assistance (TBBCC_listBenefitGroupMembers)
Financial (TBBCC_listFinancialGroupMembers)