Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LIBRARY HOLDINGS Table


XXX


Field Name

Description

Data Type

Length

HOLDINGS_SUMMARY_STATEMENT

XXX

VARCHAR2

500

IS_OPEN_HOLDINGS

XXX

VARCHAR2

1

LIBRARY_HOLDINGS_KEY

XXX

VARCHAR2

9

RECORD_CREATE_DATE

XXX

DATE

RECORD_UPDATE_DATE

XXX

DATE

RETENTION_NOTE

XXX

VARCHAR2

500

SUBSCRIPTION_END_DATE

End date of the Serial subscription

DATE

SUBSCRIPTION_START_DATE

XXX

DATE

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE