JPM_KEY_FD_LVW

(SQL View)
 Index Back

Rel Lang for JPM_KEy_FD_VW


SELECT B.RECNAME , B.FIELDNAME , A1.LANGUAGE_CD , A1.LONGNAME FROM PSDBFLDLABL A , PSDBFLDLABLLANG A1 , PSRECFIELD B WHERE A.FIELDNAME = B.FIELDNAME AND A.DEFAULT_LABEL = 1 AND A.FIELDNAME = A1.FIELDNAME AND A.LABEL_ID = A1.LABEL_ID

  • Related Language Record for JPM_KEY_FD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_PROMPT_REC_NM Character(15) VARCHAR2(15) NOT NULL Prompt Table Name
    2 JPM_PROMPT_FLD_NM Character(18) VARCHAR2(18) NOT NULL Prompt Field Name
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description