Try OpenEdge Now
skip to main content
OpenEdge Change Data Capture Guide
CDC Schema : CDC Field Policy Table
 

CDC Field Policy Table

The following table describes the fields of the _Cdc-Field-Policy.
Table 8. _Cdc-Field-Policy fields
Field
Size
Description
_Policy-Id
char(22)
Relationship to parent
_Field-Position
integer
Physical position of field in the source table
_Identifying-Field
integer
0 — not an identifying field.
A non-zero value indicates ordinal position in index.
_Field-Recid
int64
Source field recid (avoids update of policy on field rename)
_Misc
char
Reserved for future use
The following table describes the indexes of the _Cdc-Field-Policy.
Table 9. _Cdc-Table-Policy indexes
Index Name
Index Field
_Policy-Id
1 _Policy-Id
2 _Field-Position
_Identifying-Field
1 _Policy-Id
2 _Identifying-Field
_Field-Recid
1 _Policy-Id
2 _Field-Recid