INC_TRAVEL_DATA(SQL Table) |
Index Back |
|---|---|
H&S - Travel DataThis is one of several records used in the Health and Safety module to record in-depth information about a health/safety-related incident in the workplace. INC_TRAVEL_DATA details the travel specific information related to the incident. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Incident Number
Default Value: 0 |
| 2 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 3 | START_TIME | Time(15) | TIMESTAMP | Interview Start Time |
| 4 | HS_TIMEZONE1 | Character(9) | VARCHAR2(9) NOT NULL |
Health and Safety Time Zone Field 1
Prompt Table: PSTIMEZONE |
| 5 | ROUTE_LENGTH_KM | Number(7,2) | DECIMAL(6,2) NOT NULL | Route Length (km) |
| 6 | ARRIVAL_DATE | Date(10) | DATE | Arrival Date |
| 7 | ARRIVAL_TIME | Time(15) | TIMESTAMP | Arrival Time |
| 8 | HS_TIMEZONE2 | Character(9) | VARCHAR2(9) NOT NULL |
Health and Safety Time Zone Field 2
Prompt Table: PSTIMEZONE |
| 9 | TRANSPORT_MODE | Character(6) | VARCHAR2(6) NOT NULL |
Mode Of Transport
Prompt Table: TRANSPORT_TBL |
| 10 | DESTINATION | Character(50) | VARCHAR2(50) NOT NULL | Destination |
| 11 | ACTUAL_ROUTE | Character(150) | VARCHAR2(150) NOT NULL | Actual Route |
| 12 | DIRECT_ROUTE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Direct Route Taken
Y/N Table Edit Default Value: N |
| 13 | DIRECT_ROUTE | Character(150) | VARCHAR2(150) NOT NULL | Direct Route |
| 14 | USUAL_ROUTE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Usual Route Taken
Y/N Table Edit Default Value: N |
| 15 | USUAL_ROUTE | Character(150) | VARCHAR2(150) NOT NULL | Usual Route |
| 16 | ROUTE_REASON | Character(100) | VARCHAR2(100) NOT NULL | Reason For Unusual Route |
| 17 | ROUTE_DETAILS | Character(150) | VARCHAR2(150) NOT NULL | Route Details |
| 18 | BREAK_TAKEN_SW | Character(1) | VARCHAR2(1) NOT NULL |
Break Taken In Journey
Y/N Table Edit Default Value: N |
| 19 | BREAK_DURATION_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Break Duration (Hours) |
| 20 | BREAK_REASON | Character(30) | VARCHAR2(30) NOT NULL | Reason For Break |
| 21 | BREAK_INSTANT_CD | Character(1) | VARCHAR2(1) NOT NULL |
When Break Was Taken
A=After Incident B=Before Incident D=During Incident |
| 22 | INC_ANIMALS_SW | Character(1) | VARCHAR2(1) NOT NULL |
Animals Involved
Y/N Table Edit Default Value: N |
| 23 | ALCOHOL_DRUNK_GER | Character(30) | VARCHAR2(30) NOT NULL | Alcohol/Substance Taken |
| 24 | ENDORSER_GER | Character(50) | VARCHAR2(50) NOT NULL | Endorser |
| 25 | COMMENTS | Long Character | CLOB | Comment |