Warehouse table: Races

The Races warehouse table corresponds to the A422_Ethnicity view in the CRM database.

Race records are joined to parent records by the PersonGUID.

This table is available in version Stage IIa and up.

 

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

 

ColumnCRM viewCRM columnNotesStandard Export nameType
RaceGUIDA422_ethnicitya422_ethnicityidprimary key uniqueidentifier
PersonGUIDA422_ethnicitya422_rel_personid uniqueidentifier
RaceCategoryA422_ethnicitya422_rel_ethnicitycategoryidname 
nvarchar(100)
RaceCategoryGUIDA422_ethnicitya422_rel_ethnicitycategoryid uniqueidentifier
RaceValueA422_ethnicitya422_rel_ethnicityvalueidname Race_0N_Valuenvarchar(100)
RaceValueGUIDA422_ethnicitya422_rel_ethnicityvalueid uniqueidentifier
createdbyA422_ethnicitycreatedby uniqueidentifier
createdbynameA422_ethnicitycreatedbyname nvarchar(160)
createdonutcA422_ethnicitycreatedonutc datetime
modifiedbyA422_ethnicitymodifiedby uniqueidentifier
modifiedbynameA422_ethnicitymodifiedbyname nvarchar(160)
modifiedonutcA422_ethnicitymodifiedonutc datetime
statecodeA422_ethnicitystatecode int
statecodenameFilteredA422_ethnicitystatecodename nvarchar(255)
statuscodeA422_ethnicitystatuscode int
statuscodenameFilteredA422_ethnicitystatuscodename nvarchar(255)
ordinaln/an/asort order int

 


Comments