Skip to content Accesskey=4Skip to sub-navigation Accesskey=3View our Accessibility Options MIT Information Services and Technology Home About IS&T Contact IS&T Site Map Search Advanced Search
Getting StartedGetting Services by Topic or Alphabetically Getting Help

data warehouse logo

 
 Related Links:
 

Data and Reporting Services


ALUM DEPARTMENT Table

 

This table contains information about MIT academic departments as used in the Alumni's system.

 

Field Name

Description

Data Type

Length

ALUM_DEPARTMENT_KEY

XXX

VARCHAR2

7

DEPARTMENT_CODE

Code identifying an academic department, eg. 18 for "Mathematics", 6 for "Electrical Eng & Computer Sci". In the Alumni's tables, the department codes used are different from those used in MITSIS.

VARCHAR2

4

DEPARTMENT_DESCRIPTION

Descriptive text for DEPARTMENT_CODE.

VARCHAR2

50

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8
MIT Home | Getting Started | Getting Services | Getting Help | About IS&T | Accessibility
Ask a technology question or send a comment about this web page.