HR_CP_TR_LBL_LG

(SQL View)
 Index Back

EE Career Plan

Travel Preference

SELECT A.JPM_JP_TYPE , A.EFFDT , A.JPM_JP_SECTION_ID , A.FIELDNAME , A.LANGUAGE_CD , A.JPM_LABEL_TEXT FROM PS_JPM_JP_PROP_LNG A WHERE A.FIELDNAME LIKE 'JPM_YN%' AND A.JPM_JP_TYPE = 'PERSON' AND A.JPM_JP_SECTION_ID = 29 AND A.EFFDT = ( SELECT MAX (B.EFFDT) FROM PS_JPM_JP_PROP_LNG B WHERE B.FIELDNAME = A.FIELDNAME AND B.EFFDT <= %CurrentDateIn AND B.JPM_JP_TYPE = A.JPM_JP_TYPE AND B.JPM_JP_SECTION_ID = A.JPM_JP_SECTION_ID)

  • Related Language Record for HR_CP_TRAV_LBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 JPM_JP_SECTION_ID Number(4,0) SMALLINT NOT NULL JPM
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: JPM_PROPS_DVW

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 JPM_LABEL_TEXT Character(30) VARCHAR2(30) NOT NULL User defined text to be displayed as a label for a field or property within JPM User Interfaces.