WCB_ERCA_EC (SQL Table)	Index Back
Staging - Event Cause Staging table for the BC WCB Worker's Compenstation board input. Employer Reportable Event Cause - details on the fundamental cause or causes of the accident.

WCB_ERCA_EC

(SQL Table)

Staging - Event Cause

Staging table for the BC WCB Worker's Compenstation board input. Employer Reportable Event Cause - details on the fundamental cause or causes of the accident.

Parent record: INCIDENT_DATA

# 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
Prompt Table: INCIDENT_DATA

3 HAZARD_ID Character(5) VARCHAR2(5) NOT NULL Hazard ID
Prompt Table: HAZ_CON_MAT_TBL

4 INCIDENT_CAUSE Character(40) VARCHAR2(40) NOT NULL Incident Cause

#	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 Prompt Table: INCIDENT_DATA
3	HAZARD_ID	Character(5)	VARCHAR2(5) NOT NULL	Hazard ID Prompt Table: HAZ_CON_MAT_TBL
4	INCIDENT_CAUSE	Character(40)	VARCHAR2(40) NOT NULL	Incident Cause