HP_PAYCHKCTX_SP

(SQL View)
 Index Back

CAN Tax to Suspense Account

This provides an insight into Canadian Taxes that were distributed to suspense accounts

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.PROVINCE , A.TAX_CLASS_CAN , A.WAGE_LOSS_PLAN , A.NLGRS_CUR , A.TXGRS_CUR , A.TAX_CUR , A.TAX_NOT_TAKEN , A.UI_ER_RT , A.AP_STATUS FROM PS_PAY_TAX_CAN A WHERE EXISTS ( SELECT B.COMPANY FROM PS_HP_PAY_CHK_SUSP 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 EXISTS ( SELECT D.ACCT_CD FROM PS_PAY_CTX_DIST D WHERE A.COMPANY = D.COMPANY AND A.PAYGROUP = D.PAYGROUP AND A.PAY_END_DT = D.PAY_END_DT AND A.OFF_CYCLE = D.OFF_CYCLE AND A.PAGE_NUM = D.PAGE_NUM AND A.LINE_NUM = D.LINE_NUM AND A.SEPCHK = D.SEPCHK AND A.PROVINCE = D.PROVINCE AND A.TAX_CLASS_CAN = D.TAX_CLASS_CAN AND D.HP_RETDIST_STATUS = '0' AND EXISTS ( SELECT C.HP_ACCT_CD_SUSPNS FROM PS_DEPTBDGT_SUSPNS C WHERE C.DEPTID = D.DEPTID AND C.FISCAL_YEAR = D.FISCAL_YEAR AND C.HP_ACCT_CD_SUSPNS = D.ACCT_CD))

  • 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 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(4,0) SMALLINT NOT NULL Page #
    6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
    7 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
    8 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
    9 TAX_CLASS_CAN Character(3) VARCHAR2(3) NOT NULL Canadian Tax Class
    ALL=Total Gross
    CBT=Canadian Bonus Tax
    CIT=Canadian Income Tax (T4)
    CPA=Pension Adjustment
    CPP=Canada Pension Plan Employee
    CPR=Canada Pension Plan Employer
    EIE=Employment Insurance Employee
    EIR=Employment Insurance Employer
    HTX=Provincial Health Tax
    PYT=Payroll Tax
    QBT=Quebec Bonus Tax
    QCD=Quebec Tax Deduction
    QIE=Quebec Parental Plan Employee
    QIR=Quebec Parental Plan Employer
    QIT=Quebec Income Tax (RL-1)
    QPP=Quebec Pension Plan Employee
    QPR=Quebec Pension Plan Employer
    RV2=Quebec Income Tax (RL-2)
    T4A=Canadian Income Tax (T4A)
    TRV=True RL
    TT4=True T4
    10 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan
    11 NLGRS_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current No Limit Gross
    12 TXGRS_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Taxable Gross
    13 TAX_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Tax
    14 TAX_NOT_TAKEN Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax Not Taken
    15 UI_ER_RT Number(6,4) DECIMAL(5,4) NOT NULL EI Employer Rate
    16 AP_STATUS Character(1) VARCHAR2(1) NOT NULL AP Status
    S=Sent to AP
    X=Extracted