ITEMTYPEGROUP - Database Reporting Guide - English - Foundation 22.1 - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

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.

ITEMTYPEGROUP table columns
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  

The index for the ITEMTYPEGROUP table is located in DBSpace8.

ITEMTYPEGROUP table index
Index Name Included Columns
itemtypegroup1 itemtypegroupnum