GP_PKG_AR3_AD

#	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_KEY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Array Payee/Non Payee Type D=Effective Date I=Employee ID O=Other Key R=Employee Record
5	USE_MAX_IND	Character(1)	VARCHAR2(1) NOT NULL	Obsolete field found on GP ARRAY KEY table. Can be removed.
6	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
7	ARRAY_KEY_OPER	Character(2)	VARCHAR2(2) NOT NULL	Array Key Operator EQ=Equal GE=Greater Than or Equal GT=Greater Than LE=Less Than or Equal LT=Less Than NA=Not Applicable NE=Not Equal
8	ENTRY_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Element Entry Type ID
9	PIN_ELEM_NUM	Number(8,0)	INTEGER NOT NULL	Element Number
10	EFFDT_COMPARE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Array Effective Date Compare Option 1=Period Begin Date 2=Period End Date 3=Payment Date 4=Segment Begin Date 5=Segment End Date 6=Slice Begin Date 7=Slice End Date