The ITEMTYPEGROUP table stores a record for every configured OnBase Document Type Group. This table can be joined with the ITEMDATA table to get the name of the Document Type Group (itemtypegroupname) for a particular document. The ITEMTYPEGROUP table is located in DBSpace8.
| Column Name | Data Type | Description |
|---|---|---|
| itemtypegroupnum | bigint | The unique identifier of the Document Type Group. |
| itemtypegroupname | char(66) | The name of the Document Type Group. |
| inuse | bigint | |
| itemtypegroupused | bigint | |
| numrows | bigint | |
| docsourceflag | bigint | |
| dmasourcename | char(100) | |
| dmaconnectflag | bigint | |
| dmausername | char(30) | |
| dmauserpassword | char(30) | |
| dmasystemname | char(128) | |
| diskgroupnum | bigint | |
| flags | bigint | |
| initvectordata | char(255) | |
| cryptotype | bigint |
The index for the ITEMTYPEGROUP table is located in DBSpace8.
| Index Name | Included Columns |
|---|---|
| itemtypegroup1 | itemtypegroupnum |