Penn Computing

University of Pennsylvania
Penn Computing << go backback

DEPT Table - Data Element Index . Tables and Data Elements . Student Data Home . Data Warehouse Home

DEPT Table

(dwadmin.dept)

Explanation

Lookup table for alphabetic departmental codes. Contains the department code and a description.

Common Uses

  • Displaying the actual name of a department instead of the department code that appears in one of the Related Tables. ("Don't show the codes in the report. Show the English instead.")
Primary Key Indexed Data Elements Related Tables
DEPARTMENT   COURSE_SECTION, ROOM_PROFILE

Cautions

None.

DEPT Table - Data Element Index . Tables and Data Elements . Student Data Home . Data Warehouse Home

 


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania