| Column | Type | Length | Contents |
|---|
| ID | int | | Student ID number |
| AdvName | char | 45 | Advisor Name |
| AdvID | int | | Advisor ID number |
| AdvBox | char | 4 | Advisor campus box number |
| AdvPhone | char | 15 | Advisor phone number |
| AdvEmail | varchar | 50 | Advisor email address |
| SeqNo | tinyint | | Sequence number |
| Program | varchar | 50 | Academic program |
| Type | char | 12 | Advisor Type |
| StartDt | datetime | | Beginning date for the advisor assignment |
| EndDt | datetime | | Ending date for the advisor assignment |
| 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 |