LIBRARY ORDER TYPE Table
Includes order type (e.g., Monograph or Serial), acquisition method (e.g., Purchase, Gift, etc.), and material type (used for ARL statistics reporting, e.g., Book, Computer File, Microform, etc.), and whether or not it is a Rush order. Use this table to limit the query by any of the above.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACQUISITION_METHOD |
Description of how materials are acquired. (E.g.: Purchase, Approval, Gift, etc.) |
VARCHAR2 |
30 |
ACQUISITION_METHOD_CODE |
Code for how we are acquiring the material (e.g., P, A, G, etc.) (Z68-METHOD-OF-ACQUISITION) |
VARCHAR2 |
3 |
IS_RUSH_ORDER |
Use to limit a query to Rush orders. |
VARCHAR2 |
3 |
LIBRARY_ORDER_TYPE |
Description of LIBRARY_ORDER_TYPE_CODE (Monograph or Serials. The N/A represents serial invoice postage lines, which are not associated with an order record) |
VARCHAR2 |
20 |
LIBRARY_ORDER_TYPE_CODE |
Use this to limit a query to Monograph or Serial orders. (Z68-ORDER-TYPE) |
VARCHAR2 |
4 |
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 |
ORDER_MATERIAL |
Description of statistical categories of material being ordered; used by MonoAcq for ARL Statistics (E.g., Monograph, Back Issue, Standing Order, Subscription, etc.) |
VARCHAR2 |
30 |
ORDER_MATERIAL_CODE |
Code for the statistical categories of material being ordered; used by MonoAcq for ARL Statistics (e.g., M, BI, ST, SU, etc.) (Z68-MATERIAL-TYPE) |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |