| 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. |
DATE_MODIFIED
Indexed - no
Format - date
May be null? yes |
The date associated with the most recent update to the OCCUPANT record
through the Space@Penn Web Updater. Any update to the occupant assignments
in the OCCUPANT 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. |
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 occupant assignments. |
