FIRM_RPTEFFDTOP_LOCN_TRANSWCB_EMPREL_OPN(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIRM_RPT |
Number(6,0) | INTEGER NOT NULL | Employer ID Reporting |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | OP_LOCN_TRANS |
Number(3,0) | SMALLINT NOT NULL | Operating Location |
| 4 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 5 | END_DATE | Date(10) | DATE | End Date |
| 6 | CLASS_SUBCLASS | Number(6,0) | INTEGER NOT NULL | Class/Subclass |
| 7 | CLSUB_START_DATE | Date(10) | DATE | Start Date |
| 8 | CLSUB_END_DATE | Date(10) | DATE | End Date |