FCLT ROOMS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCESS_LEVEL |
XXX |
VARCHAR2 |
4 |
AREA |
The square footage of a particular space. In BUDGET GROUPINGS, AREA refers to the budget area. |
NUMBER |
32,20 |
BUILDING_ROOM |
The combined building and room number of a particular room or space within an MIT building: for example, N42-240X is room 240X in Building N42. |
VARCHAR2 |
16 |
DEPT_CODE |
XXX |
VARCHAR2 |
16 |
EASTING_SPCS |
XXX |
NUMBER |
32,20 |
FCLT_BUILDING_KEY |
XXX |
VARCHAR2 |
8 |
FCLT_FLOOR_KEY |
XXX |
VARCHAR2 |
12 |
FCLT_MAJOR_USE_KEY |
XXX |
VARCHAR2 |
16 |
FCLT_MINOR_ORGANIZATION_KEY |
XXX |
VARCHAR2 |
16 |
FCLT_MINOR_USE_KEY |
XXX |
VARCHAR2 |
16 |
FCLT_ORGANIZATION_KEY |
XXX |
VARCHAR2 |
16 |
FCLT_ROOM_KEY |
XXX |
VARCHAR2 |
16 |
FCLT_USE_KEY |
XXX |
VARCHAR2 |
16 |
FLOOR |
The floor number. for example: E19-332B; building: E19; Floor: 3; Room: 32B |
VARCHAR2 |
4 |
LATITUDE_WGS |
XXX |
NUMBER |
32,20 |
LONGITUDE_WGS |
XXX |
NUMBER |
32,20 |
MAJOR_USE_DESC |
XXX |
VARCHAR2 |
12 |
MINOR_ORGANIZATION |
XXX |
VARCHAR2 |
32 |
MINOR_USE_DESC |
XXX |
VARCHAR2 |
16 |
NORTHING_SPCS |
XXX |
NUMBER |
32,20 |
ORGANIZATION_NAME |
The name of the MIT Department or Unit to which the project is assigned, usually the home unit or the Principal Investigator or Co-Investigator. |
VARCHAR2 |
32 |
ROOM |
XXX |
VARCHAR2 |
8 |
ROOM_FULL_NAME |
XXX |
VARCHAR2 |
64 |
SPACE_ID |
XXX |
VARCHAR2 |
21 |
USE_DESC |
XXX |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |