Table Description
Household Evidence: The household evidence details for a household.
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 Screening::Service Layer::Entity::ISHouseholdEvidence::ISHouseholdEvidence
Controlling File: ISScreening\model\Packages\Service Layer\Entity\ISHouseholdEvidence_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (19)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
isHouseholdEvidenceIDkeynoThe system generated unique identifier of a HouseholdEvidence record.IS_HOUSEHOLD_EVIDENCE_ID SVR_INT64
participantRoleIDdetailsnoThe concernRoleID of the household member for whom the household evidence is captured.CONCERN_ROLE_ID SVR_INT64
disabledInddetails Indicates if the household member is disabledCURAM_INDICATOR SVR_BOOLEAN
pregnantInddetails Indicates if the household member is pregnantCURAM_INDICATOR SVR_BOOLEAN
pregnancyDueDatedetails The expected delivery date of the household memberCURAM_DATE SVR_DATE
studentInddetails Indicates if the household member is a studentCURAM_INDICATOR SVR_BOOLEAN
studentGraduationDatedetails The expected graduation date of the studentCURAM_DATE SVR_DATE
prepareMealsInddetails Indicates if the household member prepares meals with the head of the householdCURAM_INDICATOR SVR_BOOLEAN
migrantFarmworkerInddetails Indicates if the household member is a migrant or seasonal farmworkerCURAM_INDICATOR SVR_BOOLEAN
headOfHouseholdInddetails Indicates if the household member is the head of the household.CURAM_INDICATOR SVR_BOOLEAN
citizenshipCodedetails The household members citizenshipCITIZENSHIP_CODECitizenshipCodeSVR_STRING<10>
ssnApplicationStatusdetails The status of the household members SSN Application.IS_SSN_APPLICATION_STATUSSSNApplicationStatusSVR_STRING<10>
natAlaskOrAmerInddetails Indicates if the household members race is a native Alaskan or an American Indian.CURAM_INDICATOR SVR_BOOLEAN
asianInddetails Indicates if the household members race is Asian.CURAM_INDICATOR SVR_BOOLEAN
natHawOrPacIslInddetails Indicates if the household members race is native hawaiian or pacific islanderCURAM_INDICATOR SVR_BOOLEAN
whiteOrCaucInddetails Indicates if the household members race is white or CaucasianCURAM_INDICATOR SVR_BOOLEAN
blkOrAfrAmerInddetails Indicates if the household members race is black or African-American.CURAM_INDICATOR SVR_BOOLEAN
veteranStatusdetails The veteran status of the household memberIS_VETERAN_STATUSISVeteranStatusSVR_STRING<10>
recordStatusdetails The status of the household evidence record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
ISHouseholdEvidence.participantRoleIDConcernRole.concernRoleID
Indices (1)
Index NameAttributes
IND__75027727participantRoleID
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: isHouseholdEvidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
modifyStatusCodensmodifyOPTIMISTIC_LOCKING: yes
To modify the status code of the household evidence record. 
readByKeyParticipantRoleIDnsread To read a HouseholdEvidence record for a specific household member. 
readISHouseholdParticipantRoleIDns Retrieves the participant role ID corresponding to a particular ISHouseholdEvidence record.SQL
readHeadOfHouseholdns Retrieves the head of household indicator for a ISHouseholdEvidence record.SQL
validateDetails  Validates ISHouseholdEvidence details prior to insert and modify. 
readIDByCaseEvidenceGroupAndParticipantns This method will determine if a specified participant is a member of a particular household and return the identifier for the household evidence if the participant is a member.SQL
readByCaseEvidenceGroupIDAndParticipantRoleIDns Method to read the dependent child household evidence detailsSQL
countByCaseEvidenceTreeIDAndEvidenceTypens Returns the number of evidence records in the tree of the particular evidence type.SQL
Related Pages (37)
Delete Household Evidence Details: (IncomeSupportScreening_cancelISHouseholdEvidence)
Check Eligibility: (IncomeSupportScreening_checkEligibility)
Transfer Evidence: (IncomeSupportScreening_confirmTransferEvidence)
Confirm Appointment: (IncomeSupportScreening_createAppointment)
Capture Head of Household Details: (IncomeSupportScreening_createCase)
New Dependent Care Expense Evidence Details: (IncomeSupportScreening_createDependentCareExpenseEvidence)
New Income Evidence Details: (IncomeSupportScreening_createIncomeEvidence)
New Benefit Evidence Details: (IncomeSupportScreening_createISBenefitEvidence)
New Household Member Details: (IncomeSupportScreening_createISHouseholdEvidence)
New Relationships For: (IncomeSupportScreening_createISHouseholdRshipEvidence)
New Medicaid Evidence Details: (IncomeSupportScreening_createISMedicaidEvidence)
New Medical Expense Evidence Details: (IncomeSupportScreening_createMedicalExpenseEvidence)
New Resource Evidence Details: (IncomeSupportScreening_createResourceEvidence)
New Shelter Expense Evidence Details: (IncomeSupportScreening_createShelterExpenseEvidence)
Household Members: (IncomeSupportScreening_enterISHouseholdEvidence)
Eligibility Summary Communication: (IncomeSupportScreening_generateEligibilitySummaryComm)
Home: (IncomeSupportScreening_home)
Select Household Member: (IncomeSupportScreening_listHouseholdMembersForRelationships)
Household Members: (IncomeSupportScreening_listISHouseholdEvidence)
Modify Dependent Care Expense Evidence Details: (IncomeSupportScreening_modifyDependentCareExpenseEvidenceFromList)
Modify Dependent Care Expense Evidence Details: (IncomeSupportScreening_modifyDependentCareExpenseEvidenceFromView)
Modify Income Evidence Details: (IncomeSupportScreening_modifyIncomeEvidenceFromList)
Modify Income Evidence Details: (IncomeSupportScreening_modifyIncomeEvidenceFromView)
Modify Benefit Evidence Details: (IncomeSupportScreening_modifyISBenefitEvidenceFromList)
Modify Benefit Evidence Details: (IncomeSupportScreening_modifyISBenefitEvidenceFromView)
Modify Household Member Details: (IncomeSupportScreening_modifyISHouseholdEvidenceFromList)
Modify Household Member Details: (IncomeSupportScreening_modifyISHouseholdEvidenceFromView)
Modify Medicaid Evidence Details: (IncomeSupportScreening_modifyISMedicaidEvidenceFromList)
Modify Medicaid Evidence Details: (IncomeSupportScreening_modifyISMedicaidEvidenceFromView)
Modify Medical Expense Evidence Details: (IncomeSupportScreening_modifyMedicalExpenseEvidenceFromList)
Modify Medical Expense Evidence Details: (IncomeSupportScreening_modifyMedicalExpenseEvidenceFromView)
Modify Resource Evidence Details: (IncomeSupportScreening_modifyResourceEvidenceFromList)
Modify Resource Evidence Details: (IncomeSupportScreening_modifyResourceEvidenceFromView)
Modify Shelter Expense Evidence Details: (IncomeSupportScreening_modifyShelterExpenseEvidenceFromList)
Modify Shelter Expense Evidence Details: (IncomeSupportScreening_modifyShelterExpenseEvidenceFromView)
View Household Member Details: (IncomeSupportScreening_readISHouseholdEvidence)
Select the Head of the Household (IncomeSupportScreening_transferEvidence)