PAY_CHECK_REVVW

(SQL View)
 Index Back

Reversable Check View

This record is used to store detail information on checks available for reversal.

SELECT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.FORM_ID ,A.PAYCHECK_NBR ,A.EMPLID ,A.EMPL_RCD ,A.NAME ,A.DEPTID ,A.EMPL_TYPE ,A.SSN ,A.SIN ,A.TOTAL_GROSS ,A.TOTAL_TAXES ,A.TOTAL_DEDUCTIONS ,A.NET_PAY ,A.CHECK_DT ,A.PAYCHECK_STATUS ,A.PAYCHECK_OPTION ,A.PAYCHECK_ADJUST ,A.PAYCHECK_REPRINT ,A.PAYCHECK_CASHED ,A.PAYCHECK_ADDR_OPTN ,A.PAYCHECK_NAME ,A.ADDRESS1 ,A.ADDRESS2 ,A.ADDRESS3 ,A.ADDRESS4 ,A.CITY ,A.COUNTY ,A.STATE ,A.POSTAL ,A.COUNTRY ,A.LOCATION ,A.BENEFIT_RCD_NBR ,A.PAY_SHEET_SRC ,A.BUSINESS_UNIT FROM PS_PAY_CHECK A WHERE A.PAYCHECK_STATUS IN ('F','A') AND A.PAYCHECK_OPTION<>'R'

  • Parent record: PAY_LINE

    • # 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

    5 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr

    Prompt Table: PAY_PAGE

    6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr

    Prompt Table: PAY_LINE

    7 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    8 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
    9 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
    10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    11 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    12 NAME Character(50) VARCHAR2(50) NOT NULL Name
    13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    14 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried
    15 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    16 SIN Character(9) VARCHAR2(9) NOT NULL Social Insurance Nbr
    17 TOTAL_GROSS Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Gross
    18 TOTAL_TAXES Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Taxes
    19 TOTAL_DEDUCTIONS Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Deductions
    20 NET_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Net Pay
    21 CHECK_DT Date(10) DATE Check date.
    22 PAYCHECK_STATUS Character(1) VARCHAR2(1) NOT NULL Paycheck status.
    A=Adjusted
    C=Calculated
    F=Confirmed
    R=Reversed
    V=Reversing Check
    23 PAYCHECK_OPTION Character(1) VARCHAR2(1) NOT NULL Paycheck Option
    &=Check and Advice
    A=Advice
    C=Check
    M=Manual Check
    R=Check Reversal
    24 PAYCHECK_ADJUST Character(1) VARCHAR2(1) NOT NULL Paycheck Adjustment Entry
    N=Reversal
    Y=Reversal/Adjustment

    Y/N Table Edit

    25 PAYCHECK_REPRINT Character(1) VARCHAR2(1) NOT NULL Paycheck Reprint

    Y/N Table Edit

    26 PAYCHECK_CASHED Character(1) VARCHAR2(1) NOT NULL Paycheck Cashed

    Y/N Table Edit

    27 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
    28 PAYCHECK_NAME Character(50) VARCHAR2(50) NOT NULL Paycheck Name
    29 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    30 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    31 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    32 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    33 CITY Character(30) VARCHAR2(30) NOT NULL City
    34 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    35 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    36 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    37 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    38 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    39 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.

    Default Value: PER_ORG_ASGN_VW.EMPL_RCD

    40 PAY_SHEET_SRC Character(1) VARCHAR2(1) NOT NULL Source of Paysheet
    B=Flat Sum Bonus Calculation
    F=FLSA Paysheet
    K=Batch Final Check
    L=Online Final Check
    O=On-line Paysheet
    P=Paysheet Load
    S=Regular Paysheet
    41 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR