WCB_IWLE_EC(SQL Table) |
Index Back |
|---|---|
Staging Table - IWLEStaging table for the BC WCB Worker's Compenstation board input. Injured Worker's Long Term Earnings |
| # | 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 | LONG_TERM_SEQNUM | Number(2,0) | SMALLINT NOT NULL | Long Term Earnings Seqnum |
| 5 | LONG_TRM_ERNS_WCB | Number(8,0) | INTEGER NOT NULL | Long Term Earnings WCB |
| 6 | PERIOD_START_DT | Date(10) | DATE | Period Start Date |
| 7 | PERIOD_END_DATE | Date(10) | DATE | Period End Date |
| 8 | PERIOD_START_DT_C | Character(10) | VARCHAR2(10) NOT NULL | Period Start Date C |
| 9 | PERIOD_END_DATE_C | Character(10) | VARCHAR2(10) NOT NULL | Period End Date C |
| 10 | DATE_CHG_REASON | Character(200) | VARCHAR2(200) NOT NULL | Date Change Reason |
| 11 | THREE_MON_WG_CD | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether the amount in 3 month total gross wage amount represents the wages accumulated in 12 weeks or 3 months
Valid codes:
W = 12 weeks
M = 3 months
W=12 Weeks |