UD PeopleSoft Financial System - Data Dictionary
Last updated for this Record on 6/7/2003.

FUND_TBL

This is the Fund Table, which contains short and long descriptions as of an effective date. The "Fund" chartfield identifies the fund type to which a certain Purpose belongs. Implies a set of accounting rules that pertain to those Purposes (eg. OPBAS: Basic Operating). Corresponds to first two segments of the legacy Account Code (01-1-...).
EFFDT Effective Date Example: 01/01/1951
KEY Type: date Format: uppercase Length: 10 Decimals: 0
The date on which this row of data takes effect.
.
FUND_CODE Fund Code Example: OPBAS
KEY Type: character Format: uppercase Length: 5 Decimals: 0
Each Fund represents a self-balancing entity that produces balance sheets. Loosely corresponds to Legacy Data Warehouse ACCT_TYPE.
.
SETID SetID Example: UOD01
KEY Type: character Format: uppercase Length: 5 Decimals: 0
The only valid value at UD at this time is "UOD01".
.
DESCR Description Example: OPERATING BASIC
Type: character Format: lowercase Length: 30 Decimals: 0
Description
.
DESCRSHORT Short Description Example: OPBAS
Type: character Format: lowercase Length: 10 Decimals: 0
Short Description
.
EFF_STATUS Status as of Effective Date Example: A
Type: character Format: uppercase Length: 1 Decimals: 0
Indicates whether the row of data is active or inactive.
.