YE_W2CP_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: YE_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: YE_W2CP_DATA.PRV_SSN |
| 6 | W2C_TAXFORM_ID |
Character(1) | VARCHAR2(1) NOT NULL |
Tax Form Identification
I=W-2VI M=W-2GU P=W-2PR S=W-2AS W=W-2 Default Value: YE_W2CP_DATA.W2C_TAXFORM_ID |
| 7 | BOX |
Character(4) | VARCHAR2(4) NOT NULL |
Box
Prompt Table: YE_W2CP_TXFRM_V |
| 8 | STATE |
Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: W2C_STATE_NM_VW |
| 9 | LOCALITY |
Character(10) | VARCHAR2(10) NOT NULL |
Locality
Prompt Table: W2C_LOCAL_TX_VW |
| 10 | PRV_AMOUNT | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Previous Amount |
| 11 | CURRENT_AMOUNT | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Current Amount |