WCB_EMDE_WD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ECFILEROWID	Character(3)	VARCHAR2(3) NOT NULL	Electronic Commerce File Row ID. Used in EDI Manager. There must be one work record for every PeopleSoft Business Document file. The first field in the record is the Record_Id and the rest of the fields must match the corresponding business document, in the same order and length.
2	WCB_REC_HDR	Character(3)	VARCHAR2(3) NOT NULL	WCB Record Header
3	WCB_REC_TYP_ID	Character(4)	VARCHAR2(4) NOT NULL	WCB Record Type ID
4	WCB_REC_VERSION	Number(3,0)	SMALLINT NOT NULL	WCB Record Version
5	WCB_VAR_REC_LENGTH	Number(4,0)	SMALLINT NOT NULL	WCB Variable Record Length
6	WCB_REC_SEQ_NUM	Character(4)	VARCHAR2(4) NOT NULL	WCB Record Sequence Number Tr
7	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	DESIGNATE_SEQNUM	Number(2,0)	SMALLINT NOT NULL	Employer Designate Seqnum
10	DT_REPORTED_C	Character(10)	VARCHAR2(10) NOT NULL	Date Reported C
11	TIME_REPORTED5	Character(5)	VARCHAR2(5) NOT NULL	Time Reported
12	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
13	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
14	DESIG_POSTYP_CD	Character(2)	VARCHAR2(2) NOT NULL	Employer Designate Posn Type 10=First Aid Attendant 20=Worker's Supervisor 30=Other
15	FIRST_DESIGNATE_SW	Character(1)	VARCHAR2(1) NOT NULL	First Designate Reported To
16	OTHER_DESIG_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Other Designate Description
17	FIRST_AID_CERT_NBR	Character(12)	VARCHAR2(12) NOT NULL	First Aid Cerificate Number
18	WCB_REC_SEQ_NUM2	Number(4,0)	SMALLINT NOT NULL	WCB Record Sequence #2 Trailer
19	WCB_REC_TRLR	Character(3)	VARCHAR2(3) NOT NULL	WCB Record Trailer
20	WCBFILLER	Character(2)	VARCHAR2(2) NOT NULL	WCB Filler