Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(250)   Default = '' Stores the name of the site
 DESCRIPTION nvarchar(max)   Default = '' Stores the description of the site
 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.
 HIERARCHYPATH hierarchyid   Default = ([dbo].[UFN_SITEHIERARCHY_GETNEWDESCENDANTVALUE](NULL)) Stores the hierarchy path
 SHORTNAME nvarchar(100)   Default = '' Stores the short name of the site
 SITEID nvarchar(100)   Default = '' Stores the site id
 ACRONYM nvarchar(100)   Default = '' Stores the acronym of the site

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

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

Trigger Name Description
 TR_SITE_INSERTED
 TR_SITE_UPDATED
 TR_SITE_AUDIT_UPDATE
 TR_SITE_AUDIT_DELETE
 TR_SITE_AUDIT_ETLDELETEDID

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
 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
 MKTCREATIVE SITEID
 MKTDOCUMENT SITEID
 MKTEXPENSE 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

Entity-Relationship diagram of this table (ACCOUNTCODE-BATCHCONSTITUENT)
Entity-Relationship diagram of this table (BATCHCONSTITUENTUPDATESITES-EVENTAUTOMATCHSITE)
Entity-Relationship diagram of this table (EVENTCATEGORYCODESITE-IMPORTSELECTIONPROCESS)
Entity-Relationship diagram of this table (IMPORTSOURCE-MKTMARKETINGPLAN)
Entity-Relationship diagram of this table (MKTMARKETINGPLANTEMPLATE-PDACCOUNTSTRUCTURE)
Entity-Relationship diagram of this table (PDACCOUNTSYSTEMSITE-STEWARDSHIPPLANSITE)
Entity-Relationship diagram of this table (STEWARDSHIPPLANTEMPLATESITE-TRIBUTESITE)