SITE (4.0)

no changes

dbo-4.0

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Stores site information.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
SITETYPECODEID	uniqueidentifier	true	SITETYPECODE.ID	Stores the type of site

Fields
Field	Field Type	Null	Notes	Description
NAME	nvarchar(250)	false	''	Stores the name of the site
DESCRIPTION	nvarchar(max)	false	''	Stores the description of the site
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
HIERARCHYPATH	hierarchyid	false	([dbo].[UFN_SITEHIERARCHY_GETNEWDESCENDANTVALUE](NULL))	Stores the hierarchy path
SHORTNAME	nvarchar(100)	false	''	Stores the short name of the site
SITEID	nvarchar(100)	false	''	Stores the site id
ACRONYM	nvarchar(100)	false	''	Stores the acronym of the site

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_SITE_DATEADDED	DATEADDED	False	False	True
IX_SITE_DATECHANGED	DATECHANGED	False	False	False
IX_SITE_ID_NAME	ID NAME	False	False	False
IX_SITE_NAME_ID	NAME ID	False	False	False
PK_SITE	ID	True	True	False
UC_SITE_HIERARCHYPATH	HIERARCHYPATH	True	False	False

Triggers
Trigger Name	Description
TR_SITE_INSERTED
TR_SITE_UPDATED
TR_SITE_AUDIT_ETLDELETEDID
TR_SITE_AUDIT_UPDATE
TR_SITE_AUDIT_DELETE

Referenced by
Referenced by	Field
ACCOUNTCODE	SITEID
ACCOUNTSTRUCTURE	SITEID
ADDPROSPECTPLANSPROCESSSITE	SITEID
ADDRESSPROCESSINGOPTION	SITEID
ADDRESSVALIDATION	SITEID
ADHOCQUERY	SITEID
AMPROIMPORTCONFIG	NEWCONSTITUENTSITEID
ANONYMOUSEMAILPREFERENCE	SITEID
APPEAL	SITEID
APPUSER	SITEID
APPUSERSITEBRANCH	SITEID
BANKACCOUNTSITE	SITEID
BATCHAMPROIMPORTCONSTITUENT	CONSTITUENT_NEWSITEID
BATCHBBNCDONATION	DONORSITEID
BATCHBBNCDONATION	CORPORATEDONORSITEID
BATCHBBNCDONATION	MGCOMPANYSITEID
BATCHBBNCDONATION	TRIBUTEACKNOWLEDGEESITEID
BATCHBBNCDONATION	SPOUSESITEID
BATCHBBNCEVENTREGISTRATION	DONORSITEID
BATCHBBNCEVENTREGISTRATION	GUESTSITEID
BATCHBBNCMEMBERSHIP	MEMBERSITEID
BATCHBBNCPROFILE	SPOUSESITEID
BATCHBBNCPROFILE	PRIMARYBUSINESSSITEID
BATCHBBNCSIGNUP	LINKEDCONSTITUENTSITEID
BATCHCONSTITUENT	CONSTITUENT_SITEID
BATCHCONSTITUENTUPDATESITES	SITEID
BATCHDIRECTMARKETINGEFFORTLIST	SITEID
BATCHDIRECTMARKETINGEFFORTPACKAGE	SITEID
BATCHDIRECTMARKETINGEFFORTSEGMENT	SITEID
BATCHEVENTSITE	SITEID
BATCHREVENUECONSTITUENT	SITEID
BATCHTEMPLATE	SITEID
BENEFITSITE	SITEID
BUSINESSPROCESSINSTANCE	SITEID
CAMPAIGNSITE	SITEID
CHARITYCLAIMREFERENCENUMBERSITE	SITEID
COAUPDATE	SITEID
CONSTITUENTSITE	SITEID
CORRESPONDENCECODE	SITEID
DECEASEDFINDER	SITEID
DESIGNATIONLEVEL	SITEID
DONORCHALLENGE	SITEID
EDUCATIONALDEGREECODESITE	SITEID
EDUCATIONALDEPARTMENTCODESITE	SITEID
EMAILFINDER	SITEID
EVENTAUTOMATCHSITE	SITEID
EVENTCATEGORYCODESITE	SITEID
EVENTEXTENSION	SITEID
EVENTMANAGEMENTTEMPLATESITE	SITEID
EVENTSITE	SITEID
EXCHANGEEMAILBATCHSITE	SITEID
EXPORTDEFINITION	SITEID
FAFEVENTBATCH	SITEID
FAFEVENTBATCH	DEFAULTCONSTITUENTSITEID
FAFNFGCAMPAIGNDISPLAYSITE	SITEID
FAFNFGCAMPAIGNLEVELDISPLAYSITE	SITEID
FAFPROGRAMSITE	SITEID
FEPPROCESS	SITEID
FUNDINGPLAN	SITEID
FUNDINGREQUESTOUTLINE	SITEID
GIVINGLEVELPROGRAMSITE	SITEID
GLFISCALYEAR	SITEID
IDSETREGISTER	SITEID
IMPORTFILETEMPLATE	SITEID
IMPORTFIXEDWIDTHFILETEMPLATE	SITEID
IMPORTSELECTIONPROCESS	SITEID
IMPORTSOURCE	SITEID
INTERACTIONSITE	SITEID
JOB	SITEID
JOBOCCURRENCE	SITEID
KPIINSTANCESITE	SITEID
LETTERCODE	SITEID
LETTERCODESITE	SITEID
LETTERTEMPLATE	SITEID
MAILPREFERENCE	SITEID
MEMBERSHIPPROGRAM	SITEID
MERCHANTACCOUNTSITE	SITEID
MKTACKNOWLEDGEMENTMAILINGTEMPLATE	SITEID
MKTASKLADDER	SITEID
MKTCOMMUNICATIONNAMESCHEME	SITEID
MKTCOMMUNICATIONTEMPLATE	SITEID
MKTCREATIVE	SITEID
MKTDOCUMENT	SITEID
MKTEXPENSE	SITEID
MKTFINDERNUMBERCONSTITUENTSITE	SITEID
MKTLIST	SITEID
MKTLISTLAYOUT	SITEID
MKTMARKETINGPLAN	SITEID
MKTMARKETINGPLANTEMPLATE	SITEID
MKTMATERIAL	SITEID
MKTMEMBERSHIPMAILINGTEMPLATE	SITEID
MKTPACKAGE	SITEID
MKTSEED	SITEID
MKTSEGMENT	SITEID
MKTSEGMENTATION	SITEID
MKTSEGMENTGROUP	SITEID
MKTSOURCECODE	SITEID
MKTSPONSORSHIPMAILINGTEMPLATE	SITEID
NAMEFORMAT	SITEID
NAMEFORMATPARAMETER	SITEID
NAMINGOPPORTUNITY	SITEID
NETCOMMUNITYMAPPINGRULE	SITEID
OPPORTUNITYAMOUNTBRACKETSITES	SITEID
ORGANIZATIONPOSITION	SITEID
PAPERLESSMANDATESSITECONFIGURATION	ID
PDACCOUNTCODEMAPSUBLEDGER	SITEID
PDACCOUNTSTRUCTURE	SITEID
PDACCOUNTSYSTEMSITE	SITEID
PEOPLEFINDER	SITEID
PHONEFINDER	SITEID
PLANNEDGIFTLETTERCODESITE	SITEID
PLANNEDGIFTSITE	SITEID
PLANOUTLINE	SITEID
PROGRAMCATEGORYCODESITE	SITEID
PROSPECTFUNDINGINTERESTSITE	SITEID
PROSPECTPLANSITE	SITEID
PROSPECTRESEARCHREQUESTSITE	SITEID
RECOGNITIONPROGRAM	SITEID
RELATIONSHIPTYPECODESITE	SITEID
RESEARCHGROUPSITE	SITEID
SITEPERMISSION	SITEID
SMARTFIELDSITE	SITEID
SMARTQUERYINSTANCE	SITEID
SOLICITCODE	SITEID
STEWARDSHIPPLANSITE	SITEID
STEWARDSHIPPLANTEMPLATESITE	SITEID
SYSTEMROLEADGROUP	BRANCHSITEID
SYSTEMROLEADGROUPSITE	SITEID
SYSTEMROLEAPPUSER	BRANCHSITEID
SYSTEMROLEAPPUSERSITE	SITEID
TRIBUTELETTERCODESITE	SITEID
TRIBUTESITE	SITEID