Manuel de la base de données
Exporter vers Excel | Version imprimable (format grand tableau)
| Table | Table Comments |
|---|---|
| FIELD_MONTHLY_PROD | This table was created in February of 1998 for the storage and retrieval of monthly field production data. The data source for Cohasset and Panuke production was the monthly CNSOPB production summary. The CNSOPB web site is the data source for Sable Project production. The CNLOPB web site is the data source for Hibernia, Terra Nova and Whiterose production. |
Exporter vers Excel | Version imprimable (format grand tableau)
| Table | Column | Column Comments |
|---|---|---|
| FIELD_MONTHLY_PROD | FIELD | The field in which the production occurs. Values: ALMA, COHASSET, HIBERNIA, NORTH TRIUMPH, PANUKE, SOUTH VENTURE, TERRA NOVA, THEBAUD, VENTURE or WHITE ROSE. |
| FIELD_MONTHLY_PROD | SEQ_NO | A sequence number utilized by the database to order the data chronologically. |
| FIELD_MONTHLY_PROD | PROD_MONTH | The year and month during which the production occurred. |
| FIELD_MONTHLY_PROD | OIL | Oil production for the field during the month. Measured in cubic metres (per month). |
| FIELD_MONTHLY_PROD | WATER | Water production for the field during the month. Measured in cubic metres (per month). |
| FIELD_MONTHLY_PROD | GAS | Gas production for the field during the month. Measured in thousands of cubic metres (per month). |
| FIELD_MONTHLY_PROD | CUM_OIL | Value for the cumulative oil production for the field from the beginning of production through to the end of the specified month. Measured in cubic metres. |
| FIELD_MONTHLY_PROD | CUM_WATER | Value for the cumulative water production for the field from the beginning of production through to the end of the specified month. Measured in cubic metres. |
| FIELD_MONTHLY_PROD | CUM_GAS | Value for the cumulative gas production for the field from the beginning of production through to the end of the specified month. Measured in cubic metres. |
| FIELD_MONTHLY_PROD | SOURCE | The provider of the data. Values: CNSOPB (Canada-Nova Scotia Offshore Petroleum Board) or CNLOPB (Canada-Newfoundland and Labrador Offshore Petroleum Board). |
| FIELD_MONTHLY_PROD | ROW_CHANGED_DATE | Date of row creation or most recent modification. |
| FIELD_MONTHLY_PROD | ROW_CHANGED_BY | Name of the individual who created or modified the row. |
| FIELD_MONTHLY_PROD | RESERVOIR | Reservoir from which the hydrocarbons were produced. |
| FIELD_MONTHLY_PROD | PROD_YEAR | The year during which the production occurred. |