WCB_ERLO_EC(SQL Table) |
Index Back |
|---|---|
Staging Table - ERLOStaging table for the BC WCB Worker's Compenstation board input. Event Location - description of the location where the event occured. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ECTRANSID | Character(15) | VARCHAR2(15) NOT NULL | Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders) |
| 2 | INCIDENT_NBR | Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 3 | INC_LOCN_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Code that identifies the loation where the injury/incident occurred
VALID CODES
OLC - operating location
TWS - temporary worksite
OEP - off employer premises
OLC=Operating Location |
| 4 | INCDNT_OP_LOCN_SW | Character(1) | VARCHAR2(1) NOT NULL | Incident At Operating Locn |
| 5 | SCENE_DESCR | Character(200) | VARCHAR2(200) NOT NULL | Description of Accident Scene |
| 6 | INCDNT_TMP_SITE_SW | Character(1) | VARCHAR2(1) NOT NULL | Accident At Temporary Site |
| 7 | EMPLOYER_PREMISES | Character(1) | VARCHAR2(1) NOT NULL | Occurred on Employer Premises |
| 8 | STREET_NBR | Character(7) | VARCHAR2(7) NOT NULL | Street Number |
| 9 | STREET_NAME | Character(30) | VARCHAR2(30) NOT NULL | Street Name |
| 10 | STREET_UNIT_NBR | Character(6) | VARCHAR2(6) NOT NULL | Street Unit_number |
| 11 | WCB_PO_BOX | Character(5) | VARCHAR2(5) NOT NULL | P.O.Box (for WCB Purposes) |
| 12 | WCB_RR_NBR | Character(4) | VARCHAR2(4) NOT NULL | Rural Route Number - WCB |
| 13 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 14 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 15 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 16 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 17 | EXACT_LOCATION | Character(240) | VARCHAR2(240) NOT NULL | Exact Location |
| 18 | WCB_LONG_TEXT | Long Character(250) | VARCHAR2(250) | WCB Long Text |