CertificationRuleProgress

one of "subject_hours" | "subject_record_count" | "evidence_document" | "manual_sign_off" | "quiz_pass" | "external_course_pass" | "scorm_course_complete" | "job_aid_viewed"

Hours or completed records accumulated in the evaluation window, for the threshold rule kinds; null for the others.

Hours or records the user's still-pending submissions in the window would add once a manager approves them, for the threshold rule kinds; null for the others.

The rule's threshold, for the threshold rule kinds; null for the others.

The one subject a threshold rule is narrowed to; null when it counts every tag of the type, and always null on the other kinds.

That subject's name, for display; null whenever subject_matter_id is.

The evidence type an evidence_document rule looks for.

one of "score" | "date_range" | "quantity" | "url" | "file" | "pass_fail" | "note" | null

Whether a completed record in the window carries that evidence (for pass_fail, a row recording a pass); null for other kinds.

Whether a still-pending submission in the window carries that evidence; null for other kinds.

Most recent sign-off for a manual_sign_off rule, window regardless.

The quiz a quiz_pass rule requires; null for other kinds.

Most recent passing attempt for a quiz_pass rule, window regardless.

Catalogue id of the course an external_course_pass rule requires; null for other kinds.

The LMS's own identifier of that course.

That course's page on its LMS, as the catalogue records it — the learner's way to a course that lives outside this system. Null when the catalogue has no URL for it, and on other kinds.

Most recent passing grade for an external_course_pass rule, window regardless.

The hosted SCORM course a scorm_course_complete rule requires; null for other kinds.

Whether that course is archived — hidden from learners, so no longer takeable; null for other kinds.

Most recent counting completion for a scorm_course_complete rule, window regardless: an attempt reported complete without an explicit failed verdict.

When that course's package was last replaced with recertification required; completions of earlier package versions no longer satisfy the rule. Null while every completion counts, and on other kinds.

Whether last_scorm_complete_at was of a package version before the one that required recertification, so it does not satisfy the rule whatever the window. False while no completion is on record; null on other kinds.

The job aid a job_aid_viewed rule requires opening; null for other kinds.

Whether that aid is archived — hidden from its audience, so no longer openable; null for other kinds.

Most recent open of the aid's page for a job_aid_viewed rule, window regardless. Opens of its files do not count.

That aid's recertification cutoff, when its content was replaced with recertification required: an open before it does not satisfy the rule, whatever the window. Null while every open counts, and on other kinds.

The user's learning records in the evaluation window that count towards a subject_hours, subject_record_count or evidence_document rule, or would once approved — most recent first, each with its status, so a learner can see which records stand behind the rule and which are still awaiting a manager. Records a narrowed threshold rule does not cover are left out. Null for the other kinds.