{
  "title": "Record Download for Importer",
  "every": null,
  "timeUnit": null,
  "doUploadToSharePoint": false,
  "doSchedule": false,
  "doPullRecurring": false,
  "reportDefinition": {
    "title": "Record Download for Importer",
    "returnType": "Excel",
    "description": "This report will help to build out an Excel file in the output that is required for the Importer. \n\nPLEASE NOTE: You will have to add in one column called \"Create Certificate\" with values yes and no after generating the report in order for it to be properly formatted for the Importer. The following equation can be used to add the values to the new column called \"Create Certificate\": \n\n=IF(ISBLANK(D2),\"No\",\"Yes\")",
    "fields": [
      {
        "name": "Email",
        "label": "User Name",
        "source": "Learner",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "Title",
        "label": "Course Title",
        "source": "Course",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "CourseType",
        "label": "Course Type",
        "source": "Course",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "TemplateId",
        "label": "Certificate Template",
        "source": "Certificate",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "CompletionDate",
        "label": "Issue Date",
        "source": "Enrollment",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "Expiry",
        "label": "Expiration Date",
        "source": "Certificate",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "IsDeleted",
        "label": "Course Exists",
        "source": "Course",
        "valueReplacements": [
          {
            "replace": "True",
            "with": "No"
          },
          {
            "replace": "False",
            "with": "Yes"
          }
        ],
        "dateFormat": null
      },
      {
        "name": "DecimalCEU",
        "label": "CEUs",
        "source": "Enrollment",
        "valueReplacements": [],
        "dateFormat": null
      },
      {
        "name": "RegistrationStatus",
        "label": "Enroll User",
        "source": "Enrollment",
        "valueReplacements": [
          {
            "replace": "Active",
            "with": "Yes"
          },
          {
            "replace": "Cancelled",
            "with": "No"
          },
          {
            "replace": "Expired",
            "with": "No"
          }
        ],
        "dateFormat": null
      }
    ],
    "filter": {
      "operator": "And",
      "groups": [],
      "conditions": [
        {
          "source": "Enrollment",
          "field": "CoursePassingStatus",
          "operator": "is equal to",
          "value": "Completed"
        }
      ],
      "sign": "Is"
    }
  },
  "nextPullDate": null
}