| FULLNAMEFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the full name in the source system. |
| FIRSTNAMEFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the first name in the source system. |
| MIDDLENAMEFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the middle name in the source system. |
| LASTNAMEFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the last name in the source system. |
| TITLEFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the title in the source system. |
| SUFFIXFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the suffix in the source system. |
| COUNTRYFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the country in the source system. |
| ADDRESSLINE1FIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the address line 1 in the source system. |
| ADDRESSLINE2FIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the address line 2 in the source system. |
| CITYFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the city in the source system. |
| STATEFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the state in the source system. |
| POSTCODEFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the zip in the source system. |
| CARTFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the carrier route in the source system. |
| DPCFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the DPC in the source system. |
| LOTFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the lot number in the source system. |
| PHONENUMBERFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the phone number in the source system. |
| EMAILADDRESSFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the email address in the source system. |
| FIRSTGIFTDATEFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the first gift date in the source system. |
| 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| ADDRESSLINE3FIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the address line 3 in the source system. |
| ADDRESSLINE4FIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the address line 4 in the source system. |
| ADDRESSLINE5FIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the address line 5 in the source system. |
| HOUSEHOLDIDFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the household ID in the source system. |
| HEADOFHOUSEHOLDFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the head of household in the source system. |
| DATELASTCHANGEDFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the date last changed for the donor record in the source system. |
| ADDRESSEEFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the addressee in the source system. |
| SALUTATIONFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the salutation in the source system. |
| ORGNAMEFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the organization name in the source system. |
| ISHOUSEHOLDFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the is household field in the source system. |
| TITLE2FIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the title2 in the source system. |
| SUFFIX2FIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the suffix2 in the source system. |
| LOOKUPIDFIELD |
nvarchar(255) |
|
Default = '' |
The field name from the record source that maps to the lookup ID in the source system. |