| Data Element |
Definition |
AREA_USED
Indexed - no
Format - number(12,4)
May be null? yes
|
Area (in square feet) that is devoted to the selected function or program
activity. |
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 |
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. |
FUNCTION_CODE
Indexed - yes
Format - char(5)
May be null? no
|
Also known as the HEGIS Function Code; relating to the room's function. |
OCCUPYING_ORG
Indexed - yes
Format - char(4)
May be null? no
|
The organization with budget responsiblity for the room. May or may not
be the same as the Responsible Organization. |
PERCENT_USED
Indexed - no
Format - number(12,4)
May be null? yes
|
The percentage of the room reserved for the selected function and program. |
PRINCIPAL_INVESTIGATOR
Indexed - yes
Format - char(8)
May be null? no
|
Penn ID number of the Principal Investigator assigned to the space. |
PROGRAM_CODE
Indexed - yes
Format - char(2)
May be null? no
|
Also known as HEGIS Program Activity code; relating to the room's function. |
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. |
