LIBRARY FUND Table
View exposing library fund reference records including fund identifiers, names, and organizational attributes used for acquisitions and financial management.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
LIBRARY_FUND_BUDGET_GROUP |
Library fund budget group associated with the record. |
VARCHAR2 |
30 |
LIBRARY_FUND_BUDGET_GROUP_CODE |
Code identifying library fund budget group. |
VARCHAR2 |
5 |
LIBRARY_FUND_CODE |
Code identifying library fund. |
VARCHAR2 |
50 |
LIBRARY_FUND_EXTERNAL_BUDGET |
Library fund external budget associated with the record. |
VARCHAR2 |
50 |
LIBRARY_FUND_ID |
Business identifier for the library fund. |
VARCHAR2 |
10 |
LIBRARY_FUND_KEY |
Surrogate key identifying the library fund. |
VARCHAR2 |
50 |
LIBRARY_FUND_NAME |
Library fund name associated with the record. |
VARCHAR2 |
60 |
LIBRARY_FUND_NOTE_1 |
Library fund note 1 associated with the record. |
VARCHAR2 |
100 |
LIBRARY_FUND_OPEN_DATE |
Date associated with library fund open. |
DATE |
|
LIBRARY_FUND_SOURCE |
Library fund source associated with the record. |
VARCHAR2 |
100 |
LIBRARY_FUND_STATUS |
Library fund status associated with the record. |
VARCHAR2 |
20 |
LIBRARY_FUND_SUBJECT_1 |
Library fund subject 1 associated with the record. |
VARCHAR2 |
30 |
LIBRARY_FUND_SUBJECT_1_CODE |
Code identifying library fund subject 1. |
VARCHAR2 |
5 |
LIBRARY_FUND_SUBJECT_2 |
Library fund subject 2 associated with the record. |
VARCHAR2 |
30 |
LIBRARY_FUND_SUBJECT_2_CODE |
Code identifying library fund subject 2. |
VARCHAR2 |
5 |
LIBRARY_FUND_SUBJECT_3 |
Library fund subject 3 associated with the record. |
VARCHAR2 |
30 |
LIBRARY_FUND_SUBJECT_3_CODE |
Code identifying library fund subject 3. |
VARCHAR2 |
5 |
LIBRARY_FUND_SUBJECT_SEARCH |
Library fund subject search associated with the record. |
VARCHAR2 |
20 |
LIBRARY_FUND_VALID_FROM |
Library fund valid from associated with the record. |
DATE |
|
LIBRARY_FUND_VALID_THRU |
Library fund valid thru associated with the record. |
DATE |
|
MAX_OVER_COMMITTED |
Max over committed associated with the record. |
NUMBER |
11,2 |
MAX_OVER_EXPENDED |
Max over expended associated with the record. |
NUMBER |
11,2 |
MAX_OVER_TYPE |
Max over type associated with the record. |
VARCHAR2 |
1 |
PAYING_LIBRARY_CODE |
Code identifying paying library. |
VARCHAR2 |
3 |
PAYING_LIBRARY_NAME |
Paying library name associated with the record. |
VARCHAR2 |
100 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |