HR PERSON BUILDINGS Table
View exposing person-to-building associations including person identifiers and building-related attributes used for location and facilities reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_NUMBER |
Column ADDRESS_NUMBER. |
VARCHAR2 |
10 |
BUILDING_NAME |
Column BUILDING_NAME. |
VARCHAR2 |
64 |
BUILDING_NUMBER |
Column BUILDING_NUMBER. |
VARCHAR2 |
8 |
DIR_BUILDING_NAME |
Column DIR_BUILDING_NAME. |
VARCHAR2 |
64 |
DIR_BUILDING_NUMBER |
Column DIR_BUILDING_NUMBER. |
VARCHAR2 |
12 |
DIR_BUILDING_NUMBER_MIXED |
Column DIR_BUILDING_NUMBER_MIXED. |
VARCHAR2 |
12 |
INTEROFFICE_MAIL_DELIVERABLE |
Column INTEROFFICE_MAIL_DELIVERABLE. |
VARCHAR2 |
1 |
MAILROOM_ADDRESS1 |
Column MAILROOM_ADDRESS1. |
VARCHAR2 |
30 |
MAILROOM_ADDRESS2 |
Column MAILROOM_ADDRESS2. |
VARCHAR2 |
30 |
MAILROOM_ADDRESS3 |
Column MAILROOM_ADDRESS3. |
VARCHAR2 |
30 |
MASTER_BUILDING |
Column MASTER_BUILDING. |
VARCHAR2 |
8 |
MIT_BUILDING_MAIL_ADDRESS |
Column MIT_BUILDING_MAIL_ADDRESS. |
VARCHAR2 |
80 |
MIT_BUILDING_STREET_ADDRESS |
Column MIT_BUILDING_STREET_ADDRESS. |
VARCHAR2 |
36 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
MIT_RECORD_EXISTS_IN_ZROOM |
Column MIT_RECORD_EXISTS_IN_ZROOM. |
VARCHAR2 |
1 |
MIT_ROOM_NUMBER_REQUIRED |
Column MIT_ROOM_NUMBER_REQUIRED. |
VARCHAR2 |
1 |
OFFICE_TYPE |
Column OFFICE_TYPE. |
VARCHAR2 |
9 |
PHONE |
Column PHONE. |
VARCHAR2 |
14 |
SITE_ID |
Column SITE_ID. |
VARCHAR2 |
2 |
STATUS |
Column STATUS. |
VARCHAR2 |
1 |
VALID_PHONEBOOK_ADDRESS |
Column VALID_PHONEBOOK_ADDRESS. |
VARCHAR2 |
1 |