Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 OBJECTNAME nvarchar(128)   Name of database object
 DISPLAYNAME nvarchar(255)   Default display name used in query
 OBJECTTYPE tinyint   Default = 0 0 - view, 1 - table function
 OBJECTTYPENAME varchar(20) (Computed)  
 ROOTOBJECT bit   Default = 0 Indicates whether or not the object is considered a root object by the query designer
 ENFORCERECORDACCESSSECURITY bit   Default = 0 Indicates if Record Access Security is enforced over the records returned by this view
 DESCRIPTION nvarchar(max)   Default = ''
 PRIMARYKEYFIELD nvarchar(128) Name of the field in the query view which represents the primary key field for the query view
 PRIMARYKEYTYPENAME nvarchar(128)
 SUBGROUP nvarchar(255)   Default = '' Name used for subgrouping query objects in the query designer
 OUTPUTDEFINITIONXML xml Contains the meta data for each of the columns defined by the object
 PARAMETERMETADATAXML xml Contains the meta data for each of the parameters defined by the object (primarily stored procedures)
 QUERYVIEWSPEC xml Contains the spec xml used to create this query view
 QUERYVIEWSPECEXTENSION xml Contains the xml used to extend this query view
 SECURITYUIFOLDER nvarchar(255)   Default = ''
 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
 USEINREPORTMODELGENERATOR bit   Default = 0
 MARTKEY nvarchar(255)
 ALLOWATTRIBUTEEXTENSION bit   Default = 0

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

Index Name Field(s) Unique Primary Clustered
 IX_QUERYVIEWCATALOG_DATEADDED DATEADDED    
 IX_QUERYVIEWCATALOG_RECORDTYPEID RECORDTYPEID      
 PK_QUERYVIEWCATALOG ID  
 UC_QUERYVIEWCATALOG_OBJECTNAME OBJECTNAME    

Trigger Name Description
 TR_QUERYVIEWCATALOG_AUDIT_UPDATE
 TR_QUERYVIEWCATALOG_AUDIT_DELETE

Referenced by Field
 ADHOCQUERY QUERYVIEWCATALOGID
 BATCHTYPECATALOG CONTROLREPORTQUERYVIEWID
 BATCHTYPECATALOG EXCEPTIONREPORTQUERYVIEWID
 BUSINESSPROCESSVIEW QUERYVIEWCATALOGID
 CORRESPONDENCEPROCESS QUERYVIEWID
 EXPORTDEFINITION QUERYVIEWCATALOGID
 LETTERCODE QUERYVIEWID
 LETTERTEMPLATE QUERYVIEWID
 MKTAPPEALRECORDSOURCE QUERYVIEWCATALOGID
 MKTCONSOLIDATEDQUERYVIEWSPEC ID
 MKTCONSOLIDATEDQUERYVIEWSPEC CONSOLIDATEDQUERYVIEWCATALOGID
 MKTDUPLICATE QUERYVIEWCATALOGID
 MKTEXPORTDEFINITIONOUTPUTFIELD QUERYVIEWCATALOGID
 MKTEXPORTDEFINITIONOUTPUTFIELD CUSTOMQUERYVIEWCATALOGID
 MKTGIFTRECORDSOURCE QUERYVIEWCATALOGID
 MKTGIFTRECORDSOURCE MARKETINGINFOQUERYVIEWCATALOGID
 MKTMEMBERSHIPRECORDSOURCE QUERYVIEWCATALOGID
 MKTRECORDSOURCE ID
 MKTRECORDSOURCE MARKETINGINFOQUERYVIEWCATALOGID
 MKTSEGMENT QUERYVIEWCATALOGID
 MKTSEGMENTLIST QUERYVIEWCATALOGID
 MKTSEGMENTLIST CONSOLIDATEDQUERYVIEWID
 MKTSOURCEANALYSISRULEFIELDS QUERYVIEWCATALOGID
 MKTSOURCECODEMAP DONORQUERYVIEWCATALOGID
 MKTSPONSORSHIPRECORDSOURCE QUERYVIEWCATALOGID
 PLANNEDGIFTLETTERCODE QUERYVIEWID
 QUERYVIEWEXTENSIONCATALOG QUERYVIEWCATALOGID
 QUERYVIEWRELATIONSHIP ROOTQUERYVIEWID
 QUERYVIEWRELATIONSHIP RELATEDQUERYVIEWID
 QUERYVIEWRELATIONSHIP ADDEDBYQUERYVIEWID
 SECUREDCHILDQUERYVIEW ID
 SMARTFIELD SOURCEQUERYVIEWCATALOGID
 SPONSORSHIPPROGRAM QUERYVIEWID
 SYSTEMROLEPERM_QUERYVIEW QUERYVIEWCATALOGID
 TRIBUTELETTERCODE QUERYVIEWID

Entity-Relationship diagram of this table (ADHOCQUERY-MKTSOURCECODEMAP)
Entity-Relationship diagram of this table (MKTSPONSORSHIPRECORDSOURCE-TRIBUTELETTERCODE)