Implement endpoints to CRUD Formation Pressure (data)
Implement POST/api/rafs-ddms/formationpressuretests/{record_id}/data is implemented and available on Swagger
- record_id is the formationpressuretests WPC which was created previously
- User should be able to fill the formationpressuretests report with measurements taken in this analysis
- Successful response (200 status code) should update formationpressuretests record and include DDMSDatasets array with GET endpoint to the linked bulk data of formationpressuretests
- Validation cases should be covered with appropriate status codes
- Request & response structure should correspond to populated JSON
Implement GET/api/rafs-ddms/formationpressuretests/{record_id}/data endpoint is implemented and available on Swagger
- record_id is the formationpressuretests WPC
- User should be able to retrieve bulk data of formationpressuretests using new endpoint
- Successful response (200 status code) should retrieve all existing formationpressuretests Measurements (bulk data) linked to specified record id
- Validation cases should be covered with appropriate status codes
- Structure of request and response should correspond to populated JSON content schema
Click to expand
{
"FormationPressureTestID": {
"title": "Wireline or LWD Formation Pressure Test ID",
"type": "string",
"pattern": "^[\\w\\-\\.]+:work-product-component\\-\\-FormationPressureTest:[\\w\\-\\.\\:\\%]+:[0-9]*$"
},
"FormationPressureTestSteps": {
"name": "Measured Formation Pressure Test Steps",
"type": "array",
"items": {
"type": "object",
"properties": {
"StepNumber": {
"title": "Step Number",
"type": "string",
"description": "Internal step number which identifies the sequence of step in CCE measurements"
},
"PretestFileID": {
"title": "Pretest File ID",
"type": "string",
"description": "reference to the las or dlis file used to store the pretest profile",
"pattern": "^[\\w\\-\\.]+:dataset\\-\\-File.Generic:[\\w\\-\\.\\:\\%]+$"
},
"TestStatus": {
"title": "Test Status",
"type": "string",
"description": "wireline test qc remark, examples: good test, dry, supercharged"
},
"IsMiniDST": {
"title": "Is Mini DST",
"type": "boolean",
"description": "check whether formation test is mini-dst or not"
},
"PretestVolume": {
"title": "Pretest Volume",
"description": "pretest drawdown volume",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"FormationTemperature": {
"title": "Formation Temperature",
"description": "formation temperature at reference test depth",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"FluidMobility": {
"title": "Fluid Mobility",
"description": "fluid mobility (typically draw-down moblity)",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
},
"Type": {
"type": "string"
}
}
},
"SphericalMobilityExact": {
"title": "Spherical Mobility Exact",
"description": "Spherical Mobility Exact",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"DrawDownMobility": {
"title": "Draw Down Mobility",
"description": "Draw Down Mobility",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"LogFluid": {
"title": "Log Fluid",
"type": "string",
"description": "May be mixed oil and water, notes whether a sample was taken"
},
"DrillLogDirection": {
"title": "Drill Log Direction",
"type": "string",
"description": "POOH or RIH can be examples"
},
"WirelineDirection": {
"title": "Wireline Direction",
"type": "string",
"description": "Up or Down can be examples"
},
"ToolType": {
"title": "Tool Type",
"description": "Name of the tool used during the test. Tool Type examples are StethoScope MDT, Geotap RDT",
"type": "object",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-ToolType:[\\w\\-\\.\\:\\%]+:[0-9]*$"
},
"GaugeType": {
"title": "Tool Type",
"description": "Name of the pressure gauge used during the test. Gauge Type examples are PQQP1",
"type": "object",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-ToolType:[\\w\\-\\.\\:\\%]+:[0-9]*$"
},
"HoleSize": {
"title": "Hole Size",
"description": "TBD",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"FileNumber": {
"title": "File umber",
"type": "string",
"description": "reference to the las or dlis file used to store the pretest profile"
},
"RunNumber": {
"title": "Run Number",
"type": "string",
"description": "Internal step number which identifies the sequence of step in CCE measurements"
},
"TestNumber": {
"title": "Test Number",
"type": "string",
"description": "Internal test number which is used as the test identifier in vendor "
},
"TestDepth": {
"title": "Test Depth",
"description": "The depth at which the formation pressure reading was acquired during the step.",
"type": "array",
"items": [
{
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
},
"Type": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-VerticalMeasurementType:[\\w\\-\\.\\:\\%]+:[0-9]*$"
},
"Path": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-VerticalMeasurementPath:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
}
],
"DepthShift": {
"title": "Depth Shift",
"description": "Depth Shift",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
},
"Remarks": {
"type": "string"
},
"OriginalMD": {
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"WellDeviation": {
"title": "Well Deviation",
"description": "Well Deviation",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
}
}
}
},
"HydrostaticPressureBeforePretestEMW": {
"title": "Hydrostatic Pressure Before PretestEMW",
"description": "initial hydrostatic (mud) pressure before flow (ihp) equivalent mud weight",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"HydrostaticPressureBeforePretest": {
"title": "Hydrostatic Pressure Before Pretest",
"description": "initial hydrostatic (mud) pressure before flow (ihp)",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"HydrostaticPressureAfterPretestEMW": {
"title": "Hydrostatic Pressure After Pretest EMW",
"description": "final hydrostatic (mud) after tool shut-in (fhp) equivalent mud weight",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"HydrostaticPressureAfterPretest": {
"title": "Hydrostatic Pressure After Pretest",
"description": "final hydrostatic (mud) after tool shut-in (fhp)",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"FormationPressure": {
"title": "Formation Pressure",
"description": "formation pressure",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"FormationQuality": {
"title": "Formation Quality",
"type": "string",
"description": "TBD"
},
"Depletion": {
"title": "Depletion",
"description": "Depletion",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"EquivalentFormationPressure": {
"title": "Equivalent Formation Pressure",
"description": "Equivalent Formation Pressure",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"SixtySecondSlope": {
"title": "Sixty Second Slope",
"description": "Sixty Second Slope",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"TemperatureBefore": {
"title": "Temperature Before",
"description": "Temperature Before",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"TemperatureAfter": {
"title": "Temperature After",
"description": "Temperature After",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"ProbeType": {
"title": "Probe Type",
"type": "string",
"description": "TBD"
},
"PretestType": {
"title": "Pretest Type",
"type": "string",
"description": "TBD"
},
"SampleFluidType": {
"title": "Sample Fluid Type",
"type": "string",
"description": "Type of Fluid Sample, if collected"
},
"ReportSampleIdentifier": {
"title": "Report Sample Identifier",
"type": "string",
"description": "TBD"
},
"EstimatedSampleContamination": {
"title": "Estimated Sample Contamination",
"description": "Estimated Sample Contamination",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"VendorPretestStatus": {
"title": "Vendor Pretest Status",
"type": "string",
"description": "TBD"
},
"Remarks": {
"title": "Remarks",
"description": "Remarks",
"type": "object",
"properties": {
"RemarkID": {
"type": "string"
},
"Remark": {
"type": "string"
},
"Source": {
"type": "string"
}
}
},
"ProbeOrientation": {
"title": "Probe Orientation",
"type": "string",
"description": "TBD"
},
"PretestRate": {
"title": "PretestRate",
"description": "PretestRate",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"PretestDuration": {
"title": "Pretest Duration",
"description": "Pretest Duration",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"StandardDeviationSigma": {
"title": "Standard Deviation Sigma",
"description": "Standard Deviation Sigma",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"Caliper1Axis": {
"title": "Caliper 1 Axis",
"description": "Caliper 1 Axis",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"ExposureTime": {
"title": "Exposure Time",
"description": "Exposure Time",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"DrawDownPressure": {
"title": "Draw Down Pressure",
"description": "Draw Down Pressure",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"EndDrawDownPressure": {
"title": "End Draw Down Pressure",
"description": "End Draw Down Pressure",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
}
}
}
},
"Calculated": {
"name": "Calculated Formation Pressure Test Steps",
"type": "array",
"items": {
"type": "object",
"properties": {
"StepNumber": {
"title": "Step Number",
"type": "string",
"description": "Internal step number which identifies the sequence of step in CCE measurements"
},
"PressureShift": {
"title": "Pressure Shift",
"description": "pressure gauge correction",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"FormationPressure": {
"title": "Formation Pressure",
"description": "corrected formation pressure with gauge shift",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"Permeability": {
"title": "Permeability",
"description": "calculated formation permeability from test",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"BuildupPressure": {
"title": "Buildup Pressure",
"description": "the buildup pressure value used to decide the formation pressure",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"ExtrapolatedBuildupPressure": {
"title": "Extrapolated Buildup Pressure",
"description": "extrapolated formation (static) pressure",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"SixtySecondSlope": {
"title": "60 Second Slope",
"description": "the rate of change in pressure over a period of 60 seconds during the test",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"ExcessPressure": {
"title": "Excess Pressure",
"description": "the pressure above the hydrostatic pressure of the fluid column in the wellbore",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
},
"FluidType": {
"type": "string"
}
}
}
}
}
},
"InterpretationSummary": {
"name": "Formation Test Interpretation Summary",
"type": "object",
"properties": {
"AvgFlowingPressure": {
"title": "Average Flowing Pressure",
"description": "average pressure during test drawdown period",
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
}
}
},
"Intercept": {
"title": "Intercept",
"description": "y-intercept calculated from pressure vs depth crossplot",
"type": "array",
"items": {
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
},
"FluidType": {
"type": "string"
},
"FittingGroup": {
"type": "string"
}
}
}
},
"FluidGradient": {
"title": "Fluid Gradient",
"description": "calculated fluid gradient from pressure vs depth crossplot",
"type": "array",
"items": {
"type": "object",
"properties": {
"Value": {
"type": "number"
},
"UnitOfMeasure": {
"type": "string",
"pattern": "^[\\w\\-\\.]+:reference-data\\-\\-UnitOfMeasure:[\\w\\-\\.\\:\\%]+:[0-9]*$"
},
"FluidType": {
"type": "string"
},
"FittingGroup": {
"type": "string"
}
}
}
}
}
},
"required": [
"FormationPressureTestID"
]
}