PY_IC_W4_STX_VW

(SQL View)
 Index Back

Self Serivce W4-STaxDataView

View to support Self Service WEB-enabled W4 Update. This view contains an employee's State Tax Data. It has been created to shield from all Peoplecode on STATE_TAX_DATA when new rows in STATE_TAX_DATA have to be created. This would be required when a new row in FED_TAX_DATA has to be created. Changes made to the record STATE_TAX_DATA would need to be analyzed and made to PY_IC_W4_STX_VW, if necessary.

SELECT EMPLID , COMPANY , EFFDT , STATE , RESIDENT , NON_RES_DECLARED , SPECIAL_SWT_STATUS , SWT_MAR_STATUS , SWT_ALLOWANCES , SWT_ADDL_ALLOWNCES , WAGE_PLAN_CD , ANNL_EXEMPTION_AMT , PERCENT_OF_FWT , SWT_ADDL_AMT , SWT_ADDL_PCT , SDI_STATUS , SUT_EXEMPT , UI_JURISDICTION , ADDL_AMT_ADJ , WT4A_FILED , LOCK_IN_RECVD , LOCK_IN_LIMIT , RETIREMENT_PLAN , EIC_STATUS_ST , HLTH_COV_IND , CREATION_DT , PNA_FLI_STATUS , RES_ADDL_ALLOW , PY_TRANSIT_TAX , PNA_MLI_STATUS , PY_FML_STATUS , PY_LTC_STATUS , PY_SWT_FORM_RECVD FROM PS_STATE_TAX_DATA

  • Parent record: FED_TAX_DATA

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

    Prompt Table: PERSON

    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: CO_STATETAX_TBL

    5 RESIDENT Character(1) VARCHAR2(1) NOT NULL Resident

    Y/N Table Edit

    Default Value: Y

    6 NON_RES_DECLARED Character(1) VARCHAR2(1) NOT NULL Non-Residency Statement Filed

    Y/N Table Edit

    Default Value: N

    7 SPECIAL_SWT_STATUS Character(1) VARCHAR2(1) NOT NULL Special Tax Status
    A=Nonresident alien (Fed Rules)
    E=No taxable gross; no tax taken
    G=Maintain taxable gross
    N=None

    Default Value: N

    8 SWT_MAR_STATUS Character(1) VARCHAR2(1) NOT NULL SWT Marital/Tax Status

    Prompt Table: SWT_MARSTAT_TBL

    9 SWT_ALLOWANCES Number(3,0) SMALLINT NOT NULL Withholding Allowances
    10 SWT_ADDL_ALLOWNCES Number(3,0) SMALLINT NOT NULL Additional Allowances
    11 WAGE_PLAN_CD Character(1) VARCHAR2(1) NOT NULL Wage Plan Code
    A=DI Exempt/UI State
    J=DI State/UI Exempt
    L=DI Voluntary/UI Exempt
    P=DI Exempt/UI Exempt
    R=DI Special Exempt/UI State
    S=DI State/UI State
    U=DI Voluntary/UI State

    Default Value: S

    12 ANNL_EXEMPTION_AMT Number(8,0) INTEGER NOT NULL MS Annual Exemption Amount
    13 PERCENT_OF_FWT Number(6,3) DECIMAL(5,3) NOT NULL AZ Withholding Percent
    14 SWT_ADDL_AMT Signed Number(9,2) DECIMAL(7,2) NOT NULL SWT Additional Amount
    15 SWT_ADDL_PCT Number(6,3) DECIMAL(5,3) NOT NULL SWT Additional Percentage
    16 SDI_STATUS Character(1) VARCHAR2(1) NOT NULL State Disability Insurance Status
    E=Exempt
    N=Not Applicable
    V=Voluntary Disability Plan
    Y=Subject
    17 SUT_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt From SUT

    Y/N Table Edit

    Default Value: COMPANY_TBL.SUT_EXEMPT

    18 UI_JURISDICTION Character(1) VARCHAR2(1) NOT NULL UI Jurisdiction

    Y/N Table Edit

    Default Value: N

    19 ADDL_AMT_ADJ Character(1) VARCHAR2(1) NOT NULL Additional Amount Adjustment
    D=Decrease Additional Amount
    I=Increase Additional Amount

    Default Value: I

    20 WT4A_FILED Character(1) VARCHAR2(1) NOT NULL Designates that Form WT-4A has been filed to allow the addiitonal amount to be used as a standing Flat Tax Amount. As such, Reciprocity rules are enforced.
    21 LOCK_IN_RECVD Character(1) VARCHAR2(1) NOT NULL Lock-In Letter Received

    Y/N Table Edit

    Default Value: N

    22 LOCK_IN_LIMIT Number(3,0) SMALLINT NOT NULL Limit On Allowances
    23 RETIREMENT_PLAN Character(1) VARCHAR2(1) NOT NULL PR Retirement Plan
    24 EIC_STATUS_ST Character(1) VARCHAR2(1) NOT NULL Earned Income Credit
    25 HLTH_COV_IND Character(1) VARCHAR2(1) NOT NULL VT Health Coverage Indicator
    A=Eligible/Accepted
    B=Eligible/Not Accepted/Covered
    C=Eligible/Not Accepted/No Cover
    D=Not Eligible
    N=Not Applicable
    S=Seasonal
    26 CREATION_DT Date(10) DATE Creation Date
    27 PNA_FLI_STATUS Character(1) VARCHAR2(1) NOT NULL FLI Status
    E=Exempt
    N=Not Applicable
    V=Voluntary Plan
    Y=Subject
    28 RES_ADDL_ALLOW Number(3,0) SMALLINT NOT NULL Res State Addl Allowances
    29 PY_TRANSIT_TAX Character(1) VARCHAR2(1) NOT NULL Checkbox field to indicate whether Oregon Transit Tax should be withheld or not.
    30 PNA_MLI_STATUS Character(1) VARCHAR2(1) NOT NULL MLI Status
    E=Exempt
    N=Not Applicable
    V=Voluntary Plan
    Y=Subject
    31 PY_FML_STATUS Character(1) VARCHAR2(1) NOT NULL FMLI Status
    E=Exempt
    N=Not Applicable
    V=Voluntary Plan
    Y=Subject
    32 PY_LTC_STATUS Character(1) VARCHAR2(1) NOT NULL LTC Status
    E=Exempt
    N=Not Applicable
    Y=Subject
    33 PY_SWT_FORM_RECVD Character(1) VARCHAR2(1) NOT NULL State form received.
    B=Received - Line 2 Blank
    N=Form Not Received
    Y=Received - Line 2 Not Blank