UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 2/17/2004.
CLASS_CF_TBL
This is the Class Table, which contains short and long descriptions as of an effective date.
"Class" chartfield: identifies the faculty member or the staff position to which salary items
apply. Descriptions are not meaningful. Class relates to the legacy "line number".
|
| CLASS_FLD
| Class Field
| Example: ABC
|
| KEY
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | The Chartfield which identifies the faculty member or the staff position to
which salary items apply. Corresponds to the legacy line number.
|
| |
|
| .
|
| 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: Doe, John
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | For Alphabetic Class Codes, the name of the employee; for numeric ones,
simply the number.
|
| |
|
| .
|
| DESCRSHORT
| Short Description
| Example: CLASS ABC
|
|
| 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.
|
| |
|
| .