Table Description

Household Relationship: This evidence captures the details of a relationship between two household members who live in the same household.

The relationship of a household member to all other household members is captured to determine the possible eligible groups that exist within the household. When a new relationship record is inserted, the system will automatically insert a reciprocal relationship record for the related household member. Additional details specific to the case are captured on the Household Relationship evidence record, for example, whether or not the household member is a non-parent caretaker relative.

Example

A case worker creates a Household Member Relationship record for Linda Smith. Linda Smith is married to John Smith so a relationship of spouse is recorded between Linda Smith and John Smith. The reciprocal relationship record showing that John Smith is the spouse of Linda Smith is automatically created by the system. Linda Smith and John Smith are part of the same 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::Evidence::Service Layer::Entity::Household::HouseholdRelationship::HouseholdRelationship
Controlling File: Evidence\model\ServiceLayer\entity\Household\HouseholdRelationship\HouseholdRelationship_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Household Relationship. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
concernRoleRelationshipIDdetailsno

The unique identifier of the concernRoleRelationship record.

CONCERN_ROLE_RELATIONSHIP_ID SVR_INT64
nonParentCareRelInddetails Indicates if the individual is a non parent caretaker relative.CURAM_INDICATOR SVR_BOOLEAN
dependentInddetails 

Indicates if there is a dependency between an adult and a child. The UI field name for this attribute is 'Related Participant is a Dependent'.

CURAM_INDICATOR SVR_BOOLEAN
partnerInddetails 

Indicates if the related individuals consider themselves partners. There is no UI field for this attribute.

CURAM_INDICATOR SVR_BOOLEAN
recipHholdRelationshipIDdetailsyes

The key of the reciprocal household relationship. The UI field for this attribute is 'Relationship Type'.

EVD_HHOLD_RELATIONSHIP_ID SVR_INT64
commentsdetails 

Additional details related to the Household Relationship evidence. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
HouseholdRelationship.concernRoleRelationshipIDConcernRoleRelationship.concernRoleRelationshipID
Indices (1)
Index NameAttributes
evdHouseholdRelationshipconcernRoleRelationshipID
Operations (15)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
searchByConcernRoleRelIDreadmulti Reads a list of Income Support Product Household Relationship records associated with a specified concernRoleRelationshipID. 
modifyRecipRelationshipEvidencensmodify Modifies the reciprocal relationship evidence record by inserting the recipHholdRelationshipID. 
searchByRelationshipTypensmulti Searches for any relationships of a specific type that a household member has with other members of the household.SQL
searchByNPCRStatusnsmulti Searches for any NPCR relationships that a household member has with other members of the household.SQL
readNPCRDependentDetailsns Retrieve the NPCR indicator, Dependent indicator and participantRoleID of the related person.SQL
searchExistingConcernRoleRelationshipsnsmulti This method searches for existing concern role relationships between household members.SQL
readHholdRelationshipIDByConcernRoleRelationshipIDnsread This operation reads the evidenceID for an HouseholdRelationship record by the concernRoleRelationshipID. 
readNPCRHouseholdAndSpouseConcernRoleIDns This method returns the the details of the spouse of a non parent caretaker relative within the household.SQL
searchExistingConcernRoleRelationshipsByStatusnsmulti This method searches for existing concern role relationships between household members by status code.SQL
listRelationshipEvidenceForCreatePagensmulti Method to return the existing relationship details of relationship type, related member and nonParentCareRelativeInd for a household member.SQL
transferEvidence    
Related Pages (32)
Check Eligibility (CheckEligibility)
Check Eligibility (CheckMAEligibility)
Check Eligibility (CheckMAEligibilityFromIC)
Renew Chip Product Delivery (Chip_RenewProductDelivery)
New Household Relationship Evidence (EVD_addToCaseHouseholdRelationshipEvidence_sa)
New Household Relationship Evidence (EVD_addToCaseHouseholdRelationshipEvidence_wzSelAllCre)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
New Household Relationship Evidence (EVD_createHouseholdRelationshipEvidence_sa)
New Household Relationship Evidence (EVD_createHouseholdRelationshipEvidence_wzSelAllCre)
Edit Household Relationship Evidence (EVD_incomingModifyHouseholdRelationshipEvidence)
Edit Household Member Evidence (EVD_modifyHouseholdMemberEvidence)
Edit Household Relationship Evidence (EVD_modifyHouseholdRelationshipEvidence)
View Household Relationship Evidence (EVD_viewHouseholdRelationshipEvidence)
View Household Relationship Evidence (EVD_viewHouseholdRelationshipEvidenceHistRec)
Home (EVD_viewHouseholdRelationshipEvidenceObject)
View Household Relationship Evidence (EVD_viewHouseholdRelationshipEvidenceSnapshot)
Related Persons (Intake_listRelatedPerson)
Person Search Results (Intake_personSearchResult)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
Add Household Member (ISAddMemberWizard_summaryDetails)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromICHome)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromPDHome)
Check Retroactive Spend Down Eligibility (ISP_checkSpendDownRetroactiveEligibility)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibility)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibilityFromMenu)
Check Retroactive Medical Assistance Eligibility (ISPCheckRetroactiveEligibilityPDHomeFromMenu)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Re-add a Member (ISReAddMemberWizard_submit)
Renew TB Product Delivery (TBBCC_RenewProductDelivery)