07/19/99 RT get shortname from psdbfldlabl

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