W2C_AMOUNTS(SQL Table) |
Index Back |
|---|---|
Amounts on the W-2cThis defines the employee W-2c dollar amount changes. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  W2C_BATCH_NBR |
Number(4,0) | SMALLINT NOT NULL |
W-2c Batch Number
Default Value: W2C_INSTALL.W2C_BATCH_NBR |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | CALENDAR_YEAR |
Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 4 | W2C_ADD_EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Emplid (preferred)
Prompt Table: PERSON |
| 5 | PRV_SSN |
Character(9) | VARCHAR2(9) NOT NULL |
or SSN
Default Value: W2C_DATA.PRV_SSN |
| 6 | BOX |
Character(4) | VARCHAR2(4) NOT NULL |
Box
Prompt Table: W2C_TAXFORM_VW |
| 7 | STATE |
Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: W2C_STATE_NM_VW |
| 8 | LOCALITY |
Character(10) | VARCHAR2(10) NOT NULL |
Locality
Prompt Table: W2C_LOCAL_TX_VW |
| 9 | PRV_AMOUNT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Previous Amount |
| 10 | CURRENT_AMOUNT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Current Amount |