JOBCOMP_TMP_MC

(SQL Table)
 Index Back

Temp Job for Mass Changes

JOB is one of the core records in the database. Use it to record an employee's job history data such as actions taken, department, job code, location, and salary history. You can create multiple JOB records for an employee.

  • Parent record: PER_ORG_ASGN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition
    2 MC_STATUS Character(3) VARCHAR2(3) NOT NULL Mass Change Status
    APR=Approved Transaction
    CAN=Cancel Transaction
    ERR=Errored Transaction
    PND=Pending Transaction
    SCS=Successful Transaction
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    5 EFFDT Date(10) DATE Effective Date
    6 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    7 COMP_EFFSEQ Number(3,0) SMALLINT NOT NULL Compensation Eff Sequence
    8 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
    9 COMP_RATE_POINTS Number(5,0) INTEGER NOT NULL Comp Rate Points
    10 COMP_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    11 COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL Comp Percent
    12 COMP_CMP_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Compensation Frequency
    13 COMP_CURR_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    14 MANUAL_SW Character(1) VARCHAR2(1) NOT NULL Manual Switch
    15 CONVERT_COMPRT Number(19,6) DECIMAL(18,6) NOT NULL Converted Comp Rate
    16 RATE_CODE_GROUP Character(6) VARCHAR2(6) NOT NULL Rate Code Group Name
    17 COMP_CHG_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
    18 COMP_CHG_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
    19 COMP_CHG_PTS Signed Number(6,0) DECIMAL(5) NOT NULL Change Points
    20 MC_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Template ID
    21 JOB_EFFDT Date(10) DATE Job Effective Date
    22 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence
    23 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    24 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    25 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    26 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Position Data
    27 POSN_CHANGE_RECORD Character(1) VARCHAR2(1) NOT NULL Position Management Record
    28 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Pay
    Q=Retired With Pay
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Pay
    V=Terminated Pension Pay Out
    W=Short Work Break
    X=Retired-Pension Administration
    29 ACTION Character(3) VARCHAR2(3) NOT NULL Action
    30 ACTION_DT Date(10) DATE Action Date
    31 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

    32 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    33 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code
    34 JOB_ENTRY_DT Date(10) DATE Job Entry Date
    35 DEPT_ENTRY_DT Date(10) DATE Department Entry Date
    36 POSITION_ENTRY_DT Date(10) DATE Position Entry Date
    37 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=1
    2=2
    3=3
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating
    38 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    39 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time
    40 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status field
    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
    41 OFFICER_CD Character(1) VARCHAR2(1) NOT NULL Officer Code
    C=Chairman
    D=Director
    N=None
    O=Officer
    P=President
    S=Secretary
    T=Treasurer
    V=Vice President
    42 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    43 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    44 BAS_GROUP_ID Character(3) VARCHAR2(3) NOT NULL Identifies a user-defined Benefits Administration group used to facilitate benefits processing. A group can represent the entire participant population of the enterprise, or a specific group of participants. It enables you to control processing by, for example, setting up separate Open Enrollment schedules for each group. If used, a BAS Group ID is assigned to each participant in a benefit program.

    Prompt Table: BAS_GROUP_TBL

    45 ELIG_CONFIG1 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    46 ELIG_CONFIG2 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    47 ELIG_CONFIG3 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    48 ELIG_CONFIG4 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    49 ELIG_CONFIG5 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    50 ELIG_CONFIG6 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    51 ELIG_CONFIG7 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    52 ELIG_CONFIG8 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    53 ELIG_CONFIG9 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    54 BEN_STATUS Character(4) VARCHAR2(4) NOT NULL Specifies an employee's status relative to benefits, and is used to determine eligibility for benefits. Some examples of benefit status are Active, Suspended, Leave with Benefits, and Terminated.
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Benefits
    Q=Retired With Benefits
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Benefits
    55 BAS_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a benefits-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and benefits eligibility. A BAS (PeopleSoft Benefits Administration System) action may correspond to a BAS Event Class, which defines how a benefits-related event is recognized and handled. Some examples of BAS actions (and event classes) are Hire, Family Status Change, and Open Enrollment.
    56 COBRA_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.
    57 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried

    Prompt Table: PAYGRP_EMPLTYPE

    58 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule

    Prompt Table: HOLIDAY_TBL

    59 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    60 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

    Prompt Table: STDHRS_FREQ_VW

    61 EEO_CLASS Character(1) VARCHAR2(1) NOT NULL EEO Classification
    E=Exclude from Count
    N=None of the Above
    P=Production Trainee
    W=White-Collar Trainee
    62 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
    63 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: SAL_PLAN_TBL

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

    Prompt Table: SAL_GRADE_TBL

    65 GRADE_ENTRY_DT Date(10) DATE Grade Entry Date
    66 STEP Number(2,0) SMALLINT NOT NULL Step

    Prompt Table: SAL_STEP_TBL

    67 STEP_ENTRY_DT Date(10) DATE Step Entry Date
    68 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
    69 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

    Prompt Table: ACCT_CD_TBL

    70 EARNS_DIST_TYPE Character(1) VARCHAR2(1) NOT NULL Earnings Distribution Type
    A=By Amount
    H=By Hours
    N=None
    P=By Percent
    71 SALARY_MATRIX_CD Character(5) VARCHAR2(5) NOT NULL Salary Matrix Code

    Prompt Table: SAL_MATRIX_TBL

    72 RATING_SCALE Character(4) VARCHAR2(4) NOT NULL Rating Scale
    73 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

    Prompt Table: REVW_RATING_TBL

    74 REVIEW_DT Date(10) DATE Review Date
    75 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

    Prompt Table: COMP_FREQ_VW

    76 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    77 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
    78 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
    79 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
    80 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
    81 DAILY_RT Number(19,3) DECIMAL(18,3) NOT NULL Daily Rate
    82 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    83 ANNL_BENEF_BASE_RT Number(19,3) DECIMAL(18,3) NOT NULL Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.
    84 SHIFT_RT Number(19,6) DECIMAL(18,6) NOT NULL Shift Differential Rate
    85 SHIFT_FACTOR Number(5,3) DECIMAL(4,3) NOT NULL Shift Differential Factor
    86 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    87 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    88 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
    89 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
    90 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
    91 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary SetID
    92 FUNCTION_CD Character(2) VARCHAR2(2) NOT NULL Function Code
    93 HOURLY_RT_FRA Character(3) VARCHAR2(3) NOT NULL Hours Type
    94 ACCDNT_CD_FRA Character(1) VARCHAR2(1) NOT NULL Work Accident Type Code
    0=Do not Pay
    1=Building
    2=Waterproofing
    3=Floor Surface
    4=Factory Making
    5=Laboratory
    6=WorkShop
    7=Office
    95 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    96 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    97 DIRECTLY_TIPPED Character(1) VARCHAR2(1) NOT NULL Tipped
    D=Directly Tipped
    I=Indirectly Tipped
    N=Not Tipped
    98 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
    GP=Global Payroll
    NA=Payroll for North America
    OT=Other
    PI=Payroll Interface
    99 BORDER_WALKER Character(1) VARCHAR2(1) NOT NULL Cross Border Worker
    100 LUMP_SUM_PAY Character(1) VARCHAR2(1) NOT NULL Lump Sum Retro Payment

    Y/N Table Edit

    Default Value: N

    101 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    102 JOB_INDICATOR Character(1) VARCHAR2(1) NOT NULL This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
    N=Not Applicable
    P=Primary Job
    S=Secondary Job
    103 BENEFIT_SYSTEM Character(2) VARCHAR2(2) NOT NULL A flag that indicates whether the benefits for an employee are administered under PeopleSoft Benefits Administration or PeopleSoft Base Benefits.
    BA=Benefits Administration
    BN=Base Benefits
    OT=Not Managed in PeopleSoft
    104 TARIFF_GER Character(2) VARCHAR2(2) NOT NULL Tariff
    01=Metal Processing
    02=Banking
    03=Building and Civil Engineering
    04=Clothing Industry
    05=Chemical Industry
    06=Printing Industry
    07=Retail Trade
    08=Fossil Oil and Gas Extraction
    09=Glass Industry
    10=Wholesale and Foreign Trade
    11=Wood Processing
    12=Rubber Processing
    13=Ceramics
    14=Agriculture
    15=Leather Processing
    16=Public Sector
    17=Paper Industry
    18=Paper Processing
    19=Sawing Industry
    20=German Seaports
    21=Hard-Coal Mining
    22=Textile Industry
    23=Insurance
    24=Housing Industry
    25=Periodical Publishers
    26=Newspaper Publishers
    27=Tobacco Industry
    105 TARIFF_AREA_GER Character(3) VARCHAR2(3) NOT NULL Tariff Area
    106 PERFORM_GROUP_GER Character(2) VARCHAR2(2) NOT NULL Performance Group
    A1=Blue Collar Performance Grp. 1
    A2=Blue Collar Performance Grp. 2
    A3=Blue Collar Performance Grp. 3
    K1=Commercial White Collar Grp. 1
    K2=Commercial White Collar Grp. 2
    K3=Commercial White Collar Grp. 3
    K4=Commercial White Collar Grp. 4
    K5=Commerical White Collar Grp. 5
    T1=Technical White Collar Grp. 1
    T2=Technical White Collar Grp. 2
    T3=Technical White Collar Grp. 3
    T4=Technical White Collar Grp. 4
    T5=Technical White Collar Grp. 5
    107 LABOR_TYPE_GER Character(1) VARCHAR2(1) NOT NULL Labor Type
    M=Management
    N=Non-Management
    108 SPK_COMM_ID_GER Character(9) VARCHAR2(9) NOT NULL Spokesmen Committee ID
    109 VALUE_1_FRA Character(5) VARCHAR2(5) NOT NULL Value 1
    110 VALUE_2_FRA Character(5) VARCHAR2(5) NOT NULL Value 2
    111 VALUE_3_FRA Character(5) VARCHAR2(5) NOT NULL Value 3
    112 VALUE_4_FRA Character(5) VARCHAR2(5) NOT NULL Value 4
    113 VALUE_5_FRA Character(5) VARCHAR2(5) NOT NULL Value 5
    114 CTG_RATE Number(3,0) SMALLINT NOT NULL Category Rate
    115 PAID_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Paid Hours
    116 PAID_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Paid Work Period
    117 ANNL_BEN_BASE_OVRD Character(1) VARCHAR2(1) NOT NULL Annl Benefit Base Rt Override
    118 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
    119 UPDATE_PAYROLL Character(1) VARCHAR2(1) NOT NULL Update Payroll Flags
    120 UNION_FULL_PART Character(1) VARCHAR2(1) NOT NULL Union Participation
    F=Full Time
    P=Part Time
    121 UNION_POS Character(1) VARCHAR2(1) NOT NULL Union Position
    L=Leader of the union
    N=National Leader
    R=Registered
    S=Leader of S.O.C.
    122 MATRICULA_NBR Number(5,0) INTEGER NOT NULL Matricula Number
    123 SOC_SEC_RISK_CODE Character(3) VARCHAR2(3) NOT NULL Occupation Code
    124 UNION_FEE_AMOUNT Number(9,2) DECIMAL(8,2) NOT NULL Union Fee Amount
    125 UNION_FEE_START_DT Date(10) DATE Union Fee Start Date
    126 UNION_FEE_END_DT Date(10) DATE Union Fee End Date
    127 EXEMPT_JOB_LBR Character(1) VARCHAR2(1) NOT NULL Exempted
    128 EXEMPT_HOURS_MONTH Number(3,0) SMALLINT NOT NULL Exempted Hours per Month
    129 WRKS_CNCL_FUNCTION Character(1) VARCHAR2(1) NOT NULL Works Council Function
    M=Member
    P=President
    S=Secretary
    130 INTERCTR_WRKS_CNCL Character(1) VARCHAR2(1) NOT NULL InterCtr.Works Cnil Function
    1=Member 1
    2=Member 2
    3=Member 3
    131 PAY_UNION_FEE Character(1) VARCHAR2(1) NOT NULL Pay Union Fee
    132 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code
    133 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2

    Prompt Table: GVT_BARG_UNIT

    134 UNION_SENIORITY_DT Date(10) DATE Union Seniority Date
    135 ENTRY_DATE Date(10) DATE Date Entered
    136 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement
    137 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category
    138 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory
    139 EMPL_CTG_L2 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory 2
    140 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    141 GP_DFLT_ELIG_GRP Character(1) VARCHAR2(1) NOT NULL Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
    142 GP_ELIG_GRP Character(10) VARCHAR2(10) NOT NULL Eligibility Group
    143 GP_DFLT_CURRTTYP Character(1) VARCHAR2(1) NOT NULL Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
    144 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    145 GP_DFLT_EXRTDT Character(1) VARCHAR2(1) NOT NULL Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
    146 GP_ASOF_DT_EXG_RT Character(1) VARCHAR2(1) NOT NULL This field is used as a flag to determine whether to use a default exchange rate or not.
    B=Pay Period Begin Date
    E=Pay Period End Date
    P=Payment Date
    147 ADDS_TO_FTE_ACTUAL Character(1) VARCHAR2(1) NOT NULL Adds to FTE Actual Count
    148 CLASS_INDC Character(1) VARCHAR2(1) NOT NULL Classified/Unclassified Indc
    B=All
    C=Classified
    T=Temporary
    U=Unclassified
    149 ENCUMB_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Encumbrance Override
    150 FICA_STATUS_EE Character(1) VARCHAR2(1) NOT NULL FICA Status-Employee
    E=Exempt
    H=ER FICA Exmpt
    M=Medicare only
    N=Subject
    151 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
    152 PRORATE_CNT_AMT Character(1) VARCHAR2(1) NOT NULL Prorate Contract Change Amount
    C=Prorate Over Contract Period
    N=No Proration of Change Amt.
    P=Prorate over Payment Period
    153 WRKS_CNCL_ROLE_CHE Character(30) VARCHAR2(30) NOT NULL Work Council Role
    154 WORK_DAY_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Number of Hours in a Work Day
    155 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
    156 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
    157 PAID_FTE Number(8,6) DECIMAL(7,6) NOT NULL This field is si;ilqr to JOB.FTE field however it is computed with PAID_HOURS instead of STD_HOURS. It is a French specific field.
    158 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system

    Prompt Table: SUPVSR_LVL_TBL

    159 APPT_TYPE Character(1) VARCHAR2(1) NOT NULL This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers.
    0=Core Appointment
    1=Japan Kenmu Appointment
    2=French Public Sector Appt
    3=Staffing
    160 MAIN_APPT_NUM_JPN Number(3,0) SMALLINT NOT NULL Tracks the empl_rcd for the Main Appointment of this row. For a Main Appointment, this field stores the same value as the current empl_rcd, for an Additional Appointment, it stores the value of a different empl_rcd.