PNLGRPNAMEGPFR_ROW_NUMPrompt Table: GPFR_PAGES_VW
Prompt Table: %GP_EDIT_FLD7
GPFR_RTPNL_NRVW(SQL View) |
Index Back |
|---|---|
Rate Setup NPR ViewUsed to store a link to the variables used in the rate pages. |
| SELECT PNLGRPNAME , GPFR_ROW_NUM , ENTRY_TYPE_ID , PIN_NUM + 50000000 FROM PS_GPFR_RATE_PANEL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | GPFR_ROW_NUM |
Number(5,0) | INTEGER NOT NULL | Used as counter for row or column number |
| 3 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Element Entry Type ID
Prompt Table: GPFR_PAGES_VW |
| 4 | PIN_NUM | Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %GP_EDIT_FLD7 |