PAY_CONFIG_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	CF_PROCESS_MODE	Character(1)	VARCHAR2(1) NOT NULL	ChartField Configuration Processing Mode R=Report Mode U=Update Mode
5	ORIG_CF_NAME	Character(18)	VARCHAR2(18) NOT NULL	Holds the Original Chartfield Name. This will not change!
6	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
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	HP_FIELD_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Field Description for use by Retro Distribution query
13	PREV_RELATED_CF	Character(18)	VARCHAR2(18) NOT NULL	Holds the previous Affiliate Related Chartfield if the Affiliate Related Chartfield changes.
14	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
15	DISPLAY_LENGTH	Number(2,0)	SMALLINT NOT NULL	Use to determine the ChartField Length to be display.
16	CF_ORDER	Number(2,0)	SMALLINT NOT NULL	ChartField Sequence Order
17	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
18	CF_LENGTH	Number(2,0)	SMALLINT NOT NULL	ChartField Length
19	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
20	BUS_UNIT_PC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag used to determine if BUSINESS_UNIT_PC field should appear on template.