Table Description

Benefit: Assistance received by a participant, based on a program.

Example

Linda Smith is currently receiving social security disability benefits. Previously Linda Smith had received social security insurance benefits but no longer receives it as she is now receiving social security disability benefits. A case worker creates a Benefit record for the benefit Linda Smith is currently receiving and a Benefit record for the benefit she received in the past.

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::Income::Benefit::Benefit
Controlling File: Evidence\model\ServiceLayer\entity\Income\Benefit\Benefit_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (23)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

The system generated unique identifier for the Benefit. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the participant who is in receipt of the Benefit. This may or may not be a Household Member. The UI field name for this attribute is 'Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
caseNumberdetails 

A reference number for the received benefit. There is no UI field for this attribute.

EVD_CASE_NUMBER SVR_STRING<20>
deliveryTypedetails 

The method of delivery of the benefit. Examples include: Cash, Check, etc. The UI field name for this attribute is 'Delivery Type'.

EVD_DELIVERY_METHOD SVR_STRING<10>
startDatedetails 

The date from which the Benefit was received. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The date until which the Benefit was received. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
benefitTypedetails 

The type of Benefit received. Examples include 'Child Benefit', 'SSI', etc. This is populated from the 'BenefitType' code table. The UI field name for this attribute is 'Benefit Type'.

EVD_BENEFIT_RECEIVEDBenefitTypeSVR_STRING<10>
indianCountryInddetails 

True if the Household Member lived in Indian country, where 50% of adults are unemployed, while in receipt of this benefit. The UI field name for this attribute is 'Indian Country Indicator'.

CURAM_INDICATOR SVR_BOOLEAN
amountdetails 

The Benefit amount delivered. The UI field name for this attribute is 'Deduction Amount'.

CURAM_AMOUNT SVR_MONEY
frequencyCodedetails 

The frequency at which the Benefit is delivered. Examples include: Monthly, Bi-Weekly, etc. This is populated from the 'FrequencyCode' code table. The UI field name for this attribute is 'Frequency'.

FREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
benefitUsagedetails 

Benefits can be considered vendor payments and based on their usage, they can be included or excluded from the income calculations. Examples include: Education, Medical Assistance, etc. This is populated from the 'BenefitUsage' code table. The UI field name for this attribute is 'Benefit Usage'.

EVD_BENEFIT_USAGE_CODEBenefitUsageSVR_STRING<10>
lastPaymentDatedetails 

The date the Benefit was last paid. The UI field name for this attribute is 'Last Payment Date'.

CURAM_DATE SVR_DATE
publicOfficeIDdetails 

The benefit office that dealt with the claim. The UI field name for this attribute is 'Public Office'.

PUBLIC_OFFICE_LOCATION_ID SVR_INT64
payDaydetails 

The day on which the Benefit is paid. Examples include: Monday, Tuesday, etc. This is populated from the 'Day' code table. The UI field name for this attribute is 'Pay Day'.

EVD_DAYDaySVR_STRING<10>
deductionAmountdetails 

The Benefit amount received. The UI field name for this attribute is 'Amount'.

CURAM_AMOUNT SVR_MONEY
aidMobilityInddetails 

Indicates if the Disability Living Allowance received aids mobility. The UI field name for this attribute is 'Aid Mobility Indicator'.

CURAM_INDICATOR SVR_BOOLEAN
aidPersonalCareInddetails 

Indicates if the Disability Living Allowance received aids personal care. The UI field name for this attribute is 'Aid Personal Care Indicator'.

CURAM_INDICATOR SVR_BOOLEAN
commentsdetails 

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

COMMENTS SVR_STRING<300>
statedetails 

The State from which the member received Benefit. Examples include: Utah, New York, etc. This is populated from the 'StateCodes' code table. The UI field name for this attribute is 'State'.

STATE_CODES_CODEStateCodesSVR_STRING<10>
applicationDatedetails 

The date on which the individual applied for the Benefit. The UI field name for this attribute is 'Application Date'.

CURAM_DATE SVR_DATE
ratePayabledetails 

The rate payable for this Benefit. The UI field name for this attribute is 'Rate Payable'.

CURAM_AMOUNT SVR_MONEY
deductionTypedetails 

The type of deduction associated with this Benefit. This is populated from the 'DeductionType' code table. Examples include: Electricity, Gas, etc. This is populated from the 'DeductionType' code table. The UI field name for this attribute is 'Deduction Type'.

EVD_DEDUCTION_TYPEDeductionTypeSVR_STRING<10>
endReasondetails 

The reason the Benefit ended. Such reason can impact a Household Member's eligibility for Medical Assistance. For example, a household member who loses SSI because their unearned income exceeds the SSI limit may still be considered an SSI recipient and therefore eligible for Medical Assistance. Examples include: Excess Unearned Income, Increase SS DAC, etc. This is populated from the 'BenefitEndReason' code table. The UI field name for this attribute is 'End Reason'.

EVD_BENEFIT_END_REASONBenefitEndReasonSVR_STRING<10>
Foreign Keys (1)
ChildParent
Benefit.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND_1331560972caseParticipantRoleID
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 
readParticipantRoleIDByEvidenceIDns Reads the participantRoleID of the case member.SQL
searchBenefitDetailsByParticipantRoleIDAndCaseIDnsmulti search Benefit by ParticipantRoleIDSQL
Related Pages (36)
New Assigned Income Evidence (EVD_addToCaseAssignedIncomeEvidence_wzSelAllCre)
New Assigned Income Evidence (EVD_addToCaseAssignedIncomeEvidence_wzSelAllCrePAR)
New Assigned Income Evidence (EVD_addToCaseAssignedIncomeEvidence_wzSelAllCrePRE)
New Income Trust Schedule Evidence (EVD_addToCaseIncomeTrustScheduleEvidence_sa)
New Income Trust Schedule Evidence (EVD_addToCaseIncomeTrustScheduleEvidence_wzSelAllCre)
New Assigned Income Evidence (EVD_createAssignedIncomeEvidence_wzSelAllCre)
New Assigned Income Evidence (EVD_createAssignedIncomeEvidence_wzSelAllCrePAR)
New Assigned Income Evidence (EVD_createAssignedIncomeEvidence_wzSelAllCrePRE)
New Benefit Evidence (EVD_createBenefitEvidence_sa)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
New Income Trust Schedule Evidence (EVD_createIncomeTrustScheduleEvidence_sa)
New Income Trust Schedule Evidence (EVD_createIncomeTrustScheduleEvidence_wzSelAllCre)
Edit Assigned Income Evidence (EVD_incomingModifyAssignedIncomeEvidence)
Edit Income Trust Schedule Evidence (EVD_incomingModifyIncomeTrustScheduleEvidence)
Assign Income from Benefit To Income Trust (EVD_listBenefitEvidenceForAssignedIncomeEvidence)
Edit Assigned Income Evidence (EVD_modifyAssignedIncomeEvidence)
Edit Benefit Evidence (EVD_modifyBenefitEvidence)
Edit Household Member Evidence (EVD_modifyHouseholdMemberEvidence)
Edit Income Trust Schedule Evidence (EVD_modifyIncomeTrustScheduleEvidence)
View Assigned Income Evidence (EVD_viewAssignedIncomeEvidence)
View Assigned Income Evidence (EVD_viewAssignedIncomeEvidenceHistRec)
Home (EVD_viewAssignedIncomeEvidenceObject)
View Assigned Income Evidence (EVD_viewAssignedIncomeEvidenceSnapshot)
View Income Trust Schedule Evidence (EVD_viewIncomeTrustScheduleEvidence)
View Income Trust Schedule Evidence (EVD_viewIncomeTrustScheduleEvidenceHistRec)
Home (EVD_viewIncomeTrustScheduleEvidenceObject)
View Income Trust Schedule Evidence (EVD_viewIncomeTrustScheduleEvidenceSnapshot)
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)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Re-add a Member (ISReAddMemberWizard_submit)