Table Description
Household Relationship Evidence: Household relationship 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::ISHholdRshipEvidence::ISHholdRshipEvidence
Controlling File: ISScreening\model\Packages\Service Layer\Entity\ISHholdRshipEvidence_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
isHholdRshipEvidenceIDkeynoThe system generated unique identifier of a HouseholdRelationshipEvidence record.IS_HHOLD_RSHIP_EVIDENCE_ID SVR_INT64
nonParentCaretakerRelInddetails Indicates if the household member for whom the relationship is recorded is a non parent caretaker relative.CURAM_INDICATOR SVR_BOOLEAN
recipISHholdRshipEvidenceIDdetails The isHholdRshipEvidenceID of the reciprocal relationship evidence recordIS_HHOLD_RSHIP_EVIDENCE_ID SVR_INT64
participantRoleRshipIDdetailsno CONCERN_ROLE_RELATIONSHIP_ID SVR_INT64
Foreign Keys (1)
ChildParent
ISHholdRshipEvidence.participantRoleRshipIDConcernRoleRelationship.concernRoleRelationshipID
Indices (1)
Index NameAttributes
IND__1861069865participantRoleRshipID
Operations (17)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: isHholdRshipEvidenceID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readNonParentCaretakerRelns Retrieves the non parent caretaker relative indicator for a ISHholdRshipEvidence record.SQL
modifyRecipRshipEvidenceIDnsmodifyOPTIMISTIC_LOCKING: yes
Operation to modify the recipISHholdRshipEvidenceID attribute on the ISHholdRshipEvidence record 
searchByCaseEvidenceGroupIDParticipantRoleIDnsmulti Method to return a list of household relationships for a specified participant and caseEvidenceGroupIDSQL
readByParticipantRoleRelationshipIDnsread   
readEvidenceDetailsns A Method that will return the details of the household relationship evidence.SQL
searchByCEGIDParticipantRoleIDRshipTypeCodensmulti Method to read the relationship evidence based on the case evidence group code, the participant role Id and the relationship type code.SQL
searchByCEGIDParticipantRoleIDAndRshipTypeCodesnsmulti Method to read the relationship evidence based on the case evidence group code, the participant role Id and by relationship type code one or two.SQL
searchByCEGroupIDParticipantRoleIDAndNPCRnsmulti Read all the evidence by the case evidence group id, participant role id and the NPCR indicatorSQL
searchByCaseEvidenceGroupIDnsmulti Read all the Household Relationship Records based on the case evidence group idSQL
readByCaseEvidenceGroupIDParticipantRoleID  @superseded - replaced by searchByCaseEvidenceGroupIDParticipantRoleID 
readByCEGIDParticipantRoleIDRshipTypeCode  @superseded - replaced by searchByCEGIDParticipantRoleIDRshipTypeCode 
readByCEGIDParticipantRoleIDAndRshipTypeCodes  @superseded - replaced by searchByCEGIDParticipantRoleIDAndRshipTypeCodes 
readByCEGroupIDParticipantRoleIDAndNPCR  @superseded - replaced by searchByCEGroupIDParticipantRoleIDAndNPCR 
readByCaseEvidenceGroupID  @superseded - replaced by searchByCaseEvidenceGroupID 
Related Pages (16)