IDSETREGISTER

Each row in the IDSetRegister table corresponds to a view or table-valued function that returns a list of IDs and a sequence. The table is primarily populated through query.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
NAME	nvarchar(300)			Name of the ID set
DESCRIPTION	nvarchar(1024)		Default = ''	Description for the ID set
DBOBJECTNAME	nvarchar(128)			Contains the name of the view or table-valued function
DBOBJECTNAMEWITHASOFDATE	nvarchar(255)		Default = ''
OBJECTTYPE	tinyint		Default = 0	0 - view, 1 - table function, 2 - table function with ID set ID parameter.
STATIC	bit		Default = 0	Indicates whether or not the IDs returned by the view or function are based on a static table or a dynamic query
NUMROWS	int	yes		Contains the number of rows for static ID sets
USEINQUERYDESIGNER	bit		Default = 0	Indicates whether or not this ID Set can be used by the query designer
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)	yes	convert(bigint, TS)	Numeric representation of the timestamp
SECURITYLEVEL	tinyint		Default = 0	0 - All roles, 1 - Selected Roles
GROUPNAME	nvarchar(200)	yes
ACTIVE	bit		Default = 1
ISSYSTEM	bit		Default = 0	Flag used to hide selections meant for system use only.

Foreign Keys

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
OWNERID	uniqueidentifier	yes	APPUSER.ID	ID of the application user who owns the selection.
SITEID	uniqueidentifier	yes	SITE.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_IDSETREGISTER_DATEADDED	DATEADDED			yes
IX_IDSETREGISTER_RECORDTYPEID	RECORDTYPEID
IX_IDSETREGISTER_SITEID	SITEID
PK_IDSETREGISTER	ID	yes	yes
UC_IDSETREGISTER_NAME	NAME	yes

Triggers

Trigger Name	Description
TR_IDSETREGISTER_AUDIT_UPDATE
TR_IDSETREGISTER_AUDIT_DELETE
TR_IDSETREGISTER_DELETE_BBNCIDSETIDMAP
TR_IDSETREGISTER_INSERT_BBNCIDSETIDMAP
TR_IDSETREGISTER_AUDIT_ETLDELETEDID

Referenced by

Referenced by	Field
ACCOUNTINGELEMENTRELATIONSHIPQUERYPARAMETER	QUERYID
ACKNOWLEDGEMENTPROCESS	IDSETREGISTERID
ADDOPPORTUNITIESPROCESS	IDSETREGISTERID
ADDPROSPECTPLANSPROCESS	IDSETREGISTERID
ADDREQUESTSFORMULTIPLESTUDENTSPROCESS	IDSETREGISTERID
ADDRESSVALIDATIONPROCESS	IDSETREGISTERID
ADDSTEWARDSHIPPLANSPROCESS	IDSETREGISTERID
ADDSTEWARDSHIPPLANSTEPSPROCESS	IDSETREGISTERID
ADHOCQUERYDEPENDENCY	IDSETREGISTERID
ADHOCQUERYIDSETDEPENDENCY	IDSETREGISTERID
APPEALMAILINGSETUPLETTER	CANNEDSELECTIONIDSETREGISTERID
APPEALMAILINGSETUPLETTERSELECTION	IDSETREGISTERID
APPEALMAILINGSETUPSELECTION	SELECTIONID
ASSIGNCONSTITSECURITYATTRIBUTESPROCESS	SCOPEIDSETREGISTERID
ASSIGNCONSTITSECURITYATTRIBUTESPROCESS	ASSIGNTOIDSETREGISTERID
ASSIGNLETTERCODESPROCESS	IDSETREGISTERID
ASSIGNPLANNEDGIFTLETTERCODESPROCESS	IDSETREGISTERID
BATCHESCOMMITPROCESS	SELECTIONID
BILLINGGENERATETRANSACTIONSPROCESS	IDSETREGISTERID
CLEARMATCHINGGIFTCLAIMSPROCESS	SELECTIONID
CLOSINGREQUIREMENT	DATAELEMENTQUERYID
COAUPDATECREATEPROCESS	IDSETREGISTERID
COAUPDATESUBMITPROCESS	IDSETREGISTERID
COMMUNICATIONEXCLUSIONS	IDSETREGISTERID
COMMUNICATIONLETTERACTIVITYEXCLUSIONS	IDSETREGISTERID
COMMUNICATIONLETTERSELECTION	IDSETREGISTERID
CONSTITUENCYREFRESHPROCESS	IDSETREGISTERID
CONSTITUENTDUPLICATESEARCHPROCESS	IDSETREGISTERID
CONSTITUENTMERGEPROCESS	FILTERSELECTIONID
CONSTITUENTRECOGNITIONPROCESS	IDSETREGISTERID
CORRESPONDENCEPROCESS	IDSETREGISTERID
CREDITCARDPROCESSING	IDSETREGISTERID
DATABASESPACEUSED	IDSETREGISTERID
DECEASEDFINDERCREATEPROCESS	IDSETREGISTERID
DECEASEDFINDERSUBMITPROCESS	IDSETREGISTERID
DIFFERENTIALDUPLICATECONSTITUENTSRUNDATE	SELECTIONID
DISBURSEMENTPROCESS	IDSETREGISTERID
DISBURSEMENTPROCESSTEMPLATE	IDSETREGISTERID
DISCOUNTADDRESS	IDSETREGISTERID
DONORCHALLENGEENCUMBERPROCESS	SELECTIONID
EMAILFINDERSUBMITPROCESS	IDSETREGISTERID
EXCHANGECALENDARITEMBATCHASSIGNMENT	APPUSERIDSETREGISTERID
EXCHANGECALENDARSYNC	APPUSERIDSETREGISTERID
EXCHANGECONTACTBATCHASSIGNMENT	APPUSERIDSETREGISTERID
EXCHANGECONTACTSYNC	APPUSERIDSETREGISTERID
EXCHANGECONTACTSYNC	CONSTITUENTIDSETREGISTERID
EXCHANGEEMAILBATCHASSIGNMENT	APPUSERIDSETREGISTERID
EXPORTPROCESS	SELECTIONID
GENERATEBACSFILEPROCESS	IDSETREGISTERID
GENERATEBATCHPROCESS	IDSETREGISTERID
GENERATEBATCHPROCESSCUB	IDSETREGISTERID
GENERATEEFTFILEPROCESS	IDSETREGISTERID
GENERATESTEPUPDATEBATCHPROCESS	IDSETREGISTERID
GENERATETRANSACTIONSPROCESS	IDSETREGISTERID
GIFTAIDREFRESHPROCESS	IDSETREGISTERID
GLPOSTPROCESSTRANSACTIONCRITERIA	IDSETREGISTERID
IDSETREGISTERADHOCQUERY	IDSETREGISTERID
IDSETREGISTERDYNAMICIDSET	STATICIDSETREGISTERID
IDSETREGISTERDYNAMICIDSET	DYNAMICIDSETREGISTERID
IDSETREGISTERMERGE	IDSETREGISTERID
IDSETREGISTERMERGE	SELECTION1ID
IDSETREGISTERMERGE	SELECTION2ID
IDSETREGISTERSMARTQUERYINSTANCE	IDSETREGISTERID
IMPORTSELECTIONPROCESS	IDSETREGISTERID
IRSFORM1099MISCPROCESSTEMPLATE	IDSETREGISTERID
LETTERCODE	IDSETREGISTERID
MEMBERSHIPLEVELCONTRIBUTION	IDSETREGISTERID
MEMBERSHIPPROGRAMCONTRIBUTION	IDSETREGISTERID
MEMBERSHIPPROGRAMCONTRIBUTION	APPLICATIONSELECTIONID
MKTACKNOWLEDGEMENTMAILINGTEMPLATEASKLADDEROVERRIDE	IDSETREGISTERID
MKTACKNOWLEDGEMENTMAILINGTEMPLATEFILTERSELECTION	SELECTIONID
MKTCOMMUNICATIONTEMPLATEDEFAULTASKLADDEROVERRIDE	IDSETREGISTERID
MKTCOMMUNICATIONTEMPLATEDEFAULTFILTERSELECTION	SELECTIONID
MKTMEMBERSHIPMAILINGTEMPLATEASKLADDEROVERRIDE	IDSETREGISTERID
MKTMEMBERSHIPMAILINGTEMPLATEFILTERSELECTION	SELECTIONID
MKTSEGMENT	IDSETREGISTERID
MKTSEGMENTATIONACTIVATE	NORMALGIFTIDSETREGISTERID
MKTSEGMENTATIONACTIVATE	UNRESOLVEDGIFTIDSETREGISTERID
MKTSEGMENTATIONASKLADDEROVERRIDE	IDSETREGISTERID
MKTSEGMENTATIONEXCLUSIONSELECTION	IDSETREGISTERID
MKTSEGMENTATIONFILTERSELECTION	SELECTIONID
MKTSEGMENTLIST	STANDARDIDSETID
MKTSEGMENTLIST	DUPLICATEIDSETID
MKTSEGMENTSELECTION	SELECTIONID
MKTSEGMENTWHITEMAILREFRESHPROCESS	GIFTIDSETREGISTERID
MKTSPONSORSHIPMAILINGTEMPLATEASKLADDEROVERRIDE	IDSETREGISTERID
MKTSPONSORSHIPMAILINGTEMPLATEFILTERSELECTION	SELECTIONID
NAMEFORMATPARAMETER	JOINTSELECTIONID
NETCOMMUNITYMAPPINGRULE	SELECTIONID
NOTIFICATION	RECORDIDSETREGISTERID
NOTIFICATION	APPUSERIDSETREGISTERID
PAPERLESSMANDATESINSTRUCTIONPROCESS	IDSETREGISTERID
PEOPLEFINDERSUBMITPROCESS	IDSETREGISTERID
PHONEFINDERSUBMITPROCESS	IDSETREGISTERID
PLANNEDGIFTACKNOWLEDGEMENTPROCESS	IDSETREGISTERID
PLANNEDGIFTLETTERCODE	IDSETREGISTERID
PLEDGEREMINDERPROCESS	IDSETREGISTERID
PLEDGEWRITEOFFPROCESS	IDSETREGISTERID
POSTTOGLPROCESS	IDSETREGISTERID
POSTTOGLPROCESS	DEPOSITIDSETREGISTERID
POSTTOGLPROCESS	ADJUSTMENTIDSETREGISTERID
PRENOTIFICATIONPROCESS	IDSETREGISTERID
PRINTMEMBERSHIPCARDSPROCESS	IDSETREGISTERID
PROGRAMGROUP	IDSETREGISTERID
PROSPECTASSIGNMENTPROCESS	PROSPECTSELECTIONID
PROSPECTSEGMENTATION	IDSETREGISTERID
R68	IDSETREGISTERID
R68ARCHIVEDPARAMETERS	IDSETREGISTERID
RECEIPTINGPROCESS	IDSETREGISTERID
RECOGNITIONPROGRAM	SELECTIONID
RECURRINGGIFTSTATUSUPDATEPROCESS	IDSETREGISTERID
RESEARCHGROUP	IDSETREGISTERID
RESEARCHGROUPPOPULATEPROCESS	IDSETREGISTERID
REVALUECOMMITMENTSPROCESS	IDSETREGISTERID
REVENUEFILTER	IDSETREGISTERID
SMARTFIELDVALUEGROUPIDSETREGISTER	IDSETREGISTERID
SPONSORSHIPOPPORTUNITYRESERVEPROCESS	IDSETREGISTERID
SPONSORSHIPTERMINATEPROCESS	IDSETREGISTERID
SPONSORSHIPTRANSFERPROCESS	IDSETREGISTERID
STANDINGORDERSEXPORTPROCESS	IDSETREGISTERID
STEWARDSHIPPLANASSIGNMENTPROCESS	IDSETREGISTERID
SYSTEMROLEPERM_SELECTION	SELECTIONID
TRIBUTEACKNOWLEDGEMENTPROCESS	IDSETREGISTERID
UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS	CONSTITUENTSELECTIONID
WEALTHPOINTDATAREFRESHNOTIFICATION	IDSETREGISTERID
WPBATCHSCREENINGPROCESS	IDSETREGISTERID
WPSEARCHPROCESS	IDSETREGISTERID