|
Field Name
|
Data Type
|
Description
|
|
_Policy-Id
|
char
|
Unique CDC policy id
|
|
_Policy-Name
|
char
|
Policy name
|
|
_Policy-Desc
|
char
|
Policy description
|
|
_Policy-State
|
integer
|
CDC policy state
 0 — Active
1 — Inactive
|
|
_Policy-Instance
|
integer
|
CDC assigned instances
0 — Current policy (currently capturing data)
1 — Previous policy
2 — Pending policy
|
|
_Source-File-Recid
|
dbkey
|
Dbkey of the source table
|
|
_Area-Ianum
|
integer
|
Initial area to store the CDC Change Table. Areas must be Type II.
|
|
_Area_Index-Ianum
|
integer
|
Initial area to store CDC Change Table indexes. Areas must be Type II. If not specified, indexes default to the same area as the Change Table.
|
|
_Change-Tablename
|
char
|
Filename of the Change Table
|
|
_Object-Id
|
integer
|
File number of the Change Table
|
|
_Identifying-Fields
|
logical
|
Does the user want to define identifying fields and create an index for them? (Y/N)
|
|
_Level
A level setting of 0 is not modifiable once a policy has been activated.
All levels record entries in the Change Tracking Table.
Levels 1 and above cause creation of the Change Table.
Levels 2 and above record values in the Change Table.
|
integer
|
Defines how much detail a user wants to capture in the change record.
0 – (minimal tracking)
No record values are recorded. This level of tracking indicates a change occurred. A Change Tracking Record is generated and the fieldmap of fields is empty. No Change Table is created for this level. This level cannot be changed/upgraded to a higher level once this policy is active and committed.
1 – (minimal tracking)
Similar to level 0 minimal tracking, level 1 of tracking only generates a Change Tracking Record, but it includes a fieldmap indicating which fields changed. It also does not include a Change Table record. Unlike level 0, a Change Table is created for compatibility moving to higher level policies.
2 – (Medium tracking)
All operations record the current value only.
3 – (Maximum tracking)
Both previous value and current value are recorded (Applies to record update only).
|
|
_Change-Table-Owner
|
char
|
Default value for the Change Table owner is PUB. If another owner is desired, specify here.
|
|
_Encrypt-Policy
|
logical
|
Default to encrypt Change Table if Source Table is encrypted. (Y/N)
|
|
_Last-Modified
|
timestamp tz
|
Time stamp reflecting when the _Policy-Instance changed. Changes occur when:
The policy is first created
The policy becomes current
The policy becomes previous.
|
|
_First-User-Field
|
integer
|
Beginning of user data fields in Change Table.
|
|
_Misc
|
char
|
Reserved for future use.
|
|
Index Name
|
Index Field
|
|
Index Name
|
Index Field
|
|
_Policy-Id
|
1 _Policy-Id
|
|
_Policy-name
|
1 _Policy-Name
|
|
_Policy-Source-Recid
|
1 _Owner-Name
2 _Source-File-Recid
|