PY_MOD_TAXES_VW

(SQL View)
 Index Back

U.S. Payroll Tax

This record contains employee paycheck tax information.

SELECT PY_MOD_OPRID , PY_MOD_EMPLID , COMPANY , PAYGROUP , PAY_END_DT , OFF_CYCLE , PAGE_NUM , LINE_NUM , SEPCHK , STATE , LOCALITY , TAX_CLASS , RESIDENT , TAX_CUR FROM PS_MODEL_PAY_TAX WHERE TAX_CUR <> 0

  • Parent record: PAY_CHECK

    • # 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
    8 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    9 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    10 STATE Character(6) VARCHAR2(6) NOT NULL State
    11 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
    12 TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Balance Class
    13 RESIDENT Character(1) VARCHAR2(1) NOT NULL Resident

    Y/N Table Edit

    14 TAX_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Tax