IMS Data Dictionary

Back to Table List

Table NameAECHF
Long NameChild Demographic
DescriptionThe Child Demographic file contains one record for each infant/toddler/child/youth in the database. It also contains unique information about a child’s current status.
PrefixCH

Field Name Length Type Description Comments
ch_adapted 1 bit Adapted Physical Education Type
ch_addr1 30 char Address Line 1
ch_addr2 30 char Address Line 2
ch_addwt 4 int Additional Weight
ch_antgrad 8 datetime Anticipated Graduation Date
ch_atrisk 1 bit Child At Risk
ch_chid 15 char Child ID System Generated Unique Child ID
ch_city 20 char City
ch_dob 8 datetime Birthdate
ch_elisped 1 bit Eligible for Speical Education (T/F) Not used Default 0
ch_ethnic 2 char Ethnicity
ch_famstru 3 char Family Structure code
ch_first 30 char First Name
ch_firstak 15 char First Name (AKA)
ch_gender 1 char Gender
ch_grade 2 char Educational Level (Grade)
ch_ispeddt 8 datetime Initial Placement Date
ch_last 30 char Last Name
ch_lastaka 30 char Last Name (AKA)
ch_medi 8 char Medicaid Number
ch_middle 1 char Middle Initial
ch_phonalt 10 char Alternate Phone Number
ch_phonpri 10 char Primary Phone Number
ch_ptypalt 2 char Alternate Phone Type
ch_ptyppri 2 char Primary Phone Type
ch_recprg 2 char Program Model
ch_wef 4 char Recommend Weighted Factor
ch_served 2 char Served Status
ch_ssn 9 char Social Security Number
ch_state 2 char State
ch_udatec 8 datetime Child Record Creation Date
ch_udate 8 datetime Record Updated (Date)
ch_uid 9 char Record Updated (User ID)
ch_utime 8 char Record Updated (Time)
ch_zip 5 char Zip Code
ch_zip4 4 char Zip Code (Extended)
ch_resdist 4 char Resident District District in Which the Child's Parent's live.
ch_resbldg 4 char Resident Building
ch_domdist 4 char Domicile District District in which the Student Lives.
ch_dombldg 4 char Domicile Building Building the Student would have attended if not in Special Education.
ch_attdist 4 char Attending District
ch_attbld 4 char Attending Building
ch_basis 2 char Basis for Enrollment
ch_fld1 15 char Alternate ID
ch_physed 3 char Physical Education Type
ch_plstat 1 char Placement Status
ch_distype 2 char Disability (Primary) This field is automatically update from the Disability file. If you don't intend to track multiple disabilities you would enter your disability information into this field using the Extra Button Feature.
ch_comment 16 text Comments
ch_notinge 3 char % of Time not in General Education
ch_funding 1 char Funding Type
ch_medelig 1 bit Medicaid Eligible Y/N
ch_date1 8 datetime Date 1 (optional)
ch_date2 8 datetime Date 2 (optional)
ch_date3 8 datetime Date 3 (optional)
ch_date4 8 datetime Date 4 (optional)
ch_purge 10 char Purge Date
ch_paid1 4 int Tuition - Amount Paid 1st Quarter
ch_paid2 4 int Tuition - Amount Paid 2nd Quarter
ch_paid3 4 int Tuition - Amount Paid 3rd Quarter
ch_paid4 4 int Tuition - Amount Paid 4th Quarter
ch_bill1 4 int Tuition - Amount Billed 1st Quarter
ch_bill2 4 int Tuition - Amount Billed 2nd Quarter
ch_bill3 4 int Tuition - Amount Billed 3rd Quarter
ch_bill4 4 int Tuition - Amount Billed 4th Quarter
ch_deccnt 200 char December Count Comments
ch_age 2 smallint Age
ch_suffix 5 char Suffix
ch_planbeg 8 datetime Plan Duration From
ch_planend 8 datetime Plan Duration To
ch_planrev 4 char Plan Review Type
ch_planmeet 1 char Plan Meeting Type
ch_ceer 8 datetime Three Year Review Date
ch_parent 50 varchar Parent Name
ch_parentct 2 smallint Parent (count of)
ch_dwa 10 char District Wide Assessment
ch_eyse 1 char Extended Year Special Education
ch_bi 1 bit Behavior Y/N
ch_comm 1 bit Communication Y/N
ch_braille 1 bit Braille Y/N
ch_at 1 bit Assistive Technology Y/N
ch_english 1 bit Limited English Y/N
ch_health 1 bit Health Y/N
ch_stateid 10 char State ID
ch_class 5 char Class Number
ch_teacher 10 char Primary Staff
ch_parcomm 3 char Parent Comments Y/N
ch_spndist 4 char Sponsor District
ch_exitdt 8 datetime Final Exit Date Final Exit or Exit From Services
ch_exitrea 3 char Final Exit Code
ch_cede1 8 datetime CEDE Date Consent Signed
ch_cede2 8 datetime CEDE Meeting Date
ch_cede3 2 char Delay Reason
ch_cede4 2 char Meeting Not Held Reason
ch_cede5 8 datetime 45 Day Intake/Referral Date
ch_cede6 2 char Meeting Not Held Reason
ch_cede7 2 char
ch_eligib 2 char
ch_coord 10 char Service Coordinator
ch_hostdist 4 char Host District
ch_medyn 1 char Medicaid Consent Y/N
ch_meddt 8 datetime Medicaid Consent Date
ch_Ethnic09 1 char
ch_EthnicDeterm 2 smallint
ch_raceI 1 bit
ch_raceA 1 bit
ch_raceB 1 bit
ch_raceH 1 bit
ch_raceW 1 bit
ch_RaceDeterm 2 smallint
ch_edw 2 char Eligibility Meeting Not Held By 3rd Birthday
ch_iepheld 8 datetime
ch_contact 250 char
ch_categorytoReport 1 char
ch_spectrum 15 char