PY_IN_YE_ERR_VW (SQL View)	Index Back
Insights Year End Audit Error Insights Year End Audit Error View

PY_IN_YE_ERR_VW

(SQL View)

Insights Year End Audit Error

Insights Year End Audit Error View

SELECT A.EMPLID ,A.PY_TAX_YEAR ,A.W2_REPORTING_CO ,A.COMPANY ,A.TAXFORM_ID ,A.SEQUENCE_NUMBER ,A.RUN_CNTL_ID ,A.STATE ,A.DESCR254 ,A.W2_REPORTING_CO||' - '|| ( SELECT C1.DESCR FROM PS_COMPANY_TBL C1 WHERE C1.COMPANY = A.W2_REPORTING_CO AND %EffdtCheck(COMPANY_TBL C2, C1, %CurrentDateIn)) , ( SELECT X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'TAXFORM_ID' AND X.FIELDVALUE = A.TAXFORM_ID AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn)) , A.LASTUPDDTTM FROM PS_PY_YE_LD_ERR A WHERE A.PY_TAX_YEAR = ( SELECT MAX(A2.CALENDAR_YEAR) FROM PS_YE_AMOUNTS A2)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

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

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

5 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

6 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number

7 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

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

9 ERROR_DESCR Character(254) VARCHAR2(254) NOT NULL Error description

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

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

12 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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	PY_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Represents the year for personal income tax purposes.
3	W2_REPORTING_CO	Character(3)	VARCHAR2(3) NOT NULL	W-2 Reporting Company
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	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
6	SEQUENCE_NUMBER	Number(2,0)	SMALLINT NOT NULL	Sequence Number
7	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
8	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
9	ERROR_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Error description
10	PY_W2_CMP_DESCR	Character(254)	VARCHAR2(254) NOT NULL	W-2 company description
11	TAXFORM_ID_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Taxform ID Description
12	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.