The FLOORS Table - Data Element Index


			<< go back

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.

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