WCB_ERLC_WD

(SQL Table)
Index Back

EDI Working Definition ERLC

EDI Working Definition table for the BC WCB Worker's Compenstation board input. ERLC

# 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 CLAIM_CNTCT_NAME Character(50) VARCHAR2(50) NOT NULL Claim Contact Name
9 CLAIM_CNTCT_PHONE Character(24) VARCHAR2(24) NOT NULL Claim Contact Phone
10 HS_CNTCT_NAME Character(50) VARCHAR2(50) NOT NULL H&&S Contact Name
11 HS_CONTACT_PHONE Character(24) VARCHAR2(24) NOT NULL H&&S Contact Phone
12 DISABLED_PROG_SW Character(1) VARCHAR2(1) NOT NULL Program For Disabled Indicator
13 DISABLD_CNTCT_NAME Character(50) VARCHAR2(50) NOT NULL Disabled Contact Name
14 DISABLD_CNTCT_PHON Character(24) VARCHAR2(24) NOT NULL Disabled contact Phone
15 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
16 DISABLED_PGM_DESC Character(250) VARCHAR2(250) NOT NULL Disabled Pgm Desc
17 RTW_AVAILABLE_SW Character(1) VARCHAR2(1) NOT NULL Return To Work Program Availab
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