Column Descriptions
| Column Name
| Column Type
| Description
|
| ACPOLICY_ID
| INTEGER NOT NULL
| The policy ID of this policy record. This is the primary key.
|
| POLICYNAME
| VARCHAR(128) NOT NULL
| The name of the policy.
|
| ACRELGRP_ID
| INTEGER
| The relationship group ID to which this this policy refers.
|
| ACACTGRP_ID
| INTEGER NOT NULL
| The action group ID. The ID of the action group to which this policy refers. It is a foreign key to the ACACTGRP table.
|
| ACRESGRP_ID
| INTEGER NOT NULL
| The resource group ID to which this policy refers.
|
| ACRELATION_ID
| INTEGER
| The relation ID to which this policy refers.
|
| POLICYTYPE
| INTEGER
| This column is used to distinguish between the different policy types. 2 is a groupable standard policy. 3 is a groupable template policy. Policies of type 2 and 3 must belong to a policy group in order to be applied to an organization. Policy types 0, 1 and null, are deprecated. Policy type 1 indicates that it is a template policy. If it is 0 or null, it is a standard policy. Policies of type 0, 1 and null are applied based on their ownership: they apply to resources owned by the policy owner.
|
| FIELD1
| VARCHAR(128)
| This column is customizable.
|
| MBRGRP_ID
| BIGINT NOT NULL
| The member group ID. It is a foreign key to the MBRGRP_ID column in the MBRGRP table.
|
| MEMBER_ID
| BIGINT NOT NULL
| The member ID of the policy owner. It is a foreign key to the MEMBER table.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|