Data Loading Matrix for Syndicated Data
The Data Loading Matrix, shown in the first table in this topic and the Attribute by Data Source Matrix, shown in the second table in this topic, are provided to facilitate loading sales, Rx, profitability, and influence data. The first table 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.
| View | Data Source | Mandatory ID | Plan Type |
|---|---|---|---|
|
Accounts screen, Charts, and then the Sales view |
SlsIndAct |
Account Id |
Total |
|
Accounts, screen, Charts, then the Profitability view |
Anlsys ROI |
Account Id |
Total |
|
Analysis screen, Direct Sales Trend, and then the by Territory - Volume view |
SlsDirTer |
Territory Id |
Total |
|
Analysis screen, Direct Sales Trend, then by Account - Volume view |
SlsDirAct |
Account Id |
Total |
|
Analysis screen, Indirect Sales Trend, then by Territory - Volume view |
SlsIndTer |
Territory Id |
Total |
|
Analysis screen, Indirect Sales Trend, then by Territory - Share view |
SlsIndTer |
Territory Id |
Total |
|
Analysis screen, Indirect Sales Trend, then by Zip - Volume view |
SlsIndZip |
Zip Id |
Total |
|
Analysis screen, Indirect Sales Trend, then by Zip - Share view |
SlsIndZip |
Zip Id |
Total |
|
Analysis screen, Indirect Sales Trend, then by Brick - Volume view |
S1sIndBrk |
Area Id |
Total |
|
Analysis screen, Indirect Sales Trend, then by Brick - Share view |
S1sIndBrk |
Area Id |
Total |
|
Analysis screen, Indirect Sales Trend, then by Account - Volume view |
SlsIndAct |
Account Id |
Total |
|
Analysis screen, Indirect Sales Trend, then by Account - Share view |
SlsIndAct |
Account Id |
Total |
|
Analysis screen, Rx Trend, then by Territory - Volume view |
RXTer |
Territory Id |
Total |
|
Analysis screen, Rx Trend, then by Territory - Share view |
RXTer |
Territory Id |
Total |
|
Analysis screen, Rx Trend, then by Prescriber - Volume view |
RXPrf |
Contact Id |
Total |
|
Analysis screen, Rx Trend, then by Prescriber - Share view |
RXPrf |
Contact Id |
Total |
|
Analysis screen, Rx Trend, then by Plan and Territory - Volume view |
RXTer |
Territory Id |
Plan |
|
Analysis screen, Rx Trend, then by Plan and Territory - Share view |
RXTer |
Territory Id |
Plan |
|
Analysis screen, Rx Trend, then by Plan and Prescriber - Volume view |
RXPrf |
Contact Id |
Plan |
|
Analysis screen, Rx Trend, then by Plan and Prescriber - Share view |
RXPrf |
Contact Id |
Plan |
|
Analysis screen, Rx Trend, then by Payment Type and Prescriber view |
RXPrf |
Contact Id |
Payer |
|
Analysis screen, Rx Trend, then by Payment Type and Territory view |
RXTer |
Territory Id |
Payer |
|
Contacts screen, Rx Trend, then the Rx Trend by Product* |
RXPrf |
Contact Id |
Total |
|
Contacts screen, then the Profitability view |
Anlsys ROI |
Contact Id |
Total |
|
Contacts screen, then the Sample Influence view |
Anlsys EvsR |
Contact Id |
Total |
|
Products screen, Product Profitability, then Sample ROI* |
Anlsys ROI |
Territory Id |
Total |
|
Products screen, then the Sample Influence view |
Anlsys EvsR |
Territory Id |
Total |
|
* Fourth level menu |
The following table indicates, by data source, the data values that should be loaded into the syndicated data table (S_SYND_DATA) attribute fields.
| 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 |