WCB_ERPT_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	PARTCPNT_TYPE_CD	Character(2)	VARCHAR2(2) NOT NULL	Participant Type Code
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	PARTICIPANT_ID	Character(11)	VARCHAR2(11) NOT NULL	Incident Participant ID
6	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
7	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
8	STREET_NBR	Character(7)	VARCHAR2(7) NOT NULL	Street Number
9	STREET_NAME	Character(30)	VARCHAR2(30) NOT NULL	Street Name
10	STREET_UNIT_NBR	Character(6)	VARCHAR2(6) NOT NULL	Street Unit_number
11	WCB_PO_BOX	Character(5)	VARCHAR2(5) NOT NULL	P.O.Box (for WCB Purposes)
12	WCB_RR_NBR	Character(4)	VARCHAR2(4) NOT NULL	Rural Route Number - WCB
13	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
14	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
15	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
16	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
17	OTHER_ADDR_TXT	Character(90)	VARCHAR2(90) NOT NULL	Other Address Text
18	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
19	INVSTG_LAB_REP	Character(1)	VARCHAR2(1) NOT NULL	Investigator Labour Rep
20	INVSTG_MGMT_REP	Character(1)	VARCHAR2(1) NOT NULL	Investigator A Management Rep
21	WCB_INVSGTR_TYPE	Character(3)	VARCHAR2(3) NOT NULL	classification of the type of employer investigator LBR = Worker Representative MNG = Employer Representative OTH = other OTH=Other
22	NON_EMPL_RESP_TXT	Character(100)	VARCHAR2(100) NOT NULL	Non-Employee Responsible Text