Column | Type | Length | Contents |
---|---|---|---|
ID | int | Student ID number | |
Seq | int | Sequence number | |
EmailAddr | varchar | 50 | e-mail address |
EmailPrio | tinyint | Priority rank if more than 1 e-mail address is active | |
EffDt | smalldatetime | Effective date | |
ExpDt | smalldatetime | Expiration date | |
Release | char | 1 | Flag to indicate that address may be released (Y=yes, N=no, blank=yes) |
MaintDt | datetime | Last date record was updated | |
LastChgName | char | 45 | Name of last user who updated the record |
OrigDt | datetime | Date the record was originally created |