PY_IN_YE_FLT_VW (SQL View)	Index Back
Insights Audit Filter Insights Audit Filter View

PY_IN_YE_FLT_VW

(SQL View)

Insights Audit Filter

Insights Audit Filter View

SELECT A.CALENDAR_YEAR , A.COMPANY ,A.TAXFORM_ID ,( SELECT X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'TAXFORM_ID' AND X.FIELDVALUE = A.TAXFORM_ID AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn)) ,B1.COMPANY||' - '||B1.DESCR ,%CurrentDateTimeIn FROM PS_W2_COMPANY A,PS_COMPANY_TBL B1 WHERE B1.COMPANY=A.COMPANY AND %EffdtCheck(COMPANY_TBL B2, B1, %CurrentDateIn) AND A.CALENDAR_YEAR <= (EXTRACT(YEAR FROM %CurrentDateIn )) UNION SELECT (EXTRACT(YEAR FROM A.EFFDT )) ,' ' ,A.TAXFORM_ID , ( SELECT X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'TAXFORM_ID' AND X.FIELDVALUE = A.TAXFORM_ID AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn)) ,' ',%CurrentDateTimeIn FROM PS_TAXFORM_TBL A WHERE A.TAXFORM_ID IN ('I','J','M','N','P','Q','S','U','X','W') AND A.EFFDT<=%CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PY_TAX_YEAR Number(4,0) SMALLINT NOT NULL Represents the year for personal income tax purposes.

2 W2_REPORTING_CO Character(3) VARCHAR2(3) NOT NULL W-2 Reporting Company

3 TAXFORM_ID Character(1) VARCHAR2(1) NOT NULL Tax Form Identification
A=T4A Slip
B=Business Payrolls Survey - CAN
C=WCB Assessable Earnings
E=Record of Employment
F=940 - Annual Employer's FUTA
I=W-2VI
J=W-2cVI
M=W-2GU
N=W-2cGU
P=W-2PR
Q=W-2cPR
R=RL-1 Slip
S=W-2AS
T=T4 Slip
U=W-2cAS
V=RL-2 Slip
W=W-2
X=W-2c
Y=1099-R
Z=1042-S

4 TAXFORM_ID_DESCR Character(30) VARCHAR2(30) NOT NULL Taxform ID Description

5 PY_W2_CMP_DESCR Character(254) VARCHAR2(254) NOT NULL W-2 company description

6 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PY_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Represents the year for personal income tax purposes.
2	W2_REPORTING_CO	Character(3)	VARCHAR2(3) NOT NULL	W-2 Reporting Company
3	TAXFORM_ID	Character(1)	VARCHAR2(1) NOT NULL	Tax Form Identification A=T4A Slip B=Business Payrolls Survey - CAN C=WCB Assessable Earnings E=Record of Employment F=940 - Annual Employer's FUTA I=W-2VI J=W-2cVI M=W-2GU N=W-2cGU P=W-2PR Q=W-2cPR R=RL-1 Slip S=W-2AS T=T4 Slip U=W-2cAS V=RL-2 Slip W=W-2 X=W-2c Y=1099-R Z=1042-S
4	TAXFORM_ID_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Taxform ID Description
5	PY_W2_CMP_DESCR	Character(254)	VARCHAR2(254) NOT NULL	W-2 company description
6	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.