PY_MOD_TXDST_V2

(SQL View)
 Index Back

Employee Tax Distribution

Paycheck modeling employee's state tax distributions.

SELECT A.PY_MOD_OPRID , A.PY_MOD_EMPLID , A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.ADDL_NBR , A.EMPLID , A.EMPL_RCD , A.STATE , A.LOCALITY , B.DIST_PCT , A.ADDLPAY_REASON FROM PS_MODEL_PAY_EARNS A , PS_TAX_DISTRIB B WHERE ((A.ADDLPAY_REASON = 'N' AND A.ADDL_NBR = 0) OR (A.ADDLPAY_REASON = 'N' AND A.ADDL_NBR <> 0 AND EXISTS ( SELECT 'Y' FROM PS_MODEL_PAY_EARNS T WHERE T.PY_MOD_OPRID = A.PY_MOD_OPRID AND T.PY_MOD_EMPLID = A.PY_MOD_EMPLID AND T.COMPANY = A.COMPANY AND T.PAYGROUP = A.PAYGROUP AND T.PAY_END_DT = A.PAY_END_DT AND T.OFF_CYCLE = A.OFF_CYCLE AND T.PAGE_NUM = A.PAGE_NUM AND T.LINE_NUM = A.LINE_NUM AND T.ADDL_NBR = 0 AND T.ADDLPAY_REASON = A.ADDLPAY_REASON AND T.HOURLY_RT = A.HOURLY_RT AND T.DEPTID = A.DEPTID AND T.JOBCODE = A.JOBCODE AND T.POSITION_NBR = A.POSITION_NBR))) AND B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.STATE = A.STATE AND B.LOCALITY = A.LOCALITY AND B.DIST_PCT > 0 AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_TAX_DISTRIB B_ED WHERE B.EMPLID = B_ED.EMPLID AND B.EMPL_RCD = B_ED.EMPL_RCD AND B.STATE = B_ED.STATE AND B.LOCALITY = B_ED.LOCALITY AND B_ED.EFFDT <= %CurrentDateIn)

  • Parent record: TAX_DIST_EFFDT

    • # 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
    4 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    5 PAY_END_DT Date(10) DATE Pay Period End Date
    6 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    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 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
    10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    11 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    12 STATE Character(6) VARCHAR2(6) NOT NULL State
    13 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
    14 DIST_PCT Number(7,3) DECIMAL(6,3) NOT NULL Percent of Distribution
    15 ADDLPAY_REASON Character(3) VARCHAR2(3) NOT NULL Reason for Additional Pay
    A=Anniversary Award
    AWD=Award Data
    BAS=Benefits Administration Credit
    C=Contract Pay
    JOB=Job Other Pay
    N=Not Specified
    O=Outstanding Contribution
    P=Performance Award
    Q=President's Award
    S=Productivity Award