Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
ISPRIMARY | bit | Default = 0 | Indicates this address is the primary address. | |
DONOTMAIL | bit | Default = 0 | Indicates this address should not recieve mailings. | |
STARTDATE | UDT_MONTHDAY | Default = '0000' | For seasonal address types only; DD/MM start date of when this address should be considered for mailings. | |
ENDDATE | UDT_MONTHDAY | Default = '0000' | For seasonal address types only; DD/MM end date of when this address should be considered for mailings. | |
ADDRESSBLOCK | nvarchar(150) | Default = '' | Contains the address lines. | |
CITY | nvarchar(50) | Default = '' | Contains the address city. | |
POSTCODE | nvarchar(12) | Default = '' | Contains the address post code. | |
CART | nvarchar(10) | Default = '' | Contains the address carrier route (CART). | |
DPC | nvarchar(8) | Default = '' | Contains the address delivery point code | |
LOT | nvarchar(5) | Default = '' | Contains the address LOT. | |
SEQUENCE | int | Default = 0 | Stores the user-defined sequence for addresses on a constituent. | |
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. | |
DESCRIPTION | nvarchar(300) (Computed) | dbo.UFN_ADDRESS_TRANSLATE(ID) | Provides a translation field for the address record | |
HISTORICALSTARTDATE | date | Indicates the date that the constituent started using this address. | ||
HISTORICALENDDATE | date | Indicates the date that the constituent stopped using this address. | ||
ISCONFIDENTIAL | bit | Default = 0 | Indicates this address is confidential. |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
CONSTITUENTID | uniqueidentifier | CONSTITUENT.LOCALID | FK to CONSTITUENT | |
ADDRESSTYPECODEID | uniqueidentifier | ADDRESSTYPECODE.ID | FK to ADDRESSTYPECODE | |
COUNTRYID | uniqueidentifier | COUNTRY.LOCALID | FK to COUNTRY | |
STATEID | uniqueidentifier | STATE.LOCALID | FK to STATE | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
RELATIONSHIPID | uniqueidentifier | RELATIONSHIP.ID | FK to RELATIONSHIP | |
DONOTMAILREASONCODEID | uniqueidentifier | DONOTMAILREASONCODE.ID | FK to DONOTMAILREASONCODE |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_ADDRESS_CONSTITUENTID | CONSTITUENTID | |||
IX_ADDRESS_CONSTITUENTID_ISPRIMARY | CONSTITUENTID, ISPRIMARY | |||
IX_ADDRESS_DATEADDED | DATEADDED | |||
IX_ADDRESS_DATECHANGED | DATECHANGED | |||
IX_ADDRESS_DONOTMAIL_ISPRIMARY_ADDRESSTYPECODEID | DONOTMAIL, ISPRIMARY, ADDRESSTYPECODEID | |||
IX_ADDRESS_ID | ID | |||
IX_ADDRESS_POSTCODE | POSTCODE | |||
IX_ADDRESS_RELATIONSHIPID_ID | RELATIONSHIPID, ID | |||
IX_ADDRESS_STATEID | STATEID | |||
IX_ADDRESS_STATEID_ADDRESSBLOCK_CITY_POSTCODE | STATEID, ADDRESSBLOCK, CITY, POSTCODE | |||
PK_ADDRESS | ID |
Referenced by | Field |
---|---|
ADDRESSCOORDINATES | ADDRESSID |
ADDRESSVALIDATIONUPDATE | ID |
BATCHADDRESSVALIDATION | ADDRESSID |
BATCHCOAUPDATE | ADDRESSID |
BATCHCONSTITUENTADDRESSUPDATE | ADDRESSID |
BATCHCONSTITUENTUPDATEADDRESSES | ADDRESSID |
BATCHCONSTITUENTUPDATEADDRESSES | MANUALEXCEPTIONSIMILARADDRESSID |
BATCHEMAILFINDER | ADDRESSID |
BATCHEVENTSPONSORSHIP | ADDRESSID |
BATCHPEOPLEFINDER | OLDADDRESSID |
BATCHPHONEFINDER | ADDRESSID |
CREDITMEMO | REMITADDRESSID |
CREDITPAYMENTCHECKPAYMENTMETHODDETAIL | ADDRESSID |
DISBURSEMENTPROCESSDISBURSEMENT | REMITADDRESSID |
DONATIONBATCH | ADDRESSID |
INVOICE | REMITADDRESSID |
MAILPREFERENCE | ADDRESSID |
MAILPREFERENCEGROUPCONTACT | ADDRESSID |
PLANNEDGIFTADDITIONASSET | ADDRESSID |
PLANNEDGIFTASSET | ADDRESSID |
REGISTRANTBATCH | ADDRESSID |
SALESORDER | ADDRESSID |
VENDOR | REMITADDRESSID |
VENDOR1099SETTING | ADDRESSID |
Entity-Relationship diagram of this table (MAILPREFERENCE-VENDOR1099SETTING)