NDT_PLAN_ELIG (SQL View)	Index Back
NDT-EEs Eligible for Testing NDT_PLAN_ELIG is a view that joins data from the Personal Data, Employment and Current Job tables. It is used by NDT001 to initialize the employee population (eg., identify highly compensated employees) for further testing.

NDT_PLAN_ELIG

(SQL View)

NDT-EEs Eligible for Testing

NDT_PLAN_ELIG is a view that joins data from the Personal Data, Employment and Current Job tables. It is used by NDT001 to initialize the employee population (eg., identify highly compensated employees) for further testing.

SELECT A.EMPLID ,A.BIRTHDATE ,B.SERVICE_DT ,BN.HIGHLY_COMP_EMPL_P ,BN.HIGHLY_COMP_EMPL_C ,B.OWN_5PERCENT_CO ,C.OFFICER_CD ,C.ANNUAL_RT ,C.ANNL_BENEF_BASE_RT FROM PS_PERSON A , PS_BN_PERSON BN , PS_PER_ORG_ASGN B , PS_CURRENT_JOB C WHERE B.EMPLID = A.EMPLID AND C.EMPLID = B.EMPLID AND BN.EMPLID = A.EMPLID AND C.EMPL_RCD = B.EMPL_RCD AND C.HR_STATUS = 'A' AND C.PER_ORG = 'EMP' AND C.BENEFIT_SYSTEM <> 'OT' AND EXISTS ( SELECT 'X' FROM PS_NDT_CO_PAYGROUP D WHERE D.COMPANY=C.COMPANY AND D.PAYGROUP=C.PAYGROUP)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BIRTHDATE Date(10) DATE Date of Birth

3 SERVICE_DT Date(10) DATE Service Date

4 HIGHLY_COMP_EMPL_P Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not an employee is considered highly compensated according to U.S. Government regulations in the year prior to the current year, and is used for managing Section 401savings plans or Section 129 spending accounts. The valid values, as delivered, are Not Eligible (N), Highly Compensated (H), Eligible Non-Officer,Non5% (E), and Eligible Officer (O). This field is system-maintained.
E=Eligible non-Officer, non 5%
H=Highly Compensated Employee
N=Not Eligible for the Plan
O=Eligible Officer, not HCE

5 HIGHLY_COMP_EMPL_C Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not an employee is considered highly compensated according to U.S. Government regulations in the current year, and is used for managing Section 401savings plans or Section 129 spending accounts. The valid values, as delivered, are Not Eligible (N), Highly Compensated (H), Eligible Non-Officer,Non5% (E), and Eligible Officer (O). This field is system-maintained.
E=Eligile non-Officer, non 5%
H=Highly Compensated Employee
N=Not Eligible for the Plan
O=Eligible Officer, not HCE

6 OWN_5PERCENT_CO Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) an employee owns 5% or more of the company. This value is used in nondiscrimination testing.

7 OFFICER_CD Character(1) VARCHAR2(1) NOT NULL Officer Code
C=Chairman
D=Director
N=None
O=Officer
P=President
S=Secretary
T=Treasurer
V=Vice President

8 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate

9 ANNL_BENEF_BASE_RT Number(19,3) DECIMAL(18,3) NOT NULL Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	BIRTHDATE	Date(10)	DATE	Date of Birth
3	SERVICE_DT	Date(10)	DATE	Service Date
4	HIGHLY_COMP_EMPL_P	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not an employee is considered highly compensated according to U.S. Government regulations in the year prior to the current year, and is used for managing Section 401savings plans or Section 129 spending accounts. The valid values, as delivered, are Not Eligible (N), Highly Compensated (H), Eligible Non-Officer,Non5% (E), and Eligible Officer (O). This field is system-maintained. E=Eligible non-Officer, non 5% H=Highly Compensated Employee N=Not Eligible for the Plan O=Eligible Officer, not HCE
5	HIGHLY_COMP_EMPL_C	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not an employee is considered highly compensated according to U.S. Government regulations in the current year, and is used for managing Section 401savings plans or Section 129 spending accounts. The valid values, as delivered, are Not Eligible (N), Highly Compensated (H), Eligible Non-Officer,Non5% (E), and Eligible Officer (O). This field is system-maintained. E=Eligile non-Officer, non 5% H=Highly Compensated Employee N=Not Eligible for the Plan O=Eligible Officer, not HCE
6	OWN_5PERCENT_CO	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) an employee owns 5% or more of the company. This value is used in nondiscrimination testing.
7	OFFICER_CD	Character(1)	VARCHAR2(1) NOT NULL	Officer Code C=Chairman D=Director N=None O=Officer P=President S=Secretary T=Treasurer V=Vice President
8	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
9	ANNL_BENEF_BASE_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.