CHECK_YTD

(SQL Table)
 Index Back

EE U.S. YTD Check Total

This record is used to store employee Gross, Deduction, Tax and Net Pay Year-to-Date balances.

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    3 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID

    Prompt Table: BALANCE_ID_TBL

    4 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year

    Prompt Table: BALANCE_YR_VW

    5 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter

    Prompt Table: BALANCE_ID_QTR

    6 BALANCE_PERIOD Number(3,0) SMALLINT NOT NULL Balances for Period

    Prompt Table: BALANCE_ID_DEF

    7 TOTAL_GROSS_YTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Total Gross YTD
    8 TOTAL_TAXES_YTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Total Taxes YTD
    9 TOTAL_DEDNS_YTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Total Deductions YTD
    10 NET_PAY_YTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Net Pay YTD