PLCYACCT

This table stores the user account policies that consist of an account lockout policy and a password policy.

Column Descriptions:

Name	Type	Description
PLCYACCT_ID	INTEGER NOT NULL	The ID for the Account Policy table (PLCYACCT).
PLCYACCLCK_ID	BIGINT NOT NULL	The ID for the account lockout policy foreign key to the Account Lockout Policy table (PLCYACCLCK).
PLCYPASSWD_ID	BIGINT NOT NULL	The ID for the password policy foreign key to the Password Policy table (PLCYPASSWD).
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	PLCYACCT_ID	Primary Key
I0000695	PLCYACCLCK_ID	Non-Unique Index
I0000696	PLCYPASSWD_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_599	PLCYACCLCK_ID	PLCYACCLCK	PLCYACCLCK_ID	Cascade
F_600	PLCYPASSWD_ID	PLCYPASSWD	PLCYPASSWD_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_598	PLCYACCT_ID	PLCYACCDSC	PLCYACCT_ID	Cascade
F_894	PLCYACCT_ID	USERREG	PLCYACCT_ID	Cascade