GPAR_NRP_GRP_VW(SQL View) |
Index Back |
|---|---|
ARG Generic Report Setup - PINGP ARG Child record for the Generic Report Setup - Row/Col |
| SELECT GP_GENRPT_ID , SEQNUM , SEQNBR , PIN_NUM +50000000 , ENTRY_TYPE_ID , GP_GENRPT_SUB_PIN , PROGRAM_ID , STRING_ID , GPAR_SUBLEVEL , GPAR_CHAR_SYMBOL , GPAR_PRINTSUBTOTAL , GPAR_DESCR_250 FROM PS_GPAR_GENRPT_PIN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GP_GENRPT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Code of the generic report |
| 2 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | SEQNBR |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %GP_EDIT_FLD7 |
| 5 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Element Entry Type ID
Prompt Table: GPAR_ENT_RPT_VW |
| 6 | 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 |
| 7 | PROGRAM_ID | Character(8) | VARCHAR2(8) NOT NULL |
Program ID
Prompt Table: GPAR_PRG_STR_VW |
| 8 | STRING_ID | Character(18) | VARCHAR2(18) NOT NULL |
String ID
Prompt Table: GPAR_STRING_VW |
| 9 | GPAR_SUBLEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Sublevel for report stucture
Y/N Table Edit Default Value: N |
| 10 | GPAR_CHAR_SYMBOL | Character(1) | VARCHAR2(1) NOT NULL |
Symbol character printed in the reports
M=Pesos P=Percentage |
| 11 | 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 |
| 12 | GPAR_DESCR_250 | Character(250) | VARCHAR2(250) NOT NULL | Description |