WCB_ERCF_EC (SQL Table)	Index Back
Staging - Event Contrib Factor Staging table for the BC WCB Worker's Compenstation board input. Employer Reportable Event Contributing Factors

WCB_ERCF_EC

(SQL Table)

Staging - Event Contrib Factor

Staging table for the BC WCB Worker's Compenstation board input. Employer Reportable Event Contributing Factors

# 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 CONTRIB_FACTOR_CAN Character(5) VARCHAR2(5) NOT NULL Contributing Factor Code

4 OTHER_CF_DESC_CAN Character(40) VARCHAR2(40) NOT NULL Other Factor Description

#	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	CONTRIB_FACTOR_CAN	Character(5)	VARCHAR2(5) NOT NULL	Contributing Factor Code
4	OTHER_CF_DESC_CAN	Character(40)	VARCHAR2(40) NOT NULL	Other Factor Description