9. PROCESSING › 9.2 Daily Update Processing Flow › 9.2.4 Data Base Timespan Processing
9.2.4 Data Base Timespan Processing
The data base timespan processing phase performs the required
summarization to produce the cycles for the DAYS timespan.
Also, where applicable, week-to-date and/or month-to-date
cycles are updated.
The user exits invoked in this phase are listed below:
o Detail timespan exits
Exits are provided for optional creation of the DETAIL
timespan for those files that normally do not have a
DETAIL timespan.
USRXCAC - CICCAC DETAIL timespan creation
USRXCAU - CICCAU DETAIL timespan creation
USRXCSF - CICCSF DETAIL timespan creation
USRXCSU - CICCSU DETAIL timespan creation
o Output exits
During summarization to the DAYS level, these exits
may be used for data element manipulation.
USRSCAC - CICCAC element derivation
USRSCSU - CICCSU element derivation
USRSCAU - CICCAU element derivation
o Parameter-related exits
CICDCAC - cost derivation
CICDCSU - cost derivation
Figure 9-4 outlines the flow of this phase.
+-------+ ************
| 1-1 |------->* CICCAC *
+-------+ ************
|
/------------\ yes ******************
< Detail time >-------->* User detail TS *
\ span exit? / * exit USRXCAC *
\ ******************
|
+--------------------+ ****************
| Summarize CSW file |<---->* User output *
| at days level. |<--+ * exit USRSCAC *
+--------------------+ | ****************
| |
+------------------+ | *******************
| Write | +->* Cost derivation *
| DAYS.CICCAC00 | * exit USRDCAC *
+------------------+ *******************
|
+----------------------+
| Process updates to |
| month-to-date cycles |
| MONTH.CICCACM0 |
+----------------------+
|
************
* CICCSF *
************
|
/------------\ yes ******************
< Detail time >-------->* User detail TS *
\ span exit? / * exit USRXCSF *
\ ******************
|
+--------------------+
| Summarize CSF file |
| at days level. |
+--------------------+
|
+------------------+
| Write |
| DAYS.CICCSF00 |
+------------------+
|
************
* CICCSU *
************
|
/------------\ yes ****************** +-------+
< Detail time >-------->* User detail TS *------->| 2-1 |
\ span exit? / * exit USRXCSU * +-------+
\ ******************
Figure 9-4. Data Base Timespan Processing (Part 1 of 3)
+-------+ +------------------+
| 2-1 |------>| Perform data |
+-------+ | manipulations |
+------------------+
|
+--------------------+ ****************
| Summarize CSW file |<---->* User output *
| at days level. |<--+ * exit USRSCSU *
+--------------------+ | ****************
| |
+------------------+ | *******************
| Write | +->* Cost derivation *
| DAYS.CICCSU00 | * exit USRDCSU *
+------------------+ *******************
|
+----------------------+
| Process updates to |
| month-to-date cycles |
| MONTH.CICCSUM0 |
+----------------------+
|
************
* CICCAU *
************
|
/------------\ yes ******************
< Detail time >-------->* User detail TS *
\ span exit? / * exit USRXCAU *
\ ******************
|
+------------------+
| Perform data |
| manipulations |
+------------------+
|
+--------------------+ ****************
| Summarize CSW file |<---->* User output *
| at days level. | * exit USRSCAU *
+--------------------+ ****************
|
+------------------+
| Write |
| DAYS.CICCAU00 |
+------------------+
|
+----------------------+
| Process updates to | +-------+
| month-to-date cycles |------->| 3-1 |
| MONTH.CICCAUM0 | +-------+
+----------------------+
Figure 9-4. Data Base Timespan Processing (Part 2 of 3)
+-----+ *******************
| 3-1 |------->* CICCSR/CICCSY *
+-----+ *******************
|
+--------------------+
| Sort WORK.CICCSY00 |
| to eliminate |
| duplicates. |
+--------------------+
|
+-----------------+
| Write |
| DETAIL.CICCSY00 |
+-----------------+
|
+--------------------+
| Summarize CSY file |
| at days level. |
+--------------------+
|
+---------------------+
| Write DAYS.CICCSY00 |
+---------------------+
|
+---------------------+
| Build DAYS CSR file |
| from DAYS CSU. |
+---------------------+
|
+--------------------+
| Summarize CSY file |
| at days level from |
| DAYS CSY and DAYS |
| CSR |
+--------------------+
|
+---------------------+
| Write DAYS.CICCSY00 |
+---------------------+
|
+----------------------+
| Process updates to |
| week-to-date cycles |
| WEEKS.CICCSYW0 |
+----------------------+
|
+----------------------+
| Process updates to | +-------+
| month-to-date cycles |------->| done |
| MONTH.CICCSYM0 | +-------+
+----------------------+
Figure 9-4. Data Base Timespan Processing (Part 3 of 3)
