Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(64)   Default = '' Contains the name of the Active Directory organizational unit
 OUPATH nvarchar(380)   Default = '' Defines the Active Directory path for the organizational unit
 GROUP nvarchar(64)   Default = '' Defines the default Active Directory group that will be used when adding new users to the organizational unit
 USERNAMESUFFIX nvarchar(10)   Default = '' Defines an optional suffix that will be appended to any user names created for the organizational unit
 USERACCOUNTSID varbinary   The SID of the user account that has rights to modify the members or the organizational unit
 USERNAME nvarchar(128) (Computed) SUSER_SNAME(USERACCOUNTSID) Computed name of the USERACCOUNTSID column value
 USERPWD nvarchar(4000)   Default = '' Contains the encrypted password for the user account
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_ADORGANIZATIONALUNIT_DATEADDED DATEADDED    
 IX_ADORGANIZATIONALUNIT_DATECHANGED DATECHANGED      
 PK_ADORGANIZATIONALUNIT ID  
 UIX_ADORGANIZATIONALUNIT_NAME_OUPATH NAME, OUPATH    

Trigger Name Description
 TR_ADORGANIZATIONALUNIT_AUDIT_UPDATE
 TR_ADORGANIZATIONALUNIT_AUDIT_DELETE