GP_PKG_AR3_VW

#	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	SEQ_NUM5	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 1
3	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 Default Value: O
4	USE_MAX_IND	Character(1)	VARCHAR2(1) NOT NULL	Obsolete field found on GP ARRAY KEY table. Can be removed. Y/N Table Edit Default Value: N
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: %RECNAME_EDIT
6	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 Default Value: NA
7	ENTRY_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Element Entry Type ID Prompt Table: %RECNAME_EDIT2
8	PIN_ELEM_NUM	Number(8,0)	INTEGER NOT NULL	Element Number
9	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 Default Value: 2