public.learningmoduleassignments

public.learningmoduleassignments

Description

Learning Module Assignments Table - Stores assignment data for learning modules assigned to users.

This table tracks the complete lifecycle of learning module assignments from initial assignment
through completion. It serves as the primary source for assignment tracking and correlates with
learningassignmentresults via userid+moduleid for comprehensive learning analytics.

Key Performance Optimizations:
- Data retrieved using module-based API iteration (O(modules) vs O(users)) for better performance
- User IDs extracted from assignment response data rather than query parameters
- Enables efficient user-module assignment and completion analytics

Cross-table Relationships:
- userid: Links to userdetails.id for user identification and demographics
- moduleid: Links to learningmodules.id for module details and metadata
- Correlates with learningassignmentresults on userid+moduleid for assignment-to-completion tracking

Analytics Capabilities:
- Supports user assignment summaries and module completion rate analysis
- Enables performance metrics and learning analytics across user-module relationships
- Provides foundation for learning dashboard and reporting functionality

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false Primary key - Unique identifier for each learning module assignment record from Genesys Cloud
userid varchar(50) true User ID from Genesys Cloud - Links assignments to specific users.
Enables user-centric analytics and correlates with userdetails.id for user demographics.
Populated from assignment response data during module-based API retrieval for optimal performance.
moduleid varchar(50) true Learning Module ID - Links assignments to specific learning modules.
Standardized to lowercase for consistency across all database types (MSSQL, PostgreSQL, Snowflake).
Correlates with learningmodules.id for module metadata and learningassignmentresults.moduleid for completion tracking.
assessmentid varchar(50) true Assessment identifier associated with the learning module assignment
isoverdue boolean true Boolean flag indicating whether the assignment is past its due date
version varchar(255) true Version identifier for the learning module assignment
percentagescore numeric(20,2) true Overall percentage score achieved for the assignment
assessmentpercentagescore numeric(20,2) true Specific assessment percentage score for the assignment
isrule boolean true Boolean flag indicating whether the assignment was created by a rule
ismanual boolean true Boolean flag indicating whether the assignment was manually created
ispassed boolean true Boolean flag indicating whether the assignment has been successfully passed
islatest boolean true Boolean flag indicating whether this is the latest version of the assignment
assessmentcompletionpercentage numeric(20,2) true Percentage completion of the assessment component
completionpercentage numeric(20,2) true Overall completion percentage of the learning module assignment
daterecommendedforcompletion timestamp without time zone true Recommended completion date for the assignment
datecreated timestamp without time zone true Timestamp when the assignment was created in Genesys Cloud
datemodified timestamp without time zone true Timestamp when the assignment was last modified in Genesys Cloud
datesubmitted timestamp without time zone true Timestamp when the assignment was submitted for completion
lengthinminutes numeric(20,2) true Duration of the learning module in minutes
dateassigned timestamp without time zone true Timestamp when the assignment was assigned to the user
datedue timestamp without time zone true Due date for the assignment completion
state varchar(50) true Current state of the assignment (e.g., Assigned, InProgress, Completed)
updated timestamp without time zone true Timestamp when this record was last updated in the local database

Constraints

Name Type Definition
learningmoduleassignments_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
learningmoduleassignments_pkey CREATE UNIQUE INDEX learningmoduleassignments_pkey ON public.learningmoduleassignments USING btree (id)

    • Related Articles

    • public.vwlearninguserassignmentsummary

      Description Comprehensive user-centric view combining learning assignments and results. Shows complete learning lifecycle per user including assignment status, completion status, and performance metrics. Key relationships: userdetails -> ...

    • public.vwlearningassignmentcorrelation

      Description Direct correlation view between learning assignments and their completion results. Tracks complete assignment lifecycle from assignment to completion with timing and performance metrics. Includes calculated fields for lifecycle status, ...

    • public.vwlearningmodulecompletionanalytics

      Description Module-centric analytics view providing comprehensive completion rates, performance metrics, and assignment statistics. Calculates completion rates, pass rates, average scores, and timing analytics per learning module. Optimized for ...

    • public.learningassignmentresults

      Description Learning Assignment Results Table - Stores detailed results and completion data for learning module assignments. This table captures the outcome and performance metrics when users complete learning module assignments. It serves as the ...

    • public.participantattributesdynamic

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) false conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true ...