Country Dimension - Table D_COUNTRY Specification

• Name: D_COUNTRY
• Description: The Country Dimension contains the names of countries and their various codes as defined by the ISO.
• Columns:
• Name: ID
• Description: UID of the row.
  
• Datatype: NUMBER
• Null: No
  
• Unique: Yes
  
• Part of PK: Yes
  
• Name: NAME
• Description: Full name of the country.
• Datatype: VARCHAR2(100)
• Null: No
  
• Unique: No
  
• Part of PK: No
• Name: ISO2_CODE
• Description: 2 character ISO code.
• Datatype: VARCHAR2(2)
• Null: No
  
• Unique: No
  
• Part of PK: No
• Name: ISO3_CODE
• Description: 3 character ISO code.
• Datatype: VARCHAR2(3)
• Null: No
  
• Unique: No
  
• Part of PK: No
• Name: UN3_NUMBER
• Description: 3 digit numeric UN code.
• Datatype: VARCHAR2(3)
• Null: No
  
• Unique: No
  
• Part of PK: No
• Name: START_DATE
• Description: Date that the Country came into being.
• Datatype: DATE
• Null: No
  
• Unique: No
  
• Part of PK: No
• Name: END_DATE
• Description: Date that the Country ceased.
• Datatype: DATE
• Null: No
  
• Unique: No
  
• Part of PK: No
• Name: RUN_NO
• Description: The Run Number that created this row.
• Datatype: NUMBER
• Null: No
  
• Unique: No
  
• Part of PK: No
• Name: INS_TSP
• Description: Insert timestamp.
• Datatype: DATE
• Null: No
  
• Unique: No
  
• Part of PK: No