config/annotations/reporting/CaseManagement.yaml

name: "{{ project_id_tgt }}.{{ sfdc_datasets_reporting }}.CaseManagement"
description: "Case Management metrics (Creation, Duration, Closure etc.) by Sales Teams and by Accounts focus."
catalog_tags:
  - display_name: "line_of_business"
    fields:
      - display_name: "group"
        value: "Customer Relationship Management"
      - display_name: "domain"
        value: "Account and Contact Management"
fields:
  - name: "CaseId"
    description: "Case ID"
  - name: "CaseOrigin"
    description: "Case Origin"
  - name: "CasePriority"
    description: "Priority"
  - name: "CaseStatus"
    description: "Status"
  - name: "CaseOwnerId"
    description: "Owner ID"
  - name: "CaseClosedDatestamp"
    description: "Closed Date"
  - name: "CaseNumber"
    description: "Case number"
  - name: "CaseCreatedDatestamp"
    description: "Created Date Timestamp"
  - name: "IsCaseClosed"
    description: "Whether the case is already closed."
  - name: "CaseType"
    description: "Case Type"
  - name: "CaseSubject"
    description: "Subject"
  - name: "AccountId"
    description: "Account ID"
  - name: "AccountName"
    description: "Name of Account"
  - name: "AccountType"
    description: "Account Type"
  - name: "AccountPhone"
    description: "Account Phone"
  - name: "AccountOwnerId"
    description: "Owner ID"
  - name: "AccountOwnerName"
    description: "Name of the Account Owner"
  - name: "AccountIndustry"
    description: "Industry"
  - name: "AccountBillingCountry"
    description: "Billing Country"
  - name: "AccountShippingCountry"
    description: "Shipping Country"
  - name: "AccountCreatedDatestamp"
    description: "Created Date Timestamp"
  - name: "CaseOwnerName"
    description: "Name of the case owner"
  - name: "IsAgentAssigned"
    description: "Whether an agent is assigned to this case."
  - name: "CaseCreatedDate"
    description: "Created date."
  - name: "CaseCreatedWeek"
    description: "Week in which this is created."
  - name: "CaseCreatedMonth"
    description: "Month in which this is created."
  - name: "CaseCreatedQuarter"
    description: "Quarter in which this is created."
  - name: "CaseCreatedYear"
    description: "Year in which this is created."
  - name: "CaseClosedDate"
    description: "Closed date."
  - name: "CaseClosedWeek"
    description: "Week in which this is closed."
  - name: "CaseClosedMonth"
    description: "Month in which this is closed."
  - name: "CaseClosedQuarter"
    description: "Quarter in which this is closed."
  - name: "CaseClosedYear"
    description: "Year in which this is closed."