EMPLIDCOMPANYEFFDTDefault Value: %date
STATEPY_PFF_PROGIDE=Exempt
N=Not Applicable
V=Voluntary
Y=Subject
Default Value: N
A=Active
I=Inactive
PY_PFF_STTX_STA(SQL Table) |
Index Back |
|---|---|
Empl Tax Data Prog Id statusUpdate Employee Tax Data Program Id status |
| # | 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 | PY_PFF_PROGID |
Character(4) | VARCHAR2(4) NOT NULL | Program ID |
| 6 | PY_PFF_PLAN | Character(1) | VARCHAR2(1) NOT NULL |
Plan
E=Exempt N=Not Applicable V=Voluntary Y=Subject Default Value: N |
| 7 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |