Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP NEGOTIATION LOC DETAILS Table


View exposing detailed location attributes for negotiation meetings including address components, facility contact, accessibility information, and available resources used for meeting coordination and logistics planning.


Field Name

Description

Data Type

Length

DESCRIPTION

Description associated with the record.

VARCHAR2

30

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

NO_OF_DAYS

No of days associated with the record.

NUMBER

28

START_DATE

Date associated with start.

DATE

START_DATE_TIME_MONTH_KEY

Surrogate key identifying the start date time month.

VARCHAR2

6