FLSA_EARNS_VW

(SQL View)
 Index Back

Pay Earnings by FLSA Period Vw

This record gives the view of the pay earnings record within FLSA Period instead of Pay Period.

SELECT A.COMPANY ,A.EMPLID ,A.FLSA_END_DT ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.ADDL_NBR ,A.EMPL_RCD ,B.PAYCHECK_NBR ,B.CHECK_DT ,B.PAYCHECK_STATUS ,B.PAYCHECK_OPTION ,B.PAYCHECK_ADJUST ,B.PAYCHECK_REPRINT ,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.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 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.FLSA_END_DT IS NOT NULL 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 FLSA_END_DT Date(10) DATE FLSA End Date
    4 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

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

    Prompt Table: PAY_CALENDAR

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

    Y/N Table Edit

    Default Value: N

    7 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
    8 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
    9 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
    10 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line #
    11 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    12 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
    13 CHECK_DT Date(10) DATE Check date.
    14 PAYCHECK_STATUS Character(1) VARCHAR2(1) NOT NULL Paycheck status.
    A=Adjusted
    C=Calculated
    F=Confirmed
    R=Reversed
    V=Reversing Check
    15 PAYCHECK_OPTION Character(1) VARCHAR2(1) NOT NULL Paycheck Option
    &=Check and Advice
    A=Advice
    C=Check
    M=Manual Check
    R=Check Reversal
    16 PAYCHECK_ADJUST Character(1) VARCHAR2(1) NOT NULL Paycheck Adjustment Entry
    N=Reversal
    Y=Reversal/Adjustment
    17 PAYCHECK_REPRINT Character(1) VARCHAR2(1) NOT NULL Paycheck Reprint
    18 EARNS_END_DT Date(10) DATE Earnings End Date
    19 EARNS_BEGIN_DT Date(10) DATE Earnings Begin Date
    20 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
    21 DISABLE_DIR_DEP Character(1) VARCHAR2(1) NOT NULL Disable Direct Deposit

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    23 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
    24 OK_TO_PAY Character(1) VARCHAR2(1) NOT NULL OK to Pay

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    26 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
    27 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
    28 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

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

    Prompt Table: JOBCODE_TBL

    30 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    31 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

    32 SHIFT_RT Number(19,6) DECIMAL(18,6) NOT NULL Shift Differential Rate
    33 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    34 FLSA_RT Number(19,6) DECIMAL(18,6) NOT NULL FLSA Rate
    35 RATE_USED Character(1) VARCHAR2(1) NOT NULL Rate Used
    A=Alternative Rate
    F=FLSA Rate
    H=Hourly Rate
    36 FLSA_REQUIRED Character(1) VARCHAR2(1) NOT NULL FLSA required
    N=NO FLSA REQUIRED
    Y=FLSA REQUIRED
    37 ERNCD_REG_HRS Character(3) VARCHAR2(3) NOT NULL Regular Hours Earnings Type

    Default Value: PAYGROUP_TBL.ERNCD_REG_HRS

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

    Default Value: PAYGROUP_TBL.ERNCD_OT_HRS

    39 REG_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Regular Hours
    40 OT_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Overtime Hours
    41 REG_HRLY_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL Regular Hourly Earnings
    42 OT_HRLY_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL Overtime Hourly Earnings
    43 ERNCD_REG_EARNS Character(3) VARCHAR2(3) NOT NULL Regular Earns Earnings Type

    Default Value: PAYGROUP_TBL.ERNCD_REG_EARNS

    44 REG_PAY_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Regular Hours Input
    45 REG_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Regular Salaried Earnings
    46 REG_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL Regular Earnings
    47 REG_EARN_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Regular Earnings Hours
    48 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

    49 DED_SUBSET_ID Character(3) VARCHAR2(3) NOT NULL Deduction Subset ID
    50 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TAX_DATA

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

    Prompt Table: LOCAL_TAX_DATA

    52 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

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

    Default Value: 1

    54 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

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

    Y/N Table Edit

    Default Value: Y

    56 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.
    57 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

    58 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
    59 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

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

    Y/N Table Edit

    Default Value: N

    61 COMP_RATECD_REG Character(6) VARCHAR2(6) NOT NULL Regular Comp Rate Code
    62 COMP_RATECD_OT Character(6) VARCHAR2(6) NOT NULL Overtime Comp Rate Code
    63 COMPRATE_USED_REG Number(19,6) DECIMAL(18,6) NOT NULL Comp Rate Used for Regular
    64 COMPRATE_USED_OT Number(19,6) DECIMAL(18,6) NOT NULL Comp Rate Used for Overtime
    65 FICA_STATUS_EE Character(1) VARCHAR2(1) NOT NULL FICA Status-Employee
    E=Exempt
    H=ER FICA Exmpt
    M=Medicare only
    N=Subject
    66 PAID_PRDS_PER_YEAR Number(6,2) DECIMAL(5,2) NOT NULL Annual Tax Periods