|
transaction_id
|
INT
|
|
|
|
|
transaction_accreditation_id
|
INT
|
|
|
|
|
transaction_event_id
|
INT
|
|
|
|
|
transaction_instrument_id
|
INT
|
|
|
|
|
transaction_chapter_id
|
INT
|
|
|
|
|
transaction_class_id
|
INT
|
|
|
|
|
transaction_standard_id
|
INT
|
|
|
|
|
transaction_institution_id
|
INT
|
|
|
|
|
transaction_institution_score
|
varchar(3)
|
latin1_swedish_ci
|
|
|
|
transaction_institution_update_date
|
datetime
|
|
|
|
|
transaction_institution_update_by
|
INT
|
|
|
|
|
transaction_institution_is_approved
|
INT
|
|
|
|
|
transaction_institution_approve_date
|
datetime
|
|
|
|
|
transaction_surveyor_update_by
|
char(5)
|
latin1_swedish_ci
|
|
|
|
transaction_surveyor_score
|
varchar(3)
|
latin1_swedish_ci
|
|
|
|
transaction_surveyor_fact_and_analysis
|
text
|
latin1_swedish_ci
|
|
|
|
transaction_surveyor_recommendation
|
text
|
latin1_swedish_ci
|
|
|
|
transaction_surveyor_need_to_discussed
|
INT
|
|
|
|
|
transaction_surveyor_update_date
|
datetime
|
|
|
|
|
transaction_counselor_update_by
|
char(5)
|
latin1_swedish_ci
|
|
|
|
transaction_counselor_score
|
varchar(3)
|
latin1_swedish_ci
|
|
|
|
transaction_counselor_fact_and_analysis
|
text
|
latin1_swedish_ci
|
|
|
|
transaction_counselor_note
|
text
|
latin1_swedish_ci
|
|
|
|
transaction_counselor_message
|
text
|
latin1_swedish_ci
|
|
|
|
transaction_evaluation_x1
|
char(1)
|
latin1_swedish_ci
|
|
|
|
transaction_evaluation_x2
|
char(1)
|
latin1_swedish_ci
|
|
|
|
transaction_evaluation_x3
|
char(1)
|
latin1_swedish_ci
|
|
|
|
transaction_counselor_update_date
|
datetime
|
|
|
|
|
transaction_counselor_is_approved
|
INT
|
|
|
|
|
transaction_counselor_approved_date
|
date
|
|
|
|
|
transaction_remedial_surveyor_update_by
|
char(5)
|
latin1_swedish_ci
|
|
|
|
transaction_remedial_surveyor_score
|
varchar(3)
|
latin1_swedish_ci
|
|
|
|
transaction_remedial_surveyor_fact_and_analysis
|
text
|
latin1_swedish_ci
|
|
|
|
transaction_remedial_surveyor_recommendation
|
text
|
latin1_swedish_ci
|
|
|
|
transaction_remedial_surveyor_update_date
|
datetime
|
|
|
|
|
transaction_final_score
|
varchar(3)
|
latin1_swedish_ci
|
|
|
|
transaction_is_evaluated
|
INT
|
|
|
|
|
transaction_is_discussed
|
INT
|
|
|
|
|
transaction_verification_1
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
transaction_verification_1_recommendation
|
text
|
latin1_swedish_ci
|
|
|
|
transaction_verification_1_insert_by
|
varchar(6)
|
latin1_swedish_ci
|
|
|
|
transaction_verification_1_insert_date
|
datetime
|
|
|
|
|
transaction_verification_2
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
transaction_verification_2_recommendation
|
text
|
latin1_swedish_ci
|
|
|
|
transaction_verification_2_insert_by
|
varchar(6)
|
latin1_swedish_ci
|
|
|
|
transaction_verification_2_insert_date
|
datetime
|
|
|
|
|
transaction_record_status
|
char(1)
|
latin1_swedish_ci
|
|
|
|
transaction_period
|
year(4)
|
|
|
|