HCR_JOBCODE_I

(SQL View)
Index Back

Job Codes Interface View

Job Codes Interface View

SELECT A.SETID , A.JOBCODE , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.DESCRLONG , A.SAL_ADMIN_PLAN , A.GRADE , A.SAL_RANGE_CURRENCY , A.SAL_RANGE_FREQ , A.SAL_RANGE_MAX_RATE , A.SAL_RANGE_MIN_RATE , A.MANAGER_LEVEL , A.JOB_FAMILY , B.JPM_PROFILE_ID , A.ENCUMBER_INDC FROM PS_JOBCODE_TBL A ,PS_JPM_RLAT_EFDT_I B WHERE A.SETID = B.JPM_CAT_SETID (+) AND A.JOBCODE=B.JPM_RLAT_KEY1 (+) AND B.JPM_JP_TYPE (+)='JOB' AND B.JPM_RLAT_NAME (+)='JOB_CODE'

  • Related Language Record: HCR_JOBCODE_LNI
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_VLD_HR_02

    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 DESCRLONG Long Character CLOB Long Description
    8 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
    9 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    10 SAL_RANGE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Salary Range Currency
    11 SAL_RANGE_FREQ Character(5) VARCHAR2(5) NOT NULL Salary Range Frequency
    12 SAL_RANGE_MAX_RATE Number(19,6) DECIMAL(18,6) NOT NULL Salary Range Maximum Rate
    13 SAL_RANGE_MIN_RATE Number(19,6) DECIMAL(18,6) NOT NULL Salary Range Minimum Rate
    14 MANAGER_LEVEL Character(2) VARCHAR2(2) NOT NULL Manager Level
    0=Chief Operating Officer
    1=Director
    2=Senior Officer
    3=Vice President
    4=Senior Manager
    5=Mid-Level Manager
    6=First-Line Manager
    7=Supervisor
    8=All Other Positions
    9=Non-Manager
    15 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family

    Prompt Table: JOB_FAMILY_TBL

    16 JOB_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL Job Profile ID
    17 ENCUMBER_INDC Character(1) VARCHAR2(1) NOT NULL Encumbrance Indicator
    I=Encumber Immediately
    N=No Encumbrance
    R=Encumber on Requisition