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
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 |
Name | Type | Definition |
---|---|---|
learningassignmentresults_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Name | Definition |
---|---|
learningassignmentresults_pkey | CREATE UNIQUE INDEX learningassignmentresults_pkey ON public.learningassignmentresults USING btree (id) |