Siebel Data Warehouse Installation and Administration Guide > Administering and Troubleshooting the Siebel Data Warehouse > Importing Syndicated Data Into the Siebel Data Warehouse >
Data Source Values for Syndicated Data Attributes
Table 11 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 11. 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
|