Attribute Name | Data Type | Description |
|---|---|---|
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:
|
IsLast6M | boolean | This flag indicates if a date is from the last 6 months. The values are:
|
IsLast30day | boolean | This flag indicates if a date is from the last 30 days. The values are:
|
IsLast7day | boolean | This flag indicates if a date is from the last 7 days. The values are:
|
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. |