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 |