TL_JOBCD_TBL_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 A.SETID , A.JOBCODE , A.EFFDT , A.EFF_STATUS , A.DESCR , %subrec(JOBCD_FED_SBR,A) FROM PS_JOBCODE_TBL A

  • Related Language Record: TL_JOBCODE_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Set ID

    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 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan

    Prompt Table: GVT_PAY_PLAN

    7 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series

    Prompt Table: GVT_OCCUPATION

    8 TRN_PROGRAM Character(6) VARCHAR2(6) NOT NULL Training Program

    Prompt Table: TRN_PROGRM_TBL

    9 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Default Value: INSTALLATION.COMPANY

    Prompt Table: COMPANY_TBL

    10 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

    Default Value: 00

    11 GVT_POSN_TITLE_CD Character(4) VARCHAR2(4) NOT NULL Official Posn Title Code

    Prompt Table: GVT_PSN_TTL_TBL

    12 GVT_OFFICIAL_DESCR Character(70) VARCHAR2(70) NOT NULL Official Position Title
    13 GVT_ORG_TTL_CD Character(4) VARCHAR2(4) NOT NULL Organization Posn Title Code

    Prompt Table: GVT_ORG_PSN_TTL

    14 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
    15 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

    Default Value: INSTALLATION.GVT_PAY_BASIS

    16 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency

    Prompt Table: GVT_SUBAGCY_TBL

    17 GVT_POI Character(4) VARCHAR2(4) NOT NULL Personnel Office ID

    Prompt Table: GVT_POI_VW

    18 GVT_PAREN_TITLE Character(1) VARCHAR2(1) NOT NULL Parenthetical Title
    D=(Data Transcribing)
    O=(Office Automation)
    S=(Stenography)
    T=(Typing)
    19 GVT_OPM_CERT_NBR Character(8) VARCHAR2(8) NOT NULL OPM Certification Nbr
    20 GVT_POSN_CLASS_STD Character(254) VARCHAR2(254) NOT NULL Position Classification Stds
    21 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

    Default Value: 1

    22 GVT_IA_ACTIONS Character(1) VARCHAR2(1) NOT NULL IA Actions

    Y/N Table Edit

    Default Value: N

    23 GVT_EXEC_FIN_DISCL Character(1) VARCHAR2(1) NOT NULL Executive Financial Disclosure

    Y/N Table Edit

    Default Value: N

    24 GVT_EMP_FIN_INT Character(1) VARCHAR2(1) NOT NULL Employee Financial Interests

    Y/N Table Edit

    Default Value: N

    25 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
    26 GVT_CLS_STANDARD Character(15) VARCHAR2(15) NOT NULL Classification Standard

    Prompt Table: GVT_CLS_STD_TBL

    27 GVT_CLASSIFIER_ID Character(11) VARCHAR2(11) NOT NULL Classifier's ID
    28 GVT_DT_CLASSIFIED Date(10) DATE Date Classified

    Default Value: %date

    29 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2

    Prompt Table: GVT_BARG_UNIT

    30 GVT_FUND_SOURCE Character(1) VARCHAR2(1) NOT NULL Fund Source
    A=Appropriated Funds
    E=External Funds
    N=Non-Appropriated Funds
    O=Other Funds
    31 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
    32 GVT_PERF_PLAN Character(8) VARCHAR2(8) NOT NULL Performance Plan

    Prompt Table: GVT_PERF_PLAN

    33 GVT_TARGET_GRADE Character(2) VARCHAR2(2) NOT NULL Target Grade
    34 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
    35 GVT_NFC_FUNCTN_CD Character(2) VARCHAR2(2) NOT NULL Federal NFC field
    A=Add
    C=Change
    D=Delete/Restore
    I=Inactivate
    R=Reactivate

    Default Value: A

    36 GVT_OFF_TITLEPREFX Character(2) VARCHAR2(2) NOT NULL Federal NFC field
    A=Apprentice
    B=Data Transcription
    C=Office Automation
    D=Day
    E=Steno/Office Automation
    F=Foreman
    G=General Foreman
    H=Helper
    I=Inspection
    J=Coor
    K=Supervisor
    M=Instructor
    N=Trainee
    O=Senior
    R=Leader
    T=Typing
    V=Stay in School
    W=Night
    X=Trainee Leader
    Y=Stenography
    37 GVT_NFC_PI_IND_OVR Character(1) VARCHAR2(1) NOT NULL Federal NFC Field

    Y/N Table Edit

    Default Value: N

    38 GVT_PPM_JOB_IDENTY Character(1) VARCHAR2(1) NOT NULL Program and Project Management
    1=Program Manager
    2=Project Manager
    3=Program and Project Manager
    4=Not Applicable
    39 GVT_RW_TW_TYPE Character(2) VARCHAR2(2) NOT NULL Remote/Telework Type
    MW=Mobile Work Agreement
    NN=Non-teleworker
    RW=Remote Work Agreement
    TF=Frequent Routine Telework
    TP=Periodic Routine Telework
    TS=Situational Telework Agreement