Penn Computing

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

BUILDINGS Table - Data Element Index

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



Data Element Definition

BUILDING_ADDRESS_1

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

First line of the building's street address.
BUILDING_ADDRESS_2

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

No longer in use following the upgrade from FacilityCenter to TRIRIGA in April 2014 (during the upgrade, data previously stored in BUILDING_ADDRESS_2 was concatenated to BUILDING_ADDRESS_1.)

Second line of the building's street address.

BUILDING_ALIAS

Indexed - yes
Format - char(40)
May be null? yes

First line of the building's street address.

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.

BUILDING_FORMER_NAME

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

Previous names for the building are stored as a string value; may be null.

BUILDING_LOCATION

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

A concatenation of Property and Building Codes to uniquely identify the building. The location code is built by TRIRIGA.
BUILDING_NAME

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

The full name of the building, as assigned by the Architects' Office.

BUILDING_TRUSTEE_NAME

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

Official name assigned by the Trustees to the building; may be null.

CULTURAL_RESOURCE

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

Identifies the type of cultural resource represented by a particular building.

HIGH_RISE_CODE

Indexed -
Format - char(40)
May be null?

A yes/no code which indicates whether or not a building is classified as a high rise.

HISTORICAL_CERTIFICATION

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

Identifes the historical registry, either national or local, to which the building belongs.

IDD_STATUS

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

A yes/no code which indicates whether or not a building is capable of subscription to Internet Data Distribution on the internet.

ORIGINAL_ARCHITECT

Indexed - yes
Format - char(40)
May be null? yes

The name of the architect or architectural firm responsible for the design of a building.

OWN_LEASE_INDICATOR

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

Indicates whether a building is owned by the university or leased. This flag is a gross indicator to be used with caution. Check the building's ownership data for more accuracy.

OWNERSHIP

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

Ownership and lease status information for buildings

PRIMARY_USE

Indexed - yes
Format - char(40)
May be null? yes

Identifies the basic purpose for the building.

PROPERTY_CODE

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

The larger area which contains buildings. Most common use is the 'CAMPUS' designation to identify buildings contained within the West Philadelphia main campus of the University.

RENOV_ADD_ARCHITECT

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

The name of the architect or architects responsible for any renovation or addition to a building.
 
BUILDINGS 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