|
trans_id
|
INT
|
|
|
|
|
trans_event_id
|
INT
|
|
|
|
|
trans_chapter_id
|
INT
|
|
|
|
|
trans_institution_code
|
varchar(11)
|
latin1_swedish_ci
|
|
|
|
trans_institution_score
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
trans_institution_date
|
datetime
|
|
|
|
|
trans_surveyor_score
|
float
|
|
|
|
|
trans_surveyor_value
|
text
|
latin1_swedish_ci
|
|
|
|
trans_surveyor_update_by
|
INT
|
|
|
|
|
trans_surveyor_date
|
datetime
|
|
|
|
|
trans_remedial_surveyor_score
|
float
|
|
|
|
|
trans_remedial_surveyor_value
|
text
|
latin1_swedish_ci
|
|
|
|
trans_remedial_surveyor_update_by
|
INT
|
|
|
|
|
trans_remedial_surveyor_date
|
datetime
|
|
|
|
|
trans_counselor_score
|
float
|
|
|
|
|
trans_counselor_value
|
text
|
latin1_swedish_ci
|
|
|
|
trans_counselor_update_by
|
INT
|
|
|
|
|
trans_counselor_date
|
datetime
|
|
|
|
|
trans_final_score_0
|
INT
|
|
|
|
|
trans_final_score_5
|
INT
|
|
|
|
|
trans_final_score_10
|
INT
|
|
|
|
|
trans_final_is_tdd
|
char(1)
|
latin1_swedish_ci
|
|
|
|
trans_final_score
|
float
|
|
|
|
|
trans_verification_1
|
char(1)
|
latin1_swedish_ci
|
|
|
|
trans_verification_2
|
char(1)
|
latin1_swedish_ci
|
|
|
|
trans_status_id
|
char(2)
|
latin1_swedish_ci
|
|
|
|
trans_insert_date
|
datetime
|
|
|
|
|
trans_insert_by
|
INT
|
|
|
|
|
trans_record_status
|
char(1)
|
latin1_swedish_ci
|
|
|