| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
SPECIAL_FWT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Special FWT Status
A=Non-Resident Alien
E=Exempt (not subject to FIT)
G=Maintain gross (no tax WH)
N=None
Default Value: N
|
| 4 |
FWT_MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FWT Marital Status
M=Married
S=Single
|
| 5 |
FWT_ALLOWANCES |
Number(3,0) |
SMALLINT NOT NULL |
FWT Allowances
|
| 6 |
FWT_ADDL_AMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
FWT Additional Amount
|
| 7 |
FWT_ADDL_PCT |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
FWT Additional Percentage
|
| 8 |
FUT_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt from FUT
Y/N Table Edit
Default Value: N
|
| 9 |
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
Default Value: N
|
| 10 |
STATUTORY_EE |
Character(1) |
VARCHAR2(1) NOT NULL |
Statutory Employee
Y/N Table Edit
Default Value: N
|
| 11 |
DECEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Deceased
Y/N Table Edit
Default Value: N
|
| 12 |
PENSION_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Retirement Plan
Y/N Table Edit
Default Value: N
|
| 13 |
LEGAL_REP |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Representative
Y/N Table Edit
Default Value: N
|
| 14 |
DEFERRED_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Deferred Compensation
Y/N Table Edit
Default Value: N
|
| 15 |
USE_TOTAL_WAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Total Wage for Multi-State
Y/N Table Edit
Default Value: N
|
| 16 |
LAST_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Action
C=System
D=Hire Process
O=Online Operator
W=Web User
|
| 17 |
W4_PRCSS |
Character(1) |
VARCHAR2(1) NOT NULL |
W4 Process Flag
N=None
S=Notification Sent
W=New W-4 Received
|
| 18 |
W5_PRCSS |
Character(1) |
VARCHAR2(1) NOT NULL |
W5 Process Flag
N=None
S=Notification Sent
W=New W-5 Received
|
| 19 |
LOCK_IN_RECVD |
Character(1) |
VARCHAR2(1) NOT NULL |
Lock-In Letter Received
Y/N Table Edit
Default Value: N
|
| 20 |
LOCK_IN_LIMIT |
Number(3,0) |
SMALLINT NOT NULL |
Limit On Allowances
|
| 21 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
|
| 22 |
DATE_OF_ENTRY |
Date(10) |
DATE |
Date of Entry
|
| 23 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 24 |
FORM_1001_RECD |
Character(1) |
VARCHAR2(1) NOT NULL |
Form W8 Recd
N=No
X=Not Applicable
Y=Yes
Default Value: N
|
| 25 |
FORM_1001_SUBMT_DT |
Date(10) |
DATE |
W8 In Effect Date
|
| 26 |
FORM_1001_EXP_DT |
Date(10) |
DATE |
Form W8 Expiration Date.
When this expiration date is reached, the Payroll Calculation will use the "Before Form" tax rate to calculate Non Resident Alien tax.
|
| 27 |
FORM_8233_RECD |
Character(1) |
VARCHAR2(1) NOT NULL |
Form 8233 Recd
N=No
X=Not Applicable
Y=Yes
Default Value: N
|
| 28 |
FORM_8233_SUBMT_DT |
Date(10) |
DATE |
Form 8233 Submission Date
|
| 29 |
FORM_8233_EXP_DT |
Date(10) |
DATE |
Form 8233 Expiration Date.
When this expiration date is reached, the Payroll Calculation will use the "Before Form" tax rate to calculate Non Resident Alien tax.
|
| 30 |
TAXPAYER_ID_NO |
Character(9) |
VARCHAR2(9) NOT NULL |
Taxpayer ID Number
|
| 31 |
TREATY_EXP_DT |
Date(10) |
DATE |
Treaty Exp Date
|
| 32 |
TREATY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Treaty ID
|
| 33 |
FORM_1078_RECD |
Character(1) |
VARCHAR2(1) NOT NULL |
Form W9 Received
Y/N Table Edit
Default Value: N
|
| 34 |
FORM_1078_SUBMT_DT |
Date(10) |
DATE |
W9 Submit Date
|
| 35 |
THIRDPARTY_SICKPAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Third-party sick pay
Y/N Table Edit
Default Value: N
|
| 36 |
W4_NAME_CHECK |
Character(1) |
VARCHAR2(1) NOT NULL |
W4 Name Check
Y/N Table Edit
Default Value: N
|
| 37 |
PY_FLAG_FOR_IRS |
Character(1) |
VARCHAR2(1) NOT NULL |
W4 Flagged for Transmission
Y/N Table Edit
Default Value: N
|
| 38 |
PY_FLAG_FOR_IRS_DT |
Date(10) |
DATE |
Flagged for IRS On
|
| 39 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
Default Value: %DATE
|
| 40 |
PAYCHECK_DIST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Mail Option
1=Company Distribution
2=Postal Service
I=Company Distribution
X=Postal Service
|
| 41 |
HOME_HOST_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Home/Host Classification
M=Home
S=Host
|
| 42 |
FWT_EST_AMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
FWT Estimated Amount
|
| 43 |
HOUSEHOLD_EMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Household Employee (942)
Y/N Table Edit
|
| 44 |
MEDICARE_GVT |
Character(1) |
VARCHAR2(1) NOT NULL |
Medicare Qualified Gov't Emp
Y/N Table Edit
|
| 45 |
WITH_NY_DIFF |
Character(1) |
VARCHAR2(1) NOT NULL |
Withhold NY State Tax Diff
Y/N Table Edit
|