MSC_REGIONS

Details

Schema: FUSION
Object owner: MSC
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
MSC_REGIONS_PK	REGION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
REGION_ID	NUMBER		18	Yes	Region/Zone identifier that is mapped to the location.	Active
REGION_NAME	VARCHAR2	360		Yes	Region Name or Zone Name of the geography record.	Active
REGION_TYPE	VARCHAR2	30			Region Type will tell level of the region like zipcode, city, etc.	Active
REGION_LEVEL	NUMBER		2		Number Indicating the level in the hierarchy of region. aka REGION_TYPE in EBS. Null for Zones	Active
COUNTRY_CODE	VARCHAR2	2			Country Code. This will be level 1 region.	Active
REGION_ZONE_FLAG	VARCHAR2	1		Yes	A flag that specifies if the record is a region or zone. R ??? region, Z ??? zone	Active
PARENT_REGION_TYPE_1	VARCHAR2	30			Region Type of the parent region name 1 in the hierarchy.	Active
PARENT_REGION_TYPE_2	VARCHAR2	30			Region Type of the parent region name 2 in the hierarchy.	Active
PARENT_REGION_TYPE_3	VARCHAR2	30			Region Type of the parent region name 3 in the hierarchy.	Active
PARENT_REGION_TYPE_4	VARCHAR2	30			Region Type of the parent region name 4 in the hierarchy.	Active
PARENT_REGION_TYPE_5	VARCHAR2	30			Region Type of the parent region name 5 in the hierarchy.	Active
PARENT_REGION_TYPE_6	VARCHAR2	30			Region Type of the parent region name 6 in the hierarchy.	Active
PARENT_REGION_TYPE_7	VARCHAR2	30			Region Type of the parent region name 7 in the hierarchy.	Active
PARENT_REGION_TYPE_8	VARCHAR2	30			Region Type of the parent region name 8 in the hierarchy.	Active
PARENT_REGION_NAME_1	VARCHAR2	360			Name of the parent region in the hierarchy. Represents Level 2 region.	Active
PARENT_REGION_NAME_2	VARCHAR2	360			Name of the parent region in the hierarchy. Represents Level 3 region.	Active
PARENT_REGION_NAME_3	VARCHAR2	360			Name of the parent region in the hierarchy. Represents Level 4 region.	Active
PARENT_REGION_NAME_4	VARCHAR2	360			Name of the parent region in the hierarchy. Represents Level 5 region.	Active
PARENT_REGION_NAME_5	VARCHAR2	360			Name of the parent region in the hierarchy. Represents Level 6 region.	Active
PARENT_REGION_NAME_6	VARCHAR2	360			Name of the parent region in the hierarchy. Represents Level 7 region.	Active
PARENT_REGION_NAME_7	VARCHAR2	360			Name of the parent region in the hierarchy. Represents Level 8 region.	Active
PARENT_REGION_NAME_8	VARCHAR2	360			Name of the parent region in the hierarchy. Represents Level 9 region.	Active
PARENT_REGION_NAME_LIST	VARCHAR2	3700			For regions rows: comma separated string of country code and all parent (ancestor) region names of this region; NULL for zones rows;	Active
IMMEDIATE_PARENT_REGION_ID	NUMBER		18		Destination region Id of the immediate parent. For a level n region, the region if of level n-1 parent region id will be stored.
REFRESH_NUMBER	NUMBER		18		Refresh Number is the Cycle id of collections	Active
DELETED_FLAG	NUMBER		1		Flag that indicates the logical deletion of the region 1 ??? Yes (deleted), 2 ??? No (Not deleted)	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
msc_region_locations	msc_regions	REGION_ID
msc_locations	msc_regions	REGION_ID
msc_zone_regions	msc_regions	PARENT_ZONE_ID
msc_zone_regions	msc_regions	CHILD_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_REGIONS_U1	Unique	Default	REGION_ID
MSC_REGIONS_U2	Unique	Default	REGION_ZONE_FLAG, REGION_NAME, PARENT_REGION_NAME_LIST