...
| Code Block |
|---|
[
{
"Operational Profile": {
"Details": {
"Location Code": "WestLake",
"Profile Month": "April 2021",
"Profile Name": "Sample",
"Effective From": "2021-04-01T00:00:00.000Z",
"Effective Till": "2021-04-30T00:00:00.000Z",
"Profile Owners": "Sample1,Sample2"
},
"Profile Filters": {
"Protocol": "Sample",
"Activity Filter": "Sample",
"Question": [
{
"Question Title": "Sample",
"Response": "No"
},
{
"Question Title": "Sample1",
"Response": "No"
},
{
"Question Title": "Sample2",
"Response": "No"
}
]
},
"Additional Profile Details": {
"Created By": "Sample",
"Created Date": "2021-04-30T17:38:50.047Z",
"Last Updated By": "Sample",
"Updated Date": "2021-04-30T17:39:28.747Z"
},
"Action Item Details": [
{
"Action Item ID": "US-RESEARCH PARK-2021-OPM-AI-00061",
"Action Item Title": "Sample",
"Action Item Description": "Sample",
"Action Item Due Date": "2021-05-10T00:00:00.000Z",
"Primary Owners": "Sample",
"Response": "Response Yes",
"Score": 50.00,
"Action Item Status": "Closed",
"Comments": "mm",
"Action Item Completed By": "Sample",
"Action Item Completed Date": "2021-05-10T00:00:00.000Z",
"Last Updated By": "Sample",
"Updated Date": "2021-05-10T00:00:00.000Z"
},
{
"Action Item ID": "US-RESEARCH PARK-2021-OPM-AI-0002",
"Action Item Title": "Sample1",
"Action Item Description": "Sample1",
"Action Item Due Date": "2021-05-10T00:00:00.000Z",
"Primary Owners": "Sample1",
"Response": "Response Yes",
"Score": 50.00,
"Action Item Status": "Closed",
"Comments": "mm",
"Action Item Completed By": "Sample",
"Action Item Completed Date": "2021-05-10T00:00:00.000Z",
"Last Updated By": "Sample",
"Updated Date": "2021-05-10T00:00:00.000Z"
}
]
}
}
] |
Section | Field Name | Database Column Size |
|---|---|---|
Details | ||
Location Code | nvarchar(50) | |
Profile Month | nvarchar(100) | |
Profile Name | nvarchar(100) | |
Effective From | datetime | |
Effective Till | datetime | |
Profile Owners | nvarchar(4000) | |
Profile Filters | ||
Protocol | nvarchar(100) | |
Activity Filter | nvarchar(100) | |
Profile Filters >> Question | ||
Question Title | nvarchar(50) | |
Response | nvarchar(50) | |
Additional Profile Details | ||
Created By | nvarchar(100) | |
Created Date | datetime | |
Last Updated By | nvarchar(100) | |
Updated Date | datetime | |
Action Item Details | ||
Action Item ID | nvarchar(200) | |
Action Item Title | nvarchar(500) | |
Action Item Description | nvarchar(4000) | |
Primary Owners | nvarchar(4000) | |
Response | nvarchar(100) | |
Score | int | |
Action Item Status | nvarchar(100) | |
Comments | nvarchar(4000) | |
Action Item Completed By | nvarchar(100) | |
Action Item Completed Date | datetime | |
Last Updated By | nvarchar(100) | |
Updated Date | datetime | |
Errors/Validation Messages
...