Table Description

Employment Expense: An employment cost incurred by a participant.

Example

Linda Smith is self employed and running her own business. The business has expenses for advertising costs and wages for employees. A case worker creates Employment Expense records for Linda Smith's business expenses and associates them with Linda Smith's self employment record.
Model Details
Location in Model: Logical View::MetaModel::Curam::Evidence::Service Layer::Entity::Expenses::EmploymentExpense::EmploymentExpense
Controlling File: Evidence\model\ServiceLayer\entity\Expenses\EmploymentExpenses\EmploymentExpenses_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

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

EVIDENCE_ID SVR_INT64
employmentIDdetailsyes

The unique identifier of the related Employment.

EMPLOYMENT_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Household Member. The UI field name for this attribute is 'Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
totalAmountdetails 

The total monetary value of this expense. The UI field name for this attribute is 'Total Amount'.

CURAM_AMOUNT SVR_MONEY
businessAmountdetails 

The monetary value of the business portion of the expense amount, e.g. Advertising Cost. The UI field name for this attribute is 'Business Amount'.

CURAM_AMOUNT SVR_MONEY
frequencyCodedetails 

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

FREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
employmentExpensesTypedetails 

The type of expense. Examples include: Accident and Health Plans, Bad Debt, etc. This is populated from the 'EmploymentExpenseType' code table. The UI field name for this attribute is 'Expense Type'.

EVD_EMPLOYMENT_EXPENSE_TYPEEmploymentExpenseTypeSVR_STRING<10>
commentsdetails 

Additional details related to Employment Expenses. 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 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 'Reimbursement Type'.

EVD_EXPENSE_REIMBURSEMENT_TYPEReimbursementTypeSVR_STRING<10>
empCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the employer associated with this Employment Expense. The UI field name for this attribute is 'Employer'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
startDatedetails 

The start date of the Employment Expense. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The end date of the Employment Expense. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
Operations (4)
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 
Related Pages (2)