1. Database Structure › 1.3 Data Content › 1.3.5 CA MICS Data Element Categorization

1.3.5 CA MICS Data Element Categorization

The data elements that are contained within each File in the
CA MICS database are categorized according to their use and
how they are acted upon by the CA MICS data management
process.

    There are eight data element categories, including:

    1 - Common Control Data Elements
    2 - Common Date and Time Data Elements
    3 - Common Identification Data Elements
    4 - Retained Data Elements
    5 - Accumulated Data Elements
    6 - Min/Max/Avg Data Elements
    7 - Percentage Data Elements
    8 - Derived (Computed) Data Elements

    Each of these categories may be defined as follows.

Common Control Data Elements:  Data elements that maintain
a standard definition, even though they may appear in more
than one File in the Database, and may be used for
data sequencing, summarization, or selection.

Common Date and Time Data Elements:  Data elements that
are maintained in every File, except for Files maintained in
the Administrative Information Area, that commonly define the
dates and times identifying the processing periods for which
data in the Files has been collected.  The data elements
include year, month, time zone, week of the year, day of the
month, day of the week, ending hour of the period, starting
date and time, and ending date and time of the period.  The
data elements may be used for data sequencing, summarization,
or selection.

It is important that the user understand that the
following date and time data elements lose significance as
the File appears in different Timespans.

    o All date and time data elements are supported in the
      DETAIL and DAYS Timespans.

    o The DAY and DAYNAME data elements should not be used in
      the WEEKS, MONTHS and YEARS Timespans.

    o The WEEK data element should not be used in the MONTHS
      and YEARS Timespans.

    o The MONTH data element should not be used in the YEARS
      Timespan.

Common Identification Data Elements:  Data elements that
maintain a standard definition, even though they may appear
in more than one File in the Database, and are used
for purposes of level (CA MICS version) identification.

Retained Data Elements:  Data elements that are uniquely
defined for the File in which they are maintained, and
contain the last value processed.

Accumulated Data Elements:  Data elements that are
uniquely defined for the File in which they are maintained,
and contain the sum of all values processed, for a given
File's level of data summarization.

Min/Max/Avg Data Elements:  Data elements that are
uniquely defined for the File in which they are maintained,
and contain the minimum, maximum, or average value processed,
for a given File's level of data summarization.

Percentage Data Elements:  Data elements that are
uniquely defined for the File in which they are maintained,
and contain computed percentage or maximum percentage values,
which are computed for a given File's level of data
summarization.

Derived (Computed) Data Elements:  Data elements that are
uniquely, defined for the File in which they are maintained,
and contain the results of special computations (e.g.  paging
rate per second), which are computed for a given File's level
of data summarization.