Database Table: AnnualTaxReturn
Annual Tax Return: This evidence records the annual income related to the participant returned from an external system e.g. Federal Data Hub. |
| Location in Model: | Logical View::MetaModel::Curam::HCR::Case Manager::Entity::Annual Tax Return::AnnualTaxReturn |
| Controlling File: | HCR\model\Entity\AnnualTaxReturn.efx |
| ALLOW_OPTIMISTIC_LOCKING | yes |
| Attribute | Stereotype | Nullable | Description | Domain Definition | Codetable | DDL Type |
| evidenceID | key | no | The unique identifier used to identify the Annual Tax Return. | EVIDENCE_ID | | SVR_INT64 |
| caseParticipantRoleID | details | | The Case Participant Role ID of the participant associated with this Annual Tax Return record. | INTERNAL_ID | | SVR_INT64 |
| magi | details | | The MAGI amount retrieved for the participant as defined in the tax returns. | CURAM_AMOUNT | | SVR_MONEY |
| financialYear | details | | The Financial Year of the latest tax return available for a member. | DATE_STRING | | SVR_STRING<15> |
| farmingProfitLoss | details | | Income or loss from Farming. | CURAM_AMOUNT | | SVR_MONEY |
| adjustedGrossIncome | details | | The adjusted gross income as defined in the tax returns. | CURAM_AMOUNT | | SVR_MONEY |
| bizProfitLoss | details | | Income or loss from a business operated by the participant or a profession the participant practiced as a sole proprietor. | CURAM_AMOUNT | | SVR_MONEY |
| otherIncome | details | | Any taxable income not reported elsewhere on the tax return. Examples include prizes and awards, medical expenses and real estate taxes. | CURAM_AMOUNT | | SVR_MONEY |
| salary | details | | The participant's wages and salaries. If a joint return is filed, the spouse's income is also included. | CURAM_AMOUNT | | SVR_MONEY |
| adjustments | details | | The amount of any adjustment, other than the adjusted gross income, as defined in the tax return. | CURAM_AMOUNT | | SVR_MONEY |
| spouseFilingTogether | details | | The Case Participant Role ID of the spouse who jointly filed the tax return. | INTERNAL_ID | | SVR_INT64 |
| startDate | details | | The start date of the Annual Tax Return record. | CURAM_DATE | | SVR_DATE |
| endDate | details | | The end date of the Annual Tax Return record. | CURAM_DATE | | SVR_DATE |
|
| Operation | Stereotype | Options | Description | SQL |
| readByCaseParticipantRole | readmulti | | | |
| insert | insert | AUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
| Standard Operation | |
| modify | modify | OPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
| Standard Operation | |
| read | read | | Standard Operation | |
|
