Htv address

back to htv views

Column	Type	Length	Contents
ID	wuid		Student ID number
AddrType	char	1	Address type code
AddressType	char	1	Address type description
Seq	tinyint		Sequence number
EffDt	datetime		Effective date
ExpDt	datetime		Expiration date
MailToCodes	char	6	This field is not in use
Salutation	varchar	40	Salutation
Name	varchar	33	Non-student name
City	char	16	City
State	char	2	State abbreviation
Zip	char	9	Zipcode
Phone	char	15	Area code and phone number
Box	char	4	Campus Box number
UCEmplPay	char	1	Flag used by University College
RlseAddr	char	1	Flag to indicate that address may be released (Y=yes, N=no, blank=yes)
RlsePhone	char	1	Flag to indicate that phone number may be released (Y=yes, N=no, blank=yes)
AddrLn1	varchar	40	Address line 1
AddrLn2	varchar	40	Address line 2
AddrLn3	varchar	40	Address line 3
AddrLn4	varchar	40	The field is not in use
AddrLn5	varchar	40	Foreign city
Country	varchar	34	Foreign country
CountryCd	char	4	Country code
CellPhone	char	15	Cell phone number
Pager	char	15	Pager number
MaintDt	datetime		Last date record was updated
LastChgName	char	45	ID of last user who updated the record
OrigDt	datetime		Date the record was originally created