LVD_ST_TAX_VW

(SQL View)
 Index Back

EE U.S. State Tax Data

ADP Connection view used by ADP and not in export.

SELECT A.EMPLID ,A.COMPANY ,A.EFFDT ,A.STATE ,A.RESIDENT ,A.NON_RES_DECLARED ,A.SPECIAL_SWT_STATUS ,A.SWT_MAR_STATUS ,A.SWT_ALLOWANCES ,A.SWT_ADDL_ALLOWNCES ,A.WAGE_PLAN_CD ,A.ANNL_EXEMPTION_AMT ,A.PERCENT_OF_FWT ,A.SWT_ADDL_AMT ,A.SWT_ADDL_PCT ,A.SDI_STATUS ,A.SUT_EXEMPT ,A.UI_JURISDICTION ,A.ADDL_AMT_ADJ ,A.LOCK_IN_RECVD ,A.LOCK_IN_LIMIT FROM PS_STATE_TAX_DATA A WHERE A.RESIDENT = 'Y' AND (A.STATE NOT IN ( SELECT M.STATE FROM PS_TAX_DISTRIB M WHERE M.EMPLID = A.EMPLID AND M.EMPL_RCD=0 AND M.LOCALITY = ' ') OR A.UI_JURISDICTION = 'Y')

# 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
3 EFFDT Date(10) DATE Effective Date
4 STATE Character(6) VARCHAR2(6) NOT NULL State
5 RESIDENT Character(1) VARCHAR2(1) NOT NULL Resident
6 NON_RES_DECLARED Character(1) VARCHAR2(1) NOT NULL Non-Residency Statement Filed
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
8 SWT_MAR_STATUS Character(1) VARCHAR2(1) NOT NULL SWT Marital/Tax Status
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
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
18 UI_JURISDICTION Character(1) VARCHAR2(1) NOT NULL UI Jurisdiction
19 ADDL_AMT_ADJ Character(1) VARCHAR2(1) NOT NULL Additional Amount Adjustment
D=Decrease Additional Amount
I=Increase Additional Amount
20 LOCK_IN_RECVD Character(1) VARCHAR2(1) NOT NULL Lock-In Letter Received
21 LOCK_IN_LIMIT Number(3,0) SMALLINT NOT NULL Limit On Allowances