EP_J_JP_PERS_I

(SQL View)
 Index Back

Profile Types: Person

ePerformance Interface view for the Profile Type Interface view. This view only contain active Profile Type which have "person" Profile Identity Options. These "person" identify options include only the "person" identity option.

SELECT DISTINCT JP.JPM_JP_TYPE , JP.EFFDT , JP.DESCR FROM PS_JPM_JP_TYPES_I JP , PS_JPM_JP_TYP_PI_I A , PS_JPM_JP_SECTION S WHERE JPM_JP_TYPE_STATUS = 'A' AND JP.JPM_JP_TYPE = A.JPM_JP_TYPE AND JP.JPM_JP_TYPE = S.JPM_JP_TYPE AND A.EFFDT = JP.EFFDT AND A.JPM_RLAT_NAME = 'PERSON' AND A.JPM_JP_END_PROFILE = 'Y' AND S.JPM_JP_QUAL_SET2 <> ' '

  • Related Language Record: EP_J_JP_PERS_LN

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