HR PERSON BUILDINGS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_NUMBER |
XXX |
VARCHAR2 |
10 |
BUILDING_NAME |
The official MIT name given to a building. For example: Weisner Building, Horace Sayford Ford Building |
VARCHAR2 |
64 |
BUILDING_NUMBER |
The official MIT number given to a building. For example: N42, E19, W89 |
VARCHAR2 |
8 |
DIR_BUILDING_NAME |
XXX |
VARCHAR2 |
64 |
DIR_BUILDING_NUMBER |
XXX |
VARCHAR2 |
12 |
DIR_BUILDING_NUMBER_MIXED |
XXX |
VARCHAR2 |
12 |
INTEROFFICE_MAIL_DELIVERABLE |
XXX |
VARCHAR2 |
1 |
MAILROOM_ADDRESS1 |
XXX |
VARCHAR2 |
30 |
MAILROOM_ADDRESS2 |
XXX |
VARCHAR2 |
30 |
MAILROOM_ADDRESS3 |
XXX |
VARCHAR2 |
30 |
MASTER_BUILDING |
XXX |
VARCHAR2 |
8 |
MIT_BUILDING_MAIL_ADDRESS |
XXX |
VARCHAR2 |
80 |
MIT_BUILDING_STREET_ADDRESS |
XXX |
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 |
XXX |
VARCHAR2 |
1 |
MIT_ROOM_NUMBER_REQUIRED |
XXX |
VARCHAR2 |
1 |
OFFICE_TYPE |
XXX |
VARCHAR2 |
9 |
PHONE |
XXX |
VARCHAR2 |
14 |
SITE_ID |
XXX |
VARCHAR2 |
2 |
STATUS |
In the GRADUATE APPOINTMENT TYPE table, this field indicates the status of the appointment: whether Cancelled or Actual. In the ALUMNI BY COURSE table, this field carries one of these statuses: "Active", "Lost", "Purgable" regarding the MIT alumnus/alumnae. |
VARCHAR2 |
1 |
VALID_PHONEBOOK_ADDRESS |
XXX |
VARCHAR2 |
1 |