WCB_ERPA_EC (SQL Table)	Index Back
Staging Tbl - ERPA Staging table for the BC WCB Worker's Compenstation board input. Event Preventative Actions - details on the preventative actions that may be taken in future to prevent further accidents of a similar nature.

WCB_ERPA_EC

(SQL Table)

Staging Tbl - ERPA

Staging table for the BC WCB Worker's Compenstation board input. Event Preventative Actions - details on the preventative actions that may be taken in future to prevent further accidents of a similar nature.

# 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 PREVENT_ACTN_CD Character(5) VARCHAR2(5) NOT NULL Preventative Action Code

4 OTHER_PREV_DESCR Character(40) VARCHAR2(40) NOT NULL Other Preventative Action Desc

#	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	PREVENT_ACTN_CD	Character(5)	VARCHAR2(5) NOT NULL	Preventative Action Code
4	OTHER_PREV_DESCR	Character(40)	VARCHAR2(40) NOT NULL	Other Preventative Action Desc