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

Data Source Values for Syndicated Data Attributes


Table 36 indicates, by data source, the data values that should be loaded into the syndicated data table (S_SYND_DATA) attribute fields.

NOTE:  Analytics Codes are used in the Life Sciences logical model to identify the syndicated data sources.

Table 36.  S_SYND_DATA Attribute by Data Source
Data Source
Description
Analytics Codes
Attribute 1
Attribute 2
Attribute 3
Attribute 4
RXPrf
Prescription data by Contact
1
NRx
TRx
Market NRx
Market TRx
SlsIndBrk
Indirect Sales Brick Level
22
Product Sales $
Product Sales Units
Market Sales $
Market Sales Units
SlsIndAct
Indirect Sales Account Level
21
Product Sales $
Product Sales Units
Market Sales $
Market Sales Units
SlsIndZip
Indirect Sales Zip Level
23
Product Sales $
Product Sales Units
Market Sales $
Market Sales Units
SlsDirAct
Direct Sales Account Level
11
Product Sales $
Product Sales Units
 
 
SlsDirBrk
Direct Sales Brick Level
12
Product Sales $
Product Sales Units
 
 
SlsDirZip
Direct Sales Zip Level
13
Product Sales $
Product Sales Units
 
 
RXEVM
Weekly RX Data
0
Product NRx
Product TRx
Market NRx
Market TRx
RXPT
Plan Level Rx Data
6
Product NRx
Product TRx
Market NRx
Market TRx
RXSMI
Sales Market - Incentives
3
Product NRx
Product TRx
Market NRx
Market TRx
RXSMM
Sales Market - Modified
4
Product NRx
Product TRx
Market NRx
Market TRx
RXXPT
Plan Level Physician Rx Data
5
Product NRx
Product TRx
Market NRx
Market TRx
RXZip
Prescription data by ZIP Code
7
Product NRx
Product TRx
Market NRx
Market TRx
RXBrk
Prescription data by Brick
8
Product NRx
Product TRx
Market NRx
Market TRx

The following issues are specific to Analytics for Life Sciences and do not affect other products.


 Siebel Data Warehouse Installation and Administration Guide
 Published: 11 March 2004