WCB_EDSR_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	SRCE_SFTWR_ID	Character(2)	VARCHAR2(2) NOT NULL	WCB Source Software ID
4	INTERCHNG_SPEC_VER	Character(8)	VARCHAR2(8) NOT NULL	Interchange Spec Version
5	FIRM_NBR_XMIT_CAN	Number(6,0)	INTEGER NOT NULL	Firm Number Transmitting
6	OP_LOCN_TRANS	Number(3,0)	SMALLINT NOT NULL	Operating Location
7	NAME_TRANS	Character(50)	VARCHAR2(50) NOT NULL	Name of Person Transmitting
8	PHONE_TRANS	Character(12)	VARCHAR2(12) NOT NULL	Phone Number Of Person Trnsmt
9	PHONE_EXTN	Number(5,0)	INTEGER NOT NULL	Telephone Extension.
10	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
11	FIRM_RPT	Number(6,0)	INTEGER NOT NULL	Employer ID Reporting
12	OP_LOCN_RPT	Number(3,0)	SMALLINT NOT NULL	Operating Location Reporting
13	REPORT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Report Status A=Active I=Inactive P=In Progress
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	DT_RECORDED_C	Character(10)	VARCHAR2(10) NOT NULL	Date Recorded C
16	TIME_RECORD5	Character(5)	VARCHAR2(5) NOT NULL	Time Recorded
17	DATE_TRANS_C	Character(10)	VARCHAR2(10) NOT NULL	Date Transmitted C
18	TIME_TRANSMIT5_CAN	Character(5)	VARCHAR2(5) NOT NULL	Time Transmitted
19	TEST_PROD_INDCTR	Character(1)	VARCHAR2(1) NOT NULL	WCB Test or Prod Indicator