LIBRARY FUND BALANCES Table
Includes current Allocation, Expenditure, and Commitment (Encumbrance) information for each Budget (Fund). Data in this table is calculated from Z601 data from Aleph.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
TOTAL_ALLOCATION_AMOUNT |
Sum of all the Allocation, Transfer, and Year End Carry Forward Transactions for a given Budget. This total is not stored in Aleph, but is calculated from the amounts in LIBRARY_ALLOCATION_DETAIL. |
NUMBER |
22 |
TOTAL_COMMITMENT_AMOUNT |
The total commitment (encumbered) amount.. This amount only exists in Current Fiscal Year and includes ALL open commitments regardless of Expected Debit Date |
NUMBER |
13 |
TOTAL_EXPENDITURE_AMOUNT |
Sum of all the Invoice Transactions for a given Budget. This total is not stored in Aleph, but is calculated from the amounts in LIBRARY_ALLOCATION_DETAIL. |
NUMBER |
13.2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |