WRK_IMP_EMPL (SQL Table)	Index Back
Imputed Income Work List Table Record defines the list of employees who will be processed by the imputed income adjustment.

WRK_IMP_EMPL

(SQL Table)

Imputed Income Work List Table

Record defines the list of employees who will be processed by the imputed income adjustment.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 THRU_MONTH Number(2,0) SMALLINT NOT NULL Process Thru Month

4 NAME Character(50) VARCHAR2(50) NOT NULL Name

5 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec

6 SMOKER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) an employee or dependent is a smoker.
N=Non Smoker
Y=Smoker

7 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

8 BIRTHDATE Date(10) DATE Date of Birth

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	THRU_MONTH	Number(2,0)	SMALLINT NOT NULL	Process Thru Month
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
6	SMOKER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) an employee or dependent is a smoker. N=Non Smoker Y=Smoker
7	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
8	BIRTHDATE	Date(10)	DATE	Date of Birth