WCB_WOIN_EC

#	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	WRKR_INJ_DT	Date(10)	DATE	Worker Injury Date
5	WRKR_INJ_DT_C	Character(10)	VARCHAR2(10) NOT NULL	Worker Injury Date C
6	WRKR_INJ_TM5	Character(5)	VARCHAR2(5) NOT NULL	Worker Injury Time
7	DT_TIME_EXACT_SW	Character(1)	VARCHAR2(1) NOT NULL	Date Time Exact
8	CLASS_SUBCLASS	Number(6,0)	INTEGER NOT NULL	Class/Subclass
9	SCENE_DESCR	Character(200)	VARCHAR2(200) NOT NULL	Description of Accident Scene
10	CUST_COST_CENTRE	Character(15)	VARCHAR2(15) NOT NULL	WCB Customer Cost Centre Code
11	DISAB_PRIOR_INJ	Character(1)	VARCHAR2(1) NOT NULL	Disability Prior To Injury
12	DISAB_DESCR	Character(250)	VARCHAR2(250) NOT NULL	Prior Disability Description
13	EMPR_OBJECT	Character(1)	VARCHAR2(1) NOT NULL	Employer Object
14	EVENT_OUTCOME	Character(4)	VARCHAR2(4) NOT NULL	Incident_Outcome DO=Dangerous Occurrence FAT=Fatality HCO=Health Care Only RPO=Reported Only STD=Short Term Disability
15	WRKR_EXP_ST_DT_C	Character(10)	VARCHAR2(10) NOT NULL	Worker Exposure Start Dt C
16	WRKR_EXP_ST_TM5	Character(5)	VARCHAR2(5) NOT NULL	Worker Exposure Start Time
17	WRKR_EXP_END_DT_C	Character(10)	VARCHAR2(10) NOT NULL	Worker Exposure End Dt C
18	WRKR_EXP_END_TM5	Character(5)	VARCHAR2(5) NOT NULL	Worker Exposure End Time
19	HOSPITAL	Character(30)	VARCHAR2(30) NOT NULL	Hospital Name
20	NEAR_HOSP_DIS_WCB	Number(5,0)	INTEGER NOT NULL	Nearest Hospital Distance
21	NEAREST_HOSP_NAME	Character(30)	VARCHAR2(30) NOT NULL	Nearest Hospital Name
22	NEAR_PRACT_DIS_WCB	Number(5,0)	INTEGER NOT NULL	Nearest Practitioner Distance
23	NONEMPL_RESP_IND	Character(1)	VARCHAR2(1) NOT NULL	Non-Employee Responsible Ind
24	WRKR_PRE_HEALTH	Character(1)	VARCHAR2(1) NOT NULL	Worker PreExisting Health Cond
25	WRKR_PRE_DESCR	Character(250)	VARCHAR2(250) NOT NULL	Desc. Of PreExisting Hlth Cndn
26	WRKR_MED_ATTN	Character(1)	VARCHAR2(1) NOT NULL	Worker Seek Medical Attention
27	TREATMENT_DT_CH	Character(10)	VARCHAR2(10) NOT NULL	Treatment Date Ch
28	TREATMENT_TM5	Character(5)	VARCHAR2(5) NOT NULL	Treatment Time
29	WITNESS_CONF_STMT	Character(1)	VARCHAR2(1) NOT NULL	Witness Confirm Injury Stmt
30	INJURY_WITNESS	Character(1)	VARCHAR2(1) NOT NULL	Witnesses to the Injury
31	WCB_CLAIM_NBR	Number(8,0)	INTEGER NOT NULL	WCB Claim Number
32	ACCIDENT_TYPE_CD	Character(5)	VARCHAR2(5) NOT NULL	Accident Type
33	BUS_INJ_DESCR_CAN	Character(30)	VARCHAR2(30) NOT NULL	Description of Business Injury
34	FIRST_AID	Character(1)	VARCHAR2(1) NOT NULL	Receive First Aid