GPFR_ILL_ROW_IDGPFR_ROW_NUMDefault Value: 0
PIN_NUMPrompt Table: %GP_EDIT_FLD7
Prompt Table: GPFR_DUCS_PINVW
GPFR_ILLRP_NRVW(SQL View) |
Index Back |
|---|---|
Wages Certif setup - NPR ViewChild record for the generic report setup Definition of the rows or columns of the report |
| SELECT GPFR_ILL_ROW_ID , GPFR_ROW_NUM , PIN_NUM + 50000000 , ENTRY_TYPE_ID FROM PS_GPFR_ILL_ROWPIN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_ILL_ROW_ID |
Character(2) | VARCHAR2(2) NOT NULL | List of the PIN Elements used in the reports |
| 2 | GPFR_ROW_NUM |
Number(5,0) | INTEGER NOT NULL |
Used as counter for row or column number
Default Value: 0 |
| 3 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %GP_EDIT_FLD7 |
| 4 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Element Entry Type ID
Prompt Table: GPFR_DUCS_PINVW |