odyssey_test._quest contains 793 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
std_program_history	action_date	date	13
std_term_program	action_date	date	13
std_term_program_plus	action_date	date	13	√		null
std_service_indicator	active_date	date	13
std_service_indicator	active_term	quest_term_id	2147483647	√		null
std_term	actual_load	text	2147483647
std_term_section	add_date	date	13
std_address	address1	text	2147483647	√		null
std_address	address2	text	2147483647	√		null
std_address	address3	text	2147483647	√		null
std_address	address4	text	2147483647	√		null
std_address	address_type	text	2147483647
std_program_history	admit_term_id	quest_term_id	2147483647
std_term_program	admit_term_id	quest_term_id	2147483647
std_term_program_plus	admit_term_id	quest_term_id	2147483647	√		null
std_term_course_demand	apply_ng_grade	bool	1	√		null
std_program_history	approved_load	quest_load	2147483647
std_term	approved_load	text	2147483647
std_term_program	approved_load	quest_load	2147483647
std_term_program_plus	approved_load	quest_load	2147483647	√		null
std_transfer_credit_detail	articulation_term	quest_term_id	2147483647
off_association	association_id	int4	10
off_course_section	association_id	int4	10	√		null
off_course_section_complete	association_id	int4	10	√		null
off_course_section_plus	association_id	int4	10	√		null
off_course_section	auto_enroll_1_section_code	text	2147483647	√		null
off_course_section_complete	auto_enroll_1_section_code	text	2147483647	√		null
off_course_section_plus	auto_enroll_1_section_code	text	2147483647	√		null
off_course_section	auto_enroll_2_section_code	text	2147483647	√		null
off_course_section_complete	auto_enroll_2_section_code	text	2147483647	√		null
off_course_section_plus	auto_enroll_2_section_code	text	2147483647	√		null
std_student	birthdate	date	13	√		null
off_instruct_section_meet_plus	building_id	int4	10	√		null
uw_room	building_id	int4	10
std_term_course_demand	campus	text	2147483647	√		null
uw_campus	campus_active	bool	1
uw_campus_history	campus_active	bool	1
uw_campus	campus_as_of	date	13
uw_campus_history	campus_as_of	date	13
cal_course_label	campus_code	text	2147483647	√		null
cal_course_label_history	campus_code	text	2147483647	√		null
off_course_section_complete	campus_code	text	2147483647	√		null
off_course_section_plus	campus_code	text	2147483647	√		null
off_instruct_section	campus_code	text	2147483647
std_program_history	campus_code	text	2147483647
std_term_program	campus_code	text	2147483647
std_term_program_plus	campus_code	text	2147483647	√		null
uw_campus	campus_code	text	2147483647
uw_campus_history	campus_code	text	2147483647
uw_unit	campus_code	text	2147483647
uw_unit_history	campus_code	text	2147483647
uw_campus	campus_description	text	2147483647
uw_campus_history	campus_description	text	2147483647
std_term_course_demand	campus_optional	quest_option	2147483647	√		null
uw_campus	campus_short_description	text	2147483647
uw_campus_history	campus_short_description	text	2147483647
cal_course_label	career_code	quest_career	2147483647
cal_course_label_history	career_code	quest_career	2147483647
off_course_section_complete	career_code	quest_career	2147483647	√		null
off_course_section_plus	career_code	quest_career	2147483647	√		null
pps_plan	career_code	quest_career	2147483647	√		null
pps_plan_history	career_code	quest_career	2147483647	√		null
pps_program	career_code	quest_career	2147483647
pps_program_history	career_code	quest_career	2147483647
std_degree	career_code	quest_career	2147483647
std_degree_plan	career_code	quest_career	2147483647
std_plan_history	career_code	quest_career	2147483647
std_program_history	career_code	quest_career	2147483647
std_program_milestone	career_code	quest_career	2147483647	√		null
std_program_plan_milestone	career_code	quest_career	2147483647	√		null
std_subplan_history	career_code	quest_career	2147483647
std_term	career_code	quest_career	2147483647
std_term_course_demand	career_code	quest_career	2147483647
std_term_plan_plus	career_code	quest_career	2147483647	√		null
std_transfer_credit_detail	career_code	quest_career	2147483647
std_transfer_credit_school	career_code	quest_career	2147483647
std_degree_plan	career_num	int4	10
std_plan_history	career_num	int4	10
std_program_history	career_num	int4	10
std_subplan_history	career_num	int4	10
std_term	career_num	int4	10
cal_course_label	catalog	text	2147483647
cal_course_label_history	catalog	text	2147483647
off_course_section_complete	catalog	text	2147483647	√		null
off_course_section_plus	catalog	text	2147483647	√		null
std_address	city	text	2147483647	√		null
off_course	class_id	int4	10
off_course_section	class_id	int4	10
off_course_section_complete	class_id	int4	10	√		null
off_course_section_note	class_id	int4	10
off_course_section_plus	class_id	int4	10	√		null
off_course_section_reserve	class_id	int4	10
std_term_course	class_id	int4	10
std_term_course_demand	class_id	int4	10
std_term_section	class_id	int4	10
std_program_milestone	comments	text	2147483647	√		null
std_program_plan_milestone	comments	text	2147483647	√		null
std_transfer_credit_school	comments	text	2147483647	√		null
std_degree	completion_term_id	quest_term_id	2147483647
std_program_history	completion_term_id	quest_term_id	2147483647	√		null
std_term_program	completion_term_id	quest_term_id	2147483647	√		null
std_term_program_plus	completion_term_id	quest_term_id	2147483647	√		null
off_association	component_code	text	2147483647
off_course_section	component_code	text	2147483647
off_course_section_complete	component_code	text	2147483647	√		null
off_course_section_plus	component_code	text	2147483647	√		null
std_term	coop_term_type_code	text	2147483647	√		null
std_term	coop_workterm_status	text	2147483647	√		null
std_address	country	text	2147483647	√		null
uw_country	country_code	text	2147483647
uw_location	country_code	text	2147483647
uw_location_history	country_code	text	2147483647
uw_country	country_name	text	2147483647
uw_country	country_short_code	text	2147483647	√		null
uw_country	country_short_name	text	2147483647
cal_course	course_active	bool	1
cal_course_history	course_active	bool	1
off_course_section_complete	course_active	bool	1	√		null
cal_course	course_add_consent	quest_consent	2147483647
cal_course_history	course_add_consent	quest_consent	2147483647
off_course_section_complete	course_add_consent	quest_consent	2147483647	√		null
cal_course	course_ap_units	numeric	5,2
cal_course_history	course_ap_units	numeric	5,2
off_association	course_ap_units	numeric	5,2
off_course_section_complete	course_ap_units	numeric	5,2	√		null
cal_course	course_as_of	date	13
cal_course_history	course_as_of	date	13
cal_course_label	course_as_of	date	13
cal_course_label_history	course_as_of	date	13
cal_course_topic	course_as_of	date	13
cal_course_topic_history	course_as_of	date	13
off_course_as_of	course_as_of	date	13
off_course_section_complete	course_as_of	date	13	√		null
off_course_section_plus	course_as_of	date	13	√		null
cal_course	course_description	text	2147483647	√		null
cal_course_history	course_description	text	2147483647	√		null
off_course_section_complete	course_description	text	2147483647	√		null
cal_course	course_drop_consent	quest_consent	2147483647
cal_course_history	course_drop_consent	quest_consent	2147483647
off_course_section_complete	course_drop_consent	quest_consent	2147483647	√		null
std_term_course	course_grade	text	2147483647	√		null
std_transfer_credit_detail	course_grade	text	2147483647
cal_course	course_id	quest_course_id	2147483647
cal_course_history	course_id	quest_course_id	2147483647
cal_course_label	course_id	quest_course_id	2147483647
cal_course_label_history	course_id	quest_course_id	2147483647
cal_course_topic	course_id	quest_course_id	2147483647
cal_course_topic_history	course_id	quest_course_id	2147483647
off_association	course_id	quest_course_id	2147483647
off_course	course_id	quest_course_id	2147483647
off_course_as_of	course_id	quest_course_id	2147483647
off_course_section	course_id	quest_course_id	2147483647
off_course_section_complete	course_id	quest_course_id	2147483647	√		null
off_course_section_plus	course_id	quest_course_id	2147483647	√		null
std_term_course	course_id	quest_course_id	2147483647
std_term_section	course_id	quest_course_id	2147483647
std_transfer_credit_detail	course_id	int4	10
off_course_section	course_section_enrol_limit	int4	10
off_course_section_complete	course_section_enrol_limit	int4	10	√		null
off_course_section_plus	course_section_enrol_limit	int4	10	√		null
off_course_section	course_section_enrol_total	int4	10
off_course_section_complete	course_section_enrol_total	int4	10	√		null
off_course_section_plus	course_section_enrol_total	int4	10	√		null
off_course_section	course_section_room_capacity	int4	10
off_course_section_complete	course_section_room_capacity	int4	10	√		null
off_course_section_plus	course_section_room_capacity	int4	10	√		null
cal_course	course_short_title	text	2147483647
cal_course_history	course_short_title	text	2147483647
off_course_section_complete	course_short_title	text	2147483647	√		null
cal_course	course_take_units	numeric	5,2
cal_course_history	course_take_units	numeric	5,2
off_association	course_take_units	numeric	5,2
off_course_section_complete	course_take_units	numeric	5,2	√		null
cal_course	course_title	text	2147483647
cal_course_history	course_title	text	2147483647
off_course_section_complete	course_title	text	2147483647	√		null
std_term_units	cum_academic_units_attempted	numeric	8,3
std_term_units	cum_academic_units_passed	numeric	8,3				Does not include transfer credits.
std_term_units	cum_grade_points	numeric	9,3
std_term_units	cum_resident_terms	numeric	6,3
std_term_units	cum_units_attempted_in_gpa	numeric	8,3
std_term_units	cum_units_attempted_not_in_gpa	numeric	8,3
std_term_units	cum_units_audited	numeric	8,3
std_term_units	cum_units_in_progress_not_towards_gpa	numeric	8,3
std_term_units	cum_units_in_progress_towards_gpa	numeric	8,3
std_term_units	cum_units_passed_in_gpa	numeric	8,3
std_term_units	cum_units_passed_not_in_gpa	numeric	8,3
std_term_units	cum_units_total	numeric	8,3
std_term_units	cum_units_transferred	numeric	8,3
std_term	cumulative_gpa	numeric	8,3
std_program_history	data_from_adm_appl	bool	1
std_term_program	data_from_adm_appl	bool	1
std_term_program_plus	data_from_adm_appl	bool	1	√		null
std_program_milestone	date_completed	date	13	√		null
std_program_plan_milestone	date_completed	date	13	√		null
std_student	deathdate	date	13	√		null
pps_degree	degree_active	bool	1
pps_degree_history	degree_active	bool	1
pps_degree	degree_as_of	date	13
pps_degree_history	degree_as_of	date	13
pps_degree	degree_code	text	2147483647
pps_degree_history	degree_code	text	2147483647
pps_plan	degree_code	text	2147483647	√		null
pps_plan_history	degree_code	text	2147483647	√		null
std_degree	degree_code	text	2147483647
std_term_plan_plus	degree_code	text	2147483647	√		null
std_degree	degree_conferral_date	date	13
pps_degree	degree_full_title	text	2147483647
pps_degree_history	degree_full_title	text	2147483647
std_degree	degree_id	quest_degree_id	2147483647
std_degree_honour	degree_id	quest_degree_id	2147483647
std_degree_plan	degree_id	quest_degree_id	2147483647
std_degree_subplan	degree_id	quest_degree_id	2147483647
std_plan_history	degree_id	quest_degree_id	2147483647	√		null
std_term_plan	degree_id	quest_degree_id	2147483647	√		null
std_term_plan_plus	degree_id	quest_degree_id	2147483647	√		null
pps_degree	degree_internal	bool	1
pps_degree_history	degree_internal	bool	1
pps_degree	degree_level	text	2147483647	√		null
pps_degree_history	degree_level	text	2147483647	√		null
std_degree	degree_revoked	bool	1
pps_degree	degree_short_title	text	2147483647
pps_degree_history	degree_short_title	text	2147483647
pps_degree	degree_title	text	2147483647
pps_degree_history	degree_title	text	2147483647
pps_degree	degree_years	int4	10
pps_degree_history	degree_years	int4	10
std_term_course_demand	demand_as_of	timestamp	29,6	√		null
pps_service_indicator_impact	description	text	2147483647	√		null
pps_service_indicator_reason	description	text	2147483647	√		null
pps_service_indicator	display_in_self_serve	bool	1
std_term_section	drop_date	date	13	√		null
std_term_course	earn_credit	bool	1
std_transfer_credit_detail	earn_credit	bool	1
std_term	eligible_to_enrol	bool	1
std_student	email	text	2147483647	√		null
std_term_section	enrolment_status	quest_student_enrol_status	2147483647
std_program_history	expected_grad_term_id	quest_term_id	2147483647	√		null
std_term_program	expected_grad_term_id	quest_term_id	2147483647	√		null
std_term_program_plus	expected_grad_term_id	quest_term_id	2147483647	√		null
std_transfer_credit_detail	external_catalog	text	2147483647	√		null
std_transfer_credit_detail	external_descr	text	2147483647	√		null
std_transfer_credit_detail	external_grade	text	2147483647	√		null
std_transfer_credit_detail	external_subject	text	2147483647	√		null
std_transfer_credit_detail	external_term	text	2147483647	√		null
off_instruct_section_meet_plus	facility_active	bool	1	√		null
uw_room	facility_active	bool	1
off_instruct_section_meet_plus	facility_as_of	date	13	√		null
uw_room	facility_as_of	date	13
off_instruct_section_meet	facility_id	text	2147483647	√		null
off_instruct_section_meet_plus	facility_id	text	2147483647	√		null
uw_room	facility_id	text	2147483647
off_instruct_section_meet_plus	facility_partition	int4	10	√		null
uw_room	facility_partition	int4	10	√		null
off_instruct_section_meet_plus	facility_type_code	text	2147483647	√		null
uw_room	facility_type_code	text	2147483647
std_name	first_name	text	2147483647	√		null
std_name_preferred	first_name	text	2147483647	√		null
std_name_primary	first_name	text	2147483647	√		null
pps_plan	first_valid_term_id	quest_term_id	2147483647	√		null
pps_plan_history	first_valid_term_id	quest_term_id	2147483647	√		null
pps_program	first_valid_term_id	quest_term_id	2147483647	√		null
pps_program_history	first_valid_term_id	quest_term_id	2147483647	√		null
pps_subplan	first_valid_term_id	quest_term_id	2147483647	√		null
pps_subplan_history	first_valid_term_id	quest_term_id	2147483647	√		null
std_term_plan_plus	first_valid_term_id	quest_term_id	2147483647	√		null
std_term	form_of_study	text	2147483647
std_program_milestone	formal_description	text	2147483647
std_program_plan_milestone	formal_description	text	2147483647
off_instruct_section_instructor_plus	givennames	text	2147483647	√		null
std_term_plan_gpa	gpa	numeric	8,3	√		null
std_term_subplan_gpa	gpa	numeric	8,3	√		null
std_term_plan_gpa	gpa_date	date	13	√		null
std_term_subplan_gpa	gpa_date	date	13	√		null
std_term_plan_gpa	gpa_type_code	text	2147483647
std_term_subplan_gpa	gpa_type_code	text	2147483647
off_association	grade_basis_code	text	2147483647
std_term_course	grade_category	text	2147483647	√		null
std_transfer_credit_detail	grade_category	text	2147483647
std_term_course	grade_points	numeric	9,3
std_term_course	grade_submission_date	date	13	√		null
std_term_course	grading_basis	text	2147483647
std_transfer_credit_detail	grading_basis	text	2147483647
uw_group	group_active	bool	1
uw_group_history	group_active	bool	1
uw_group	group_as_of	date	13
uw_group_history	group_as_of	date	13
cal_course_label	group_code	text	2147483647
cal_course_label_history	group_code	text	2147483647
off_course_section_complete	group_code	text	2147483647	√		null
off_course_section_plus	group_code	text	2147483647	√		null
pps_program	group_code	text	2147483647
pps_program_history	group_code	text	2147483647
uw_group	group_code	text	2147483647
uw_group_history	group_code	text	2147483647
uw_unit	group_code	text	2147483647	√		null
uw_unit_history	group_code	text	2147483647	√		null
uw_group	group_quest_name	text	2147483647
uw_group_history	group_quest_name	text	2147483647
std_degree_honour	honours_award_date	date	13
std_degree_honour	honours_code	text	2147483647
std_degree_honour	honours_id	int4	10
std_term_course	include_in_gpa	bool	1
std_transfer_credit_detail	include_in_gpa	bool	1
std_transfer_credit_school	include_in_gpa	bool	1
off_instruct_section	instruct_section_capacity_request	int4	10
off_instruct_section	instruct_section_enrol_limit	int4	10
off_instruct_section	instruct_section_enrol_total	int4	10
std_term_course_demand	instruction_mode	quest_instruction_mode	2147483647	√		null
off_instruct_section	instruction_mode_code	quest_instruction_mode	2147483647
std_term_course_demand	instruction_mode_optional	quest_option	2147483647	√		null
off_instruct_section_instructor	instructor_role_code	text	2147483647
off_instruct_section_instructor_plus	instructor_role_code	text	2147483647	√		null
cal_course_label	label_schedule_print	bool	1
cal_course_label_history	label_schedule_print	bool	1
off_course_section_complete	label_schedule_print	bool	1	√		null
off_course_section_plus	label_schedule_print	bool	1	√		null
cal_course_label	label_seq	int4	10
cal_course_label_history	label_seq	int4	10
off_association	label_seq	int4	10
off_course	label_seq	int4	10
off_course_section	label_seq	int4	10
off_course_section_complete	label_seq	int4	10	√		null
off_course_section_plus	label_seq	int4	10	√		null
std_term_course	label_seq	int4	10
std_transfer_credit_detail	label_seq	int4	10
pps_plan	last_admit_term_id	quest_term_id	2147483647	√		null
pps_plan_history	last_admit_term_id	quest_term_id	2147483647	√		null
pps_subplan	last_admit_term_id	quest_term_id	2147483647	√		null
pps_subplan_history	last_admit_term_id	quest_term_id	2147483647	√		null
std_term_plan_plus	last_admit_term_id	quest_term_id	2147483647	√		null
std_term	last_date_attended	date	13	√		null
std_term_section	last_drop	timestamp	29,6	√		null
std_term_section	last_enrolment_change	timestamp	29,6	√		null
std_name	last_name	text	2147483647	√		null
std_name_preferred	last_name	text	2147483647	√		null
std_name_primary	last_name	text	2147483647	√		null
std_term_section	last_update	timestamp	29,6	√		null
pps_program	level_load_rule_code	text	2147483647
pps_program_history	level_load_rule_code	text	2147483647
std_term_course_demand	location	text	2147483647	√		null
uw_location	location_active	bool	1
uw_location_history	location_active	bool	1
uw_location	location_as_of	date	13
uw_location_history	location_as_of	date	13
off_instruct_section	location_code	text	2147483647
off_instruct_section_meet_plus	location_code	text	2147483647	√		null
uw_campus	location_code	text	2147483647
uw_campus_history	location_code	text	2147483647
uw_location	location_code	text	2147483647
uw_location_history	location_code	text	2147483647
uw_room	location_code	text	2147483647
uw_location	location_quest_description	text	2147483647
uw_location_history	location_quest_description	text	2147483647
std_term_units	max_nogpa_unit_load	numeric	5,2
std_term_units	max_total_unit_load	numeric	5,2
off_instruct_section_meet	meet_dates	daterange	2147483647
off_instruct_section_meet_plus	meet_dates	daterange	2147483647	√		null
off_instruct_section_meet	meet_days	bit	7
off_instruct_section_meet_plus	meet_days	bit	7	√		null
off_instruct_section_meet	meet_id	int4	10
off_instruct_section_meet_plus	meet_id	int4	10	√		null
off_instruct_section_meet	meet_times	timerange	2147483647
off_instruct_section_meet_plus	meet_times	timerange	2147483647	√		null
std_name	middle_name	text	2147483647	√		null
std_name_preferred	middle_name	text	2147483647	√		null
std_name_primary	middle_name	text	2147483647	√		null
std_program_milestone	milestone_code	text	2147483647
std_program_plan_milestone	milestone_code	text	2147483647
std_program_milestone	milestone_complete	quest_completion_code	2147483647
std_program_plan_milestone	milestone_complete	quest_completion_code	2147483647
std_program_milestone	milestone_id	int4	10
std_program_plan_milestone	milestone_id	int4	10
std_program_milestone	milestone_title	text	2147483647	√		null
std_program_plan_milestone	milestone_title	text	2147483647	√		null
std_transfer_credit_school	model_status	text	2147483647
std_name	name_as_of	date	13
std_name_preferred	name_as_of	date	13	√		null
std_name_primary	name_as_of	date	13	√		null
std_name	name_title	text	2147483647	√		null
std_name_preferred	name_title	text	2147483647	√		null
std_name_primary	name_title	text	2147483647	√		null
std_name	name_type_code	text	2147483647
std_name_preferred	name_type_code	text	2147483647	√		null
std_name_primary	name_type_code	text	2147483647	√		null
off_default_note	note_active	bool	1
off_default_note_history	note_active	bool	1
off_default_note	note_as_of	date	13
off_default_note_history	note_as_of	date	13
off_default_note	note_description	text	2147483647
off_default_note_history	note_description	text	2147483647
off_course_section_note	note_id	int4	10	√		null
off_default_note	note_id	int4	10
off_default_note_history	note_id	int4	10
off_course_section_note	note_text	text	2147483647	√		null
off_default_note	note_text	text	2147483647
off_default_note_history	note_text	text	2147483647
update_notification	notification_id	serial	10		√	nextval('_quest.update_notification_notification_id_seq'::regclass)
update_notification	notification_time	timestamp	29,6			now()	When the notification was recorded
std_term_units	override_max_units	bool	1
std_term_section	permission_number	int4	10	√		null
std_photo	photo_as_of	date	13				When this photo was loaded
std_photo	photo_original	bytea	2147483647				The original photo supplied by WatCard
std_photo	photo_standard	bytea	2147483647				The photo re-sized to a standard size
pps_plan	plan_active	bool	1
pps_plan_history	plan_active	bool	1
std_term_plan_plus	plan_active	bool	1	√		null
pps_plan	plan_as_of	date	13
pps_plan_history	plan_as_of	date	13
std_term_plan_plus	plan_as_of	date	13	√		null
pps_plan	plan_code	text	2147483647
pps_plan_history	plan_code	text	2147483647
pps_subplan	plan_code	text	2147483647
pps_subplan_history	plan_code	text	2147483647
std_degree_plan	plan_code	text	2147483647
std_degree_subplan	plan_code	text	2147483647
std_plan_history	plan_code	text	2147483647
std_program_plan_milestone	plan_code	text	2147483647
std_subplan_history	plan_code	text	2147483647
std_term_plan	plan_code	text	2147483647
std_term_plan_gpa	plan_code	text	2147483647
std_term_plan_plus	plan_code	text	2147483647	√		null
std_term_subplan	plan_code	text	2147483647
std_term_subplan_gpa	plan_code	text	2147483647
std_transfer_credit_school	plan_code	text	2147483647
pps_plan	plan_comment	text	2147483647	√		null
pps_plan_history	plan_comment	text	2147483647	√		null
std_term_plan_plus	plan_comment	text	2147483647	√		null
pps_plan	plan_diploma_description	text	2147483647	√		null
pps_plan_history	plan_diploma_description	text	2147483647	√		null
std_term_plan_plus	plan_diploma_description	text	2147483647	√		null
std_degree_plan	plan_position	int4	10
std_plan_history	plan_position	int4	10
std_term_plan	plan_position	int4	10
std_term_plan_plus	plan_position	int4	10	√		null
pps_plan	plan_short_title	text	2147483647
pps_plan_history	plan_short_title	text	2147483647
std_term_plan_plus	plan_short_title	text	2147483647	√		null
pps_plan	plan_title	text	2147483647
pps_plan_history	plan_title	text	2147483647
std_term_plan_plus	plan_title	text	2147483647	√		null
pps_plan	plan_transcript_description	text	2147483647
pps_plan_history	plan_transcript_description	text	2147483647
std_term_plan_plus	plan_transcript_description	text	2147483647	√		null
pps_plan	plan_type_code	text	2147483647
pps_plan_history	plan_type_code	text	2147483647
std_term_plan_plus	plan_type_code	text	2147483647	√		null
pps_service_indicator	positive_indicator	bool	1
std_address	postal	text	2147483647	√		null
off_association	primary_component_code	text	2147483647	√		null
std_term	primary_program_code	text	2147483647
std_term_course_demand	priority	int4	10	√		null
std_student	privacy_flag	bool	1
update_notification	process_code	text	2147483647				The Quest process code of the notification
update_process	process_code	text	2147483647
update_run_notification	process_code	text	2147483647
update_process	process_description	text	2147483647
update_notification	process_id	int4	10				The Quest process ID of the notification
std_program_history	program_action	text	2147483647
std_term_program	program_action	text	2147483647
std_term_program_plus	program_action	text	2147483647	√		null
pps_program	program_active	bool	1
pps_program_history	program_active	bool	1
pps_program	program_as_of	date	13
pps_program_history	program_as_of	date	13
std_plan_history	program_as_of	date	13
std_program_history	program_as_of	date	13
std_subplan_history	program_as_of	date	13
std_term_program	program_as_of	date	13
std_term_program_plus	program_as_of	date	13	√		null
pps_plan	program_code	text	2147483647	√		null
pps_plan_history	program_code	text	2147483647	√		null
pps_program	program_code	text	2147483647
pps_program_history	program_code	text	2147483647
std_program_history	program_code	text	2147483647
std_program_milestone	program_code	text	2147483647
std_program_plan_milestone	program_code	text	2147483647
std_term_plan_plus	program_code	text	2147483647	√		null
std_term_program	program_code	text	2147483647
std_term_program_plus	program_code	text	2147483647	√		null
std_transfer_credit_school	program_code	text	2147483647
std_program_history	program_reason	text	2147483647	√		null
std_term_program	program_reason	text	2147483647	√		null
std_term_program_plus	program_reason	text	2147483647	√		null
std_plan_history	program_sequence	int4	10
std_program_history	program_sequence	int4	10
std_subplan_history	program_sequence	int4	10
std_term_program	program_sequence	int4	10
std_term_program_plus	program_sequence	int4	10	√		null
pps_program	program_short_title	text	2147483647
pps_program_history	program_short_title	text	2147483647
std_term_program_plus	program_short_title	text	2147483647	√		null
std_program_history	program_status	text	2147483647
std_term_program	program_status	text	2147483647
std_term_program_plus	program_status	text	2147483647	√		null
pps_program	program_title	text	2147483647
pps_program_history	program_title	text	2147483647
std_term_program_plus	program_title	text	2147483647	√		null
std_term	projected_level	text	2147483647	√		null
std_address	prov	text	2147483647	√		null
pps_service_indicator_reason	reason	text	2147483647
pps_service_indicator_reason	reason_as_of	date	13
std_term	registration_status	quest_registration_status	2147483647	√		null
off_association	requirement_designation	text	2147483647	√		null
std_term_course	requirement_designation	text	2147483647	√		null
std_transfer_credit_detail	requirement_designation	text	2147483647	√		null
std_term_course	requirement_designation_grade	text	2147483647	√		null
std_plan_history	requirement_term_id	quest_term_id	2147483647	√		null
std_program_history	requirement_term_id	quest_term_id	2147483647	√		null
std_subplan_history	requirement_term_id	quest_term_id	2147483647
std_term_plan	requirement_term_id	quest_term_id	2147483647
std_term_plan_plus	requirement_term_id	quest_term_id	2147483647	√		null
std_term_program	requirement_term_id	quest_term_id	2147483647
std_term_program_plus	requirement_term_id	quest_term_id	2147483647	√		null
std_term_subplan	requirement_term_id	quest_term_id	2147483647
cal_requisite	requisite_active	bool	1
cal_requisite_history	requisite_active	bool	1
cal_requisite	requisite_as_of	date	13
cal_requisite_history	requisite_as_of	date	13
cal_requisite	requisite_brief_description	text	2147483647
cal_requisite_history	requisite_brief_description	text	2147483647
cal_requisite	requisite_description	text	2147483647
cal_requisite_history	requisite_description	text	2147483647
cal_course_label	requisite_id	quest_requisite_id	2147483647	√		null
cal_course_label_history	requisite_id	quest_requisite_id	2147483647	√		null
cal_requisite	requisite_id	int4	10
cal_requisite_history	requisite_id	int4	10
off_course_section_complete	requisite_id	quest_requisite_id	2147483647	√		null
off_course_section_plus	requisite_id	quest_requisite_id	2147483647	√		null
off_course_section_reserve	requisite_id	int4	10
cal_requisite	requisite_short_description	text	2147483647
cal_requisite_history	requisite_short_description	text	2147483647
off_course_section_reserve	reserve_enrol_limit	int4	10
off_course_section_reserve	reserve_enrol_total	int4	10
off_course_section_reserve	reserve_id	int4	10
std_term_section	reserve_id	int4	10	√		null
off_course_section_reserve	reserve_start_date	date	13
std_term_units	reset_cum_stats	bool	1
std_term_units	resident_terms_adjustment	numeric	6,3
std_term_units	resident_terms_credited	numeric	6,3
off_instruct_section_meet_plus	room_capacity	int4	10	√		null
uw_room	room_capacity	int4	10
off_instruct_section_meet_plus	room_code	text	2147483647	√		null
uw_room	room_code	text	2147483647
off_instruct_section_meet_plus	room_description	text	2147483647	√		null
uw_room	room_description	text	2147483647
update_run	run_created	timestamp	29,6			now()	When this run was created
update_notification	run_id	int4	10	√		null	The run_id, if any, this notification contributes to making ready
update_run	run_id	serial	10		√	nextval('_quest.update_run_run_id_seq'::regclass)
update_run_notification	run_id	int4	10
update_run	run_loaded	timestamp	29,6	√		null	When the data update process for this run finished
update_run	run_ready	timestamp	29,6	√		null	When the final notification for this run was received
std_transfer_credit_school	school_type	text	2147483647
off_course_section	section_add_consent	quest_consent	2147483647
off_course_section_complete	section_add_consent	quest_consent	2147483647	√		null
off_course_section_plus	section_add_consent	quest_consent	2147483647	√		null
off_course_section	section_code	text	2147483647
off_course_section_complete	section_code	text	2147483647	√		null
off_course_section_plus	section_code	text	2147483647	√		null
off_instruct_section	section_combined_type	quest_combined_type	2147483647	√		null
off_course_section	section_drop_consent	quest_consent	2147483647
off_course_section_complete	section_drop_consent	quest_consent	2147483647	√		null
off_course_section_plus	section_drop_consent	quest_consent	2147483647	√		null
off_course_section	section_enrol_status	quest_course_enrol_status	2147483647
off_course_section_complete	section_enrol_status	quest_course_enrol_status	2147483647	√		null
off_course_section_plus	section_enrol_status	quest_course_enrol_status	2147483647	√		null
off_instruct_section	section_enrolment	bool	1				Whether the section is an enrolment (primary) section
off_course_section	section_id	int4	10
off_course_section_complete	section_id	int4	10	√		null
off_course_section_plus	section_id	int4	10	√		null
off_instruct_section	section_id	int4	10
off_instruct_section_instructor	section_id	int4	10
off_instruct_section_instructor_plus	section_id	int4	10	√		null
off_instruct_section_meet	section_id	int4	10
off_instruct_section_meet_plus	section_id	int4	10	√		null
off_course_section_note	section_note_id	int4	10	√		null
off_course_section	section_schedule_print	bool	1
off_course_section_complete	section_schedule_print	bool	1	√		null
off_course_section_plus	section_schedule_print	bool	1	√		null
off_instruct_section	section_status	quest_section_status	2147483647	√		null	The status of the section
std_transfer_credit_detail	seq_num	int4	10
pps_service_indicator_impact	service_impact_as_of	date	13
pps_service_indicator_impact	service_impact_code	text	2147483647
pps_service_indicator	service_indicator_as_of	date	13
std_service_indicator	service_indicator_as_of	timestamp	29,6
pps_service_indicator	service_indicator_code	text	2147483647
pps_service_indicator_impact	service_indicator_code	text	2147483647
pps_service_indicator_reason	service_indicator_code	text	2147483647
std_service_indicator	service_indicator_code	text	2147483647
pps_service_indicator_reason	service_indicator_reason	text	2147483647
std_service_indicator	service_indicator_reason	text	2147483647
off_association	session_code	quest_session	2147483647
off_course_section	session_code	quest_session	2147483647
off_course_section_complete	session_code	quest_session	2147483647	√		null
off_course_section_plus	session_code	quest_session	2147483647	√		null
off_instruct_section	session_code	quest_session	2147483647				The session of the section
std_student	sex	quest_sex	2147483647
std_program_milestone	short_description	text	2147483647
std_program_plan_milestone	short_description	text	2147483647
pps_service_indicator_reason	short_reason	text	2147483647
pps_service_indicator	short_title	text	2147483647
std_transfer_credit_school	source_school_name	text	2147483647
std_term	standing_action_date	date	13	√		null
pps_standing	standing_brief_description	text	2147483647
pps_standing	standing_code	text	2147483647
std_term	standing_code	text	2147483647	√		null
pps_standing	standing_description	text	2147483647
std_term	standing_program_code	text	2147483647	√		null
pps_standing	standing_short_description	text	2147483647
std_term	standing_status	quest_standing_status	2147483647	√		null
pps_standing	standing_status_code	quest_standing_status	2147483647
std_term	study_agreement	text	2147483647	√		null
cal_subject	subject_active	bool	1
cal_subject_history	subject_active	bool	1
cal_subject	subject_as_of	date	13
cal_subject_history	subject_as_of	date	13
cal_course_label	subject_code	text	2147483647
cal_course_label_history	subject_code	text	2147483647
cal_subject	subject_code	text	2147483647
cal_subject_history	subject_code	text	2147483647
off_course_section_complete	subject_code	text	2147483647	√		null
off_course_section_plus	subject_code	text	2147483647	√		null
cal_subject	subject_description	text	2147483647
cal_subject_history	subject_description	text	2147483647
cal_subject	subject_short_description	text	2147483647
cal_subject_history	subject_short_description	text	2147483647
pps_subplan	subplan_active	bool	1
pps_subplan_history	subplan_active	bool	1
pps_subplan	subplan_as_of	date	13
pps_subplan_history	subplan_as_of	date	13
pps_subplan	subplan_code	text	2147483647
pps_subplan_history	subplan_code	text	2147483647
std_degree_subplan	subplan_code	text	2147483647
std_subplan_history	subplan_code	text	2147483647
std_term_subplan	subplan_code	text	2147483647
std_term_subplan_gpa	subplan_code	text	2147483647
pps_subplan	subplan_diploma_description	text	2147483647	√		null
pps_subplan_history	subplan_diploma_description	text	2147483647	√		null
pps_subplan	subplan_short_title	text	2147483647
pps_subplan_history	subplan_short_title	text	2147483647
pps_subplan	subplan_title	text	2147483647
pps_subplan_history	subplan_title	text	2147483647
pps_subplan	subplan_transcript_description	text	2147483647
pps_subplan_history	subplan_transcript_description	text	2147483647
pps_subplan	subplan_type	quest_subplan_type	2147483647
pps_subplan_history	subplan_type	quest_subplan_type	2147483647
off_instruct_section_instructor_plus	surname	text	2147483647	√		null
std_term_units	term_academic_units_attempted	numeric	8,3
std_term_units	term_academic_units_passed	numeric	8,3
pps_service_indicator_impact	term_category	text	2147483647	√		null
uw_term	term_class_dates	daterange	2147483647
uw_term	term_dates	daterange	2147483647
uw_term	term_exam_dates	daterange	2147483647	√		null
std_term	term_gpa	numeric	8,3
std_term_units	term_grade_points	numeric	9,3
off_association	term_id	quest_term_id	2147483647
off_course	term_id	quest_term_id	2147483647
off_course_as_of	term_id	quest_term_id	2147483647
off_course_section	term_id	quest_term_id	2147483647
off_course_section_complete	term_id	quest_term_id	2147483647	√		null
off_course_section_note	term_id	quest_term_id	2147483647
off_course_section_plus	term_id	quest_term_id	2147483647	√		null
off_course_section_reserve	term_id	quest_term_id	2147483647
off_instruct_section	term_id	quest_term_id	2147483647
off_instruct_section_instructor	term_id	quest_term_id	2147483647
off_instruct_section_instructor_plus	term_id	quest_term_id	2147483647	√		null
off_instruct_section_meet	term_id	quest_term_id	2147483647
off_instruct_section_meet_plus	term_id	quest_term_id	2147483647	√		null
std_term	term_id	quest_term_id	2147483647
std_term_course	term_id	quest_term_id	2147483647
std_term_course_demand	term_id	quest_term_id	2147483647
std_term_plan	term_id	quest_term_id	2147483647
std_term_plan_gpa	term_id	quest_term_id	2147483647
std_term_plan_plus	term_id	quest_term_id	2147483647	√		null
std_term_program	term_id	quest_term_id	2147483647
std_term_program_plus	term_id	quest_term_id	2147483647	√		null
std_term_section	term_id	quest_term_id	2147483647
std_term_subplan	term_id	quest_term_id	2147483647
std_term_subplan_gpa	term_id	quest_term_id	2147483647
std_term_units	term_id	quest_term_id	2147483647
uw_term	term_id	quest_term_id	2147483647
std_term_units	term_units_attempted_in_gpa	numeric	8,3
std_term_units	term_units_attempted_not_in_gpa	numeric	8,3				Includes non-academic (PD) courses.
std_term_units	term_units_audited	numeric	8,3
std_term_units	term_units_in_progress_not_towards_gpa	numeric	8,3
std_term_units	term_units_in_progress_towards_gpa	numeric	8,3
std_term_units	term_units_passed_in_gpa	numeric	8,3
std_term_units	term_units_passed_not_in_gpa	numeric	8,3
std_term_units	term_units_total	numeric	8,3
std_term_units	term_units_transferred	numeric	8,3
pps_service_indicator	title	text	2147483647
cal_course_topic	topic_seq	int4	10
cal_course_topic_history	topic_seq	int4	10
off_course_section	topic_seq	int4	10	√		null
off_course_section_complete	topic_seq	int4	10	√		null
off_course_section_plus	topic_seq	int4	10	√		null
cal_course_topic	topic_short_title	text	2147483647
cal_course_topic_history	topic_short_title	text	2147483647
off_course_section_complete	topic_short_title	text	2147483647	√		null
off_course_section_plus	topic_short_title	text	2147483647	√		null
cal_course_topic	topic_title	text	2147483647
cal_course_topic_history	topic_title	text	2147483647
off_course_section_complete	topic_title	text	2147483647	√		null
off_course_section_plus	topic_title	text	2147483647	√		null
std_term_course	transcript_note	text	2147483647	√		null
std_term	transcript_text	text	2147483647	√		null
std_transfer_credit_detail	transfer_group	int4	10
std_transfer_credit_school	transfer_group	int4	10
std_transfer_credit_school	transfer_units_attempted_not_towards_gpa	numeric	8,3	√		null
std_transfer_credit_school	transfer_units_attempted_towards_gpa	numeric	8,3	√		null
std_transfer_credit_school	transfer_units_passed_not_toward_gpa	numeric	8,3	√		null
std_transfer_credit_school	transfer_units_passed_toward_gpa	numeric	8,3	√		null
std_transfer_credit_school	transferred_gpa	numeric	8,3	√		null
std_term_units	transferred_grade_points	numeric	9,3
std_transfer_credit_school	transferred_grade_points	numeric	9,3	√		null
std_term_units	transferred_units_attempted_not_towards_gpa	numeric	8,3
std_term_units	transferred_units_attempted_towards_gpa	numeric	8,3
std_term_units	transferred_units_passed_in_gpa	numeric	8,3
std_term_units	transferred_units_passed_not_in_gpa	numeric	8,3
uw_unit	unit_active	bool	1
uw_unit_history	unit_active	bool	1
uw_unit	unit_as_of	date	13
uw_unit_history	unit_as_of	date	13
cal_course_label	unit_code	text	2147483647
cal_course_label_history	unit_code	text	2147483647
cal_subject	unit_code	text	2147483647
cal_subject_history	unit_code	text	2147483647
off_course_section_complete	unit_code	text	2147483647	√		null
off_course_section_plus	unit_code	text	2147483647	√		null
off_instruct_section_meet_plus	unit_code	text	2147483647	√		null
pps_plan	unit_code	text	2147483647
pps_plan_history	unit_code	text	2147483647
pps_program	unit_code	text	2147483647
pps_program_history	unit_code	text	2147483647
std_term_plan_plus	unit_code	text	2147483647	√		null
uw_room	unit_code	text	2147483647	√		null
uw_unit	unit_code	text	2147483647
uw_unit_history	unit_code	text	2147483647
uw_unit	unit_description	text	2147483647
uw_unit_history	unit_description	text	2147483647
uw_unit	unit_full_description	text	2147483647
uw_unit_history	unit_full_description	text	2147483647
uw_unit	unit_short_description	text	2147483647
uw_unit_history	unit_short_description	text	2147483647
std_term_course	units_attempted	numeric	5,2
std_transfer_credit_school	units_attempted	numeric	5,2	√		null
std_term_course	units_attempted_code	quest_completion_code	2147483647
std_transfer_credit_detail	units_attempted_code	quest_completion_code	2147483647
std_term_course	units_earned	numeric	5,2
std_term_course	units_for_progress	numeric	5,2
std_transfer_credit_detail	units_taken	numeric	5,2	√		null
std_transfer_credit_detail	units_transferred	numeric	8,3
std_transfer_credit_school	units_transferred	numeric	8,3	√		null
off_instruct_section_instructor	userid	text	2147483647	√		null
off_instruct_section_instructor_plus	userid	text	2147483647	√		null
std_student	userid	quest_userid	2147483647	√		null
off_instruct_section_instructor	uw_id	quest_uw_id	2147483647
std_address	uw_id	quest_uw_id	2147483647
std_degree	uw_id	quest_uw_id	2147483647
std_degree_honour	uw_id	quest_uw_id	2147483647
std_degree_plan	uw_id	quest_uw_id	2147483647
std_degree_subplan	uw_id	quest_uw_id	2147483647
std_name	uw_id	quest_uw_id	2147483647
std_name_preferred	uw_id	quest_uw_id	2147483647	√		null
std_name_primary	uw_id	quest_uw_id	2147483647	√		null
std_photo	uw_id	quest_uw_id	2147483647
std_plan_history	uw_id	quest_uw_id	2147483647
std_program_history	uw_id	quest_uw_id	2147483647
std_program_milestone	uw_id	quest_uw_id	2147483647
std_program_plan_milestone	uw_id	quest_uw_id	2147483647
std_service_indicator	uw_id	quest_uw_id	2147483647
std_student	uw_id	quest_uw_id	2147483647
std_subplan_history	uw_id	quest_uw_id	2147483647
std_term	uw_id	quest_uw_id	2147483647
std_term_course	uw_id	quest_uw_id	2147483647
std_term_course_demand	uw_id	quest_uw_id	2147483647
std_term_plan	uw_id	quest_uw_id	2147483647
std_term_plan_gpa	uw_id	quest_uw_id	2147483647
std_term_plan_plus	uw_id	quest_uw_id	2147483647	√		null
std_term_program	uw_id	quest_uw_id	2147483647
std_term_program_plus	uw_id	quest_uw_id	2147483647	√		null
std_term_section	uw_id	quest_uw_id	2147483647
std_term_subplan	uw_id	quest_uw_id	2147483647
std_term_subplan_gpa	uw_id	quest_uw_id	2147483647
std_term_units	uw_id	quest_uw_id	2147483647
std_transfer_credit_detail	uw_id	quest_uw_id	2147483647
std_transfer_credit_school	uw_id	quest_uw_id	2147483647
std_term_course	valid_attempt	bool	1	√		null
std_transfer_credit_detail	valid_attempt	bool	1
std_term	withdraw_code	quest_withdraw_code	2147483647
std_term	withdraw_date	date	13	√		null
std_term	withdraw_reason	text	2147483647	√		null
std_student	wlu_id	text	2147483647	√		null