PNLGRPNAMERECNAMEEORC_CMPREC_V(SQL View) |
Index Back |
|---|
| SELECT A.PNLGRPNAME , B.RECNAME FROM PS_PRCSDEFNPNL A , PSPNLFIELD B , PSPNLGROUP C WHERE A.PNLGRPNAME = C.PNLGRPNAME AND C.PNLNAME=B.PNLNAME AND B.RECNAME<> ' ' AND B.RECNAME<>'PRCSRUNCNTL' AND ( SELECT RECTYPE FROM PSRECDEFN D WHERE D.RECNAME=B.RECNAME)=0 AND ( SELECT OBJECTOWNERID FROM PSRECDEFN D WHERE D.RECNAME=B.RECNAME)<>'PPT' GROUP BY A.PNLGRPNAME, B.RECNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |