HRS_JOBPROF_I

(SQL View)
 Index Back

HRS - Job Profile Interface

Job Profile Interface View - returns non-person 'JOB' profiles only

SELECT A.JPM_PROFILE_ID , A.JPM_JP_PRFL_STATUS , A.DESCR , A.DESCRSHORT FROM PS_JPM_PROFILE_I A WHERE A.JPM_JP_TYPE = 'JOB' AND A.JPM_JP_PRFL_STATUS = 'A' AND A.JPM_PROFILE_USAGE = 'J'

  • Related Language Record: HRS_JOBPROF_LNI

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JOB_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL Job Profile ID
    2 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    3 JOB_PROF_DESCR Character(30) VARCHAR2(30) NOT NULL Job Profile Description
    4 JOB_PROF_DESCRSHRT Character(10) VARCHAR2(10) NOT NULL Short Description