WCB_EMDE_EC(SQL Table) |
Index Back |
|---|---|
Staging - Employer DesginateStaging table for the BC WCB Worker's Compenstation board input. Employer Designate - employer representatives to whom the injured worker reported the injuries. |
| # | 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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | DESIGNATE_SEQNUM | Number(2,0) | SMALLINT NOT NULL | Employer Designate Seqnum |
| 5 | DT_REPORTED_C | Character(10) | VARCHAR2(10) NOT NULL | Date Reported C |
| 6 | TIME_REPORTED5 | Character(5) | VARCHAR2(5) NOT NULL | Time Reported |
| 7 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 8 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 9 | DESIG_POSTYP_CD | Character(2) | VARCHAR2(2) NOT NULL |
Employer Designate Posn Type
10=First Aid Attendant 20=Worker's Supervisor 30=Other |
| 10 | FIRST_DESIGNATE_SW | Character(1) | VARCHAR2(1) NOT NULL |
First Designate Reported To
Y/N Table Edit |
| 11 | OTHER_DESIG_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Other Designate Description |
| 12 | FIRST_AID_CERT_NBR | Character(12) | VARCHAR2(12) NOT NULL | First Aid Cerificate Number |