EQTNRECFLDVWLN

(SQL View)
 Index Back

Rel Lang Equ Data Recfield

EQTNRECFLDVWLN is the language record related to EQTN_RECFLD_VW A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT A.EQTN_DATA_RECNAME ,B.FIELDNAME ,F.LANGUAGE_CD ,E.LONGNAME FROM PS_EQTN_DATA_TBL A , PSRECFIELD B , PSDBFIELD C , PSDBFLDLABL E ,PS_EQTN_DATA_LNG F WHERE A.EQTN_DATA_RECNAME = B.RECNAME AND A.EFF_STATUS='A' AND A.EFFDT= ( SELECT MAX(D.EFFDT) FROM PS_EQTN_DATA_TBL D ,PS_EQTN_DATA_LNG G WHERE D.EQTN_DATA_RECNAME = A.EQTN_DATA_RECNAME AND D.EFFDT <= %CurrentDateIn AND D.EQTN_DATA_RECNAME=G.EQTN_DATA_RECNAME AND D.EFFDT=G.EFFDT ) AND B.FIELDNAME = C.FIELDNAME AND C.FIELDNAME = E.FIELDNAME AND E.DEFAULT_LABEL = 1 AND A.EQTN_DATA_RECNAME=F.EQTN_DATA_RECNAME AND A.EFFDT=F.EFFDT

  • Related Language Record for EQTN_RECFLD_VW

  • Parent record: EQTN_DATA_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQTN_DATA_RECNAME Character(15) VARCHAR2(15) NOT NULL Equation Processor Data Record Name.
    2 EQTN_DATA_FLDNAME Character(18) VARCHAR2(18) NOT NULL Equation Data Fieldname.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description