| Data Element |
Definition |
AREA_OCCUPIED_BY_ORG
Indexed - no
Format - number(12,4)
May be null? yes |
Total area (in square feet) occupied by the charge org in the room. |
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). |
CHARGE_ORG
Indexed - yes
Format - char(4)
May be null? no
|
The charge organization. |
EXTRACT_DATE
Indexed - no
Format - date
May be null? yes
|
Date of the last extract 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 that contains the room. |
PERCENT_OCCUPIED_BY_ORG
Indexed - no
Format - number(12,4)
May be null? yes
|
Total percentage of the room occupied by the charge org. |
ROOM_CODE
Indexed - yes
Format - char(16)
May be null? no
|
Uniquely identifies the room within a building. This may contain letters,
numbers, and symbols. |
