{
  "title": "Learners' Transcript",
  "every": null,
  "timeUnit": null,
  "scheduleStartDate": null,
  "doUploadToSharePoint": false,
  "doSchedule": false,
  "doPullRecurring": false,
  "reportDefinition": {
    "title": "Learners' Transcript",
    "ticket": null,
    "returnType": "Excel",
    "description": "Contains:\na) all current and expired completions,\nb) uncompleted enrollments (current and expired) into active (i.e. published, not deleted) courses,\nc) enrollment requests into active courses.",
    "dateFormat": "yyyy-MM-dd HH:mm:ss",
    "filter": {
      "Operator": "Or",
      "Groups": [
        {
          "Operator": "And",
          "Groups": [],
          "Conditions": [
            {
              "id": null,
              "Source": "Enrollment",
              "Field": "CoursePassingStatus",
              "Operator": "is different from",
              "Value": "Completed"
            },
            {
              "id": null,
              "Source": "Course",
              "Field": "IsPublished",
              "Operator": "is equal to",
              "Value": "true"
            },
            {
              "id": null,
              "Source": "Course",
              "Field": "IsDeleted",
              "Operator": "is equal to",
              "Value": "false"
            },
            {
              "id": null,
              "Source": "Enrollment",
              "Field": "RegistrationStatus",
              "Operator": "is different from",
              "Value": "Cancelled"
            }
          ],
          "Sign": "Is"
        }
      ],
      "Conditions": [
        {
          "Source": "Enrollment",
          "Field": "CoursePassingStatus",
          "Operator": "is equal to",
          "Value": "Completed"
        }
      ],
      "Sign": "Is"
    },
    "fields": [
      {
        "Name": "Title",
        "Label": "Course",
        "Source": "Course",
        "ValueReplacements": []
      },
      {
        "Name": "Title",
        "Label": "Learner",
        "Source": "Learner",
        "ValueReplacements": []
      },
      {
        "Name": "Email",
        "Label": "Learner email",
        "Source": "Learner",
        "ValueReplacements": []
      },
      {
        "Name": "Department",
        "Label": "Department",
        "Source": "Learner",
        "ValueReplacements": []
      },
      {
        "Name": "Title",
        "Label": "Manager",
        "Source": "Learner's manager",
        "ValueReplacements": []
      },
      {
        "Name": "RegistrationStatus",
        "Label": "Registration status",
        "Source": "Enrollment",
        "ValueReplacements": []
      },
      {
        "Name": "RegistrationDate",
        "Label": "Registered at",
        "Source": "Enrollment",
        "ValueReplacements": []
      },
      {
        "Name": "StartDate",
        "Label": "Session start date",
        "Source": "Course sessions",
        "ValueReplacements": []
      },
      {
        "Name": "CoursePassingStatus",
        "Label": "Completion status",
        "Source": "Enrollment",
        "ValueReplacements": [
          {
            "Replace": "NotStarted",
            "With": "Not started"
          },
          {
            "Replace": "InProgress",
            "With": "In progress"
          }
        ]
      },
      {
        "Name": "CompletionDate",
        "Label": "Completed at",
        "Source": "Enrollment",
        "ValueReplacements": []
      },
      {
        "Name": "Id",
        "Label": "Enrollment Id",
        "Source": "Enrollment",
        "ValueReplacements": []
      }
    ]
  }
}