JOBCD_TBL_EF_VW

(SQL View)
 Index Back

Job Codes

Use JOBCODE_TBL to record information about the job assignments in your company. Assign a job code to each job. Data includes description, salary grade, standard hours, and salary survey equivalents. You can create multiple JOBCODE_TBL records for a job code, each with a unique effective date.

SELECT SETID , JOBCODE , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , JOB_FUNCTION , SETID_SALARY , SAL_ADMIN_PLAN , GRADE , STEP , MANAGER_LEVEL , SURVEY_SALARY , SURVEY_JOB_CODE , UNION_CD , RETRO_RATE , RETRO_PERCENT , CURRENCY_CD , STD_HOURS , STD_HRS_FREQUENCY , COMP_FREQUENCY , WORKERS_COMP_CD , JOB_FAMILY , JOB_KNOWHOW_POINTS , JOB_ACCNTAB_POINTS , JOB_PROBSLV_POINTS , JOB_POINTS_TOTAL , JOB_KNOWHOW_PCT , JOB_ACCNTAB_PCT , JOB_PROBSLV_PCT , REG_TEMP , DIRECTLY_TIPPED , MED_CHKUP_REQ , FLSA_STATUS , EEO1CODE , EEO4CODE , EEO5CODE , EEO6CODE , EEO_JOB_GROUP , US_SOC_CD , IPEDSSCODE , CAN_PAYEQ_JOB_CLS , FUNCTION_CD , BA_CD , TECHNICAL , MED_SURV_REQ , EMP_CATEGRY_FRA , ACTIVITY_TYPE_FRA , INSEE_CD_FRA , UK_SOC_CD , GVT_PAY_PLAN , GVT_OCC_SERIES , TRN_PROGRAM , COMPANY , GVT_FUNC_CLASS , GVT_POSN_TITLE_CD , GVT_OFFICIAL_DESCR , GVT_ORG_TTL_CD , GVT_ORG_TTL_DESCR , GVT_PAY_BASIS , GVT_SUB_AGENCY , GVT_POI , GVT_PAREN_TITLE , GVT_OPM_CERT_NBR , GVT_POSN_CLASS_STD , GVT_POSN_SENS_CD , GVT_IA_ACTIONS , GVT_EXEC_FIN_DISCL , GVT_EMP_FIN_INT , GVT_PATCOB_CD , GVT_CLS_STANDARD , GVT_CLASSIFIER_ID , GVT_DT_CLASSIFIED , BARG_UNIT , GVT_FUND_SOURCE , GVT_LEO_POSITION , GVT_PERF_PLAN , GVT_TARGET_GRADE , GVT_PI_UPD_IND , ENCUMBER_INDC , POSN_MGMT_INDC , EG_ACADEMIC_RANK , EG_GROUP , HP_STATS_DUTIES , HP_STATS_RPT_FLAG , ENCUMB_SAL_OPTN , ENCUMB_SAL_AMT , INAIL_CODE , CNO_ESP , DESCRLONG FROM PS_JOBCODE_TBL JCD WHERE JCD.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOBCODE_TBL WHERE JOBCODE = JCD.JOBCODE AND EFFDT <= %CurrentDateIn)

  • Related Language Record: JOBCD_LNG_EF_VW

    • # 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_JOBC_VLD_VW

    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 JOB_FUNCTION Character(3) VARCHAR2(3) NOT NULL Job Function Code

    Prompt Table: JOBFUNCTION_TBL

    8 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID

    Prompt Table: %SAL_SETID_PRMP

    9 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: %SAL_PLN_PRMPT2

    10 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: %SAL_GRD_PRMPT2

    11 STEP Number(2,0) SMALLINT NOT NULL Step

    Prompt Table: %SAL_STP_PRMPT2

    12 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

    Default Value: 8

    13 SURVEY_SALARY Number(8,0) INTEGER NOT NULL Survey Salary
    14 SURVEY_JOB_CODE Character(8) VARCHAR2(8) NOT NULL Salary Survey Job Code
    15 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

    Prompt Table: UNION_TBL

    16 RETRO_RATE Signed Number(8,4) DECIMAL(6,4) NOT NULL Retroactive Rate
    17 RETRO_PERCENT Signed Number(8,4) DECIMAL(6,4) NOT NULL Retroactive Percent
    18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    19 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours

    Default Value: OPR_DEF_TBL_HR.STD_HRS_DEFAULT

    20 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

    Default Value: OPR_DEF_TBL_HR.STD_HRS_FREQUENCY

    Prompt Table: STDHRS_FREQ_VW

    21 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    H=Hourly
    M=Monthly
    S=Semimonthly
    W=Weekly

    Default Value: INSTALLATION.COMP_FREQUENCY

    Prompt Table: COMP_FREQ_VW

    22 WORKERS_COMP_CD Character(4) VARCHAR2(4) NOT NULL Workers' Comp Code
    23 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family

    Prompt Table: JOB_FAMILY_TBL

    24 JOB_KNOWHOW_POINTS Number(5,0) INTEGER NOT NULL Knowhow-Points
    25 JOB_ACCNTAB_POINTS Number(5,0) INTEGER NOT NULL Accountability-Points
    26 JOB_PROBSLV_POINTS Number(5,0) INTEGER NOT NULL Problem-Solving-Points
    27 JOB_POINTS_TOTAL Number(5,0) INTEGER NOT NULL Total Points
    28 JOB_KNOWHOW_PCT Number(5,1) DECIMAL(4,1) NOT NULL Knowhow-Percent
    29 JOB_ACCNTAB_PCT Number(5,1) DECIMAL(4,1) NOT NULL Accountability-Percent
    30 JOB_PROBSLV_PCT Number(5,1) DECIMAL(4,1) NOT NULL Problem-Solving-Percent
    31 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    32 DIRECTLY_TIPPED Character(1) VARCHAR2(1) NOT NULL Tipped
    D=Directly Tipped
    I=Indirectly Tipped
    N=Not Tipped

    Default Value: N

    33 MED_CHKUP_REQ Character(1) VARCHAR2(1) NOT NULL Medical Checkup Required

    Y/N Table Edit

    Default Value: N

    34 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status
    A=Administrative
    C=Computer Employee
    E=Executive
    H=Highly Compensated Employees
    M=Management
    N=Nonexempt
    O=Outside Salesperson
    P=Professional
    V=Nonexempt Alt Overtime
    X=No FLSA Required
    35 EEO1CODE Character(1) VARCHAR2(1) NOT NULL EEO-1 Job Category
    1=Officials and Managers
    2=Professionals
    3=Technicians
    4=Sales Workers
    5=Administrative Support Workers
    6=Craft Workers
    7=Operatives
    8=Laborers and Helpers
    9=Service Workers
    A=Executive/Sr Level Officials
    B=First/Mid Level Officials
    N=No EEO-1 Reporting
    36 EEO4CODE Character(1) VARCHAR2(1) NOT NULL EEO-4 Job Category
    1=Officials and Administrators
    2=Professionals
    3=Technicians
    4=Protective Service
    5=Paraprofessionals
    6=Administrative Support
    7=Skilled Craft
    8=Service Maintenance
    N=No EEO-4 Reporting
    37 EEO5CODE Character(2) VARCHAR2(2) NOT NULL EEO-5 Job Category
    1=Officials,Administrators,Mgrs
    10=Librarian/Audiovisual
    11=Consultants/Supv.of Instructn
    12=Other Professional Staff
    13=Teacher Aides
    14=Technicians
    15=Clerical/Secretarial
    16=Service Workers
    17=Craft Workers (Skilled)
    18=Laborers (Unskilled)
    2=Principals
    3=Asst. Principals-Teaching
    4=Asst. Principals-Nonteaching
    5=Elementary Classroom Teachers
    6=Secondary Classroom Teachers
    7=Other Classroom Teachers
    8=Guidance
    9=Psychological
    N=No EEO-5 Reporting
    38 EEO6CODE Character(1) VARCHAR2(1) NOT NULL EEO-6 Job Category
    1=Executive/Admin/Managerial
    2=Faculty
    3=Professional Nonfaculty
    4=Secretarial/Clerical
    5=Technical/Paraprofessional
    6=Skilled Crafts
    7=Service Maintenance Workers
    N=No EEO-6 Reporting
    39 EEO_JOB_GROUP Character(4) VARCHAR2(4) NOT NULL EEO Job Group
    40 US_SOC_CD Character(10) VARCHAR2(10) NOT NULL Standard Occupational Classif
    41 IPEDSSCODE Character(1) VARCHAR2(1) NOT NULL IPEDS-S Job Category
    42 CAN_PAYEQ_JOB_CLS Character(3) VARCHAR2(3) NOT NULL Canadian Pay Equity Job Class
    43 FUNCTION_CD Character(2) VARCHAR2(2) NOT NULL Function Code
    44 BA_CD Character(5) VARCHAR2(5) NOT NULL BA Code
    45 TECHNICAL Character(1) VARCHAR2(1) NOT NULL Technical
    46 MED_SURV_REQ Character(1) VARCHAR2(1) NOT NULL Medical Surveillance Required
    47 EMP_CATEGRY_FRA Character(3) VARCHAR2(3) NOT NULL Employee Category
    CAD=Executive
    ETA=Manager
    OUV=Workman
    48 ACTIVITY_TYPE_FRA Character(3) VARCHAR2(3) NOT NULL Activity Type
    ATE=WorkShop Personnel
    AUT=Other
    BUR=Office Personnel
    CHA=Shoulder Worker
    SIE=Corporate Personnel
    49 INSEE_CD_FRA Character(4) VARCHAR2(4) NOT NULL Insee Code - FRA
    50 UK_SOC_CD Character(2) VARCHAR2(2) NOT NULL Standard Occupational Classification major groups for Northern Ireland
    1=Managers and administrators
    2=Professional occupations
    3=Assoc prof/techn occupations
    4=Clerical/sectrl occupations
    5=Crafts and related occupations
    6=Prsnl/prtive srvc occupations
    7=Sales occupations
    8=Plant and machine operatives
    9=Other occupations
    51 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
    52 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
    53 TRN_PROGRAM Character(6) VARCHAR2(6) NOT NULL Training Program
    54 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    55 GVT_FUNC_CLASS Character(2) VARCHAR2(2) NOT NULL Functional Class
    00=Not Applicable
    11=Research
    12=Research,Contract/Grant Admin
    13=Development
    14=Test and Evaluation
    21=Design
    22=Construction
    23=Production
    24=Install/Operations/Maintenance
    31=Data Collect/Process/Analysis
    32=Scientific/Technical Info
    41=Standards and Specifications
    42=Regulatory Enforcement/License
    51=Natural Resource Operations
    81=Clinical Practice/Counseling
    91=Planning
    92=Management
    93=Teaching/Training
    94=Technical Assistance/Consult
    99=Other
    56 GVT_POSN_TITLE_CD Character(4) VARCHAR2(4) NOT NULL Official Posn Title Code
    57 GVT_OFFICIAL_DESCR Character(70) VARCHAR2(70) NOT NULL Official Position Title
    58 GVT_ORG_TTL_CD Character(4) VARCHAR2(4) NOT NULL Organization Posn Title Code
    59 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
    60 GVT_PAY_BASIS Character(2) VARCHAR2(2) NOT NULL Pay Basis
    BW=Bi-weekly
    FB=Fee Basis
    PA=Per Annum
    PD=Per Diem
    PH=Per Hour
    PM=Per Month
    PW=Piece Work
    SM=Semi-monthly
    SY=School Year
    WC=Without Compensation
    61 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency
    62 GVT_POI Character(4) VARCHAR2(4) NOT NULL Personnel Office ID
    63 GVT_PAREN_TITLE Character(1) VARCHAR2(1) NOT NULL Parenthetical Title
    D=(Data Transcribing)
    O=(Office Automation)
    S=(Stenography)
    T=(Typing)
    64 GVT_OPM_CERT_NBR Character(8) VARCHAR2(8) NOT NULL OPM Certification Nbr
    65 GVT_POSN_CLASS_STD Character(254) VARCHAR2(254) NOT NULL Position Classification Stds
    66 GVT_POSN_SENS_CD Character(1) VARCHAR2(1) NOT NULL Sensitivity Code
    1=Non Sensitive
    2=Non-Critical, Sensitive
    3=Critical Sensitive
    4=Special Sensitive
    67 GVT_IA_ACTIONS Character(1) VARCHAR2(1) NOT NULL IA Actions
    68 GVT_EXEC_FIN_DISCL Character(1) VARCHAR2(1) NOT NULL Executive Financial Disclosure
    69 GVT_EMP_FIN_INT Character(1) VARCHAR2(1) NOT NULL Employee Financial Interests
    70 GVT_PATCOB_CD Character(1) VARCHAR2(1) NOT NULL PATCOB Code
    1=Exception 1
    2=Exception 2
    3=Exception 3
    4=Exception 4
    5=Exception 5
    6=Exception 6
    7=Exception 7
    8=Exception 8
    A=Administrative
    B=Blue Collar
    C=Clerical
    M=Mixed Collar
    O=Other White Collar
    P=Professional
    T=Technical
    71 GVT_CLS_STANDARD Character(15) VARCHAR2(15) NOT NULL Classification Standard
    72 GVT_CLASSIFIER_ID Character(11) VARCHAR2(11) NOT NULL Classifier's ID
    73 GVT_DT_CLASSIFIED Date(10) DATE Date Classified
    74 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2
    75 GVT_FUND_SOURCE Character(1) VARCHAR2(1) NOT NULL Fund Source
    A=Appropriated Funds
    E=External Funds
    N=Non-Appropriated Funds
    O=Other Funds
    76 GVT_LEO_POSITION Character(1) VARCHAR2(1) NOT NULL LEO/Fire Position
    5=5USC 5305 LEO
    C=D.C. Police Forces
    F=Fire Fighter
    N=Not Applicable
    P=Primary FEPCA
    S=Secondary FEPCA
    77 GVT_PERF_PLAN Character(8) VARCHAR2(8) NOT NULL Performance Plan
    78 GVT_TARGET_GRADE Character(2) VARCHAR2(2) NOT NULL Target Grade
    79 GVT_PI_UPD_IND Character(1) VARCHAR2(1) NOT NULL PI upd ind
    A=Applied at NFC
    I=Auto Action Inserted
    N=Not Ready to Process
    P=In Process
    R=Ready To Process
    S=SINQ Error
    Z=Other
    80 ENCUMBER_INDC Character(1) VARCHAR2(1) NOT NULL Encumbrance Indicator
    I=Encumber Immediately
    N=No Encumbrance
    R=Encumber on Requisition

    Default Value: N

    81 POSN_MGMT_INDC Character(1) VARCHAR2(1) NOT NULL Used by Position Management

    Y/N Table Edit

    Default Value: Y

    82 EG_ACADEMIC_RANK Character(3) VARCHAR2(3) NOT NULL Academic Rank

    Prompt Table: EG_RANK_TBL

    83 EG_GROUP Character(6) VARCHAR2(6) NOT NULL Service Calculation Group

    Prompt Table: EG_CALC_SVC_VW

    84 HP_STATS_DUTIES Character(2) VARCHAR2(2) NOT NULL Stats-Can Duties
    10=Teaching Only
    20=Teaching & Othr Responsibility
    30=Research
    85 HP_STATS_RPT_FLAG Character(1) VARCHAR2(1) NOT NULL Stats-Can Report Flag
    B=Both Surveys
    F=Full-Time Survey
    N=Not Applicable
    P=Part-Time Survey

    Default Value: N

    86 ENCUMB_SAL_OPTN Character(3) VARCHAR2(3) NOT NULL Encumber Salary Option
    COM=Sum of Default Components
    MAX=Salary Grade Maximum
    MID=Salary Grade Midpoint
    MIN=Salary Grade Minimum
    STP=Salary Step
    USR=User Specified Amount

    Default Value: STP

    87 ENCUMB_SAL_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Encumber Salary Amount
    88 INAIL_CODE Character(11) VARCHAR2(11) NOT NULL INAIL Code
    89 CNO_ESP Character(4) VARCHAR2(4) NOT NULL Occupational Code
    90 DESCRLONG Long Character CLOB Long Description