Country Dimension - Table VAL.V_COUNTRIES Specification

• Name: v_countries
• Description: Names of countries and their various codes as defined by the ISO.
• Columns:
• Name: name
  
• Description: Full name of the country.
• Datatype: VARCHAR2(100)
• Null: No
  
• Unique: No
  
• Part of PK: Yes
  
• Name: iso2_code
• Description: 2 character ISO code.
• Datatype: VARCHAR2(2)
• Null: No
  
• Unique: No
  
• Part of PK: Yes
  
• Name: iso3_code
• Description: 3 character ISO code.
• Datatype: VARCHAR2(3)
• Null: No
  
• Unique: No
  
• Part of PK: Yes
  
• Name: un3_number
• Description: 3 digit numeric UN code.
• Datatype: VARCHAR2(3)
• Null: No
  
• Unique: No
  
• Part of PK: Yes
  
• 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