GP_PKG_IDRECNAMEPrompt Table: GP_NR_PKG_R1_VW
C=Change WHERE Clause
D=Use Default WHERE Clause
Default Value: D
GP_NR_PKG_RECS(SQL Table) |
Index Back |
|---|---|
Non Rule Package - Work RecordThis is a work record that contains the records in a given package. A work record is needed to simplify the export script creation |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(8) | VARCHAR2(8) NOT NULL | Field used for element packaging |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: GP_NR_PKG_R1_VW |
| 3 | RECNAME_EXPORT | Character(15) | VARCHAR2(15) NOT NULL | Export Record (Table) Name |
| 4 | GRP_WHERE_CLS | Long Character(4096) | CLOB | Where Clause for Groups |
| 5 | WHERE_CLAUSE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Option for storing WHERE clause associated with the Packager.
C=Change WHERE Clause D=Use Default WHERE Clause Default Value: D |