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 |
|
|