PNLGRPNAMERECNAMERB_CMP_REC_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT 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 AND F.RECNAME IN ( SELECT R2.PARENTRECNAME FROM PSRECDEFN R2 , PSRECFIELD RF WHERE R2.RECNAME = RF.RECNAME AND FIELDNAME = 'RB_ATTR_SBR') |
| # | 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). |