WCB_EERE_WD

(SQL Table)
Index Back

EERE working document

EDI Working Document for the BC WCB Worker's Compenstation board input.

# 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

Default Value: RH#

3 WCB_REC_TYP_ID Character(4) VARCHAR2(4) NOT NULL WCB Record Type ID

Default Value: EERE

4 WCB_REC_VERSION Number(3,0) SMALLINT NOT NULL WCB Record Version

Default Value: 020

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 INCIDENT_DT_C Character(10) VARCHAR2(10) NOT NULL Incident Date Masked
9 INCIDENT_TIME4 Character(5) VARCHAR2(5) NOT NULL Incident Time 4
10 CLASS_SUBCLASS Number(6,0) INTEGER NOT NULL Class/Subclass
11 EXPOSURE_ST_DT_C Character(10) VARCHAR2(10) NOT NULL Exposure Start Date Masked
12 EXPOSURE_ST_TM4 Character(5) VARCHAR2(5) NOT NULL Exposure Start Time 4
13 EXPOSURE_END_DT_C Character(10) VARCHAR2(10) NOT NULL Exposure End Date Masked
14 EXPOSURE_END_TM4 Character(5) VARCHAR2(5) NOT NULL Exposure End Time 4
15 BUSINESS_TYPE Character(30) VARCHAR2(30) NOT NULL Business Type For Event
16 OCCURRENCE_TYPE Character(2) VARCHAR2(2) NOT NULL Occurrence Type Code
17 EXP_DTTM_EXACT_SW Character(1) VARCHAR2(1) NOT NULL Exposure Date/Time Exact
18 WITNESS_INDICATOR Character(1) VARCHAR2(1) NOT NULL Witness Indicator
19 WCB_REC_SEQ_NUM2 Number(4,0) SMALLINT NOT NULL WCB Record Sequence #2 Trailer
20 WCB_REC_TRLR Character(3) VARCHAR2(3) NOT NULL WCB Record Trailer

Default Value: #RT

21 WCBFILLER Character(2) VARCHAR2(2) NOT NULL WCB Filler