PY_TD1_FED_VW

(SQL View)
 Index Back

TD1 Federal View

TD1 federal view for approvals

SELECT DISTINCT A.EMPLID , A.COMPANY , A.SPECIAL_CIT_STATUS , A.STATUS_INDIAN ,A.CIT_PRESCR_AREA ,A.PCT_EXEMPT , A.CIT_ADDL_AMT , A.CIT_ADDL_PCT ,A.CIT_NET_CLAIM_AMT ,A.TD1_ADJUST ,A.CIT_ANNUAL_COMM ,A.CIT_ANNUAL_EXP ,A.WAGE_LOSS_PLAN ,A.QIT_NET_CLAIM_AMT ,A.SPECIAL_QIT_STATUS ,A.NON_INDEX_AMT ,A.QIT_PRESCR_AREA ,A.QIT_OTHER_DEDUCTS ,A.QIT_ADDL_AMT ,A.QIT_ANNUAL_COMM ,A.QIT_ANNUAL_EXP FROM PS_CAN_TAX_DATA A , PS_JOB B , PS_COMPANY_TBL C WHERE A.EMPLID = B.EMPLID AND B.COMPANY = C.COMPANY AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_CAN_TAX_DATA A1 WHERE A1.EMPLID = A.EMPLID AND A1.COMPANY = A.COMPANY AND A1.EFFDT <= %CurrentDateIn) AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_COMPANY_TBL C1 WHERE C1.COMPANY = C.COMPANY AND C1.EFFDT <= %CurrentDateIn)

  • Parent record: PAY_LINE

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

    Prompt Table: COMPANY_TBL

    3 SPECIAL_CIT_STATUS Character(1) VARCHAR2(1) NOT NULL Special CIT Status
    E=Exempt (not subject to CIT)
    G=Maintain gross
    N=None
    4 STATUS_INDIAN Character(1) VARCHAR2(1) NOT NULL Status Indian
    5 CIT_PRESCR_AREA Number(10,2) DECIMAL(9,2) NOT NULL CIT Prescibed Area Deduction
    6 PCT_EXEMPT Number(3,0) SMALLINT NOT NULL Field to define the percentage of taxable gross that is exempt from income tax.
    7 CIT_ADDL_AMT Number(8,2) DECIMAL(7,2) NOT NULL CIT Additional Amount
    8 CIT_ADDL_PCT Number(6,3) DECIMAL(5,3) NOT NULL CIT Additional Percentage
    9 CIT_NET_CLAIM_AMT Number(10,2) DECIMAL(9,2) NOT NULL CIT Net Claim Amount
    10 TD1_ADJUST Number(10,2) DECIMAL(9,2) NOT NULL TD1 Adjustment
    11 CIT_ANNUAL_COMM Number(10,2) DECIMAL(9,2) NOT NULL TD1X Estimated Commissions
    12 CIT_ANNUAL_EXP Number(10,2) DECIMAL(9,2) NOT NULL TD1X Estimated Expenses
    13 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan
    14 QIT_NET_CLAIM_AMT Number(10,2) DECIMAL(9,2) NOT NULL QIT Net Claim Amount
    15 SPECIAL_QIT_STATUS Character(1) VARCHAR2(1) NOT NULL Special QIT Status
    E=Exempt (not subject to QIT)
    G=Maintain gross
    N=None
    16 NON_INDEX_AMT Number(10,2) DECIMAL(9,2) NOT NULL Non-Indexed Amount
    17 QIT_PRESCR_AREA Number(10,2) DECIMAL(9,2) NOT NULL QIT Prescribed Area
    18 QIT_OTHER_DEDUCTS Number(10,2) DECIMAL(9,2) NOT NULL QIT Other Deductions
    19 QIT_ADDL_AMT Number(8,2) DECIMAL(7,2) NOT NULL QIT Additional Amount
    20 QIT_ANNUAL_COMM Number(10,2) DECIMAL(9,2) NOT NULL MR19-CV Estimated Commissions
    21 QIT_ANNUAL_EXP Number(10,2) DECIMAL(9,2) NOT NULL MR19-CV Estimated Expenses