IMS Injury/Illness Outbound API
Background and strategic fit
The purpose of this Integration is to pull over different Injury/Illness incident information 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
- 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 is sent in Outbound
- The date 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
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 |
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 |
Sample Parameters
Poonam Chandak Please update postman screenshot
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 JSON
[ { "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
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 |
Action Item Field List
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 |
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