MOD_PAY_CHECK

(SQL Table)
 Index Back

Pay Check

This is the summary record that contains the result of the payroll confirmation process.

  • 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

    Default Value: Y

    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

    Prompt Table: PAY_FORM_TBL

    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

    Default Value: H

    28 PAYCHECK_NAME Character(50) VARCHAR2(50) NOT NULL Paycheck Name
    29 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    30 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    31 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    32 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    33 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    34 CITY Character(30) VARCHAR2(30) NOT NULL City
    35 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    36 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    37 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    38 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    39 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    40 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    41 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    42 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    43 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    44 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    45 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    46 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    47 PAYCHECK_DIST_KEY1 Character(90) VARCHAR2(90) NOT NULL Paycheck Sort Key 1
    48 PAYCHECK_DIST_KEY2 Character(90) VARCHAR2(90) NOT NULL Paycheck Sort Key 2
    49 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

    50 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

    Default Value: S

    51 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: JOB.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_HR

    52 GVT_SCHEDULE_NO Character(14) VARCHAR2(14) NOT NULL Schedule Number
    53 GVT_PAY_ID_LINE_1 Character(40) VARCHAR2(40) NOT NULL Payment ID Line 1
    54 GVT_PAY_ID_LINE_2 Character(40) VARCHAR2(40) NOT NULL Payment ID Line 2
    55 GVT_ECS_LTD_INDIC Character(1) VARCHAR2(1) NOT NULL LTD Pay Indicator
    56 GVT_ECS_OFF_ACCT Character(16) VARCHAR2(16) NOT NULL Account Symbol
    57 GVT_RITS_DT Date(10) DATE Track processing date of Occ Cycle RITS deductions
    58 GVT_TSP_SEQ_YR Number(2,0) SMALLINT NOT NULL TSP Voucher Number
    59 GVT_TSP_SEQ_NO Number(4,0) SMALLINT NOT NULL Voucher Seq Nbr
    60 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
    61 HP_CORRECT_STATUS Character(1) VARCHAR2(1) NOT NULL Check Corrected Status

    Y/N Table Edit

    Default Value: N

    62 HP_CORRECTED_DT Date(10) DATE Check correction date. Checks are only corrected by retroactive distribution process
    63 HR_WP_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL HR Wage Progression Processed Flag

    Y/N Table Edit

    Default Value: N

    64 UPDATE_DT Date(10) DATE Last Updated