PIN_NUMSEQ_NUM5Default Value: 1
C=Monetary
E=Element Number (Pointer)
O=Other
Default Value: O
Prompt Table: %GP_EDIT_FLD2
Prompt Table: %RECNAME_EDIT2
Prompt Table: %GP_EDIT_FLD2
A=Ascending
D=Descending
N=None
Default Value: N
GP_ARRAY_FLD(SQL Table) |
Index Back |
|---|---|
Array Return ElementsGlobal Payroll Array Return Elements Record |
| # | 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
Default Value: 1 |
| 3 | ARRAY_FLD_USE | Character(1) | VARCHAR2(1) NOT NULL |
Array Return Column Field Use
C=Monetary E=Element Number (Pointer) O=Other Default Value: O |
| 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 Default Value: N |