PAY_CONFIG_WRK

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ORIG_CF_NAME	Character(18)	VARCHAR2(18) NOT NULL	Holds the Original Chartfield Name. This will not change!
2	CF_CONFIG_FLG	Number(5,0)	INTEGER NOT NULL	Chartfields Configuration Flags
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
4	CF_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Chartfield Type - Use specificly for Chartfield Template. A=Affiliate C=Currency Code D=Deleted Chartfield F=Fully Configurable P=Partially Configurable S=Statistic Code X=Product Specific Default Value: F
5	CF_ACTIVE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	The user can specify CF to be Active, Inactive or Deleted. This field was formerly called User Option. A=Active ChartField I=Inactive ChartField Default Value: A
6	PREV_CF_ACTIVE_STS	Character(1)	VARCHAR2(1) NOT NULL	The user can specify CF to be Active, Inactive or Deleted. This field was formerly called User Option.
7	LABEL_ID	Character(18)	VARCHAR2(18) NOT NULL	LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
8	LONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Long Name
9	SHORTNAME	Character(15)	VARCHAR2(15) NOT NULL	Field Short Name
10	PREV_LONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Long Name
11	PREV_SHORTNAME	Character(15)	VARCHAR2(15) NOT NULL	Prev Short Name
12	CF_ORDER	Number(2,0)	SMALLINT NOT NULL	ChartField Sequence Order
13	PREV_CF_ORDER	Number(2,0)	SMALLINT NOT NULL	Previous ChartField Sequence Order
14	DISPLAY_LENGTH	Number(2,0)	SMALLINT NOT NULL	Use to determine the ChartField Length to be display.
15	PREV_DISPLAY_LEN	Number(2,0)	SMALLINT NOT NULL	Previous ChartField Display Length
16	AFFILIATE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Tells if the Chartfield is Intra Unit Affiliate or Inter Unit Affiliate. A=IntraUnit Affiliate I=InterUnit Affiliate X=Standard Default Value: X
17	AFF_RELATED_CF	Character(18)	VARCHAR2(18) NOT NULL	Holds the Related Chartfield that is needed by Affiliate Chartfield. Prompt Table: AFF_CF_PRMPT_VW
18	PREV_RELATED_CF	Character(18)	VARCHAR2(18) NOT NULL	Holds the previous Affiliate Related Chartfield if the Affiliate Related Chartfield changes.
19	HP_FIELD_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Field Description for use by Retro Distribution query
20	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
21	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
22	CF_LENGTH	Number(2,0)	SMALLINT NOT NULL	ChartField Length