PIN_NUMDefault Value: GP_PIN.PIN_NUM
SEQ_NUM5Default Value: 1
C=Monetary
E=Element Number (Pointer)
O=Other
Default Value: O
Prompt Table: %RECNAME_EDIT
Prompt Table: %RECNAME_EDIT
A=Ascending
D=Descending
N=None
Default Value: N
GP_PKG_AR2_VW(SQL View) |
Index Back |
|---|---|
Packaging View-Array FieldsThis is a Packaging View. It is used to move Array Fields (Return Elements) between databases. |
| SELECT PIN_NUM + 50000000 , SEQ_NUM5 , ARRAY_FLD_USE , FIELDNAME , PIN_VAR_NUM , FIELDNAME_CUR , ORDER_BY FROM PS_GP_ARRAY_FLD |
| # | 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_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: %RECNAME_EDIT |
| 5 | PIN_VAR_NUM | Number(8,0) | INTEGER NOT NULL | Variable Element Number |
| 6 | FIELDNAME_CUR | Character(18) | VARCHAR2(18) NOT NULL |
Currency Field
Prompt Table: %RECNAME_EDIT |
| 7 | ORDER_BY | Character(1) | VARCHAR2(1) NOT NULL |
Order By
A=Ascending D=Descending N=None Default Value: N |