WCB_INWO_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	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
5	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
6	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
7	STREET_NBR	Character(7)	VARCHAR2(7) NOT NULL	Street Number
8	STREET_NAME	Character(30)	VARCHAR2(30) NOT NULL	Street Name
9	STREET_UNIT_NBR	Character(6)	VARCHAR2(6) NOT NULL	Street Unit_number
10	WCB_PO_BOX	Character(5)	VARCHAR2(5) NOT NULL	P.O.Box (for WCB Purposes)
11	WCB_RR_NBR	Character(4)	VARCHAR2(4) NOT NULL	Rural Route Number - WCB
12	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
13	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
14	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
15	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
16	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
17	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
18	BIRTHDATE_C	Character(10)	VARCHAR2(10) NOT NULL	Birthdate C
19	DT_OF_DEATH_C	Character(10)	VARCHAR2(10) NOT NULL	Date of Death C
20	SIN	Character(9)	VARCHAR2(9) NOT NULL	Social Insurance Nbr
21	HEALTH_CARE_NBR	Character(12)	VARCHAR2(12) NOT NULL	Health Care Number
22	EXTRA_ADDRESS_INFO	Long Character	CLOB	Extra Address Information