GPSC_ELM_AR_FL

(SQL View)
 Index Back

Array Return Elements

Global Payroll Array Return Elements Record

SELECT PIN_NUM , SEQ_NUM5 , ARRAY_FLD_USE , FIELDNAME , PIN_VAR_NUM , FIELDNAME_CUR , ORDER_BY FROM PS_GP_ARRAY_FLD WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , SEQ_NUM5 , ARRAY_FLD_USE , FIELDNAME , PIN_VAR_NUM , FIELDNAME_CUR , ORDER_BY FROM PS_GPSC_RM_AR_FLD WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN)

# 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 FIELDNAME_CUR Character(18) VARCHAR2(18) NOT NULL Currency Field

Prompt Table: %GP_EDIT_FLD2

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