TAXFORM_ERN (SQL Table)	Index Back
Taxform Earnings Defines the earnings used to compute the value for the box.

TAXFORM_ERN

(SQL Table)

Taxform Earnings

Defines the earnings used to compute the value for the box.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 BOX Character(4) VARCHAR2(4) NOT NULL Box

4 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
Prompt Table: EARNINGS_TBL

5 OTHER_MONIES_CD Character(3) VARCHAR2(3) NOT NULL ROE Other Monies Code

6 ROE_VAC_PAY_CD Character(1) VARCHAR2(1) NOT NULL Vacation pay code for ROE.
2=Paid - No Longer Working
3=Paid - Vacation Leave Period
4=Anniversary - Yearly Payment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	BOX	Character(4)	VARCHAR2(4) NOT NULL	Box
4	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code Prompt Table: EARNINGS_TBL
5	OTHER_MONIES_CD	Character(3)	VARCHAR2(3) NOT NULL	ROE Other Monies Code
6	ROE_VAC_PAY_CD	Character(1)	VARCHAR2(1) NOT NULL	Vacation pay code for ROE. 2=Paid - No Longer Working 3=Paid - Vacation Leave Period 4=Anniversary - Yearly Payment