The Sub-Department Table (ORG_SUBDEPT) contains the following information:
Description | SQL Name | Length | Notes |
---|---|---|---|
Department Code | DEPT_CD | 5 | primary key #1 and foreign key |
Sub-Department Code | SD_SUBDEPT_CD | 5 | primary key #2 |
Name | SD_NAME | 30 | |
Abbreviation | SD_ABBRV | 15 | |
Campus Address | SD_CAMPUS_ADDR | 30 | |
Street Address | SD_STREET_ADDR | 30 | |
City | SD_CITY | 15 | |
State | SD_ST | 2 | |
Zip Code | SD_ZIP | 9 | |
Telephone | SD_PHONE | 10 | |
Responsible Person SSN | SD_RESP_SSN | 9 | |
FRS Primary Account | SD_ACCT | 10 | |
Email Contact | SD_EMAIL_CNTCT | 40 | |
Previous Sub-Department Code | SD_PRV_CD | 3 | |
Status | SD_STAT | 1 | |
Last Updated | SD_LST_UPDT | timestamp | |
School Code | SCHL_CD | 2 | |
College Code | COL_CD | 2 | |
Division Code | DIV_CD | 2 |
The Status indicates whether this table row is Active or Inactive.
Last Modified: Thursday, 05-Oct-2000 08:00:23 CDT
©2000 All Rights Reserved