When defining a CDC policy, the level you specify determines amount of change tracking data collected. The following table gives a description of the data captured at level.

Table 1. Description of CDC levels
Level Description
Minimal (0) This level indicates a change occurred. No record values will be recorded.
Minimal with Fieldmap (1) Similar to the Minimal (0) level, this level indicates a change occurred, but also includes a field map value indicating which fields changed. No record values will be recorded.
Medium (2) This level records the current (after) value of all CUD operations.
Maximum (3) This level records both the previous (before) and current (after) values of all CUD operations.

The following table describes in more detail the resulting data recorded for the different levels.

Level Field Policies Change Tracking Table Record Change Table Record Change Fieldmap Change Level Allowed
0 no yes no null no
1 yes yes no Reflects changed fields in update only yes
2 yes yes yes Reflects changed fields in update only yes
3 yes yes
  • 1 record for before update
  • 1 record for after update
 Reflects changed fields in update only. yes