GP_AUD_ARFD_VW

(SQL View)
 Index Back

Array Return Elements

Global Payroll Array Return Elements Record

SELECT A.PIN_NUM , A.SEQ_NUM5 , A.ARRAY_FLD_USE , A.FIELDNAME , A.PIN_VAR_NUM ,'' ,'' ,'' , A.FIELDNAME_CUR , A.ORDER_BY ,'' ,0 FROM PS_GP_ARRAY_FLD A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number
3 ARRAY_FLD_USE Character(1) VARCHAR2(1) NOT NULL Array Return Column Field Use
C=Monetary
E=Element Number (Pointer)
O=Other
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: %GP_EDIT_FLD2

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

Prompt Table: %RECNAME_EDIT2

6 GP_AUD_CHAR_NM1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
7 GP_AUD_LINK1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
8 GP_AUD_CHAR_VAL1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
9 FIELDNAME_CUR Character(18) VARCHAR2(18) NOT NULL Currency Field

Prompt Table: %GP_EDIT_FLD2

10 ORDER_BY Character(1) VARCHAR2(1) NOT NULL Order By
A=Ascending
D=Descending
N=None
11 PIN_CHAIN_RSLT_NUM Number(4,0) SMALLINT NOT NULL Resolution Sequence of an Element in an Audit Chain
12 SEQ_NUM8 Number(8,0) INTEGER NOT NULL Sequence Number