| Jira Legacy | ||||||||
|---|---|---|---|---|---|---|---|---|
|
...
Background and strategic fit
The purpose of this Integration is to get action item 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 action item detail
- 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
- The user would have to input a 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. Customers will have to use mapping documentation
- User accessing this endpoint through a valid Token & ConsumerId, provided by ProcessMAP, will have access to complete data
- Owner Information will be as nested
- Asset Information will be as nested
- DATETIME, INT, and FLOAT data will be shown as NULL when there is no data
- Pin Location Information and Default CAPA is not considered for this release
- The data that is being shown in response is in EST Date time format ONLY
- Certain fields are auto-populated in Application but the same will not reflect in JSON until the form is saved
User Interaction
Action Item Details
...
| Name | Description | Type | Additional information |
|---|---|---|---|
| locationCode | Represents the unique code of the location for which action item records to return. | string | Required |
| dateFrom | Represents the starting date of action item records to return. | date | Required but value optional |
| dateTo | Represents the ending date of action item records to return. | date | Required but value optional |
| lastSyncedDate | Represents the data from the action item due date. | date | Required but value optional |
...
Action Items": [
{
"Source ID": "sample string",
"Source Title": "sample string",
"Action Item ID": "sample string",
"Action Item Title": "sample string",
"Action Item Category": "sample string",
"Action Item Type": "Corrective Action",
"Root Cause": "sample string",
"Action Item Description":"sample string",
"Action Item Priority": "sample string",
"Action Item Due Date": "2019-11-06T00:00:00.000Z",
"Owners":
[
"sample string"
],
"Notify Owners Immediately": "sample string",
"Responsible Department": "sample string",
"Assets":
[
"sample string"
],
"Hierarchy of Controls": "sample string",
"Assigned By": "sample string",
"Verification Required": "sample string",
"Verify User":
[
"sample string"
],
"Approval Status": "sample string",
"Approval Comment": "sample string",
"Approver": "sample string",
"Approval Date": "2019-10-06T00:00:00.000Z",
"Action Item Status": "sample string",
"Response": "sample string",
"Score": "sample string",
"Action Taken": "sample string",
"Action Item Completed By": "sample string",
"Completed Date": "2019-10-06T00:00:00.000Z",
"Due Date Extension": "sample string",
"Requested Due Date Extension": "sample string",
"Reason for Due Date Extension": "sample string",
"Due Date Extension Request Approved?": "sample string",
"Reason for not extending the Due Date": "sample string",
"Verification Status": "sample string",
"Verification Performed": "sample string",
"Onsite When": "sample string",
"Verified By": "sample string"
"Verification Date":"sample string"
"Verification Comments":"sample string",
"Capital Expenditure Involved": "sample string"
"Approximate Cost": "sample string"
"Estimated Budget":"sample string",
"Actual Costs":"sample string",
"Memo":"sample string",
}
]
Action Item Field List
| Section | Field Name | Database Column Size |
|---|---|---|
| Source Details | ||
| Source ID | NVARCHAR(400) | |
| Source Title | NVARCHAR(400) | |
| Create | ||
| Action Item ID | ||
| Action Item Title | NVARCHAR(50) | |
| Action Item Category | INT, NVARCHAR(50) | |
| Action Item Type | NVARCHAR(50) | |
| Root Cause | INT, NVARCHAR(50) | |
| Action Item Description | NVARCHAR(2000) | |
| Action Item Priority | INT | |
| Action Item Due Date | DATETIME | |
| Owners | INT, NVARCHAR(50) | |
| Notify Owners Immediately | ||
| Responsible Department | INT, NVARCHAR(50) | |
| Asset | INT, NVARCHAR(50) | |
| Hierarchy of Controls | INT, NVARCHAR(50) | |
| Assigned By | VARCHAR(50) | |
| Verification required | INT | |
| Verify User | ||
| Approval Approval Approval | ||
| Approval Status | INT | |
| Approvers | ||
| Approval Comment | NVARCHAR(2000) | |
| Approval Date | DATETIME | |
| Complete | ||
| Action Item Status | ||
| Response | ||
| Score | ||
| Action Taken | NVARCHAR(2000) | |
| Action item Completed By | VARCHAR(50) | |
| Action item Completed Date | DATETIME | |
| Due Date Extension | NVARCHAR(2000) | |
| Requested Due Date Extension | DATETIME | |
| Reason for Due Date Extension | NVARCHAR(2000) | |
| Due Date Extension Request Approved? | NVARCHAR(2000) | |
| Reason for not extending the Due Date. | NVARCHAR(2000) | |
| Review/Verify | ||
| Verification Status | INT | |
| Verification Performed | VARCHAR(50) | |
| Onsite When | ||
| Verified By | INT | |
| Verification Date | DATETIME | |
| Comments | NVARCHAR(2000) | |
| Cost Information | ||
| Capital Expenditure involved | ||
| Approximate cost | ||
| Estimated Budget | ||
| Actual Cost | ||
| Memo | ||
...
Below is a list of questions to be addressed as a result of this requirements document:
| Question | Outcome |
|---|---|
Poonam[9th Aug 2021]- As discussed in the call today,The design would be better if The Response JSON Structure has section wise data, which will make the output more readable. Will be sharing the JSON Structure.