GP_PKG_WA1_VW(SQL View) |
Index Back |
---|---|
Packaging View-Writeable ArrayThis is a Packaging View. It is used to move Writeable Arrays between databases. |
SELECT PIN_NUM + 50000000 , RECNAME , BULK_INSERT , GP_VERSION FROM PS_GP_WA_ARRAY |
# | 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 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
3 | BULK_INSERT | Character(1) | VARCHAR2(1) NOT NULL |
Bulk Insert Flag
Y/N Table Edit |
4 | GP_VERSION | Character(18) | VARCHAR2(18) NOT NULL | Stores element version. |