MSC_LOCATIONS

Details

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

Primary Key

Name	Columns
MSC_LOCATIONS_PK	LOCATION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
LOCATION_ID	NUMBER		18	Yes	Location id generated on destination side
SR_LOCATION_ID	NUMBER				Source side value of the location identifier.
LOCATION_TYPE	VARCHAR2	1			Identifies if the location is internal or external.
REGION_ID	NUMBER		18		Region identifier that is mapped to the location.
SR_INSTANCE_ID	NUMBER		18	Yes	Identifier of the source system from where the data is collected.
LOCATION_CODE	VARCHAR2	240		Yes	Unique identifier for Location for a given source instance.
DESCRIPTION	VARCHAR2	2000			Description of the associated location
ADDRESS1	VARCHAR2	240			First line of the Identifying address
ADDRESS2	VARCHAR2	240			Second line of the Identifying address
ADDRESS3	VARCHAR2	240			Third line of the identifying address
ADDRESS4	VARCHAR2	240			Fourth line of the Identifying address
FLOOR_NUMBER	VARCHAR2	40			This is the floor number part of the address.
BUILDING	VARCHAR2	240			Specific building name or number at a given address
CITY	VARCHAR2	60			City of the Identifying address
STATE	VARCHAR2	60			State name of the customer/supplier site location address.
PROVINCE	VARCHAR2	60			Province part of the customer/supplier site location address.
COUNTY	VARCHAR2	60			County where this address belongs.
POSTAL_CODE	VARCHAR2	60			Postal code part of the customer/supplier site location address.
COUNTRY_CODE	VARCHAR2	2		Yes	Country where this address belongs.
ADDRESS_EFFECTIVE_DATE	DATE				Date when the location is valid
ADDRESS_EXPIRATION_DATE	DATE				Date when the location is no longer valid
REFRESH_NUMBER	NUMBER		18		Refresh Number is the Cycle id of collections
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
LOCATION_NAME	VARCHAR2	240			Stores the concatenation of Location Name and Alternate Location Code
SR_LOCATION_CODE	VARCHAR2	150			Stores the name of the location

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_LOCATIONS	msc_regions	REGION_ID
msc_location_associations	msc_locations	LOCATION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_LOCATIONS_U1	Unique	Default	LOCATION_ID
MSC_LOCATIONS_U2	Unique	Default	SR_INSTANCE_ID, LOCATION_TYPE, LOCATION_CODE