| ID | string | The unique identifier of the customer. |
| TenantID | int | The unique identifier of the client environment. |
| SourceSystemID | string | The unique identifier of the upstream source system. |
| SourceCustomerNumber | string | The unique identifier of the customer in your data. |
| UUID | string | Universally Unique Identifier (UUID) is a 128-bit label used for information in computer systems. |
| SourceAccountNumber | string | The account number of the source. |
| AccountID | string | The unique identifier of the account. |
| FirstName | string | The customer’s first name. If you have the customer’s full name, specify the full name in this field and leave the other name fields empty. |
| MiddleName | string | The customer’s middle name. |
| LastName | string | The customer’s last name. |
| Title | string | The customer’s title. |
| Sal | string | The customer’s salary. |
| Company | string | The customer’s company. |
| Email | string | The customer’s email address. |
| PrimaryPhone | string | The customer’s primary phone number. |
| SecondaryPhone | string | The customer’s secondary phone number. |
| Cookie | string | The unique identifier of the person triggering the event. For web or app-related events, use an actual cookieID or mobiledeviceID of the visitor, prefixed with an indication of the source system. This attribute is used only for web or app-related events. |
| State | string | The state or province where the customer is located. |
| Preferences | string | A combination of the individual preference columns, such as DoNotCall, DoNotEmail. Each value is separated by &. For example, DNC=Y&DNE=N. |
| BirthYear | int | The birth year of the customer. |
| BirthMonth | int | The birth month of the customer. |
| BirthDay | int | The birthday of the customer. |
| BirthDate | timestamp | The date of birth of the customer. |
| Age | int | The age of the customer. |
| DateCreated | timestamp | The date when the record was created. |
| DateModified | timestamp | The date when the record was updated. |
| DeleteFlag | boolean | The flag that indicates if a customer record is deleted. The possible values are: True when a customer record is deletedFalse or null when a customer record is not deleted
|
| RowCreated | timestamp | The time when the customer record was first ingested in CDP. |
| RowModified | timestamp | The time when the customer record was last modified in CDP. |
| Batch | string | The time when the customer record was last modified in CDP. This is used for bucketing the ingestion of records in CDP. |
| EmailStatus | string | The validity of the email address of your customers. The possible values are: V stands for Verified and indicates that the syntax is valid, the domain is good or known, and the email address is not a known spam trap.U stands for Unverified and indicates that the syntax is valid, but the domain is unknown or bad.X stands for Invalid and indicates that the syntax is invalid.Unknown indicates that no email address was provided.
|
| Gender | string | The customer’s gender. The possible values are: M for MaleF for FemaleU for any other values
If a gender is not provided, but a gendered first name is provided, Acquia CDP assigns the gender based on the first name. |
| MobilePhone | string | The customer’s mobile phone number. |
| MobileAdvertisingId | string | The unique advertising identifier for the customer’s mobile device. This can be the iOS IDFA or Android’s Google Advertising Id. |
| MobileDeviceId | string | The unique identifier for the customer’s mobile device. This can be the iOS IDFV or Android Device Id. |
| NameCodes | string | The Melissa result code system to indicate data quality when validating customers. This also indicates status and any errors. These codes are four-character codes, where two letters are followed by two numbers, and are delimited by commas. For example, NS01,NS03. |
| DoNotEmail | string | The subscription (glossary term, activate to view definition) preference of the customer for email campaigns. The possible values are: Y: You must not send emails to the customer (opted-out).N: You can send emails (opted-in).U or empty: You do not have specific information.
|
| DoNotCall | string | The subscription preference of the customer for phone campaigns. The possible values are: Y: You must not make calls to the customer (opted-out).N: You can call the customer (opted-in).U or empty: You do not have specific information.
|
| DoNotText | string | The subscription preference of the customer for text or SMS campaigns. The possible values are: Y: You must not send any text or SMS to the customer (opted-out).N: You can send a text or SMS to the customer (opted-in).U or empty: You do not have specific information.
|
| DoNotMail | string | The subscription preference of the customer for direct, postal mailing campaigns. The possible values are: Y: You must not send any postal campaign to the customer (opted-out).N: You can send a direct mail to the customer (opted-in).U` or empty: You do not have specific information.
|
| PrimaryPhoneValidity | string | It is returned by Melissa during customer validation to indicate primary phone validity. Possible values are V, X, and Unidentified. By default, phone validation is turned-off. |
| SecondaryPhoneValidity | string | It is returned by Melissa during customer validation to indicate secondary phone validity. Possible values are V, X, and Unidentified. By default, phone validation is turned-off. |
| MobilePhoneValidity | string | It is returned by Melissa during customer validation to indicate mobile phone validity. Possible values are V, X, and Unidentified. By default, phone validation is turned-off. |
| Source | string | The last file origin that modified the customer record. |
| PhoneValidationResultCodes | string | The Melissa result code system that indicates phone validation quality when validating customers. |
| RowProcessed | timestamp | The date when the customer record was last processed by CDP. |