ComboCurve.Api.Model.EmbeddedLookupTableCondition

Properties

Name	Type	Description	Notes
Key	string	A well header, or a project custom header of the project. The value must have the type of the header. - A project embedded lookup table also accepts the project custom headers that the project configures. The project custom header settings give the type of each: `_project_custom_header`, `_project_custom_header_1`, `_project_custom_header_2`, `_project_custom_header_3`, `_project_custom_header_4`, `_project_custom_header_5`, `_project_custom_header_6`, `_project_custom_header_7`, `_project_custom_header_8`, `_project_custom_header_9`, `_project_custom_header_10`, `_project_custom_header_11`, `_project_custom_header_12`, `_project_custom_header_13`, `_project_custom_header_14`, `_project_custom_header_15`, `_project_custom_header_16`, `_project_custom_header_17`, `_project_custom_header_18`, `_project_custom_header_19`, `_project_custom_header_20`, `_project_custom_header_21`, `_project_custom_header_22`, `_project_custom_header_23`, `_project_custom_header_24`, `_project_custom_header_25`, `_project_custom_header_26`, `_project_custom_header_27`, `_project_custom_header_28`, `_project_custom_header_29`, `_project_custom_header_30`, `_project_custom_header_31`, `_project_custom_header_32`, `_project_custom_header_33`, `_project_custom_header_34`, `_project_custom_header_35`, `_project_custom_header_36`, `_project_custom_header_37`, `_project_custom_header_38`, `_project_custom_header_39`, `_project_custom_header_40`, `_project_custom_header_41`, `_project_custom_header_42`, `_project_custom_header_43`, `_project_custom_header_44`, `_project_custom_header_45`, `_project_custom_header_46`, `_project_custom_header_47`, `_project_custom_header_48`, `_project_custom_header_49`. - A company embedded lookup table accepts well headers only, except these headers: `api10`, `api12`, `api14`, `aries_id`, `chosenID`, `chosenKeyID`, `closest_well_any_zone`, `closest_well_same_zone`, `inptID`, `phdwin_id`. - These headers are available only when their feature is on for the tenant: `heelTrueVerticalDepth`, `midpointTrueVerticalDepth`, `toeTrueVerticalDepth`. String headers (a string): `abstract`, `allocation_type`, `api10`, `api12`, `api14`, `aries_id`, `basin`, `block`, `chosenID`, `chosenKeyID`, `closest_well_any_zone`, `closest_well_same_zone`, `combo_name`, `completion_design`, `country`, `county`, `current_operator`, `current_operator_alias`, `current_operator_code`, `current_operator_ticker`, `custom_string_0`, `custom_string_1`, `custom_string_10`, `custom_string_11`, `custom_string_12`, `custom_string_13`, `custom_string_14`, `custom_string_15`, `custom_string_16`, `custom_string_17`, `custom_string_18`, `custom_string_19`, `custom_string_2`, `custom_string_20`, `custom_string_21`, `custom_string_22`, `custom_string_23`, `custom_string_24`, `custom_string_25`, `custom_string_26`, `custom_string_27`, `custom_string_28`, `custom_string_29`, `custom_string_3`, `custom_string_30`, `custom_string_31`, `custom_string_32`, `custom_string_33`, `custom_string_34`, `custom_string_4`, `custom_string_5`, `custom_string_6`, `custom_string_7`, `custom_string_8`, `custom_string_9`, `dataPool`, `dataSource`, `dataSourceCustomName`, `district`, `drillinginfo_id`, `elevation_type`, `field`, `first_frac_vendor`, `first_treatment_type`, `flow_path`, `fluid_type`, `gas_gatherer`, `hole_direction`, `ihs_id`, `inptID`, `landing_zone`, `lease_name`, `lease_number`, `mostRecentImportDesc`, `mostRecentImportType`, `oil_gatherer`, `pad_name`, `parent_child_any_zone`, `parent_child_same_zone`, `phdwin_id`, `play`, `previous_operator`, `previous_operator_alias`, `previous_operator_code`, `previous_operator_ticker`, `primary_product`, `prms_reserves_category`, `prms_reserves_sub_category`, `prms_resources_class`, `production_method`, `proppant_mesh_size`, `proppant_type`, `range`, `recovery_method`, `refrac_frac_vendor`, `refrac_treatment_type`, `rig`, `rseg_id`, `section`, `spgci_id`, `state`, `status`, `subplay`, `survey`, `target_formation`, `tgs_id`, `toe_in_landing_zone`, `toe_up`, `township`, `type_curve_area`, `well_name`, `well_number`, `well_type`. Number headers (a number): `acre_spacing`, `azimuth`, `before_income_tax_cash_flow`, `casing_id`, `choke_size`, `cum_boe`, `cum_boe_per_perforated_interval`, `cum_gas`, `cum_gas_per_perforated_interval`, `cum_gor`, `cum_mmcfge`, `cum_mmcfge_per_perforated_interval`, `cum_oil`, `cum_oil_per_perforated_interval`, `cum_water`, `cum_water_per_perforated_interval`, `custom_number_0`, `custom_number_1`, `custom_number_10`, `custom_number_11`, `custom_number_12`, `custom_number_13`, `custom_number_14`, `custom_number_15`, `custom_number_16`, `custom_number_17`, `custom_number_18`, `custom_number_19`, `custom_number_2`, `custom_number_3`, `custom_number_4`, `custom_number_5`, `custom_number_6`, `custom_number_7`, `custom_number_8`, `custom_number_9`, `distance_from_base_of_zone`, `distance_from_top_of_zone`, `drainage_area`, `elevation`, `first_12_boe`, `first_12_boe_per_perforated_interval`, `first_12_gas`, `first_12_gas_per_perforated_interval`, `first_12_gor`, `first_12_mmcfge`, `first_12_mmcfge_per_perforated_interval`, `first_12_oil`, `first_12_oil_per_perforated_interval`, `first_12_water`, `first_12_water_per_perforated_interval`, `first_6_boe`, `first_6_boe_per_perforated_interval`, `first_6_gas`, `first_6_gas_per_perforated_interval`, `first_6_gor`, `first_6_mmcfge`, `first_6_mmcfge_per_perforated_interval`, `first_6_oil`, `first_6_oil_per_perforated_interval`, `first_6_water`, `first_6_water_per_perforated_interval`, `first_additive_volume`, `first_cluster_count`, `first_discount_cash_flow`, `first_fluid_per_perforated_interval`, `first_fluid_volume`, `first_max_injection_pressure`, `first_max_injection_rate`, `first_prop_weight`, `first_proppant_per_fluid`, `first_proppant_per_perforated_interval`, `first_stage_count`, `first_test_flow_tbg_press`, `first_test_gas_vol`, `first_test_gor`, `first_test_oil_vol`, `first_test_water_vol`, `footage_in_landing_zone`, `formation_thickness_mean`, `gas_breakeven`, `gas_shrunk_eur`, `gas_shrunk_eur_over_pll`, `gas_specific_gravity`, `gross_perforated_interval`, `ground_elevation`, `heelLatitude`, `heelLongitude`, `heelTrueVerticalDepth`, `horizontal_spacing`, `initial_respress`, `initial_restemp`, `irr`, `landing_zone_base`, `landing_zone_top`, `last_12_boe`, `last_12_boe_per_perforated_interval`, `last_12_gas`, `last_12_gas_per_perforated_interval`, `last_12_gor`, `last_12_mmcfge`, `last_12_mmcfge_per_perforated_interval`, `last_12_oil`, `last_12_oil_per_perforated_interval`, `last_12_water`, `last_12_water_per_perforated_interval`, `last_month_boe`, `last_month_boe_per_perforated_interval`, `last_month_gas`, `last_month_gas_per_perforated_interval`, `last_month_gor`, `last_month_mmcfge`, `last_month_mmcfge_per_perforated_interval`, `last_month_oil`, `last_month_oil_per_perforated_interval`, `last_month_water`, `last_month_water_per_perforated_interval`, `lateral_length`, `lower_perforation`, `matrix_permeability`, `measured_depth`, `midpointLatitude`, `midpointLongitude`, `midpointTrueVerticalDepth`, `month_produced`, `ngl_shrunk_eur`, `ngl_shrunk_eur_over_pll`, `nri_oil`, `num_treatment_records`, `oil_api_gravity`, `oil_breakeven`, `oil_shrunk_eur`, `oil_shrunk_eur_over_pll`, `oil_specific_gravity`, `payout_duration`, `perf_lateral_length`, `refrac_additive_volume`, `refrac_cluster_count`, `refrac_fluid_per_perforated_interval`, `refrac_fluid_volume`, `refrac_max_injection_pressure`, `refrac_max_injection_rate`, `refrac_prop_weight`, `refrac_proppant_per_fluid`, `refrac_proppant_per_perforated_interval`, `refrac_stage_count`, `stage_spacing`, `surfaceLatitude`, `surfaceLongitude`, `thickness`, `toeLatitude`, `toeLongitude`, `toeTrueVerticalDepth`, `total_additive_volume`, `total_cluster_count`, `total_fluid_per_perforated_interval`, `total_fluid_volume`, `total_prop_weight`, `total_proppant_per_fluid`, `total_proppant_per_perforated_interval`, `total_stage_count`, `true_vertical_depth`, `tubing_depth`, `tubing_id`, `undiscounted_roi`, `upper_perforation`, `vertical_spacing`, `wi_oil`. Integer headers (a number, with the `equal` operator only): `hz_well_spacing_any_zone`, `hz_well_spacing_same_zone`, `vt_well_spacing_any_zone`, `vt_well_spacing_same_zone`. Percent headers (a number from 0 to 100): `percent_in_zone`, `porosity`, `sg`, `so`, `sw`. Date headers (a date string in YYYY-MM-DD format): `completion_end_date`, `completion_start_date`, `createdAt`, `custom_date_0`, `custom_date_1`, `custom_date_10`, `custom_date_11`, `custom_date_12`, `custom_date_13`, `custom_date_14`, `custom_date_15`, `custom_date_16`, `custom_date_17`, `custom_date_18`, `custom_date_19`, `custom_date_2`, `custom_date_3`, `custom_date_4`, `custom_date_5`, `custom_date_6`, `custom_date_7`, `custom_date_8`, `custom_date_9`, `date_rig_release`, `drill_end_date`, `drill_start_date`, `econ_first_production_date`, `econ_run_date`, `first_prod_date`, `first_prod_date_daily_calc`, `first_prod_date_monthly_calc`, `last_prod_date_daily`, `last_prod_date_monthly`, `mostRecentImportDate`, `permit_date`, `refrac_date`, `spud_date`, `til`, `updatedAt`. Boolean headers (`true` or `false`): `copied`, `custom_bool_0`, `custom_bool_1`, `custom_bool_2`, `custom_bool_3`, `custom_bool_4`, `generic`, `has_daily`, `has_directional_survey`, `has_monthly`.
Operator	string	Comparison operator. The operator also sets the behavior of the header. Use the same behavior for a header in all rules. - `equal`: The UI \"Match\" cell - `greater_than_equal`: The UI \"Min (>=)\" or \"Start (>=)\" cell (number and date headers) - `less_than_equal`: The UI \"Max (<=)\" or \"End (<=)\" cell (number and date headers) - `ratio`: The UI \"Ratio\" cell. The value is the divisor: each number of the rule is multiplied by the header value and divided by this value. It does not filter wells. One header of the table at the maximum, number headers only. - `interpolation`: The UI \"Interpolation\" cell. The value is the first boundary, and `interpolationRows` gives the next boundaries. It does not filter wells. One header of the table at the maximum, number headers only.
Value	Object	Value to compare against. Must match the header type: - String headers: string value (e.g., \"Permian\") - Numeric headers: number value (e.g., 5000) - Date headers: date string in YYYY-MM-DD format (e.g., \"2020-01-01\") - Boolean headers: boolean value (true or false) - `null` matches only the wells with no value. The UI shows `null` as \"N/A\".

[Back to Model list] [Back to API list] [Back to README]