DC_FLD_VW(SQL View) |
Index Back |
---|
SELECT DISTINCT d.PNLGRPNAME , e.PNLNAME , b.FIELDNAME , f.SHORTNAME FROM PSPNLGROUP d , PSPNLFIELD e , PSKEYDEFN b , PSDBFIELD c , PSDBFLDLABL f WHERE d.PNLNAME = e.PNLNAME AND b.RECNAME = e.RECNAME AND b.FIELDNAME <> 'DC_OBJECT_ID' AND b.INDEXID = '_' AND b.FIELDNAME = c.FIELDNAME AND f.FIELDNAME = c.FIELDNAME AND f.DEFAULT_LABEL = 1 AND e.RECNAME IN ( SELECT a.RECNAME FROM PSPNLFIELD a WHERE a.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'. |
2 | DC_PANEL | Character(18) | VARCHAR2(18) NOT NULL | 04/05/00 laj...Added new label id for 'Page'. |
3 | DC_COPY_FLDNAM1 | Character(18) | VARCHAR2(18) NOT NULL | Copy From FieldName1 |
4 | DC_COPY_FLDESCR1 | Character(15) | VARCHAR2(15) NOT NULL | Copy Field Description1 |