R_NDT_EMPL_YTD (SQL Table)	Index Back
Tmp Tbl-NDT EE Elig Earnings R_NDT_EMPL_YTD is a temporary record used with R_NDT_EMP_ADP to test eligible earnings YTD amounts for 401 plans under NDT.

R_NDT_EMPL_YTD

(SQL Table)

Tmp Tbl-NDT EE Elig Earnings

R_NDT_EMPL_YTD is a temporary record used with R_NDT_EMP_ADP to test eligible earnings YTD amounts for 401 plans under NDT.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 YEAR_CD Character(1) VARCHAR2(1) NOT NULL Year Code: used in Nondiscriminating Testing and...
B=Current and Prior Plan Year
C=Current Plan Year
P=Prior Plan Year

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

3 HCE_TYPE Character(1) VARCHAR2(1) NOT NULL Highly/Lowly Compensated
H=Highly Compensated
L=Non Highly Compensated

4 YTD_401_K_M Character(1) VARCHAR2(1) NOT NULL 401(k) or 401(m) YTD

5 GRS_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Gross Earnings YTD

6 DED_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Deduction Balance YTD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	YEAR_CD	Character(1)	VARCHAR2(1) NOT NULL	Year Code: used in Nondiscriminating Testing and... B=Current and Prior Plan Year C=Current Plan Year P=Prior Plan Year
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	HCE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Highly/Lowly Compensated H=Highly Compensated L=Non Highly Compensated
4	YTD_401_K_M	Character(1)	VARCHAR2(1) NOT NULL	401(k) or 401(m) YTD
5	GRS_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Gross Earnings YTD
6	DED_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deduction Balance YTD