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.
|
| |
|
| .