BUSINESSPROCESSSTATUS

Contains information pertaining to the business process status information

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
STATUSCODE	tinyint		Default = 0	Stores the current status of the business process
STARTEDON	datetime			Designates the date and time that the business process was started
ERRORMESSAGE	nvarchar(max)	yes		Contains the reason why the business process could not be completed
SERVERNAME	nvarchar(255)			Contains the name of the server that the current process is running on
NUMBERPROCESSED	int	yes	Default = 0	The number of records successfully processed by the business process
NUMBEROFEXCEPTIONS	int	yes	Default = 0	The number of record exceptions found during the business process
LETTERTEMPLATE	varbinary	yes		The Letter Word file that will be used by the mail related business processes to generate the mail merge output file
LABELTEMPLATE	varbinary	yes		The Label Word file that will be used by the mail related business processes to generate the mail merge output file
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
ENDEDON	datetime	yes		Designates the date and time that the business process ended
BUSINESSPROCESSPARAMETERSETID	uniqueidentifier	yes
STATUS	nvarchar(25) (Computed)	yes		Provides a translation for the 'STATUSCODE' field.
ENQUEUEDJOBID	bigint		Default = ((0))	Designates the enqueued job ID if the process has been enqueued, else 0.
INNEREXCEPTION	nvarchar(max)	yes		Contains the inner exception reason for why the business process could not be completed

Foreign Keys

Foreign Key	Field Type	Notes	Description
BUSINESSPROCESSCATALOGID	uniqueidentifier	BUSINESSPROCESSCATALOG.ID	A foreign key to the business process catalog table
STARTEDBYUSERID	uniqueidentifier	APPUSER.ID	Designates the user that started the business process
ADDEDBYID	uniqueidentifier	CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier	CHANGEAGENT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BUSINESSPROCESSSTATUS_BUSINESSPROCESSCATALOGID	BUSINESSPROCESSCATALOGID
IX_BUSINESSPROCESSSTATUS_BUSINESSPROCESSCATALOGID_STATUSCODE	BUSINESSPROCESSCATALOGID
IX_BUSINESSPROCESSSTATUS_BUSINESSPROCESSPARAMETERSETID	BUSINESSPROCESSPARAMETERSETID
IX_BUSINESSPROCESSSTATUS_BUSINESSPROCESSPARAMETERSETID_STARTEDON	BUSINESSPROCESSPARAMETERSETID, STARTEDON
IX_BUSINESSPROCESSSTATUS_DATEADDED	DATEADDED			yes
PK_BUSINESSPROCESSSTATUS	ID	yes	yes

Triggers

Trigger Name	Description
TR_BUSINESSPROCESSSTATUS_AUDIT_UPDATE
TR_BUSINESSPROCESSSTATUS_AUDIT_DELETE

Referenced by

Referenced by	Field
ACKNOWLEDGEMENTPROCESSSTATUS	ID
ADDOPPORTUNITIESPROCESSSTATUS	ID
ADDPROSPECTPLANSPROCESSSTATUS	ID
ADDREQUESTSFORMULTIPLESTUDENTSPROCESSSTATUS	ID
ADDRESSVALIDATIONPROCESSSTATUS	ID
ADDSTEWARDSHIPPLANSPROCESSSTATUS	ID
ADDSTEWARDSHIPPLANSTEPSPROCESSSTATUS	ID
ADHOCQUERYDEPENDENCYBUSINESSPROCESSSTATUS	ID
ADHOCQUERYSTATUS	ID
ALERTTYPESTATUS	ID
ASSIGNCONSTITSECURITYATTRIBUTESPROCESSSTATUS	ID
ASSIGNLETTERCODESPROCESSSTATUS	ID
ASSIGNPLANNEDGIFTLETTERCODESPROCESSSTATUS	ID
AWARDMANAGEMENTINTEGRATIONERROR	BUSINESSPROCESSSTATUSID
AWARDMANAGEMENTINTEGRATIONPROCESSSTATUS	ID
BATCHESCOMMITPROCESSSTATUS	ID
BATCHSTATUS	ID
BBNCTRANSACTIONDOWNLOADEXCEPTIONSTATUS	ID
BILLINGGENERATETRANSACTIONSPROCESSSTATUS	ID
BUSINESSPROCESSJOBSCHEDULECONVERSIONPROCESSSTATUS	ID
BUSINESSPROCESSOUTPUT	BUSINESSPROCESSSTATUSID
BUSINESSPROCESSOUTPUTTEMPLATE	BUSINESSPROCESSSTATUSID
BUSINESSPROCESSSTATUS_EXT	ID
CLEARMATCHINGGIFTCLAIMSPROCESSSTATUS	ID
COAUPDATECREATEPROCESSSTATUS	ID
COAUPDATEGETPROCESSSTATUS	ID
COAUPDATERESUBMITPROCESSSTATUS	ID
COAUPDATESUBMITPROCESSSTATUS	ID
CONFIGURATIONEXPORTPROCESSSTATUS	ID
CONFIGURATIONIMPORTPROCESSSTATUS	ID
CONSTITUENCYREFRESHPROCESSSTATUS	ID
CONSTITUENTDUPLICATESEARCHPROCESSSTATUS	ID
CONSTITUENTMERGEPROCESSSTATUS	ID
CONSTITUENTRECOGNITIONPROCESSSTATUS	ID
CORRESPONDENCEPROCESSSTATUS	ID
CREDITCARDPROCESSINGHISTORY	BUSINESSPROCESSSTATUSID
CREDITCARDPROCESSINGSTATUS	ID
CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS	ID
DATABASEGROWTHANALYSISPROCESSSTATUS	ID
DECEASEDFINDERCREATEPROCESSSTATUS	ID
DECEASEDFINDERGETPROCESSSTATUS	ID
DECEASEDFINDERRESUBMITPROCESSSTATUS	ID
DECEASEDFINDERSUBMITPROCESSSTATUS	ID
DONORCHALLENGEENCUMBERPROCESSSTATUS	ID
EMAILFINDERGETPROCESSSTATUS	ID
EMAILFINDERRESUBMITPROCESSSTATUS	ID
EMAILFINDERSUBMITPROCESSSTATUS	ID
ETLREFRESHPROCESSSTATUS	ID
EXCHANGECALENDARSYNCSTATUS	ID
EXCHANGECONTACTSYNCSTATUS	ID
EXCHANGEDOWNLOADPROCESSSTATUS	ID
EXPORTPROCESSSTATUS	ID
FENXTSYNCPROCESSEXCEPTIONS	BUSINESSPROCESSSTATUSID
FENXTSYNCPROCESSSTATUS	ID
FEPSUBMITPROCESSSTATUS	ID
GENERATEBACSFILEPROCESSSTATUS	ID
GENERATEBATCHPROCESSCUBSTATUS	ID
GENERATEBATCHPROCESSSTATUS	ID
GENERATEEFTFILEPROCESSSTATUS	ID
GENERATESTEPUPDATEBATCHPROCESSSTATUS	ID
GENERATETRANSACTIONSPROCESSSTATUS	ID
GIFTAIDREFRESHPROCESSSTATUS	ID
GLACCOUNTMAPPINGERRORUPDATEPROCESSSTATUS	ID
GLBATCH	POSTPROCESSSTATUSID
GLOBALCHANGERECORDCOUNT	ID
GLOBALCHANGESTATUS	ID
GLPOSTPROCESSSTATUS	ID
HTMLTEMPLATETODOCXMERGEPROCESSSTATUS	ID
IMPORTPROCESSBATCH	BUSINESSPROCESSSTATUSID
IMPORTPROCESSEXCEPTION	BUSINESSPROCESSSTATUSID
IMPORTPROCESSSTATUS	ID
IMPORTSELECTIONPROCESSSTATUS	ID
INVITATIONHISTORY	BUSINESSPROCESSSTATUSID
INVITATIONSTATUS	ID
IRSFORM1099MISCPROCESSTEMPLATESTATUS	ID
KPIINSTANCESTATUS	ID
LUMINATEONLINEDATACONNECTORPARAMETERSETSTATUS	ID
MEMBERSHIPPROGRAMCONTRIBUTIONPROCESSSTATUS	ID
MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUS	ID
MKTCONSTITUENTFILEIMPORTPROCESSSTATUS	ID
MKTFINDERFILEIMPORTPROCESSSTATUS	ID
MKTMAILINGPREACTIVATIONPROCESSSTATUS	ID
MKTMEMBERSHIPMAILINGPROCESSSTATUS	ID
MKTMEMBERSHIPRENEWALEFFORTPROCESSSTATUS	ID
MKTPREACTIVATION	BUSINESSPROCESSSTATUSID
MKTSEGMENTATIONACTIVATEPROCESSSTATUS	ID
MKTSEGMENTATIONEXCLUSIONSPROCESSSTATUS	ID
MKTSEGMENTATIONEXPORTPROCESS2STATUS	ID
MKTSEGMENTATIONEXPORTPROCESSSTATUS	ID
MKTSEGMENTATIONREFRESHPROCESSSTATUS	ID
MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS	ID
MKTSEGMENTATIONSEGMENTREFRESHPROCESSSTATUS	ID
MKTSEGMENTGROUPREFRESHPROCESSSTATUS	ID
MKTSEGMENTLISTDEDUPEPROCESSSTATUS	ID
MKTSEGMENTLISTIMPORTPROCESSSTATUS	ID
MKTSEGMENTREFRESHPROCESSSTATUS	ID
MKTSEGMENTSREFRESHPROCESSSTATUS	ID
MKTSEGMENTWHITEMAILREFRESHALLPROCESSSTATUS	ID
MKTSEGMENTWHITEMAILREFRESHPROCESSSTATUS	ID
MKTSOURCEANALYSISRULESSTATUS	ID
MKTSPONSORSHIPMAILINGPROCESSSTATUS	ID
MKTUPDATEMAILINGCOUNTSPROCESSSTATUS	ID
NETCOMMUNITYTRANSACTIONPROCESSORSTATUS	ID
OLAPDATASOURCEVALIDATIONPARAMETERSSTATUS	ID
OLAPREFRESHPROCESSSTATUS	ID
PAPERLESSMANDATESINSTRUCTIONPROCESSSTATUS	ID
PEOPLEFINDERGETPROCESSSTATUS	ID
PEOPLEFINDERRESUBMITPROCESSSTATUS	ID
PEOPLEFINDERSUBMITPROCESSSTATUS	ID
PHONEFINDERGETPROCESSSTATUS	ID
PHONEFINDERRESUBMITPROCESSSTATUS	ID
PHONEFINDERSUBMITPROCESSSTATUS	ID
PLANNEDGIFTACKNOWLEDGEMENTPROCESSSTATUS	ID
PLEDGEREMINDERPROCESSSTATUS	ID
PLEDGEWRITEOFFPROCESSSTATUS	ID
POSTTOGLPROCESSSTATUS	ID
PRENOTIFICATIONPROCESSSTATUS	ID
PRINTMEMBERSHIPCARDSPROCESSSTATUS	ID
PROCESSORTRANSACTIONSETTLEMENTIMPORTSTATUS	ID
PROSPECTASSIGNMENTPROCESSSTATUS	ID
QUERYVIEWADDATTRIBUTEEXTENSIONPROCESSSTATUS	ID
QUEUEPROCESSRESULT	BUSINESSPROCESSSTATUSID
QUEUEPROCESSSTATUS	ID
R68ARCHIVEDPARAMETERS	ID
R68ONLINESUBMISSIONPARAMETERSSTATUS	ID
R68PROCESSCOMMITPARAMETERSSTATUS	ID
R68STATUS	ID
RE7ATTRIBUTEPROCESSSTATUS	ID
RECEIPTINGPROCESSSTATUS	ID
RECURRINGGIFTSTATUSUPDATEPROCESSSTATUS	ID
RESEARCHGROUPPOPULATEPROCESSSTATUS	ID
RESEARCHGROUPSTATUS	ID
REVALUECOMMITMENTSPROCESSSTATUS	ID
REVENUELIFECYCLEPROCESSSTATUS	ID
REVENUESPLITGIFTAID	PENDINGR68STATUSID
REVENUESPLITGIFTAIDREFUND	PENDINGR68STATUSID
SALESDEPOSITPROCESSSTATUS	ID
SMARTFIELDSTATUS	ID
SMARTQUERYINSTANCESTATUS	ID
SPONSORSHIPLOCATIONCLOSEPROCESSSTATUS	ID
SPONSORSHIPOPPORTUNITYRESERVEPROCESSSTATUS	ID
SPONSORSHIPOPPORTUNITYTRANSFERPROCESSSTATUS	ID
SPONSORSHIPTERMINATEPROCESSSTATUS	ID
SPONSORSHIPTRANSFERPROCESSSTATUS	ID
STANDINGORDERSEXPORTPROCESSSTATUS	ID
STANDINGORDERSIMPORTPROCESSEXCEPTION	BUSINESSPROCESSSTATUSID
STANDINGORDERSIMPORTPROCESSSTATUS	ID
STEWARDSHIPPACKAGEPROCESSHISTORY	BUSINESSPROCESSSTATUSID
STEWARDSHIPPACKAGEPROCESSSTATUS	ID
STEWARDSHIPPLANASSIGNMENTPROCESSSTATUS	ID
SURVEYDOWNLOADPROCESSSTATUS	ID
SYNCMERCHANTACCOUNTSPROCESSSTATUS	ID
TRIBUTEACKNOWLEDGEMENTPROCESSSTATUS	ID
UPDATEMULTIPLECONSTITUENTFROMMFOPROCESSSTATUS	ID
USAGEREPORTPROCESSSTATUS	ID
WEALTHPOINTSEARCHPARAMETERSSTATUS	ID
WPBATCHSCREENINGPROCESSSTATUS	ID
WPRESEARCHGROUPSEARCHPROCESSSTATUS	ID
WPSEARCHPROCESSSTATUS	ID