EMPLIDCOMPANYEFFDTDefault Value: %date
STATEGPUS_SEQ_NBRGPUS_SWT_EE_OTH(SQL Table) |
Index Back |
|---|---|
EE State Tax Data Addl FieldsEmployee State Tax Data Additional Fields for specific states |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 5 | GPUS_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Sequesnce Number |
| 6 | GPUS_ADOPT_CHLD_EX | Number(3,0) | SMALLINT NOT NULL | Adopted Child Exemptions for State Tax Data. Specific to Indiana |
| 7 | GPUS_WHLD_AMT_OVRD | Number(9,0) | DECIMAL(9) NOT NULL | Withholding Amount Override for State Taxes |