PY_W4_CURR_VW

(SQL View)
 Index Back

Tax Data Current Information

Current Information for the Federal and State Tax Data. By Company and by Employee

SELECT A.EMPLID , A.COMPANY , A.EFFDT , '$U' , 'Federal' , A.FWT_MAR_STATUS , X.XLATSHORTNAME , A.FWT_ALLOWANCES , A.FWT_ADDL_AMT , A.FWT_ADDL_PCT , 0 FROM PS_FED_TAX_DATA A , PSXLATITEM X WHERE X.FIELDNAME = 'FWT_MAR_STATUS' AND X.FIELDVALUE = A.FWT_MAR_STATUS AND %EffdtCheck(FED_TAX_DATA A1, A, %CurrentDateIn) AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn) UNION ALL SELECT B.EMPLID , B.COMPANY , B.EFFDT , B.STATE , C.DESCR , B.SWT_MAR_STATUS , S.DESCRSHORT , B.SWT_ALLOWANCES , B.SWT_ADDL_AMT , B.SWT_ADDL_PCT , B.SWT_ADDL_ALLOWNCES FROM PS_STATE_TAX_DATA B , PS_STATE_TBL C , PS_SWT_MARSTAT_TBL S WHERE B.STATE = C.STATE AND C.COUNTRY IN ('USA', 'CAN') AND B.STATE = S.STATE AND B.SWT_MAR_STATUS = S.SWT_MAR_STATUS AND %EffdtCheck(STATE_TAX_DATA B1, B, %CurrentDateIn) AND %EffdtCheck(SWT_MARSTAT_TBL S1, S, %CurrentDateIn)

# 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 Effective Date

Default Value: %date

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

Prompt Table: PY_STATETAX_VW

5 STATE_DESCR Character(30) VARCHAR2(30) NOT NULL State Description
6 MAR_STATUS_FORM Character(1) VARCHAR2(1) NOT NULL Marital Status Form
7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
8 NO_ALLOWANCES Number(3,0) SMALLINT NOT NULL Number of Allowances Permitted
9 FWT_ADDL_AMT Number(8,2) DECIMAL(7,2) NOT NULL FWT Additional Amount
10 FWT_ADDL_PCT Number(6,3) DECIMAL(5,3) NOT NULL FWT Additional Percentage
11 SWT_ADDL_ALLOWNCES Number(3,0) SMALLINT NOT NULL Additional Allowances