APPUSER

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
USERSID varbinary
DISPLAYNAME nvarchar(255) Default = ''
ISSYSADMIN bit Default = 0
DATEADDED datetime Default = getdate()
DATECHANGED datetime Default = getdate()
TS timestamp
TSLONG bigint (Computed) yes convert(bigint, TS)
CUSTOM_AUTHENTICATION_USERID nvarchar(255) Default = ''
WINDOWSUSERNAME nvarchar(255) Default = ''
ISSYSTEM bit Default = 0
EMAILADDRESS nvarchar(100) yes
USERNAME nvarchar(128) (Computed) yes
ISACTIVE bit Default = 1
LASTLOGINDATE datetime yes
ISPROXYUSER bit yes
INVALIDLOGINATTEMPTS int yes
PROXYOWNERID uniqueidentifier yes
HASRUNASRIGHTS bit Default = 0

Foreign Keys

Foreign Key Field Type Null Notes Description
ADDEDBYID uniqueidentifier CHANGEAGENT.ID
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID
CONSTITUENTID uniqueidentifier yes CONSTITUENT.LOCALID
SITEID uniqueidentifier yes SITE.ID

Indexes

Index Name Fields Unique Primary Clustered
IX_APPUSER_CONSTITUENTID CONSTITUENTID
IX_APPUSER_COVER_CUSTOM_AUTHENTICATION_USERID_ISSYSADMIN_ID CUSTOM_AUTHENTICATION_USERID
IX_APPUSER_COVER_ID_ISSYSADMIN ID
IX_APPUSER_COVER_USERSID_ISSYSADMIN_ID USERSID
IX_APPUSER_DATEADDED DATEADDED yes
IX_APPUSER_SITEID SITEID
IX_APPUSER_EMAILADDRESS EMAILADDRESS yes
PK_APPUSER ID yes yes
UC_APPUSER_USERSID USERSID, CUSTOM_AUTHENTICATION_USERID, EMAILADDRESS yes

Triggers

Trigger Name Description
TR_APPUSER_AUDIT_DELETE
TR_APPUSER_ARCHIVE
TR_APPUSER_EMAILUPDATED
TR_APPUSER_INSERT
TR_APPUSER_UPDATE
TR_APPUSER_AUDIT_ETLDELETEDID
TR_APPUSER_AUDIT_UPDATE

Referenced by

Referenced by Field
ADDRESSVALIDATION BATCHAPPUSERID
ADHOCQUERY OWNERID
ADHOCQUERYFOLDER OWNERID
APPUSERACCOUNTSYSTEM APPUSERID
APPUSERADHOCQUERYFAVORITE APPUSERID
APPUSERALERTSETTING ID
APPUSERALERTTYPESETTING APPUSERID
APPUSERCLAIMS APPUSERID
APPUSERCLAIMSLINK APPUSERID
APPUSERCURRENCYSET APPUSERID
APPUSERFEATURETIP APPUSERID
APPUSERFEEDALERTINSTANCE APPUSERID
APPUSERINACTIVEDETAIL ID
APPUSERKPIINSTANCEFAVORITE APPUSERID
APPUSERPASSWORDRESET APPUSERID
APPUSERSESSION ID
APPUSERSITEBRANCH APPUSERID
APPUSERSMARTQUERYINSTANCEFAVORITE APPUSERID
APPUSERSUMMARYTILECONTEXT APPUSERID
APPUSERTHIRDPARTYAUTH ID
BATCH APPUSERID
BATCHAUCTIONITEMCONSTITUENT CURRENTAPPUSERID
BATCHREVENUECONSTITUENT CURRENTAPPUSERID
BATCHSPONSORSHIPCONSTITUENT CURRENTAPPUSERID
BATCHSTATISTICS APPUSERID
BATCHTICKETPRINTJOB APPUSERID
BATCHUSERSETTINGS APPUSERID
BATCHWORKFLOWSTATUS APPUSERID
BBNCUSERMAP ID
BBWORKFLOWINBOXASSIGNMENT APPUSERID
BBWORKFLOWINSTANCEINFO INITIATEDBY_APPUSERID
BBWORKFLOWTASK COMPLETEDBY_APPUSERID
BBWORKFLOWTASK OWNER_APPUSERID
BUSINESSPROCESSINSTANCE OWNERID
BUSINESSPROCESSJOBSCHEDULEUSERMAPPING APPUSERID
BUSINESSPROCESSSTATUS STARTEDBYUSERID
COAUPDATE BATCHAPPUSERID
CORPORATESTRUCTUREFILTER APPUSERID
CORPORATESTRUCTURESELECTION APPUSERID
CREDITCARDPROCESSING OWNERID
CREDITPAYMENT APPUSERID
DATANETTEASEREMAILTRACKING APPUSERID
DATANETTEASERTRACKING APPUSERID
DECEASEDFINDER BATCHAPPUSERID
DOCUMENTPRINTINGHISTORY APPUSERID
EMAILFINDER BATCHAPPUSERID
ENQUEUESETTINGS ID
EVENTIMPORT ISIMPORTINGBYUSERID
EXCHANGEAPPUSEREMAILADDRESS APPUSERID
EXCHANGECALENDARITEM APPUSERID
EXCHANGECALENDARITEMBATCH OWNERID
EXCHANGECALENDARITEMBATCHASSIGNMENT OWNERAPPUSERID
EXCHANGECALENDARSYNC SPECIFICAPPUSERID
EXCHANGECONTACT APPUSERID
EXCHANGECONTACTBATCH CHANGEDBYAPPUSERID
EXCHANGECONTACTBATCHASSIGNMENT OWNERAPPUSERID
EXCHANGECONTACTSYNC SPECIFICAPPUSERID
EXCHANGEDOWNLOADPROCESS EMAILBATCHAPPUSERID
EXCHANGEDOWNLOADPROCESS CONTACTBATCHAPPUSERID
EXCHANGEDOWNLOADPROCESS CALENDARITEMBATCHAPPUSERID
EXCHANGEEMAILBATCH USERID
EXCHANGEEMAILBATCHASSIGNMENT OWNERAPPUSERID
EXCHANGESERVERAPPUSER APPUSERID
EXCHANGEUSER APPUSERID
FINANCIALTRANSACTION APPUSERID
FLAGGEDPROSPECT APPUSERID
GENERATEBACSFILEPROCESS OWNERID
GENERATEBATCHPROCESS APPUSERID
GENERATEBATCHPROCESSCUB APPUSERID
GENERATEEFTFILEPROCESS OWNERID
GENERATESTEPUPDATEBATCHPROCESS APPUSERID
GENERATETRANSACTIONSPROCESS OWNERID
GIVINGLISTMODE APPUSERID
GIVINGLISTSUMMARYCURRENCYTYPESETTING APPUSERID
GIVINGLISTSUMMARYSETTINGS APPUSERID
GRADINGAPPUSERSESSION ID
IDSETREGISTER OWNERID
IMPORTPROCESS BATCHAPPUSERID
IMPORTSELECTIONPROCESS OWNERID
INTERACTIONATTACHMENT ENTEREDBYAPPUSERID
INTERACTIONMEDIALINK ENTEREDBYAPPUSERID
INTERACTIONNOTE ENTEREDBYAPPUSERID
JOURNALENTRYANNOTATION APPUSERID
KPIDASHBOARDPAGE APPUSERID
MKTCOMMUNICATIONEFFORTUSERSETTINGS APPUSERID
MKTFINDERNUMBERCONSTITUENT CURRENTAPPUSERID
MKTMARKETINGPLANINCOMEFORECASTPREFERENCES APPUSERID
MKTSEGMENTATION OWNERID
NETCOMMUNITYMAPPINGRULEOWNER OWNERID
NETCOMMUNITYPROCESSORSPLIT OWNERID
NETCOMMUNITYTRANSACTIONPROCESSOR OWNERID
PARTIALINFORMATIONSEARCHCRITERIA APPUSERID
PEOPLEFINDER BATCHAPPUSERID
PERSONALACCESSTOKEN PROXYUSERID
PHONEFINDER BATCHAPPUSERID
PLANNEDGIFTATTACHMENT ENTEREDBYAPPUSERID
PLANNEDGIFTMEDIALINK ENTEREDBYAPPUSERID
PLANNEDGIFTNOTE ENTEREDBYAPPUSERID
PROSPECT LASTRESEARCHEDBYID
PROSPECTASSIGNMENTREQUEST REVIEWEDBYID
PROSPECTASSIGNMENTREQUEST SUBMITTEDBYID
PROSPECTPLANREQUEST REVIEWEDBYID
PROSPECTPLANREQUEST SUBMITTEDBYID
PROSPECTRESEARCHREQUESTAPPUSERPERMISSION ID
PROSPECTRESEARCHTEMPLATE OWNERID
PROSPECTRESEARCHTEMPLATEDEFAULT OWNERID
PROSPECTSEARCH OWNERID
PROSPECTSEARCHSELECTEDTILE APPUSERID
PROSPECTSEGMENTATION OWNERID
RE7INTEGRATIONCREDENTIALS ID
RE7INTEGRATIONIMPORTSTAGING APPUSERID
RECONCILIATION APPUSERID
RECONCILIATION APPROVEDBYID
RELATIONSHIPMAPINSTANCE OWNERID
RESCHEDULETICKETSHISTORY RESCHEDULEDBYID
RESEARCHGROUP OWNERID
RESEARCHGROUPFAVORITE APPUSERID
RESEARCHGROUPLASTVISITED APPUSERID
RESERVATIONSECURITYDEPOSITPAYMENT APPUSERID
SALESORDER APPUSERID
SALESORDERALERTEMAILADDRESS APPUSERID
SALESORDERPAYMENT APPUSERID
SIGNATURE APPUSERID
SITEPERMISSION APPUSERID
SMARTQUERYINSTANCE OWNERID
SOCIALMEDIAACCOUNT CONFIRMEDBYAPPUSERID
SOCIALMEDIAACCOUNT REJECTEDBYAPPUSERID
SOCIALMEDIATEASER ID
STANDINGORDERSIMPORTPROCESS OWNERID
STEWARDSHIPATTACHMENT ENTEREDBYAPPUSERID
STEWARDSHIPEXCHANGECALENDARITEM APPUSERID
STEWARDSHIPMEDIALINK ENTEREDBYAPPUSERID
STEWARDSHIPNOTE ENTEREDBYAPPUSERID
SYSTEMROLEAPPUSER APPUSERID
TICKETPRINTINFO APPUSERID
TOKENIZERUSERCONFIG APPUSERID
UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS BATCHOWNERID
USERPAGEHISTORY APPUSERID
USERSETTINGS APPUSERID
USERSETTINGSBATCHTEMPLATE APPUSERID
USERSETTINGSCALENDAR APPUSERID
USERSETTINGSCONSTITUENTSUMMARYTILES ID
USERSETTINGSDATAFORM APPUSERID
USERSETTINGSDATALIST APPUSERID
USERSETTINGSINFORMATIONLIBRARYHIERARCHY APPUSERID
USERSETTINGSLISTBUILDER APPUSERID
USERSETTINGSPAGE APPUSERID
USERSETTINGSSEARCHLIST APPUSERID
USERSETTINGSSEARCHLISTTASKHISTORY APPUSERID
WEALTHCAPACITYFORMULA OWNERID
WEALTHPOINTCREDENTIALS ID
WEBDASHBOARDCONTEXTRECORDHISTORY APPUSERID
WEBDASHBOARDPAGE OWNERID
WEBDASHBOARDPAGECATALOG OWNERID
WEBDASHBOARDPERSONALIZATIONPERUSER APPUSERID
WORKSTATIONCASHDRAWEROPEN APPUSERID
WPAFFLUENCEINDICATOR CONFIRMEDBYAPPUSERID
WPAFFLUENCEINDICATOR REJECTEDBYAPPUSERID
WPBIOGRAPHICAL CONFIRMEDBYAPPUSERID
WPBIOGRAPHICAL REJECTEDBYAPPUSERID
WPBIOGRAPHICALDEMOGRAPHIC CONFIRMEDBYAPPUSERID
WPBIOGRAPHICALDEMOGRAPHIC REJECTEDBYAPPUSERID
WPBUSINESSOWNERSHIP CONFIRMEDBYAPPUSERID
WPBUSINESSOWNERSHIP REJECTEDBYAPPUSERID
WPINCOMECOMPENSATION CONFIRMEDBYAPPUSERID
WPINCOMECOMPENSATION REJECTEDBYAPPUSERID
WPNONPROFITAFFILIATION CONFIRMEDBYAPPUSERID
WPNONPROFITAFFILIATION REJECTEDBYAPPUSERID
WPOTHERASSET CONFIRMEDBYAPPUSERID
WPOTHERASSET REJECTEDBYAPPUSERID
WPPHILANTHROPICGIFT CONFIRMEDBYAPPUSERID
WPPHILANTHROPICGIFT REJECTEDBYAPPUSERID
WPPOLITICALDONATION CONFIRMEDBYAPPUSERID
WPPOLITICALDONATION REJECTEDBYAPPUSERID
WPPRIVATEFOUNDATION CONFIRMEDBYAPPUSERID
WPPRIVATEFOUNDATION REJECTEDBYAPPUSERID
WPREALESTATE CONFIRMEDBYAPPUSERID
WPREALESTATE REJECTEDBYAPPUSERID
WPSEARCHHISTORY APPUSERID
WPSECURITIES CONFIRMEDBYAPPUSERID
WPSECURITIES REJECTEDBYAPPUSERID