WCB_ERLC_WD(SQL Table) |
Index Back |
---|---|
EDI Working Definition ERLCEDI 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 |