POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
The volume or mass of fluid, specifically hydrocarbons, that are stored or in transit, usually from a seller to a buyer.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
- fluid_cargo.identifier
The identifier, such as a cargo number, for the fluid cargo.
- 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).
- fluid_component_s (FSK, M: CHAR VARYING(19))
fluid_component_t (M: CHAR VARYING(30))
- fluid_cargo.fluid_component
The specific or generic fluid in the cargo.
fluid_component_s: Implements a foreign key to a row in one of the tables projected from entity fluid_component depending on the value of the next column (See below).
fluid_component_t: Defines the name of the referenced table. Possible values are: bulk_material, r_generic_fluid_component (@fluid_component).
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- end_date (O: TIMESTAMP)
end_date_cd (O: CHAR(1))
end_date_yr (O: FLOAT)
end_date_yp (O: INTEGER)
end_date_dy (O: INTEGER)
end_date_hr (O: INTEGER)
end_date_mt (O: INTEGER)
end_date_st (O: FLOAT)
end_date_of (O: FLOAT)
- fluid_cargo.end_date
The date and time when this fluid cargo ceases to exist, such as when unloaded from a stationary container, offloaded from a vessel or delivered by a pipeline.
- 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".
- start_date (O: TIMESTAMP)
start_date_cd (O: CHAR(1))
start_date_yr (O: FLOAT)
start_date_yp (O: INTEGER)
start_date_dy (O: INTEGER)
start_date_hr (O: INTEGER)
start_date_mt (O: INTEGER)
start_date_st (O: FLOAT)
start_date_of (O: FLOAT)
- fluid_cargo.start_date
The date and time when this fluid cargo was created, such as when loaded into a stationary container, a vessel or a pipeline.
- containing_facility_s (FSK, O: CHAR VARYING(19))
- fluid_cargo.containing_facility
This is the facility that holds the fluid cargo, such as a ship or a pipeline.
Defines a foreign key to table general_facility.
- pfnu_cargo_connection_s (FSK, O: CHAR VARYING(19))
- fluid_cargo.pfnu_cargo_connection
This is the description of the initial and terminal sites for the fluid cargo. These sites are defined as fluid inlets and outlets of producing, processing, storage and transporting facilities.
Defines a foreign key to table pfnu_external_connection.
Table is related to: contract_object_designation, contract_oblig_object_fulfil, data_collection_content, derived_interest_makeup, document_specification_part, fluid_cargo_transfer, @graphical_element, guideline_compliance, object_activity_involvement, object_remark, object_subject_to_guideline, p_standard_volume_gas, p_standard_volume_liquid, p_transient_density_liquid, p_transient_density_vapor, p_transient_energy, p_transient_mass, p_transient_pressure, p_transient_temperature, subject_of_contract
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:23:45 2001
© Copyright 2001 POSC. All rights reserved.