RBC_USAGEREC_VW

(SQL View)
Index Back

Records specified in Usage

View to select records specified in Usage

SELECT DISTINCT A.PNLGRPNAME , B.RECNAME FROM PSPNLGROUP A , PSPNLFIELD B WHERE A.PNLNAME=B.PNLNAME AND B.RECNAME<>' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: RBC_PANELGRP_VW

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).