GP_MT_RFL_LNG

(SQL View)
 Index Back

RelLang for Rec-Fields per Com

Related Lnguage record for GP_MT_RFLD_VW

SELECT DISTINCT PG.PNLGRPNAME , RF.RECNAME , RF.FIELDNAME , FLL.LANGUAGE_CD , FLL.LONGNAME FROM PSPNLGROUP PG , PSPNLFIELD PF , PSRECFIELDALL RF , PSDBFLDLABL FL , PSDBFLDLABLLANG FLL WHERE ( PF.PNLNAME = PG.PNLNAME OR PF.PNLNAME IN ( SELECT PF1.SUBPNLNAME FROM PSPNLGROUP PG1 , PSPNLFIELD PF1 WHERE PG1.PNLGRPNAME = PG.PNLGRPNAME AND PF1.PNLNAME = PG1.PNLNAME AND PF1.SUBPNLNAME <> ' ' ) ) AND PF.ASSOCFIELDNUM = 0 AND PF.RECNAME <> ' ' AND PF.FIELDNUM = ( SELECT MIN(PF1.FIELDNUM) FROM PSPNLFIELD PF1 WHERE PF1.PNLNAME = PF.PNLNAME AND PF1.RECNAME = PF.RECNAME ) AND RF.RECNAME = PF.RECNAME AND FL.FIELDNAME = RF.FIELDNAME AND FL.DEFAULT_LABEL = 1 AND FLL.FIELDNAME = FL.FIELDNAME AND FLL.LABEL_ID = FL.LABEL_ID

  • Related Language Record for GP_MT_RFLD_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description