Siebel Business Analytics Applications Installation and Administration Guide > Siebel Data Warehouse for Life Sciences Data Considerations > Importing Syndicated Data into Siebel Data Warehouse >

Data Types Supported in the Siebel Data Warehouse


The Siebel Data Warehouse supports multiple data types defined by data source type and periodicity, as described in Table 96.

Table 96. Data Types Supported in Siebel Data Warehouse
Data Type
Description

Prescription data by contact

Monthly NRx and TRx data for client defined markets that include competitor products data by physician.

Indirect sales brick level

Monthly wholesaler sales and unit values data for client defined markets that include competitor products aggregated by brick.

Indirect sales account level

Monthly wholesaler sales and unit values for company products by pharmacy.

Indirect sales zip level

Monthly wholesaler sales and unit values for client defined markets that include competitor products aggregated by postal code.

Direct sales account level

Monthly direct factory sales data and unit values to wholesalers for company's products by wholesaler.

Direct sales brick level

Monthly direct factory sales data and unit values to wholesalers for company's products by brick.

Direct sales zip level

Monthly direct factory sales data and unit values to wholesalers for company's products by postal code.

Weekly prescription data

Weekly NRx and TRx data for client defined markets that include competitor products by physician.

Plan level prescription data

Monthly prescription data by managed care plan for client defined markets that includes competitor products.

Sales market

Incentives. Monthly incentive compensation data sourced from internal incentive compensation systems and loaded as a new data type in the Siebel Data Warehouse.

Sales market

Modified. Monthly incentive compensation data sourced from internal incentive compensation systems and loaded as a new data type in the Siebel Data Warehouse.

Physician plan level Rx data

Monthly prescription data for physicians associated with a managed care plan.

Prescription data by zip code

Monthly prescription data for client defined markets that includes competitor products aggregated by postal code.

Prescription data by brick

Monthly prescription data for client defined markets that include competitor products aggregated by brick.

Siebel Business Analytics Applications Installation and Administration Guide