| Table of Contents | ||
|---|---|---|
|
Background and strategic fit
...
AUTHENTICATION URL DETAILS [ Base URL with Auth EndPoint ]
Environment | Auth URL |
|---|---|
UAT | https://integrationsvc.uat.pmapconnect.com/product/papi/v1/auth |
Production |
Please note that the above Auth Token expires after every 120 minutes.
BASE URL+Endpoint FOR RESPECTIVE API CALLS :
Environment | Base URL | Method |
|---|---|---|
UAT | GET | |
Production | GET |
PropertyDamage
Incident Details
...
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. | Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ... |
ConsumerId | Represents the value of the consumer id. | 2426 |
Response
...
| View file | ||
|---|---|---|
|
Sample:
| Code Block |
|---|
[ { "IncidentID": "sample string", "InternalIncidentIDProperty Damage Incident Details": "sample{ string", "IncidentTitleIncident Details": "sample string",{ "LocationCodeIncident Internal ID": "sample string", "LocationIncident ID (System Generated)": "sample string", "IncidentDate "Incident Title/Site": "2019-10-06T00:00:00.000Zsample", "TimeofIncidentIncident Type": "sample", string 2", "TimeUndeterminedLocation Code": "sample string", "DayOfWeekLocation": "sample string", "JobShift": "sample string", }, "TimeWorkDayBeganGeneral Details": "sample{ string", "hasthePotentialtobeSerious": "sample string",Date "DescriptionofIncident": "sample stringof Incident": "2024-04-02T00:00:00.000Z", "IncidentOccurredonEmployerPremises"Time of Incident": "sample string17:25", "DepartmentTime Undetermined": "sample string", "PinLocationDay Of Week": "sample string", "Job Shift"AddressofIncidentLocation": "sample string", "CityTime Work Day Began": "sample string16:25", "County": "2019-10-06T00:00:00.000Z", "Country"Is this a serious Incident or has the Potential to be Serious?": "sample", string 2", "StateDescription of Incident": "sample string", "ZipCode": "sample string", "WasAssetinvolved" "Incident Occurred on Employer's Premises": "sample string", "AssetsAddress of Incident Location": [{"sample", "sample string 2"City": "sample", }], "ConfirmSignificancelevelofincidentCounty": "sample string", "DateandTimeReportedtoEmployerCountry": "sample string", "WasEmployeeinvolvedintheIncident "State/Province": "sample string", "EmployeeDetails"Postal Code/Zip Code": "sample", { "Was Contractor involved?"PersonnelType": "sample string", "EmployeeInvolvedContractor Name": "sample string", "EmployeeIdContractor Details": "sample string", "PayRateType": "sample string",Was the Contractor trained on Company Policies?"EmployeeDepartment": "sample string", "ContractorWas Asset involved?": "sample string", "DoyouwanttoclassifyUnsupervisedContractEmployeeAsset(s)": [ "sample string", "TypeofClientPersonnel": "sample string", "ClientCompany": "sample string", ], "NameofContractorDate Reported to Employer": "sample string2024-04-02T00:00:00.000Z", "NameofSubContractorTime Reported To Employer": "17:25"sample, string" } , "WasMachineinvolved"Confirm Significance Level of Incident": "sample" string", "MachineNumber": "sample string"}, "ReviewedbyEHSRepresentative "Employee/Individual Details": "sample string", "ReviewDate": "sample string", "Property Damage Incident Details": { "IncidentType[ { "Was an Employee / Individual involved in the Incident?": "sample string", "IsthisachargeableIncident "Personnel Type": "sample string", "CauseofIncident "First Name of Employee": "sample", string" } "DamageSummary": { "WascontractorinvolvedintheincidentMiddle Name of Employee": "sample string", "PleaseprovideContractorDetails "Last Name of Employee": "sample string", "Wasthecontractortrainedoncompanypolicies "Employee Id": "sample string", "Describeanydamagecaused": "sample string", "Describewhatcausedtheincidenttooccur": "sample string", "Describeworkactivitybeingperformedduringincident "Pay Rate Type": "sample string", "Wastheapplicableregulatoryagencynotified": "sample string" } "ArethereanyWitnessesidentifiedEmployee Department": "sample string", "NumberofWitnesses": "sample string",} "WitnessInformation": ], [ { "Property Damage Incident Details": { "LastName "Incident Type": "sample", string 2", "Is this a chargeable Incident?"FirstName": "sample string 3", "Cause of "MiddleNameIncident": "sample" string 4", }, "NotesDamage Summary": "sample string 6", "PhoneNumber{ "Describe Any Damage Caused": "sample string 6", "Describe "WitnessrealtiontoProcessMAP"What Caused the Incident To Occur": "sample", string 6" } ],"Describe Work Activity Being Performed During Incident"IncidentStatus": "sample string", "CreatedBy": "sample string", "CreatedDate": "2019-10-14T11:43:31.517Z", "Was the Applicable Regulatory Agency Notified?": "sample" "LastUpdatedDate": "2019-10-14T11:47:29.440Z" }, "LastUpdatedBy": "sampleIncident stringSeverity_En": { , "InvestigationReport": { "Incident Severity (SIF/PSIF)_En": "InvestigationResponsibilitysample":, { "ResponsibleTeamActual Severity": ["sample" }, "Process Safety": { "Is this a Process Safety Incident": "sample", "Process Safety Incident "SalutationClassification": " sample", }, "Witness Information": [ "FirstName": "Satish",{ "Are there any Witnesses identified?": "sample", "LastNameNumber of Witnesses": 1 "Korupol" }, }], { "TargetCompletionDateLast Name": "2020-04-30T00:00:00.000Zsample", "First Name": "Notesample": null, "Middle "NotifyImmediateSupervisorName": "Ysample", }, "InvestigationDetails": [], "Phone Number": "ContributingFactorssample":, [ { "Notes": "sample", "Witness Relation to "ContributingFactorType"ProcessMAP(Coworkerfriendpublicsupervisorvenueemployee)": "Computer # IT Theft", sample" } "ContributingFactors":], [ "Additional Incident Information": { "Computer Theft" "Incident Status": "sample", ], "Created By": "sample", "Created Date": "2024-04-08T04:23:14.770Z", "CommentsLast Updated By": "opiuysample", }], "5WhyMethodology": [ {"Last Updated Date": "2024-04-08T04:23:14.770Z" } }, "SelectActionorConditionthatmayhavedirectlycausedincidentInvestigation Report": { [ "Investigation Responsibility": { "Responsible Team": [ "Computer Theft" { ]"Salutation": "sample", "First Name": "sample", "WhysLast Name": ["sample" } ], { "Target Completion Date": "2024-03-05T00:00:00.000Z", "Note/Comments": "sample", "Notify Immediate Supervisor": "sample"Why or what created the scenario above}, to affect the action or condition": "conditionInvestigationDetails": [ { "Did the Incident involve },a chemical or chemical process": "sample", "Did an employee, contractor, or subcontractor medical treatment {case": "sample", "Did a fire or explosion damage greater than or equal to $100,000 of direct cost ": "sample", "Why or what created the scenario above to affect"Did thea actionfire or condition": "condition" explosion damage greater than or equal to $2500 of direct cost ": "sample", "Material }Code": "sample", "Release Location": "sample", "Is {material released above it's Flash Point?": "sample", "Spillage Quantity": "sample", "Tier Type"Why: { or what created the scenario above to affect the action or"Tier conditionType": "conditionsample", "Tier 2 Ques": "sample", }, "Tier 1 Ques": "sample", "Tier 3 Ques": "sample" { } }, { "Why or what created the"Was scenarioan aboveasset toinvolved affectin the actionInjury of orthe conditionEmployee?": "conditionsample", "Asset ID Number": "sample" }, { "Did affected employee(non-injured) voilate work { rule?": "sample", "Name of employee": "sample" }, "Why or what { created the scenario above to affect the action or condition": "condition"Did the incident result in a fire?": "sample", "Who Reported the Fire?": "sample", }, "Senior Fire Brigade Officer": "sample", "Was the {fire alarm sounded?": "sample", "Was the plant evacuated?": "sample", "FinalWas the RootFire CauseDepartment Checkedcalled?": "Yes"{ "Was the Fire Department called?": "sample", } "who called?": "sample" }, ] "How many hand extinguishers were } ]used?": "sample", "RootCauseStatement": [ "How many wheeled extinguishers {used?": "sample", "How many "RootcauseType"hose lines were used?": "Behavioral Factor'ssample", "Did the sprinklers "RootCauseoperate?": [{ "Did notthe ask for help"sprinklers operate?": "sample", "How ]many?": "sample", "Which risers?"Comments": "sample" } }, ], "FinalRootCauseStatement": [ { "Is the alarm system back in service?": "sample", "FinalRootCauseStatement": "condition Updated 2", "Have all extinguishers and hoses been replaced?"PrimaryCountermeasure": "Improvingsample", overall virologic surveillance", "Is the sprinkler system back in service?"PrimaryRootCause": "sample"Drug, or alcohol use" "What }is the plant ] }Temperature?": "sample", "What is the plant "ActionItems":humidity?": "sample", [ { "SourceIDPost Inspection Details:": "CA-WESTLAKE-19_20-I-0038",sample" }, "SourceTitle": "record test", { "ActionItemTitle": "Test pa",Is the damage to the property significant to restrict "ActionItemCategory"access?": "Incident Managementsample", "ActionItemType": "Preventative Action", "ActionItemDescriptionWhat steps are being taken to ensure no unauthorized access?": "sample", }, "ActionItemPriority": "Reg 1921", { "ActionItemDueDate": "2020-04-16T00:00:00.000Z", "Owners": [Is the damage significant enough to create a security risk to the facility?": "sample", "Please describe what steps are being taken to secure the area?"John: Smith"sample", } ], "RajeshContributing HotaFactors": [ { ], "Contributing Factor "ResponsibleDepartment"Type (Parent)": "19.1 Bu Typesample", "Contributing Factors"CounterMeasure": [ "", "ApplicabletoExpansion":sample 1"", "DescriptionofActionstobeExpandedsample 2": "", ], "ApplicabletoEEMEPMInfo": "", "EEMEPMComments": "sample", } "EEMEPMInfoSubmitted": "", ], "5 Why? Methodology"DocumentNumber": "",[ { "AssignedBy": "Vinay Eppalapelly", "Select Action or Condition that may have directly caused incident"VerificationRequired": "No",[ "ActionItemStatus": "Opensample", "ActionTaken": "", ], "ActionItemCompletedByWhys": "",[ { "CompletedDate": null, "DueDateExtension": "",Why or what created the scenario above to affect the action or condition"RequestedDueDateExtension": null,"sample1" "ReasonforDueDateExtension": "", }, "DueDateExtensionRequestApproved?": "{ ",Why or what created the scenario above to affect the action or condition"ReasonfornotextendingtheDueDate": "sample2" }, ] }] |
JSON Field Mapping with respect to Application Fields :
...
JSON Field
...
ProcessMAP System Field
...
IncidentID
...
Incident ID (System Generated)
...
InternalIncidentID
...
IncidentTitle
...
Incident Title/Site
...
LocationCode
...
Location Code
...
Location
...
IncidentDate
...
Date of Incident
...
TimeofIncident
...
Time of Incident
...
TimeUndetermined
...
DayOfWeek
...
Day Of Week
...
JobShift
...
Job Shift
...
TimeWorkDayBegan
...
Time Work Day Began
...
hasthePotentialtobeSerious
...
Is this a serious Incident or has the Potential to be Serious?
...
DescriptionofIncident
...
Description of Incident
...
IncidentOccurredonEmployerPremises
...
Incident Occurred on Employer's Premises
...
Department
...
PinLocation
...
AddressofIncidentLocation
...
Address of Incident Location
...
City
...
City
...
County
...
County
...
Country
...
Country
...
State
...
State/Province
...
ZipCode
...
Postal Code/Zip Code
...
WasAssetinvolved
...
Was Asset involved?
...
Assets
...
Select Asset(s)
...
DateandTimeReportedtoEmployer
...
Date & Time Reported to Employer
...
ConfirmSignificancelevelofincident
...
Confirm Significance Level of Incident
...
EmployeeDetails
...
Employee / Individual Details
...
WasEmployeeinvolvedintheIncident
...
Was an Employee / Individual involved in the Incident?
...
PersonnelType
...
Personnel Type
...
EmployeeInvolved
...
Employee / Individual Involved( Last, First, M.I.)
...
EmployeeId
...
Employee Id
...
PayRateType
...
Pay Rate Type
...
EmployeeDepartment
...
Employee / Individual Department
...
Contractor
...
Contractor
...
DoyouwanttoclassifyUnsupervisedContractEmployee
...
Do you want to further classify Unsupervised Contract Employee
...
TypeofClientPersonnel
...
Type of Client Personnel
...
ClientCompany
...
Client Company
...
NameofContractor
...
Name of Contractor
...
NameofSubContractor
...
Name of SubContractor
...
WasMachineinvolved
...
MachineNumber
...
ReviewedbyEHSRepresentative
...
ReviewDate
...
PropertyDamageIncidentDetails
...
Property Damage Incident Details
...
IncidentType
...
Incident Type
...
IsthisachargeableIncident
...
Is this a chargeable Incident
...
CauseofIncident
...
Cause of Incident
...
DamageSummary
...
Damage Summary
...
Wascontractorinvolvedintheincident
...
Was contractor involved in the incident
...
PleaseprovideContractorDetails
...
Please provide Contractor Details
...
Wasthecontractortrainedoncompanypolicies
...
Was the contractor trained on company policies
...
Describeanydamagecaused
...
Describe any damage caused
...
Describewhatcausedtheincidenttooccur
...
Describe what caused the incident to occur
...
Describeworkactivitybeingperformedduringincident
...
Describe work activity being performed during incident
...
Wastheapplicableregulatoryagencynotified
...
Was the applicable regulatory agency notified
...
WitnessInformation
...
Witness Information
...
ArethereanyWitnessesidentified
...
Are there any Witnesses identified
...
NumberofWitnesses
...
Number of Witnesses
...
LastName
...
LastName
...
FirstName
...
FirstName
...
MiddleName
...
MiddleName
...
Notes
...
Notes
...
PhoneNumber
...
Phone Number
...
WitnessrealtiontoProcessMAP
...
Witness Relation to ProcessMAP
(Coworker, friend, public, supervisor, venue employee)
...
InvestigationResponsibility
...
Salutation
...
Salutation
...
FirstName
...
First Name
...
LastName
...
Last Name
...
TargetCompletionDate
...
Target Completion Date
...
Note
...
Note
...
NotifyImmediateSupervisor
...
Notify Immediate Supervisor
...
InvestigationDetails
...
All questions
...
ContributingFactors
...
ContributingFactorType
...
Contributing Factor Type
...
ContributingFactors
...
Contributing Factors
...
Comments
...
Comments
...
5WhyMethodology
...
SelectActionorConditionthatmayhavedirectlycausedincident
...
Select Action or Condition that may have directly caused incident
...
Whys
...
Whys
...
RootCauseStatement
...
RootcauseType
...
Root cause Type
...
RootCause
...
Root Cause
...
Comments
...
Comments
...
FinalRootCauseStatement
...
FinalRootCauseStatement
...
Final Root Cause Statement
...
PrimaryCountermeasure
...
Primary Counter measure
...
PrimaryRootCause
...
Primary Root Cause
...
Action Items
...
SourceID
...
Source ID
...
SourceTitle
...
Source Title
...
ActionItemTitle
...
Action Item Title
...
ActionItemCategory
...
Action Item Category
...
ActionItemType
...
Action Item Type
...
RootCause
...
Root Cause
...
ActionItemDescription
...
Action Item Description
...
ActionItemPriority
...
Action Item Priority
...
ActionItemDueDate
...
Action Item Due Date
...
Owners
...
Owner
...
ResponsibleDepartment
...
Responsible Department
...
Countermeasure
...
Countermeasure
...
ApplicabletoExpansion
...
Applicable to Expansion?
...
DescriptionofActionstobeExpanded
...
Description of Actions to be Expanded *
...
ApplicabletoEEMEPMInfo
...
Applicable to EEM/EPM Info?
...
EEMEPM
...
EEM / EPM *
...
EEMEPMInfoSubmitted
...
EEM/EPM Info Submitted?
...
DocumentNumber
...
Document Number *
...
AssignedBy
...
Assigned By
...
Verificationrequired
...
Verification required
...
VerifyUser
...
Verify User
...
ApprovalStatus
...
Approval Status
...
Approvers
...
Approvers
...
ApprovalComment
...
Approval Comment
...
ApprovalDate
...
Approval Date
...
ActionItemStatus
...
Action Item Status
...
ActionTaken
...
Action Taken
...
ActionitemCompletedBy
...
Action item Completed By
...
ActionitemCompletedDate
...
Action item Completed Date
...
DueDateExtension
...
Due Date Extension
...
RequestedDueDateExtension
...
Requested Due Date Extension
...
ReasonforDueDateExtension
...
Reason for Due Date Extension
...
DueDateExtensionRequestApproved
...
Due Date Extension Request Approved?
...
ReasonfornotextendingtheDueDate.
...
Reason for not extending the DueDate.
...
VerificationStatus
...
Verification Status
...
VerificationPerformed
...
Verification Performed
...
VerifiedBy
...
Verified By
...
VerificationDate
...
Verification Date
...
Comments
...
Comments
...
CapitalExpenditureinvolved
...
Capital Expenditure involved
...
Approximatecost
...
Approximate cost
...
EstimatedBudget
...
Estimated Budget
...
Additional Information
...
IncidentStatus
...
CreatedBy
...
CreatedDate
...
LastUpdatedDate
...
{
"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": "sample"
}
]
},
{
"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": "sample"
}
]
}
],
"Root Cause Statement": [
{
"Root cause Type (Parent)": "sample",
"Root Cause": [
"sample"
],
"Comments": "sample"
},
{
"Root cause Type (Parent)": "sample",
"Root Cause": [
"sample"
],
"Comments": "sample"
}
],
"Final Root Cause": [
{
"FinalRootCauseStatement": "sample",
"PrimaryCountermeasure": "sample",
"PrimaryRootCause": "sample"
}
],
"Lessons Learned Statement": [
{
"Lessons Learned Details": "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-05-05T00:00:00.000Z",
"Owners": [
"sample"
],
"Responsible Department": "sample",
"Applicable to Expansion": "sample",
"Description of Actions to be Expanded": "Sample",
"Applicable to EEM/EPM Info": "sample",
"EEM / EPM": "Sample",
"EEM/EPM Info Submitted": "Sample",
"Document Number": "Sample",
"Assigned By": "sample",
"Verification Required": "sample",
"Approval Status": "sample",
"Approvers": [
"Sample",
"Sample",
"Sample"
],
"Approval Comment": "sample",
"Approval Date": "2021-05-05T00:00:00.000Z",
"Action Item Status": "sample",
"Action Taken": "Sample",
"Action Item Completed By": "Sample",
"Completed Date": "2021-05-05T00:00:00.000Z",
"Due Date Extension": "sample",
"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"
}
],
"Management Review": [
{
"Role": "sample",
"Owner": [
"sample"
],
"Approval Due Date": "2021-05-05T00:00:00.000Z",
"Comments": "sample",
"Completed By": "sample",
"Completed Date": "2021-05-05T00:00:00.000Z"
},
{
"Management Review Status": "sample"
}
]
}
] |
Property Damage 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) | |
General Details | ||
Date of Incident * | DATETIME | |
Time of Incident * | NVARCHAR(100) | |
Time undetermined | NVARCHAR(10) | |
Day Of Week | NVARCHAR(100) | |
Job Shift | NVARCHAR(200) | |
Time Work Day Began | NVARCHAR(200) | |
Is this a serious Incident or has the Potential to be Serious? | ||
Description of Incident | NVARCHAR(4000) | |
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) | |
Was Contractor involved? | NVARCHAR(50) | |
Contractor Name | NVARCHAR(500) | |
Contractor Details | NVARCHAR(4000) | |
Was the Contractor trained on Company Policies? | NVARCHAR(50) | |
Was Asset involved? | NVARCHAR(50) | |
Select Asset(s) | NVARCHAR(4000) | |
Date & Time Reported to Employer | DATETIME,NVARCHAR(200) | |
Confirm Significance Level of Incident | NVARCHAR(50) | |
Employee / Individual Details | ||
Was an Employee / Individual involved in the Incident? | NVARCHAR(10) | |
Personnel Type | NVARCHAR(500) | |
Employee / Individual Involved( Last, First, M.I.) | NVARCHAR(2000) | |
Employee Id | NVARCHAR(50) | |
Pay Rate Type | NVARCHAR(50) | |
Employee / Individual Department | NVARCHAR(500) | |
Contractor Name | NVARCHAR(2000) | |
Do you want to further classify Unsupervised Contract Employee | NVARCHAR(10) | |
Sub-Contractor Name | NVARCHAR(2000) | |
Property Damage Incident Details | ||
Property Damage Incident Type | NVARCHAR(1000) | |
Is this a chargeable Incident | NVARCHAR(1000) | |
Cause of Incident | NVARCHAR(1000) | |
Damage Summary | ||
Describe Any Damage Caused | NVARCHAR(1000) | |
Describe What Caused the Incident To Occur | NVARCHAR(1000) | |
Describe Work Activity Being Performed During Incident | NVARCHAR(1000) | |
Was the Applicable Regulatory Agency Notified? | NVARCHAR(1000) | |
Incident Severity_En | ||
Incident Severity (SIF/PSIF)_En | NVARCHAR(500) | |
Actual Severit | NVARCHAR(500) | |
Process Safety | ||
Is this a Process Safety Incident | NVARCHAR(5) | |
Process Safety Incident Classification | NVARCHAR(500) | |
WitnessInformation | Witness Information | |
Are there any Witnesses identified | NVARCHAR(20) | |
Number of Witnesses | INT | |
LastName | NVARCHAR(50) | |
FirstName | NVARCHAR(50) | |
MiddleName | NVARCHAR(50) | |
Notes | NVARCHAR(2000) | |
Phone Number | NVARCHAR(50) | |
Witness Relation to ProcessMAP | NVARCHAR(2000) | |
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 | |
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 | |
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 | |
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"
}