Interface Tables:
WSH_REGIONS_INTERFACE
WSH_REGIONS_TL_INTERFACE
Base Tables:
WSH_REGIONS
WSH_REGIONS_TL
Create Country:
Insert the following data into Interface tables
Generate Sequence_ID and use the same for both the INTERFACE tables.
Region_Type=0
Country and Country_Code should be NOT NULL.
Other values like state, city, parent_region_id should be NULL
Run ‘Region Interface’ import program to create
COUNTRY records.
Create State:
Insert the following data into Interface tables
Generate Sequence_ID and use the same for both the INTERFACE tables.
Region_Type=1
Country, Country_Code, State, State_Code should be NOT NULL.
Parent_Region_ID should be the region_id of the corresponding COUNTRY
record.
Other values like city, Postal_Code_From, Postal_Code_To should be NULL
Run ‘Region Interface’ import program to create STATE
records.
Create City:
Insert the following data into Interface tables
Generate Sequence_ID and use the same for both the INTERFACE tables.
Region_Type=2
Country, Country_Code, State, State_Code, City_City_Code should be NOT
NULL.
Parent_Region_ID should be the region_id of the corresponding STATE
record.
Other values like area, Postal_Code_From, Postal_Code_To should be NULL
Run ‘Region Interface’ import program to create CITY
records
Create Area/ Pincode:
Insert the following data into Interface tables
Generate Sequence_ID and use the same for both the INTERFACE tables.
Region_Type=3
Country , Country_Code, State, State_Code, City_City_Code, Area,
Postal_Code_From, Postal_Code_To should be NOT NULL.
Run ‘Region Interface’ import program to create Area/
Pincode records.
