odyssey_test._oat contains 92 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
ins_schedule_prefs	accomodations	text	2147483647	√		null
ins_schedule_prefs	additional_info	text	2147483647	√		null
ins_schedule_prefs	back_to_back	bool	1			true
ins_schedule_prefs	emailed_accomodations	bool	1			false
ins_schedule_prefs	faculty	text	2147483647
ins_schedule_prefs	five_days	bool	1			true
ins_schedule_prefs	need_data_projector	bool	1			false
ins_schedule_prefs	pref_time	text	2147483647			'NoPref'::text
ins_schedule_prefs	unit	text	2147483647
ins_schedule_prefs	userid	text	2147483647
mappings	acad_id	int4	10
mappings	bio_id	int4	10	√		null
mappings	new_id	int4	10	√		null
mappings	pix_id	int4	10	√		null
oat_permission	description	text	2147483647				Describe the permission.
oat_permission	parent	permission	2147483647				The parent permission (permissions form a tree).
oat_permission	permission	permission	2147483647				Name of a permission that a user may have.
oat_tag	description	text	2147483647	√		null	Describe the intent of the tag to users.
oat_tag	group_id	text	2147483647				Tags are grouped by application: qry, faq, etc.
oat_tag	label	text	2147483647				The tag displayed to users; may have spaces.
oat_tag	tag	text	2147483647				The tag used within the system; may not have spaces.
oat_tag_content	group_id	text	2147483647
oat_tag_content	id	int4	10				An id from some other table (ie queries, FAQs, etc.).
oat_tag_content	tag	text	2147483647
oat_unit_groups	group_code	text	2147483647
oat_unit_groups	unit_description	text	2147483647
oat_xlate	code	text	2147483647				The code value to be translated.
oat_xlate	field	text	2147483647				Group common codes together. This is typically the name of the field in which the code is found.
oat_xlate	meaning	text	2147483647				The meaning of the code.
pps_plan_core_cs	career_code	quest_career	2147483647	√		null
pps_plan_core_cs	degree_code	text	2147483647	√		null
pps_plan_core_cs	first_valid_term_id	quest_term_id	2147483647	√		null
pps_plan_core_cs	last_admit_term_id	quest_term_id	2147483647	√		null
pps_plan_core_cs	plan_active	bool	1	√		null
pps_plan_core_cs	plan_as_of	date	13	√		null
pps_plan_core_cs	plan_code	text	2147483647	√		null
pps_plan_core_cs	plan_comment	text	2147483647	√		null
pps_plan_core_cs	plan_diploma_description	text	2147483647	√		null
pps_plan_core_cs	plan_short_title	text	2147483647	√		null
pps_plan_core_cs	plan_title	text	2147483647	√		null
pps_plan_core_cs	plan_transcript_description	text	2147483647	√		null
pps_plan_core_cs	plan_type_code	text	2147483647	√		null
pps_plan_core_cs	program_code	text	2147483647	√		null
pps_plan_core_cs	unit_code	text	2147483647	√		null
qry_parameter	description	text	2147483647	√		null	Description of the parameter.
qry_parameter	name	text	2147483647				Name of parameter.
qry_parameter	param_num	int4	10				Sequence number of this parameter.
qry_parameter	param_type	text	2147483647				Type of parameter; reference to qry_parameter_type.
qry_parameter	query_id	int4	10				Query this parameter is for.
qry_parameter_type	convert_to	text	2147483647	√		null
qry_parameter_type	examples	text	2147483647	√		null
qry_parameter_type	param_type	text	2147483647				A short list of example values to display to the user.
qry_parameter_type	regex	regex	2147483647				A regular expression used to validate input for the parameter.
qry_parameter_type	value_list	_text	2147483647	√		null	Values in this field are displayed as a drop-down list.
qry_query	description	text	2147483647				A description of this query.
qry_query	query	text	2147483647				The SQL for the canned query.
qry_query	query_id	serial	10		√	nextval('_oat.qry_query_query_id_seq'::regclass)	Primary key identifying the query.
qry_query	title	text	2147483647				A title for this query.
std_advisor_view	advisor_userid	quest_userid	2147483647				The userid of the advisor who viewed the student.
std_advisor_view	date_viewed	timestamp	29,6			now()	The date (but not time) of the viewing.
std_advisor_view	uw_id	quest_uw_id	2147483647				The uw_id of the student who was viewed by an advisor.
std_note	body	text	2147483647	√		null	The main content of this note, if elaboration is needed on the subject.
std_note	note_category	std_note_category	2147483647				A categorization of the note content (used for filtering).
std_note	note_id	serial	10		√	nextval('_oat.std_note_note_id_seq'::regclass)	Unique identifier for this note.
std_note	origin	text	2147483647				The source of this note. Either an advisor's userid or the name of a program that added the note automatically.
std_note	subject	text	2147483647				A short description of this note.
std_note	uw_id	quest_uw_id	2147483647				Student this note applies to.
std_note	when_added	timestamp	29,6			now()	When this note was added.
std_permission_number	assigned_by	text	2147483647	√		null	Who assigned the permission number.
std_permission_number	assigned_date	timestamp	29,6	√		null	When the permission number was given.
std_permission_number	catalog	text	2147483647				The course catalog number (eg: 135).
std_permission_number	class_id	int4	10				The class ID the permission number is for.
std_permission_number	expiry_date	date	13				The date the permission number expires.
std_permission_number	permission_num	int4	10				The permission number to give out.
std_permission_number	reason	text	2147483647	√		null	Why the permission number was assigned.
std_permission_number	section_code	text	2147483647				The course section number (eg: 001).
std_permission_number	subject_code	text	2147483647				The course subject (eg: CS).
std_permission_number	term_id	quest_term_id	2147483647				The term (eg 1089) this permission number is for.
std_permission_number	uw_id	quest_uw_id	2147483647	√		null	The ID of the student given the permission number.
usr_permission	assigned_by	quest_userid	2147483647				Audit: who assigned it.
usr_permission	assigned_when	timestamp	29,6			now()	Audit: when it was assigned.
usr_permission	permission	permission	2147483647				The permission assigned.
usr_permission	userid	quest_userid	2147483647				The user the permission is assigned to.
usr_user	acad_record_sort_order	oat_sort_order	2147483647			'ASC'::_oat.oat_sort_order	Order in which the terms of the academic record are displayed.
usr_user	added_by	quest_userid	2147483647				Who added this user.
usr_user	added_when	timestamp	29,6			now()	When this user was added.
usr_user	auth_group	text	2147483647				Group of the person that authorized this user; used to show the authorizing user all the people they have authorized.
usr_user	col1_prefixes	regex	2147483647			''::text	Comma-separated list of prefixes (regular expressions) for courses to display in the first column of the academic record.
usr_user	col2_prefixes	regex	2147483647			''::text	Comma-separated list of prefixes (regular expressions) for courses to display in the second column of the academic record.
usr_user	last_change	timestamp	29,6			now()	A timestamp applied when the record is updated (to debug). NULL when first created.
usr_user	notes_sort_order	oat_sort_order	2147483647			'DESC'::_oat.oat_sort_order	Order in which notes are displayed.
usr_user	userid	quest_userid	2147483647				User this set of preferences applies to.