PAYGROUP_TBL

(SQL Table)
 Index Back

Paygroups

Use PAYGROUP_TBL to group employees by how they are paid. For example, if your company has both salaried and hourly employees, you might set up a monthly paygroup for the salaried employees paid once a month, and another paygroup for hourly employees paid weekly. Use a subordinate record, PAYGRP_EMPLTYPE, to identify the valid employee types for each paygroup.

  • Related Language Record: PAYGROUP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Default Value: OPR_DEF_TBL_FO.COMPANY

    Prompt Table: COMPANY_TBL

    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    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 PAY_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Pay Frequency
    A=Annual
    B=Biweekly
    D=Daily
    M=Monthly
    Q=Quarterly
    S=Semimonthly
    W=Weekly

    Default Value: M

    8 RETIREE_PAYGROUP Character(1) VARCHAR2(1) NOT NULL Retiree Pay Group

    Y/N Table Edit

    Default Value: N

    9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: OPR_DEF_TBL_FS.LC_CNTRY

    Prompt Table: COUNTRY_TBL

    10 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
    11 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried

    Default Value: H

    12 NET_PAY_MINIMUM Number(4,0) SMALLINT NOT NULL Minimum Net Pay
    13 NET_PAY_MAXIMUM Number(8,0) INTEGER NOT NULL Maximum Net Pay

    Default Value: 10000

    14 AUTO_OVERTIME Number(5,2) DECIMAL(4,2) NOT NULL Automatic Overtime
    15 PAY_REF_NBR Character(8) VARCHAR2(8) NOT NULL Payroll Reference #
    16 ROE_ISSUER_ID Character(11) VARCHAR2(11) NOT NULL ROE Issuer ID

    Prompt Table: PERSONAL_DATA

    17 ROE_CONTACT_ID Character(11) VARCHAR2(11) NOT NULL ROE Contact ID

    Prompt Table: PERSONAL_DATA

    18 PAY_RPT_SEQ Character(1) VARCHAR2(1) NOT NULL Payroll Report Sequence
    1=Dept, Employee Type, Employee
    2=Dept, Employee
    3=Employee Only
    4=Employee Type, Dept, Employee
    5=Employee Type, Employee

    Default Value: 1

    19 PAY_RPT_SUBTOTALS Character(1) VARCHAR2(1) NOT NULL Payroll Report Subtotals
    A=Break After Subtotals
    B=Break Before and After Subttls
    N=No Subtotals

    Default Value: A

    20 PAY_RPT_EMPL_SEQ Character(1) VARCHAR2(1) NOT NULL Payroll Rpt Employee Sequence
    E=Employee ID Sequence
    N=Employee Name Sequence

    Default Value: N

    21 PAYCHECK_SEQ Character(1) VARCHAR2(1) NOT NULL Paycheck Sequence
    E=Select on Payroll Data Panel
    I=Company Distribution Order
    P=Paysheet Order
    X=Postal Code Order

    Default Value: P

    22 PAYCHECK_ADDR_OPTN Character(1) VARCHAR2(1) NOT NULL Paycheck Address Option
    1=Home Address
    2=Mailing Address
    3=Check Address
    C=Mail to Check Address
    E=Select on Payroll Data Panel
    H=Mail to Home Address
    M=Mail to Mailing Address

    Default Value: H

    23 PAYCHECK_LOCN_OPTN Character(1) VARCHAR2(1) NOT NULL Location Option
    D=Home Department Location
    E=Select on Payroll Data Panel
    J=Job Location
    O=Other Location

    Default Value: D

    24 PAYCHECK_EMPL_SEQ Character(1) VARCHAR2(1) NOT NULL Paycheck Employee Sequence
    E=Employee ID Sequence
    N=Employee Name Sequence

    Default Value: N

    25 PAYCHECK_SEQ_FLD01 Character(1) VARCHAR2(1) NOT NULL Check Print Sequence 01
    D=Department ID
    E=Employee ID or Name
    F=FLSA Status
    L=Location
    M=Mail Drop
    S=Shift
    T=Employee Type
    U=Supervisor ID
    26 PAYCHECK_SEQ_FLD02 Character(1) VARCHAR2(1) NOT NULL Check Print Sequence 02
    D=Department ID
    E=Employee ID or Name
    F=FLSA Status
    L=Location
    M=Mail Drop
    S=Shift
    T=Employee Type
    U=Supervisor ID
    27 PAYCHECK_SEQ_FLD03 Character(1) VARCHAR2(1) NOT NULL Check Print Sequence 03
    D=Department ID
    E=Employee ID or Name
    F=FLSA Status
    L=Location
    M=Mail Drop
    S=Shift
    T=Employee Type
    U=Supervisor ID
    28 PAYCHECK_SEQ_FLD04 Character(1) VARCHAR2(1) NOT NULL Check Print Sequence 04
    D=Department Id
    E=Employee ID or Name
    F=FLSA Status
    L=Location
    M=Mail Drop
    S=Shift
    T=Employee Type
    U=Supervisor ID
    29 PAYCHECK_SEQ_FLD05 Character(1) VARCHAR2(1) NOT NULL Check Print Sequence 05
    D=Department ID
    E=Employee ID or Name
    F=FLSA Status
    L=Location
    M=Mail Drop
    S=Shift
    T=Employee Type
    U=Supervisor ID
    30 PAYCHECK_SEQ_FLD06 Character(1) VARCHAR2(1) NOT NULL Check Print Sequence 06
    D=Department ID
    E=Employee ID or Name
    F=FLSA Status
    L=Location
    M=Mail Drop
    S=Shift
    T=Employee Type
    U=Supervisor ID
    31 PAYCHECK_SEQ_FLD07 Character(1) VARCHAR2(1) NOT NULL Check Print Sequence 07
    D=Department ID
    E=Employee ID or Name
    F=FLSA Status
    L=Location
    M=Mail Drop
    S=Shift
    T=Employee Type
    U=Supervisor ID
    32 PAYCHECK_SEQ_FLD08 Character(1) VARCHAR2(1) NOT NULL Check Print Sequence 08
    D=Department ID
    E=Employee ID or Name
    F=FLSA Status
    L=Location
    M=Mail Drop
    S=Shift
    T=Employee Type
    U=Supervisor ID
    33 PAYCHECK_SEQ_FLD09 Character(1) VARCHAR2(1) NOT NULL Check Print Sequence 09
    D=Department ID
    E=Employee ID or Name
    F=FLSA Status
    L=Location
    M=Mail Drop
    S=Shift
    T=Employee Type
    U=Supervisor ID
    34 PAYCHECK_SEQ_FLD10 Character(1) VARCHAR2(1) NOT NULL Check Print Sequence 10
    D=Department ID
    E=Employee ID or Name
    F=FLSA Status
    L=Location
    M=Mail Drop
    S=Shift
    T=Employee Type
    U=Supervisor ID
    35 OASDI_EARNS_BREAK Number(7,2) DECIMAL(6,2) NOT NULL Earnings Break Point
    36 OASDI_LOW_FACTOR Number(5,4) DECIMAL(4,4) NOT NULL Factor for Low Earnings
    37 OASDI_HIGH_EXEMPT Number(7,2) DECIMAL(6,2) NOT NULL Exemption for High Earnings
    38 PRORATE_SALARIED Character(1) VARCHAR2(1) NOT NULL Salaried Proration Rule
    A=Percent of Annual
    P=Percent of Period
    W=Rate per Work Day

    Default Value: A

    39 PRORATE_HRLY Character(1) VARCHAR2(1) NOT NULL Hourly Proration Rule
    P=Percent of Period
    W=Work Days

    Default Value: W

    40 AUTO_PAYSHEET_UPD Character(1) VARCHAR2(1) NOT NULL Automatic Paysheet Update

    Y/N Table Edit

    Default Value: Y

    41 WORK_SCHEDULE Character(7) VARCHAR2(7) NOT NULL Work Schedule
    42 DFLT_BEN_PROGRAM Character(3) VARCHAR2(3) NOT NULL Default Benefit Program

    Prompt Table: BEN_DEFN_PGM

    43 ERN_PROGRAM Character(3) VARCHAR2(3) NOT NULL Earnings Program ID

    Default Value: COMPANY_TBL.DFLT_ERN_PROGRAM

    Prompt Table: %RECNAME_EDIT

    44 ERNCD_REG_HRS Character(3) VARCHAR2(3) NOT NULL Regular Hours Earnings Type
    45 ERNCD_OT_HRS Character(3) VARCHAR2(3) NOT NULL OT Hours Earnings Type
    46 ERNCD_REG_EARNS Character(3) VARCHAR2(3) NOT NULL Regular Earns Earnings Type
    47 ERNCD_HOLIDAY Character(3) VARCHAR2(3) NOT NULL Holiday (Statutory) Earn Type
    48 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_REGION_TBL

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

    Prompt Table: HOLIDAY_TBL

    50 RETROPAY_PGM_ID Character(3) VARCHAR2(3) NOT NULL Retro Pay Program ID
    51 FLSA_REQUIRED Character(1) VARCHAR2(1) NOT NULL FLSA required
    N=NO FLSA REQUIRED
    Y=FLSA REQUIRED

    Y/N Table Edit

    Default Value: N

    52 ERNCD_HOL_NONSTAT Character(3) VARCHAR2(3) NOT NULL Canadian Non-Stat Holiday

    Prompt Table: ERN_PROGRAM_DEF

    53 PI_CONFIG_ID Character(6) VARCHAR2(6) NOT NULL PI Configuration ID
    54 DEFAULT_SETID Character(5) VARCHAR2(5) NOT NULL Default SetID

    Default Value: PAYGROUP_TBL.PAYGROUP

    55 CONFIRM_ERRORS Character(1) VARCHAR2(1) NOT NULL Continue With Errors

    Y/N Table Edit

    Default Value: N

    56 ERR_PED_OPTION Character(1) VARCHAR2(1) NOT NULL Error Pay End Dt Option
    D=Next Day
    N=None Chosen
    S=Same Day

    Default Value: N

    57 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    58 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

    Default Value: INSTALLATION.EXCHNG_TO_RT_TYPE

    Prompt Table: RT_TYPE_TBL

    59 RT_CONV_DT Character(1) VARCHAR2(1) NOT NULL Rate Conversion Date
    C=Check Date
    P=Pay End Date
    T=Today's Date

    Default Value: C

    60 TIPS_DELAY_WTHLD Character(1) VARCHAR2(1) NOT NULL Delay Withholding of Taxes

    Y/N Table Edit

    Default Value: N

    61 TIPS_ADJUST Character(1) VARCHAR2(1) NOT NULL Adjust to Minimum Wage

    Y/N Table Edit

    62 ERNCD_TIPS_ADJUST Character(3) VARCHAR2(3) NOT NULL Min Wage Adjustment Earns Code

    Prompt Table: EARNINGS_TBL

    63 ERNCD_TIPS_CRED Character(3) VARCHAR2(3) NOT NULL Tip Credit Earnings Code

    Prompt Table: EARNINGS_TBL

    64 FLSA_SAL_HRS_USE Character(1) VARCHAR2(1) NOT NULL FLSA Salaried Hours Used
    F=Fixed Salaried Hours
    U=Unspecified Salaried Hours

    Default Value: U

    65 TERM_PGM_ID Character(3) VARCHAR2(3) NOT NULL Final Check Program ID
    66 CAO_NLD Character(3) VARCHAR2(3) NOT NULL The CAO field is specified by Pay Group for HR Netherlands.
    DET=CAO Retail Trade
    HOU=CAO Wood Industry
    MED=CAO Medical Staff
    MET=CAO Metal Industry
    VER=CAO Transportation Industry
    67 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan
    68 ERNCD_1042_EARNS Character(3) VARCHAR2(3) NOT NULL 1042 Earn Code
    69 ERNCD_ERN_NOT_PD Character(3) VARCHAR2(3) NOT NULL Earned and Not Paid Erncd
    70 ERNCD_PD_NOT_ERN Character(3) VARCHAR2(3) NOT NULL Paid Not Earned Erncd
    71 ERNCD_CNTRCT_REG Character(3) VARCHAR2(3) NOT NULL Contract Regular Earnings
    72 STDNT_FIN_PAYGROUP Character(1) VARCHAR2(1) NOT NULL Student Fin Paygroup

    Y/N Table Edit

    Default Value: N

    73 INDUSTRY_SECTOR Character(4) VARCHAR2(4) NOT NULL Industry Sector
    CORE=Core
    PBSC=Public Sector
    USFG=US Federal Government

    Default Value: CORE

    74 INDUSTRY Character(4) VARCHAR2(4) NOT NULL Industry
    CORE=Core
    EDUC=Education
    FNSV=Financial Services
    GOVT=Government
    HLTH=Health Care
    RETL=Retail
    TRAN=Transportation
    UTIL=Utilities

    Default Value: CORE

    75 FLSA_PERIOD_TYPE Character(2) VARCHAR2(2) NOT NULL FLSA Period Definition
    00=Fixed FLSA Period
    01=Fire Protection
    02=Law Enforcement

    Default Value: 00

    76 FLSA_CALENDAR_ID Character(10) VARCHAR2(10) NOT NULL FLSA Calendar ID

    Prompt Table: %EDITTABLE

    77 FLSA_BASIC_FORMULA Character(2) VARCHAR2(2) NOT NULL Use Basic Formula
    N=Do Not Use Basic Formula
    Y=Use Basic Formula

    Default Value: N

    78 FREQ_ID_MONTHLY Character(5) VARCHAR2(5) NOT NULL Monthly Frequency
    79 FREQ_ID_DAILY Character(5) VARCHAR2(5) NOT NULL Daily Frequency
    80 DED_PRIORITY Number(3,0) SMALLINT NOT NULL Deduction Priority
    81 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan