Allocation

the allocation table is only needed when a well's daily production docid\ jnogjwoaowkpzzaho3pkp comes from a metered source (e g a multiphase flow meter) and you also want to track allocated volumes in that case, push the measured rates to daily production and the allocated volumes here, so forecasting results stay consistent with business reporting standards if daily production is your single source of truth, this table does not need to be populated the unique constraint on allocation entries is uwi + date variable data type unit of measure is nullable? default value description uwi string no unique well identifier must match the uwi of a record in the well docid\ p xhbe4jqkjqemay7aol5 table date datetime offset no allocation date datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37 +0000 oilrate double stb/d no allocated oil rate gasrate double mscf/d no allocated gas rate waterrate double stb/d no allocated water rate factor double no allocation factor applied for the day data integrity checks condition response uwi is null or empty record rejected uwi does not exist in the well table record rejected any non nullable field is null record rejected common error messages api scenario error response add / upsert allocation unknown uwi uwi xxx does not exist fetch / delete allocation unknown uwi uwi xxx does not exist