Data Warehouse

CURRENCY_CODE

Three-letter codes for the currency (follows ISO code structure) (e.g., USD, EUR) (Z82-CURRENCY)

VARCHAR2

3

LIBRARY_CATALOG_KEY

Key used to join to the LIBRARY_CATALOG table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

20

LIBRARY_KEY

Key used to join to the LIBRARY table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

3

LIBRARY_NOTE

Note associated with the order, for internal use. (Z68-LIBRARY-NOTE)

VARCHAR2

200

LIBRARY_ORDER_AMOUNT

Total price of the order (NUMBER_OF_UNITS times UNIT_PRICE, in USD) (Z68-E-LOCAL-PRICE, referred to as ""Local Price"" in the client, not ""Final Price."")

NUMBER

15,2

LIBRARY_ORDER_AMOUNT_ORIG_CURR

Total price of the order (NUMBER_OF_UNITS times UNIT_PRICE, in the original currency) (Z68-E-PRICE, referred to as ""Final Price"" in the client. DO NOT USE THIS FIELD FOR CALCULATIONS.)

NUMBER

15,2

LIBRARY_ORDER_CLAIM_DATE

The date the next claim for the order should be sent; for Monograph orders only (Z68-EDA)

DATE

LIBRARY_ORDER_DATE

The date the order was sent to the vendor (Order Status became SV) (Z68-ORDER-DATE)

DATE

LIBRARY_ORDER_KEY

Key used to join to the LIBRARY_ORDER table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

14

LIBRARY_ORDER_NUMBER

Purchase order number assigned to an order (e.g., 03-1456, D12345, etc.) (Z68-ORDER-NUMBER, referred to as ""Order Number 1"" in the client. ( the Z68-ORDER-NUMBER-1 field corresponds to ""Order Number 2."")

VARCHAR2

30

LIBRARY_ORDER_OPEN_DATE

The date the order record was created (Z68-OPEN-DATE)

DATE

LIBRARY_ORDER_STATUS_KEY

Key used to join to the LIBRARY_ORDER_STATUS table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

20

LIBRARY_ORDER_TYPE_KEY

Key used to join to the LIBRARY _ORDER_TYPE table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

20

LIBRARY_VENDOR_KEY

Key used to join to the LIBRARY_VENDOR table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

20

NOTE

For the LIBRARY FINANCIAL DETAIL and LIBRARY ALLOCATION DETAIL tables, the NOTE field contains detailed explanation of the budget transaction. May be system assigned e.g. INVOICE, ORDER ENCUMBRANCE (Z601-NOTE). For the CIP table, this field contains additional information regarding the CIP program.

VARCHAR2

200

NUMBER_OF_UNITS

For LIBRARY data: Number of individual items (units) being ordered; usually the number of copies. This number is multiplied by UNIT_PRICE to get LIBRARY_ORDER_AMOUNT. For Serial orders, this number is always 1. (Z68-NO-UNITS) For SUBJECT ENROLLMENT Data, this represent the number of units the student registered for the subject.

NUMBER

5

ORIGINAL_ORDER_CLAIM_DATE

The date the first claim for the order should be sent; for Monograph orders only (Z68-ORIGINAL-EDA)

DATE

QUANTITY_TEXT

A note about the number of units in the order; used for multi-part Mono orders (Z68-QUANTITY-TEXT, called ""Quantity Note"" in the client)

VARCHAR2

200

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

1

SUBSCRIPTION_BEGIN_DATE

Starting date of the Serial subscription

DATE

SUBSCRIPTION_END_DATE

End date of the Serial subscription

DATE

TARGET_TEXT

For RUSH orders, name of the user who requested the order. (Z68-TARGET-TEXT)

VARCHAR2

200

UNIT_PRICE

Cost associated with each piece counted in NUMBER_OF_UNITS, converted to USD. For Serial orders, this is always $.01. (Z68-UNIT-PRICE converted to USD)

NUMBER

15,2

VENDOR_NOTE

Note to be sent to the vendor on orders, claims, etc. (Z68-VENDOR-NOTE)

VARCHAR2

200

VENDOR_REFERENCE_NUMBER

A number assigned by the vendor to refer to this order; always used with GOBI orders, used less frequently with other Mono and Serial orders (Z68-VENDOR-REFERENCE-NO)

VARCHAR2

30

WAREHOUSE_LOAD_DATE

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

DATE