| Table Name | AEACF |
| Long Name | Adult to Child Relationship |
| Description | This file stores information concerning the "unique" relationship between a given child and a given adult. A child can be related to several adults and adult to several children. This file describes the relation between one (1) adult and one (1) child. |
| Prefix | AC |
| Field Name | Length | Type | Description | Comments |
|---|---|---|---|---|
| ac_chid | 15 | char | Child ID | Key Field - links to child file |
| ac_statcod | 3 | char | Coded value for State | |
| ac_statdte | 8 | datetime | Begin Date | |
| ac_enddate | 8 | datetime | End Date | |
| ac_statdes | 3 | char | Relationship type | |
| ac_consent | 1 | bit | Consent Date | |
| ac_live | 1 | bit | Live with Adult (T/F) | |
| ac_udate | 8 | datetime | Record Updated (Date) | |
| ac_utime | 8 | char | Record Updated (Time) | |
| ac_uid | 9 | char | Record Updated (User ID) | |
| ac_adid | 10 | char | Adult ID | Key Field - System Generated |
| ac_comment | 254 | char | Comments | |
| ac_keyacf | 10 | char | AEACF KEY |