| ID | int | The unique identifier of the customer record in CDP. |
| DateInUnix | timestamp | The date in the UNIX format. |
| Year | int | The year in the timestamp. |
| QuarterNumber | int | The number of the quarter in the year. |
| QuarterName | string | The name of the quarter. |
| MonthNumber | int | The number of the month in the year. |
| MonthName | string | The name of the month. |
| MonthDayNumber | int | The number of the day in a month. |
| WeekDayName | string | The number of the day in a month. |
| YearWeekNumber | int | The number of the week in the year. |
| IsLast12M | boolean | This flag indicates if a date is from the last 12 months. The values are: - True for the dates within the last 12 months.
- False for the dates which are not from the last 12 months.
|
| IsLast6M | boolean | This flag indicates if a date is from the last 6 months. The values are: - True for the dates within the last 6 months.
- False for the dates which are not from the last 6 months.
|
| IsLast30day | boolean | This flag indicates if a date is from the last 30 days. The values are: - True for the dates within the last 30 days.
- False for the dates which are not from the last 30 days.
|
| IsLast7day | boolean | This flag indicates if a date is from the last 7 days. The values are: - True for the dates within the last 7 days.
- False for the dates which are not from the last 7 days.
|
| SpecialDayName | string | The name of the special day. |
| IsSpecialDay | string | This flag indicates if a day is a special day. It has Yes or No value. |
| IsOfficialHoliday | string | This flag indicates if a day is an official holiday. It has Yes or No value. |
| IsWeekend | string | This flag indicates if a day is a weekend. It has Yes or No value. |
| FiscalYear | int | A one year period that companies and governments use for financial reporting and budgeting. |
| FiscalQuarter | int | A three month period in which a company reports its financial results. |
| FiscalMonth | int | Any fiscal month of a fiscal year. |
| FiscalWeek | int | Seven days accounting period that is defined by the business. |
| RowCreated | timestamp | The time when the promotion record was created. |
| RowModified | timestamp | The time when the promotion record was last modified. |
| Batch | string | When the customer record was last modified in CDP. This is used for bucketing the ingestion of records into CDP. |
Acquia CDP