POZ_EXT_DATA_PROVIDERS

This table stores information about data providers supported to search and enrich supplier data. It includes details such as the primary provider, provider status and other relevant information about data providers.

Details

• Schema: FUSION

• Object owner: POZ

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
POZ_EXT_DATA_PROVIDERS_PK	EXT_DATA_PROVIDER_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EXT_DATA_PROVIDER_ID	NUMBER		18	Yes	Unique identifier for a data provider.
EXT_DATA_PROVIDER_CODE	VARCHAR2	255		Yes	Unique code representing the data provider
EXT_DATA_PROVIDER_NAME	VARCHAR2	4000		Yes	Name of the data provider.
PRIMARY_FLAG	VARCHAR2	1		Yes	Flag indicating if this provider is the primary provider.
ENABLED_FLAG	VARCHAR2	1		Yes	Flag indicating if this provider is currently enabled.
SEARCH_API_URL	VARCHAR2	4000		Yes	Stores the url of the search API provided by the external data provider.
COMPANY_NAME_PROVIDER_ATTR	VARCHAR2	4000		Yes	Field from the provider's response data representing company's name.
PROVIDER_ATTRIBUTE1	VARCHAR2	4000			Placeholder 1 for storing data from the provider's response field that users would like to display in search results.
PROVIDER_ATTRIBUTE2	VARCHAR2	4000			Placeholder 2 for storing data from the provider's response field that users would like to display in search results
PROVIDER_ATTRIBUTE3	VARCHAR2	4000			Placeholder 3 for storing data from the provider's response field that users would like to display in search results
PROVIDER_ATTRIBUTE4	VARCHAR2	4000			Placeholder 4 for storing data from the provider's response field that users would like to display in search results
PROVIDER_ATTRIBUTE5	VARCHAR2	4000			Placeholder 5 for storing data from the provider's response field that users would like to display in search results
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index	Uniqueness	Tablespace	Columns
POZ_EXT_DATA_PROVIDERS_U1	Unique	FUSION_TS_TX_DATA	EXT_DATA_PROVIDER_ID