EP_J_JP_TMPL_LN

(SQL View)
 Index Back

Profile Types: Template PIO

This is related language view for EP_J_JP_TMPL_I

SELECT LN.JPM_JP_TYPE , LN.EFFDT , LN.LANGUAGE_CD , LN.DESCR FROM PS_JPM_JP_TYPE_LNG LN , PS_JPM_JP_TYPES_I JP WHERE LN.JPM_JP_TYPE = JP.JPM_JP_TYPE AND LN.EFFDT = JP.EFFDT AND JP.JPM_JP_TYPE_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM PS_JPM_JP_TYP_PAOS A WHERE A.JPM_JP_TYPE = JP.JPM_JP_TYPE AND A.EFFDT = JP.EFFDT AND A.JPM_RLAT_NAME = 'EPERF_TMPLT')

  • Related Language Record for EP_J_JP_TMPL_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EP_J_JP_TYPE Character(12) VARCHAR2(12) NOT NULL ePerformance specific field for Profile Type
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description