A standard code or abbreviation for an item of reference information.

end_time (O, K: ndt_date_tod)

The end time for when the alias applied.


start_time (O, K: ndt_date_tod)

The start time for when the alias applied.


source (M, K, I: ref_source)

The provider of this instance of reference information. If this instance is provided by POSC, then this attribute must be "POSC". Each ref_code_alias must provided by one ref_source. Inherited from reference_behavior.


standard_code (M, K: ref_code(code_alias))

Defines the standard code for which this code is an alias. Each ref_code_alias must for one ref_code.


identifier (M: ndt_name)

The alias code.


description (O: ndt_comment)

A remark about the alias.


status (O, I: ndt_instance_status) (0644)

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. Inherited from reference_behavior.


ref_naming_system (O: ref_naming_system)

Specifies the name space within which this code alias is defined and is unique. Each ref_code_alias may defined within one ref_naming_system.


source_reference (O, I: ref_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. Each ref_code_alias may documented by one ref_source_reference. Inherited from reference_behavior.


version (O, I: ref_epicentre_version) (0644)

Describes the version of Epicentre when this status was assigned to this instance of reference behavior Each ref_code_alias may version one ref_epicentre_version. Inherited from reference_behavior.

Local rules:

Uniqueness Constraint (0749)
end_time, start_time, source, standard_code
Supertype path(s):
reference_behavior > ref_code_alias.
ref_data > ref_code_alias.

Entity projects as table R_CODE_ALIAS.

Referenced in Diagrams:

• HL1: High Level Model (0644)