Table 128. Data Types Supported in Oracle Business Analytics Warehouse
|
|
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 Oracle Business Analytics Warehouse. |
Sales market |
Modified. Monthly incentive compensation data sourced from internal incentive compensation systems and loaded as a new data type in the Oracle Business Analytics 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. |