Try OpenEdge Now
skip to main content
OpenEdge Change Data Capture Guide
Change Data Capture : CDC Policies : CDC Policy Levels
 

CDC Policy Levels

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