GP_AUD_FC_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	EFFDT	Date(10)	DATE	Effective Date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
4	PIN_HIST_RULE_NUM	Number(8,0)	INTEGER NOT NULL	Previous Periods Number Element Prompt Table: GP_PIN_HRF_VW
5	GP_AUD_CHAR_NM1	Character(30)	VARCHAR2(30) NOT NULL	used in payroll analytics
6	GP_AUD_LINK1	Character(30)	VARCHAR2(30) NOT NULL	used in payroll analytics
7	GP_AUD_CHAR_VAL1	Character(30)	VARCHAR2(30) NOT NULL	used in payroll analytics
8	PRC_OVRD_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Process Element Override Option O=Use Original Process S=Use Specific Process
9	PIN_PRC_NUM	Number(8,0)	INTEGER NOT NULL	Process Element Prompt Table: GP_PIN_PR0_VW
10	GP_AUD_CHAR_NM2	Character(30)	VARCHAR2(30) NOT NULL	used in payroll analytics
11	GP_AUD_LINK2	Character(30)	VARCHAR2(30) NOT NULL	used in payroll analytics
12	GP_AUD_CHAR_VAL2	Character(30)	VARCHAR2(30) NOT NULL	used in payroll analytics
13	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.
14	GROUPBOX_FC	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
15	GROUPBOX_FC2	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
16	GROUPBOX_FC3	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
17	GROUPBOX_FC4	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
18	GROUPBOX_FC5	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
19	GROUPBOX_FC6	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
20	GROUPBOX_FC7	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
21	GROUPBOX_FC8	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.