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

CHARTFIELD2_TBL

This is the Source Table, which contains short and long descriptions as of an effective date. The "Source" chartfield is the source of funds. Will be used for Contracts & Grants and capital projects (eg. 33041101: Office of Education).
CHARTFIELD2 Source Example: 3300003000
KEY Type: character Format: uppercase Length: 10 Decimals: 0
Source chartfield which tags and tracks contract and grant agency information, and capital projects.
.
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.
.
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: FEDERAL APPROPRIATIONS-AG
Type: character Format: lowercase Length: 30 Decimals: 0
Description
.
DESCRSHORT Short Description Example: FED AG
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.
.