WCB_WODT_EC (SQL Table)	Index Back
Staging Table - WODT Staging table for the BC WCB Worker's Compenstation board input. Worker Injury Details - nature and location of each injury

WCB_WODT_EC

(SQL Table)

Staging Table - WODT

Staging table for the BC WCB Worker's Compenstation board input. Worker Injury Details - nature and location of each injury

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 SEQNUM_WODT_WCB Number(2,0) SMALLINT NOT NULL WODT Sequence Number

5 WCB_INJ_NATURE Character(5) VARCHAR2(5) NOT NULL WCB Injury Nature

6 WCB_BODY_PART Character(5) VARCHAR2(5) NOT NULL WCB Body Part

7 SIDE_OF_BODY Character(1) VARCHAR2(1) NOT NULL Side of Body
B=Back
F=Front
L=Left
R=Right

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	SEQNUM_WODT_WCB	Number(2,0)	SMALLINT NOT NULL	WODT Sequence Number
5	WCB_INJ_NATURE	Character(5)	VARCHAR2(5) NOT NULL	WCB Injury Nature
6	WCB_BODY_PART	Character(5)	VARCHAR2(5) NOT NULL	WCB Body Part
7	SIDE_OF_BODY	Character(1)	VARCHAR2(1) NOT NULL	Side of Body B=Back F=Front L=Left R=Right