Table Description

Boarder: This evidence captures details of a Household Member who pays compensation to the household for lodging and meals.

Boarders are individuals that live with the household and pay the household for lodgings and meals. A roomer is an individual who pays for lodgings but does not eat with the household.

Example

A case worker creates a Boarder record for John Kelly who is residing in Linda Smith's household. John Kelly receives 2 meals as part of his boarding arrangement. John Kelly is paying for lodging and meals.
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::Boarder::Boarder
Controlling File: Evidence\model\ServiceLayer\entity\Household\Boarder\Boarder_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

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

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The name (or rather, the Case Participant Role ID) of the Household Member who is a Boarder. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
residenceTypedetails 

The type of residence that the Boarder is staying in. Examples include 'Commercial Boarding House', 'Private Residence', 'Others', etc. The UI field name for this attribute is 'Residence Type'.

EVD_RESIDENCE_TYPEResidenceTypeSVR_STRING<10>
numberOfMealsdetails 

The number of meals that are included in the rent. The UI field name for this attribute is 'Number of Meals'.

EVD_NUMBER_OF_MEALS SVR_INT16
amountPaiddetails 

The amount paid by the Boarder to the household for rent and meals. The UI field name for this attribute is 'Amount Paid'.

CURAM_AMOUNT SVR_MONEY
paymentFrequencydetails 

This field specifies how often payments are made by the Boarder to the household. The UI field name for this attribute is 'Payment Frequency'.

FREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
inclInAppInddetails 

Indicates if the Boarder is to be included in the application for benefit, that the household is submitting. The UI field name for this attribute is 'Include In Application'.

CURAM_INDICATOR SVR_BOOLEAN
commentsdetails 

Details relating to a Boarder. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
startDatedetails 

The date from which the Boarder started living in that residence. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The date until which the Boarder lived in the residence. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
Boarder.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND_1504289416caseParticipantRoleID
Operations (6)
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 
readBoarderAndParticipantRoleDetailsns Method for reading boarder evidence and the participantRoleID of the boarder.SQL
readCaseParticipantsByEvidenceIDnsread   
Related Pages (13)