GP_AUD_AR_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFNPVW
3	ARRAY_KEY_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Array Key Column Use E=Keyed By Employee U=User Defined Key
4	ARRAY_PRC_OPTN	Character(2)	VARCHAR2(2) NOT NULL	Array Formula Type FR=By Formula, Apply all Rows LU=Look-up RF=By Row, Apply all Formulas
5	RELOAD_IND	Character(1)	VARCHAR2(1) NOT NULL	Reload for each Payment/Slice Indicator 0=Load once (small table) 1=Reload for each resolution 2=Reload for each segment E=Employee-based look-up
6	PIN_FRML_NUM	Number(8,0)	INTEGER NOT NULL	Element number field Prompt Table: GP_PIN_FM0_VW
7	GP_AUD_CHAR_NM3	Character(30)	VARCHAR2(30) NOT NULL	used in payroll analytics
8	GP_AUD_LINK3	Character(30)	VARCHAR2(30) NOT NULL	used in payroll analytics
9	GP_AUD_CHAR_VAL3	Character(30)	VARCHAR2(30) NOT NULL	used in payroll analytics
10	DEBUG_SQL_OPT	Character(1)	VARCHAR2(1) NOT NULL	Dynamic SQL Debug Option N=No Debugging Y=Debug SQL
11	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.
12	GP_AUD_INSTANCE	Character(3)	VARCHAR2(3) NOT NULL	Instance Number 01=01 02=02 03=03
13	GROUPBOX_AR	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
14	GROUPBOX_AR2	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
15	GROUPBOX_AR3	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
16	GROUPBOX_AR4	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
17	GROUPBOX_AR5	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
18	GROUPBOX_AR6	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
19	GROUPBOX_AR7	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.