GP_PKG_IDGP_GENRPT_IDSEQNUMSEQNBRPIN_NUM10=Add
20=Subtract
Y/N Table Edit
Default Value: N
M=Pesos
P=Percentage
Y/N Table Edit
Default Value: N
GPAR_NRP_GRP_AD(SQL Table) |
Index Back |
|---|---|
ARG Generic Report Setup - PINGP ARG Child record for the Generic Report Setup - Row/Col |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | GP_GENRPT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Code of the generic report |
| 3 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | SEQNBR |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 6 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Element Entry Type ID |
| 7 | GP_GENRPT_SUB_PIN | Character(2) | VARCHAR2(2) NOT NULL |
Indicates if the result must be added or subtract from the elements set
10=Add 20=Subtract |
| 8 | PROGRAM_ID | Character(8) | VARCHAR2(8) NOT NULL | Program ID |
| 9 | STRING_ID | Character(18) | VARCHAR2(18) NOT NULL | String ID |
| 10 | GPAR_SUBLEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Sublevel for report stucture
Y/N Table Edit Default Value: N |
| 11 | GPAR_CHAR_SYMBOL | Character(1) | VARCHAR2(1) NOT NULL |
Symbol character printed in the reports
M=Pesos P=Percentage |
| 12 | GPAR_PRINTSUBTOTAL | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if the totals must be printed or not for the set of elements (row or column)
Y/N Table Edit Default Value: N |
| 13 | GPAR_DESCR_250 | Character(250) | VARCHAR2(250) NOT NULL | Description |