Table Description
Benefit Evidence: The benefit evidence 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::ISBenefitEvidence::ISBenefitEvidence
Controlling File: ISScreening\model\Packages\Service Layer\Entity\ISBenefitEvidence_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
isBenefitEvidenceIDkeynoThe system generated unique identifier of a BenefitEvidence record.IS_BENEFIT_EVIDENCE_ID SVR_INT64
participantRoleIDdetailsnoThe concernRoleID of the household member for whom the benefit evidence is recorded.CONCERN_ROLE_ID SVR_INT64
benefitTypeCodedetails The type of benefit the household member is currently receiving.BENEFIT_TYPE_CODEBenefitTypeCodeSVR_STRING<10>
benefitCaseNodetails The case number of benefit the household member is currently receiving.REFERENCE_NUMBER SVR_STRING<20>
benefitFromDatedetails The date on which the household member started receiving the benefit.CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
ISBenefitEvidence.participantRoleIDConcernRole.concernRoleID
Indices (1)
Index NameAttributes
IND__337255639participantRoleID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: isBenefitEvidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readByKeyParticipantRoleIDnsread To retrieve all isBenefitEvidence records for a specific participantRoleID. 
readByKeyParticipantRoleIDTypensread To retrieve all isBenefitEvidence records of a specified type for a specific participantRoleID 
validateDetails  Validates ISBenefitEvidence details prior to insert and modify. 
Related Pages (13)