| 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. |
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). |
EXTRACT_DATE
Indexed - no
Format - date
May be null? yes |
The date the row was extracted from TRIRIGA to the Data Warehouse. |
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) |
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. |
