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