Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP NEGOTIATION CUSTOM DATA Table


View exposing custom negotiation-related attributes including user-defined fields, extended negotiation metadata, and institution-specific tracking attributes used for specialized tracking and enhanced data analysis.


Field Name

Description

Data Type

Length

COLUMN_NAME

Column name associated with the record.

VARCHAR2

30

COLUMN_VALUE

Column value associated with the record.

VARCHAR2

2000

NEGOTIATION_NUMBER

Negotiation number associated with the record.

VARCHAR2

25

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