A simplified report that describes the operational units of a product flow network unit over a period of time.
instance_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
instance_create_date (O: TIMESTAMP)
e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
last_updated (O: TIMESTAMP)
e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
object_count (M: INTEGER)
pfnu_period_operation_report.object_count
The count of the objects being reported for the product flow network unit.
pfnu_period_operation_report.pfnu
Specifies the producing object for which this report is compiled. pfnu_s: Implements a foreign key to a row in one of the tables projected from entity pfnu depending on the value of the next column (See below). pfnu_t: Defines the name of the referenced table. Possible values are defined in @pfnu.
pfnu_period_operation_report.ref_pfnu_operational_object
The type of object being counted for the product flow network unit. Examples include inactive wells, flowing wells, producing fields, shut-in platforms, etc.
Defines a foreign key to table r_pfnu_operational_object.
description (O: CHAR VARYING(2000))
e_and_p_data.description
A remark or comment about the instance.
pfnu_period_operation_report.end_time
The date and time of day designated as the end of the valid or effective time period over which this reported information applies.
instance_creator (O: CHAR VARYING(80))
e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
last_updated_by (O: CHAR VARYING(80))
e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
source (O: CHAR VARYING(80))
e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
pfnu_period_operation_report.start_time
The date and time of day designated as the start of the valid or effective time period over which this reported information applies.
r_transient_period (FNK, O: CHAR VARYING(80))
pfnu_period_operation_report.ref_transient_period
The type of period being described by the PFNU period report. Examples are day, week, month, quarter, year, year-to-date, cumulative, instantaneous, etc.
Defines a foreign key to table r_transient_period.