Warehouse table: Ids

The Ids warehouse table corresponds to the A422_Ids view in the CRM database.

Id 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
IdGUIDA422_idsa422_idsidprimary key uniqueidentifier
PersonGUIDA422_idsa422_rel_personid uniqueidentifier
IdTypeA422_idsa422_rel_idnameidname ID_0N_Typenvarchar(100)
IdTypeGUIDA422_idsa422_rel_idnameid uniqueidentifier
IdValueA422_idsa422_idvalue ID_0N_Valuenvarchar(100)
DisplayOrderA422_dom_idnamea422_displayorder int
createdbyA422_idscreatedby uniqueidentifier
createdbynameA422_idscreatedbyname nvarchar(160)
createdonutcA422_idscreatedonutc datetime
modifiedbyA422_idsmodifiedby uniqueidentifier
modifiedbynameA422_idsmodifiedbyname nvarchar(160)
modifiedonutcA422_idsmodifiedonutc datetime
statecodeA422_idsstatecode int
statecodenameFilteredA422_idsstatecodename nvarchar(255)
statuscodeA422_idsstatuscode int
statuscodenameFilteredA422_idsstatuscodename nvarchar(255)
ordinaln/an/asort order int

 


Comments