| 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). |
DATE_MODIFIED
Indexed - no
Format - date
May be null? yes |
The date associated with the most recent update to the ROOMS or ROOM
UTILIZATION records, prior to the extract for SpaceHistory and made through
the Space@Penn Web Updater. Any update to the basic room information (as
contained in this, the ROOMS table) or changes to the program activity
data stored in the ROOMS UTILIZATION table will be reflected in this field. |
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 that contains the room. |
OCCUPANT_PENN_ID
Indexed - yes
Format - char(8)
May be null? no
|
The Penn ID of the University employee who is assigned to work in the
room. Any room can have Occupants, but only rooms designated for research
can have a Principal Investigator. There are no limits to the number of
Occupants that can be assigned to a room. |
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. |
USER_LAST_NAME_MODIFIED
Indexed - no
Format - char(25)
May be null? yes
|
The last name (and first initial) of the person who performed the last
update to the room data, either in the ROOMS or ROOM UTILIZATION tables.
Corresponds to the USER_NAME_MODIFIED. |
USER_NAME_MODIFIED
Indexed - no
Format - varchar2(12)
May be null? yes
|
Erroneously named, this is actually the Penn ID of the person who performed
the last update to the room data prior to the extract to SpaceHistory,
either in the ROOMS or ROOM UTILIZATION tables. |
