AccountDimension | |||
| Column Name | Azure Type | Snowflake Type | Description |
|---|---|---|---|
| ad_id | int | NUMBER(38,0) | Primary key |
| ad_accountId | varchar(16) | VARCHAR(16) | The account unique identifier |
| ad_parentAccount | varchar(16) | VARCHAR(16) | The parent account identifier |
| ad_name | varchar(64) | VARCHAR(64) | Account name |
| ad_broadsoftEnterpriseId | varchar(64) | VARCHAR(64) | The VoIP platform identifier |
| ad_country | varchar(64) | VARCHAR(64) | The origin country of the account |
| ad_currency | varchar(3) | VARCHAR(3) | The currency used for the account |
| ad_customerStartDate | datetime2(7) | TIMESTAMP_NTZ(9) | The customer start date. |
| ad_eccAccount | bit (1=true/0=false) | BOOLEAN | Is ECC account flag |
| ad_marketSegment | varchar(16) | VARCHAR(16) | Market segment |
| ad_mrcBillCycle | varchar(2) | VARCHAR(2) | The MRC billing cycle |
| ad_npaNxx | varchar(6) | VARCHAR(6) | The area code (NPA) and exchange (NXX) used for taxation |
| ad_nrcBillCycle | varchar(2) | VARCHAR(2) | The NRC billing cycle |
| ad_releasedMRR | decimal(18, 4) | NUMBER(18,4) | The Released Monthly Recurring Revenue |
| ad_serviceWindowStartDay | varchar(2) | VARCHAR(2) | The day in month that the service window start day has started |
| ad_state | varchar(2) | VARCHAR(2) | The state associated with the account if applicable |
| ad_status | varchar(8) | VARCHAR(8) | Indicates if the status of the account is active or not active |
| ad_type | varchar(16) | VARCHAR(16) | The account type. Possible values:
|
| ad_zipCode | varchar(16) | VARCHAR(16) | The zip code associated with the account |
| ad_isCountyTaxExempt | bit (1=true/0=false) | BOOLEAN | County tax exempt flag |
| ad_isCriticalAccount | bit (1=true/0=false) | BOOLEAN | Critical customer flag |
| ad_isFederalTaxExempt | bit (1=true/0=false) | BOOLEAN | Federal tax exempt flag |
| ad_isStateTaxExempt | bit (1=true/0=false) | BOOLEAN | State tax exempt flag |
| ad_isSuppressAdminFee | bit (1=true/0=false) | BOOLEAN | Suppress Admin Fee Flag |
AccountGroupDimension | |||
| Column Name | Data Type | Snowflake Type | Description |
| agd_id | int | NUMBER(38,0) | Primary key |
| agd_accountGroupId | varchar(16) | VARCHAR(16) | Account group identifier |
| agd_description | varchar(128) | VARCHAR(128) | Account group description |
| agd_type | varchar(16) | VARCHAR(16) | The account group type. Possible values:
|
BroadsoftUserDimension | |||
| Column Name | Data Type | Snowflake Type | Description |
| bud_id | int | NUMBER(38,0) | Primary key |
| bud_broadsoftUserId | varchar(161) | VARCHAR(161) | Identifier of the broadsoft user |
| bud_broadsoftUserDisplayName | varchar(100) | VARCHAR(100) | The display name of the broadsoft user. |
| bud_broadsoftEntepriseId | varchar(64) | VARCHAR(64) | The VoIP platform identifier |
| bud_broadsoftGroupId | varchar(64) | VARCHAR(64) | Broadsoft user group identifier |
| bud_broadsoftDepartment | varchar(64) | VARCHAR(64) | Broadsoft user department |
| bud_broadsoftLanguage | varchar(64) | VARCHAR(64) | Broadsoft user language |
| bud_broadsoftTimezone | varchar(32) | VARCHAR(32) | Time zone |
| bud_broadsoftSystemName | varchar(128) | VARCHAR(128) | Broadsoft user system name |
| bud_accountId | varchar(16) | VARCHAR(16) | Identifier of the account |
| bud_externalReferenceChar | varchar(64) | VARCHAR(64) | External reference character |
| bud_externalReferenceNum | bigint | NUMBER(38,0) | External reference number |
| bud_locationId | varchar(64) | VARCHAR(64) | Identifier of the location |
| bud_broadsoftFQUserId | varchar(161) | VARCHAR(161) | Identifier of the broadsoft fully qualified user |
| bud_lastUpdateTimestamp | datetime2(7) | TIMESTAMP_NTZ(9) | Broadsoft user last update timestamp |
| bud_parentEipId | varchar(16) | VARCHAR(16) | The account identifier |
| bud_entryTimestamp | datetime2(7) | TIMESTAMP_NTZ(9) | The time in which the broadsoft user has been added. |
| bud_userCategory | varchar(16) | VARCHAR(16) | User category type. Possib;e values:
|
CountryDimension | |||
| Column Name | Data Type | Snowflake Type | Description |
| cd_dialCountryCode | int | NUMBER(38,0) | The country dial code |
| cd_displayName | varchar(64) | VARCHAR(64) | The country display name |
| cd_officialName | varchar(64) | VARCHAR(64) | The country official name |
| cd_capital | varchar(48) | VARCHAR(48) | The capital |
| cd_continent | varchar(2) | VARCHAR(2) | Continent |
| cd_currencyAlphaCode | varchar(3) | VARCHAR(3) | The currency alpha code |
| cd_currencyCountryName | varchar(64) | VARCHAR(64) | The currency country name |
| cd_currencyName | varchar(64) | VARCHAR(64) | The currency name |
| cd_intermediateRegionName | varchar(64) | VARCHAR(64) | Intermediate regional name |
| cd_iso3166Aplha2 | varchar(2) | VARCHAR(2) | The ISO 3166 Alpha2 code |
| cd_iso3166Aplha3 | varchar(3) | VARCHAR(3) | The ISO 3166 Alpha3 code |
| cd_languages | varchar(128) | VARCHAR(128) | Country language codes represented in a semicolon separated list |
| cd_regionCode | int | NUMBER(38,0) | Region code |
| cd_regionName | varchar(16) | VARCHAR(16) | Region Name |
| cd_subRegionCode | int | NUMBER(38,0) | Sub region code |
| cd_subRegionName | varchar(32) | VARCHAR(32) | Sub region name |
| cd_topLevelDomain | varchar(3) | VARCHAR(3) | The top level domain |
| cd_unTermName | varchar(64) | VARCHAR(64) | The country UNTERM name |
| cd_unTermShortName | varchar(64) | VARCHAR(64) | The country UNTERM short name |
DateDimension | |||
| Column Name | Data Type | Snowflake Type | Description |
| dd_date | int | NUMBER(38,0) | Primary key represents the date (in the format of 'YYYYMMDD', For example: 20200101) |
| dd_day | int | NUMBER(38,0) | The day in month numbering |
| dd_dayNameLong | varchar(9) | VARCHAR(9) | The day name |
| dd_dayNameShort | char(3) | VARCHAR(3) | The day short name |
| dd_dayOfQuarter | int | NUMBER(38,0) | The day of quarter numbering |
| dd_dayOfWeekISO | int | NUMBER(38,0) | ISO day of week numbering |
| dd_dayOfWeekInMonth | int | NUMBER(38,0) | The day of week in a month |
| dd_dayOfWeekInYear | int | NUMBER(38,0) | The day of week in a year |
| dd_dayOfWeekUSA | int | NUMBER(38,0) | USA day of week numbering |
| dd_dayOfYear | int | NUMBER(38,0) | The number of day in year |
| dd_daysInMonth | int | NUMBER(38,0) | The number of days in a month |
| dd_daysInQuarter | int | NUMBER(38,0) | The number of days in a quarter |
| dd_daysInYear | int | NUMBER(38,0) | The number of days in a year |
| dd_firstDayOfMonth | int | NUMBER(38,0) | First day of month (in a format of 'YYYYMMDD') |
| dd_firstDayOfQuarter | int | NUMBER(38,0) | First day of quarter (in a format of 'YYYYMMDD') |
| dd_firstDayOfWeekISO | int | NUMBER(38,0) | ISO first day of week (in a format of 'YYYYMMDD') |
| dd_firstDayOfWeekUSA | int | NUMBER(38,0) | USA first day of week (in a format of 'YYYYMMDD') |
| dd_firstDayOfYear | int | NUMBER(38,0) | The first day of year (in a format of 'YYYYMMDD') |
| dd_holidayOther | int | NUMBER(38,0) | Future use |
| dd_holidayUSA | int | NUMBER(38,0) | Future use |
| dd_lastDayOfMonth | int | NUMBER(38,0) | Last day of month (in a format of 'YYYYMMDD') |
| dd_lastDayOfQuarter | int | NUMBER(38,0) | Last day of quarter (in a format of 'YYYYMMDD') |
| dd_lastDayOfWeekISO | int | NUMBER(38,0) | ISO last day of week (in a format of 'YYYYMMDD') |
| dd_lastDayOfWeekUSA | int | NUMBER(38,0) | USA last day of week (in a format of 'YYYYMMDD') |
| dd_lastDayOfYear | int | NUMBER(38,0) | The last day of the year (in a format of 'YYYYMMDD') |
| dd_month | int | NUMBER(38,0) | Month number |
| dd_monthNameLong | varchar(9) | VARCHAR(9) | Long month name |
| dd_monthNameShort | char(3) | VARCHAR(3) | Short month name |
| dd_monthOfQuarter | int | NUMBER(38,0) | The month of quarter numbering. |
| dd_quarter | int | NUMBER(38,0) | The number of quarter within the year (1-4) |
| dd_weekOfMonthISO | int | NUMBER(38,0) | The ISO week of month numbering |
| dd_weekOfMonthUSA | int | NUMBER(38,0) | The USA week of month numbering |
| dd_weekOfQuarterISO | int | NUMBER(38,0) | The ISO week of quarter numbering |
| dd_weekOfQuarterUSA | int | NUMBER(38,0) | The USA week of quarter numbering |
| dd_weekOfYearISO | int | NUMBER(38,0) | The ISO week numbering year |
| dd_weekOfYearUSA | int | NUMBER(38,0) | The USA week numbering year |
| dd_year | int | NUMBER(38,0) | Represents the year |
| dd_yearAndMonth | int | NUMBER(38,0) | Represents the year and month in a format of 'YYYYMM' |
| dd_isHolidayOther | bit (1=true/0=false) | BOOLEAN | Is other holiday flag |
| dd_isHolidayUSA | bit (1=true/0=false) | BOOLEAN | Is USA holiday flag |
| dd_isLeapYear | bit (1=true/0=false) | BOOLEAN | Is leap year flag |
| dd_isWeekDay | bit (1=true/0=false) | BOOLEAN | Is week day flag |
| dd_dateAsDate | date | DATE | Date representation as date in the format of (YYYY-MM-DD) |
LocationDimension | |||
| Column Name | Data Type | Snowflake Type | Description |
| lcd_id | int | NUMBER(38,0) | Primary key |
| lcd_location | varchar(16) | VARCHAR(16) | Location identifier |
| lcd_accountId | varchar(16) | VARCHAR(16) | Account identifier associated with the location |
| lcd_addressCode | varchar(16) | VARCHAR(16) | Address code |
| lcd_billingLocationName | varchar(128) | VARCHAR(128) | Billing location name |
| lcd_city | varchar(64) | VARCHAR(64) | City |
| lcd_country | varchar(16) | VARCHAR(16) | Country |
| lcd_description | varchar(256) | VARCHAR(256) | Location description |
| lcd_isDefault | bit (1=true/0=false) | BOOLEAN | Default flag |
| lcd_isDisabled | bit (1=true/0=false) | BOOLEAN | Disable/Enabled flag |
| lcd_isRepairFacility | bit (1=true/0=false) | BOOLEAN | Repair facility flag |
| lcd_orgId | varchar(16) | VARCHAR(16) | Organization identifier |
| lcd_postalCode | varchar(16) | VARCHAR(16) | ZIP/Postal code |
| lcd_serviceAddressCode | varchar(16) | VARCHAR(16) | Service address code |
| lcd_shipToAddressCode | varchar(16) | VARCHAR(16) | Ship to address code |
| lcd_siteId | varchar(16) | VARCHAR(16) | The site identifier associated with the location |
| lcd_stateProvince | varchar(16) | VARCHAR(16) | The state/province of the location |
| lcd_status | varchar(16) | VARCHAR(16) | Location status. For example: ACTIVE, INACTIVE, 120 Active, OPERATING, 150 Idle |
| lcd_streetAddress | varchar(256) | VARCHAR(256) | The physical street address associated with the location |
| lcd_streetAddress2 | varchar(256) | VARCHAR(256) | Second street address |
| lcd_type | varchar(16) | VARCHAR(16) | Location type. For example: HOLDING, SALVAGE, OPERATING, STOREROOM |
| lcd_parentEipId | varchar(16) | VARCHAR(16) | Parent account identifier |
| lcd_locationName | varchar(64) | VARCHAR(64) | Location name |
ProductDimension | |||
| Column Name | Data Type | Snowflake Type | Description |
| pd_id | int | NUMBER(38,0) | Primary key |
| pd_productCode | varchar(64) | VARCHAR(64) | Product code |
| pd_uniqueProductCode | varchar(64) | VARCHAR(64) | The unique product code |
| pd_currencyIsoCode | varchar(3) | VARCHAR(3) | The currency ISO code |
| pd_isProductRequiringApproval | bit (1=true/0=false) | BOOLEAN | Product Requiring Approval flag |
| pd_isStandardPriceBook | bit (1=true/0=false) | BOOLEAN | Standard price book flag |
| pd_isUseStandardPrice | bit (1=true/0=false) | BOOLEAN | Standard price use flag |
| pd_partnerDiscountFromRetail | decimal(12, 2) | NUMBER(12,2) | Partner discount from retail |
| pd_pointInTimeRetailPrice | decimal(12, 2) | NUMBER(12,2) | Point in time retail price |
| pd_priceBookDescription | varchar(256) | VARCHAR(256) | Price book description |
| pd_priceBookName | varchar(64) | VARCHAR(64) | Price book name |
| pd_priceOverride | decimal(12, 2) | NUMBER(12,2) | Price override |
| pd_productCategory | varchar(32) | VARCHAR(32) | Product category |
| pd_productCount | decimal(12, 2) | NUMBER(12,2) | Product count |
| pd_productName | varchar(128) | VARCHAR(128) | Product name |
| pd_proposalGrouping | varchar(32) | VARCHAR(32) | Proposal grouping |
| pd_revenueType | varchar(8) | VARCHAR(8) | The revenue type |
| pd_stage | varchar(32) | VARCHAR(32) | Product stage |
| pd_subFamily | varchar(64) | VARCHAR(64) | Product sub family |
| pd_taxServiceType | varchar(4) | VARCHAR(4) | Product tax service type |
| pd_taxTransactionType | varchar(4) | VARCHAR(4) | Product tax transaction type |
| pd_unitPrice | decimal(12, 4) | NUMBER(12,4) | Product unit price |
SystemDimension | |||
| Column Name | Data Type | Snowflake Type | Description |
| sd_id | int | NUMBER(38,0) | Primary key |
| sd_hostName | varchar(128) | VARCHAR(128) | System host name |
| sd_hostAbbr | varchar(16) | VARCHAR(16) | System host abbreviation |
| sd_country | varchar(32) | VARCHAR(32) | Country |
| sd_description | varchar(128) | VARCHAR(128) | System description |
| sd_groupAbbr | varchar(16) | VARCHAR(16) | System group abbreviation |
| sd_groupName | varchar(64) | VARCHAR(64) | System group name |
| sd_ipAddr | varchar(16) | VARCHAR(16) | System IP address |
| sd_platformAbbr | varchar(16) | VARCHAR(16) | Platform abbreviation |
| sd_platformName | varchar(64) | VARCHAR(64) | The platform name |
| sd_platformNumber | varchar(6) | VARCHAR(6) | The platform number |
| sd_region | varchar(32) | VARCHAR(32) | Region |
| sd_service | varchar(16) | VARCHAR(16) | Service |
| sd_softwareVersion | varchar(24) | VARCHAR(24) | System software version |
| sd_systemAbbr | varchar(16) | VARCHAR(16) | System abbreviation |
| sd_systemName | varchar(64) | VARCHAR(64) | System name |
| sd_type | varchar(32) | System type | |
TimeOfDayDimension | |||
| Column Name | Data Type | Snowflake Type | Description |
| td_timeOfDay | int | NUMBER(38,0) | Primary key |
| td_amPm | char(2) | VARCHAR(2) | AM or PM |
| td_firstSecondOfHalfHour | int | NUMBER(38,0) | The first second of half an hour numbering |
| td_firstSecondOfHour | int | NUMBER(38,0) | The first second of an hour numbering |
| td_firstSecondOfQuarterHour | int | NUMBER(38,0) | The first second of quarter an hour numbering |
| td_halfHourOfDay | int | NUMBER(38,0) | The half hour of the day numbering (1-48) |
| td_halfHourOfHour | int | NUMBER(38,0) | The half our of an hour numbering (1 or 2) |
| td_hour12 | int | NUMBER(38,0) | Hour is 12 in 12 hour clock (1-12) |
| td_hour24 | int | NUMBER(38,0) | Hour in 24 hour clock (0-23) |
| td_lastSecondOfHalfHour | int | NUMBER(38,0) | The last second of half an hour numbering |
| td_lastSecondOfHour | int | NUMBER(38,0) | The last second of an hour numbering |
| td_lastSecondOfQuarterHour | int | NUMBER(38,0) | The last second of quarter an hour numbering |
| td_minute | int | NUMBER(38,0) | The minute in an hour numbering (1-60) |
| td_quarterHourOfDay | int | NUMBER(38,0) | The quarter hour of the day numbering (1-96) |
| td_quarterHourOfHour | int | NUMBER(38,0) | The quarter hour of an hour numbering (1- 4) |
| td_second | int | NUMBER(38,0) | The second in hour numbering |
| td_secondOfDay | int | NUMBER(38,0) | The second of the day numbering |
| td_todString | char(6) | VARCHAR(6) | Time of day representation as a string |
| td_timeAsTime24 | char(8) | VARCHAR(8) | Time of day representation in a 24 hour clock in the format of 'hh:mm:ss' |
| TD_QUARTERHOURLABEL | varchar(13) | VARCHAR(13) | |
| TD_HALFHOURLABEL | varchar(13) | VARCHAR(13) | |
| TD_HOURLABEL | varchar(13) | VARCHAR(13) | |
TaxServiceTypeDimension | |||
| Column Name | Data Type | Snowflake Type | Description |
| tst_id | int | NUMBER(38,0) | Primary key |
| tst_code | varchar(4) | VARCHAR(4) | Tax service code |
| tst_description | varchar(64) | VARCHAR(64) | Tax service description |
TaxTransactionTypeDimension | |||
| Column Name | Data Type | Snowflake Type | Description |
| ttt_id | int | NUMBER(38,0) | Primary key |
| ttt_code | varchar(4) | VARCHAR(4) | Tax transaction code |
| ttt_description | varchar(64) | VARCHAR(64) | Tax transaction description |
Overview
Content Tools