odyssey_test._watiam contains 47 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
check_duplicate_hr_id	pdbids	_int4	10	√		null
check_duplicate_ts_id	pdbids	_int4	10	√		null
check_duplicate_uw_id	pdbids	_int4	10	√		null
watiam_entry	ou	_text	2147483647	√		null	Active Directory OU, separated into components
watiam_entry	visible	bool	1				Privacy request, do not publish if FALSE
watiam_entry	activated	date	13	√		null	Date authentication token assigned
watiam_entry	created	date	13	√		null	Date entry created
watiam_entry	expires	date	13	√		null	Date entry should expire
watiam_entry	lastchanged	date	13	√		null	Date entry last changed
watiam_entry	lastmentioned	date	13	√		null	Date last mentioned in authoritative source
watiam_dept_num	dept_code_seq	int4	10
watiam_dept_name	dept_name_seq	int4	10
check_duplicate_hr_id	hr_id	int4	10	√		null
watiam_entry	hr_id	int4	10	√		null	First HR ID number
watiam_hr_id	hr_id	int4	10
watiam_hr_id	hr_id_seq	int4	10
watiam_office	office_seq	int4	10
watiam_dept_name	pdbid	int4	10
watiam_dept_num	pdbid	int4	10
watiam_entry	pdbid	int4	10				Persistent DB Identifier
watiam_hr_id	pdbid	int4	10
watiam_office	pdbid	int4	10
watiam_phone	pdbid	int4	10
watiam_ts_id	pdbid	int4	10
watiam_uw_id	pdbid	int4	10
watiam_phone	phone_seq	int4	10
check_duplicate_ts_id	ts_id	int4	10	√		null
watiam_entry	ts_id	int4	10	√		null	First Telephone Services ID number
watiam_ts_id	ts_id	int4	10
watiam_ts_id	ts_id_seq	int4	10
check_duplicate_uw_id	uw_id	int4	10	√		null
watiam_entry	uw_id	int4	10	√		null	First student ID number
watiam_uw_id	uw_id	int4	10
watiam_uw_id	uw_id_seq	int4	10
watiam_entry	authority	text	2147483647	√		null	Authority who created entry
watiam_entry	campus_email	text	2147483647	√		null
watiam_dept_num	dept_code	text	2147483647
watiam_dept_name	dept_name	text	2147483647
watiam_entry	email	text	2147483647	√		null	Electronic mail (example, jsmith@forestry.uwaterloo.ca)
watiam_entry	givennames	text	2147483647	√		null	Given names (example, John Edward)
watiam_entry	homepage	text	2147483647	√		null	Personal web page (example, http://forestry.uwaterloo.ca/~jsmith)
watiam_entry	nicknames	text	2147483647	√		null	Familiar names (example, Ted)
watiam_office	office	text	2147483647
watiam_phone	phone	text	2147483647
watiam_entry	surname	text	2147483647				Surname (example, Smith)
watiam_entry	userid	text	2147483647				Standard UW userid (maximum 8 characters)
watiam_entry	useridext	text	2147483647				Additional UW userid characters; concatenate with userid to get full long userid