RB_COMP_LVL_VW

(SQL View)
 Index Back

Component Levels


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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
2 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level