Cc Dim Date DMO

This DMO contains various attributes related to dates, providing detailed temporal information. Each record represents a calendar date and its component parts (year, quarter, month, week, day).

Object API Name: std__CcDimDateDmo__dlm
Category: Unassigned
Availability: Available in 260 and later versions
Primary Key Field: Id

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• DayDisplayName
• DayOfMonth
• DayOfWeek
• DayOfWeekLong
• DayOfWeekShort
• DayOfYear
• DayTimestamp
• Id
• InternalOrganizationId
• MonthDisplayName
• MonthId
• MonthOfYear
• MonthOfYearLong
• MonthOfYearShort
• MonthTimestamp
• QuarterDisplayName
• QuarterId
• QuarterLong
• QuarterOfYear
• QuarterShort
• QuarterTimestamp
• WeekDisplayName
• WeekId
• WeekOfYear
• WeekOfYearLong
• WeekOfYearShort
• WeekTimestamp
• WeekYearDisplayName
• WeekYearId
• WeekYearOfEra
• WeekYearTimestamp
• YearDisplayName
• YearId
• YearOfEra
• YearTimestamp

• Field API Name: std__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: std__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DayDisplayName__c
• Data Type: TEXT
• Description: User-friendly display name for the day.

• Field API Name: std__DayOfMonth__c
• Data Type: DOUBLE
• Description: Day number within the month (1-31).

• Field API Name: std__DayOfWeek__c
• Data Type: DOUBLE
• Description: Day number within the week (for example, 1 for Monday).

• Field API Name: std__DayOfWeekLong__c
• Data Type: TEXT
• Description: Long name for the day of the week (for example, "Monday").

• Field API Name: std__DayOfWeekShort__c
• Data Type: TEXT
• Description: Short name for the day of the week (for example, "Mon").

• Field API Name: std__DayOfYear__c
• Data Type: DOUBLE
• Description: Day number within the year (1-366).

• Field API Name: std__DayTimestamp__c
• Data Type: DATEONLY
• Description: Timestamp representing the start of the day.

• Field API Name: std__Id__c
• Data Type: DOUBLE
• Description: Unique identifier for a specific day.

• Field API Name: std__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__MonthDisplayName__c
• Data Type: TEXT
• Description: User-friendly display name for the month (for example, 'January')

• Field API Name: std__MonthId__c
• Data Type: DOUBLE
• Description: Unique identifier for a specific month.

• Field API Name: std__MonthOfYear__c
• Data Type: DOUBLE
• Description: Month number within the year (1-12).

• Field API Name: std__MonthOfYearLong__c
• Data Type: TEXT
• Description: Long representation of the month of the year (for example, 'Jan').

• Field API Name: std__MonthOfYearShort__c
• Data Type: TEXT
• Description: Short representation of the month of the year.

• Field API Name: std__MonthTimestamp__c
• Data Type: DATEONLY
• Description: Timestamp representing the start of the month.

• Field API Name: std__QuarterDisplayName__c
• Data Type: TEXT
• Description: User-friendly display name for the quarter

• Field API Name: std__QuarterId__c
• Data Type: DOUBLE
• Description: Unique identifier for a specific quarter.

• Field API Name: std__QuarterLong__c
• Data Type: TEXT
• Description: Long representation of the quarter.

• Field API Name: std__QuarterOfYear__c
• Data Type: DOUBLE
• Description: Quarter number within the year (1-4).

• Field API Name: std__QuarterShort__c
• Data Type: TEXT
• Description: Short representation of the quarter.

• Field API Name: std__QuarterTimestamp__c
• Data Type: DATEONLY
• Description: Timestamp representing the start of the quarter.

• Field API Name: std__WeekDisplayName__c
• Data Type: TEXT
• Description: User-friendly display name for the week.

• Field API Name: std__WeekId__c
• Data Type: DOUBLE
• Description: Unique identifier for a specific week.

• Field API Name: std__WeekOfYear__c
• Data Type: DOUBLE
• Description: Week number within the year (1-53).

• Field API Name: std__WeekOfYearLong__c
• Data Type: TEXT
• Description: Long representation of the week of the year.

• Field API Name: std__WeekOfYearShort__c
• Data Type: TEXT
• Description: Short representation of the week of the year.

• Field API Name: std__WeekTimestamp__c
• Data Type: DATEONLY
• Description: Timestamp representing the start of the week.

• Field API Name: std__WeekYearDisplayName__c
• Data Type: TEXT
• Description: User-friendly display name for the week-year.

• Field API Name: std__WeekYearId__c
• Data Type: DOUBLE
• Description: Unique identifier for a specific week-year.

• Field API Name: std__WeekYearOfEra__c
• Data Type: DOUBLE
• Description: Week-year number within its era.

• Field API Name: std__WeekYearTimestamp__c
• Data Type: DATEONLY
• Description: Timestamp representing the start of the week-year.

• Field API Name: std__YearDisplayName__c
• Data Type: TEXT
• Description: User-friendly display name for the year.

• Field API Name: std__YearId__c
• Data Type: DOUBLE
• Description: Unique identifier for a specific year.

• Field API Name: std__YearOfEra__c
• Data Type: DOUBLE
• Description: Year number within its era.

• Field API Name: std__YearTimestamp__c
• Data Type: DATEONLY
• Description: Timestamp representing the start of the year.