Table Description
ISP Assistance Unit Processing: Stores the details of the different combinations of household members that can be used to make assistance units for Medical Assistance.

A processing table used to keep track of the assistance units that are currently being assessed by some product workflow instance. It is set up before the workflow starts for a product and cleared down at the end of the workflow instance.
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::Processing::ISPAssistanceUnitProc::ISPAssistanceUnitProc
Controlling File: ISProduct\model\Service Layer\entity\Processing\ISPAssistanceUnitProc\ISPAssistanceUnitProc_cat.efx
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
assistanceUnitIDkeynoA system generated unique identifier for an ISP assistance unit processing.ISP_ASSISTANCE_UNIT_ID SVR_INT64
caseIDdetailsnoThe caseID to which the assistance unit processing refers.CASE_ID SVR_INT64
unitIDdetailsnoThe caseID to which the assistance unit processing refers.ISP_UNIT_ID SVR_INT32
caseParticipantRoleIDdetailsnoA case participant role ID of the household member in the assistance unit processing.CASE_PARTICIPANT_ROLE_ID SVR_INT64
instanceIDdetails The current workflow instance.ISP_ASSISTANCE_INSTANCE_ID SVR_INT64
assistanceUnitTypedetailsyesDefines the type of unit the assistance unit is, i.e. LIFC, Refugee, etc.ISP_ASSISTANCE_UNIT_TYPEAssistanceUnitTypeSVR_STRING<10>
Foreign Keys (2)
ChildParent
ISPAssistanceUnitProc.caseIDCaseHeader.caseID
ISPAssistanceUnitProc.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (3)
Index NameAttributes
casEvTreIDUntIDIdxcaseID, unitID
instanceIDIndxcaseID, unitID, instanceID
IND__1507765203caseParticipantRoleID
Operations (14)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: assistanceUnitID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeByCaseIDnsremove   
searchISPAssistanceUnitProcByCETIDUnitIDnsreadmulti Retrieves a list of household members representing a single assistance unit combination 
removeISPAssistanceUnitProcByCETIDUnitIDnsremove Removes a list of household members representing a single assistance unit combination 
searchByCaseIDUnitIDInstanceIDnsreadmulti Retrieves a list of household members representing a single assistance unit combination for a given case ID and instance ID. 
readISPAssistanceUnitProcByCaseIDnsreadmulti Retrieve list of assistance unit records by case id. 
searchCasesByGroupCodeAndDatesnsmulti  SQL
searchCaseByTypeIDAndReceivedDatensmulti Search Existing programs by product type and dateSQL
searchRetroactiveByTypeIDAndReceivedDatensmulti Search for Retroactive programs by product type and date. Retroactive only case is identified as a case which starts in the past and ends in the past relative to its registration date.SQL
clearCaches    
searchByCaseIDAndUnitTypensmulti A method to return a list of assistance units based on the case id and the unit type. The returned is ordered by the unit id.SQL
modifyUnitIDAnDTypeDetailsnsmodify This is a method to update an assistance unit's unit id and type details. 
Related Pages (27)
Check Eligibility (CheckEligibility)
Check Eligibility (CheckMAEligibility)
Check Eligibility (CheckMAEligibilityFromIC)
Renew Chip Product Delivery (Chip_RenewProductDelivery)
Program Summary (Eligibility_createProgram)
Eligibility Result (Eligibility_viewResults)
Eligibility Result (Eligibility_viewResultsFromIC)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromICHome)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromPDHome)
Check Retroactive Spend Down Eligibility (ISP_checkRetroactiveSpendDownEligibility_fromlistRetroSDPeriods)
Check Medical Assistance Eligibility with Spend Down (ISP_checkSpendDownEligibility)
Check Medical Assistance Eligibility with Spend Down (ISP_checkSpendDownEligibilityFromCurrent)
Check Medical Assistance Eligibility with Spend Down (ISP_checkSpendDownEligibilityFromFirstTime)
Check Retroactive Spend Down Eligibility (ISP_checkSpendDownRetroactiveEligibility)
Retroactive Program Summary (ISP_createRetroactiveProgram)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibility)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibilityFromMenu)
Retroactive Medical Assistance Eligibility Request Details (ISP_retroactiveEligibilityRequestDetails)
Medical Assistance Eligibility Result (ISP_viewCurrentChipRenewalEligibilityDetails)
Medical Assistance Eligibility Result (ISP_viewCurrentChipRenewalIneligibleDetails)
Medical Assistance with Spend Down Eligibility Result (ISP_viewMedicalAssistanceWithSDEligibilityDetails)
Medical Assistance Eligibility Result (ISP_viewProductDeliveryRenewEligibilityResult)
Medical Assistance Eligibility Result (ISP_viewProductDeliveryRenewInEligibilityResult)
Medical Assistance with Spend Down Retroactive Eligibility Result (ISP_viewRetroactiveMedicalAssistanceWithSDEligibilityDetails)
Check Retroactive Medical Assistance Eligibility (ISPCheckRetroactiveEligibilityPDHomeFromMenu)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Renew TB Product Delivery (TBBCC_RenewProductDelivery)