WCB_EERE_EC (SQL Table)	Index Back
Staging - Employer reprt even Staging table for the BC WCB Worker's Compenstation board input. Employer Reportable Event - general information agbout the employer reportable event.

WCB_EERE_EC

(SQL Table)

Staging - Employer reprt even

Staging table for the BC WCB Worker's Compenstation board input. Employer Reportable Event - general information agbout the employer reportable event.

# 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 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.

3 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound

4 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

5 INCIDENT_DT_C Character(10) VARCHAR2(10) NOT NULL Incident Date Masked

6 INCIDENT_TIME4 Character(5) VARCHAR2(5) NOT NULL Incident Time 4

7 CLASS_SUBCLASS Number(6,0) INTEGER NOT NULL Class/Subclass

8 EXPOSURE_ST_DT_C Character(10) VARCHAR2(10) NOT NULL Exposure Start Date Masked

9 EXPOSURE_ST_TM4 Character(5) VARCHAR2(5) NOT NULL Exposure Start Time 4

10 EXPOSURE_END_DT_C Character(10) VARCHAR2(10) NOT NULL Exposure End Date Masked

11 EXPOSURE_END_TM4 Character(5) VARCHAR2(5) NOT NULL Exposure End Time 4

12 BUSINESS_TYPE Character(30) VARCHAR2(30) NOT NULL Business Type For Event

13 OCCURRENCE_TYPE Character(2) VARCHAR2(2) NOT NULL Occurrence Type Code

14 EXP_DTTM_EXACT_SW Character(1) VARCHAR2(1) NOT NULL Exposure Date/Time Exact

15 WITNESS_INDICATOR Character(1) VARCHAR2(1) NOT NULL Witness Indicator

16 DAN_OCR_TYPE_CAN Character(2) VARCHAR2(2) NOT NULL A code that identifies the type of near miss/dangerous occurrence Aliases: Near Miss Valid Codes 10 - Structural Failure or Collapse 20 - Release of Toxic or Hazardous Substance 30 - Blasting Accident 40 - Diving Accident 50 - Other Potential for Serious Injury
10=Structural Failure

17 WRKRS_INVLD_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether one or more employees (workers) were involved in the reported incident valid codes Y = yes N = No

18 INCIDENT_TYPE Character(1) VARCHAR2(1) NOT NULL Incident Type
A=Accident
B=Industrial Accident
C=Contamination
D=Industrial Accident (Official)
E=Exposure
H=Hazardous Condition
I=Incident
L=Illness
M=Near Miss
N=Injury
O=Dangerous Occurrence
P=Unsafe Practice
R=Environmental
S=Safety Violation
V=Vehicle/Equipment Accident

#	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	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
3	ECTRANSINOUTSW	Character(1)	VARCHAR2(1) NOT NULL	Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound. I=Inbound O=Outbound
4	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number
5	INCIDENT_DT_C	Character(10)	VARCHAR2(10) NOT NULL	Incident Date Masked
6	INCIDENT_TIME4	Character(5)	VARCHAR2(5) NOT NULL	Incident Time 4
7	CLASS_SUBCLASS	Number(6,0)	INTEGER NOT NULL	Class/Subclass
8	EXPOSURE_ST_DT_C	Character(10)	VARCHAR2(10) NOT NULL	Exposure Start Date Masked
9	EXPOSURE_ST_TM4	Character(5)	VARCHAR2(5) NOT NULL	Exposure Start Time 4
10	EXPOSURE_END_DT_C	Character(10)	VARCHAR2(10) NOT NULL	Exposure End Date Masked
11	EXPOSURE_END_TM4	Character(5)	VARCHAR2(5) NOT NULL	Exposure End Time 4
12	BUSINESS_TYPE	Character(30)	VARCHAR2(30) NOT NULL	Business Type For Event
13	OCCURRENCE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Occurrence Type Code
14	EXP_DTTM_EXACT_SW	Character(1)	VARCHAR2(1) NOT NULL	Exposure Date/Time Exact
15	WITNESS_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Witness Indicator
16	DAN_OCR_TYPE_CAN	Character(2)	VARCHAR2(2) NOT NULL	A code that identifies the type of near miss/dangerous occurrence Aliases: Near Miss Valid Codes 10 - Structural Failure or Collapse 20 - Release of Toxic or Hazardous Substance 30 - Blasting Accident 40 - Diving Accident 50 - Other Potential for Serious Injury 10=Structural Failure
17	WRKRS_INVLD_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether one or more employees (workers) were involved in the reported incident valid codes Y = yes N = No
18	INCIDENT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Incident Type A=Accident B=Industrial Accident C=Contamination D=Industrial Accident (Official) E=Exposure H=Hazardous Condition I=Incident L=Illness M=Near Miss N=Injury O=Dangerous Occurrence P=Unsafe Practice R=Environmental S=Safety Violation V=Vehicle/Equipment Accident