LIBRARY ALLOCATION DETAIL Table
Includes details of the Budget Transactions for Allocations, Transfers, and Year End Carryovers only (e.g., Transaction Dates, Amounts). See LIBRARY_FINANCIAL_DETAIL for other transaction types. Data in this table is taken from the Z601 table in Aleph.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALLOCATION_AMOUNT |
Dollar amount of the budget allocation. (Z601-LOCAL-SUM) |
NUMBER |
22 |
LIBRARY_FUND_KEY |
Key used to join to the LIBRARY_FUND 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 |
100 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
TRANSACTION_DATE |
Original date of the transaction. (Z601-OPEN-DATE or just Date in the client) |
DATE |
8 |
TRANSACTION_SORT_SEQUENCE |
A unique sequence number, usually a time and date stamp, assigned by Aleph. Not sure if there is an accurate time and date stamp associated with migrated data, but it should be accurate for all Aleph-born data. (Z601-SEQUENCE) |
VARCHAR2 |
15 |
TRANSACTION_TYPE_KEY |
Key used to join to the LIBRARY_TRANSACTION_TYPE table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
3 |
TRANSACTION_USER |
Original user (person) who created the transaction. (Z601-USER-NAME) |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |