PY_RL_FORMS_VW

(SQL View)
Index Back

RL Forms View

RL Forms View record

SELECT DISTINCT A.EMPLID ,A.PY_TAX_YEAR ,A.COMPANY ,A.TAXFORM_ID ,A.WAGE_LOSS_PLAN ,A.PROVINCE , ( SELECT COUNT(*) FROM PS_PY_SS_MRQ1_VW A1 WHERE A1.EMPLID=A.EMPLID AND A.PY_TAX_YEAR=A1.PY_TAX_YEAR AND A.COMPANY=A1.COMPANY AND A.TAXFORM_ID=A1.TAXFORM_ID AND A.WAGE_LOSS_PLAN=A1.WAGE_LOSS_PLAN AND A.province=A1.province ) FROM PS_PY_SS_MRQ1_VW A WHERE A.ye_form_viewing_dt<=%CurrentDateIn

# 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 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
5 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan
6 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
7 COUNT1 Number(12,0) DECIMAL(12) NOT NULL AUS WGEA counts