Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide > Siebel Data Warehouse for Life Sciences Data Considerations > Importing Syndicated Data into Siebel Data Warehouse >
Siebel Analytics Data Loading Matrix for Syndicated Data
The Data Loading Matrix, shown in Table 35, and the Attribute by Data Source Matrix, shown in Table 36, are provided to facilitate loading sales and Rx data. The following list explains the table headings:
- Screen. Name of the Siebel Analytics screen.
- View. Name of the Siebel Analytics view.
- Data Source. Value that determines which view displays the data stored in the record. The valid values are RXPrf, SlsIndBrk, SlsIndAct, SlsIndZip, SlsDirAct, SlsDirBrk, SlsDirZip, RXEVM, RXPT, RXSMI, RXSMM, RXXPT, RXZip, and RXBrk.
- 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.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 11 March 2004 |