EMPLIDPrompt Table: PERSON
COMPANYPrompt Table: COMPANY_TBL
EFFDTDefault Value: %date
Y/N Table Edit
H=Head of Household
M=Married
S=Single
X=Exempt
N=Standard withholding rate
Y=Higher withholding rate
PY_LOCK_LIMITS(SQL Table) |
Index Back |
|---|---|
Lock in Letter RepositoryFED_TAX_DATA Sybiling Record used to store the Lock in letter information for Federal Tax Data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | LOCK_IN_RECVD | Character(1) | VARCHAR2(1) NOT NULL |
Lock-In Letter Received
Y/N Table Edit |
| 5 | FWT_MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
FWT Marital Status
H=Head of Household M=Married S=Single X=Exempt |
| 6 | FWT_WH_RATE | Character(1) | VARCHAR2(1) NOT NULL |
2020 W4 changes - Multiple Jobs Indicator
N=Standard withholding rate Y=Higher withholding rate |
| 7 | FWT_TTL_DEP_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | 2020 W4 - Total Dependent Amount |
| 8 | FWT_OTH_INCOME | Number(11,2) | DECIMAL(10,2) NOT NULL | 2020 W4 - Other Income |
| 9 | FWT_DED_ADJ | Number(11,2) | DECIMAL(10,2) NOT NULL | 2020 W4 - Deduction Adjustment |
| 10 | FWT_ADDL_AMT | Number(8,2) | DECIMAL(7,2) NOT NULL | FWT Additional Amount |