Penn Computing

University of Pennsylvania
Penn Computing << go backback
BUILDING_CENTER Table   Tables and Data Elements   FRES Work Requests   Data Warehouse Home

BUILDING_CENTER Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
BLDG_CODE

Indexed - yes
Format - varchar2(16)
May be null? no

Unique identifier for a building. Four digits, zero filled, for older buildings; five digits for newer buildings constructed since the implementation of FacilityCenter.

BLDG_DESC

Indexed - no
Format - varchar2(40)
May be null? yes

The name of the building.

CENTER_CODE

Indexed - no
Format - varchar2(2)
May be null? yes

The two character code that represents a specific school or center. The code set is from the University's General Ledger, and has been in use since July 1, 1996.

PGM_CODE

Indexed - no
Format - varchar2(4)
May be null? no

The 4-character program code corresponding to the building.

PGM_DESC

Indexed - no
Format - varchar2(40)
May be null? no

The description corresonding to the program code.


BUILDING_CENTER Table   Tables and Data Elements   FRES Work Requests 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