EP_J_JP_NPERS_I

(SQL View)
 Index Back

Profile Types: Non-Person

ePerformance Interface view for the Profile Type Interface view. This view only contain active Profile Type which have "non-person" Profile Identity Options. These "non-person" identify options include: job code, job family, position, and salary grade.

SELECT JPM_JP_TYPE , EFFDT , DESCR FROM PS_JPM_JP_TYPES_I WHERE JPM_JP_TYPE_STATUS = 'A' AND NOT EXISTS ( SELECT 'X' FROM PS_JPM_JP_TYP_PI_I A WHERE A.JPM_JP_TYPE = PS_JPM_JP_TYPES_I.JPM_JP_TYPE AND A.EFFDT = PS_JPM_JP_TYPES_I.EFFDT AND A.JPM_RLAT_NAME = 'PERSON' AND A.JPM_JP_END_PROFILE = 'Y')

  • Related Language Record: EP_JPNPERS_LN_V

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description