| # |
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 |
ETHNIC_GROUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Ethnic Group
1=White
2=Black/African American
3=Hispanic/Latino
4=Asian
5=American Indian/Alaska Native
6=Not Specified
7=Native Hawaiian/Oth Pac Island
|
| 4 |
MAIL_DROP |
Character(50) |
VARCHAR2(50) NOT NULL |
Mail Drop ID
|
| 5 |
HIRE_DT |
Date(10) |
DATE |
Hire Date
|
| 6 |
REHIRE_DT |
Date(10) |
DATE |
Rehire Date
|
| 7 |
PAYCHECK_DIST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Mail Option
1=Company Distribution
2=Postal Service
I=Company Distribution
X=Postal Service
|
| 8 |
PAYCHECK_LOCN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Location Option
D=Home Department Location
E=Select on Payroll Data Panel
J=Job Location
O=Other Location
|
| 9 |
FICA_STATUS_EE |
Character(1) |
VARCHAR2(1) NOT NULL |
FICA Status-Employee
E=Exempt
M=Medicare only
N=Subject
|
| 10 |
FUT_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt from FUT
|
| 11 |
FWT_ALLOWANCES |
Number(3,0) |
SMALLINT NOT NULL |
FWT Allowances
|
| 12 |
FWT_MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FWT Marital Status
M=Married
S=Single
|
| 13 |
FWT_ADDL_AMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
FWT Additional Amount
|
| 14 |
FWT_EST_AMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
FWT Estimated Amount
|
| 15 |
FWT_ADDL_PCT |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
FWT Additional Percentage
|
| 16 |
EIC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Earned Income Credit Status
M=Married, both spouses filing
N=Not applicable
S=Single,or Head of Household
U=Married without spouse filing
|
| 17 |
STATUTORY_EE |
Character(1) |
VARCHAR2(1) NOT NULL |
Statutory Employee
Y/N Table Edit
Default Value: N
|
| 18 |
DECEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Deceased
Y/N Table Edit
Default Value: N
|
| 19 |
PENSION_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Retirement Plan
Y/N Table Edit
Default Value: N
|
| 20 |
DEFERRED_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Deferred Compensation
Y/N Table Edit
Default Value: N
|
| 21 |
LEGAL_REP |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Representative
Y/N Table Edit
Default Value: N
|
| 22 |
HOUSEHOLD_EMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Household Employee (942)
Y/N Table Edit
Default Value: N
|
| 23 |
WITH_NY_DIFF |
Character(1) |
VARCHAR2(1) NOT NULL |
Withhold NY State Tax Diff
Y/N Table Edit
Default Value: N
|
| 24 |
MEDICARE_GVT |
Character(1) |
VARCHAR2(1) NOT NULL |
Medicare Qualified Gov't Emp
Y/N Table Edit
Default Value: N
|
| 25 |
I9_COMPL_DT |
Date(10) |
DATE |
I9 Date Completed
|
| 26 |
ALT_DOC_DT |
Date(10) |
DATE |
Alt Doc Expiration
|
| 27 |
SERVICE_DT |
Date(10) |
DATE |
Service Date
|
| 28 |
HOME_HOST_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Home/Host Classification
M=Home
S=Host
Default Value: M
|