MARKETPNLGRPNAMERECNAMERB_CMP_REC_VW2(SQL View) |
Index Back |
|---|---|
Component record viewList of records in a given component |
| SELECT DISTINCT C.MARKET , C.PNLGRPNAME , F.RECNAME FROM PSPNLGROUP C , PSPNLFIELD F , PSRECDEFN R WHERE C.PNLNAME = F.PNLNAME AND F.RECNAME = R.RECNAME AND R.RECTYPE IN (0, 1, 5, 6) AND F.ASSOCFIELDNUM = 0 AND F.RECNAME <> ' ' AND F.FIELDTYPE <> 2 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 2 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |