JOBCODE_TBL

(SQL Table)
 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.

  • Related Language Record: JOBCODE_LANG

  • Parent Record Of CAN_JOBCODE_CU FPMJB_RATECODE GVT_JCOD_FCT JBCD_CMP_RT2_VW JBCD_CMP_RT3_VW JOBCD_COMP_RATE JOBCD_TRN_PROG JOBCODE_TBL_BRA PPP_ENV_LOC_BRA

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

    Default Value: N

    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

    Default Value: N

    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

    Default Value: N

    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

    Default Value: N

    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

    Default Value: N

    39 EEO_JOB_GROUP Character(4) VARCHAR2(4) NOT NULL EEO Job Group

    Prompt Table: EEO_JOB_GRP_TBL

    40 US_SOC_CD Character(10) VARCHAR2(10) NOT NULL Standard Occupational Classif

    Prompt Table: US_SOC_TBL

    41 IPEDSSCODE Character(1) VARCHAR2(1) NOT NULL IPEDS-S Job Category

    Default Value: N

    42 US_OCC_CD Character(4) VARCHAR2(4) NOT NULL Occupational Classification Code

    Prompt Table: US_OCC_TBL

    43 AVAIL_TELEWORK Character(1) VARCHAR2(1) NOT NULL Job Code Available for Telework

    Y/N Table Edit

    Default Value: N

    44 BN_ACA_ELIG_IND Character(1) VARCHAR2(1) NOT NULL ACA (Affordable Care Act) Eligibility Indicator
    A=Always Eligible
    E=Eligible
    I=Ineligible
    U=To be determined
    X=Excluded
    45 CAN_PAYEQ_JOB_CLS Character(3) VARCHAR2(3) NOT NULL Canadian Pay Equity Job Class

    Prompt Table: CAN_PAYEQ_TBL

    46 CAN_NOC_CD Character(10) VARCHAR2(10) NOT NULL National Occupational Classif

    Prompt Table: CAN_NOC_TBL

    47 SEASONAL Character(1) VARCHAR2(1) NOT NULL Seasonal

    Y/N Table Edit

    Default Value: N

    48 BPS_ACTIVITY_CD Character(6) VARCHAR2(6) NOT NULL BPS Activity

    Prompt Table: BPS_ACT_TBL

    49 ELS_STATUS Character(1) VARCHAR2(1) NOT NULL Employment and Labour Standards Status
    1=Exempt
    2=Non-Exempt

    Default Value: 2

    50 FUNCTION_CD Character(2) VARCHAR2(2) NOT NULL Function Code

    Prompt Table: FUNCTION_CD_TBL

    51 BA_CD Character(5) VARCHAR2(5) NOT NULL BA Code

    Prompt Table: BA_CD_TBL

    52 TECHNICAL Character(1) VARCHAR2(1) NOT NULL Technical

    Y/N Table Edit

    53 MED_SURV_REQ Character(1) VARCHAR2(1) NOT NULL Medical Surveillance Required

    Y/N Table Edit

    Default Value: N

    54 EMP_CATEGRY_FRA Character(3) VARCHAR2(3) NOT NULL Employee Category
    CAD=Executive
    ETA=Manager
    OUV=Workman
    55 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
    56 INSEE_CD_FRA Character(4) VARCHAR2(4) NOT NULL Insee Code - FRA

    Prompt Table: INSEE_TBL_FRA

    57 JOB_CTG_FRA_CD Character(2) VARCHAR2(2) NOT NULL Job Category Code - FRA

    Prompt Table: JOB_CTG_FRA_TBL

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

    Prompt Table: GVT_PAY_PLAN

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

    Prompt Table: GVT_OCCUPATION

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

    Prompt Table: TRN_PROGRM_TBL

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

    Default Value: INSTALLATION.COMPANY

    Prompt Table: COMPANY_TBL

    63 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

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

    Prompt Table: GVT_PSN_TTL_TBL

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

    Prompt Table: GVT_ORG_PSN_TTL

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

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

    Prompt Table: GVT_SUBAGCY_TBL

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

    Prompt Table: GVT_POI_VW

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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: GVT_CLS_STD_TBL

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

    Default Value: %date

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

    Prompt Table: GVT_BARG_UNIT

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

    Prompt Table: GVT_PERF_PLAN

    86 GVT_TARGET_GRADE Character(2) VARCHAR2(2) NOT NULL Target Grade
    87 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
    88 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

    89 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
    90 GVT_NFC_PI_IND_OVR Character(1) VARCHAR2(1) NOT NULL Federal NFC Field

    Y/N Table Edit

    Default Value: N

    91 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
    92 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
    93 ENCUMBER_INDC Character(1) VARCHAR2(1) NOT NULL Encumbrance Indicator
    I=Encumber Immediately
    N=No Encumbrance
    R=Encumber on Requisition

    Default Value: N

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

    Y/N Table Edit

    Default Value: Y

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

    Prompt Table: EG_RANK_TBL

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

    Prompt Table: EG_CALC_SVC_VW

    97 HP_STATS_DUTIES Character(2) VARCHAR2(2) NOT NULL Stats-Can Duties
    10=Teaching Only
    20=Teaching & Othr Responsibility
    30=Research
    98 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

    99 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

    100 ENCUMB_SAL_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Encumber Salary Amount
    101 INAIL_CODE Character(11) VARCHAR2(11) NOT NULL INAIL Code

    Prompt Table: JOB_ITAINAIL_VW

    102 CNO_ESP Character(4) VARCHAR2(4) NOT NULL Occupational Code

    Prompt Table: CNO4_ESPVW

    103 ASCO_CD_AUS Character(6) VARCHAR2(6) NOT NULL This field is used to group occupations into categories

    Prompt Table: ASCO_TBL_AUS

    104 PKG_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Sal Package - Package Template ID

    Prompt Table: PKG_TMP_TBL

    105 PKG_RULE_ID Character(10) VARCHAR2(10) NOT NULL Sal Package - Package Rule ID

    Prompt Table: PKG_RULE_TBL

    106 FUNCTION_AUS Character(1) VARCHAR2(1) NOT NULL This field refers to the role performed by the employee. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
    1=Teaching only function
    2=Research only function
    3=Teaching & Research function
    4=Other function
    107 ANN_CNTACT_HRS_AUS Number(7,2) DECIMAL(6,2) NOT NULL This field represents the total number of hours spent annually in a teaching job. The field is used for calculating FTE equivalence. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
    108 TEACH_WEEKS_AUS Number(2,0) SMALLINT NOT NULL This field represents the total number of weeks worked by a member of staff in the role of teaching. The field is used for calculating FTE equivalence. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
    109 CASUAL_TYPE_AUS Character(1) VARCHAR2(1) NOT NULL This field translates the type of work performed by a member of the staff and is used for calculating FTE equivalence for casual types. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
    L=Lecturing
    R=Market/Research/Other
    S=Supervise/Tutorial Workshop
    110 WORK_DAY_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Number of Hours in a Work Day
    111 FA_PAY_PROGRAM Character(3) VARCHAR2(3) NOT NULL Festive Advance Pay Program that the Employee is enrolled in.

    Prompt Table: FA_PAY_HDR

    112 ELECTION_GROUP Character(5) VARCHAR2(5) NOT NULL Election Group

    Prompt Table: ELECTION_GR_TBL

    113 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

    Prompt Table: EMPL_CTG

    114 FP_PROF_CATG Character(3) VARCHAR2(3) NOT NULL Labor Agreement Category
    AGT=Supervisory Officer
    DIR=Director
    TEC=Technician
    115 FP_JOB_FMLY Character(4) VARCHAR2(4) NOT NULL CS Job Code
    FEM1=Job Family 1
    FEM2=Job Family 2
    116 FP_OFF_COLAG Character(1) VARCHAR2(1) NOT NULL Job Outside Coll Lbor Agrment

    Y/N Table Edit

    Default Value: N

    117 FP_MATRIX_TYP Character(3) VARCHAR2(3) NOT NULL Salary Grade Table Type
    GEC=Under Contract Grid
    GES=Statutory Grid
    GFP=Public Service Grid

    Prompt Table: FPMMATXTYP_TBL

    118 FP_MATRIX_CD Character(4) VARCHAR2(4) NOT NULL Salary Grade Table Code

    Prompt Table: FPMSALMATRX_VW1

    119 FP_BUSINESS_CD Character(4) VARCHAR2(4) NOT NULL Occupation Code

    Prompt Table: FPMBUISNESS_TBL

    120 FP_JOBCD_ACC Character(1) VARCHAR2(1) NOT NULL Match Competencies

    Y/N Table Edit

    Default Value: Y

    121 FP_ATCH_AREA Character(4) VARCHAR2(4) NOT NULL Attachment Sector
    ADMN=Administrative Sector
    OUV=Industrial Sector
    PRIV=Private Sector
    122 FP_JOB_TYP Character(2) VARCHAR2(2) NOT NULL Job Type
    CO=Public / Private
    PR=Private
    SP=Public

    Default Value: CO

    123 FP_AUTO_RATFY Character(1) VARCHAR2(1) NOT NULL Auto Hire Validation

    Y/N Table Edit

    124 LAST_UPDATE_DATE Date(10) DATE Date of last update

    Default Value: %date

    125 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_STANDARD_VW

    126 SAL_RANGE_MIN_RATE Number(19,6) DECIMAL(18,6) NOT NULL Salary Range Minimum Rate
    127 SAL_RANGE_MID_RATE Number(19,6) DECIMAL(18,6) NOT NULL Salary Range Midpoint Rate
    128 SAL_RANGE_MAX_RATE Number(19,6) DECIMAL(18,6) NOT NULL Salary Range Maximum Rate
    129 SAL_RANGE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Salary Range Currency

    Prompt Table: CURRENCY_CD_TBL

    130 SAL_RANGE_FREQ Character(5) VARCHAR2(5) NOT NULL Salary Range Frequency

    Prompt Table: COMP_FREQ_VW

    131 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service

    Prompt Table: MIL_SERVICE_TBL

    132 MIL_RANK Character(5) VARCHAR2(5) NOT NULL Military Rank

    Prompt Table: MIL_RANK_TBL

    133 JOB_SUB_FUNC Character(3) VARCHAR2(3) NOT NULL Job sub Function

    Prompt Table: JOB_SUB_FNC_VW

    134 DESCRLONG Long Character CLOB Long Description
    135 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    136 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    137 KEY_JOBCODE Character(1) VARCHAR2(1) NOT NULL Key Job Code
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N