Table Description

Adoption: This evidence captures details of a child who has been adopted by an adult household member.

The adoption may be subsidized. A subsidized adoption refers to the adoption of a child with special needs where an adoption assistance agreement is established between the adoptive parents and a State or local Government agency. Special needs means a child who is physically or mentally handicapped, older, or otherwise hard to place. The adoption assistance agreement outlines what kind of payments should be made to the parents of the adopted child.

Example

Jane Kelly is a dependent child and has been adopted by Linda Smith. A case worker creates an Adoption record for Jane Kelly. Linda Smith is recorded as the adoptive parent on the Adoption record.
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::Household::Adoption::Adoption
Controlling File: Evidence\model\ServiceLayer\entity\Household\Adoption\Adoption_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

The system generated unique identifier for the Adoption.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the child who is being adopted. The child is a Household Member. The UI field name is 'Child Name'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
parCaseParticipantRoleIDdetails 

The Case Participant Role ID of the Household Member who has adopted the child.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
adoptionAssistAgreementTypedetails 

The type of adoption assistance payment being made. Examples include: State Agreement, Title IV-E Adoption Agreement, etc. This is populated from the 'AdoptionAgreementType' code table. The UI field name is 'Adoption Agreement Type'.

EVD_ADOPTION_ASSIST_AGREEMENT_TYPEAdoptionAgreementTypeSVR_STRING<10>
statedetails 

This is the State in which the adoption assistance agreement was established. This is populated from the 'StateCodes' code table. The UI field name is 'State'.

STATE_CODES_CODEStateCodesSVR_STRING<10>
adoptionFinalizedDatedetails 

The date on which the Adoption was made final by order of the court. This is the final decree of Adoption. The UI field name for this attribute is 'Adoption Finalized Date'.

CURAM_DATE SVR_DATE
commentsdetails 

Any additional details related to the Adoption are specified here. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
startDatedetails 

The start date for the Adoption. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

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

CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
Adoption.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND__1513430707caseParticipantRoleID
Operations (7)
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 
readDetailsns Returns Income Support Product Adoption Evidence details including the participant and adoption parent full name.SQL
readCaseParticipantsByEvidenceIDnsread Returns all related caseParticipantRoleID's for a specified Adoption ID. 
transferEvidence    
Related Pages (23)