WCB_IWJO_EC(SQL Table) |
Index Back |
|---|---|
Staging Table - IWJOStaging table for the BC WCB Worker's Compenstation board input. Injured Worker's Job Record - details of each injured worker's job and work duties |
| # | 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 | OCCUPATION_CD_CAN | Character(7) | VARCHAR2(7) NOT NULL | Occupation Code |
| 5 | ORIG_HIRE_DT_C | Date(10) | DATE | Original Hire Dt C |
| 6 | JOB_ENTRY_DT_C | Character(10) | VARCHAR2(10) NOT NULL | Job Entry Dt C |
| 7 | JOB_EXIT_DT_C | Character(10) | VARCHAR2(10) NOT NULL | Job Exit Dt C |
| 8 | IND_START_DT_CANC | Character(10) | VARCHAR2(10) NOT NULL | Ind St Dt Can C |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | JOB_DUTIES_DESCR | Character(250) | VARCHAR2(250) NOT NULL | Job Duties Description |
| 11 | ACTIONS_BUSREL_SW | Character(1) | VARCHAR2(1) NOT NULL | Actions Business Related |
| 12 | NON_BUS_WRK_DESCR | Character(250) | VARCHAR2(250) NOT NULL | Non Business Work Description |
| 13 | ACTIONS_ROUTINE_SW | Character(1) | VARCHAR2(1) NOT NULL | Actions Routine |
| 14 | NON_ROUTINE_DESC | Character(250) | VARCHAR2(250) NOT NULL | Description of Non Routine Act |
| 15 | REL_PARTNER_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Partner |
| 16 | REL_PRNCPL_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Principal |
| 17 | REL_RLTV_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Relative |
| 18 | RELATIONSHIP_TEXT | Character(25) | VARCHAR2(25) NOT NULL | Description of Relationship |
| 19 | RTW_EMPLRTN_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Employee Returned |
| 20 | RTW_EMPRTN_DT_C | Character(10) | VARCHAR2(10) NOT NULL | Return To Work Date C |
| 21 | RTW_TIME5 | Character(5) | VARCHAR2(5) NOT NULL | RTW Time 5 |
| 22 | RTW_CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Return To Work Contact Name |
| 23 | PAYMENTS_DURING | Character(1) | VARCHAR2(1) NOT NULL | Payments during disability |
| 24 | EMPR_BENEFITS_DESC | Character(250) | VARCHAR2(250) NOT NULL | Employer Benefits Description |
| 25 | VAR_SHIFT_ROTATION | Character(1) | VARCHAR2(1) NOT NULL | Variable Shift Rotation |
| 26 | LAST_DAY_START_TM5 | Character(5) | VARCHAR2(5) NOT NULL | Last Day Start Time 5 |
| 27 | LAST_DAY_END_TM5 | Character(5) | VARCHAR2(5) NOT NULL | Last Day End Time 5 |
| 28 | LAST_WORKED_DT_C | Character(10) | VARCHAR2(10) NOT NULL | Last Worked Date C |
| 29 | LAST_DAY_WORK_TM5 | Character(5) | VARCHAR2(5) NOT NULL | Last Day Work Time 5 |
| 30 | EMPL_SECURE_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Employment Secure |
| 31 | JOB_AVL_MONTHS_CAN | Number(3,0) | SMALLINT NOT NULL | Job Available Months |
| 32 | FIXED_ROTN_ST_DT_C | Character(10) | VARCHAR2(10) NOT NULL | Fixed Rotation Start Dt C |
| 33 | EMPTYP_FTW_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Full Time |
| 34 | EMPTYP_PER_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Permanent |
| 35 | EMPTYP_SNL_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Seasonal |
| 36 | EMPTYP_CSL_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Casual |
| 37 | EMPTYP_VLN_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Volunteer |
| 38 | EMPTYP_STU_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Student |
| 39 | EMPTYP_SUB_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Subcontractor |
| 40 | EMPLOYMENT_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Employment Description |
| 41 | RTW_EMPLCNS_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Employer Consider Return |
| 42 | RTW_MODWORK_SW_CAN | Character(1) | VARCHAR2(1) NOT NULL | Modified Work Available |
| 43 | LUMP_SUM_HOL_RCVD | Character(1) | VARCHAR2(1) NOT NULL | Lump Sum Holiday Pay Received |
| 44 | HOLIDAY_PAY_RT_WCB | Number(3,0) | SMALLINT NOT NULL | Holiday Pay Rate WCB |
| 45 | LAST_DAY_WAGES_WCB | Number(7,0) | INTEGER NOT NULL | Last Day Wages WCB |
| 46 | WRKR_CAT_CD | Character(3) | VARCHAR2(3) NOT NULL |
Worker Category
CAS=Casual |
| 47 | WCB_OCC_CAT | Character(3) | VARCHAR2(3) NOT NULL |
Occupational Category
NA=Not Applicable |
| 48 | SHFT_DIFF_IND | Character(1) | VARCHAR2(1) NOT NULL | Shift Differential Included Indicator |
| 49 | SHIFT_DIFF_AMNT | Number(12,2) | DECIMAL(11,2) NOT NULL | Amount of shift differential premiumm that the worker is paid |
| 50 | SHFT_DIFF_MES_CD | Character(1) | VARCHAR2(1) NOT NULL |
Differential Premium Ind
D=Day |
| 51 | OFF_WRK_VAC_IND | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether vacation pay continues to accrue while off work Valid Codes Y = Yes N = No |
| 52 | DAMAGED_APP_IND | Character(1) | VARCHAR2(1) NOT NULL | Damaged Appliance Indicator |
| 53 | RTN_WRK_FL_SLRY | Character(1) | VARCHAR2(1) NOT NULL | Return to Work At Full Salary |
| 54 | WRKR_SUP_EQP_IND | Character(1) | VARCHAR2(1) NOT NULL | Worker Supplies Own Equipment Indicator |
| 55 | WRK_SCHLD_TYP_CD | Character(1) | VARCHAR2(1) NOT NULL |
indicates whether the injured worker works a set schedule every week, has a fixed rotating shift or has a variable shift work
Valid codes:
F = Fixed
R = Rotating
V = Variable
F=Fixed |