Warehouse table: Addresses

The Addresses warehouse table corresponds to the CustomerAddress view in the CRM database.

Award records are joined to parent records by the PersonGUID. 

 

This table is made available to clients via the Advanced Export as Addresses_Local.

 

This table is first available in the Stage III warehouse.

 


Warehouse columnCRM columnNotesStandard Export nameField type
AddressGUIDaddressidprimary key uniqueidentifier
PersonGUIDparentidjoin field uniqueidentifier
AddressNumberaddressnumber1 = primary (exported as active); 3+ = secondaryAddress_0N_Activeint
Namename Address_0N_Namenvarchar(200)
PermAddressaddresstypecode Address_0N_PermAddressbit
Street1line1 Address_0N_Street1nvarchar(200)
Street2line2
Address_0N_Street2nvarchar(200)
Street3line3
Address_0N_Street3nvarchar(200)
Citycity
Address_0N_Citynvarchar(100)
Countycounty
Address_0N_Countynvarchar(100)
StateProvincestateorprovince
Address_0N_StateProvincenvarchar(100)
CountryRegioncountry
Address_0N_CountryRegionnvarchar(100)
PostalCodepostalcode
Address_0N_PostalCodenvarchar(10)
Latitudelatitude

float
Longitudelongitude

float
GeoMarketa422_geomarket

nvarchar(100)
CensusTracta422_censustractavailable in schema 3.1
nvarchar(100)
createdbycreatedby  uniqueidentifier
createdbynamecreatedbyname  nvarchar(160)
createdonutccreatedonutc  datetime
modifiedbymodifiedby  uniqueidentifier
modifiedbynamemodifiedbyname  nvarchar(160)
modifiedonutcmodifiedonutc 
datetime
EffectiveDaten/adate on which record changed in CRM
datetime
IsCurrentn/aflags current records
bit
ordinaln/asort order
int

 

 


Comments