/
IMS REST API
IMS REST API
- Nagalakshmi Bhattiprolu (Unlicensed)
- Poonam Chandak
- Adi Cheede
Owned by Nagalakshmi Bhattiprolu (Unlicensed)
Background and strategic fit
The purpose of this Integration is to pull over different incident information (Near Miss,Injury Illness, Vehicle and Environmental) to support our growing customer base to analyze the data they are entering through the ProcessMAP solution.This document provides information on how to consume the API's by the end Users.
Assumptions
- Individual APIs being used for Near Miss, Injury Illness, Vehicle & Environmental incident types
- For Injury/Illness the Incident type field will have comma separate value in case it is a combined Incident with other Incident Types
- Data will be sent only for the Injury/Illness
- ProcessMAP system User permissions would not be considered while exposing the data
- ProcessMAP assumes anyone who is accessing the Outbound API has required authority to access Personal Information
- User would have to input single Location Code(e.g. Westlake) each time to consume that Location data
- Data to be accessed with a limitation of 2 years duration at a time to avoid any performance issues.
- Data will be shown in Readable JSON format
- Fields Names in the Response would be Product Field Naming. Customer will have to use mapping documentation
- User accessing this endpoint through a valid Token & ConsumerId, provided by ProcessMAP, will have access to complete data
- Witness Details Information will be as nested
- BodyParts -- Will be separated by , and side will be mentioned in braces Ex: Arm (L)(R)
- For Nature, Cause and BodyParts -- IF Other(List) is selected then others description will be appended with '-' Ex: Other(List) --- Some Text
- For Employee, Supervisor, Reported By -- LastName, MiddleName, First name and Prefix will be combined as shown as single (Prefix(if available) + Firstname+ MiddleName(if available) + LastName)
- For Witness the First Name, Middle Name, Last Name will not be appended as no field is mandatory
- Incident Status will be included in the json output
- DATETIME, INT and FLOAT data will be shown as NULL when there is no data
- Pin Location Information and Default CAPA is not considered for this release
- The data that is being shown in response is in EST Date time format ONLY
- Certain fields are auto-populated in Application but the same will not reflect in JSON until the form is saved
User Interaction
Implementation :
AUTHENTICATION URL DETAILS [ Base URL with Auth EndPoint ]
| Environment | Auth URL |
|---|---|
| UAT | https://integrationsvc.uat.pmapconnect.com/product/papi/v1/auth |
| Production | https://integrationsvc.processmap.com/product/papi/v1/auth |
Please note that the above Auth Token expires after every 120 minutes.
BASE URL FOR RESPECTIVE API CALLS :
| Environment | Base URL |
|---|---|
| UAT | https://integrationsvc.uat.pmapconnect.com/outbound/ |
| Production |
Near Miss
Incident Details
Request
Ex: papi/v1/imsoutbound/nearmissincidents?locationCode=westlake&dateFrom=2019-07-01&dateTo=2019-07-30&lastSyncedDate=2019-01-01
URI Parameters
Location Code, DateFrom, DateTo and LastSyncedDate are to be passed as parameters.
DateFrom and DateTo are required when LastSyncedDate is not provided.
When DateFrom, DateTo and LastSyncedDate are provided, data will be returned based on LastSyncedDate only.
| Name | Description | Type | Additional information |
|---|---|---|---|
| locationCode | Represents the unique code of location for which Incident records to return. | string | Required |
| dateFrom | Represents the starting date of Incident records to return. | date | Required but value optional |
| dateTo | Represents the ending date of Incident records to return. | date | Required but value optional |
| lastSyncedDate | Represents the data from incident created date or incident modified date. | date | Required but value optional |
Headers
| Name | Description | Sample |
|---|---|---|
| Authorization | Represents the value of the authentication token. Allow multiple values: no. | Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ... |
| ConsumerId | Represents the value of the consumer id. Allow multiple values: no. | 2426 |
Response
Sample:
{
"Incident ID (System Generated)": "sample string","Incident Title/Site": "sample string",
"Location Code": "sample string",
"Location": "sample string",
"Incident Date": "2019-10-06T00:00:00.000Z",
"Time of Incident": "sample string 2",
"Time Undetermined": "sample string",
"Date Reported to Employer": "2019-10-06T00:00:00.000Z",
"Time Reported To Employer": "18:40",
"Day Of Week": "sample string",
"Reported By": "sample string",
"Work Shift": "sample string",
"Incident Occurred on Employer's Premises": "sample string",
"Operating Unit": "sample string",
"Describe what occurred to create the Near Miss/Unsafe Act/Unsafe Condition?": "sample string.",
"Is Contractor Involved?": "sample string",
"Please provide Contractor Name, Company": "sample string",
"Near Miss Incident Type": "sample string",
"Severity": "sample string",
"Hazard Classification": "sample string",
"Potential Injury / Illness":
[
{
"Nature of Injury / Illness": "sample string",
"Cause of Injury/Illness": "sample string",
"Injured Body Parts":
[
"sample string",
"sample string",
]
}
],
"Employee/Individual Details":
{
"Was an Employee / Individual involved in the Incident?": "sample string",
},
"Are there any Witnesses identified?": "sample string",
"If Yes - Number of Witnesses": "sample string",
"Witness Information":
[ {
"LastName": "sample string 2",
"FirstName": "sample string 3",
"MiddleName": "sample string 4",
"PhoneNumber": "sample string 5",
"Notes": "sample string 6"
} ],
"Incident Status": ""sample string",
"Created By": "sample string",
"Created Date": "2019-10-14T11:43:31.517Z",
"Modified Date": "2019-10-14T11:47:29.440Z",
"Modified By": "sample string",
"Investigation Responsibility":
{ "Responsible Team": [ { "Salutation": null, "First Name": "John", "Last Name": "Smith" }, { "Salutation": null, "First Name": "Sagar", "Last Name": "Pradhan" } ], "Target Completion Date": "2019-11-22T00:00:00.000Z", "Note/Comments": "Test inv responsblity*", "Notify Immediate Supervisor": "Y" },
"Investigation Details": [
{
"Had the job or task related to the Near Miss been risk assessed?": "sample string",
"IF No, explain:":"sample string",
},
{
"Was incident reviewed with the involved employee?":"sample string",
"Employee Comments (If yes to answer above)": "sample string",
},
{
"How long has the employee been working on the job where the Near Miss occurred?": "sample string"
},
{
"Was the employee performing their normal job?": "sample string"
},
{
"Select the type of the task the employee was performing when the Near Miss occurred": "sample string"
},
{
"What tools, machine, equipment, object, or substances or components were involved in the Near Miss": "sample string"
},
{
"Lessons Learned from incident to be communicated to other departments?": "sample string"
},
"Name of person leading the investigation": "sample string"
},
{
"Investigation completed date": "sample string"
},
{
"Investigation completed Time": "sample string"
},
{
"Name of representative(s) approving of the investigation and corrective action?": "sample string"
},
{
"Date of representaive(s) approval": "sample string"
}
],
"Contributing Factors":
[
{
"Contributing Factor Type (Parent)": "sample string",
"Contributing Factors":
[
"sample string",
"sample string"
],
"Comments": "sample string"
}
],
"5 Why? Methodology":
[
{
"Select Action or Condition that may have directly caused incident":
[
"sample string"
],
"Whys":
[
{
"Why or what created the scenario above to affect the action or condition": "sample string"
},
{
"Final Root Cause Checked": "sample string"
}
]
],
"Root Cause Analysis":
[
{
"Root cause Type (Parent)": "sample string",
"Root Cause":
[
"Tools/Equipment - "sample string",
],
"Comments": "sample string"
}
],
"Action Items": [
{
"Source ID": "sample string",
"Source Title": "sample string",
"Action Item Title": "sample string",
"Action Item Category": "Incident Management",
"Action Item Type": "Corrective Action",
"Action Item Description":"sample string",
"Action Item Priority": "sample string",
"Action Item Due Date": "2019-11-06T00:00:00.000Z",
"Owners":
[
"sample string"
],
"Responsible Department": "sample string",
"Applicable to Expansion": "sample string",
"Description of Actions to be Expanded": "sample string",
"Applicable to EEM/EPM Info": "sample string",
"EEM / EPM":"sample string",
"EEM/EPM Info Submitted": "sample string",
"Document Number": "sample string",
"Assigned By": "sample string",
"Verification Required": "sample string",
"Action Item Status": "sample string",
"Action Taken": "sample string",
"Action Item Completed By": "sample string",
"Completed Date": "2019-10-06T00:00:00.000Z",
"Due Date Extension": "sample string",
"Requested Due Date Extension": "sample string",
"Reason for Due Date Extension": "sample string",
"Due Date Extension Request Approved?": "sample string",
"Reason for not extending the Due Date": "sample string",
"Verification Status": "sample string",
"Verification Performed": "sample string",
"Verified By": "sample string"
"Verification Date":"sample string"
"Comments":"sample string",
}
]
Near Miss Field List
| Section | Field Name | Database Column Size |
|---|---|---|
| Incident Detail | ||
| Incident ID * | NVARCHAR(400) | |
| Internal incident Id | NVARCHAR(200) | |
| Incident Title (No Personal data to be entered) * | NVARCHAR(400) | |
| General Detail | ||
| Incident Date * | DATETIME | |
| Time of Incident * | NVARCHAR(100) | |
| Time Undetermined | NVARCHAR(10) | |
| Day of Week * | NVARCHAR(50) | |
| Date Reported to Employer | DATETIME | |
| Time Reported to Employer | NVARCHAR(200) | |
| Reported By | NVARCHAR(200) | |
| Work Shift * | NVARCHAR(200) | |
| Incident Occurred on Employer's Premises * | NVARCHAR(3) | |
| Address of Incident Location * | NVARCHAR(500) | |
| City * | NVARCHAR(50) | |
| County | NVARCHAR(50) | |
| Country * | NVARCHAR(50) | |
| State * | NVARCHAR(50) | |
| Postal Code | NVARCHAR(50) | |
| Department * | NVARCHAR(100) | |
| Department where the incident/injury occurred | NVARCHAR(100) | |
| Could this have resulted in a life altering injury or fatality? * | NVARCHAR(100) | |
| Describe what occurred to create the Near Miss? * | NVARCHAR(8000) | |
| Is Contractor Involved? * | NVARCHAR(50) | |
| Please provide Contractor Name, Company * | NVARCHAR(500) | |
| Nearmiss Incident type * | NVARCHAR(200) | |
| Severity * | NVARCHAR(50) | |
| Hazard Classification * | NVARCHAR(100) | |
| Was a Corrective Action completed at time of reporting incident? | NVARCHAR(3) | |
| Action Item Title | NVARCHAR(500) | |
| Action Taken | NVARCHAR(4000) | |
| Primary Owners | NVARCHAR(100) | |
| Assigned By | NVARCHAR(100) | |
| Completion Date | DATETIME | |
| Potentially Injury illness section | ||
| Nature of Illness/Injury * | NVARCHAR(100) | |
| Cause of Illness/Injury * | NVARCHAR(200) | |
| Injured Body Part | NVARCHAR(100) | |
| Employee / Individual Details | ||
| Was an Employee / Individual involved in the Incident? * | NVARCHAR(50) | |
| Personnel Type * | NVARCHAR(50) | |
| Employee / Individual Involved ( Last, First, M.I.) * | NVARCHAR(200), NVARCHAR(200), NVARCHAR(200) | |
| Employee Id * | NVARCHAR(200) | |
| Gender | NVARCHAR(200) | |
| Occupation/Job Title | NVARCHAR(200) | |
| Hire Date | DATETIME | |
| Employee / Individual Department | NVARCHAR(100) | |
| Supervisor ( Last, First, M.I) | NVARCHAR(200), NVARCHAR(200), NVARCHAR(200) | |
| Supervisor's Email | NVARCHAR(50) | |
| Do you want to further classify Unsupervised Contract Employee | NVARCHAR(10) | |
| Type of Client Personnel | NVARCHAR(20) | |
| Client Company | NVARCHAR(100) | |
| Name of Contractor | NVARCHAR(800) | |
| Name of Sub-Contractor | NVARCHAR(800) | |
| Witness Information | ||
| Are there any Witness identified? | NVARCHAR(20) | |
| If Yes - Number of Witnesses | INT | |
| Last Name | NVARCHAR(50) | |
| First Name | NVARCHAR(50) | |
| Middle Name | NVARCHAR(50) | |
| Phone Number | NVARCHAR(100) | |
| Notes | NVARCHAR(2000) | |
Injury/Illness
Incident Details
Request
GET papi/v1/imsoutbound/injuryincidents?locationCode={locationCode}&dateFrom={dateFrom}&dateTo={dateTo}&lastSyncedDate={lastSyncedDate}
Ex: papi/v1/imsoutbound/injuryincidents?locationCode=westlake&dateFrom=2019-07-01&dateTo=2019-07-30&lastSyncedDate=2019-01-01
URI Parameters
Location Code, DateFrom, DateTo and LastSyncedDate are to be passed as parameters.
DateFrom and DateTo are required when LastSyncedDate is not provided.
When DateFrom, DateTo and LastSyncedDate are provided, data will be returned based on LastSyncedDate only.
| Name | Description | Type | Additional information |
|---|---|---|---|
| locationCode | Represents the unique code of location for which Incident records to return. | string | Required |
| dateFrom | Represents the starting date of Incident records to return. | date | Required but value optional |
| dateTo | Represents the ending date of Incident records to return. | date | Required but value optional |
| lastSyncedDate | Represents the data from incident created date or incident modified date. | date | Required but value optional |
Headers
| Name | Description | Sample |
|---|---|---|
| Authorization | Represents the value of the authentication token. Allow multiple values: no. | Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ... |
| ConsumerId | Represents the value of the consumer id. Allow multiple values: no. | 2222 |
Sample Response:
[
{
"Location Code": "sample string 1",
"Location Name": "sample string 2",
"Incident ID (System Generated)": "sample string 3",
"Incident Internal Id (System Generated)": "sample string 4",
"Incident Title (No Personal data to be entered)": "sample string 5",
"Incident Type": "sample string 6",
"Were multiple people injured as part of this incident?": "sample string 7",
"Is this a MSHA Related Incident?": "sample string 8",
"Is this a MSHA Related Incident Location?": "sample string 9",
"Date of Incident": "2022-08-25T12:36:53.603Z",
"Time of Incident": "sample string 10",
"Time undetermined": "sample string 11",
"Day Of Week": "sample string 12",
"Length of Normal Workday": "sample string 13",
"Work Shift": "sample string 14",
"Time Work Day Began": "sample string 15",
"Description of Incident": "sample string 16",
"Incident Occurred on Employer's Premises": "sample string 17",
"Address of Incident Location": "sample string 18",
"City of Incident Location": "sample string 19",
"County of Incident Location": "sample string 20",
"Country of Incident Location": "sample string 21",
"State/Province of Incident Location": "sample string 22",
"Postal Code/Zip Code of Incident Location": "sample string 23",
"Department": "sample string 24",
"Pin Location": "sample string 25",
"Responsible Department": "sample string 26",
"Responsible Supervisor": "sample string 27",
"Location of Injury Scene": "sample string 28",
"Date Reported to Employer": "2022-08-25T12:36:53.609Z",
"Time Reported to Employer": "sample string 29",
"Confirm Significance Level ID Of Incident": "sample string 30",
"Confirm Significance Level Of Incident": "sample string 31",
"Would you like to submit a Workers Compensation claim?": "sample string 32",
"Personnel Type ID": 33,
"Personnel Type": "sample string 34",
"Employee / Individual Involved (Prefix, First, M.I., Last)": "sample string 35",
"Employee Id": "sample string 36",
"Employee's Social Security Number **": "sample string 37",
"Date of Birth **": "2022-08-25T12:36:53.612Z",
"Gender": "sample string 39",
"Occupation/Job Title": "sample string 40",
"Hire Date": "2022-08-25T12:36:53.614Z",
"Time in Current job": "sample string 41",
"Time in Current job Unit": "sample string 42",
"Employee / Individual Department": "sample string 43",
"Supervisor (First, M.I., Last)": "sample string 44",
"Supervisor's Email": "sample string 45",
"Supervisor Phone": "sample string 46",
"Employee Home Address": "sample string 47",
"Employee City": "sample string 48",
"Employee State": "sample string 49",
"Employee Postal Code/Zip Code": "sample string 50",
"Employee Home Phone Number": "sample string 51",
"Marital Status": "sample string 52",
"Years at Company": "sample string 53",
"Number Of Dependents": 1,
"Type of Employment": "sample string 54",
"Current Weekly Wage": 1.1,
"Hourly Wage": 1.1,
"Hours Worked per Week": 1.1,
"Days worked Per Week": 1,
"Hours worked Per Day": 1,
"State Hired": "sample string 55",
"Employment Status": "sample string 56",
"Was Employee Paid in Full for Date of Injury?": "sample string 57",
"Any Prior WC Injuries?": "sample string 58",
"Do you want to further classify Unsupervised Contract Employee": "sample string 59",
"Type of Client Personnel": "sample string 60",
"Client Company": "sample string 61",
"Name of Contractor": "sample string 62",
"Name of Sub-Contractor": "sample string 63",
"Will employee's salary continue?": "sample string 64",
"Was Employee treated offsite?": "sample string 65",
"Where was employee treated": "sample string 66",
"Explain Why": "sample string 67",
"If this injury had occurred in a slightly different matter, could it have caused a serious injury or fatality": "sample string 68",
"Did this incident involve an in-patient hospitalization, amputation, or a loss of an eye?": "sample string 69",
"Has OSHA been contacted?": "sample string 70",
"Please Identify OSHA Contact Details (Name and Phone Number)": "sample string 71",
"Nature of Injury / Illness": "sample string 72",
"Cause of Illness/Injury": "sample string 73",
"Injured Body Part": "sample string 74",
"What was the employee doing just before the incident occurred?": "sample string 75",
"Please describe what object or substance directly harmed the employee? If this question does not apply, enter 'not applicable'": "sample string 76",
"Specific Work Activity when the incident occurred": "sample string 77",
" Was any Machine / Equipment involved?": "sample string 78",
"Machine/Equipment Number": "sample string 79",
"Reviewed by EHS Representative": "sample string 80",
"Review Date": "2022-08-25T12:36:53.636Z",
" Is this a Needlestick Injury?": "sample string 81",
" Type": "sample string 82",
"Brand": "sample string 83",
"Model": "sample string 84",
"Identify Initial Treatment": "sample string 85",
"Was Drug Testing Performed": "sample string 86",
"Explain why": "sample string 87",
"RIDDOR Classification": "sample string 88",
"Most Severe Case": "sample string 89",
"Current Case": "sample string 90",
"Health & Safety / WC Contact Name": "sample string 91",
"Employer Telephone Number": "sample string 92",
"Employer Title": "sample string 93",
"Employer Mailing Address": "sample string 94",
"Employer City": "sample string 95",
"Employer State": "sample string 96",
"Employer Postal Code/Zip Code": "sample string 97",
"Employer Location Code": "sample string 98",
"Employer SIC": "sample string 99",
"Nature of Business": "sample string 100",
"Employer FEIN Number": "sample string 101",
"Employer Name": "sample string 102",
"Workers Comp Claim": "sample string 103",
"Is This Claim Work Related": "sample string 104",
"Jurisdiction State": "sample string 105",
"Did the incident result in fatality?": "sample string 106",
"Date fatality occurred": "2022-08-25T12:36:53.644Z",
"Did the employee lose any time from work?": "sample string 107",
"What was the first full day out?": "2022-08-25T12:36:53.645Z",
"Do you know the Date Employee Last Worked?": "sample string 108",
"Date Employee Last Worked": "2022-08-25T12:36:53.646Z",
"Has the employee returned to work?": "sample string 109",
"Date Returned to Work": "2022-08-25T12:36:53.647Z",
"Return to Work Status": "sample string 110",
"Estimated Return to Work Date": "2022-08-25T12:36:53.649Z",
"Reqs Sharps Inj Log": "sample string 111",
"Work Comp Id": "sample string 112",
"Incident Reported By": "sample string 113",
"Reporters Email": "sample string 114",
"Reporters Phone": "sample string 115",
"Injury Date": "2022-08-25T12:36:53.651Z",
"Injury Day": "sample string 116",
"Injury Time": "sample string 117",
"Claim Time Workday Began": "sample string 118",
"Was employee sent to Hospital / Clinic to receive Medical Treatment?": "sample string 119",
"Initial Medical Treatment": "sample string 120",
"Hospital / Clinic Name": "sample string 121",
"Hospital Address": "sample string 122",
"Hospital City": "sample string 123",
"Hospital State": "sample string 124",
"Hospital Postal Code/Zip Code": "sample string 125",
"Hospital Phone": "sample string 126",
"Hospital Fax": "sample string 127",
"Clinic/Doctor Name": "sample string 128",
"Do you question the Validity of the claim?": "sample string 129",
"Provide details": "sample string 130",
"Other Comments": "sample string 131",
"Is Claim Form Completed?": "sample string 132",
"Claim Submission Status": "sample string 133",
"Claim Submitted By": "sample string 134",
"Claim Submitted Date": "2022-08-25T12:36:53.659Z",
"Claim Status": "sample string 135",
"Date Claim Closed": "2022-08-25T12:36:53.659Z",
"Total Cost Incurred": 1.1,
"Total Cost Paid": 1.1,
"Total Outstanding Cost": 1.1,
"Total Developed Cost": 1.1,
"Are there any Witnesses identified?": "sample string 136",
"Witness Information": [
{
"LastName": "sample string 2",
"FirstName": "sample string 3",
"MiddleName": "sample string 4",
"PhoneNumber": "sample string 5",
"Notes": "sample string 6"
},
{
"LastName": "sample string 2",
"FirstName": "sample string 3",
"MiddleName": "sample string 4",
"PhoneNumber": "sample string 5",
"Notes": "sample string 6"
}
],
"Name": "sample string 137",
"Title": "sample string 138",
"Phone": "sample string 139",
"Incident Status": "sample string 140",
"Incident Created By Employee ID": "sample string 141",
"Incident Created By": "sample string 142",
"Incident Created Date": "2022-08-25T12:36:53.668Z",
"Incident Last Updated By": "sample string 143",
"Incident Last Updated Date": "2022-08-25T12:36:53.669Z",
"Was This Claim Work Related": "sample string 144",
"ManagementReviewStatus": "sample string 145",
"Lost Time Days": 1.1,
"Restricted Duty Days": 1.1,
"Recordable (Yes/No)": "sample string 146",
"Workers Comp Claim#": "sample string 147",
"Reason for Non Work Related Classification": "sample string 148",
"Is This a Company defined Recordable Case ?": "sample string 149",
"Worker Comp Id": "sample string 150",
"Please identify the severity of the Incident": "sample string 151",
"Filing State": "sample string 152",
"Is Claim Submission Required?": "sample string 153",
"Claim #": "sample string 154",
"Recent Cost Update": "sample string 155",
"Was employee sent to Hospital/Clinic to receive Medical Treatment?": "sample string 156",
"Root Cause Details": [
{
"Parent Root Cause Name": "sample string 2",
"Root Cause Name": "sample string 3",
"Comments": "sample string 4"
},
{
"Parent Root Cause Name": "sample string 2",
"Root Cause Name": "sample string 3",
"Comments": "sample string 4"
}
],
"5Y Details": [
{
"Evaluation ID": 1,
"Contact Type": "sample string 2",
"Others Description": "sample string 3",
"Contact ID": "sample string 4"
},
{
"Evaluation ID": 1,
"Contact Type": "sample string 2",
"Others Description": "sample string 3",
"Contact ID": "sample string 4"
}
],
"5Ys": [
{
"Evaluation ID": 1,
"Why Label": "sample string 2",
"Why Check": "sample string 3"
},
{
"Evaluation ID": 1,
"Why Label": "sample string 2",
"Why Check": "sample string 3"
}
],
"Investigation questions Details": [
{
"Question ID": 2,
"Question": "sample string 3",
"Answer": {},
"Answer ID": 5,
"Parent Question ID": 6,
"Parent Question": "sample string 7"
},
{
"Question ID": 2,
"Question": "sample string 3",
"Answer": {},
"Answer ID": 5,
"Parent Question ID": 6,
"Parent Question": "sample string 7"
}
],
"Investigation Responsibility Details": [
{
"Target Completion Date": "2022-08-25T12:36:53.685Z",
"Comments": "sample string 1",
"Notify / YN": "sample string 2"
},
{
"Target Completion Date": "2022-08-25T12:36:53.685Z",
"Comments": "sample string 1",
"Notify / YN": "sample string 2"
}
],
"Investigation Responsibility assignee Details": [
{
"UserID": 1,
"Salutation": "sample string 2",
"First Name": "sample string 3",
"Last Name": "sample string 4"
},
{
"UserID": 1,
"Salutation": "sample string 2",
"First Name": "sample string 3",
"Last Name": "sample string 4"
}
],
"Final root cause statement Details": [
{
"IMSIncidentID": 1,
"FinalRootCauseStatement": "sample string 2",
"PrimaryCounterMeasure": "sample string 3",
"PrimaryRootCause": "sample string 4"
},
{
"IMSIncidentID": 1,
"FinalRootCauseStatement": "sample string 2",
"PrimaryCounterMeasure": "sample string 3",
"PrimaryRootCause": "sample string 4"
}
],
"Action Items Details": [
{
"Source ID": "sample string 2",
"Source Title": "sample string 3",
"Action Item Title": "sample string 4",
"Action Item Category": "sample string 5",
"Action Item Type Id": 6,
"Action Item Type": "sample string 7",
"Root Cause": "sample string 8",
"Action Item Description": "sample string 9",
"Action Item Priority": "sample string 10",
"Action Item Due Date": "2022-08-25T12:36:53.693Z",
"Owner": "sample string 11",
"Responsible Department": "sample string 12",
"Counter Measure": "sample string 13",
"Applicable to Expansion?": "sample string 14",
"Description of Actions to be Expanded": "sample string 15",
"Applicable to EEM/EPM Info?": "sample string 16",
"EEM / EPM": "sample string 17",
"EEM/EPM Info Submitted ?": "sample string 18",
"Document Number ": "sample string 19",
"Assigned By": "sample string 20",
"Is Verification Required": 21,
"Verification Required": "sample string 22",
"VerifyUser": "sample string 23",
"Approval Status": "sample string 24",
"Approvers": "sample string 25",
"Approval Comment": "sample string 26",
"Approval Date": "2022-08-25T12:36:53.7Z",
"Action Item Status": "sample string 27",
"Action Taken": "sample string 28",
"Action item Completed By": "sample string 29",
"Action item Completed Date": "2022-08-25T12:36:53.701Z",
"Due Date Extension": "sample string 30",
"Requested Due Date Extension": "2022-08-25T12:36:53.702Z",
"Reason for Due Date Extension": "sample string 31",
"Due Date Extension Request Approved?": "sample string 32",
"Reason for not extending the Due Date": "sample string 33",
"Verification Status": "sample string 34",
"Verification Performed": "sample string 35",
"Verified By": "sample string 36",
"Verification Date": "2022-08-25T12:36:53.705Z",
"Comments": "sample string 37"
},
{
"Source ID": "sample string 2",
"Source Title": "sample string 3",
"Action Item Title": "sample string 4",
"Action Item Category": "sample string 5",
"Action Item Type Id": 6,
"Action Item Type": "sample string 7",
"Root Cause": "sample string 8",
"Action Item Description": "sample string 9",
"Action Item Priority": "sample string 10",
"Action Item Due Date": "2022-08-25T12:36:53.693Z",
"Owner": "sample string 11",
"Responsible Department": "sample string 12",
"Counter Measure": "sample string 13",
"Applicable to Expansion?": "sample string 14",
"Description of Actions to be Expanded": "sample string 15",
"Applicable to EEM/EPM Info?": "sample string 16",
"EEM / EPM": "sample string 17",
"EEM/EPM Info Submitted ?": "sample string 18",
"Document Number ": "sample string 19",
"Assigned By": "sample string 20",
"Is Verification Required": 21,
"Verification Required": "sample string 22",
"VerifyUser": "sample string 23",
"Approval Status": "sample string 24",
"Approvers": "sample string 25",
"Approval Comment": "sample string 26",
"Approval Date": "2022-08-25T12:36:53.7Z",
"Action Item Status": "sample string 27",
"Action Taken": "sample string 28",
"Action item Completed By": "sample string 29",
"Action item Completed Date": "2022-08-25T12:36:53.701Z",
"Due Date Extension": "sample string 30",
"Requested Due Date Extension": "2022-08-25T12:36:53.702Z",
"Reason for Due Date Extension": "sample string 31",
"Due Date Extension Request Approved?": "sample string 32",
"Reason for not extending the Due Date": "sample string 33",
"Verification Status": "sample string 34",
"Verification Performed": "sample string 35",
"Verified By": "sample string 36",
"Verification Date": "2022-08-25T12:36:53.705Z",
"Comments": "sample string 37"
}
],
"Contributing Factors Details": [
{
"Parent Contributing Factor ID": 1,
"Contributing Factor ID": 2,
"Contributing Factor Name": "sample string 3",
"Comments": "sample string 4"
},
{
"Parent Contributing Factor ID": 1,
"Contributing Factor ID": 2,
"Contributing Factor Name": "sample string 3",
"Comments": "sample string 4"
}
],
"Ergo Details": [
{
"Question ID": 1,
"Dependency Question ID": 2,
"Question Lable": "sample string 3",
"Answer ID": "sample string 4"
},
{
"Question ID": 1,
"Dependency Question ID": 2,
"Question Lable": "sample string 3",
"Answer ID": "sample string 4"
}
],
"Case Classification": [
{
"Case Number (System Generated)": "sample string 1",
"Was this case Work-Related?": "sample string 2",
"Describe the reason for the Non Work Related classification": "sample string 3",
"Did this incident result in a fatality?": "sample string 4",
"Did this incident result in an amputation, fractured/cracked bone(s) (including teeth), or loss of consciousness?": "sample string 5",
"Did the incident result in work restrictions, lost time or job transfer?": "sample string 6",
"Was Treatment Provided beyond First Aid?": "sample string 7",
"Did the injury involve a needlestick and cut(s) from sharp objects that are contaminated with another person's blood or other potentially infectious material?": "sample string 8",
"Was treatment defined as First Aid provided?": "sample string 9",
"This is a First Aid Case, identify the specific treatment(s) provided.": "sample string 10",
"Is This a Company defined Recordable Case ?": "sample string 11",
"Describe the reason for the Not Recordable classification": "sample string 12",
"Is this Case Recordable According to Local Record keeping Requirements ?": "sample string 13",
"Does this meet FCA's requirement for FAI Classification?": "sample string 14",
"Did this case involve a chronic injury, a strain or a sprain?": "sample string 15",
"Date Reported to Healthcare": "2022-08-25T12:36:53.716Z",
"Time Reported to Healthcare": "sample string 16",
"Case Status": "sample string 17",
"Title": "sample string 18",
"Phone": "sample string 19",
"Closed Date": "2022-08-25T12:36:53.717Z",
"Comments": "sample string 20",
"Completed By": "sample string 21"
},
{
"Case Number (System Generated)": "sample string 1",
"Was this case Work-Related?": "sample string 2",
"Describe the reason for the Non Work Related classification": "sample string 3",
"Did this incident result in a fatality?": "sample string 4",
"Did this incident result in an amputation, fractured/cracked bone(s) (including teeth), or loss of consciousness?": "sample string 5",
"Did the incident result in work restrictions, lost time or job transfer?": "sample string 6",
"Was Treatment Provided beyond First Aid?": "sample string 7",
"Did the injury involve a needlestick and cut(s) from sharp objects that are contaminated with another person's blood or other potentially infectious material?": "sample string 8",
"Was treatment defined as First Aid provided?": "sample string 9",
"This is a First Aid Case, identify the specific treatment(s) provided.": "sample string 10",
"Is This a Company defined Recordable Case ?": "sample string 11",
"Describe the reason for the Not Recordable classification": "sample string 12",
"Is this Case Recordable According to Local Record keeping Requirements ?": "sample string 13",
"Does this meet FCA's requirement for FAI Classification?": "sample string 14",
"Did this case involve a chronic injury, a strain or a sprain?": "sample string 15",
"Date Reported to Healthcare": "2022-08-25T12:36:53.716Z",
"Time Reported to Healthcare": "sample string 16",
"Case Status": "sample string 17",
"Title": "sample string 18",
"Phone": "sample string 19",
"Closed Date": "2022-08-25T12:36:53.717Z",
"Comments": "sample string 20",
"Completed By": "sample string 21"
}
],
"Case Progression Tracking": [
{
"Employee Name": "sample string 1",
"Classification Of Case Id": 2,
"Classification of Case": "sample string 3",
"Date Reported": "2022-08-25T12:36:53.72Z",
"Date First Aid Provided": "2022-08-25T12:36:53.72Z",
"Date other Recordable case Occurred": "2022-08-25T12:36:53.721Z",
"First Day of Restricted Duty": "2022-08-25T12:36:53.721Z",
"Last Day of Restricted Duty": "2022-08-25T12:36:53.721Z",
"First Day of Lost Time": "2022-08-25T12:36:53.722Z",
"Last Day of Lost Time": "2022-08-25T12:36:53.722Z",
"Date Fatality Occurred.": "2022-08-25T12:36:53.723Z",
"Reason for Classification": "sample string 4",
"Reason for Classification Pick List": "sample string 5",
"Is This A Defense Based Act Case?": "sample string 6",
"Is This A Compensable Case?": "sample string 7",
"Comments": "sample string 8",
"Official Medical Diagnosis (Nature of Injury / Illness)": "sample string 9",
"Was the Corporate Medical Director contacted?": "sample string 10",
"Was Medical Treatment Rejected?": "sample string 11",
"Reason for Refusal": "sample string 12",
"Was Treatment Provided beyond First Aid?": "sample string 13",
"Was Treatment provided offsite?": "sample string 14",
"Hospital/Clinic Name": "sample string 15",
"Type": "sample string 16",
"Physician/Health care Provider": "sample string 17",
"Street": "sample string 18",
"City": "sample string 19",
"Country": "sample string 20",
"State": "sample string 21",
"Postal Code/Zip Code": "sample string 22",
"Phone": "sample string 23",
"FAX": "sample string 24",
"Was the employee treated in an emergency room": "sample string 25",
"Was employee hospitalized overnight as an in-patient": "sample string 26",
"Recording/Revision Date": "2022-08-25T12:36:53.73Z"
},
{
"Employee Name": "sample string 1",
"Classification Of Case Id": 2,
"Classification of Case": "sample string 3",
"Date Reported": "2022-08-25T12:36:53.72Z",
"Date First Aid Provided": "2022-08-25T12:36:53.72Z",
"Date other Recordable case Occurred": "2022-08-25T12:36:53.721Z",
"First Day of Restricted Duty": "2022-08-25T12:36:53.721Z",
"Last Day of Restricted Duty": "2022-08-25T12:36:53.721Z",
"First Day of Lost Time": "2022-08-25T12:36:53.722Z",
"Last Day of Lost Time": "2022-08-25T12:36:53.722Z",
"Date Fatality Occurred.": "2022-08-25T12:36:53.723Z",
"Reason for Classification": "sample string 4",
"Reason for Classification Pick List": "sample string 5",
"Is This A Defense Based Act Case?": "sample string 6",
"Is This A Compensable Case?": "sample string 7",
"Comments": "sample string 8",
"Official Medical Diagnosis (Nature of Injury / Illness)": "sample string 9",
"Was the Corporate Medical Director contacted?": "sample string 10",
"Was Medical Treatment Rejected?": "sample string 11",
"Reason for Refusal": "sample string 12",
"Was Treatment Provided beyond First Aid?": "sample string 13",
"Was Treatment provided offsite?": "sample string 14",
"Hospital/Clinic Name": "sample string 15",
"Type": "sample string 16",
"Physician/Health care Provider": "sample string 17",
"Street": "sample string 18",
"City": "sample string 19",
"Country": "sample string 20",
"State": "sample string 21",
"Postal Code/Zip Code": "sample string 22",
"Phone": "sample string 23",
"FAX": "sample string 24",
"Was the employee treated in an emergency room": "sample string 25",
"Was employee hospitalized overnight as an in-patient": "sample string 26",
"Recording/Revision Date": "2022-08-25T12:36:53.73Z"
}
],
"WCC InjuryIllness": [
{
"IMSIncidentID": 1,
"IncidentClaimYN": "sample string 2",
"WorkCompId": "sample string 3",
"TPAID": "sample string 4",
"IncidentReportedBy": "sample string 5",
"ReportersEmail": "sample string 6",
"ReportersPhone": "sample string 7",
"InjuryDate": "2022-08-25T12:36:53.734Z",
"InjuryDay": "sample string 8",
"InjuryTime": "sample string 9",
"TimeWorkdayBegan": "sample string 10",
"IncidentInternalId": "sample string 11",
"ClaimWorkRelatedYn": "sample string 12",
"EmpSSN": "sample string 13",
"EmpFirstName": "sample string 14",
"EmpMiddleName": "sample string 15",
"EmpLastName": "sample string 16",
"EmpStreet": "sample string 17",
"EmpCity": "sample string 18",
"EmpState": "sample string 19",
"EmpZip": "sample string 20",
"EmpPhone": "sample string 21",
"EmpGender": "sample string 22",
"EmpDOB": "2022-08-25T12:36:53.739Z",
"EmpMaritialStatus": "sample string 23",
"EmpHireDate": "2022-08-25T12:36:53.74Z",
"EmpYearsAtComp": "sample string 24",
"EmpNoOfDependents": 25,
"EmpTypeOfEmployement": "sample string 26",
"EmpDepartment": "sample string 27",
"EmpStateHired": "sample string 28",
"EmpSupervisorName": "sample string 29",
"EmpSupervisorPhone": "sample string 30",
"EmpWeeklyWage": 31.1,
"EmpHourlyWage": 32.1,
"EmpHoursPerWeek": 33.1,
"EmpDaysPerWeek": 34.1,
"EmpHoursPerDay": 35.1,
"EmployementStatus": "sample string 36",
"EmployeeID": "sample string 37",
"EmpPaidInFull": "sample string 38",
"EmpAnyPriorInjuriesYn": "sample string 39",
"EmpSalaryContinueYN": "sample string 40",
"EmployerContactName": "sample string 41",
"EmployerTelephoneNumber": "sample string 42",
"EmployerTitle": "sample string 43",
"EmployerAddress": "sample string 44",
"EmployerCity": "sample string 45",
"EmployerState": "sample string 46",
"EmployerZip": "sample string 47",
"EmployerLocCode": "sample string 48",
"EmployerSIC": "sample string 49",
"EmployerNatureOfBusiness": "sample string 50",
"EmployerName": "sample string 51",
"FEINNumber": "sample string 52",
"AccidentOccuredAtWorkYn": "sample string 53",
"AccidentAddress": "sample string 54",
"AccidentCity": "sample string 55",
"AccidentState": "sample string 56",
"AccidentZip": "sample string 57",
"AccidentDescription": "sample string 58",
"EmpActivityBeforeAccident": "sample string 59",
"ObjectInvolved": "sample string 60",
"JurisdictionState": "sample string 61",
"DateReported": "2022-08-25T12:36:53.753Z",
"TimeReported": "sample string 62",
"FatalityYn": "sample string 63",
"FatalityDate": "2022-08-25T12:36:53.755Z",
"LostTimeYn": "sample string 64",
"FirstFullDayOut": "2022-08-25T12:36:53.755Z",
"DateEmployeeLastWorkedYN": "sample string 65",
"DateEmployeeLastWorked": "2022-08-25T12:36:53.757Z",
"EmpReturnToWorkYn": "sample string 66",
"DateReturnToWork": "2022-08-25T12:36:53.758Z",
"EmpReturnWorkStatus": "sample string 67",
"EstReturnToWorkDate": "2022-08-25T12:36:53.759Z",
"NatureOfinjury": "sample string 68",
"CauseOfinjury": "sample string 69",
"PartOfBody": "sample string 70",
"PartOfBodyLocation": "sample string 71",
"NeedleStickInjuryYn": "sample string 72",
"ReqNeedleStickYn": "sample string 73",
"EmpSentToHospYn": "sample string 74",
"InitialTreatmentYn": "sample string 75",
"HospName": "sample string 76",
"HospAddress": "sample string 77",
"HospCity": "sample string 78",
"HosplAddressState": "sample string 79",
"HospZip": "sample string 80",
"HospPhone": "sample string 81",
"HospFax": "sample string 82",
"DoctName": "sample string 83",
"WitnessYn": "sample string 84",
"WitnessName": "sample string 85",
"WitnessContact": "sample string 86",
"ValidityOfClaimYn": "sample string 87",
"ValidityOfClaimDetails": "sample string 88",
"OtherComments": "sample string 89",
"PrepByName": "sample string 90",
"PrepByPhone": "sample string 91",
"PrepByTitle": "sample string 92",
"EmpOccupation": "sample string 93",
"OshaReference": "sample string 94"
},
{
"IMSIncidentID": 1,
"IncidentClaimYN": "sample string 2",
"WorkCompId": "sample string 3",
"TPAID": "sample string 4",
"IncidentReportedBy": "sample string 5",
"ReportersEmail": "sample string 6",
"ReportersPhone": "sample string 7",
"InjuryDate": "2022-08-25T12:36:53.734Z",
"InjuryDay": "sample string 8",
"InjuryTime": "sample string 9",
"TimeWorkdayBegan": "sample string 10",
"IncidentInternalId": "sample string 11",
"ClaimWorkRelatedYn": "sample string 12",
"EmpSSN": "sample string 13",
"EmpFirstName": "sample string 14",
"EmpMiddleName": "sample string 15",
"EmpLastName": "sample string 16",
"EmpStreet": "sample string 17",
"EmpCity": "sample string 18",
"EmpState": "sample string 19",
"EmpZip": "sample string 20",
"EmpPhone": "sample string 21",
"EmpGender": "sample string 22",
"EmpDOB": "2022-08-25T12:36:53.739Z",
"EmpMaritialStatus": "sample string 23",
"EmpHireDate": "2022-08-25T12:36:53.74Z",
"EmpYearsAtComp": "sample string 24",
"EmpNoOfDependents": 25,
"EmpTypeOfEmployement": "sample string 26",
"EmpDepartment": "sample string 27",
"EmpStateHired": "sample string 28",
"EmpSupervisorName": "sample string 29",
"EmpSupervisorPhone": "sample string 30",
"EmpWeeklyWage": 31.1,
"EmpHourlyWage": 32.1,
"EmpHoursPerWeek": 33.1,
"EmpDaysPerWeek": 34.1,
"EmpHoursPerDay": 35.1,
"EmployementStatus": "sample string 36",
"EmployeeID": "sample string 37",
"EmpPaidInFull": "sample string 38",
"EmpAnyPriorInjuriesYn": "sample string 39",
"EmpSalaryContinueYN": "sample string 40",
"EmployerContactName": "sample string 41",
"EmployerTelephoneNumber": "sample string 42",
"EmployerTitle": "sample string 43",
"EmployerAddress": "sample string 44",
"EmployerCity": "sample string 45",
"EmployerState": "sample string 46",
"EmployerZip": "sample string 47",
"EmployerLocCode": "sample string 48",
"EmployerSIC": "sample string 49",
"EmployerNatureOfBusiness": "sample string 50",
"EmployerName": "sample string 51",
"FEINNumber": "sample string 52",
"AccidentOccuredAtWorkYn": "sample string 53",
"AccidentAddress": "sample string 54",
"AccidentCity": "sample string 55",
"AccidentState": "sample string 56",
"AccidentZip": "sample string 57",
"AccidentDescription": "sample string 58",
"EmpActivityBeforeAccident": "sample string 59",
"ObjectInvolved": "sample string 60",
"JurisdictionState": "sample string 61",
"DateReported": "2022-08-25T12:36:53.753Z",
"TimeReported": "sample string 62",
"FatalityYn": "sample string 63",
"FatalityDate": "2022-08-25T12:36:53.755Z",
"LostTimeYn": "sample string 64",
"FirstFullDayOut": "2022-08-25T12:36:53.755Z",
"DateEmployeeLastWorkedYN": "sample string 65",
"DateEmployeeLastWorked": "2022-08-25T12:36:53.757Z",
"EmpReturnToWorkYn": "sample string 66",
"DateReturnToWork": "2022-08-25T12:36:53.758Z",
"EmpReturnWorkStatus": "sample string 67",
"EstReturnToWorkDate": "2022-08-25T12:36:53.759Z",
"NatureOfinjury": "sample string 68",
"CauseOfinjury": "sample string 69",
"PartOfBody": "sample string 70",
"PartOfBodyLocation": "sample string 71",
"NeedleStickInjuryYn": "sample string 72",
"ReqNeedleStickYn": "sample string 73",
"EmpSentToHospYn": "sample string 74",
"InitialTreatmentYn": "sample string 75",
"HospName": "sample string 76",
"HospAddress": "sample string 77",
"HospCity": "sample string 78",
"HosplAddressState": "sample string 79",
"HospZip": "sample string 80",
"HospPhone": "sample string 81",
"HospFax": "sample string 82",
"DoctName": "sample string 83",
"WitnessYn": "sample string 84",
"WitnessName": "sample string 85",
"WitnessContact": "sample string 86",
"ValidityOfClaimYn": "sample string 87",
"ValidityOfClaimDetails": "sample string 88",
"OtherComments": "sample string 89",
"PrepByName": "sample string 90",
"PrepByPhone": "sample string 91",
"PrepByTitle": "sample string 92",
"EmpOccupation": "sample string 93",
"OshaReference": "sample string 94"
}
],
"Employee first name": "sample string 157",
"Employee middle name": "sample string 158",
"Employee Last name": "sample string 159",
"Employee suffix": "sample string 160",
"supervisor first name": "sample string 161",
"supervisor middle name": "sample string 162",
"Supervisor Last name": "sample string 163",
"supervisor suffix": "sample string 164",
"Incident Own id": "sample string 165",
"USLocationYN": 166,
"Work_activity_done": "sample string 167",
"OccuredDepartment": "sample string 168",
"InitialMedicalTreatment": "sample string 169",
"ReportPrepByName": "sample string 170",
"ReportPrepByPhone": "sample string 171",
"ReportPrepByTitle": "sample string 172",
"Management review Details": [
{
"ROLE": "sample string 1",
" PRIMARY_OWNER": "sample string 2",
"DEFAULT_APPR_DUEDATE": "sample string 3",
"COMMENTS": "sample string 4",
"REVIEW_STATUS": "sample string 5",
"COMPLETED_BY": "sample string 6",
"COMPLETED_DATE": "sample string 7",
"IMSIncidentID": 8
},
{
"ROLE": "sample string 1",
" PRIMARY_OWNER": "sample string 2",
"DEFAULT_APPR_DUEDATE": "sample string 3",
"COMMENTS": "sample string 4",
"REVIEW_STATUS": "sample string 5",
"COMPLETED_BY": "sample string 6",
"COMPLETED_DATE": "sample string 7",
"IMSIncidentID": 8
}
],
"Status of Worker's compensation": "sample string 173",
"Chargable (Yes / No)": "sample string 174",
"Current Case Start Date": "2022-08-25T12:36:53.768Z",
"Current Case End Date": "2022-08-25T12:36:53.768Z",
"Date OSHARecordable Determined": "2022-08-25T12:36:53.769Z"
},
{
"Location Code": "sample string 1",
"Location Name": "sample string 2",
"Incident ID (System Generated)": "sample string 3",
"Incident Internal Id (System Generated)": "sample string 4",
"Incident Title (No Personal data to be entered)": "sample string 5",
"Incident Type": "sample string 6",
"Were multiple people injured as part of this incident?": "sample string 7",
"Is this a MSHA Related Incident?": "sample string 8",
"Is this a MSHA Related Incident Location?": "sample string 9",
"Date of Incident": "2022-08-25T12:36:53.603Z",
"Time of Incident": "sample string 10",
"Time undetermined": "sample string 11",
"Day Of Week": "sample string 12",
"Length of Normal Workday": "sample string 13",
"Work Shift": "sample string 14",
"Time Work Day Began": "sample string 15",
"Description of Incident": "sample string 16",
"Incident Occurred on Employer's Premises": "sample string 17",
"Address of Incident Location": "sample string 18",
"City of Incident Location": "sample string 19",
"County of Incident Location": "sample string 20",
"Country of Incident Location": "sample string 21",
"State/Province of Incident Location": "sample string 22",
"Postal Code/Zip Code of Incident Location": "sample string 23",
"Department": "sample string 24",
"Pin Location": "sample string 25",
"Responsible Department": "sample string 26",
"Responsible Supervisor": "sample string 27",
"Location of Injury Scene": "sample string 28",
"Date Reported to Employer": "2022-08-25T12:36:53.609Z",
"Time Reported to Employer": "sample string 29",
"Confirm Significance Level ID Of Incident": "sample string 30",
"Confirm Significance Level Of Incident": "sample string 31",
"Would you like to submit a Workers Compensation claim?": "sample string 32",
"Personnel Type ID": 33,
"Personnel Type": "sample string 34",
"Employee / Individual Involved (Prefix, First, M.I., Last)": "sample string 35",
"Employee Id": "sample string 36",
"Employee's Social Security Number **": "sample string 37",
"Date of Birth **": "2022-08-25T12:36:53.612Z",
"Gender": "sample string 39",
"Occupation/Job Title": "sample string 40",
"Hire Date": "2022-08-25T12:36:53.614Z",
"Time in Current job": "sample string 41",
"Time in Current job Unit": "sample string 42",
"Employee / Individual Department": "sample string 43",
"Supervisor (First, M.I., Last)": "sample string 44",
"Supervisor's Email": "sample string 45",
"Supervisor Phone": "sample string 46",
"Employee Home Address": "sample string 47",
"Employee City": "sample string 48",
"Employee State": "sample string 49",
"Employee Postal Code/Zip Code": "sample string 50",
"Employee Home Phone Number": "sample string 51",
"Marital Status": "sample string 52",
"Years at Company": "sample string 53",
"Number Of Dependents": 1,
"Type of Employment": "sample string 54",
"Current Weekly Wage": 1.1,
"Hourly Wage": 1.1,
"Hours Worked per Week": 1.1,
"Days worked Per Week": 1,
"Hours worked Per Day": 1,
"State Hired": "sample string 55",
"Employment Status": "sample string 56",
"Was Employee Paid in Full for Date of Injury?": "sample string 57",
"Any Prior WC Injuries?": "sample string 58",
"Do you want to further classify Unsupervised Contract Employee": "sample string 59",
"Type of Client Personnel": "sample string 60",
"Client Company": "sample string 61",
"Name of Contractor": "sample string 62",
"Name of Sub-Contractor": "sample string 63",
"Will employee's salary continue?r": "sample string 64",
"Was Employee treated offsite?": "sample string 65",
"Where was employee treated": "sample string 66",
"Explain Why": "sample string 67",
"If this injury had occurred in a slightly different matter, could it have caused a serious injury or fatality": "sample string 68",
"Did this incident involve an in-patient hospitalization, amputation, or a loss of an eye?": "sample string 69",
"Has OSHA been contacted?": "sample string 70",
"Please Identify OSHA Contact Details (Name and Phone Number)": "sample string 71",
"Nature of Injury / Illness": "sample string 72",
"Cause of Illness/Injury": "sample string 73",
"Injured Body Part": "sample string 74",
"What was the employee doing just before the incident occurred?": "sample string 75",
"Please describe what object or substance directly harmed the employee? If this question does not apply, enter 'not applicable'": "sample string 76",
"Specific Work Activity when the incident occurred": "sample string 77",
" Was any Machine / Equipment involved?": "sample string 78",
"Machine/Equipment Number": "sample string 79",
"Reviewed by EHS Representative": "sample string 80",
"Review Date": "2022-08-25T12:36:53.636Z",
" Is this a Needlestick Injury?": "sample string 81",
" Type": "sample string 82",
"Brand": "sample string 83",
"Model": "sample string 84",
"Identify Initial Treatment": "sample string 85",
"Was Drug Testing Performed": "sample string 86",
"Explain why": "sample string 87",
"RIDDOR Classification": "sample string 88",
"Most Severe Case": "sample string 89",
"Current Case": "sample string 90",
"Health & Safety / WC Contact Name": "sample string 91",
"Employer Telephone Number": "sample string 92",
"Employer Title": "sample string 93",
"Employer Mailing Address": "sample string 94",
"Employer City": "sample string 95",
"Employer State": "sample string 96",
"Employer Postal Code/Zip Code": "sample string 97",
"Employer Location Code": "sample string 98",
"Employer SIC": "sample string 99",
"Nature of Business": "sample string 100",
"Employer FEIN Number": "sample string 101",
"Employer Name": "sample string 102",
"Workers Comp Claim": "sample string 103",
"Is This Claim Work Related": "sample string 104",
"Jurisdiction State": "sample string 105",
"Did the incident result in fatality?": "sample string 106",
"Date fatality occurred": "2022-08-25T12:36:53.644Z",
"Did the employee lose any time from work?": "sample string 107",
"What was the first full day out?": "2022-08-25T12:36:53.645Z",
"Do you know the Date Employee Last Worked?": "sample string 108",
"Date Employee Last Worked": "2022-08-25T12:36:53.646Z",
"Has the employee returned to work?": "sample string 109",
"Date Returned to Work": "2022-08-25T12:36:53.647Z",
"Return to Work Status": "sample string 110",
"Estimated Return to Work Date": "2022-08-25T12:36:53.649Z",
"Reqs Sharps Inj Log": "sample string 111",
"Work Comp Id": "sample string 112",
"Incident Reported By": "sample string 113",
"Reporters Email": "sample string 114",
"Reporters Phone": "sample string 115",
"Injury Date": "2022-08-25T12:36:53.651Z",
"Injury Day": "sample string 116",
"Injury Time": "sample string 117",
"Claim Time Workday Began": "sample string 118",
"Was employee sent to Hospital / Clinic to receive Medical Treatment?": "sample string 119",
"Initial Medical Treatment": "sample string 120",
"Hospital / Clinic Name": "sample string 121",
"Hospital Address": "sample string 122",
"Hospital City": "sample string 123",
"Hospital State": "sample string 124",
"Hospital Postal Code/Zip Code": "sample string 125",
"Hospital Phone": "sample string 126",
"Hospital Fax": "sample string 127",
"Clinic/Doctor Name": "sample string 128",
"Do you question the Validity of the claim?": "sample string 129",
"Provide details": "sample string 130",
"Other Comments": "sample string 131",
"Is Claim Form Completed?": "sample string 132",
"Claim Submission Status": "sample string 133",
"Claim Submitted By": "sample string 134",
"Claim Submitted Date": "2022-08-25T12:36:53.659Z",
"Claim Status": "sample string 135",
"Date Claim Closed": "2022-08-25T12:36:53.659Z",
"Total Cost Incurred": 1.1,
"Total Cost Paid": 1.1,
"Total Outstanding Cost": 1.1,
"Total Developed Cost": 1.1,
"Are there any Witnesses identified?": "sample string 136",
"Witness Information": [
{
"LastName": "sample string 2",
"FirstName": "sample string 3",
"MiddleName": "sample string 4",
"PhoneNumber": "sample string 5",
"Notes": "sample string 6"
},
{
"LastName": "sample string 2",
"FirstName": "sample string 3",
"MiddleName": "sample string 4",
"PhoneNumber": "sample string 5",
"Notes": "sample string 6"
}
],
"Name": "sample string 137",
"Title": "sample string 138",
"Phone": "sample string 139",
"Incident Status": "sample string 140",
"Incident Created By Employee ID": "sample string 141",
"Incident Created By": "sample string 142",
"Incident Created Date": "2022-08-25T12:36:53.668Z",
"Incident Last Updated By": "sample string 143",
"Incident Last Updated Date": "2022-08-25T12:36:53.669Z",
"Was This Claim Work Related": "sample string 144",
"ManagementReviewStatus": "sample string 145",
"Lost Time Days": 1.1,
"Restricted Duty Days": 1.1,
"Recordable (Yes/No)": "sample string 146",
"Workers Comp Claim#": "sample string 147",
"Reason for Non Work Related Classification": "sample string 148",
"Is This a Company defined Recordable Case ?": "sample string 149",
"Worker Comp Id": "sample string 150",
"Please identify the severity of the Incident": "sample string 151",
"Filing State": "sample string 152",
"Is Claim Submission Required?": "sample string 153",
"Claim #": "sample string 154",
"Recent Cost Update": "sample string 155",
"Was employee sent to Hospital/Clinic to receive Medical Treatment?": "sample string 156",
"Root Cause Details": [
{
"Parent Root Cause Name": "sample string 2",
"Root Cause Name": "sample string 3",
"Comments": "sample string 4"
},
{
"Parent Root Cause Name": "sample string 2",
"Root Cause Name": "sample string 3",
"Comments": "sample string 4"
}
],
"5Y Details": [
{
"Evaluation ID": 1,
"Contact Type": "sample string 2",
"Others Description": "sample string 3",
"Contact ID": "sample string 4"
},
{
"Evaluation ID": 1,
"Contact Type": "sample string 2",
"Others Description": "sample string 3",
"Contact ID": "sample string 4"
}
],
"5Ys": [
{
"Evaluation ID": 1,
"Why Label": "sample string 2",
"Why Check": "sample string 3"
},
{
"Evaluation ID": 1,
"Why Label": "sample string 2",
"Why Check": "sample string 3"
}
],
"Investigation questions Details": [
{
"Question ID": 2,
"Question": "sample string 3",
"Answer": {},
"Answer ID": 5,
"Parent Question ID": 6,
"Parent Question": "sample string 7"
},
{
"Question ID": 2,
"Question": "sample string 3",
"Answer": {},
"Answer ID": 5,
"Parent Question ID": 6,
"Parent Question": "sample string 7"
}
],
"Investigation Responsibility Details": [
{
"Target Completion Date": "2022-08-25T12:36:53.685Z",
"Comments": "sample string 1",
"Notify / YN": "sample string 2"
},
{
"Target Completion Date": "2022-08-25T12:36:53.685Z",
"Comments": "sample string 1",
"Notify / YN": "sample string 2"
}
],
"Investigation Responsibility assignee Details": [
{
"UserID": 1,
"Salutation": "sample string 2",
"First Name": "sample string 3",
"Last Name": "sample string 4"
},
{
"UserID": 1,
"Salutation": "sample string 2",
"First Name": "sample string 3",
"Last Name": "sample string 4"
}
],
"Final root cause statement Details": [
{
"IMSIncidentID": 1,
"FinalRootCauseStatement": "sample string 2",
"PrimaryCounterMeasure": "sample string 3",
"PrimaryRootCause": "sample string 4"
},
{
"IMSIncidentID": 1,
"FinalRootCauseStatement": "sample string 2",
"PrimaryCounterMeasure": "sample string 3",
"PrimaryRootCause": "sample string 4"
}
],
"Action Items Details": [
{
"Source ID": "sample string 2",
"Source Title": "sample string 3",
"Action Item Title": "sample string 4",
"Action Item Category": "sample string 5",
"Action Item Type Id": 6,
"Action Item Type": "sample string 7",
"Root Cause": "sample string 8",
"Action Item Description": "sample string 9",
"Action Item Priority": "sample string 10",
"Action Item Due Date": "2022-08-25T12:36:53.693Z",
"Owner": "sample string 11",
"Responsible Department": "sample string 12",
"Counter Measure": "sample string 13",
"Applicable to Expansion?": "sample string 14",
"Description of Actions to be Expanded": "sample string 15",
"Applicable to EEM/EPM Info?": "sample string 16",
"EEM / EPM": "sample string 17",
"EEM/EPM Info Submitted ?": "sample string 18",
"Document Number ": "sample string 19",
"Assigned By": "sample string 20",
"Is Verification Required": 21,
"Verification Required": "sample string 22",
"VerifyUser": "sample string 23",
"Approval Status": "sample string 24",
"Approvers": "sample string 25",
"Approval Comment": "sample string 26",
"Approval Date": "2022-08-25T12:36:53.7Z",
"Action Item Status": "sample string 27",
"Action Taken": "sample string 28",
"Action item Completed By": "sample string 29",
"Action item Completed Date": "2022-08-25T12:36:53.701Z",
"Due Date Extension": "sample string 30",
"Requested Due Date Extension": "2022-08-25T12:36:53.702Z",
"Reason for Due Date Extension": "sample string 31",
"Due Date Extension Request Approved?": "sample string 32",
"Reason for not extending the Due Date": "sample string 33",
"Verification Status": "sample string 34",
"Verification Performed": "sample string 35",
"Verified By": "sample string 36",
"Verification Date": "2022-08-25T12:36:53.705Z",
"Comments": "sample string 37"
},
{
"Source ID": "sample string 2",
"Source Title": "sample string 3",
"Action Item Title": "sample string 4",
"Action Item Category": "sample string 5",
"Action Item Type Id": 6,
"Action Item Type": "sample string 7",
"Root Cause": "sample string 8",
"Action Item Description": "sample string 9",
"Action Item Priority": "sample string 10",
"Action Item Due Date": "2022-08-25T12:36:53.693Z",
"Owner": "sample string 11",
"Responsible Department": "sample string 12",
"Counter Measure": "sample string 13",
"Applicable to Expansion?": "sample string 14",
"Description of Actions to be Expanded": "sample string 15",
"Applicable to EEM/EPM Info?": "sample string 16",
"EEM / EPM": "sample string 17",
"EEM/EPM Info Submitted ?": "sample string 18",
"Document Number ": "sample string 19",
"Assigned By": "sample string 20",
"Is Verification Required": 21,
"Verification Required": "sample string 22",
"VerifyUser": "sample string 23",
"Approval Status": "sample string 24",
"Approvers": "sample string 25",
"Approval Comment": "sample string 26",
"Approval Date": "2022-08-25T12:36:53.7Z",
"Action Item Status": "sample string 27",
"Action Taken": "sample string 28",
"Action item Completed By": "sample string 29",
"Action item Completed Date": "2022-08-25T12:36:53.701Z",
"Due Date Extension": "sample string 30",
"Requested Due Date Extension": "2022-08-25T12:36:53.702Z",
"Reason for Due Date Extension": "sample string 31",
"Due Date Extension Request Approved?": "sample string 32",
"Reason for not extending the Due Date": "sample string 33",
"Verification Status": "sample string 34",
"Verification Performed": "sample string 35",
"Verified By": "sample string 36",
"Verification Date": "2022-08-25T12:36:53.705Z",
"Comments": "sample string 37"
}
],
"Contributing Factors Details": [
{
"Parent Contributing Factor ID": 1,
"Contributing Factor ID": 2,
"Contributing Factor Name": "sample string 3",
"Comments": "sample string 4"
},
{
"Parent Contributing Factor ID": 1,
"Contributing Factor ID": 2,
"Contributing Factor Name": "sample string 3",
"Comments": "sample string 4"
}
],
"Ergo Details": [
{
"Question ID": 1,
"Dependency Question ID": 2,
"Question Lable": "sample string 3",
"Answer ID": "sample string 4"
},
{
"Question ID": 1,
"Dependency Question ID": 2,
"Question Lable": "sample string 3",
"Answer ID": "sample string 4"
}
],
"Case Classification": [
{
"Case Number (System Generated)": "sample string 1",
"Was this case Work-Related?": "sample string 2",
"Describe the reason for the Non Work Related classification": "sample string 3",
"Did this incident result in a fatality?": "sample string 4",
"Did this incident result in an amputation, fractured/cracked bone(s) (including teeth), or loss of consciousness?": "sample string 5",
"Did the incident result in work restrictions, lost time or job transfer?": "sample string 6",
"Was Treatment Provided beyond First Aid?": "sample string 7",
"Did the injury involve a needlestick and cut(s) from sharp objects that are contaminated with another person's blood or other potentially infectious material?": "sample string 8",
"Was treatment defined as First Aid provided?": "sample string 9",
"This is a First Aid Case, identify the specific treatment(s) provided.": "sample string 10",
"Is This a Company defined Recordable Case ?": "sample string 11",
"Describe the reason for the Not Recordable classification": "sample string 12",
"Is this Case Recordable According to Local Record keeping Requirements ?": "sample string 13",
"Does this meet FCA's requirement for FAI Classification?": "sample string 14",
"Did this case involve a chronic injury, a strain or a sprain?": "sample string 15",
"Date Reported to Healthcare": "2022-08-25T12:36:53.716Z",
"Time Reported to Healthcare": "sample string 16",
"Case Status": "sample string 17",
"Title": "sample string 18",
"Phone": "sample string 19",
"Closed Date": "2022-08-25T12:36:53.717Z",
"Comments": "sample string 20",
"Completed By": "sample string 21"
},
{
"Case Number (System Generated)": "sample string 1",
"Was this case Work-Related?": "sample string 2",
"Describe the reason for the Non Work Related classification": "sample string 3",
"Did this incident result in a fatality?": "sample string 4",
"Did this incident result in an amputation, fractured/cracked bone(s) (including teeth), or loss of consciousness?": "sample string 5",
"Did the incident result in work restrictions, lost time or job transfer?": "sample string 6",
"Was Treatment Provided beyond First Aid?": "sample string 7",
"Did the injury involve a needlestick and cut(s) from sharp objects that are contaminated with another person's blood or other potentially infectious material?": "sample string 8",
"Was treatment defined as First Aid provided?": "sample string 9",
"This is a First Aid Case, identify the specific treatment(s) provided.": "sample string 10",
"Is This a Company defined Recordable Case ?": "sample string 11",
"Describe the reason for the Not Recordable classification": "sample string 12",
"Is this Case Recordable According to Local Record keeping Requirements ?": "sample string 13",
"Does this meet FCA's requirement for FAI Classification?": "sample string 14",
"Did this case involve a chronic injury, a strain or a sprain?": "sample string 15",
"Date Reported to Healthcare": "2022-08-25T12:36:53.716Z",
"Time Reported to Healthcare": "sample string 16",
"Case Status": "sample string 17",
"Title": "sample string 18",
"Phone": "sample string 19",
"Closed Date": "2022-08-25T12:36:53.717Z",
"Comments": "sample string 20",
"Completed By": "sample string 21"
}
],
"Case Progression Tracking": [
{
"Employee Name": "sample string 1",
"Classification Of Case Id": 2,
"Classification of Case": "sample string 3",
"Date Reported": "2022-08-25T12:36:53.72Z",
"Date First Aid Provided": "2022-08-25T12:36:53.72Z",
"Date other Recordable case Occurred": "2022-08-25T12:36:53.721Z",
"First Day of Restricted Duty": "2022-08-25T12:36:53.721Z",
"Last Day of Restricted Duty": "2022-08-25T12:36:53.721Z",
"First Day of Lost Time": "2022-08-25T12:36:53.722Z",
"Last Day of Lost Time": "2022-08-25T12:36:53.722Z",
"Date Fatality Occurred.": "2022-08-25T12:36:53.723Z",
"Reason for Classification": "sample string 4",
"Reason for Classification Pick List": "sample string 5",
"Is This A Defense Based Act Case?": "sample string 6",
"Is This A Compensable Case?": "sample string 7",
"Comments": "sample string 8",
"Official Medical Diagnosis (Nature of Injury / Illness)": "sample string 9",
"Was the Corporate Medical Director contacted?": "sample string 10",
"Was Medical Treatment Rejected?": "sample string 11",
"Reason for Refusal": "sample string 12",
"Was Treatment Provided beyond First Aid?": "sample string 13",
"Was Treatment provided offsite?": "sample string 14",
"Hospital/Clinic Name": "sample string 15",
"Type": "sample string 16",
"Physician/Health care Provider": "sample string 17",
"Street": "sample string 18",
"City": "sample string 19",
"Country": "sample string 20",
"State": "sample string 21",
"Postal Code/Zip Code": "sample string 22",
"Phone": "sample string 23",
"FAX": "sample string 24",
"Was the employee treated in an emergency room": "sample string 25",
"Was employee hospitalized overnight as an in-patient": "sample string 26",
"Recording/Revision Date": "2022-08-25T12:36:53.73Z"
},
{
"Employee Name": "sample string 1",
"Classification Of Case Id": 2,
"Classification of Case": "sample string 3",
"Date Reported": "2022-08-25T12:36:53.72Z",
"Date First Aid Provided": "2022-08-25T12:36:53.72Z",
"Date other Recordable case Occurred": "2022-08-25T12:36:53.721Z",
"First Day of Restricted Duty": "2022-08-25T12:36:53.721Z",
"Last Day of Restricted Duty": "2022-08-25T12:36:53.721Z",
"First Day of Lost Time": "2022-08-25T12:36:53.722Z",
"Last Day of Lost Time": "2022-08-25T12:36:53.722Z",
"Date Fatality Occurred.": "2022-08-25T12:36:53.723Z",
"Reason for Classification": "sample string 4",
"Reason for Classification Pick List": "sample string 5",
"Is This A Defense Based Act Case?": "sample string 6",
"Is This A Compensable Case?": "sample string 7",
"Comments": "sample string 8",
"Official Medical Diagnosis (Nature of Injury / Illness)": "sample string 9",
"Was the Corporate Medical Director contacted?": "sample string 10",
"Was Medical Treatment Rejected?": "sample string 11",
"Reason for Refusal": "sample string 12",
"Was Treatment Provided beyond First Aid?": "sample string 13",
"Was Treatment provided offsite?": "sample string 14",
"Hospital/Clinic Name": "sample string 15",
"Type": "sample string 16",
"Physician/Health care Provider": "sample string 17",
"Street": "sample string 18",
"City": "sample string 19",
"Country": "sample string 20",
"State": "sample string 21",
"Postal Code/Zip Code": "sample string 22",
"Phone": "sample string 23",
"FAX": "sample string 24",
"Was the employee treated in an emergency room": "sample string 25",
"Was employee hospitalized overnight as an in-patient": "sample string 26",
"Recording/Revision Date": "2022-08-25T12:36:53.73Z"
}
],
"WCC InjuryIllness": [
{
"IMSIncidentID": 1,
"IncidentClaimYN": "sample string 2",
"WorkCompId": "sample string 3",
"TPAID": "sample string 4",
"IncidentReportedBy": "sample string 5",
"ReportersEmail": "sample string 6",
"ReportersPhone": "sample string 7",
"InjuryDate": "2022-08-25T12:36:53.734Z",
"InjuryDay": "sample string 8",
"InjuryTime": "sample string 9",
"TimeWorkdayBegan": "sample string 10",
"IncidentInternalId": "sample string 11",
"ClaimWorkRelatedYn": "sample string 12",
"EmpSSN": "sample string 13",
"EmpFirstName": "sample string 14",
"EmpMiddleName": "sample string 15",
"EmpLastName": "sample string 16",
"EmpStreet": "sample string 17",
"EmpCity": "sample string 18",
"EmpState": "sample string 19",
"EmpZip": "sample string 20",
"EmpPhone": "sample string 21",
"EmpGender": "sample string 22",
"EmpDOB": "2022-08-25T12:36:53.739Z",
"EmpMaritialStatus": "sample string 23",
"EmpHireDate": "2022-08-25T12:36:53.74Z",
"EmpYearsAtComp": "sample string 24",
"EmpNoOfDependents": 25,
"EmpTypeOfEmployement": "sample string 26",
"EmpDepartment": "sample string 27",
"EmpStateHired": "sample string 28",
"EmpSupervisorName": "sample string 29",
"EmpSupervisorPhone": "sample string 30",
"EmpWeeklyWage": 31.1,
"EmpHourlyWage": 32.1,
"EmpHoursPerWeek": 33.1,
"EmpDaysPerWeek": 34.1,
"EmpHoursPerDay": 35.1,
"EmployementStatus": "sample string 36",
"EmployeeID": "sample string 37",
"EmpPaidInFull": "sample string 38",
"EmpAnyPriorInjuriesYn": "sample string 39",
"EmpSalaryContinueYN": "sample string 40",
"EmployerContactName": "sample string 41",
"EmployerTelephoneNumber": "sample string 42",
"EmployerTitle": "sample string 43",
"EmployerAddress": "sample string 44",
"EmployerCity": "sample string 45",
"EmployerState": "sample string 46",
"EmployerZip": "sample string 47",
"EmployerLocCode": "sample string 48",
"EmployerSIC": "sample string 49",
"EmployerNatureOfBusiness": "sample string 50",
"EmployerName": "sample string 51",
"FEINNumber": "sample string 52",
"AccidentOccuredAtWorkYn": "sample string 53",
"AccidentAddress": "sample string 54",
"AccidentCity": "sample string 55",
"AccidentState": "sample string 56",
"AccidentZip": "sample string 57",
"AccidentDescription": "sample string 58",
"EmpActivityBeforeAccident": "sample string 59",
"ObjectInvolved": "sample string 60",
"JurisdictionState": "sample string 61",
"DateReported": "2022-08-25T12:36:53.753Z",
"TimeReported": "sample string 62",
"FatalityYn": "sample string 63",
"FatalityDate": "2022-08-25T12:36:53.755Z",
"LostTimeYn": "sample string 64",
"FirstFullDayOut": "2022-08-25T12:36:53.755Z",
"DateEmployeeLastWorkedYN": "sample string 65",
"DateEmployeeLastWorked": "2022-08-25T12:36:53.757Z",
"EmpReturnToWorkYn": "sample string 66",
"DateReturnToWork": "2022-08-25T12:36:53.758Z",
"EmpReturnWorkStatus": "sample string 67",
"EstReturnToWorkDate": "2022-08-25T12:36:53.759Z",
"NatureOfinjury": "sample string 68",
"CauseOfinjury": "sample string 69",
"PartOfBody": "sample string 70",
"PartOfBodyLocation": "sample string 71",
"NeedleStickInjuryYn": "sample string 72",
"ReqNeedleStickYn": "sample string 73",
"EmpSentToHospYn": "sample string 74",
"InitialTreatmentYn": "sample string 75",
"HospName": "sample string 76",
"HospAddress": "sample string 77",
"HospCity": "sample string 78",
"HosplAddressState": "sample string 79",
"HospZip": "sample string 80",
"HospPhone": "sample string 81",
"HospFax": "sample string 82",
"DoctName": "sample string 83",
"WitnessYn": "sample string 84",
"WitnessName": "sample string 85",
"WitnessContact": "sample string 86",
"ValidityOfClaimYn": "sample string 87",
"ValidityOfClaimDetails": "sample string 88",
"OtherComments": "sample string 89",
"PrepByName": "sample string 90",
"PrepByPhone": "sample string 91",
"PrepByTitle": "sample string 92",
"EmpOccupation": "sample string 93",
"OshaReference": "sample string 94"
},
{
"IMSIncidentID": 1,
"IncidentClaimYN": "sample string 2",
"WorkCompId": "sample string 3",
"TPAID": "sample string 4",
"IncidentReportedBy": "sample string 5",
"ReportersEmail": "sample string 6",
"ReportersPhone": "sample string 7",
"InjuryDate": "2022-08-25T12:36:53.734Z",
"InjuryDay": "sample string 8",
"InjuryTime": "sample string 9",
"TimeWorkdayBegan": "sample string 10",
"IncidentInternalId": "sample string 11",
"ClaimWorkRelatedYn": "sample string 12",
"EmpSSN": "sample string 13",
"EmpFirstName": "sample string 14",
"EmpMiddleName": "sample string 15",
"EmpLastName": "sample string 16",
"EmpStreet": "sample string 17",
"EmpCity": "sample string 18",
"EmpState": "sample string 19",
"EmpZip": "sample string 20",
"EmpPhone": "sample string 21",
"EmpGender": "sample string 22",
"EmpDOB": "2022-08-25T12:36:53.739Z",
"EmpMaritialStatus": "sample string 23",
"EmpHireDate": "2022-08-25T12:36:53.74Z",
"EmpYearsAtComp": "sample string 24",
"EmpNoOfDependents": 25,
"EmpTypeOfEmployement": "sample string 26",
"EmpDepartment": "sample string 27",
"EmpStateHired": "sample string 28",
"EmpSupervisorName": "sample string 29",
"EmpSupervisorPhone": "sample string 30",
"EmpWeeklyWage": 31.1,
"EmpHourlyWage": 32.1,
"EmpHoursPerWeek": 33.1,
"EmpDaysPerWeek": 34.1,
"EmpHoursPerDay": 35.1,
"EmployementStatus": "sample string 36",
"EmployeeID": "sample string 37",
"EmpPaidInFull": "sample string 38",
"EmpAnyPriorInjuriesYn": "sample string 39",
"EmpSalaryContinueYN": "sample string 40",
"EmployerContactName": "sample string 41",
"EmployerTelephoneNumber": "sample string 42",
"EmployerTitle": "sample string 43",
"EmployerAddress": "sample string 44",
"EmployerCity": "sample string 45",
"EmployerState": "sample string 46",
"EmployerZip": "sample string 47",
"EmployerLocCode": "sample string 48",
"EmployerSIC": "sample string 49",
"EmployerNatureOfBusiness": "sample string 50",
"EmployerName": "sample string 51",
"FEINNumber": "sample string 52",
"AccidentOccuredAtWorkYn": "sample string 53",
"AccidentAddress": "sample string 54",
"AccidentCity": "sample string 55",
"AccidentState": "sample string 56",
"AccidentZip": "sample string 57",
"AccidentDescription": "sample string 58",
"EmpActivityBeforeAccident": "sample string 59",
"ObjectInvolved": "sample string 60",
"JurisdictionState": "sample string 61",
"DateReported": "2022-08-25T12:36:53.753Z",
"TimeReported": "sample string 62",
"FatalityYn": "sample string 63",
"FatalityDate": "2022-08-25T12:36:53.755Z",
"LostTimeYn": "sample string 64",
"FirstFullDayOut": "2022-08-25T12:36:53.755Z",
"DateEmployeeLastWorkedYN": "sample string 65",
"DateEmployeeLastWorked": "2022-08-25T12:36:53.757Z",
"EmpReturnToWorkYn": "sample string 66",
"DateReturnToWork": "2022-08-25T12:36:53.758Z",
"EmpReturnWorkStatus": "sample string 67",
"EstReturnToWorkDate": "2022-08-25T12:36:53.759Z",
"NatureOfinjury": "sample string 68",
"CauseOfinjury": "sample string 69",
"PartOfBody": "sample string 70",
"PartOfBodyLocation": "sample string 71",
"NeedleStickInjuryYn": "sample string 72",
"ReqNeedleStickYn": "sample string 73",
"EmpSentToHospYn": "sample string 74",
"InitialTreatmentYn": "sample string 75",
"HospName": "sample string 76",
"HospAddress": "sample string 77",
"HospCity": "sample string 78",
"HosplAddressState": "sample string 79",
"HospZip": "sample string 80",
"HospPhone": "sample string 81",
"HospFax": "sample string 82",
"DoctName": "sample string 83",
"WitnessYn": "sample string 84",
"WitnessName": "sample string 85",
"WitnessContact": "sample string 86",
"ValidityOfClaimYn": "sample string 87",
"ValidityOfClaimDetails": "sample string 88",
"OtherComments": "sample string 89",
"PrepByName": "sample string 90",
"PrepByPhone": "sample string 91",
"PrepByTitle": "sample string 92",
"EmpOccupation": "sample string 93",
"OshaReference": "sample string 94"
}
],
"Employee first name": "sample string 157",
"Employee middle name": "sample string 158",
"Employee Last name": "sample string 159",
"Employee suffix": "sample string 160",
"supervisor first name": "sample string 161",
"supervisor middle name": "sample string 162",
"Supervisor Last name": "sample string 163",
"supervisor suffix": "sample string 164",
"Incident Own id": "sample string 165",
"USLocationYN": 166,
"Work_activity_done": "sample string 167",
"OccuredDepartment": "sample string 168",
"InitialMedicalTreatment": "sample string 169",
"ReportPrepByName": "sample string 170",
"ReportPrepByPhone": "sample string 171",
"ReportPrepByTitle": "sample string 172",
"Management review Details": [
{
"ROLE": "sample string 1",
" PRIMARY_OWNER": "sample string 2",
"DEFAULT_APPR_DUEDATE": "sample string 3",
"COMMENTS": "sample string 4",
"REVIEW_STATUS": "sample string 5",
"COMPLETED_BY": "sample string 6",
"COMPLETED_DATE": "sample string 7",
"IMSIncidentID": 8
},
{
"ROLE": "sample string 1",
" PRIMARY_OWNER": "sample string 2",
"DEFAULT_APPR_DUEDATE": "sample string 3",
"COMMENTS": "sample string 4",
"REVIEW_STATUS": "sample string 5",
"COMPLETED_BY": "sample string 6",
"COMPLETED_DATE": "sample string 7",
"IMSIncidentID": 8
}
],
"Status of Worker's compensation": "sample string 173",
"Chargable (Yes / No)": "sample string 174",
"Current Case Start Date": "2022-08-25T12:36:53.768Z",
"Current Case End Date": "2022-08-25T12:36:53.768Z",
"Date OSHARecordable Determined": "2022-08-25T12:36:53.769Z"
}
]Injury/Illness and Claim Field List
| Section | Field Name | Database Column Size |
|---|---|---|
| Incident Detail | ||
| Incident ID * | NVARCHAR(400) | |
| Internal Incident ID | NVARCHAR(200) | |
| Incident Title/Site* | NVARCHAR(400) | |
| Incident Type * | INT | |
| Location Code | NVARCHAR(400) | |
| Location | NVARCHAR(400) | |
| Were multiple people injured as part of this incident? | NVARCHAR(50) | |
| General Details | ||
| Is this a MSHA Related Incident*? | NVARCHAR(100) | |
| Date of Incident * | DATETIME | |
| Time of Incident * | NVARCHAR(100) | |
| Time undetermined | NVARCHAR(10) | |
| Day Of Week ** | NVARCHAR(100) | |
| Length of Normal Workday | NVARCHAR(100) | |
| Work Shift ** | INT | |
| Time Work Day Began ** | NVARCHAR(200) | |
| Description of Incident * | NVARCHAR(8000) | |
| Incident Occurred on Employer's Premises * | NVARCHAR(6) | |
| Address of Incident Location * | NVARCHAR(1000) | |
| City * | NVARCHAR(100) | |
| County | NVARCHAR(100) | |
| Country * | NVARCHAR(100) | |
| State/Province * | NVARCHAR(100) | |
| Postal Code/Zip Code | NVARCHAR(100) | |
| Department * | INT | |
| Department where the incident/injury occurred | INT | |
| Location of Injury Scene | NVARCHAR(1000) | |
| Date and Time Reported to Employer | DATETIME | |
| Confirm Significance Level ID of Incident | NVARCHAR(200) | |
| Confirm Significance level of incident | INT | |
| Employee / Individual Details | ||
| Would you like to submit a Workers Compensation claim? * | NVARCHAR(100) | |
| Personal Type ID* | INT | |
| Personnel Type * | NVARCHAR(200) | |
| Employee / Individual Involved ( Last, First, M.I.) * | NVARCHAR(200), NVARCHAR(200), NVARCHAR(200) | |
| Employee Id * | NVARCHAR(200) | |
| Employee's Social Security Number ** | NVARCHAR(200) | |
| Date of Birth ** | datetime | |
| Gender ** | NVARCHAR(200) | |
| Occupation/Job Title ** | NVARCHAR(200) | |
| Hire Date ** | DATETIME | |
| Time in Current job | NVARCHAR(200) | |
| Time in Current job Unit | NVARCHAR(200) | |
| Employee / Individual Department | INT | |
| Supervisor ( Last, First, M.I) | INT | |
| Supervisor's Email | NVARCHAR(50) | |
| Supervisor Phone | NVARCHAR(50) | |
| Home Address | NVARCHAR(500) | |
| City | NVARCHAR(50) | |
| State | NVARCHAR(50) | |
| Postal Code/Zip Code | NVARCHAR(50) | |
| Home Phone Number | NVARCHAR(50) | |
| Marital Status | NVARCHAR(50) | |
| Years at "Company" | NVARCHAR(50) | |
| Number Of Dependents | INT | |
| Type of Employment | NVARCHAR(100) | |
| Current Weekly Wage | FLOAT | |
| Hourly Wage | FLOAT | |
| Hours Worked per Week | FLOAT | |
| Days worked Per Week | INT | |
| Hours worked Per Day | INT | |
| State Hired | NVARCHAR(50) | |
| Employment Status | NVARCHAR(50) | |
| Was Employee Paid in Full for Date of Injury? | NVARCHAR(50) | |
| Any Prior WC Injuries? | NVARCHAR(50) | |
| Do you want to further classify Unsupervised Contract Employee | NVARCHAR(50) | |
| Type of Client Personnel | NVARCHAR(20) | |
| Client Company | NVARCHAR(100) | |
| Name of Contractor | NVARCHAR(800) | |
| Name of Sub-Contractor | NVARCHAR(800) | |
| Will employee's salary continue? | NVARCHAR(50) | |
| Injury/Illness Summary | ||
| Was Employee treated offsite? ** | NVARCHAR(50) | |
| Where was employee treated | NVARCHAR(1000) | |
| Explain Why | NVARCHAR(1000) | |
| If this injury had occurred in a slightly different matter, could it have caused a serious injury or fatality | NVARCHAR(1000) | |
| Did this incident involve an in-patient hospitalization, amputation, or a loss of an eye? | NVARCHAR(1000) | |
| Has OSHA been contacted? | NVARCHAR(500) | |
| Please Identify OSHA Contact Details (Name and Phone Number) | NVARCHAR(500) | |
| Nature of Injury / Illness ** | INT | |
| Cause of Illness/Injury ** | INT | |
| Injured Body Part ** | INT | |
| What was the employee doing just before the incident occurred? * | NVARCHAR(4000) | |
| Please describe what object or substance directly harmed the employee? If this question does not apply, enter “not applicable” ** | NVARCHAR(MAX) | |
| Specific Work Activity when the incident occurred | NVARCHAR(4000) | |
| Was any Machine / Equipment involved? | NVARCHAR(4000) | |
| Machine/Equipment Number | NVARCHAR(100) | |
| Reviewed by EHS Representative | NVARCHAR(4000) | |
| Review Date | DATETIME | |
| Is this a Needlestick Injury? | VARCHAR(50) | |
| Type | NVARCHAR(100) | |
| Brand | NVARCHAR(100) | |
| Model | NVARCHAR(100) | |
| Identify Initial Treatment | NVARCHAR(100) | |
| Was Drug Testing Performed? | NVARCHAR(10) | |
| Explain Why | [NVARCHAR](1000) | |
| RIDDOR Classification | ||
| RIDDOR Classification | NVARCHAR(100) | |
| Employer Information | ||
| Health & Safety / WC Contact Name | NVARCHAR(50) | |
| Telephone Number | NVARCHAR(50) | |
| Title | NVARCHAR(50) | |
| Mailing Address | NVARCHAR(500) | |
| City | NVARCHAR(50) | |
| State | NVARCHAR(20) | |
| Postal Code/Zip Code | NVARCHAR(50) | |
| Employer Location Code | NVARCHAR(50) | |
| Employer SIC | NVARCHAR(50) | |
| Nature of Business | NVARCHAR(500) | |
| Employer FEIN Number | NVARCHAR(20) | |
| Employer Name | NVARCHAR (100) | |
| Injury Information | ||
| Workers Comp Claim# | NVARCHAR(50) | |
| Is This Claim Work Related | NVARCHAR (50) | |
| Jurisdiction State | NVARCHAR (100) | |
| Did the incident result in fatality? | NVARCHAR(50) | |
| Date fatality occurred | DATETIME | |
| Did the employee lose any time from work? | NVARCHAR(50) | |
| What was the first full day out? | DATETIME | |
| Do you know the Date Employee Last Worked? | NVARCHAR(50) | |
| Date Employee Last Worked | DATETIME | |
| Has the employee returned to work? | NVARCHAR(50) | |
| Date Returned to Work | DATETIME | |
| Return to Work Status | NVARCHAR(50) | |
| Estimated Return to Work Date | DATETIME | |
| Reqs Sharps Inj Log | NVARCHAR(50) | |
| Work Comp Id | NVARCHAR(50) | |
| Reported By | NVARCHAR(100) | |
| Reporters Email | NVARCHAR(50) | |
| Reporters Phone | NVARCHAR(50) | |
| Date | DATETIME | |
| Day | NVARCHAR(50) | |
| Time | NVARCHAR(50) | |
| Claim Time Workday Began | NVARCHAR(200) | |
| Medical Information | ||
| Was employee sent to Hospital / Clinic to receive Medical Treatment? ** | NVARCHAR(50) | |
| Initial Medical Treatment | NNVARCHAR(50) | |
| Hospital / Clinic Name | NVARCHAR(500) | |
| Address | NVARCHAR(500) | |
| City | NVARCHAR(50) | |
| State | NVARCHAR(50) | |
| Postal Code/Zip Code | NVARCHAR(50) | |
| Phone | NVARCHAR(50) | |
| Fax | NVARCHAR(50) | |
| Clinic/Doctor Name | NVARCHAR(50) | |
| Additional Comments and Information | ||
| Do you question the Validity of the claim? | NVARCHAR(50) | |
| Provide details | NVARCHAR(500) | |
| Other Comments | NVARCHAR(500) | |
| Additional Claim Information | ||
| Claim Form Completed | NVARCHAR(100) | |
| Claim Submission Status | NVARCHAR(200) | |
| Claim Submitted By | NVARCHAR(200) | |
| Claim Submitted Date | DATETIME | |
| Claim Status | NVARCHAR(100) | |
| Date Claim Closed | DATETIME | |
| Total Cost Incurred | FLOAT | |
| Total Cost Paid | FLOAT | |
| Total Outstanding Cost | FLOAT | |
| Total Developed Cost | FLOAT | |
| Witness Information | ||
| Are there any Witnesses identified? | NVARCHAR(20) | |
| Number of Witnesses | INT | |
| Last Name | NVARCHAR(50) | |
| First Name | NVARCHAR(50) | |
| Middle Name | NVARCHAR(50) | |
| Phone Number | NVARCHAR(100) | |
| Notes | NVARCHAR(2000) | |
| Witness relation to <CUSTOMER> Coworker, friend, public, supervisor, venue employee | NVARCHAR(500) | |
| Report Prepared By: | ||
| Name | NVARCHAR(50) | |
| Title | NVARCHAR(50) | |
| Phone | NVARCHAR(50) | |
| Additional Incident Information | ||
| Incident Status | NVARCHAR(100) | |
| Created By Employee ID | NVARCHAR(50) | |
| Created By | NVARCHAR(100) | |
| Created Date | DATETIME | |
| Last Updated By | NVARCHAR(100) | |
| Last Updated Date | DATETIME | |
Case Management Field List
| Section | Field Name | Database Column Size |
|---|---|---|
| Case Managemnet | ||
| Current Case | NVARCHAR(500) | |
| Most Severe Case | NVARCHAR(500) | |
| Recordable | NVARCHAR(500) | |
| Status of Worker's compensation | NVARCHAR(500) | |
| Current Case Start Date | DATETIME | |
| Current Case End Date | DATETIME | |
| Date OSHARecordable Determined | DATETIME | |
| Classification Of Case | ||
| Case Number | NVARCHAR(500) | |
| Was this case Work-Related? | NVARCHAR(50) | |
| Describe the reason for the "Non Work Related" classification | NVARCHAR(1000) | |
| Did this incident result in a fatality? | NVARCHAR(100) | |
| Did this incident result in an amputation, fractured/cracked bone(s) (including teeth), or loss of consciousness? | NVARCHAR(100) | |
| Did the incident result in work restrictions, lost time or job transfer? | NVARCHAR(100) | |
| Was Treatment Provided beyond First Aid? (Prescription strength medications, Application of wound closing devices, Intravenous Fluids). | NVARCHAR(100) | |
| Did the injury involve a needlestick and cut(s) from sharp objects that are contaminated with another person's blood or other potentially infectious material? | NVARCHAR(100) | |
| Was treatment defined as "First Aid" provided? | NVARCHAR(100) | |
| This is a First Aid Case, identify the specific treatment(s) provided. | INT | |
| Is This a Company defined Recordable Case ? | NVARCHAR(50) | |
| Describe the reason for the "Not Recordable" classification | NVARCHAR(500) | |
| Is this Case Recordable According to Local Recordkeeping Requirements? | NVARCHAR(50) | |
| Does this meet FCA's requirement for FAI classification | NVARCHAR(50) | |
| Did this case involve a chronic injury, a strain or a sprain? * | NVARCHAR(50) | |
| Date reported to Health Care Center | DATETIME | |
| Time reported to Health Care Center | NVARCHAR(50) | |
| Case Status | NVARCHAR(50) | |
| Date | DATETIME | |
| Comments/Notes | NVARCHAR(MAX) | |
| Completed By | INT | |
| Title | NVARCHAR(50) | |
| Phone | NVARCHAR(50) | |
| Close Date | DATETIME | |
| Case Progression Tracking | ||
| Employee Name | NVARCHAR(200) | |
| Classification of Case | INT | |
| Date Reported | DATETIME | |
| Date First Aid Provided | DATETIME | |
| Date other Recordable case Occurred | DATETIME | |
| First Day of Restricted Duty | DATETIME | |
| Last Day of Restricted Duty | DATETIME | |
| First Day of Lost Time | DATETIME | |
| Last Day of Lost Time | DATETIME | |
| Date Fatality Occurred | DATETIME | |
| Reason for Classification | NVARCHAR(500) | |
| Reason for Classification Pick List | NVARCHAR(500) | |
| Is This A Defense Based Act Case? | NVARCHAR(50) | |
| Is This A Compensable Case? | NVARCHAR(50) | |
| Comments/Notes | NVARCHAR(500) | |
| Official Medical Diagnosis (Nature of Injury / Illness) | NVARCHAR(100) | |
| Was the Corporate Medical Director contacted? | NVARCHAR(50) | |
| Was medical Treatment Rejected? | NVARCHAR(50) | |
| Reason for Refusal | NVARCHAR(500) | |
| Was Treatment Provided beyond First Aid?(Prescription strength medications, Application of wound closing devices, Intravenous Fluids) | NVARCHAR(50) | |
| Was Treatment provided offsite? | NVARCHAR(10) | |
| Hospital/Clinic Name | NVARCHAR(500) | |
| Type | NVARCHAR(50) | |
| Physician/Health care Provider | NVARCHAR(50) | |
| Street | NVARCHAR(200) | |
| City | NVARCHAR(100) | |
| Country | INT | |
| State | NVARCHAR(50) | |
| Postal Code/Zip Code | NVARCHAR(50) | |
| Phone | NVARCHAR(50) | |
| Fax | NVARCHAR(100) | |
| Was the employee treated in an emergency room | NVARCHAR(50) | |
| Was employee hospitalized overnight as an in-patient | NVARCHAR(50) | |
| Recording/Revision Date | DATETIME | |
Investigation Sections Field List (Common to All Incident Types)
| Section | Field Name | Database Column Size |
|---|---|---|
| Investigation Responsibility | ||
| Responsible Team * | ||
| Target Completion Date * | DATE | |
| Note/Comments | NVARCHAR(2000) | |
| Investigation Questions | ||
| All Questions | NVARCHAR(2000) | |
| All Answers | NVARCHAR(500) | |
| All Dependencies | INT / INT | |
| Questions Configuration based on Business Types & Operation Types (Near Miss & Injury / Illness) | INT / INT / INT | |
| Ergonomic Analysis (Applicable only when respective question in Investigation Details is answered as Yes) | ||
| All Questions | VARCHAR(2000) | |
| All Answers | NVARCHAR(500) | |
| All Picklist Answer | NVARCHAR(500) | |
| All Dependencies | INT / INT | |
| Incident Specific Questions and its answers | INT / INT / INT | |
| Contributing Factors | ||
| Contributing Factors | INT / INT | |
| 5 Why ? Methodology | ||
| Root Cause Evaluation | INT / INT | |
| Contributing Factors | INT / NVARCHAR(50) | |
| Whys | NVARCHAR(2000) | |
| Check this box (If the above is FINAL ROOT CAUSE) | NVARCHAR(2000) | |
| Root Cause Analysis | ||
| Root Cause analysis | INT / INT | |
| Comments | ||
| Final Root Cause Statement | ||
| Final Root cause statement | NVARCHAR(4000) | |
| Primary Countermeasure | INT / INT | |
| Primary Root Cause | INT | |
| Release / Impacts | ||
| Environmental Media | INT | |
| Impacts | NVARCHAR(500) | |
| Comments/Notes | NVARCHAR(500) | |
| Critique of response / Follow up | ||
| All Questions | NVARCHAR(2000) | |
| All Answers | NVARCHAR(500) | |
| All Dependencies | INT / INT | |
Action Item Field List (Common to All Incident Types)
| Section | Field Name | Database Column Size |
|---|---|---|
| Source Details | ||
| Source ID | NVARCHAR(400) | |
| Source Title | NVARCHAR(400) | |
| Management Review Role | VARCHAR(50) | |
| TMS Enabled Department | NVARCHAR(50) | |
| TMS Work Order Number | NVARCHAR(100) | |
| Create | ||
| Action Item Title | NVARCHAR(50) | |
| Action Item Category | NVARCHAR (2000) | |
| Action Item Type | NVARCHAR(50) | |
| Root Cause | NVARCHAR(MAX) | |
| Action Item Description | NVARCHAR(2000) | |
| Action Item Priority | NVARCHAR(1000) | |
| Action Item Due Date | DATETIME | |
| Owner | INT, NVARCHAR(50) | |
| Responsible Department | INT,NVARCHAR(MAX) | |
| Countermeasure | INT,NVARCHAR(MAX) | |
| Applicable to Expansion? | NVARCHAR(10) | |
| Description of Actions to be Expanded * | NVARCHAR(1000) | |
| Applicable to EEM/EPM Info ? | NVARCHAR(10) | |
| EEM / EPM * | NVARCHAR(10) | |
| EEM/EPM Info Submitted ? | NVARCHAR(10) | |
| Document Number * | NVARCHAR(200) | |
| Assigned By | VARCHAR(50) | |
| Verification required | INT, NVARCHAR(50) | |
| Verify User | NVARCHAR(MAX) | |
| Approval | ||
| Approval Status | INT, NVARCHAR(100) | |
| Approvers | NVARCHAR(MAX) | |
| Approval Comment | NVARCHAR(2000) | |
| Approval Date | DATETIME | |
| Complete | ||
| Action Item Status | NVARCHAR(200) | |
| Action Taken | NVARCHAR(2000) | |
| Action item Completed By | VARCHAR(1000) | |
| Action item Completed Date | DATETIME | |
| Due Date Extension | NVARCHAR(50) | |
| Requested Due Date Extension | NCHAR(10) | |
| Reason for Due Date Extension | NVARCHAR(2000) | |
| Due Date Extension Request Approved? | NVARCHAR(2000) | |
| Reason for not extending the Due Date. | DATETIME | |
| Review/Verify | ||
| Verification Status | INT | |
| Verification Performed | VARCHAR(50) | |
| Verified By | INT | |
| Verification Date | DATETIME | |
| Comments | NVARCHAR(2000) | |
| Cost Information | ||
| Capital Expenditure involved | ||
| Approximate cost | ||
| Estimated Budget | ||
Environmental
Incident Details
Request
GET papi/v1/imsoutbound/environmentalincidents?locationCode={locationCode}&dateFrom={dateFrom}&dateTo={dateTo}&lastSyncedDate={lastSyncedDate}
Ex: papi/v1/imsoutbound/environmentalincidents?locationCode=westlake&dateFrom=2019-07-01&dateTo=2019-07-30&lastSyncedDate=2019-01-01
URI Parameters
Location Code, DateFrom, DateTo and LastSyncedDate are to be passed as parameters.
DateFrom and DateTo are required when LastSyncedDate is not provided.
When DateFrom, DateTo and LastSyncedDate are provided, data will be returned based on LastSyncedDate only.
| Name | Description | Type | Additional information |
|---|---|---|---|
| locationCode | Represents the unique code of location for which Incident records to return. | string | Required |
| dateFrom | Represents the starting date of Incident records to return. | date | Required but value optional |
| dateTo | Represents the ending date of Incident records to return. | date | Required but value optional |
| lastSyncedDate | Represents the data from incident created date or incident modified date. | date | Required but value optional |
Headers
| Name | Description | Sample |
|---|---|---|
| Authorization | Represents the value of the authentication token. Allow multiple values: no. | Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ... |
| ConsumerId | Represents the value of the consumer id. Allow multiple values: no. | 2222 |
Sample Response:
[
{
"Environmental Incident Details": {
"Incident Details": {
"Incident Internal ID": "US-WESTLAKE-17-I-0040",
"Incident ID (System Generated)": "US-WESTLAKE-17-E-0007",
"Incident Title/Site": "Multiple Injuries",
"Incident Type": "Environmental/Radiological",
"Location Code": "Westlake",
"Location": "Westlake"
},
"General Details": {
"Date of Incident": "2017-05-16T00:00:00.000Z",
"Time of Incident": "8:10",
"Time Undetermined": "No",
"Day Of Week": "Tuesday",
"Job Shift": "Morning",
"Time Work Day Began": "6:00",
"Is this a serious Incident or has the Potential to be Serious?": "",
"Description of Incident": "Forklift struck two pedestrians",
"Incident Occurred on Employer's Premises": "Yes",
"Address of Incident Location": "6100 Heisley Road",
"City": "West Windsor",
"County": "USA",
"Country": "United States",
"State/Province": "NJ-New Jersey",
"Postal Code/Zip Code": "08550",
"Department": "Warehouse",
"Was Asset involved": "Yes",
"Asset(s)": [ "Asset1", "Asset2" ],
"Date Reported to Employer": "2017-05-16T00:00:00.000Z",
"Time Reported To Employer": "15:05",
"Confirm Significance Level of Incident": "Level 2"
},
"Employee / Individual Details": [
{
"Was an Employee / Individual involved in the Incident?": "Yes",
"Personnel Type": "Employee",
"First Name of Employee": "Mark",
"Middle Name of Employee": "Middle Name",
"Last Name of Employee": "Bickle",
"Employee Id": "201612309"
},
{
"Was an Employee / Individual involved in the Incident?": "Yes",
"Personnel Type": "Employee",
"First Name of Employee": "Gary",
"Middle Name of Employee": "Middle Name",
"Last Name of Employee": "Avalos",
"Employee Id": "21146427"
}
],
"Environmental Incident Details": {
"Environmental Incident Type": "Discharge",
"Cause of Incident": "Chemical Contact",
"Hazard Classification": "Classification",
"Severity": "Severity",
"ERCA Required?": "ERCA",
"Weather conditions": "Bad Weather conditions",
"Did incident involve shipping of hazardous material": "Yes",
"Carrier Name": "Carrier Name",
"Contact Info": "Contact Info",
"Vehicle ID#": "123456",
"Was the emergency Response Plan reviewed after the incident to see if changes are needed?": "Yes",
"Was there a release to the environment?": "No",
"Was there a spill of substance?": "No"
},
"Substance Details": [
{
"Name of Substance": "Crude Oil",
"Percentage of Mix": 10,
"Amount Spilled": "20 KG",
"Amount Recovered": "30 Litres",
"Amount Disposed off": "40 Ounces"
},
{
"Name of Substance": "Diesel",
"Percentage of Mix": 10,
"Amount Spilled": "20 BBLS",
"Amount Recovered": "30 Gallons",
"Amount Disposed off": "50 KG"
}
],
"Damage Summary": {
"Was there any hazardous material involved ?": "Yes",
"If Yes, identify the Material": [ "Material1", "Material2" ],
"Do you have MSDS?": "No",
"Was the facility evacuated?": "No",
"Was a Contractor Involved in the Incident?": "No",
"Please Provide Contractor Details (Name, Company, Phone, etc.)": "John, PMAP,12345678",
"Was The Contractor Trained On Company Policies?": "Yes",
"Describe Any Damage Caused": "Damage Caused in company",
"Describe What Caused the Incident To Occur": "Damage Caused",
"Describe Work Activity Being Performed During Incident": "Damage Caused",
"Was the Applicable Regulatory Agency Notified?": "Damage Caused"
},
"Agency Details": [
{
"Agency Notified": "Mississippi Oil & Gas Board",
"Date of Notification": "2021-03-09T00:00:00.000Z",
"Time of Notification": "11:45",
"Contact Name": "Test",
"Contact Number": "1234567"
},
{
"Agency Notified": "LEPC",
"Date of Notification": "2021-03-09T00:00:00.000Z",
"Time of Notification": "12:50",
"Contact Name": "3453453453453",
"Contact Number": "65456456"
}
],
"Witness Information": [
{
"Are there any Witnesses identified?": "Yes",
"Number of Witnesses": 2
},
{
"Last Name": "Test",
"First Name": "Test",
"Middle Name": "Test",
"Phone Number": "12345678",
"Notes": "Test",
"Witness Relation to ProcessMAP(Coworker, friend, public, supervisor, venue employee)": "TEst"
},
{
"Last Name": "Last Name",
"First Name": "Last Name",
"Middle Name": "Last Name",
"Phone Number": "12345678",
"Notes": "Last Name",
"Witness Relation to ProcessMAP(Coworker, friend, public, supervisor, venue employee)": "Last Name"
}
],
"Additional Incident Information": {
"Incident Status": "Investigation Report Incomplete",
"Created By": "Tina Duffy",
"Created Date": "2017-05-16T12:02:59.183Z",
"Last Updated By": "Tina Duffy",
"Last Updated Date": "06/14/17 11:00:06 AM"
}
},
"Investigation Report": {
"Investigation Responsibility Details": [
{
"Target Completion Date": "2021-05-24T09:49:25.88Z",
"Comments": "sample string 1",
"Notify / YN": "sample string 2"
},
{
"Target Completion Date": "2021-05-24T09:49:25.88Z",
"Comments": "sample string 1",
"Notify / YN": "sample string 2"
}
],
"Investigation Responsibility assignee Details": [
{
"Salutation": "sample string 2",
"First Name": "sample string 3",
"Last Name": "sample string 4"
},
{
"Salutation": "sample string 2",
"First Name": "sample string 3",
"Last Name": "sample string 4"
}
],
"Investigation Details": [
{
"Was an asset involved in the Injury of the Employee?": "Yes",
"Asset ID Number": "123456 reg 19.1"
},
{
"Did affected employee(non-injured) voilate work rule?": "Yes",
"Name of employee": "Bettua John "
},
{
"What is the Job Number? (If not applicable enter 'NA')": "Test"
},
{
"EHS Category: Was Crane, Rigging, Lifting Devices or Vehicles involved?": "Yes",
"Crane, Rigging Devices, Lifting Devices or Vehicles?": {
"Crane, Rigging Devices, Lifting Devices or Vehicles?": "Crane",
"Crane Unit Number": "123456",
"Crane Make": "Test",
"Age of Crane (In Years)": "1-20",
"Crane Year Model": "2020",
"Crane Type": "Truck",
"Crane Last Annual Certification Date": "04/05/2021",
"Crane Last Monthly Inspection": "04/05/2021",
"Crane Daily Inspection": "No",
"Rigging Types": "Test",
"Rigging Make": "Test",
"Rigging Serial no": "Test",
"Rigging Capacity": "Test",
"Rigging Size/Length": "Sample",
"Rigging Date of Certification": "Sample",
"Rigging Date of Last Inspection": "Sample",
"Rigging Correct Color Code Inspection Tag": "Sample",
"Lifting Devices Types": "Sample",
"Lifting Devices Make": "Sample",
"Lifting Devices Serial No.": "Sample",
"Lifting Devices Unit No.": "Sample",
"Lifting Devices Capacity": "Sample",
"Lifting Devices Size/Length": "Sample",
"Spreader Bar Type": "Sample",
"Personnel Basket": "Sample",
"Lifting Devices Date of Certification": "Sample",
"Lifting Devices Date of Last Inspection": "Sample",
"Vehicle Types": "Sample",
"Vehicle Make": "Sample",
"Vehicle Model": "Sample",
"Vehicle Year": "Sample",
"Vehicle Unit No": "Sample",
"Vehicle Pre-Trip Inspection Completed?": "Sample",
"Vehicle Date of Last Inspection": "Sample"
}
},
{
"Did a contractor contribute to the incident?": "Yes",
"Was the contractor trained on site policies before starting work?": "Yes"
},
{
"Was the incident preventable?": "No",
"Describe how incident could have been prevented:": "Yes"
},
{
"Post-Incident Drugs & Alcohol Test?": "Yes",
"Test Type?": "DOT",
"Date of Testing": "04/05/2021",
"Why wasn't testing performed?": "Need to test"
},
{
"Employee(s) involved attended IIF Orientation?": "Yes"
},
{
"Employee(s) involved attended IIF Supervisor Skills Training?": "Yes"
},
{
"Employee(s) involved attended other IIF functions?": "No",
"If yes above, please describe:": "Sample Text"
},
{
"Did affected employee(non-injured) voilate work rule?": "No",
"Name of employee": "Sam Atom"
}
],
"Contributing Factors": [
{
"Contributing Factor Type (Parent)": "Material",
"Contributing Factors": [
"Hazardous substances"
],
"Comments": "Material"
}
],
"5 Why? Methodology": [
{
"Select Action or Condition that may have directly caused incident": [
"Sun in Eyes"
],
"Whys": [
{
"Why or what created the scenario above to affect the action or condition": "Why 1"
},
{
"Why or what created the scenario above to affect the action or condition": "Why 2"
},
{
"Why or what created the scenario above to affect the action or condition": "Why 3"
},
{
"Final Root Cause Checked": "No"
}
]
}
],
"Root Cause Statement": [
{
"Root cause Type (Parent)": "Behavioral Factor's",
"Root Cause": [
"Anger/frustration"
],
"Comments": ""
},
{
"Root cause Type (Parent)": "High Potential & Exposures",
"Root Cause": [
"Falls from Height & into Water"
],
"Comments": ""
},
{
"Root cause Type (Parent)": "Unsafe Act-Competence/Knowledge",
"Root Cause": [
"B - Little or No Experience in Specific Job"
],
"Comments": ""
}
],
"Release Impact Details": [
{
"Impacts": "sample string 3",
"Comments": "sample string 4",
"Environmental Media": "sample string 5"
},
{
"Impacts": "sample string 3",
"Comments": "sample string 4",
"Environmental Media": "sample string 5"
}
],
"Final root cause statement Details": [
{
"FinalRootCauseStatement": "sample string 2",
"PrimaryCounterMeasure": "sample string 3",
"PrimaryRootCause": "sample string 4"
},
{
"FinalRootCauseStatement": "sample string 2",
"PrimaryCounterMeasure": "sample string 3",
"PrimaryRootCause": "sample string 4"
}
]
},
"Action Items": [
{
"Source ID": "CA-WESTLAKE-20_21-I-0276",
"Source Title": "Env Test",
"Action Item Title": "Action Item One",
"Action Item Category": "Incident Management",
"Action Item Type": "Preventative Action",
"Root Cause": [
"B - Little or No Experience in Specific Job",
"Falls from Height & into Water"
],
"Action Item Description": "Desc",
"Action Item Priority": "Reg 1921",
"Action Item Due Date": "2021-05-05T00:00:00.000Z",
"Owners": [
"Mahendra Nath",
"Ravi Ranjan",
"Satish Korupol"
],
"Responsible Department": "Contact Centers",
"Applicable to Expansion": "No",
"Description of Actions to be Expanded": "Sample",
"Applicable to EEM/EPM Info": "No",
"EEM / EPM": "Sample",
"EEM/EPM Info Submitted": "Sample",
"Document Number": "Sample",
"Assigned By": "Jo'hn Smith1",
"Verification Required": "No",
"Approval Status": "Open",
"Approvers": [ "Sample", "Sample", "Sample" ],
"Approval Comment": "",
"Approval Date": "2021-05-05T00:00:00.000Z",
"Action Item Status": "Open",
"Action Taken": "Sample",
"Action Item Completed By": "Sample",
"Completed Date": "2021-05-05T00:00:00.000Z",
"Due Date Extension": "",
"Requested Due Date Extension": "2021-05-05T00:00:00.000Z",
"Reason for Due Date Extension": "Sample",
"Due Date Extension Request Approved?": "Sample",
"Reason for not extending the Due Date": "Sample"
},
{
"Source ID": "CA-WESTLAKE-20_21-I-0276",
"Source Title": "Env Test",
"Action Item Title": "ytruw",
"Action Item Category": "Incident Management",
"Action Item Type": "Corrective Action",
"Root Cause": [],
"Action Item Description": "",
"Action Item Priority": "Reg 1921",
"Action Item Due Date": "2021-05-18T00:00:00.000Z",
"Owners": [
"Satish Korupol"
],
"Responsible Department": "Test C",
"Assigned By": "Jo'hn Smith1",
"Verification Required": "No",
"Action Item Status": "Open",
"Action Taken": "Sample",
"Action Item Completed By": "Sample",
"Completed Date": "2021-05-18T00:00:00.000Z",
"Due Date Extension": "",
"Requested Due Date Extension": "2021-05-18T00:00:00.000Z",
"Reason for Due Date Extension": "",
"Due Date Extension Request Approved?": "Sample",
"Reason for not extending the Due Date": "Sample"
}
],
"Management Review": [
{
"Role": "Level-1",
"Owner": [
" Jo'hn Smith1 "
],
"Approval Due Date": "05/25/21 4:20:38 PM",
"Comments": "Comments",
"Completed By": "John Mark",
"Completed Date": "2021-05-05T00:00:00.000Z"
},
{
"Management Review Status": "Open"
}
]
}
]
Environmental Incident Details Fields List
| Section | Field Name | Database Column Size |
|---|---|---|
| Incident Detail | ||
| Incident ID * | NVARCHAR(400) | |
| Internal Incident ID | NVARCHAR(200) | |
| Incident Title/Site* | NVARCHAR(400) | |
| Incident Type * | INT | |
| Were multiple people injured as part of this incident? | NVARCHAR(50) | |
| General Details | ||
| Date of Incident * | DATETIME | |
| Time of Incident * | NVARCHAR(100) | |
| Time undetermined | NVARCHAR(10) | |
| Day Of Week ** | NVARCHAR(100) | |
| Work Shift ** | NVARCHAR(1000) | |
| Time Work Day Began ** | NVARCHAR(200) | |
| Is this a serious Incident or has the Potential to be Serious? | NVARCHAR(200) | |
| Description of Incident * | NVARCHAR(8000) | |
| Incident Occurred on Employer's Premises * | NVARCHAR(100) | |
| Address of Incident Location * | NVARCHAR(1000) | |
| City * | NVARCHAR(100) | |
| County | NVARCHAR(100) | |
| Country * | NVARCHAR(100) | |
| State/Province * | NVARCHAR(100) | |
| Postal Code/Zip Code | NVARCHAR(100) | |
| Department * | NVARCHAR(1000) | |
| Department where the incident/injury occurred | NVARCHAR(1000) | |
| Was Asset involved | NVARCHAR(100) | |
| Asset(s) | NVARCHAR(1000) | |
| Date and Time Reported to Employer | DATETIME | |
| Time | NVARCHAR(200) | |
| Confirm Significance level of incident | NVARCHAR(1000) | |
| Employee / Individual Details | ||
| Was an Employee / Individual involved in the Incident? | NVARCHAR(100) | |
| Personnel Type * | NVARCHAR(100) | |
| Employee / Individual Involved ( Last, First, M.I.) * | NVARCHAR(200), NVARCHAR(200), NVARCHAR(200) | |
| Employee Id * | NVARCHAR(200) | |
| Do you want to further classify Unsupervised Contract Employee | NVARCHAR(50) | |
| Type of Client Personnel | NVARCHAR(20) | |
| Client Company | NVARCHAR(100) | |
| Name of Contractor | NVARCHAR(800) | |
| Name of Sub-Contractor | NVARCHAR(800) | |
| Was any Machine / Equipment involved? | NVARCHAR(100) | |
| Machine/Equipment Number | NVARCHAR(400) | |
| Reviewed by EHS Representative | NVARCHAR(800) | |
| Review Date | DateTime | |
| Substance Details | ||
| Name of Substance | NVARCHAR(1000) | |
| Percentage of Mix | INT | |
| Amount Spilled | NVARCHAR(200) | |
| Amount Spilled Units | INT | |
| Amount Recovered Qty | NVARCHAR(200) | |
| Amount Recovered Units | INT | |
| Amount Disposed Qty | NVARCHAR(200) | |
| Amount Disposed Units | INT | |
| Agency Details | ||
| Agency Notified | NVARCHAR(1000) | |
| Date of Notification | DATETIME | |
| Time of Notification | NVARCHAR(50) | |
| Contact Name | NVARCHAR(100) | |
| Contact Number | NVARCHAR(100) | |
| Environmental Incident Details | ||
| Environmental Incident Type | NVARCHAR(50) | |
| Cause of Incident | NVARCHAR (50) | |
| Hazard Classification | NVARCHAR (400) | |
| Severity | NVARCHAR(50) | |
| ERCA Required? | NVARCHAR(50) | |
| Weather conditions | NVARCHAR(500) | |
| Note quantity/units spilled/leaked/emitted | NVARCHAR(100) | |
| Did incident involve shipping of hazardous material | NVARCHAR(50) | |
| Carrier Name | NVARCHAR(50) | |
| Contact Info | NVARCHAR(50) | |
| Vehicle ID# | NVARCHAR(50) | |
| Was the emergency Response Plan reviewed after the incident to see if changes are needed? | NVARCHAR(50) | |
| Was there a release to the environment? | NVARCHAR(50) | |
| Was there a spill of substance? | NVARCHAR(50) | |
| Damage Summary | ||
| Was there any hazardous material involved ? | NVARCHAR(50) | |
| If Yes, identify the Material | NNVARCHAR(MAX) | |
| Do you have MSDS? | NVARCHAR(500) | |
| Was the facility evacuated? | NVARCHAR(500) | |
| Was a Contractor Involved in the Incident? | NVARCHAR(50) | |
| Please Provide Contractor Details (Name, Company, Phone, etc.) | NVARCHAR(50) | |
| Was The Contractor Trained On Company Policies? | NVARCHAR(500) | |
| Describe Any Damage Caused | NVARCHAR(50) | |
| Describe What Caused the Incident To Occur | NVARCHAR(50) | |
| Describe Work Activity Being Performed During Incident | NVARCHAR(50) | |
| Was the Applicable Regulatory Agency Notified? | NVARCHAR(50) | |
| Witness Information | ||
| Are there any Witnesses identified? | NVARCHAR(20) | |
| Number of Witnesses | INT | |
| Last Name | NVARCHAR(50) | |
| First Name | NVARCHAR(50) | |
| Middle Name | NVARCHAR(50) | |
| Phone Number | NVARCHAR(100) | |
| Notes | NVARCHAR(2000) | |
| Witness relation to <CUSTOMER> Coworker, friend, public, supervisor, venue employee | NVARCHAR(500) | |
| Additional Incident Information | ||
| Incident Status | NVARCHAR(100) | |
| Created By | NVARCHAR(100) | |
| Created Date | DATETIME | |
| Last Updated By | NVARCHAR(100) | |
| Last Updated Date | DATETIME | |
Investigation Sections Field List (Common to All Incident Types)
| Section | Field Name | Database Column Size |
|---|---|---|
| Investigation Responsibility | ||
| Responsible Team * | NVARCHAR(1000) | |
| Target Completion Date * | DATE | |
| Note/Comments | NVARCHAR(2000) | |
| Investigation Questions | ||
| All Questions | NVARCHAR(2000) | |
| All Answers | NVARCHAR(500) | |
| All Dependencies | INT / INT | |
| Questions Configuration based on Business Types & Operation Types (Near Miss & Injury / Illness) | INT / INT / INT | |
| Ergonomic Analysis (Applicable only when respective question in Investigation Details is answered as Yes) | ||
| All Questions | VARCHAR(2000) | |
| All Answers | NVARCHAR(500) | |
| All Picklist Answer | NVARCHAR(500) | |
| All Dependencies | INT / INT | |
| Incident Specific Questions and its answers | INT / INT / INT | |
| Contributing Factors | ||
| Contributing Factors | INT / INT | |
| 5 Why ? Methodology | ||
| Root Cause Evaluation | INT / INT | |
| Contributing Factors | INT / NVARCHAR(50) | |
| Whys | NVARCHAR(2000) | |
| Check this box (If the above is FINAL ROOT CAUSE) | NVARCHAR(2000) | |
| Root Cause Analysis | ||
| Root Cause analysis | INT / INT | |
| Comments | NVARCHAR(2000) | |
| Final Root Cause Statement | ||
| Final Root cause statement | Nvarchar(4000) | |
| Primary Countermeasure | INT / INT | |
| Primary Root Cause | INT | |
| Release / Impacts | ||
| Environmental Media | INT | |
| Impacts | Nvarchar(500) | |
| Comments/Notes | Nvarchar(500) | |
| Critique of response / Follow up | ||
| All Questions | NVARCHAR(2000) | |
| All Answers | NVARCHAR(500) | |
| All Dependencies | INT / INT | |
Action Item Field List (Common to All Incident Types)
| Section | Field Name | Database Column Size |
|---|---|---|
| Source Details | ||
| Source ID | NVARCHAR(400) | |
| Source Title | NVARCHAR(400) | |
| Management Review Role | VARCHAR(50) | |
| TMS Enabled Department | NVARCHAR(50) | |
| TMS Work Order Number | NVARCHAR(100) | |
| Create | ||
| Action Item Title | NVARCHAR (2000) | |
| Action Item Category | NVARCHAR(2000) | |
| Action Item Type | NVARCHAR (2000) | |
| Root Cause | NVARCHAR(MAX) | |
| Action Item Description | NVARCHAR(2000) | |
| Action Item Priority | NVARCHAR(1000) | |
| Action Item Due Date | DATETIME | |
| Owner | NVARCHAR(1000) | |
| Responsible Department | NVARCHAR(1000) | |
| Countermeasure | NVARCHAR(1000) | |
| Applicable to Expansion? | NVARCHAR(10) | |
| Description of Actions to be Expanded * | NVARCHAR(1000) | |
| Applicable to EEM/EPM Info? | NVARCHAR(10) | |
| EEM / EPM * | NVARCHAR(10) | |
| EEM/EPM Info Submitted? | NVARCHAR(10) | |
| Document Number * | NVARCHAR(200) | |
| Assigned By | VARCHAR(50) | |
| Verification required | NVARCHAR(50) | |
| Verify User | NVARCHAR(MAX) | |
| Approval | ||
| Approval Status | INT, NVARCHAR(100) | |
| Approvers | NVARCHAR(MAX) | |
| Approval Comment | NVARCHAR(2000) | |
| Approval Date | DATETIME | |
| Complete | ||
| Action Item Status | NVARCHAR(200) | |
| Action Taken | NVARCHAR(2000) | |
| Action item Completed By | VARCHAR(50) | |
| Action item Completed Date | DATETIME | |
| Due Date Extension | NVARCHAR(100) | |
| Requested Due Date Extension | DATETIME | |
| Reason for Due Date Extension | NVARCHAR(2000) | |
| Due Date Extension Request Approved? | NVARCHAR(2000) | |
| Reason for not extending the Due Date. | NVARCHAR(2000) | |
| Review/Verify | ||
| Verification Status | INT | |
| Verification Performed | VARCHAR(50) | |
| Verified By | INT | |
| Verification Date | DATETIME | |
| Comments | NVARCHAR(2000) | |
| Cost Information | ||
| Capital Expenditure involved | ||
| Approximate cost | ||
| Estimated Budget | ||
Management Review (Common to All Incident Types)
| Section | Field Name | Database Column Size |
|---|---|---|
| Role | NVARCHAR(100) | |
| Owner | NVARCHAR(2000) | |
| Approval Due Date | DATETIME | |
| Comments | NVARCHAR(1000) | |
| Completed By | NVARCHAR(100) | |
| Management Review Status | VARCHAR(50) |
Vehicle :
Incident Details
Request
GET papi/v1/imsoutbound/vehicleincidents?locationCode={locationCode}&dateFrom={dateFrom}&dateTo={dateTo}&lastSyncedDate={lastSyncedDate}
Ex: papi/v1/imsoutbound/vehicleincidents?locationCode=westlake&dateFrom=2019-07-01&dateTo=2019-07-30&lastSyncedDate=2019-01-01
URI Parameters
Location Code, DateFrom, DateTo and LastSyncedDate are to be passed as parameters.
DateFrom and DateTo are required when LastSyncedDate is not provided.
When DateFrom, DateTo and LastSyncedDate are provided, data will be returned based on LastSyncedDate only.
| Name | Description | Type | Additional information |
|---|---|---|---|
| locationCode | Represents the unique code of location for which Incident records to return. | string | Required |
| dateFrom | Represents the starting date of Incident records to return. | date | Required but value optional |
| dateTo | Represents the ending date of Incident records to return. | date | Required but value optional |
| lastSyncedDate | Represents the data from incident created date or incident modified date. | date | Required but value optional |
Headers
| Name | Description | Sample |
|---|---|---|
| Authorization | Represents the value of the authentication token. Allow multiple values: no. | Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ... |
| ConsumerId | Represents the value of the consumer id. Allow multiple values: no. | 2222 |
Sample response:
[
{
"Detail Report": {
"Incident Details": {
"Incident ID (System Generated)": "sample",
"Incident Internal ID": "sample",
"Incident Title/Site": "sample",
"Incident Type": " sample"
},
"General Details": {
"Date of Incident": "2021-05-01T00:00:00.000Z",
"Time of Incident": "sample",
"Time Undetermined": "sample",
"Day Of Week": "sample",
"Job Shift": "sample",
"Time Work Day Began": "sample",
"Description of Incident": "sample",
"Incident Occurred on Employer's Premises": "sample",
"Address of Incident Location": "sample",
"City": "sample",
"County": "sample",
"Country": "sample",
"State/Province": "sample",
"Postal Code/Zip Code": "sample",
"Operating Unit": "sample",
"Confirm Significance Level of Incident": "sample"
},
"Employee / Individual Details": {
"Would you like to submit a Vehicle claim?": "sample",
"Personnel Type": "sample",
"First Name of Employee": "sample",
"Middle Name of Employee": "sample",
"Last Name of Employee": "sample",
"Employee Id": "sample",
"Occupation/Job Title": "sample"
},
"Vehicle Incident Summary": {
"Please identify the weight of the vehicle?": "sample",
"Company Vehicle Type (please provide description of Vehicle)": "sample",
"Please identify the condition of the employee?": "sample",
"Length of Service (L.O.S.) as Company Driver": "sample",
"Is company driver a Commercial Driver's License holder?": "sample",
"State of License": "sample",
"Date of Expiration": "2020-03-20T00:00:00.000Z"
},
"Vehicle Details": [
{
"Vehicle Number": "sample",
"Year of Vehicle": "sample",
"Make of Vehicle": "sample",
"Model of Vehicle": "sample",
"VIN Number": "sample",
"License Tag Number": "sample",
"State of License Plate Tag": "sample",
"Trailer (if Applicable)": "sample",
"Model of Trailer": "sample",
"Damage to Company Vehicle?": "sample",
"Was vehicle towed as a result of the incident?": "sample",
"Please explain who towed the vehicle?": "sample",
"Address / Location of Incident / Cross Section": "sample",
"City": "sample",
"State": "sample",
"Did incident occur within a construction zone?": "sample",
"Please select scenario that best represents traffic / road condition?": "sample",
"Scenario That Best Represents The Weather Conditions At The Time Of The Incident": " sample"
}
],
"Insurance Information (Vehicle 1 is always Company Vehicle)": [
{
"Please identify number of vehicles / parties involved in accident": 1
},
{
"Name of Individual": "sample",
"Insurance Company": "sample",
"Insurance Company Policy Number": "sample",
"Address": "sample",
"Phone Number": "sample",
"Names of all passengers involved in vehicle": "sample",
"Additional Comments / Notes": "sample"
}
],
"Witness Information": [
{
"Are there any Witnesses identified?": "sample",
"Number of Witnesses": 1
},
{
"Last Name": "sample",
"First Name": "sample",
"Middle Name": "sample",
"Phone Number": "sample",
"Notes": "sample",
"Witness Relation to ProcessMAP(Coworker, friend, public, supervisor, venue employee)": "sample"
}
],
"Additional Incident Information": {
"Incident Status": "sample",
"Created By": "sample",
"Created Date": "2021-05-19T16:29:47.797Z",
"Last Updated By": "sample",
"Last Updated Date": "2021-05-25T16:33:19.747Z"
}
},
"Reportability & Chargeability": {
"Did the incident result in a fatality for company driver / passenger?": "sample",
"Were there any non-employees (other parties) injured as a result of the incident?": "sample",
"Did the incident result in a fatality for any parties involved (non-employees)?": "sample",
"Were any of the parties involved treated away from the scene (i.e., transported by ambulance from scene)?": "sample",
"Were there any Hazardous Materials spilled": "sample",
"Does this incident need to be reported to the Department of Transportation (DOT)?": "sample",
"Please identify DOT Reportable Type": "sample",
"Please provide any comments necessary for verifying DOT Reportable Classification": "sample",
"Last Federal Annual Inspection Date": "05/25/21 12:00:00 AM",
"Last Driver Vehicle Inspection Report Date": "2021-05-25T00:00:00.000Z",
"Please identify if a chargeable accident for Company Vehicle": "sample",
"Please select the expected payout / cost associated with the Vehicle Accident?": "sample",
"Please provide the total payout cost": 34,
"Comments": "Comments"
},
"Summary of Injured Parties": {
"Summary of Injured Parties": [
{
"Injured Party Type": "sample",
"Name Of Involved Person": "sample",
"Age": sample,
"Residential Address": "sample",
"City": "sample",
"State": "sample",
"Postal Code/Zip Code": "sample",
"Phone Number": "sample",
"Injuries Resulted in a Fatality": "sample",
"Date of Fatality": sample,
"Was individual hospitalized as a result of injuries?": "sample",
"Hospital Name": "sample",
"Hospital Address": "sample",
"Hospital City": "sample",
"Hospital State": "sample",
"Hospital Zip": "sample",
"Hospital Phone": "sample",
"Hospital Fax": "sample",
"Doctor Name": "sample"
},
{
"Injured Party Type": "sample",
"Name Of Involved Person": "sample",
"Age": sample,
"Residential Address": "sample",
"City": "sample",
"State": "sample",
"Postal Code/Zip Code": "sample",
"Phone Number": "sample",
"Injuries Resulted in a Fatality": "sample",
"Date of Fatality": "2021-05-25T00:00:00.000Z",
"Was individual hospitalized as a result of injuries?": "sample",
"Hospital Name": "sample",
"Hospital Address": "sample",
"Hospital City": "sample",
"Hospital State": "sample",
"Hospital Zip": "sample",
"Hospital Phone": "sample",
"Hospital Fax": "sample",
"Doctor Name": "sample"
}
],
"Total Number of Injured": 1,
"Total Number of Deaths": 1
},
"Investigation Report": {
"Investigation Responsibility": {},
"Investigation Details": [
{
"Was an asset involved in the Injury of the Employee?": "sample",
"Asset ID Number": "sample"
},
{
"Did affected employee(non-injured) voilate work rule?": "sample",
"Name of employee": "sample"
},
{
"What is the Job Number? (If not applicable enter 'NA')": "sample"
},
{
"EHS Category: Was Crane, Rigging, Lifting Devices or Vehicles involved?": "sample",
"Crane, Rigging Devices, Lifting Devices or Vehicles?": {
"Crane, Rigging Devices, Lifting Devices or Vehicles?": "sample",
"Crane Unit Number": "sample",
"Crane Make": "sample",
"Age of Crane (In Years)": "sample",
"Crane Year Model": "sample",
"Crane Type": "sample",
"Crane Last Annual Certification Date": "05/25/2021",
"Crane Last Monthly Inspection": "05/25/2021",
"Crane Daily Inspection": "sample",
"Rigging Types": "sample",
"Rigging Make": "sample",
"Rigging Serial no": "sample",
"Rigging Capacity": "sample",
"Rigging Size/Length": "sample",
"Rigging Date of Certification": "sample",
"Rigging Date of Last Inspection": "sample",
"Rigging Correct Color Code Inspection Tag": "sample",
"Lifting Devices Types": "sample",
"Lifting Devices Make": "sample",
"Lifting Devices Serial No.": "sample",
"Lifting Devices Unit No.": "sample",
"Lifting Devices Capacity": "sample",
"Lifting Devices Size/Length": "sample",
"Spreader Bar Type": "sample",
"Personnel Basket": "sample",
"Lifting Devices Date of Certification": "sample",
"Lifting Devices Date of Last Inspection": "sample",
"Vehicle Types": "sample",
"Vehicle Make": "sample",
"Vehicle Model": "sample",
"Vehicle Year": "sample",
"Vehicle Unit No": "sample",
"Vehicle Pre-Trip Inspection Completed?": "sample",
"Vehicle Date of Last Inspection": "sample"
}
},
{
"CSA points assessed against the driver for this accident?": "sample",
"How many points assessed?": "sample",
"Including this incident, total CSA points on driver's record:": "sample"
},
{
"Has driver had any prior incidents in the past 5 years?": "sample",
"Explain prior incident(s)": "sample"
},
{
"Has driver received Smith Driver Training?": "sample"
},
{
"List any additional Defensive Driver Training (If not applicable, enter 'NA'):": "sample"
},
{
"Total years of CDL driving experience?": "sample"
},
{
"Years of consecutive CDL driving experience at time of incident?": "sample"
},
{
"Years of consecutive CDL driving experience for the company\"sample": "sample"
},
{
"Were seat belts used?": "sample"
},
{
"Post Accident Alcohol / Drug Test conducted?": "sample",
"What type of drug screening test?": "sample",
"What is the date of the Post Accident Drug/Alcohol Screening?": "05/25/2021",
"Explain why post accident drug & alcohol testing was not conducted:": "sample"
},
{
"Did the incident occur on a public road?": "sample"
},
{
"What was the estimated speed at the time of the incident?": "sample"
},
{
"Property damage to non-company vehicles and/or surrounding property?": "sample",
"Please describe damage:": "sample"
},
{
"Were any other vehicles (non-company) involved in the incident towed as a result of the incident?": "sample",
"Please explain who towed the vehicle?": "sample"
},
{
"Was the incident preventable?": "sample",
"Preventable Incident Classification": "sample",
"Non-Preventable Incident Classification": "sample"
},
{
"Please explain who was at fault?": "sample"
},
{
"Was a Citation issued?": "sample",
"Please explain who was issued a Citation?": "sample"
},
{
"Was any equipment involved in the Incident?": "sample",
"Please identify the type of equipment involved.": "sample"
},
{
"Employee(s) involved attended IIF Orientation?": "sample"
},
{
"Employee(s) involved attended IIF Supervisor Skills Training?": "sample"
},
{
"Employee(s) involved attended other IIF functions?": "sample",
"If yes above, please describe:": "sample"
}
],
"Contributing Factors": [
{
"Contributing Factor Type (Parent)": "sample",
"Contributing Factors": [
"sample 1",
"sample 2"
],
"Comments": "sample"
}
],
"5 Why? Methodology": [
{
"Select Action or Condition that may have directly caused incident": ["sample"],
"Whys": [
{
"Why or what created the scenario above to affect the action or condition": "sample1"
},
{
"Why or what created the scenario above to affect the action or condition": "sample2"
},
{
"Why or what created the scenario above to affect the action or condition": "sample3"
},
{
"Why or what created the scenario above to affect the action or condition": "sample4"
},
{
"Why or what created the scenario above to affect the action or condition": "sample5"
},
{
"Final Root Cause Checked": "No"
}
]
},
{
"Select Action or Condition that may have directly caused incident": ["sample"],
"Whys": [
{
"Why or what created the scenario above to affect the action or condition": "sample 1"
},
{
"Why or what created the scenario above to affect the action or condition": "sample 2"
},
{
"Why or what created the scenario above to affect the action or condition": "sample 3"
},
{
"Why or what created the scenario above to affect the action or condition": "sample 3"
},
{
"Why or what created the scenario above to affect the action or condition": "sample 4"
},
{
"Final Root Cause Checked": "No"
}
]
}
],
"Root Cause Statement": [
{
"Root cause Type (Parent)": "sample",
"Root Cause": [
"sample 1",
"sample 2"
],
"Comments": "sample"
},
{
"Root cause Type (Parent)": "sample",
"Root Cause": [
"sample"
],
"Comments": "sample"
}
],
"Final Root Cause Statement": [
{
"Final Root Cause Statement": "sample",
"Primary Countermeasure": "sample",
"Primary Root Cause Category": "sample"
}
]
},
"Action Items": [
{
"Source ID": "sample",
"Source Title": "sample",
"Action Item Title": "sample",
"Action Item Category": "Sample",
"Action Item Type": "sample",
"Root Cause": [
"sample"
],
"Action Item Description": "sample",
"Action Item Priority": "sample",
"Action Item Due Date": "2021-01-13T00:00:00.000Z",
"Owners": [
"sample",
"sample"
],
"Responsible Department": "sample",
"Assigned By": "sample",
"Verification Required": "sample",
"Action Item Status": "sample",
"Action Taken": "sample",
"Action Item Completed By": "sample",
"Completed Date": "2020-12-14T00:00:00.000Z",
"Due Date Extension": "sample",
"Requested Due Date Extension": null,
"Reason for Due Date Extension": "sample",
"Due Date Extension Request Approved?": "sample",
"Reason for not extending the Due Date": "sample"
}
],
"Management Review": [
{
"Role": "sample 1",
"Owner": [],
"Approval Due Date": "05/25/21 5:00:22 PM",
"Comments": "sample",
"Completed By": "sample",
"Completed Date": "sample"
},
{
"Role": "sample 2",
"Owner": [
" sample 1 ",
" sample 2 ",
" sample 3 ",
" sample 4 ",
" sample 5 "
],
"Approval Due Date": "05/26/21 5:00:22 PM",
"Comments": "sample",
"Completed By": "sample",
"Completed Date": "sample"
},
{
"Role": "sample 3",
"Owner": [
" sample 1 ",
" sample 2 "
],
"Approval Due Date": "05/26/21 5:00:22 PM",
"Comments": "sample",
"Completed By": "sample",
"Completed Date": "sample"
},
{
"Role": "sample 4",
"Owner": [
" sample "
],
"Approval Due Date": "05/30/21 5:00:22 PM",
"Comments": "sample",
"Completed By": "sample",
"Completed Date": "sample"
},
{
"Role": "Sample 5",
"Owner": [
" sample "
],
"Approval Due Date": "05/30/21 5:00:22 PM",
"Comments": "sample",
"Completed By": "sample",
"Completed Date": "sample"
},
{
"Management Review Status": "sample"
}
]
}
]
Vehicle Incident field list:
| Section | Fields Name | Database Column Size |
|---|---|---|
| Incident Detail | ||
| Incident ID | nvarchar(400) | |
| Internal Incident ID | nvarchar(200) | |
| Incident Title/Site | nvarchar(400) | |
| Incident Type | Int,nvarchar(50) | |
| General Details | ||
| Date of Incident | DATETIME | |
| Time of Incident | NVARCHAR(100) | |
| Time undetermined | NVARCHAR(10) | |
| Day Of Week | NVARCHAR(100) | |
| Work Shift | NVARCHAR(200) | |
| Time Work Day Began | NVARCHAR(200) | |
| Description of Incident | NVARCHAR(8000) | |
| Incident Occurred on Employer's Premises | NVARCHAR(6) | |
| Address of Incident Location | NVARCHAR(1000) | |
| City | NVARCHAR(100) | |
| County | NVARCHAR(100) | |
| Country | NVARCHAR(100) | |
| State/Province | NVARCHAR(100) | |
| Postal Code/Zip Code | NVARCHAR(100) | |
| Department | NVARCHAR(100) | |
| Date and Time Reported to Employer | DATETIME,NVARCHAR(200) | |
| Confirm Significance level of incident | NVARCHAR(50) | |
| Employee / Individual Details | ||
| Would you like to submit a Vehicle claim? | NVARCHAR(100) | |
| Personnel Type | NVARCHAR(50) | |
| Employee / Individual Involved ( Last, First, M.I.) * | NVARCHAR(200), NVARCHAR(200), NVARCHAR(200) | |
| Employee Id | NVARCHAR(200) | |
| Occupation/Job Title | NVARCHAR(200) | |
| Do you want to further classify Unsupervised Contract Employee | NVARCHAR(50) | |
| Type of Client Personnel | nvarchar(20) | |
| Client Company | nvarchar(100) | |
| Name of Contractor | NVARCHAR(800) | |
| Name of Sub-Contractor | NVARCHAR(800) | |
| Vehicle Incident Summary | ||
| Please identify the weight of the vehicle? | NVARCHAR(200) | |
| Company Vehicle Type (please provide description of Vehicle) | NVARCHAR(500) | |
| Please identify the condition of the employee? | NVARCHAR(100) | |
| Length of Service (L.O.S.) as Company Driver | NVARCHAR(50) / NVARCHAR(50) | |
| Is company driver a Commercial Driver's License holder? | NVARCHAR(50) | |
| Please select Type of Commercial Drivers License | NVARCHAR(100) | |
| Driver’s License Number | NVARCHAR(50) | |
| State of License | VARCHAR(50) | |
| Date of Expiration | DATETIME | |
| Vehicle Ownership | NVARCHAR(100) | |
| Vehicle Incident Type/Cause | NVARCHAR(100) | |
| Vehicle Details | ||
| Vehicle Number | NVARCHAR(50) | |
| Year of Vehicle | INT | |
| Make of Vehicle | NVARCHAR(50) | |
| Model of Vehicle | NVARCHAR(50) | |
| VIN Number | NVARCHAR(50) | |
| License Tag Number | NVARCHAR(50) | |
| State of License Plate Tag | VARCHAR(50) | |
| Trailer (if Applicable) | NVARCHAR(50) | |
| Model of Trailer | NVARCHAR(50) | |
| Damage to Company Vehicle? | NVARCHAR(50) | |
| Please describe damage to vehicle | NVARCHAR(500) | |
| Was vehicle towed as a result of the incident? | NVARCHAR(50) | |
| Please explain who towed the vehicle? | NVARCHAR(500) | |
| Address / Location of Incident / Cross Section | NVARCHAR(500) | |
| City | NVARCHAR(50) | |
| State | NVARCHAR(50) | |
| Did incident occur within a construction zone? | NVARCHAR(50) | |
| Please select scenario that best represents traffic / road condition? | NVARCHAR(100) | |
| Please select scenario that best represents the weather conditions at the time of the incident? | NVARCHAR(100) | |
| Insurance Information | ||
| Please identify number of vehicles / parties involved in accident. | ||
| Name of Individual | NVARCHAR(100) | |
| Insurance Company | NVARCHAR(50) | |
| Insurance Company Policy Number | NVARCHAR(50) | |
| Address | NVARCHAR(500) | |
| Phone Number | NVARCHAR(50) | |
| Names of all Passengers involved in vehicle | NVARCHAR(500) | |
| Additional Comments / Notes | NVARCHAR(500) | |
| Witness Information | ||
| Are there any Witnesses identified? | NVARCHAR(20) | |
| Number of Witnesses | ||
| Last Name | NVARCHAR(50) | |
| First Name | NVARCHAR(50) | |
| Middle Name | NVARCHAR(50) | |
| Notes | NVARCHAR(2000) | |
| Witness realtion to <CUSTOMER> Coworker, friend, public, supervisor, venue employee | NVARCHAR(500) | |
| Additional Incident Information | ||
| Incident Status | NVARCHAR(100) | |
| Created By | NVARCHAR(100) | |
| Created Date | DATETIME | |
| Last Updated By | NVARCHAR(100) | |
| Last Updated Date | DATETIME | |
Investigation Section Field List (Common to all incident types):
| Section | Field Name | Database Column Size |
|---|---|---|
| Investigation Responsibility | ||
| Responsible Team | ||
| Target Completion Date | Date | |
| Note/Comments | NVARCHAR(2000) | |
| Investigation Questions | ||
| All Questions | NVARCHAR(2000) | |
| All Answers | NVARCHAR(500) | |
| All Dependencies | INT / INT | |
| Questions Configuration based on Business Types & Operation Types (Near Miss & Injury / Illness) | INT / INT / INT | |
| Ergonomic Analysis(Applicable only when respective question in Investigation Details is answered as Yes) | ||
| All Questions | VARCHAR(2000) | |
| All Answers | NVARCHAR(500) | |
| All Picklist Answer | NVARCHAR(500) | |
| All Dependencies | INT / INT | |
| Incident Specific Questions and its answers | INT/ INT / INT | |
| Contributing Factors | ||
| Contributing Factors | INT / INT | |
| 5 Why ? Methodology | ||
| Root Cause Evaluation | INT / INT | |
| Contributing Factors | INT / NVARCHAR(50) | |
| Whys | NVARCHAR(2000) | |
| Check this box (If the above is FINAL ROOT CAUSE) | NVARCHAR(2000) | |
| Root Cause Analysis | ||
| Root Cause analysis | INT / INT | |
| Comments | ||
| Final Root Cause Statement | ||
| Final Root cause statement | Nvarchar(4000) | |
| Primary Countermeasure | INT / INT | |
| Primary Root Cause | ||
Reportability & Chargeability:
| Section | Field Name | Database Column Size |
|---|---|---|
Reportability & Chargeability | ||
| Did the incident result in a fatality for company driver / passenger? | NVARCHAR(50) | |
| Were there any non-employees (other parties) injured as a result of the incident? | NVARCHAR(50) | |
| Did the incident result in a fatality for any parties involved (non-employees)? | NVARCHAR(50) | |
| Were any of the parties involved treated away from the scene (i.e., transported by ambulance from scene)? | NVARCHAR(50) | |
| Were there any Hazardous Materials spilled | NVARCHAR(50) | |
| Does this incident need to be reported to the Department of Transportation (DOT)? | NVARCHAR(50) | |
| Please identify DOT Reportable Type | NVARCHAR(100) | |
| Please provide any comments necessary for verifying DOT Reportable Classification. | NVARCHAR(500) | |
| Last Federal Annual Inspection | DATETIME | |
| Last Driver Vehicle Inspection Report (DVIR) | DATETIME | |
| Please identify if a chargeable accident for Company Vehicle | NVARCHAR(100) | |
| Please select the expected payout / cost associated with the Vehicle Accident? | NVARCHAR(100) | |
| Please provide the total payout cost: | Float | |
| Comments | NVARCHAR(2000) | |
Summary of Injured Parties:
| Section | Field Name | Database Column Size |
|---|---|---|
| Summary of Injured Parties | ||
| Injured Party Type | NVARCHAR(100) | |
| Name of Involved Person | NVARCHAR(50) | |
| Age | NVARCHAR(50) | |
| Residential Address | NVARCHAR(50) | |
| City | NVARCHAR(50) | |
| State | NVARCHAR(50) | |
| Zip | NVARCHAR(50) | |
| Phone Number | NVARCHAR(50) | |
| Injuries resulted in Fatality? | NVARCHAR(50) | |
| Date of Fatality | DATETIME | |
| Was individual hospitalized? | NVARCHAR(50) | |
| Hospital Name | NVARCHAR(100) | |
| Hospital Address | NVARCHAR(1000) | |
| City | NVARCHAR(200) | |
| State | NVARCHAR(100) | |
| Zip | NVARCHAR(100) | |
| Phone Number | NVARCHAR(100) | |
| Fax | NVARCHAR(200) | |
| Doctor Name: | ||
| Total Number of Injured | ||
| Total Number of Deaths | ||
Action Item Field List (Common to All Incident Types)
| Section | Field Name | Database Column Size |
|---|---|---|
| Source Details | ||
| Source ID | NVARCHAR(400) | |
| Source Title | NVARCHAR(400) | |
| Management Review Role | VARCHAR(50) | |
| TMS Enabled Department | NVARCHAR(50) | |
| TMS Work Order Number | NVARCHAR(100) | |
| Create | ||
| Action Item Title | NVARCHAR(50) | |
| Action Item Category | ||
| Action Item Type | NVARCHAR(50) | |
| Root Cause | ||
| Action Item Description | NVARCHAR(2000) | |
| Action Item Priority | ||
| Action Item Due Date | DATETIME | |
| Owner | INT, NVARCHAR(50) | |
| Responsible Department | INT | |
| Countermeasure | INT | |
| Applicable to Expansion? | NVARCHAR(10) | |
| Description of Actions to be Expanded | NVARCHAR(1000) | |
| Applicable to EEM/EPM Info ? | NVARCHAR(10) | |
| EEM / EPM | NVARCHAR(10) | |
| EEM/EPM Info Submitted ? | NVARCHAR(10) | |
| Document Number | NVARCHAR(200) | |
| Assigned By | VARCHAR(50) | |
| Verification required | INT | |
| Verify User | ||
| Approval Approval Approval | ||
| Approval Status | INT | |
| Approvers | ||
| Approval Comment | NVARCHAR(2000) | |
| Approval Date | DATETIME | |
| Complete | ||
| Action Item Status | ||
| Action Taken | NVARCHAR(2000) | |
| Action item Completed By | VARCHAR(50) | |
| Action item Completed Date | DATETIME | |
| Due Date Extension | NVARCHAR(2000) | |
| Requested Due Date Extension | DATETIME | |
| Reason for Due Date Extension | NVARCHAR(2000) | |
| Due Date Extension Request Approved? | NVARCHAR(2000) | |
| Reason for not extending the Due Date. | NVARCHAR(2000) | |
| Review/Verify | ||
| Verification Status | INT | |
| Verification Performed | VARCHAR(50) | |
| Verified By | INT | |
| Verification Date | DATETIME | |
| Comments | NVARCHAR(2000) | |
| Cost Information | ||
| Capital Expenditure involved | ||
| Approximate cost | ||
| Estimated Budget | ||
Management Review:
| Section | Field Name | DatabaseColumn Size |
|---|---|---|
| Management Review | ||
| Role | Nvarchar(50) | |
| Owner | NVARCHAR(100),NVARCHAR(100),NVARCHAR(100) | |
| Approval Due Date | varchar(50) | |
| Comments | varchar(500) | |
| Completed By | varchar(50) | |
| Completed Date | DATETIME | |
| Management Review Status | nvarchar(100) | |
Errors/Validation Messages
Generic Error codes are given below.
HTTP ERROR 401
{
"HttpStatusCode": 401,
"HttpStatus": "Unauthorized",
"ErrorCode": 1030,
"ErrorMessage": "Invalid tenant."
}
If the location code given is invalid:
{
"Message": "Invalid Location Code"
}
(When FromDate, ToDate and LastSyncedDate are empty) or (FromDate, ToDate and LastSyncedDate are given in incorrect format of DD-MM-YYYY)
{
"Message": "Date From or Date To should not be empty"
}
When FromDate is greater than ToDate and LastSyncedDate is empty
{
"Message": "Date From is greater than Date To"
}
When LastSyncedDate is greater than current date
{
"Message": "Last Synced Date is a Future Date"
}
Questions
Below is a list of questions to be addressed as a result of this requirements document:
| Question | Outcome |
|---|---|
| We would like to start playing with Location (papi/v1/location) and IMS (papi/v1/ims) services and I have a few questions. | Data would be exposed per Location |
| I assume we have to use the App (papi/v1/auth/app) Endpoint to obtain the authentication token for our Integration application to submit further requests. How can we obtain ConsumerId, App Id and ConsumerKey? How long the token is valid? How will we find out that the token has expired (HTTP 401,403)? | Any Existing Valid User credentials along with the ConsumerKey can be used to call the Auth API.PMAP would provide the Unique ConsumerKey to the Customer. If the User is valid, an Authorization Token is generated which can be used further in the Header to call Module Endpoints.If it is successful, data can be extracted else HTTP 401 Error is thrown. Each Authorization Token is valid for lifetime unless there is any change in the ConsumerKey. User can request PMAP to reset the Token anytime. |
| How can we obtain UserId required for papi/v1/locations/all/{UserId} and other services? Does UserId identify Bunge as a user among other customers? | Yes.. Any Existing Valid User credentials for any specific customer can be used to call the Auth API. |
| papi/v1/ims/incidents service specifies that LocationId is required and accepts only a single value. Does it mean that we have to submit a request for each location? Can you describe the effect of the lastSynced parameter? | Yes.For now the data can be viewed for one Location only per request. |
© 2018 ProcessMAP Corporation, All Rights Reserved Confidential, may not be disclosed without the express permission of ProcessMAP Corporation