IMS Data Dictionary

Back to Table List

Table NameAEHEARS
Long NameHearing Screening
Description
PrefixHS

Field Name Length Type Description Comments
hs_keyhsf 10 char
hs_chid 15 char
hs_chid 15 char
hs_testwhy 20 char Hearing-Why Tested
hs_testwhy 20 char
hs_testres 20 char Hearing-Test Results
hs_testres 20 char
hs_testtxt -1 varchar
hs_testtxt -1 varchar Hearing-Comments
hs_fupdt 8 datetime
hs_fupdt 8 datetime Hearing-Follow-up date for hearing testing
hs_testdt 8 datetime
hs_testdt 8 datetime
hs_yn2 5 decimal Hearing-Evaluation Yes/No
hs_yn2 5 decimal
hs_sp1 5 decimal
hs_sp1 5 decimal
hs_sp2 5 decimal
hs_sp2 5 decimal
hs_mask 5 decimal
hs_mask 5 decimal
hs_medical 4 char Hearing-Medical opinions
hs_medical 4 char
hs_key 3 char
hs_key 3 char
hs_status 3 char Hearing-Compare hearing status
hs_udate 8 datetime
hs_udate 8 datetime
hs_uid 9 char
hs_uid 9 char
hs_utime 8 char
hs_utime 8 char
hs_udatec 8 datetime
hs_udatec 8 datetime
hs_ptr1r 4 char
hs_ptr1r 4 char
hs_ptr2r 4 char
hs_ptr2r 4 char
hs_ptr3r 4 char
hs_ptr3r 4 char
hs_ptr4r 4 char
hs_ptr4r 4 char
hs_ptr5r 4 char
hs_ptr5r 4 char
hs_ptr6r 4 char
hs_ptr6r 4 char
hs_ptr7r 4 char
hs_ptr7r 4 char
hs_ptr8r 4 char
hs_ptr8r 4 char
hs_ptr9r 4 char
hs_ptr9r 4 char
hs_ptr10r 4 char
hs_ptr10r 4 char
hs_ptr11r 4 char
hs_ptr11r 4 char
hs_ptr12r 4 char
hs_ptr12r 4 char
hs_ptr13r 4 char
hs_ptr13r 4 char
hs_cb1 1 bit
hs_cb1 1 bit
hs_cb2 1 bit
hs_cb2 1 bit
hs_cb3 1 bit
hs_cb3 1 bit
hs_cb4 1 bit
hs_cb4 1 bit
hs_cb5 1 bit
hs_cb5 1 bit
hs_cb6 1 bit
hs_cb6 1 bit
hs_cb7 1 bit
hs_cb7 1 bit
hs_cb8 1 bit
hs_cb8 1 bit
hs_cb9 1 bit
hs_cb9 1 bit
hs_cb10 1 bit
hs_cb10 1 bit
hs_cb11 1 bit
hs_cb11 1 bit
hs_cb12 1 bit
hs_cb12 1 bit
hs_cb13 1 bit
hs_cb13 1 bit
hs_cb14 1 bit
hs_cb14 1 bit
hs_cb15 1 bit
hs_cb15 1 bit
hs_cb16 1 bit
hs_cb16 1 bit
hs_td1 4 char
hs_td1 4 char
hs_td2 5 char
hs_td2 5 char
hs_td3 4 char
hs_td3 4 char
hs_td4 3 char
hs_td4 3 char
hs_td5 5 char
hs_td5 5 char
hs_td6 3 char
hs_td6 3 char
hs_td7 3 char
hs_td7 3 char
hs_td8 3 char
hs_td8 3 char
hs_td9 3 char
hs_td9 3 char
hs_td10 4 char
hs_td11 5 char
hs_td11 5 char
hs_td12 4 char
hs_td12 4 char
hs_td13 3 char
hs_td13 3 char
hs_td14 5 char
hs_td14 5 char
hs_td15 3 char
hs_td15 3 char
hs_td16 3 char
hs_td16 3 char
hs_td17 3 char
hs_td17 3 char
hs_td18 3 char
hs_td18 3 char
hs_td19 3 char
hs_td20 3 char
hs_td21 3 char
hs_td22 3 char
hs_td23 3 char
hs_td24 3 char
hs_td25 3 char
hs_td26 3 char
hs_td27 3 char
hs_td28 3 char
hs_ptr1l 4 char
hs_ptr1l 4 char
hs_ptr2l 4 char
hs_ptr2l 4 char
hs_ptr3l 4 char
hs_ptr3l 4 char
hs_ptr4l 4 char
hs_ptr4l 4 char
hs_ptr5l 4 char
hs_ptr5l 4 char
hs_ptr6l 4 char
hs_ptr6l 4 char
hs_ptr7l 4 char
hs_ptr7l 4 char
hs_ptr8l 4 char
hs_ptr8l 4 char
hs_ptr9l 4 char
hs_ptr9l 4 char
hs_ptr10l 4 char
hs_ptr10l 4 char
hs_ptr11l 4 char
hs_ptr11l 4 char
hs_ptr12l 4 char
hs_ptr12l 4 char
hs_ptr13l 4 char
hs_ptr13l 4 char
hs_ptr1rb 4 char
hs_ptr1rb 4 char
hs_ptr2rb 4 char
hs_ptr2rb 4 char
hs_ptr3rb 4 char
hs_ptr3rb 4 char
hs_ptr4rb 4 char
hs_ptr4rb 4 char
hs_ptr5rb 4 char
hs_ptr5rb 4 char
hs_ptr6rb 4 char
hs_ptr6rb 4 char
hs_ptr7rb 4 char
hs_ptr7rb 4 char
hs_ptr8rb 4 char
hs_ptr8rb 4 char
hs_ptr9rb 4 char
hs_ptr9rb 4 char
hs_ptr10rb 4 char
hs_ptr10rb 4 char
hs_ptr11rb 4 char
hs_ptr11rb 4 char
hs_ptr12rb 4 char
hs_ptr12rb 4 char
hs_ptr13rb 4 char
hs_ptr13rb 4 char
hs_ptr1lb 4 char
hs_ptr1lb 4 char
hs_ptr2lb 4 char
hs_ptr2lb 4 char
hs_ptr3lb 4 char
hs_ptr3lb 4 char
hs_ptr4lb 4 char
hs_ptr4lb 4 char
hs_ptr5lb 4 char
hs_ptr5lb 4 char
hs_ptr6lb 4 char
hs_ptr6lb 4 char
hs_ptr7lb 4 char
hs_ptr7lb 4 char
hs_ptr8lb 4 char
hs_ptr8lb 4 char
hs_ptr9lb 4 char
hs_ptr9lb 4 char
hs_ptr10lb 4 char
hs_ptr10lb 4 char
hs_ptr11lb 4 char
hs_ptr11lb 4 char
hs_ptr12lb 4 char
hs_ptr12lb 4 char
hs_ptr13lb 4 char
hs_ptr13lb 4 char
hs_a1 4 char
hs_a1 4 char
hs_a2 4 char
hs_a2 4 char
hs_a3 4 char
hs_a3 4 char
hs_a4 4 char
hs_a4 4 char
hs_a5 4 char
hs_a5 4 char
hs_a6 4 char
hs_a6 4 char
hs_a7 4 char
hs_a7 4 char
hs_a8 4 char
hs_a8 4 char
hs_a9 4 char
hs_a9 4 char
hs_a10 4 char
hs_a10 4 char
hs_a11 4 char
hs_a11 4 char
hs_a12 4 char
hs_a12 4 char
hs_a13 4 char
hs_a13 4 char
hs_loc 50 char
hs_s1 4 char
hs_s2 4 char
hs_s3 4 char
hs_s4 4 char
hs_s5 4 char
hs_s6 4 char
hs_s7 4 char
hs_s8 4 char
hs_s9 4 char
hs_s10 4 char
hs_s11 4 char
hs_s12 4 char
hs_s13 4 char
hs_art1 4 char
hs_art2 4 char
hs_art3 4 char
hs_art4 4 char
hs_1000 1 bit
hs_inserts 1 bit