HR_CP_TRAV_LBL

(SQL View)
 Index Back

EE Career Plan

Travel Preference

SELECT A.JPM_JP_TYPE , A.EFFDT , A.JPM_JP_SECTION_ID , A.FIELDNAME , A.JPM_LABEL_TEXT FROM PS_JPM_JP_PROPS 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_PROPS 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: HR_CP_TR_LBL_LG

    • # 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 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.