Table Description

Student Expense: This evidence captures details about an educational expense incurred by a household member.

Types of student expenses include: books, transportation, tuition, mandatory school fees, including the rental or purchase of any equipment, material, and supplies related to the pursuit of the course of study involved.

Student expenses may only be recorded for Household Members who are students.

For certain programs Student Expenses may be deductible from educational income. Education income less any deductions is a countable income.

Example


Linda Smith is in full time education at a vocational school. Linda Smith must pay school fees and purchase books for school every year. A case worker creates Student Expense records for Linda Smith with details of the expenses she has incurred.

Model Details
Location in Model: Logical View::MetaModel::Curam::Evidence::Service Layer::Entity::Expenses::StudentExpense::StudentExpense
Controlling File: Evidence\model\ServiceLayer\entity\Expenses\StudentExpenses\StudentExpenses_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

Unique reference number assigned by the system to the Student Expense record. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
studentExpenseTypedetails 

The type of expense, examples include: Books, Supplies, etc. This is populated from the 'StudentExpenseType' code table. The UI field name for this attribute is 'Student Expense Type'.

EVD_STUDENT_EXPENSE_TYPEStudentExpenseTypeSVR_STRING<10>
amountdetails 

The amount of the expense. The UI field name for this attribute is 'Amount'.

CURAM_AMOUNT SVR_MONEY
frequencyCodedetails 

'The frequency at which the expense occurs. Examples include: Monthly, Daily, etc. This is populated from the 'FrequencyCode' code table. The UI field name for this attribute is 'Frequency'.

FREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
commentsdetails 

Additional details related to Student Expense. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
reimbursedAmountdetails 

The amount which was reimbursed to the Household Member. The UI field name for this attribute is 'Reimbursed Amount'.

CURAM_AMOUNT SVR_MONEY
reimbursementTypedetails 

The type of expense reimbursement. Examples include: Federal Assistance Program, Insurance Company, etc. This is populated from the 'ReimbursementType' code table. The UI field name for this attribute is 'Reimbursed Type'.

EVD_EXPENSE_REIMBURSEMENT_TYPEReimbursementTypeSVR_STRING<10>
startDatedetails 

The date from which the Student Expense started. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The date till which the Student Expense was incurred. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
Operations (5)
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 
readAmtAndFrequencyDetailsnsread Method to read the expense amount and frequency code for a specific student expense record. 
Related Pages (23)
New Income Allocation Evidence (EVD_addToCaseIncomeAllocationEvidence_wzSelAllCre)
New Income Allocation Evidence (EVD_addToCaseIncomeAllocationEvidence_wzSelAllCrePAR)
New Income Allocation Evidence (EVD_addToCaseIncomeAllocationEvidence_wzSelAllCrePRE)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
New Income Allocation Evidence (EVD_createIncomeAllocationEvidence_wzSelAllCre)
New Income Allocation Evidence (EVD_createIncomeAllocationEvidence_wzSelAllCrePAR)
New Income Allocation Evidence (EVD_createIncomeAllocationEvidence_wzSelAllCrePRE)
Edit Income Allocation Evidence (EVD_incomingModifyIncomeAllocationEvidence)
Edit Household Member Evidence (EVD_modifyHouseholdMemberEvidence)
Edit Income Allocation Evidence (EVD_modifyIncomeAllocationEvidence)
View Income Allocation Evidence (EVD_viewIncomeAllocationEvidence)
View Income Allocation Evidence (EVD_viewIncomeAllocationEvidenceHistRec)
Home (EVD_viewIncomeAllocationEvidenceObject)
View Income Allocation Evidence (EVD_viewIncomeAllocationEvidenceSnapshot)
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)