| ADDRESSSTANDARDIZATIONENABLED |
bit |
|
Default = 0 |
|
| FIELDCAPITALIZATIONENABLED |
bit |
|
Default = 0 |
|
| DATEADDED |
datetime |
|
Default = getdate() |
|
| DATECHANGED |
datetime |
|
Default = getdate() |
|
| TS |
timestamp |
|
|
|
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
|
| DIFFERENTPHONECODE |
tinyint |
|
Default = 3 |
|
| NEWPHONEENDDATECODE |
tinyint |
|
Default = 0 |
|
| NEWPHONEPRIMARYCODE |
tinyint |
|
Default = 1 |
|
| DIFFERENTEMAILCODE |
tinyint |
|
Default = 3 |
|
| NEWEMAILENDDATECODE |
tinyint |
|
Default = 0 |
|
| NEWEMAILPRIMARYCODE |
tinyint |
|
Default = 1 |
|
| DIFFERENTEMAIL |
nvarchar(42) (Computed) |
yes |
CASE [DIFFERENTEMAILCODE] WHEN 0 THEN N'Ignore email address' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add as new email address' END |
|
| CREATEHISTORICALNAMECODE |
tinyint |
|
Default = 1 |
|
| CREATEHISTORICALNAME |
nvarchar(3) (Computed) |
yes |
CASE [CREATEHISTORICALNAMECODE] WHEN 0 THEN N'No' WHEN 1 THEN N'Yes' END |
|
| NAMECODE |
tinyint |
|
Default = 1 |
|
| SIMILARADDRESSCODE |
tinyint |
|
Default = 3 |
|
| UNSIMILARADDRESSCODE |
tinyint |
|
Default = 3 |
|
| UNSIMILARADDRESS |
nvarchar(42) (Computed) |
yes |
CASE [UNSIMILARADDRESSCODE] WHEN 0 THEN N'Ignore address' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add as new address' END |
|
| NEWADDRESSENDDATECODE |
tinyint |
|
Default = 0 |
|
| NEWADDRESSPRIMARYCODE |
tinyint |
|
Default = 1 |
|
| BIRTHDATERULECODE |
tinyint |
|
Default = 1 |
|
| NAME |
nvarchar(42) (Computed) |
yes |
CASE [NAMECODE] WHEN 0 THEN N'Ignore name' WHEN 1 THEN N'Update name' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add name as an alias' END |
|
| SIMILARADDRESS |
nvarchar(63) (Computed) |
yes |
CASE [SIMILARADDRESSCODE] WHEN 0 THEN N'Ignore address' WHEN 1 THEN N'Update existing address (old address data will not be retained)' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add as new address' END |
|
| NEWADDRESSENDDATE |
nvarchar(30) (Computed) |
yes |
CASE [NEWADDRESSENDDATECODE] WHEN 0 THEN N'Make existing address inactive' WHEN 1 THEN N'Keep existing address active' END |
|
| NEWADDRESSPRIMARY |
nvarchar(61) (Computed) |
yes |
CASE [NEWADDRESSPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary address has the same address type' WHEN 2 THEN N'Always' END |
|
| DIFFERENTPHONE |
nvarchar(42) (Computed) |
yes |
CASE [DIFFERENTPHONECODE] WHEN 0 THEN N'Ignore phone' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add as new phone' END |
|
| NEWPHONEENDDATE |
nvarchar(28) (Computed) |
yes |
CASE [NEWPHONEENDDATECODE] WHEN 0 THEN N'Make existing phone inactive' WHEN 1 THEN N'Keep existing phone active' END |
|
| NEWPHONEPRIMARY |
nvarchar(57) (Computed) |
yes |
CASE [NEWPHONEPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary phone has the same phone type' WHEN 2 THEN N'Always' END |
|
| NEWEMAILENDDATE |
nvarchar(36) (Computed) |
yes |
CASE [NEWEMAILENDDATECODE] WHEN 0 THEN N'Make existing email address inactive' WHEN 1 THEN N'Keep existing email address active' END |
|
| NEWEMAILPRIMARY |
nvarchar(65) (Computed) |
yes |
CASE [NEWEMAILPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary email address has the same email type' WHEN 2 THEN N'Always' END |
|
| BIRTHDATERULE |
nvarchar(17) (Computed) |
yes |
CASE [BIRTHDATERULECODE] WHEN 0 THEN N'Ignore birth date' WHEN 1 THEN N'Update birth date' END |
|