config/annotations/reporting/Cases.yaml

name: "{{ project_id_tgt }}.{{ sfdc_datasets_reporting }}.Cases"
description: "Cases data."
catalog_tags:
  - display_name: "line_of_business"
    fields:
      - display_name: "group"
        value: "Customer Relationship Management"
      - display_name: "domain"
        value: "Case Management"
fields:
  - name: "CaseId"
    description: "Case ID"
  - name: "AccountId"
    description: "Account ID"
  - name: "CaseNumber"
    description: "Case Number"
  - name: "ClosedDatestamp"
    description: "Closed Date"
  - name: "Comments"
    description: "Internal Comments"
  - name: "ContactEmail"
    description: "Contact Email"
  - name: "ContactFax"
    description: "Contact Fax"
  - name: "ContactId"
    description: "Contact ID"
  - name: "ContactMobile"
    description: "Contact Mobile"
  - name: "ContactPhone"
    description: "Contact Phone"
  - name: "CreatedById"
    description: "ID of the User who created this Case"
  - name: "CreatedDatestamp"
    description: "Created Date Timestamp"
  - name: "Description"
    description: "Description of Case"
  - name: "EntitlementId"
    description: "Entitlement ID"
  - name: "Isclosed"
    description: "Closed"
  - name: "IsEscalated"
    description: "Escalated"
  - name: "Language"
    description: "Language"
  - name: "MasterRecordId"
    description: "Master Record ID"
  - name: "Origin"
    description: "Case Origin"
  - name: "OwnerId"
    description: "Owner ID"
  - name: "ParentId"
    description: "Parent Case ID"
  - name: "Priority"
    description: "Priority"
  - name: "Reason"
    description: "Case Reason"
  - name: "RecordTypeId"
    description: "Record Type ID"
  - name: "Status"
    description: "Status"
  - name: "Subject"
    description: "Subject"
  - name: "SuppliedCompany"
    description: "Company"
  - name: "SuppliedEmail"
    description: "Email Address"
  - name: "SuppliedName"
    description: "Name"
  - name: "SuppliedPhone"
    description: "Phone"
  - name: "Type"
    description: "Case Type"
  - name: "LastModifiedById"
    description: "ID of the last User who modified this Case"
  - name: "LastModifiedDatestamp"
    description: "Last Modified Date"
  - name: "LastReferencedDatestamp"
    description: "Last Referenced Date"
  - name: "LastViewedDatestamp"
    description: "Last Viewed Date"
  - name: "SlaExitDatestamp"
    description: "Entitlement Process End Time"
  - name: "SlaStartDatestamp"
    description: "Entitlement Process Start Time"
  - 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."