| Name | Description | Data type | Constraints |
|---|---|---|---|
| graduid | student's CalNet LDAP UID number | NUMBER(9) | |
| empid | faculty member's employee ID number | NUMBER(9) | |
| advuid | faculty member's CalNet LDAP UID number | NUMBER(9) | |
| lname | faculty's last name | VARCHAR2(30) | |
| fnames | faculty's first name(s) | VARCHAR2(30) | |
| name | faculty's full name (first last) | VARCHAR2(61) | |
| advtype | code for type of adviser (r = research, a = academic, t = temporary) | CHAR(1) |