WCB_ERET_EC (SQL Table)	Index Back
Staging Tbl - ERET Staging table for the BC WCB Worker's Compenstation board input. Event Text Record - text description of the event

WCB_ERET_EC

(SQL Table)

Staging Tbl - ERET

Staging table for the BC WCB Worker's Compenstation board input. Event Text Record - text description of the 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 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

3 WCB_ERET_SEQNUM Character(3) VARCHAR2(3) NOT NULL WCB_ERET_SEQNUM

4 ERET_DESC_TXT Character(75) VARCHAR2(75) NOT NULL ERET description text

#	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	WCB_ERET_SEQNUM	Character(3)	VARCHAR2(3) NOT NULL	WCB_ERET_SEQNUM
4	ERET_DESC_TXT	Character(75)	VARCHAR2(75) NOT NULL	ERET description text