Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Library Fund


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

LIBRARY_FUND

Includes information from the Budgets (Funds) in Aleph (e.g., Fund Code, Fund Name, Budget Groups). Cost Collector and GL Account numbers are included for linking to SAP data. Data in this table is taken from the Z76 table in Aleph. Use this table to limit by Fund or Paying Library. Use the LIBRARY table to limit by the Library that owns the item.

Dimension

Libraries

MIT ONLY

Daily

08-JAN-2020

LIBRARY_FUND_BALANCES

Includes current Allocation, Expenditure, and Commitment (Encumbrance) information for each Budget (Fund). Data in this table is calculated from Z601 data from Aleph.

Fact

Libraries

MIT ONLY

Daily

08-JAN-2020