| 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. |
CALENDAR_MONTH
Indexed - yes
Format - char(2)
May be null? yes
|
The calendar month for the ACCOUNTING_PERIOD. For cases in which the snapshot is for the 13th fiscal month, the CALENDAR_MONTH will be set to 13. |
CALENDAR_YEAR
Indexed - yes
Format - char(4)
May be null? yes
|
The calendar year for the ACCOUNTING_PERIOD. The calendar year begins
January 1 and ends December 31. Example: 1996 (the CALENDAR_YEAR for ACCOUNTING_PERIOD
JUL-96). |
CULTURAL_RESOURCE
Indexed - no
Format - char(40)
May be null? yes
|
Identifies the type of cultural resource represented by a particular
building. |
FISCAL_MONTH_SEQ
Indexed - yes
Format - char(2)
May be null? yes
|
The month (or accounting period) of the fiscal year. This field is used
for sorting. Examples: 01 (July); 11 (May). See also FISCAL_YEAR |
FISCAL_YEAR
Indexed - yes
Format - char(4)
May be null? yes
|
The financial year within which the Accounting_Period falls. Penn's fiscal
year begins July 1 of one calendar year and ends June 30 of the next calendar
year. Example: 2000 (fiscal year that began July 1, 1999, and ended June
30, 2000) |
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. |
