Table Description

Alimony Expense: A maintenance, or support payment made by a Household Member to a divorced spouse.

Example

John Smith is divorced from his former spouse Linda Smith. John and Linda Smith are no longer residing in the same household. John Smith is making support payments to Linda Smith as part of the divorce settlement. A case worker creates an Alimony Expense for John Smith, with details of the payment being made to Linda Smith.
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::Expenses::Alimony::AlimonyExpense
Controlling File: Evidence\model\ServiceLayer\entity\Expenses\Alimony\Alimony_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

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

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

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

CASE_PARTICIPANT_ROLE_ID SVR_INT64
recCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the individual who is receiving the alimony payment. The UI field name for this attribute is 'Recipient Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
amountdetails 

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

CURAM_AMOUNT SVR_MONEY
obligatedAmountdetailsyes

The amount of the Alimony Expense, which the member is obliged by law to pay. The UI field name for this attribute is 'Obligated Amount'.

CURAM_AMOUNT SVR_MONEY
frequencyCodedetails 

The frequency at which the alimony payments are made. 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>
commentsdetails 

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

COMMENTS SVR_STRING<300>
startDatedetails 

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

CURAM_DATE SVR_DATE
endDatedetails 

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

CURAM_DATE SVR_DATE
Foreign Keys (2)
ChildParent
AlimonyExpense.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
AlimonyExpense.recCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (2)
Index NameAttributes
IND__1492324990caseParticipantRoleID
IND__1021178698recCaseParticipantRoleID
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 
readCaseParticipantsByEvidenceIDnsread Method to return any case participant Role ID associated with the entity. 
Related Pages (5)