WCB_ERFA_EC (SQL Table)	Index Back
Staging Tbl - ERFA Staging table for the BC WCB Worker's Compenstation board input. Event Follow-Up Actions taken in response to the accident

WCB_ERFA_EC

(SQL Table)

Staging Tbl - ERFA

Staging table for the BC WCB Worker's Compenstation board input. Event Follow-Up Actions taken in response to the 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 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

3 ACTION_SEQUENCE Number(2,0) SMALLINT NOT NULL Action Sequence

4 CORRECTIVE_ACTION Long Character CLOB Corrective Action

#	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	ACTION_SEQUENCE	Number(2,0)	SMALLINT NOT NULL	Action Sequence
4	CORRECTIVE_ACTION	Long Character	CLOB	Corrective Action