Country Dimension - S_COUNTRIES

• Name: s_countries
• Description: Staging Country table. This contains data newly extracted from the source web page.
  
• Columns:
• Name: run_no
  
• Description: The run number of the mapping that created the data set.
  
• Datatype: NUMBER
  
• Null: No
  
• Unique: No
  
• Part of PK: Yes
  
• Name: data_seq
  
• Description: Sequence of the data within the run number. Starts at 1 for each new data set.
  
• Datatype: NUMBER
  
• Null: No
  
• Unique: No
  
• Part of PK: Yes
• Name: name
  
• Description: Name of the country.
  
• Datatype: VARCHAR2(4000)
  
• Null: Yes
  
• Unique: No
  
• Part of PK: No
  
• Name: iso2_code
  
• Description: 2 character ISO Country code.
  
• Datatype: VARCHAR2(4000)
  
• Null: Yes
  
• Unique: No
  
• Part of PK: No
  
• Name: iso3_code
  
• Description: 3 character ISO Country code.
  
• Datatype: VARCHAR2(4000)
  
• Null: Yes
  
• Unique: No
  
• Part of PK: No
  
• Name: un3_code
  
• Description: 3 character UN Country code.
  
• Datatype: VARCHAR2(4000)
  
• Null: Yes
  
• Unique: No
  
• Part of PK: No
  
• Name: windows_country_region
  
• Description: Windows country region.
  
• Datatype: VARCHAR2(4000)
  
• Null: Yes
  
• Unique: No
  
• Part of PK: No
  
• Name: windows_code
  
• Description: Windows code.
  
• Datatype: VARCHAR2(4000)
  
• Null: Yes
  
• Unique: No
  
• Part of PK: No
  
• Name: mac_name
  
• Description: Mac name.
  
• Datatype: VARCHAR2(4000)
  
• Null: Yes
  
• Unique: No
  
• Part of PK: No
  
• Name: mac_code
  
• Description: Mac code.
  
• Datatype: VARCHAR2(4000)
  
• Null: Yes
  
• Unique: No
  
• Part of PK: No
  
• Name: ins_tsp
  
• Description: Insert timestamp.
  
• Datatype: DATE
  
• Null: No
  
• Unique: No
  
• Part of PK: No