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

Syndicated Loading Definitions


Table 95 provides terms and definitions related to syndicated loading.

Table 95. Syndicated Loading Definitions
Term
Definition

Syndicated data

Third-party data from vendors that shows sales and prescription results for client defined markets.

Brick

Micro sales geographic area defined by vendor that contains prescription and sales trends for clients' product groupings or markets. Bricks do not exist in the US where the micro sales geographic area is commonly the postal code or zip code.

NRx

Abbreviation of new prescriptions. A new prescription is defined as dispensed prescriptions given a new number by the pharmacy, not necessarily new therapy for the patient.

TRx

Abbreviation of total prescriptions. TRx = NRx + Refills. After the first time a prescription is filled, when it is refilled, the pharmacy refers back to the previous drug ID number and notes this as a refill.

Indirect sales

Total drug wholesalers product sales values to drug retailers (pharmacies) by brick or zip code. Sales values are calculated as units multiplied by client-selected price, where the price is the warehouse acquisition cost unless the client has chosen to have a different price applied to its direct sales or government depot sales.

Indirect units

Total drug wholesalers product sales units to drug retailers (pharmacies) by brick or zip code. Sales unit quantity is determined by multiplying package factor to obtain unit value (for example, one carton x 24 bottles = 24 units).

Siebel Business Analytics Applications Installation and Administration Guide