LIBRARY FUND Table
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.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
FISCAL_YEAR |
The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998) |
VARCHAR2 |
4 |
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
LIBRARY_FUND_BUDGET_GROUP |
The names of the codes in LIBRARY_FUND_BUDGET_GROUP_CODE spelled out (e.g., Monographs, Serials) (based on Z76-SUB-KEY-1) |
VARCHAR2 |
30 |
LIBRARY_FUND_BUDGET_GROUP_CODE |
Groups funds together by Monographs, Serials, or Other, as the codes MONO or SER(Z76-SUB-KEY-1, or Budget group in the client) |
VARCHAR2 |
5 |
LIBRARY_FUND_CODE |
Code for the fund/budget, including the fiscal year (e.g., S-DEW-ECON-2003) (Z76-BUDGET-NUMBER, or Budget Code in the client) |
VARCHAR2 |
20 |
LIBRARY_FUND_EXTERNAL_BUDGET |
SAP budget number (Z76-EXTERNAL-BUDGET) |
VARCHAR2 |
50 |
LIBRARY_FUND_ID |
Code for the fund/budget, excluding the fiscal year (e.g., S-DEW-ECON) (based on LIBRARY_FUND_CODE) |
VARCHAR2 |
10 |
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 |
LIBRARY_FUND_NAME |
Descriptive name of the fund/budget (e.g., ECONOMICS/DEW) (Z76-NAME, or Budget name in the client) |
VARCHAR2 |
60 |
LIBRARY_FUND_NOTE_1 |
Note associated with the fund/budget (Z76-NOTE-1) |
VARCHAR2 |
100 |
LIBRARY_FUND_OPEN_DATE |
Creation date of the fund/budget for a given fiscal year. (Z76-OPEN-DATE, or Open Date in the client) |
DATE |
8 |
LIBRARY_FUND_SOURCE |
Where the money comes from (e.g., M and S funds are Regular, G are Gift) (Z76-BUDGET-TYPE, spelled out; Budget Type in the client) |
VARCHAR2 |
100 |
LIBRARY_FUND_STATUS |
Notes whether the fund/budget is Active or Inactive (Z76-STATUS) |
VARCHAR2 |
20 |
LIBRARY_FUND_SUBJECT_1 |
Not currently in use. |
VARCHAR2 |
30 |
LIBRARY_FUND_SUBJECT_1_CODE |
Not currently in use. |
VARCHAR2 |
5 |
LIBRARY_FUND_SUBJECT_2 |
Not currently in use. |
VARCHAR2 |
30 |
LIBRARY_FUND_SUBJECT_2_CODE |
Not currently in use. |
VARCHAR2 |
5 |
LIBRARY_FUND_SUBJECT_3 |
Not currently in use. |
VARCHAR2 |
30 |
LIBRARY_FUND_SUBJECT_3_CODE |
Not currently in use. |
VARCHAR2 |
5 |
LIBRARY_FUND_SUBJECT_SEARCH |
Not currently in use. |
VARCHAR2 |
20 |
LIBRARY_FUND_VALID_FROM |
Earliest date the fund/budget may be used in the fiscal year (usually around the first week of June, when year-end closing happens in Aleph) |
DATE |
8 |
LIBRARY_FUND_VALID_THRU |
Latest date the fund/budget may be used in the fiscal year (usually around the first week of June, when year-end closing happens in Aleph) |
DATE |
8 |
MAX_OVER_COMMITTED |
Maximum over encumbrance amount as shown in MAX_OVER_TYPE. (Z76-MAX-OVER-COMMITTED) |
NUMBER |
22 |
MAX_OVER_EXPENDED |
Maximum over expenditure amount as shown in MAX_OVER_TYPE. (Z76-MAX-OVER-EXPENDITURE) |
NUMBER |
22 |
MAX_OVER_TYPE |
Type of over encumbrance or expenditure expressed in MAX_OVER_COMMITTED and MAX_OVER_EXPENDED (i.e., P for Percentage or A for Dollar Amount) (Z76-SW-ABSOLUTE-PERCENT) |
VARCHAR2 |
1 |
PAYING_LIBRARY_CODE |
Three-letter Sub Library code, extracted from the fund/budget. (e.g., DEW, coming from S-DEW-ECON) Note:not necessarily owning it (e.g., books bought on R-TEC-REPL will say TEC here, even though the book might go to HUM) Use the LIBRARY_CODE field in the LIBRARY table for the library owning the item. |
VARCHAR2 |
3 |
PAYING_LIBRARY_NAME |
Name of the library corresponding to the PAYING_LIBRARY_CODE (e.g., Dewey Library). Library that purchased the item, not necessarily owing it. Use the LIBRARY_NAME in the LIBRARY table for the library owning the item. |
VARCHAR2 |
100 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |