Penn Computing

University of Pennsylvania
Penn Computing << go backback
FLOORS Table   Tables and Data Elements   Space@Penn Home   Data Warehouse Home

FLOORS Table - Data Element Index

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



Data Element Definition

BUILDING_CODE

Indexed - yes
Format - char(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.

EXTRACT_DATE

Indexed - no
Format - date
May be null? yes

The date the row was extracted from TRIRIGA to the Data Warehouse.

FLOOR_CODE

Indexed - yes
Format - char(8)
May be null? no

Identifies the floor within the building.

FLOOR_DESCRIPTION

Indexed - yes
Format - char(32)
May be null? no

Free-form text description of the floor.

LOCATION_CODE

Indexed - no
Format - char(72)
May be null? no

A concatenation of Property, Building and Floor Codes to uniquely identify the floor. The location code is built by TRIRIGA.
 
FLOORS Table   Tables and Data Elements   Space@Penn 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