MODEL_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 PY_MOD_OPRID Character(30) VARCHAR2(30) NOT NULL PayCheck Modeler User Id
    2 PY_MOD_EMPLID Character(11) VARCHAR2(11) NOT NULL PayCheck Modeler Employee ID
    3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    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: Y

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

    Prompt Table: PAY_PAGE

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

    Prompt Table: PAY_LINE

    9 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    10 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification

    Prompt Table: PAY_FORM_TBL

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    29 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

    30 PAYCHECK_NAME Character(50) VARCHAR2(50) NOT NULL Paycheck Name
    31 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

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

    Y/N Table Edit

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

    Default Value: PER_ORG_ASGN_VW.EMPL_RCD

    52 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

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

    Default Value: JOB.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_HR

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    66 UPDATE_DT Date(10) DATE Last Updated