A unit of money. A unit may be a subunit of another unit such as US Cent being a subunit of US Dollar and may have units such as US Dollar has a subunit of US Cent.

r_currency_unit_s (PK, M: CHAR VARYING(19))

Surrogate key of the table.


acronym (M: CHAR VARYING(15))

ref_currency_unit.acronym
A short symbolic identifier for a currency type. For example: $, F, Nk.


r_currency_unit_nm (M: CHAR VARYING(40))

ref_currency_unit.name
The name of the currency unit. The name should include a reference to the country. For example, US Dollar.


source (FNK, M: CHAR VARYING(40))

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.


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.


sub_unit_per_unit (O: INTEGER)

ref_currency_unit.sub_unit_per_unit
The number of sub units that are equivalent to the unit. This is undefined (null) if there is no sub unit defined.


smaller_unit (FNK, O: CHAR VARYING(15))

ref_currency_unit.smaller_unit
This defines the smaller currency unit which evenly divides into this unit.
Defines a foreign key to table r_currency_unit.


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.