UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 6/7/2003.
CF_ATTRIB_TBL
Attributes provide a method for tagging chartfields with additional qualities not inherent in the
chartfield itself. Can be used as criteria or grouping in another way than lists and trees, but
often toward the same end. For example, the Purposes that are given a certain TRUSTSORT
attribute here are grouped together for reporting to Board of Trustees.
|
| CF_ATTRIB_VALUE
| Chartfield Attribute Value
| Example: BW1007
|
| KEY
| Type: character
| Format: uppercase
| Length: 20
| Decimals: 0
|
| | In this table, the CF_ATTRIB_VALUE is the value attached to an individual
chartfield value.
|
| |
|
| .
|
| CF_ATTRIBUTE
| Chartfield Attribute
| Example: TRUSTSORT
|
| KEY
| Type: character
| Format: uppercase
| Length: 15
| Decimals: 0
|
| | An attribute that applies to this chartfield. A many-to-many relationship
exists between chartfields and atttributes.
|
| |
|
| .
|
| CHARTFIELD_VALUE
| ChartField Value
| Example: MEEG11
|
| KEY
| Type: character
| Format: uppercase
| Length: 30
| Decimals: 0
|
| | The value of the chartfield as of this effective date
|
| |
|
| .
|
| 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.
|
| |
|
| .
|
| FIELDNAME
| Field Name
| Example: CHARTFIELD1
|
| KEY
| Type: character
| Format: uppercase
| Length: 18
| Decimals: 0
|
| | The name of a chartfield with which one or more attributes are associated
in this record.
|
| |
|
| .
|
| SETID
| SetID
| Example: UOD01
|
| KEY
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | The only valid value at UD at this time is "UOD01".
|
| |
|
| .