WCB_ERLC_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	CLAIM_CNTCT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Claim Contact Name
4	CLAIM_CNTCT_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Claim Contact Phone
5	RPT_EMPLR_FAX_NO	Character(3)	VARCHAR2(3) NOT NULL	Reporting Employer Fax Number
6	RPT_EMPLR_FAX_CD	Character(3)	VARCHAR2(3) NOT NULL	Reporting Employer Fax Area Cd
7	RPT_EMPLR_TEL_EXTN	Character(5)	VARCHAR2(5) NOT NULL	Reporting Employer Telephone Extension
8	HS_CNTCT_NAME	Character(50)	VARCHAR2(50) NOT NULL	H&&S Contact Name
9	HS_CONTACT_PHONE	Character(24)	VARCHAR2(24) NOT NULL	H&&S Contact Phone
10	DISABLED_PROG_SW	Character(1)	VARCHAR2(1) NOT NULL	Program For Disabled Indicator
11	DISABLD_CNTCT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Disabled Contact Name
12	DISABLD_CNTCT_PHON	Character(24)	VARCHAR2(24) NOT NULL	Disabled contact Phone
13	PYRL_CNT_FRST_NAM	Character(25)	VARCHAR2(25) NOT NULL	Payroll Contact First Name
14	PYRL_CNT_LAST_NAM	Character(25)	VARCHAR2(25) NOT NULL	Payroll Contact Last Name
15	PYRL_CNT_TEL_NO	Character(24)	VARCHAR2(24) NOT NULL	Payroll Contact Telephone Number
16	PYRL_TEL_EXTN	Character(5)	VARCHAR2(5) NOT NULL	Payroll Telephone Extension
17	PYRL_CNT_TEL_AR_CD	Character(3)	VARCHAR2(3) NOT NULL	Payroll Contact Telephone Area Code
18	PYRL_CNT_FAX_AR_CD	Character(3)	VARCHAR2(3) NOT NULL	Payroll Contact Fax Area Code
19	PYRL_CNT_FAX_NO	Character(7)	VARCHAR2(7) NOT NULL	Payroll Contact Fax Number
20	LOCN_SIZE_CD	Character(1)	VARCHAR2(1) NOT NULL	Location Size Code A=A: Less than 6 B=B: 6 to 10 C=C: 11 to 15 D=D: 16 to 20 E=E: 21 to 49 F=F: 50 to 100 G=G: 101 to 200 H=H: More than 200
21	DISABLED_PGM_DESC	Character(250)	VARCHAR2(250) NOT NULL	Disabled Pgm Desc
22	RTW_AVAILABLE_SW	Character(1)	VARCHAR2(1) NOT NULL	Return To Work Program Availab