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

CHARTFIELD1_TBL

This is the Purpose Table, which contains short and long descriptions as of an effective date. The "Purpose" chartfield identifies discrete blocks of money used to make expenditures, collect revenues, or track assets and liabilities (eg. PLSC11). Relates to the legacy 11-digit "account code".
CHARTFIELD1 Purpose Example: ENGL110000
KEY Type: character Format: uppercase Length: 10 Decimals: 0
Purpose chartfield. Replaces legacy 11 digit account code.
.
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: ENGLISH
Type: character Format: lowercase Length: 30 Decimals: 0
Description
.
DESCRSHORT Short Description Example: ENGL110000
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.
.