public.learningassignmentresults

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 results repository that correlates with learningmoduleassignments to provide complete
assignment lifecycle tracking from assignment through completion and assessment.

Key Performance Optimizations:
- Data retrieved using module-based API iteration (O(modules) vs O(users)) for better performance
- User IDs extracted from assignment result 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 learningmoduleassignments 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, reporting, and performance tracking
- Tracks assessment scores, completion percentages, and timing metrics

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false Primary key - Unique identifier for each learning assignment result record from Genesys Cloud
userid varchar(50) true User ID from Genesys Cloud - Links assignment results to specific users.
Enables user-centric analytics and correlates with userdetails.id for user demographics.
Populated from assignment result response data during module-based API retrieval for optimal performance.
moduleid varchar(50) true Learning Module ID - Links results to specific learning modules.
Standardized to lowercase for consistency across all database types (MSSQL, PostgreSQL, Snowflake).
Correlates with learningmodules.id for module metadata and learningmoduleassignments.moduleid for assignment tracking.
assessmentid varchar(50) true Assessment identifier associated with the learning assignment result
assessmentformid varchar(50) true Assessment form identifier used for the evaluation
passpercent numeric(20,2) true Minimum percentage required to pass the assessment
assessmentpercentagescore numeric(20,2) true Actual percentage score achieved on the assessment
assessmentcompletionpercentage numeric(20,2) true Percentage completion of the assessment component
completionpercentage numeric(20,2) true Overall completion percentage of the learning module
datecreated timestamp without time zone true Timestamp when the result was created in Genesys Cloud
datemodified timestamp without time zone true Timestamp when the result was last modified in Genesys Cloud
lengthinminutes numeric(20,2) true Duration spent completing the learning module in minutes
updated timestamp without time zone true Timestamp when this record was last updated in the local database

Constraints

Name Type Definition
learningassignmentresults_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
learningassignmentresults_pkey CREATE UNIQUE INDEX learningassignmentresults_pkey ON public.learningassignmentresults 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.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 ...
    • 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 ...