STATECOMPANYR_TAX810ST(SQL Table) |
Index Back |
|---|---|
Temp table - TAX810xx SQRsThis temporary table is used to store the State and Company codes for those states that are filing separate files for multiple companies. The table is used by several SQRs in the TAX810xx series (state unemployment wage files) to determine the file names for those states. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |