Siebel Life Sciences Guide > Importing Data > Administrator Procedures >
Data Loading Matrix for Syndicated Data
The Data Loading Matrix, shown in Table 23, and the Attribute by Data Source Matrix, shown in Table 24, are provided to facilitate loading sales, Rx, profitability, and influence data. Table 9-4 indicates, by view, the combination of data source, mandatory ID, and plan type values a record must have to be displayed in the view. The following list explains the table headings:
- View. Name of the Analysis, Contacts, Accounts, or Products view.
- Data Source. Value that determines which view will display the data stored in the record. The valid values are SlsDirAct, SlsDirBrk, SlsDirTer, SlsDirZip, SlsIndAct, SlsIndBrk, SlsIndTer, SlsIndZip, RSPT, RXBrk, RXEVM, RXSMI, RSXMM, RXPrf, RXTer, RXXPT, RXZip, Anlsys ROI, and Anlsys EvsR.
- Mandatory Id. Value that indicates the ID field that must be non-NULL for a database record to be displayed in the corresponding view. There are four key ID fields: Account Id, Contact Id, Territory Id, and Zip Id. For each view listed in the table, one of these ID fields is required and the other three must be NULL.
- Plan Type. Value that indicates the type of plan ID a database record must have to be displayed in the view.
Table 23. Data Loading Matrix
View
|
Data Source
|
Mandatory ID
|
Plan Type
|
Accounts > Charts > Sales
|
SlsIndAct
|
Account Id
|
Total
|
Accounts > Charts > Profitability
|
Anlsys ROI
|
Account Id
|
Total
|
Analysis > Direct Sales Trend > by Territory - Volume
|
SlsDirTer
|
Territory Id
|
Total
|
Analysis > Direct Sales Trend > by Account - Volume
|
SlsDirAct
|
Account Id
|
Total
|
Analysis > Indirect Sales Trend > by Territory - Volume
|
SlsIndTer
|
Territory Id
|
Total
|
Analysis > Indirect Sales Trend > by Territory - Share
|
SlsIndTer
|
Territory Id
|
Total
|
Analysis > Indirect Sales Trend > by Zip - Volume
|
SlsIndZip
|
Zip Id
|
Total
|
Analysis > Indirect Sales Trend > by Zip - Share
|
SlsIndZip
|
Zip Id
|
Total
|
Analysis > Indirect Sales Trend > by Brick - Volume
|
S1sIndBrk
|
Area Id
|
Total
|
Analysis > Indirect Sales Trend > by Brick - Share
|
S1sIndBrk
|
Area Id
|
Total
|
Analysis > Indirect Sales Trend > by Account - Volume
|
SlsIndAct
|
Account Id
|
Total
|
Analysis > Indirect Sales Trend > by Account - Share
|
SlsIndAct
|
Account Id
|
Total
|
Analysis > Rx Trend > by Territory - Volume
|
RXTer
|
Territory Id
|
Total
|
Analysis > Rx Trend > by Territory - Share
|
RXTer
|
Territory Id
|
Total
|
Analysis > Rx Trend > by Prescriber - Volume
|
RXPrf
|
Contact Id
|
Total
|
Analysis > Rx Trend > by Prescriber - Share
|
RXPrf
|
Contact Id
|
Total
|
Analysis > Rx Trend > by Plan and Territory - Volume
|
RXTer
|
Territory Id
|
Plan
|
Analysis > Rx Trend > by Plan and Territory - Share
|
RXTer
|
Territory Id
|
Plan
|
Analysis > Rx Trend > by Plan and Prescriber - Volume
|
RXPrf
|
Contact Id
|
Plan
|
Analysis > Rx Trend > by Plan and Prescriber - Share
|
RXPrf
|
Contact Id
|
Plan
|
Analysis > Rx Trend > by Payment Type and Prescriber
|
RXPrf
|
Contact Id
|
Payer
|
Analysis > Rx Trend > by Payment Type and Territory
|
RXTer
|
Territory Id
|
Payer
|
Contacts > Rx Trend > Rx Trend by Product*
|
RXPrf
|
Contact Id
|
Total
|
Contacts > Profitability
|
Anlsys ROI
|
Contact Id
|
Total
|
Contacts > Sample Influence
|
Anlsys EvsR
|
Contact Id
|
Total
|
Products > Product Profitability > Sample ROI*
|
Anlsys ROI
|
Territory Id
|
Total
|
Products > Sample Influence
|
Anlsys EvsR
|
Territory Id
|
Total
|
|
|
|
|
|
Table 24 indicates, by data source, the data values that should be loaded into the syndicated data table (S_SYND_DATA) attribute fields.
Table 24. S_SYND_DATA Attribute by Data Source
Data Source
|
Attribute 1
|
Attribute 2
|
Attribute 3
|
Attribute 4
|
Attribute 5
|
Anlsys EvsR
|
TRx
|
Number of Calls
|
Number of Samples
|
Number of Details
|
|
Anlsys ROI
|
Revenue
|
Samples Cost
|
Promotion Cost
|
Call Expenses
|
Other Expenses
|
RSPT
|
Product NRx
|
Product TRx
|
Market NRx
|
Market TRx
|
|
RXBrk
|
Product NRx
|
Product TRx
|
Market NRx
|
Market TRx
|
|
RXEVM
|
Product NRx
|
Product TRx
|
Market NRx
|
Market TRx
|
|
RXPrf
|
Product NRx
|
Product TRx
|
Market NRx
|
Market TRx
|
|
RXSMI
|
Product NRx
|
Product TRx
|
Market NRx
|
Market TRx
|
|
RXSMM
|
Product NRx
|
Product TRx
|
Market NRx
|
Market TRx
|
|
RXTer
|
Product NRx
|
Product TRx
|
Market NRx
|
Market TRx
|
|
RXXPT
|
Product NRx
|
Product TRx
|
Market NRx
|
Market TRx
|
|
RXZip
|
Product NRx
|
Product TRx
|
Market NRx
|
Market TRx
|
|
SlsDirAct
|
Product Sales $
|
Product Sales Units
|
|
|
|
SlsDirBrk
|
Product Sales $
|
Product Sales Units
|
|
|
|
SlsDirTer
|
Product Sales $
|
Product Sales Units
|
|
|
|
SlsDirZip
|
Product Sales $
|
Product Sales Units
|
|
|
|
SlsIndAct
|
Product Sales $
|
Product Sales Units
|
Market Sales $
|
Market Sales Units
|
|
SlsIndBrk
|
Product Sales $
|
Product Sales Units
|
Market Sales
|
Market Sales Units
|
|
SlsIndTer
|
Product Sales $
|
Product Sales Units
|
Market Sales $
|
Market Sales Units
|
|
SlsIndZip
|
Product Sales $
|
Product Sales Units
|
Market Sales $
|
Market Sales Units
|
|
