COMPANYSUT_STATELOCATION_STATETAX_LOCATION_CDR_TAX004(SQL Table) |
Index Back |
|---|---|
Temp Table - SQR TAX004Temporary table required for processing of TAX004.SQR - Multiple Worksite Report. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | SUT_STATE |
Character(6) | VARCHAR2(6) NOT NULL | SUT State |
| 3 | LOCATION_STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 4 | TAX_LOCATION_CD |
Character(10) | VARCHAR2(10) NOT NULL | Tax Location Code |
| 5 | OUT_OF_STATE_LOC | Character(1) | VARCHAR2(1) NOT NULL | Out-of-state Location |
| 6 | WORKERS_MONTH1 | Number(6,0) | INTEGER NOT NULL | Workers in Month-1 |
| 7 | WORKERS_MONTH2 | Number(6,0) | INTEGER NOT NULL | Workers in Month-2 |
| 8 | WORKERS_MONTH3 | Number(6,0) | INTEGER NOT NULL | Workers in Month-3 |
| 9 | QTRLY_WAGES | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Quarterly Wages |