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

  • Parent Record Of PAYGRP_EMPLTYPE

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

    Default Value: OPR_DEF_TBL_HR.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

    Prompt Table: STD_FREQ_TBL_VW

    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_HR.COUNTRY

    Prompt Table: COUNTRY_TBL

    10 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

    Prompt Table: SRC_BANK

    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 Nbr
    16 ROE_ISSUER_ID Character(11) VARCHAR2(11) NOT NULL ROE Issuer ID

    Prompt Table: PERSON_NAME

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

    Prompt Table: PERSON_NAME

    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 Options Page
    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=Check Address
    E=Select on Payroll Options Page
    H=Home Address
    M=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 Options Page
    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

    Default Value: NYYYYYN

    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

    Default Value: REG

    Prompt Table: ERN_PROGRAM_DEF

    45 ERNCD_OT_HRS Character(3) VARCHAR2(3) NOT NULL OT Hours Earnings Type

    Default Value: OTP

    Prompt Table: ERN_PROGRAM_DEF

    46 ERNCD_REG_EARNS Character(3) VARCHAR2(3) NOT NULL Regular Earns Earnings Type

    Default Value: REG

    Prompt Table: ERN_PROGRAM_DEF

    47 ERNCD_HOLIDAY Character(3) VARCHAR2(3) NOT NULL Holiday (Statutory) Earn Type

    Default Value: HOL

    Prompt Table: ERN_PROGRAM_DEF

    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

    Prompt Table: RETROPAYPGM_TBL

    51 RETRO_TRG_PGM_ID Character(3) VARCHAR2(3) NOT NULL This field will define the Retroactive Program ID.

    Prompt Table: PY_RETROTRG_DEF

    52 FLSA_REQUIRED Character(1) VARCHAR2(1) NOT NULL FLSA required
    N=NO FLSA REQUIRED
    Y=FLSA REQUIRED

    Y/N Table Edit

    Default Value: COMPANY_TBL.FLSA_REQUIRED

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

    Prompt Table: ERN_PROGRAM_DEF

    54 PI_CONFIG_ID Character(6) VARCHAR2(6) NOT NULL PI Configuration ID

    Prompt Table: PI_CONFIG_TBL

    55 DEFAULT_SETID Character(5) VARCHAR2(5) NOT NULL Default Set ID

    Default Value: PAYGROUP_TBL.PAYGROUP

    Prompt Table: SET_SHFT_VLD_VW

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

    Y/N Table Edit

    Default Value: N

    57 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

    58 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: COUNTRY_CUR_VW

    59 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

    60 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

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

    Y/N Table Edit

    Default Value: COMPANY_TBL.TIPS_DELAY_WTHLD

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

    Y/N Table Edit

    Default Value: COMPANY_TBL.TIPS_ADJUST

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

    Default Value: COMPANY_TBL.ERNCD_TIPS_ADJUST

    Prompt Table: EARNINGS_TBL

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

    Default Value: COMPANY_TBL.ERNCD_TIPS_CRED

    Prompt Table: EARNINGS_TBL

    65 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

    66 TERM_PGM_ID Character(3) VARCHAR2(3) NOT NULL Final Check Program ID

    Prompt Table: TERM_PGM_TBL

    67 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
    68 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan

    Prompt Table: WAGELS_PLAN_TBL

    69 ERNCD_1042_EARNS Character(3) VARCHAR2(3) NOT NULL 1042 Earn Code

    Prompt Table: ERN_PROGRAM_DEF

    70 ERNCD_ERN_NOT_PD Character(3) VARCHAR2(3) NOT NULL Earned and Not Paid Erncd

    Default Value: ENP

    Prompt Table: ERN_PROGRAM_DEF

    71 ERNCD_PD_NOT_ERN Character(3) VARCHAR2(3) NOT NULL Paid Not Earned Erncd

    Default Value: PNE

    Prompt Table: ERN_PROGRAM_DEF

    72 ERNCD_CNTRCT_REG Character(3) VARCHAR2(3) NOT NULL Contract Regular Earnings

    Default Value: CRG

    Prompt Table: ERN_PROGRAM_DEF

    73 STDNT_FIN_PAYGROUP Character(1) VARCHAR2(1) NOT NULL Student Fin Paygroup

    Y/N Table Edit

    Default Value: N

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

    Default Value: CORE

    75 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

    76 FLSA_PERIOD_TYPE Character(2) VARCHAR2(2) NOT NULL FLSA Period Definition

    Default Value: 00

    Prompt Table: FLSA_PERIOD_TYP

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

    Prompt Table: %EDITTABLE

    78 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

    79 FREQ_ID_MONTHLY Character(5) VARCHAR2(5) NOT NULL Monthly Frequency

    Default Value: M

    Prompt Table: MTH_FREQ_TBL_VW

    80 FREQ_ID_DAILY Character(5) VARCHAR2(5) NOT NULL Daily Frequency

    Default Value: D

    Prompt Table: DAY_FREQ_TBL_VW

    81 DED_PRIORITY Number(3,0) SMALLINT NOT NULL Deduction Priority
    82 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan

    Prompt Table: GVT_PAY_PLAN

    83 GVT_ERNCD_NONPAY Character(3) VARCHAR2(3) NOT NULL Nonpaid Hours

    Prompt Table: ERN_PROG_DESCR

    84 GVT_ERNCD_REFUND Character(3) VARCHAR2(3) NOT NULL Refund Earnings Code

    Prompt Table: ERN_PROG_DESCR

    85 GVT_ERNCD_INTEREST Character(3) VARCHAR2(3) NOT NULL Interest Earnings Code

    Prompt Table: ERN_PROG_DESCR

    86 DD_SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Some banks require a single employer to use two different bank transit numbers for one bank account - one transit number for their direct deposit transactions and another transit number for their printed checks. Added DD_SRC_BANK_ID to the PAYGROUP_TBL record to allow for a different Bank ID to be used as the transit number for direct deposits. If the field are left blank, then the system will assume that the user wants to use the SRC_BANK_ID for both checks and direct deposits. This new field will be added to Paygroup Table 8.

    Prompt Table: SRC_BANK

    87 MIN_WAGE_JUR Character(1) VARCHAR2(1) NOT NULL Field used for enabling Minimum Wage Jurisdiction feature
    N=No
    Y=Yes

    Default Value: N