WCB_SYSTEM_CD(SQL Table) |
Index Back |
|---|---|
System CodesThis record is to capture information of system codes and data population automatically happens by parsing the xml response from WCB. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SYSTEM_CAT |
Character(4) | VARCHAR2(4) NOT NULL |
System Category
ACEX=Incident Category Type Code ERED=Near Miss/Dangerous Occurrance INLO=Incident Location Type Code ISSB=ISSv3 Basic Wage ISSG=ISSv3 Gross Wage ISSI=Investigator Type ISSR=Room & Board Indicator ISSS=Differential Premium Indicator ISST=Tips & Gratuities OCCA=Occupational Category SEXT=Gender Code WKRC=Worker Category WSCH=Work Schedule |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | SYS_CODE_VAL |
Character(4) | VARCHAR2(4) NOT NULL | System Code Value |
| 4 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 5 | END_DATE | Date(10) | DATE | End Date |
| 6 | WCB_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Description |