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