WCB_WOIN_WD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ECFILEROWID	Character(3)	VARCHAR2(3) NOT NULL	Electronic Commerce File Row ID. Used in EDI Manager. There must be one work record for every PeopleSoft Business Document file. The first field in the record is the Record_Id and the rest of the fields must match the corresponding business document, in the same order and length.
2	WCB_REC_HDR	Character(3)	VARCHAR2(3) NOT NULL	WCB Record Header
3	WCB_REC_TYP_ID	Character(4)	VARCHAR2(4) NOT NULL	WCB Record Type ID
4	WCB_REC_VERSION	Number(3,0)	SMALLINT NOT NULL	WCB Record Version
5	WCB_VAR_REC_LENGTH	Number(4,0)	SMALLINT NOT NULL	WCB Variable Record Length
6	WCB_REC_SEQ_NUM	Character(4)	VARCHAR2(4) NOT NULL	WCB Record Sequence Number Tr
7	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	WRKR_INJ_DT_C	Character(10)	VARCHAR2(10) NOT NULL	Worker Injury Date C
10	WRKR_INJ_TM5	Character(5)	VARCHAR2(5) NOT NULL	Worker Injury Time
11	DT_TIME_EXACT_SW	Character(1)	VARCHAR2(1) NOT NULL	Date Time Exact
12	CLASS_SUBCLASS	Number(6,0)	INTEGER NOT NULL	Class/Subclass
13	SCENE_DESCR	Character(200)	VARCHAR2(200) NOT NULL	Description of Accident Scene
14	CUST_COST_CENTRE	Character(15)	VARCHAR2(15) NOT NULL	WCB Customer Cost Centre Code
15	DISAB_PRIOR_INJ	Character(1)	VARCHAR2(1) NOT NULL	Disability Prior To Injury
16	DISAB_DESCR	Character(250)	VARCHAR2(250) NOT NULL	Prior Disability Description
17	EMPR_OBJECT	Character(1)	VARCHAR2(1) NOT NULL	Employer Object
18	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
19	WRKR_EXP_ST_DT_C	Character(10)	VARCHAR2(10) NOT NULL	Worker Exposure Start Dt C
20	WRKR_EXP_ST_TM5	Character(5)	VARCHAR2(5) NOT NULL	Worker Exposure Start Time
21	WRKR_EXP_END_DT_C	Character(10)	VARCHAR2(10) NOT NULL	Worker Exposure End Dt C
22	WRKR_EXP_END_TM5	Character(5)	VARCHAR2(5) NOT NULL	Worker Exposure End Time
23	HOSPITAL	Character(30)	VARCHAR2(30) NOT NULL	Hospital Name
24	NEAR_HOSP_DIS_WCB	Number(5,0)	INTEGER NOT NULL	Nearest Hospital Distance
25	NEAREST_HOSP_NAME	Character(30)	VARCHAR2(30) NOT NULL	Nearest Hospital Name
26	NEAR_PRACT_DIS_WCB	Number(5,0)	INTEGER NOT NULL	Nearest Practitioner Distance
27	NONEMPL_RESP_IND	Character(1)	VARCHAR2(1) NOT NULL	Non-Employee Responsible Ind
28	WRKR_PRE_HEALTH	Character(1)	VARCHAR2(1) NOT NULL	Worker PreExisting Health Cond
29	WRKR_PRE_DESCR	Character(250)	VARCHAR2(250) NOT NULL	Desc. Of PreExisting Hlth Cndn
30	WRKR_MED_ATTN	Character(1)	VARCHAR2(1) NOT NULL	Worker Seek Medical Attention
31	TREATMENT_DT_CH	Character(10)	VARCHAR2(10) NOT NULL	Treatment Date Ch
32	TREATMENT_TM5	Character(5)	VARCHAR2(5) NOT NULL	Treatment Time
33	WITNESS_CONF_STMT	Character(1)	VARCHAR2(1) NOT NULL	Witness Confirm Injury Stmt
34	INJURY_WITNESS	Character(1)	VARCHAR2(1) NOT NULL	Witnesses to the Injury
35	WCB_CLAIM_NBR	Number(8,0)	INTEGER NOT NULL	WCB Claim Number
36	ACCIDENT_TYPE_CD	Character(5)	VARCHAR2(5) NOT NULL	Accident Type
37	BUS_INJ_DESCR_CAN	Character(30)	VARCHAR2(30) NOT NULL	Description of Business Injury
38	FIRST_AID	Character(1)	VARCHAR2(1) NOT NULL	Receive First Aid
39	WCB_REC_SEQ_NUM2	Number(4,0)	SMALLINT NOT NULL	WCB Record Sequence #2 Trailer
40	WCB_REC_TRLR	Character(3)	VARCHAR2(3) NOT NULL	WCB Record Trailer
41	WCBFILLER	Character(2)	VARCHAR2(2) NOT NULL	WCB Filler