WCB_WOFA_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	FA_DESIG_SEQNUM	Number(2,0)	SMALLINT NOT NULL	First Aider Designate Seqnum
5	UNCONSCIOUS_SW	Character(1)	VARCHAR2(1) NOT NULL	Patient Fell Unconscious
6	UNCONSCIOUS_HRS	Number(3,0)	SMALLINT NOT NULL	Hours Unconscious
7	UNCONSCIOUS_MINS	Number(3,0)	SMALLINT NOT NULL	Minutes Unconscious
8	TRANSPORT_HRS	Number(2,0)	SMALLINT NOT NULL	Transportation Time - Hours
9	TRANSPORT_MIN	Number(2,0)	SMALLINT NOT NULL	Transportation Time - Minutes
10	AMBULANCE_CNTC_DTC	Character(10)	VARCHAR2(10) NOT NULL	Ambulance Contact Dt C
11	AMBULANCE_CNTCT5	Character(5)	VARCHAR2(5) NOT NULL	Ambulance Contact Time
12	AMBULANCE_ARRIVE5	Character(5)	VARCHAR2(5) NOT NULL	Ambulance Arrival Time
13	AMBULANCE_ARRV_DTC	Character(10)	VARCHAR2(10) NOT NULL	Ambulance Arrival Dt C
14	ATTENDANT_OBS_SW	Character(1)	VARCHAR2(1) NOT NULL	Attendant Observe Unconscious
15	WRKR_ARRIVE_FA	Character(2)	VARCHAR2(2) NOT NULL	How Worker Arrived First Aid 05=Walking 10=Carried 15=Stretcher 20=Truck 25=Car 30=Assisted by helper 35=Emergency Transport Vehicle 40=Air Evacuation 45=Industrial Ambulance 50=Ambulance 55=Other
16	WRKR_LEAVE_FA	Character(2)	VARCHAR2(2) NOT NULL	How Worker Left First Aid 05=Walking 10=Carried 15=Stretcher 20=Truck 25=Car 30=Assisted by helper 35=Emergency Transport Vehicle 40=Air Evacuation 45=Industrial Ambulance 50=Ambulance 55=Other