Siebel Life Sciences Guide > Configuring Siebel Life Sciences >

Charting Denormalized Syndicated Data


Siebel Life Sciences allows you to chart denormalized syndicated data. To take advantage of this enhancement, configuration is required at the business component, table, and applet levels.

Schema for Territory Data Files

The territory data files created by your syndicated data provider must have the following characteristics:

  • They must be plain ASCII files.
  • They must follow the schema described in Table 52.
Table 52.  Territory File Schema
Field
Type
Length

Record Length

Alphanumeric

8

Territory Number

Alphanumeric

10

ME Number

Alphanumeric

10

Check Digit

Alphanumeric

1

Last Name

Alphanumeric

25

First Name

Alphanumeric

25

Middle Initial

Alphanumeric

1

Suffix

Alphanumeric

4

Title

Alphanumeric

5

Address 1

Alphanumeric

30

Address 2

Alphanumeric

30

Address 3

Alphanumeric

30

Address Indicator

Alphanumeric

1

City

Alphanumeric

28

State

Alphanumeric

2

Zip Code + 4

Number

9

Specialty

Alphanumeric

3

Called On Code

Alphanumeric

1

No Contact Indicator

Alphanumeric

1

Project Start Date

Alphanumeric

10

Current Week Date

Alphanumeric

10

Prior-To Date

Alphanumeric

10

Client Data

Alphanumeric

49

Programming Info

Alphanumeric

11

PRODUCT A

Alphanumeric

30

Week 9 Beg. Date

Alphanumeric

10

Week 9 End Date

Alphanumeric

10

Week 9 Activity Indicator

Alphanumeric

3

Week 9 Activity Indicator Name

Alphanumeric

10

Week 8 Beg. Date

Alphanumeric

10

Week 8 End Date

Alphanumeric

10

Week 8 Activity Indicator

Alphanumeric

3

Week 8 Activity Indicator Name

Alphanumeric

10

Week 7 Beg. Date

Alphanumeric

10

Week 7 End Date

Alphanumeric

10

Week 7 Activity Indicator

Alphanumeric

3

Week 7 Activity Indicator Name

Alphanumeric

10

Week 6 Beg. Date

Alphanumeric

10

Week 6 End Date

Alphanumeric

10

Week 6 Activity Indicator

Alphanumeric

3

Week 6 Activity Indicator Name

Alphanumeric

10

Week 5 Beg. Date

Alphanumeric

10

Week 5 End Date

Alphanumeric

10

Week 5 Activity Indicator

Alphanumeric

3

Week 5 Activity Indicator Name

Alphanumeric

10

Week 4 Beg. Date

Alphanumeric

10

Week 4 End Date

Alphanumeric

10

Week 4 Activity Indicator

Alphanumeric

3

Week 4 Activity Indicator Name

Alphanumeric

10

Week 3 Beg. Date

Alphanumeric

10

Week 3 End Date

Alphanumeric

10

Week 3 Activity Indicator

Alphanumeric

3

Week 3 Activity Indicator Name

Alphanumeric

10

Week 2 Beg. Date

Alphanumeric

10

Week 2 End Date

Alphanumeric

10

Week 2 Activity Indicator

Alphanumeric

3

Week 2 Activity Indicator Name

Alphanumeric

10

Week 1 Beg. Date

Alphanumeric

10

Week 1 End Date

Alphanumeric

10

Week 1 Activity Indicator

Alphanumeric

3

Week 1 Activity Indicator Name

Alphanumeric

10

PRODUCT B

Alphanumeric

30

Week 9 Beg. Date

Alphanumeric

10

Week 9 End Date

Alphanumeric

10

Week 9 Activity Indicator

Alphanumeric

3

Week 9 Activity Indicator Name

Alphanumeric

10

Week 8 Beg. Date

Alphanumeric

10

Week 8 End Date

Alphanumeric

10

Week 8 Activity Indicator

Alphanumeric

3

Week 8 Activity Indicator Name

Alphanumeric

10

Week 7 Beg. Date

Alphanumeric

10

Week 7 End Date

Alphanumeric

10

Week 7 Activity Indicator

Alphanumeric

3

Week 7 Activity Indicator Name

Alphanumeric

10

Week 6 Beg. Date

Alphanumeric

10

Week 6 End Date

Alphanumeric

10

Week 6 Activity Indicator

Alphanumeric

3

Week 6 Activity Indicator Name

Alphanumeric

10

Week 5 Beg. Date

Alphanumeric

10

Week 5 End Date

Alphanumeric

10

Week 5 Activity Indicator

Alphanumeric

3

Week 5 Activity Indicator Name

Alphanumeric

10

Week 4 Beg. Date

Alphanumeric

10

Week 4 End Date

Alphanumeric

10

Week 4 Activity Indicator

Alphanumeric

3

Week 4 Activity Indicator Name

Alphanumeric

10

Week 3 Beg. Date

Alphanumeric

10

Week 3 End Date

Alphanumeric

10

Week 3 Activity Indicator

Alphanumeric

3

Week 3 Activity Indicator Name

Alphanumeric

10

Week 2 Beg. Date

Alphanumeric

10

Week 2 End Date

Alphanumeric

10

Week 2 Activity Indicator

Alphanumeric

3

Week 2 Activity Indicator Name

Alphanumeric

10

Week 1 Beg. Date

Alphanumeric

10

Week 1 End Date

Alphanumeric

10

Week 1 Activity Indicator

Alphanumeric

3

Week 1 Activity Indicator Name

Alphanumeric

10

Siebel Life Sciences Guide Copyright © 2007, Oracle. All rights reserved.