PNLGRPNAMEPrompt Table: FS_SD_PNLGRP_VW
MARKETDefault Value: GBL
PNLNAMEPrompt Table: FS_SD_PNL_VW
FS_SD_SRCHPG_VW(SQL View) |
Index Back |
|---|---|
Supplemental Data ViewSupplemental Data View |
| SELECT A.PNLGRPNAME , A.MARKET , A.PNLNAME , C.SD_RECNAME FROM PS_FS_SD_PG A , PS_FS_SD_PGGRP B , PS_FS_SD_GRPFLD C WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND A.PNLNAME = B.PNLNAME AND B.SD_GRP_NAME = C.SD_GRP_NAME AND A.IS_SEARCH_PAGE = 'Y' GROUP BY A.PNLGRPNAME, A.MARKET, A.PNLNAME , C.SD_RECNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: FS_SD_PNLGRP_VW |
| 2 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL |
Market
Default Value: GBL |
| 3 | PNLNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table: FS_SD_PNL_VW |
| 4 | SD_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Supplementa Data Record |