DC_PNLGRP_VW

(SQL View)
Index Back

DC Component View


SELECT DISTINCT C.PNLGRPNAME , C.DESCR FROM PSPNLGRPDEFN C , PSPNLGROUP A , PSPNLFIELD B WHERE A.PNLGRPNAME = C.PNLGRPNAME AND A.PNLNAME = B.PNLNAME AND A.MARKET ='GBL' AND B.FIELDNAME = 'DC_OBJECT_ID'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DC_PNLGRP Character(18) VARCHAR2(18) NOT NULL 04/05/00 laj...Added new label id for 'Component'.

Prompt Table: DC_PNLGRP_VW

2 DC_PNLGRP_NAME Character(30) VARCHAR2(30) NOT NULL Component Description