Previous Topic: SubscriberStateNext Topic: PolicyCategory


WgnPolicy

This table defines all of the policy documents contained within the CA DataMinder installation.

Column

Primary Key

Datatype

Length

Notes

PolicyIDM

Part-key that uniquely identifies the policy within CA DataMinder.

Yes

INTEGER

4

 

 

PolicyID

Part-key that uniquely identifies the policy within CA DataMinder.

Yes

INTEGER

4

 

PolicyName

Name of the policy. This usually reflects the name of the user, group or machine that the policy belongs to.

 

VARCHAR

64

 

PolicyCategory

Indicates the category of the policy document. Categories are common to each type of policy.

 

INTEGER

4

Follow the hyperlink for details.

PolicyType

The type of the policy document (ie, machine, group or user).

 

INTEGER

4

Follow the hyperlink for details.

PolicyVersion

The version of the policy document.

 

INTEGER

4

Each time the policy document is updated, this value is incremented.

Encrypted

 

BIT

1

Unused

Compressed

 

BIT

1

Unused

PolicyBLOBIDM

Part-key identifying the BLOB that contains the policy document data.

 

INTEGER

4

Foreign key: WgnBLOB

PolicyBLOBID

Part-key identifying the BLOB that contains the policy document data.

 

INTEGER

4

Foreign key: WgnBLOB

PolicyCreateTime

The time at which the policy document was created.

 

TIMESTAMP

8

 

VersionIDM

Used to detect and resolve replication update collisions.

 

INTEGER

4

 

VersionID

Used to detect and resolve replication update collisions.

 

INTEGER

4

 

VersionRanking

Used to detect and resolve replication update collisions.

 

INTEGER

4