LV_STTAX_STP_VW (SQL View)	Index Back
State Tax Data Stop View This view is used to facilitate sending a stop transaction to ADP Connection for use with their PCPW product. They require the state code and the date any time the resident state is changed and it ends up being equal to the worked in state.

LV_STTAX_STP_VW

(SQL View)

State Tax Data Stop View

This view is used to facilitate sending a stop transaction to ADP Connection for use with their PCPW product. They require the state code and the date any time the resident state is changed and it ends up being equal to the worked in state.

SELECT A.EMPLID ,A.COMPANY ,A.EFFDT ,A.STATE FROM PS_STATE_TAX_DATA A WHERE A.RESIDENT = 'Y' AND A.EFFDT < ( SELECT MAX(B.EFFDT) FROM PS_STATE_TAX_DATA B WHERE A.EMPLID = B.EMPLID AND B.RESIDENT = 'Y' AND A.STATE <> B.STATE)

# 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

#	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