JOB_PROFILE_TBL

(SQL View)
 Index Back

Job Profile Table

Job Profile Table Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from HR Core Objects to JPM.

SELECT JPM_PROFILE_ID ,STATUS_DT ,JPM_JP_PRFL_STATUS ,DESCR ,DESCRSHORT ,DESCRLONG FROM PS_JPM_PROFILE WHERE JPM_JP_TYPE = 'JOB'

  • Related Language Record: JOB_PROF_LANG

  • Parent Record Of HRS_JOB_COMP_I HRS_JOB_QUAL_I JOB_PROF_COMP JOB_PROF_QDEGVW JOB_PROF_QHONVW JOB_PROF_QLICVW JOB_PROF_QLNGVW JOB_PROF_QMEMVW JOB_PROF_QNVQVW JOB_PROF_QTSTVW JOB_PROF_QUAL JOB_PROF_RESP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JOB_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL Job Profile ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 JOB_PROF_DESCR Character(30) VARCHAR2(30) NOT NULL Job Profile Description
    5 JOB_PROF_DESCRSHRT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 JOB_PROF_DESCRLONG Long Character CLOB Job Profile Long Description