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 63 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 63. S_SYND_DATA Attribute by Data Source
|
|
|
|
|
|
|
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.
|