GP_PKG_AR2_AD (SQL Table)	Index Back
Array Return Elements Global Payroll Array Return Elements Record

GP_PKG_AR2_AD

(SQL Table)

Array Return Elements

Global Payroll Array Return Elements Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging

2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

3 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number

4 ARRAY_FLD_USE Character(1) VARCHAR2(1) NOT NULL Array Return Column Field Use
C=Monetary
E=Element Number (Pointer)
O=Other

5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

6 PIN_VAR_NUM Number(8,0) INTEGER NOT NULL Variable Element Number

7 FIELDNAME_CUR Character(18) VARCHAR2(18) NOT NULL Currency Field

8 ORDER_BY Character(1) VARCHAR2(1) NOT NULL Order By
A=Ascending
D=Descending
N=None

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
3	SEQ_NUM5	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	ARRAY_FLD_USE	Character(1)	VARCHAR2(1) NOT NULL	Array Return Column Field Use C=Monetary E=Element Number (Pointer) O=Other
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	PIN_VAR_NUM	Number(8,0)	INTEGER NOT NULL	Variable Element Number
7	FIELDNAME_CUR	Character(18)	VARCHAR2(18) NOT NULL	Currency Field
8	ORDER_BY	Character(1)	VARCHAR2(1) NOT NULL	Order By A=Ascending D=Descending N=None