Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP NEGOTIATION LOCATION Table


View exposing negotiation location information including meeting venue, facility information, and physical or virtual meeting attributes used for negotiation logistics tracking and coordination.


Field Name

Description

Data Type

Length

EFFECTIVE_DATE

Date associated with effective.

DATE

END_DATE

Date associated with end.

DATE

LOCATION_NUMBER

Location number associated with the record.

NUMBER

22

NEGOTIATION_LOCATION_TYPE_CODE

Code identifying negotiation location type.

NUMBER

22

NEGOTIATION_NUMBER

Negotiation number associated with the record.

VARCHAR2

25

NUMBER_OF_DAYS

Number of days associated with the record.

NUMBER

28

UPDATE_TIMESTAMP

Timestamp associated with update.

DATE

UPDATE_USER

Update user associated with the record.

VARCHAR2

60

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE