EOPCAPP_SFLDLNG

(SQL View)
 Index Back

EOPCAPP_SFLD_VW

EOPCAPP_SFLD_VW

SELECT A.EOPCMAIN_ID , A.RECNAME , B.FIELDNAME , L.LANGUAGE_CD , A.EOPCAPPKEY_GRP , A.EOPCAPP_SRCREC_ID , CL.LONGNAME , CL.SHORTNAME FROM PSDBFLDLABLLANG CL , PSDBFLDLABL C , PSRECFIELDDB B , PS_EOPCMAIN_LNG L , PS_EOPCAPP_SRC_REC A WHERE L.EOPCMAIN_ID = A.EOPCMAIN_ID AND B.RECNAME = A.RECNAME AND C.FIELDNAME = B.FIELDNAME AND C.DEFAULT_LABEL = 1 AND CL.FIELDNAME = C.FIELDNAME AND CL.LABEL_ID = C.LABEL_ID AND CL.LANGUAGE_CD = L.LANGUAGE_CD AND B.LABEL_ID = ' ' UNION SELECT A.EOPCMAIN_ID , A.RECNAME , B.FIELDNAME , L.LANGUAGE_CD , A.EOPCAPPKEY_GRP , A.EOPCAPP_SRCREC_ID , CL.LONGNAME , CL.SHORTNAME FROM PSDBFLDLABLLANG CL , PSRECFIELDDB B , PS_EOPCMAIN_LNG L , PS_EOPCAPP_SRC_REC A WHERE L.EOPCMAIN_ID = A.EOPCMAIN_ID AND B.RECNAME = A.RECNAME AND CL.FIELDNAME = B.FIELDNAME AND CL.LANGUAGE_CD = L.LANGUAGE_CD AND CL.LABEL_ID = B.LABEL_ID

  • Related Language Record for EOPCAPP_SFLD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOPCMAIN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Section ID
    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 EOPCAPPKEY_GRP Character(20) VARCHAR2(20) NOT NULL EOPC App Key Group
    6 EOPCAPP_SRCREC_ID Character(20) VARCHAR2(20) NOT NULL EOPC App Source Rec ID
    7 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    8 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name