IMS Data Dictionary

Back to Table List

Table NameAEHEARD
Long NameHearing Loss
Description
PrefixHS

Field Name Length Type Description Comments
hd_last 30 char Hearing-Last Name of Student
hd_last 30 char Last Name
hd_first 30 char First Name
hd_first 30 char Hearing-First Name of Student
hd_middle 1 char Middle Initial
hd_middle 1 char Hearing-Middle Initial of Student
hd_dob 8 datetime Birthdate
hd_dob 8 datetime Hearing-Date of Birth of Student
hd_chid 15 char
hd_chid 15 char Child ID
hd_addr1 30 char Hearing-Parent/Student Address
hd_addr1 30 char Address Line 1
hd_addr2 30 char Address Line 2
hd_addr2 30 char Hearing-Parent/Student Address Second Line
hd_city 20 char City
hd_city 20 char
hd_state 2 char State
hd_state 2 char
hd_zip 5 char Hearing-Parent/Student Zip Code
hd_zip 5 char Zipe
hd_gender 1 char Hearing-Gender of Student
hd_gender 1 char Gender
hd_grade 2 char Educational Level
hd_grade 2 char Hearing-Grade of Student
hd_medi 8 char Hearing-Medicaid Number of Student
hd_medi 8 char Medicaid Number
hd_phonpri 10 char Hearing-Parent/Student Phone Number
hd_phonpri 10 char Phone
hd_ssn 9 char Hearing-Social Security Number of Student
hd_ssn 9 char Social Security Number
hd_staff 10 char
hd_staff 10 char Staff
hd_parent 60 char Hearing-Parent Name
hd_parent 60 char Parent Name
hd_roster 1 bit
hd_roster 1 bit Roster
hd_attdist 4 char Hearing-Attending District of Student
hd_attdist 4 char Attending District
hd_attbldg 4 char Hearing-Student Attending Building
hd_attbldg 4 char Attending Building
hd_comment -1 varchar Comments
hd_comment -1 varchar Hearing-Newborn Hearing Screening Comments
hd_status 10 char Hearing-Status of Student
hd_status 10 char Status
hd_udate 8 datetime
hd_udate 8 datetime Record Updated (Date)
hd_uid 9 char
hd_uid 9 char Record Updated (Date)
hd_utime 8 char Record Updated (Date)
hd_utime 8 char
hd_udatec 8 datetime Record Created Date
hd_udatec 8 datetime
hd_yn1 10 char
hd_yn1 10 char Hearing-Was screened as newborn
hd_yn1 10 char Hearing-Was screened as newborn
hd_yn1 10 char
hd_date1 8 datetime
hd_date1 8 datetime Hearing -Hearing Date First Indicated
hd_date2 8 datetime Hearing-Hearing Loss Identified/Confirmed
hd_date2 8 datetime
hd_date3 8 datetime Hearing-Hearing Intervention Start Date
hd_date3 8 datetime
hd_date4 8 datetime
hd_age1 3 char
hd_age1 3 char Hearing-Hearing Age First Indicated
hd_age2 3 char Hearing-Hearing Loss Age Identified/Confirmed
hd_age3 3 char
hd_deg1 4 char
hd_deg1 4 char Hearing-Degree of Loss Right Ear
hd_deg2 4 char Hearing-Type of Loss Right Ear
hd_deg2 4 char
hd_deg3 4 char Hearing-Hearing Tone Right Ear
hd_deg3 4 char
hd_deg4 4 char Hearing-Hearing Degree of Loss Left Ear
hd_deg4 4 char
hd_deg5 4 char
hd_deg5 4 char Hearing-Type of Loss Left Ear
hd_deg6 4 char Hearing-Hearing Tone Left Ear
hd_deg6 4 char
hd_hri 20 char Hearing-High Risk Indicator
hd_hri 20 char
hd_toi 4 char Hearing-Hearing Loss Intervention Type
hd_toi 4 char
hd_rear -1 varchar
hd_lear -1 varchar
hd_oaedt 8 datetime
hd_pf1 10 char
hd_pf2 10 char
hd_abrdt 8 datetime
hd_pf3 10 char
hd_pf4 10 char
hd_tosound 5 decimal
hd_prefsit 5 decimal
hd_cfgr 3 char Config-Right
hd_cfgl 3 char Config-Left
hd_toner 3 char Tone-Right
hd_tonel 3 char Tone-Left
hd_active 1 bit
hd_key 4 int