reference_behavior.source
The provider of this instance of reference information. If this instance is provided by POSC, then this attribute must be "POSC".
Defines a foreign key to table r_source.
ref_code_alias.standard_code
Defines the standard code for which this code is an alias. standard_code_s: Implements a foreign key to a row in one of the tables projected from entity ref_code depending on the value of the next column (See below). standard_code_t: Defines the name of the referenced table. Possible values are defined in @ref_code.
ref_code_alias.end_time
The end time for when the alias applied.
start_time (O: TIMESTAMP)
ref_code_alias.start_time
The start time for when the alias applied.
status (O: CHAR VARYING(11))
reference_behavior.status
The status of this instance in the version of Epicentre running in a data store. This is an enumerated datatype for which the following are the possible values: current, provisional, deprecated. Current - use without restriction. Provisional - use with caution, this value is for comment and may not appear in future releases of Epicentre. Deprecated - avoid use if possible, it is planned to remove this value in the next major release of Epicentre.
r_naming_system_kd (FNK, O: CHAR VARYING(40))
ref_code_alias.ref_naming_system
Specifies the name space within which this code alias is defined and is unique.
Defines a foreign key to table r_naming_system.
source_reference_s (FSK, O: CHAR VARYING(19))
reference_behavior.source_reference
The reference used by source to provide the standard instance, such as Petroleum Industry Data Dictionary (PIDD), Websters Ninth New Collegiate Dictionary, etc.
Defines a foreign key to table r_source_ref.
version (FNK, O: CHAR VARYING(40))
reference_behavior.version
Describes the version of Epicentre when this status was assigned to this instance of reference behavior
Defines a foreign key to table r_epcnt_version.