create table chaptest ( projid char(9) not null primary key, projid15 char(15) not null , formno char(4), intid char(3), dateint2 char(8), dateint date, sex smallint, time1 char(7), autotm char(8), q1dem char(30), q2dem char(30), q3dem char(30), q4dem date, q5dem smallint, q5adem smallint, q5bdem smallint, q5cdem smallint, q1qua smallint, q2qua smallint, q3qua smallint, q4qua smallint, q1medh smallint, q1amedh smallint, q1bmedh smallint, q1cmedh smallint, q1dmedh char(40), q2medh smallint, q2amedh smallint, q2bmedh smallint, q2cmedh smallint, q2dmedh smallint, q2emedh char(40), q3medh smallint, q3amedh char(20), q3bmedh smallint, q3cmedh smallint, q3dmedh char(40), q4medh smallint, q4amedh smallint, q4bmedh smallint, q5medh smallint, q5amedh smallint, q5bmedh smallint, q6medh smallint, q7medh smallint, q8medh smallint, q8amedh smallint, q8bmedh smallint, q8cmedh smallint, q8dmedh char(40), q9medh smallint, q9amedh smallint, q9bmedh smallint, q9cmedh char(40), q1hi smallint, q2hi smallint, q2ahi smallint, q3hi smallint, q4hi smallint, q5hi smallint, q5ahi smallint, q5bhi char(40), q1fem smallint, q2fem smallint, q1acc smallint, q2acc smallint, q2aacc smallint, q3acc smallint, q3aacc smallint, q1chp smallint, q1achp smallint, q2chp smallint, q3chp smallint, q4chp smallint, q5chp smallint, q5achp smallint, q6chp1 smallint, q6chp2 smallint, q6chp3 smallint, q6chp4 smallint, q6chp5 smallint, q7chp smallint, q7achp char(20), q8chp smallint, q9chp smallint, q9achp char(40), q10chp smallint, q1joi smallint, q2joi smallint, q3joi smallint, q4joi smallint, q5joi smallint, q6joi smallint, q7joi smallint, q1bp float, q2bp smallint, q3bp smallint, q4bp smallint, q5bp smallint, q6bp smallint, q7bp char(7), q8bp char(7), q1hei char(5), q2hei smallint, q3hei smallint, q4hei smallint, q5hei smallint, q1drg smallint, q2drg smallint, q3drg smallint, q4drg smallint, name1 char(50), stren1 char(10), drgnm1 smallint, seen1 smallint, dosage1 smallint, recd1 char(40), name2 char(50), stren2 char(10), drgnm2 smallint, seen2 smallint, dosage2 smallint, recd2 char(40), name3 char(50), stren3 char(10), drgnm3 smallint, seen3 smallint, dosage3 smallint, recd3 char(40), name4 char(50), stren4 char(10), drgnm4 smallint, seen4 smallint, dosage4 smallint, recd4 char(40), name5 char(50), stren5 char(10), drgnm5 smallint, seen5 smallint, dosage5 smallint, recd5 char(40), name6 char(50), stren6 char(10), drgnm6 smallint, seen6 smallint, dosage6 smallint, recd6 char(40), name7 char(50), stren7 char(10), drgnm7 smallint, seen7 smallint, dosage7 smallint, recd7 char(40), name8 char(50), stren8 char(10), drgnm8 smallint, seen8 smallint, dosage8 smallint, recd8 char(40), name9 char(50), stren9 char(10), drgnm9 smallint, seen9 smallint, dosage9 smallint, recd9 char(40), name10 char(50), stren10 char(10), drgnm10 smallint, seen10 smallint, dosage10 smallint, recd10 char(40), name11 char(50), stren11 char(10), drgnm11 smallint, seen11 smallint, dosage11 smallint, recd11 char(40), name12 char(50), stren12 char(10), drgnm12 smallint, seen12 smallint, dosage12 smallint, recd12 char(40), name13 char(50), stren13 char(10), drgnm13 smallint, seen13 smallint, dosage13 smallint, recd13 char(40), name14 char(50), stren14 char(10), drgnm14 smallint, seen14 smallint, dosage14 smallint, recd14 char(40), name15 char(50), stren15 char(10), drgnm15 smallint, seen15 smallint, dosage15 smallint, recd15 char(40), name16 char(50), stren16 char(10), drgnm16 smallint, seen16 smallint, dosage16 smallint, recd16 char(40), name17 char(50), stren17 char(10), drgnm17 smallint, seen17 smallint, dosage17 smallint, recd17 char(40), name18 char(50), stren18 char(10), drgnm18 smallint, seen18 smallint, dosage18 smallint, recd18 char(40), name19 char(50), stren19 char(10), drgnm19 smallint, seen19 smallint, dosage19 smallint, recd19 char(40), name20 char(50), stren20 char(10), drgnm20 smallint, seen20 smallint, dosage20 smallint, recd20 char(40), q1ebmt smallint, q2ebmt smallint, q3ebmt smallint, q4ebmt smallint, q5ebmt smallint, q6ebmt smallint, q7ebmt smallint, q8ebmt smallint, q9ebmt smallint, q10ebmt smallint, q9newebmt smallint, q10newebmt smallint, q11ebmt smallint, q12ebmt smallint, prow char(7), row1 char(15), row2 char(15), row3 char(15), row4 char(15), row5 char(15), row6 char(15), row7 char(15), row8 char(15), row9 char(15), row10 char(15), row11 char(15), q1ebdr smallint, q2ebdr smallint, q3ebdr smallint, q4ebdr smallint, q5ebdr smallint, q6ebdr smallint, q7ebdr smallint, q8ebdr smallint, q9ebdr smallint, q10ebdr smallint, q9newebdr smallint, q10newebdr smallint, q11ebdr smallint, q12ebdr smallint, q1mme smallint, q2mme smallint, q3mme smallint, q4mme smallint, q5mme smallint, q6mme smallint, q7mme smallint, q8mme smallint, q9mme smallint, q10amme smallint, q10bmme smallint, q11amme smallint, q11bmme smallint, q11cmme smallint, q12amme smallint, q12bmme char(10), q13amme smallint, q13bmme smallint, q13cmme smallint, q14mme smallint, q15mme smallint, q16mme smallint, q17mme smallint, q18amme smallint, q18bmme smallint, q18cmme smallint, q19mme smallint, q20mme smallint, q1he smallint, q2he smallint, q2ahe smallint, q2bhe smallint, q3he smallint, q3ahe smallint, q4he smallint, q4ahe smallint, q5he smallint, q5ahe smallint, q5bhe smallint, q1han smallint, q2han smallint, q1smo smallint, q1asmo smallint, q1bsmo smallint, q2smo smallint, q2asmo smallint, q2bsmo smallint, q2csmo smallint, q3smo smallint, q4smo smallint, q1alc smallint, q2alc smallint, q2ialc smallint, q3alc smallint, q4alc smallint, q5alc smallint, q6alc smallint, q7alc smallint, q8alc smallint, q1phy smallint, q1aphy smallint, q1bphy smallint, q2phy smallint, q2aphy smallint, q2bphy smallint, q3phy smallint, q3aphy smallint, q3bphy smallint, q4phy smallint, q4aphy smallint, q4bphy smallint, q5phy smallint, q5aphy smallint, q5bphy smallint, q6phy smallint, q6aphy smallint, q6bphy smallint, q7phy smallint, q7aphy smallint, q7bphy smallint, q8phy smallint, q8aphy smallint, q8bphy smallint, q9phy smallint, q9aphy smallint, q9bphy smallint, q10phy smallint, q101phy char(40), q10aphy smallint, q10bphy smallint, q1fs smallint, q2fs smallint, q3fs smallint, q4fs smallint, q5fs smallint, q6fs smallint, q7fs smallint, q8fs smallint, q9fs smallint, q10fs smallint, q11fs smallint, q11afs smallint, q12fs smallint, q12afs smallint, q13fs smallint, q13afs smallint, q14fs smallint, q14afs smallint, q15fs smallint, q15afs smallint, q16fs smallint, q16afs smallint, q17fs smallint, q17afs smallint, q1ur smallint, q2ur smallint, q3ur smallint, q4ur smallint, q1care smallint, q2care smallint, q3care smallint, q3acare char(20), q4care smallint, q5care smallint, q1md smallint, q2md smallint, q3md smallint, q4md smallint, q5md smallint, q6md smallint, q7md smallint, q8md smallint, q9md smallint, q10md smallint, q1pm float, q2pm float, q3pm float, q4apm float, q4bpm smallint, q4b1pm char(20), q5apm smallint, q5bpm smallint, q5opm char(20), q5cpm smallint, q6apm smallint, q6bpm float, q6opm char(20), q6cpm smallint, q7apm smallint, q7bpm smallint, q1act smallint, q1aact smallint, q1bact smallint, q1cact char(20), q2act smallint, q2aact smallint, q2bact smallint, q2cact char(20), q3act smallint, q3aact smallint, q3oaact char(20), q3bact smallint, q3obact char(20), q4act smallint, q4aact char(60), q5act smallint, q5aact smallint, q5oact char(20), q6act smallint, q6aact char(60), q7act smallint, q8act smallint, q1ch smallint, q2ch smallint, q3ch smallint, q4ch smallint, q5ch smallint, q6ch smallint, q7ch smallint, q8ch smallint, q9ch smallint, q1ani smallint, q1a1ani smallint, q1a2ani smallint, q1a3ani smallint, q1a4ani smallint, q1a5ani smallint, q1a6ani smallint, q1a7ani smallint, q1a8ani smallint, q1pi smallint, q1api smallint, q1bpi smallint, q2pi smallint, q2api smallint, q2bpi smallint, q2cpi smallint, q3pi smallint, q4pi smallint, q5pi char(30), q6pi smallint, q6api smallint, q7pi smallint, q7api smallint, q7bpi smallint, q8pi smallint, q8api smallint, q8bpi smallint, q8cpi smallint, q9pi char(30), q10pi smallint, q10api smallint, q1famh smallint, q2famh smallint, q3famh smallint, q4famh smallint, q1sn smallint, q2sn smallint, q2asn smallint, q3sn smallint, q3asn smallint, q3a1sn smallint, q4sn smallint, q4asn smallint, q4a1sn smallint, q5sn smallint, q5asn smallint, q1per smallint, q2per smallint, q3per smallint, q4per smallint, q5per smallint, q6per smallint, q7per smallint, q8per smallint, q9per smallint, q10per smallint, q11per smallint, q12per smallint, q13per smallint, q14per smallint, q15per smallint, q1oc smallint, q2oc smallint, q3oc char(30), q4oc char(60), q5oc char(30), q6oc smallint, q7oc smallint, q8oc smallint, q8aoc smallint, q9oc smallint, q9aoc char(60), q10oc char(60), q11oc char(30), q12oc smallint, q13oc smallint, q14oc smallint, q15oc smallint, q16oc smallint, q1600c char(30), q16aoc char(30), q17oc char(60), q18oc char(30), q19oc smallint, q20oc smallint, q21oc smallint, q1inc smallint, q1aloc char(20), q1bloc char(40), q1cloc char(12), q1dloc char(20), q1eloc char(20), q1floc char(40), q1gloc char(12), q1hloc char(20), q2loc char(10), q2aloc char(10), q3loc char(11), q3aloc char(11), q4loc char(20), q4aloc char(20), q4bloc char(20), q4cloc char(20), q5loc char(20), q5aloc char(20), q5bloc char(20), q6loc smallint, q6aloc char(40), time2 char(7), autoendtm char(8), comm char(10), q1int smallint, q1aint smallint, q1a1int char(30), q1bint smallint, q2int smallint, q2aint smallint, q3int smallint, q4int smallint, q5int smallint, q6int smallint, q7int smallint, q8int smallint, q8aint char(30), cen_tbh char(10), cen_seq char(3), hhid char(10), revidate date, load_date date, status smallint );