Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 DESCRIPTION nvarchar(100)   Default = '' Stores the description of the state
 ABBREVIATION nvarchar(50)   Default = '' Stores the abbreviation of the state
 ACTIVE bit   Default = 1 Indicates whether or not the state is active
 SEQUENCE int   Default = 0 Stores the user-defined sequence for the state
 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.

Foreign Key Field Type Null Notes Description
 COUNTRYID uniqueidentifier   COUNTRY.LOCALID FK to COUNTRY
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_STATE_DATEADDED DATEADDED    
 IX_STATE_DATECHANGED DATECHANGED      
 IX_STATE_ID ID      
 PK_STATE ID  
 UIX_STATE_COUNTRYID_ABBREVIATION COUNTRYID, ABBREVIATION    
 UIX_STATE_COUNTRYID_DESCRIPTION COUNTRYID, DESCRIPTION    

Trigger Name Description
 TR_STATE_DELETE_BBNCCODETABLEIDMAP
 TR_STATE_INSERT_BBNCCODETABLEIDMAP
 TR_STATE_AUDIT_UPDATE
 TR_STATE_AUDIT_DELETE

Referenced by Field
 ADDRESS STATEID
 ADDRESSBOOKFAF STATEID
 ADDRESSBOOKFAF SECONDARYSTATEID
 ADVOCACY_CUSTOM STATEID
 BANKACCOUNTTRANSACTION_EXT STATEID
 BATCHADDRESSVALIDATION STATEID
 BATCHADDRESSVALIDATION NEWSTATEID
 BATCHAMPROIMPORTCONSTITUENT CONSTITUENT_UPDATEDSTATEID
 BATCHAUCTIONITEMCONSTITUENT STATEID
 BATCHCOAUPDATE STATEID
 BATCHCOAUPDATE STDSTATEID
 BATCHCOAUPDATE COASTATEID
 BATCHCONSTITUENT ADDRESS_STATEID
 BATCHCONSTITUENT PRIMARYBUSINESS_ADDRESS_STATEID
 BATCHCONSTITUENTADDRESSUPDATE STATEID
 BATCHCONSTITUENTUPDATE BUSINESS_STATEID
 BATCHCONSTITUENTUPDATEADDRESSES STATEID
 BATCHDECEASEDFINDER STATEID
 BATCHEDUCATIONALHISTORYUPDATE EDUCATIONALINSTITUTIONSTATEID
 BATCHEVENTSPONSORSHIP STATEID
 BATCHEVENTSPONSORSHIP COMPANY_STATEID
 BATCHEVENTSPONSORSHIP BILLING_STATEID
 BATCHPEOPLEFINDER NEWSTATEID
 BATCHREVENUECONSTITUENT STATEID
 BATCHSPONSORSHIPCONSTITUENT STATEID
 CONSTITUENTSOURCEANALYSISCACHEADDRESS PRIMARYSTATEID
 DECEASEDFINDERGETPROCESSDATA STATEID
 DONATIONBATCH STATEID
 DONATIONBATCH COMPANY_STATEID
 DONATIONBATCH BILLING_STATEID
 DONATIONBATCH TRIBUTESTATEID
 EVENTLOCATION STATEID
 EVENTLODGINGLOCATION STATEID
 FINANCIALINSTITUTION STATEID
 FINANCIALTRANSACTION1099DISTRIBUTION STATEID
 FINANCIALTRANSACTIONAPPLICATION1099DISTRIBUTION STATEID
 MKTFINDERNUMBERCONSTITUENT STATEID
 MKTSEED STATEID
 MKTSEGMENTPASSIVE LOCATIONSTATEID
 NAMINGOPPORTUNITYFACILITY STATEID
 ORGANIZATIONINFORMATION STATEID
 PARTIALINFORMATIONSEARCHCRITERIA STATEID
 PROSPECTSEARCH STATEID
 REGISTRANTBATCH STATEID
 REGISTRANTBATCH TRIBUTEESTATEID
 REGISTRANTBATCH BILLING_STATEID
 REGISTRANTBATCH ORGANIZATION_STATEID
 TAXID STATEID
 TRIBUTEEXTENSION TRIBUTEESTATEID
 UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH MFSTATEID
 VENDOR1099ADJUSTMENT STATEID
 VENDOR1099DISTRIBUTION STATEID
 ZIPCITYSTATE STATEID

Entity-Relationship diagram of this table (ADDRESS-CONSTITUENTSOURCEANALYSISCACHEADDRESS)
Entity-Relationship diagram of this table (COUNTRY-UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH)
Entity-Relationship diagram of this table (VENDOR1099ADJUSTMENT-ZIPCITYSTATE)