Country Dimension - Definition

Table:

Table	Description
D_COUNTRY	The Country Dimension contains the names of countries and their various codes as defined by the ISO.

Levels:

Level	Prefix	Description
ISO_COU	COU	The ISO Country.

Level Attributes:

Country Level:

Attribute	Datatype	Description
ID	NUMBER	UID of the row.
NAME	VARCHAR2(100)	Full name of the country.
ISO2_CODE	VARCHAR2(2)	2 character ISO code.
ISO3_CODE	VARCHAR2(3)	3 character ISO code.
UN3_NUMBER	VARCHAR2(3)	3 digit numeric UN code.
START_DATE	DATE	Date that the Country came into being.
END_DATE	DATE	Date that the Country ceased.

OTHER :

These are audit and control attributes. While not strictly belonging to a Level, they are assigned to the most granular level - in this case; ISO_COU:

Attribute	Datatype	Description
RUN_NO	NUMBER	The Run Number that created this row.
INS_TSP	DATE	Insert timestamp.