Table Description

Adoption Payment: This evidence captures details of an assistance payment made by the Government for an adopted child living in the household. This type of assistance payment is given when the adopted child has some special needs - such as physical, or mental disability.

An Adoption Payment relates directly to an adoption record for a child who has been adopted by an adult household member. The Adoption Payment includes information such as the amount, frequency, and type of payment received, for example, a state funded assistance payment.

Individuals eligible for title IV-E adoption assistance are in a Medicaid eligibility group known as 'mandatory categorically needy'. This means that their receipt of Medicaid is automatic by virtue of their eligibility for title IV-E adoption assistance.

Evidence Generation Pattern: Parent - Child, Related Attributes

Example

Jane Kelly is a dependent child and has been adopted by Linda Smith. Linda Smith is receiving adoption payments in respect of Jane Kelly. A case worker creates an Adoption Payment record for the payments Linda Smith is receiving. The Adoption Payment record is associated with the Adoption record for Jane Kelly. Linda Smith is recorded as the adoptive parent on the Adoption record.

Model Details
Location in Model: Logical View::MetaModel::Curam::Evidence::Service Layer::Entity::Income::AdoptionPayment::AdoptionPayment
Controlling File: Evidence\model\ServiceLayer\entity\Income\AdoptionPayment\AdoptionPayment_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for an Adoption Payment.

EVIDENCE_ID SVR_INT64
adoptionPaymentTypedetails 

The type of Adoption Payment being made. Examples include: Title IV-E Adoption Assistance Payments, State Funded Adoption Subsidy, etc. This is populated from the 'AdoptionPayment' code table. The UI field name for this attribute is 'Adoption Payment Type'.

EVD_ADOPTION_PAYMENT_TYPEAdoptionPaymentSVR_STRING<10>
amountdetails 

The value of the Adoption Payment received from the Government. The UI field name for this attribute is 'Amount'.

CURAM_AMOUNT SVR_MONEY
frequencyCodedetails 

The frequency at which the Adoption Payment is received from the Government. Examples include: Weekly, Monthly and Yearly. 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 relating to the Adoption Payment are mentioned here. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
startDatedetails 

The date on which the first Adoption Payment was received from the Government. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The date on which the final Adoption Payment was received by the Household Member. 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 
transferEvidence    
Related Pages (3)