IMS Data Dictionary

Back to Table List

Table NameAEADF
Long NameAdult Demographic
DescriptionThis file contains information on a given adult. An adult can be "related" to an individual child in different ways. Those relations are defined in the AEACF file.
PrefixAD

Field Name Length Type Description Comments
ad_city 20 char City
ad_addr1 30 char Address Line 1
ad_addr2 30 char Address Line 2
ad_state 2 char State
ad_zip 5 char Zip Code
ad_zip4 4 char Zip Code (Extended)
ad_first 30 char Name - Last
ad_last 30 char Name - First
ad_first2 30 char
ad_last2 30 char
ad_name 70 char
ad_inactive 1 bit
ad_phonalt 10 char Phone Number - Alternate
ad_phonpri 10 char Primary Phone Number
ad_ptypalt 2 char Alternate Phone Number Type
ad_ptyppri 2 char Primary Phone Number Type
ad_udate 8 datetime Record Updated (Date)
ad_utime 8 char Record Updated (Time)
ad_uid 9 char Record Updated (User ID)
ad_adid 10 char Adult ID Key Field - System Generated
ad_comment 254 char Comments
ad_letter 1 bit Suppress from Mailing List
ad_old 1 bit Old Address
ad_email 50 varchar