GP_ARRAY

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Default Value: GP_PIN.PIN_NUM
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 Default Value: E
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 Default Value: LU
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 Default Value: E
6	PIN_FRML_NUM	Number(8,0)	INTEGER NOT NULL	Element number field Prompt Table: GP_PIN_FM0_VW
7	DEBUG_SQL_OPT	Character(1)	VARCHAR2(1) NOT NULL	Dynamic SQL Debug Option N=No Debugging Y=Debug SQL Default Value: N
8	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.