In addition to the data provided by the System Management
Console and the Sterling Selling and
Fulfillment Foundation Statistics,
you can also get application processing statistics by data mining
the Sterling Selling and
Fulfillment Foundation database.
This technique takes advantage of the following application characteristics:
- A record is created in yfs_order_header for every
new order.
- A record is created in yfs_order_line for every
order line.
- A record is created in yfs_order_release_status
each time the order line moves through the various states in its lifecycle.
- An audit record is created in yfs_order_audit each
time an order or order line is modified.
- An audit record is created in yfs_inventory_audit
each time an inventory item is modified.
- Each record has a primary key whose value is made
up of two parts:
- A date/time component in the form of year, month,
date, hours, minutes, and seconds. For example, a record that was
created on September 21, 2011 at 4:20:14 p.m. has 20110921162014 as
the first part of the key.
- A monotonically-increasing sequence number.
A different logic is used to generate primary keys for records
in the YFS_ORDER_RELEASE_STATUS, YFS_ORDER_LINE_SCHEDULE, and YFS_INVENTORY_DEMAND
tables, resulting in random primary keys rather than sequential primary
keys being generated. The logic is as follows:
- The first ten characters comprise the year (YYYY), month (MM),
date (DD), and hours (HH).
- The next two characters are random digits.
- The next two characters comprise the minutes (MM).
- The final ten characters comprise a monotonically-increasing sequence
number, and may contain two characters for seconds (SS), as follows:
- If the sequence number that is returned from the database is eight
characters or less (for example, NNNNNNNN), the primary key includes
two characters for seconds (SS) in addition to the generated sequence
number.
- If the sequence number that is returned from the database is greater
than eight characters (for example, NNNNNNNNNN), the seconds (SS)
are truncated and the ten-digit sequence number is honored.
For example, a record that was created for the YFS_INVENTORY_DEMAND
table on September 21, 2011 at 4:20:14 p.m. has a primary key of 2011092116RR2014NNNNNNNN
(if the sequence number that is returned from the database is eight
characters) or 2011092116RR20NNNNNNNNNN (if the sequence number that
is returned from the database is greater than eight characters), where
RR represents the two random digits and NNNNNNNNNN represents a monotonically-increasing
sequence number.
Note: In multischema environments, the first two
characters of the year are replaced by the two-digit prefix for the
colony.