JOBCODE_TBL_VW

(SQL View)
 Index Back

Current Job Codes View

JOBCODE_TBL_VW is a view of the JOBCODE_TBL which retrieves only the active, current effective-dated records.

SELECT A.SETID , A.JOBCODE ,A.DESCR ,A.DESCRSHORT ,A.MANAGER_LEVEL ,A.JOB_FUNCTION ,A.JOB_FAMILY ,A.SETID_SALARY ,A.SAL_ADMIN_PLAN ,A.GRADE ,A.STEP FROM PS_JOBCODE_TBL A

  • Related Language Record: JOBCDTBL_V1_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 JOBCODE Character(15) VARCHAR2(15) NOT NULL Job Code or Job Title.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 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
    6 JOB_FUNCTION Character(3) VARCHAR2(3) NOT NULL Job Function Category
    7 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
    8 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL SETID_SALARY field used in the HCM/ CRM sync Application Messages.

    Prompt Table: SETID_TBL

    9 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL SAL_ADMIN_PLAN field used in the HCM/ CRM sync Application Messages.
    10 GRADE Character(3) VARCHAR2(3) NOT NULL This is the salary grade field.
    11 STEP Number(2,0) SMALLINT NOT NULL STEP field is being use in one of the HCM/CRM Application Message.