EP_J_JP_TYPE_I

(SQL View)
 Index Back

Profile Types: All

ePerformance Interface view for the Profile Type Interface view. This view only contain active and "end" Profile Types

SELECT JPM_JP_TYPE , EFFDT , DESCR FROM PS_JPM_JP_TYPES WHERE JPM_JP_TYPE_STATUS = 'A' AND JPM_JP_END_PROFILE = 'Y'

  • Related Language Record: EP_JP_TYPE_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