PAY_TAX_TXGR_VW

(SQL View)
 Index Back

U.S. Payroll Tax

This record contains employee paycheck tax information.

SELECT S.COMPANY ,S.PAYGROUP ,S.PAY_END_DT ,S.OFF_CYCLE ,S.PAGE_NUM ,S.LINE_NUM ,S.SEPCHK ,S.STATE ,S.LOCALITY ,S.TAX_CLASS ,F.TXGRS_CUR ,F.NLGRS_CUR ,B.TAX_GRS_BASE FROM PS_PAY_TAX S ,PS_PAY_TAX F ,PS_TAXGR_DEFN_TBL D ,PS_TAXGR_BASE_TBL B WHERE S.COMPANY = F.COMPANY AND S.PAYGROUP = F.PAYGROUP AND S.PAY_END_DT = F.PAY_END_DT AND S.OFF_CYCLE = F.OFF_CYCLE AND S.PAGE_NUM = F.PAGE_NUM AND S.LINE_NUM = F.LINE_NUM AND S.SEPCHK = F.SEPCHK AND S.STATE <> '$U' AND F.STATE = '$U' AND S.LOCALITY = D.LOCALITY AND S.STATE = D.STATE AND S.LOCALITY = B.LOCALITY AND S.STATE = B.STATE AND D.EFF_STATUS = 'A' AND ((B.TAX_GRS_BASE='D' AND F.TAX_CLASS IN ('D','E') AND S.TAX_CLASS IN ('D','E','G','J','W','X','I','L','M','N','O','Y','Z')) OR (B.TAX_GRS_BASE = 'U' AND F.TAX_CLASS = 'U' AND S.TAX_CLASS IN ('U','V','S')) OR (B.TAX_GRS_BASE = 'W' AND F.TAX_CLASS = 'H' AND S.TAX_CLASS = 'H')) AND D.EFFDT=B.EFFDT AND D.EFFDT= ( SELECT MAX(D1.EFFDT) FROM PS_TAXGR_DEFN_TBL D1 WHERE D.STATE=D1.STATE AND D.LOCALITY=D1.LOCALITY AND D1.EFFDT<=S.PAY_END_DT) UNION SELECT S.COMPANY ,S.PAYGROUP ,S.PAY_END_DT ,S.OFF_CYCLE ,S.PAGE_NUM ,S.LINE_NUM ,S.SEPCHK ,S.STATE ,S.LOCALITY ,S.TAX_CLASS ,F.TXGRS_CUR ,F.NLGRS_CUR ,B.TAX_GRS_BASE FROM PS_PAY_TAX S ,PS_PAY_TAX F ,PS_TAXGR_DEFN_TBL D ,PS_TAXGR_BASE_TBL B WHERE S.COMPANY = F.COMPANY AND S.PAYGROUP = F.PAYGROUP AND S.PAY_END_DT = F.PAY_END_DT AND S.OFF_CYCLE = F.OFF_CYCLE AND S.PAGE_NUM = F.PAGE_NUM AND S.LINE_NUM = F.LINE_NUM AND S.SEPCHK = F.SEPCHK AND S.STATE <> '$U' AND F.STATE = '$U' AND S.STATE = D.STATE AND S.STATE = B.STATE AND S.LOCALITY <> ' ' AND S.LOCALITY <> D.LOCALITY AND D.LOCALITY = '$DFLT' AND D.LOCALITY = B.LOCALITY AND D.EFF_STATUS = 'A' AND ((B.TAX_GRS_BASE='D' AND F.TAX_CLASS IN ('D','E') AND S.TAX_CLASS IN ('D','E','G','J','W','X','I','L','M','N','O','Y','Z')) OR (B.TAX_GRS_BASE = 'U' AND F.TAX_CLASS = 'U' AND S.TAX_CLASS IN ('U','V','S')) OR (B.TAX_GRS_BASE = 'W' AND F.TAX_CLASS = 'H' AND S.TAX_CLASS = 'H')) AND D.EFFDT=B.EFFDT AND D.EFFDT= ( SELECT MAX(D1.EFFDT) FROM PS_TAXGR_DEFN_TBL D1 WHERE D.STATE=D1.STATE AND D.LOCALITY=D1.LOCALITY AND D1.EFFDT<=S.PAY_END_DT)

  • 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(5,0) INTEGER NOT NULL Page Nbr
    6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    7 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    8 STATE Character(6) VARCHAR2(6) NOT NULL State
    9 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
    10 TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Balance Class
    11 TXGRS_BASE Signed Number(12,2) DECIMAL(10,2) NOT NULL Federal Taxable Gross Base
    12 NLGRS_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current No Limit Gross
    13 TAX_GRS_BASE Character(1) VARCHAR2(1) NOT NULL Base Gross
    D=FICA
    G=All Gross
    S=SWT
    U=FUT
    W=FWT