Table Description

Earned Income: The pay or reward the participant receives for a paid employment.

Example

Linda Smith is currently in paid employment and receiving a monthly salary. A case worker creates an Earned Income record with details of the salary that Linda Smith is receiving from her employer. Linda Smith's Earned Income record is associated with her paid employment.
Model Details
Location in Model: Logical View::MetaModel::Curam::Evidence::Service Layer::Entity::Income::EarnedIncome::EarnedIncome
Controlling File: Evidence\model\ServiceLayer\entity\Income\EarnedIncome\EarnedIncome_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

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

EVIDENCE_ID SVR_INT64
amountdetails 

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

CURAM_AMOUNT SVR_MONEY
frequencyCodedetails 

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

FREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
earnedIncomeTypedetails 

The type of income. Examples include: Bonus, Migrant Worker. This is populated from the 'EarnedIncomeType' code table. The UI field name for this attribute is 'Type'.

EVD_EARNED_INCOME_TYPEEarnedIncomeTypeSVR_STRING<10>
seasonalIncomeInddetails 

Indicates if the Earned Income is seasonal. The UI field name for this attribute is 'Seasonal Income'.

CURAM_INDICATOR SVR_BOOLEAN
startDatedetails 

The date on which the Earned Income commenced. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The date on which the Earned Income stopped. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
commentsdetails 

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

COMMENTS SVR_STRING<300>
incomeTaxAmountdetails 

The amount of the Income Tax related to this Earned Income. The UI field name for this attribute is 'Income Tax Amount'.

CURAM_AMOUNT SVR_MONEY
pensionContributionAmountdetails 

The amount of Pension Contribution related to this Earned Income. The UI field name for this attribute is 'Pension Contribution Amount'.

CURAM_AMOUNT SVR_MONEY
siContributionAmountdetails 

The amount of Social Insurance Contribution related to this Earned Income. The UI field name for this attribute is 'Social Insurance Contribution Amount'.

CURAM_AMOUNT SVR_MONEY
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 (4)