Siebel Life Sciences Guide > Importing Data into Life Sciences > Extracting Data for Mobile Users >

Specifying the Data to Route to Mobile Users

Use the following procedure to specify the data that is routed to mobile users.

This task is a step in Process of Analysis.

To specify the data that is routed to mobile users

1. Navigate to the Administration - Syndicated Data screen, then the Export Rules view.
2. In the Rules list, select the correct rule.
3. Click the Tables tab.
4. In the Tables list, create a new record and complete the necessary fields.

   Some fields are described in the following table.

   Field	Comments
   Table Name	Generally, this value should be S_SYND_DATA. The exception to this general rule is if you have created an extension table or if you are using another table to store syndicated data.
   Where String	Enter a string that defines the data to be extracted. Generally, these strings use standard SQL WHERE statements to build the extraction scripts. In addition to using static column values and column names to specify the data to be extracted, you can use two case-sensitive variables, [Position Id] and [Employee Id]. An example WHERE string definition that uses the Position Id variable is provided below. This example extracts data where the position ID in the syndicated data is equal to the position ID of the user. For example: WHERE T.POSITION_ID = [Position Id] A second example, provided below, extracts data for all positions assigned to an employee. Note that <TableOwner> in the example should be replaced with the appropriate Siebel database TableOwner value. For example: WHERE EXISTS (SELECT 1 FROM <TableOwner>.S_PARTY_PER R WHERE R.PARTY_ID = T.POSITION_ID AND R.PERSON_ID = [Employee Id])
   Sequence	Enter a numeric value that defines the order in which tables will be extracted.
   Active	Only tables specified as active will be processed.

5. Click the SQL Statements tab, then click the Pre SQL Statements tab.
6. In the Pre SQL Statements list, create a new record and compete the necessary fields.

   Some fields are described in the following table.

   Field	Comments
   SQL Text	This SQL statement cleans up the data in the remote database in preparation for importing newer data, by deleting the existing data that will be replaced by newer data. If the entire syndicated data table is to be extracted, use the DELETE FROM table function. If only a subset of the data is to be extracted (for example, the latest month's data), use a where clause to specify the data subset. NOTE:  Each SQL statement must be prefixed with the table owner SIEBEL. If you do not include the table owner, the syndicated data import process fails.
   Comments	Optional description of statement's purpose; for example, describe the portion of the data you want to extract.
   Sequence	Enter a numeric value that defines the order in which SQL statements will be executed.
   Active	Only statements specified as active will be processed.

   You can refresh the entire syndicated data table, or you can refresh only certain specified data periods.

   NOTE:  Do not use the TRUNCATE function. Use the DELETE FROM function instead.