The Department Table (ORG_DEPT) contains the following information:
| Description | SQL Name | Length | Notes |
|---|---|---|---|
| Department Code | DEPT_CD | 5 | primary key |
| Name | DEPT_NAME | 30 | |
| Abbreviation | DEPT_ABBRV | 15 | |
| Campus Address | DEPT_CAMPUS_ADDR | 30 | |
| Street Address | DEPT_STREET_ADDR | 30 | |
| City | DEPT_CITY | 15 | |
| State | DEPT_ST | 2 | |
| Zip Code | DEPT_ZIP | 9 | |
| Telephone | DEPT_PHONE | 10 | |
| Responsible Person SSN | DEPT_RESP_SSN | 9 | |
| FRS Primary Account | DEPT_ACCT | 10 | |
| School Code | SCHL_CD | 2 | foreign key |
| Email Contact | DEPT_EMAIL_CNTCT | 40 | |
| SIS Department Code | DEPT_SIS_DEPT | 4 | |
| Status | DEPT_STAT | 1 | |
| Last Updated | DEPT_LST_UPDT | timestamp | |
| College Code | COL_CD | 2 | |
| Division Code | DIV_CD | 2 | |
The Status indicates whether this table row is Active or Inactive.