PAY_EARNINGS_V

(SQL View)
 Index Back

Pay Check Earnings View

This record gives the view of the pay earnings record.

SELECT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.ADDL_NBR ,A.EMPLID ,A.EMPL_RCD ,A.EARNS_END_DT ,A.EARNS_BEGIN_DT ,A.ADDLPAY_REASON ,A.DISABLE_DIR_DEP ,A.GROSSUP ,A.PAY_LINE_STATUS ,A.OK_TO_PAY ,A.JOB_PAY ,A.ACCT_CD ,A.GL_PAY_TYPE ,A.DEPTID ,A.JOBCODE ,A.POSITION_NBR ,A.SHIFT ,A.SHIFT_RT ,A.HOURLY_RT ,A.FLSA_RT ,A.RATE_USED ,A.FLSA_REQUIRED ,A.ERNCD_REG_HRS ,A.ERNCD_OT_HRS ,A.REG_HRS ,A.OT_HRS ,A.REG_HRLY_EARNS ,A.OT_HRLY_EARNS ,A.ERNCD_REG_EARNS ,A.REG_PAY_HRS ,A.REG_PAY ,A.REG_EARNS ,A.REG_EARN_HRS ,A.DED_TAKEN ,A.DED_SUBSET_ID ,A.DED_TAKEN_GENL ,A.DED_SUBSET_GENL ,A.STATE ,A.LOCALITY ,A.PAY_FREQUENCY ,A.TAX_PERIODS ,A.TAX_METHOD ,A.ADDL_TAXES ,A.BENEFIT_RCD_NBR ,A.SINGLE_CHECK_USE ,A.PAY_SHEET_SRC ,A.BUSINESS_UNIT ,A.EI_PRIOR_PD_CORR ,A.COMP_RATECD_REG ,A.COMP_RATECD_OT ,A.COMPRATE_USED_REG ,A.COMPRATE_USED_OT ,A.FICA_STATUS_EE ,A.PAID_PRDS_PER_YEAR ,A.ORIG_PAYGROUP FROM PS_PAY_EARNINGS A ,PS_PAY_CHECK B WHERE A.COMPANY=B.COMPANY AND A.PAYGROUP=B.PAYGROUP AND A.PAY_END_DT=B.PAY_END_DT AND A.OFF_CYCLE=B.OFF_CYCLE AND A.PAGE_NUM=B.PAGE_NUM AND A.LINE_NUM=B.LINE_NUM AND A.SEPCHK=B.SEPCHK AND A.OK_TO_PAY='Y'

  • Parent record: PAY_CHECK

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

    Prompt Table: COMPANY_TBL

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

    Prompt Table: PAYGROUP_TBL

    3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    Default Value: N

    5 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
    6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
    7 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
    8 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line #
    9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    10 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    11 EARNS_END_DT Date(10) DATE Earnings End Date
    12 EARNS_BEGIN_DT Date(10) DATE Earnings Begin Date
    13 ADDLPAY_REASON Character(3) VARCHAR2(3) NOT NULL Reason for Additional Pay
    A=Anniversary Award
    AWD=Award Data
    BAS=Benefits Administration Credit
    C=Contract Pay
    JOB=Job Other Pay
    N=Not Specified
    O=Outstanding Contribution
    P=Performance Award
    Q=President's Award
    S=Productivity Award
    14 DISABLE_DIR_DEP Character(1) VARCHAR2(1) NOT NULL Disable Direct Deposit

    Y/N Table Edit

    Default Value: N

    15 GROSSUP Character(1) VARCHAR2(1) NOT NULL Gross-Up

    Y/N Table Edit

    Default Value: N

    16 PAY_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Payline Calculation Status
    C=Calculated
    E=Calculation Error
    F=Confirmed
    I=Initial Load
    P=Pay in Progress
    U=Updated by User
    V=Reversing Check
    17 OK_TO_PAY Character(1) VARCHAR2(1) NOT NULL OK to Pay

    Y/N Table Edit

    Default Value: N

    18 JOB_PAY Character(1) VARCHAR2(1) NOT NULL Job Pay

    Y/N Table Edit

    Default Value: N

    19 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
    20 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
    21 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

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

    Prompt Table: JOBCODE_TBL

    23 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    24 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=1
    2=2
    3=3
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating

    Default Value: N

    25 SHIFT_RT Number(19,6) DECIMAL(18,6) NOT NULL Shift Differential Rate
    26 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    27 FLSA_RT Number(19,6) DECIMAL(18,6) NOT NULL FLSA Rate
    28 RATE_USED Character(1) VARCHAR2(1) NOT NULL Rate Used
    A=Alternative Rate
    F=FLSA Rate
    H=Hourly Rate
    29 FLSA_REQUIRED Character(1) VARCHAR2(1) NOT NULL FLSA required
    N=NO FLSA REQUIRED
    Y=FLSA REQUIRED
    30 ERNCD_REG_HRS Character(3) VARCHAR2(3) NOT NULL Regular Hours Earnings Type

    Default Value: PAYGROUP_TBL.ERNCD_REG_HRS

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

    Default Value: PAYGROUP_TBL.ERNCD_OT_HRS

    32 REG_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Regular Hours
    33 OT_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Overtime Hours
    34 REG_HRLY_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL Regular Hourly Earnings
    35 OT_HRLY_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL Overtime Hourly Earnings
    36 ERNCD_REG_EARNS Character(3) VARCHAR2(3) NOT NULL Regular Earns Earnings Type

    Default Value: PAYGROUP_TBL.ERNCD_REG_EARNS

    37 REG_PAY_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Regular Hours Input
    38 REG_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Regular Salaried Earnings
    39 REG_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL Regular Earnings
    40 REG_EARN_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Regular Earnings Hours
    41 DED_TAKEN Character(1) VARCHAR2(1) NOT NULL Deductions Taken
    D=Deduction Table Governs
    N=None
    R=No Override
    S=Deduction Table Subset Governs

    Default Value: D

    42 DED_SUBSET_ID Character(3) VARCHAR2(3) NOT NULL Deduction Subset ID
    43 DED_TAKEN_GENL Character(1) VARCHAR2(1) NOT NULL General Deductions Taken
    D=Deduction Table Governs
    N=None
    R=No Override
    S=Deduction Table Subset Governs

    Default Value: D

    44 DED_SUBSET_GENL Character(3) VARCHAR2(3) NOT NULL General Ded Subset ID
    45 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TAX_DATA

    46 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

    Prompt Table: LOCAL_TAX_DATA

    47 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: PAYGROUP_TBL.PAY_FREQUENCY

    Prompt Table: FREQUENCY_TBL

    48 TAX_PERIODS Number(2,0) SMALLINT NOT NULL Tax Periods

    Default Value: 1

    49 TAX_METHOD Character(1) VARCHAR2(1) NOT NULL Tax method.
    A=Annualized
    B=Bonus
    C=Cumulative
    G=Aggregate
    L=Lump Sum
    M=Commission
    P=Specified on Paysheet
    S=Supplemental
    X=Special Supplemental

    Default Value: A

    50 ADDL_TAXES Character(1) VARCHAR2(1) NOT NULL Additional Taxes

    Y/N Table Edit

    Default Value: Y

    51 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
    52 SINGLE_CHECK_USE Character(1) VARCHAR2(1) NOT NULL How is Single Check Used
    C=Check Only
    N=Not Applicable
    P=Paysheet Only

    Default Value: N

    53 PAY_SHEET_SRC Character(1) VARCHAR2(1) NOT NULL Source of Paysheet
    F=FLSA Paysheet
    K=Batch Final Check
    L=Online Final Check
    O=On-line Paysheet
    P=Paysheet Load
    S=Regular Paysheet
    54 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    55 EI_PRIOR_PD_CORR Character(1) VARCHAR2(1) NOT NULL EI Prior Period Correction

    Y/N Table Edit

    Default Value: N

    56 COMP_RATECD_REG Character(6) VARCHAR2(6) NOT NULL Regular Comp Rate Code
    57 COMP_RATECD_OT Character(6) VARCHAR2(6) NOT NULL Overtime Comp Rate Code
    58 COMPRATE_USED_REG Number(19,6) DECIMAL(18,6) NOT NULL Comp Rate Used for Regular
    59 COMPRATE_USED_OT Number(19,6) DECIMAL(18,6) NOT NULL Comp Rate Used for Overtime
    60 FICA_STATUS_EE Character(1) VARCHAR2(1) NOT NULL FICA Status-Employee
    E=Exempt
    H=ER FICA Exmpt
    M=Medicare only
    N=Subject
    61 PAID_PRDS_PER_YEAR Number(6,2) DECIMAL(5,2) NOT NULL Annual Tax Periods
    62 ORIG_PAYGROUP Character(3) VARCHAR2(3) NOT NULL Original Paygroup