SCC_PFLD_REF_VW

(SQL View)
 Index Back

Panel Field Reference View


SELECT B.PNLGRPNAME , A.RECNAME , A.FIELDNAME , A.FIELDNUM , A.PNLNAME , A.ASSOCFIELDNUM FROM PSPNLFIELD A , PSPNLGROUP B WHERE A.PNLNAME=B.PNLNAME AND ((A.PNLNAME IN ( SELECT PNLNAME FROM PSPNLGROUP WHERE PNLGRPNAME=B.PNLGRPNAME) AND A.SUBPNLNAME=' ') OR (A.PNLNAME IN ( SELECT SUBPNLNAME FROM PSPNLFIELD WHERE (PNLNAME IN ( SELECT PNLNAME FROM PSPNLGROUP WHERE PNLGRPNAME=B.PNLGRPNAME) AND SUBPNLNAME<>' '))) OR (A.PNLNAME IN ( SELECT SUBPNLNAME FROM PSPNLFIELD WHERE (PNLNAME IN ( SELECT SUBPNLNAME FROM PSPNLFIELD WHERE (PNLNAME IN ( SELECT PNLNAME FROM PSPNLGROUP WHERE PNLGRPNAME=B.PNLGRPNAME) AND SUBPNLNAME<>' '))))))

# 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).
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
5 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
6 ASSOCFIELDNUM Number(4,0) SMALLINT NOT NULL Associated Field Number