📌 Feature Request: Fivetran Integration for LMS Reporting

Requested by: Loyd Collier
Purpose: Enable automated extraction and transformation of LMS reporting data for analytics and dashboarding.

1. Core Completion Data

Enable connectors for the following views to capture user learning progress:

• report.vw_rpt_transcript: Main completions fact table (user, module, completion date, status, % complete, minutes spent).
• report.vw_rpt_transcript_cf: Transcript custom fields (if applicable).
• report.vw_rpt_transcript_status & report.vw_rpt_transcript_status_local: Status ID to readable text (e.g., Completed, In Progress, Pending).
• report.vw_rpt_transcript_src_curriculum: NEW – Bridges transcripts for child & parent learning objects when using curricula.

2. Assignment Data

Support tracking of assigned, pending, and overdue training modules:

• report.vw_rpt_training_assignment: Assignment metadata (due dates, type, recurrence).
• report.vw_rpt_training_assignment_user: User-to-module assignment mapping.
• report.vw_rpt_transcript_assignment_user: Bridge linking assignments to transcripts.
• report.vw_rpt_training_assignment_due_date_type: Includes schedule/recurrence lookups for overdue calculations.

3. Organizational Structure

Enable breakdowns by department and position:

• report.vw_rpt_ou, report.vw_rpt_ou_title_local, report.vw_rpt_ou_description_local: Department/OU names and descriptions.
• report.vw_rpt_ou_cf2: NEW – Custom fields tied to organizational units.