Sunbird Lern
AskDot
  • LEARN
    • Overview
    • Functional Capabilities
    • Technical Architecture
      • Technical Architecture Diagram
      • Tech Stack
    • Dependencies
    • Product Roadmap
  • USE
    • Overview
    • Release Notes
      • Release V 8.0.0 (Ongoing)
      • Release V 7.0.0
      • Release V 5.4.0
      • Release V 5.3.0
      • Release V 5.2.0
      • Release V 5.1.0
      • Release V 5.0.1
      • Release V 5.0.0
      • Release V 4.10.0
      • Release V 4.9.0
      • Release V 4.8.0
      • Release V 4.7.0
    • Developer Guide
      • USER & ORG SERVICE
        • Features/Core capabilities
        • Architecture
          • Code Flow
        • Developer Installation
          • System Requirements
          • Tech Stack
          • Installation Guide
          • Keycloak Local setup
          • Additional Installation Dependencies:
          • Source Code
          • Installation Configuration
        • Data Models
          • Cassandra
            • Data Dictionary
              • User
              • Organisation
              • System Settings
              • Role
              • Bulk Upload Process
              • Tenant Preference
              • Cassandra Migration Version
              • User Consent
              • Email Template
              • OTP
              • Page Management (LMS Service)
              • Location
              • User Notes
              • Deprecated
          • Elastic Search
          • Redis
        • APIs
          • User Management
            • User Deletion API
            • Ownership Transfer API
          • Organisation Management
          • Location Management
          • Consent Management
          • OTP Services
          • Tenant Configurations
          • Bulk Upload
          • System Settings
          • API Management Service
          • Data Sync
          • Notification APIs
        • Flink Jobs
          • User Cache Updater
          • User Deletion Cleanup Flink Job
          • Ownership Transfer Flink Job
        • Reports
          • Standard Exhaust
            • State Admin Geo report
            • State Admin Report
          • Other Jobs
            • User Cache Indexer Job
            • Delete Users Assets Report
          • Data Products Developer Installation
            • System Requirements
            • Tech Stack
            • Installation Dependencies
            • Local installation of data-products
            • Server setup Guide
            • Installation Configuration
            • Data-product creation guide
            • Troubleshooting a data-product
        • Logs, Telemetry Events
        • Configuration
          • Functional Configurations
          • System Settings
          • Email Configuration
          • SMS Configuration
          • OTP based SMS Configuration
        • Roles
          • System Roles
          • User Roles
          • RBAC
        • Dependencies
        • Keycloak on Sunbird
        • How to Guide
          • Create Organization
          • Create User
          • Add new user type & location
        • Single Sign-on with Sunbird
        • Caching and Denormalising User Metadata
          • ETLUserCacheUpdaterJob
          • UserCacheUpdaterFlinkJob
        • Unit Tests and Code Coverage
        • FAQs
      • LMS(BATCH) SERVICE
        • Features/Core Capabilities
        • Architecture
          • Code Flow
        • Developer Installation
          • System Requirements
          • Tech Stack
          • Installation Guide
          • Source Code
        • Data Models
          • Cassandra
            • Data Dictionary
          • ElasticSearch
          • Redis
        • APIs
        • Flink Jobs
          • Merge User Courses
          • Relation Cache Updater
          • Activity Aggregate Updater
          • Assessment Aggregator
          • Enrolment Reconciliation
          • Collection Certificate Pre-Processor
          • Collection Certificate Generator
        • Reports
          • On-Demand Exhaust
            • Response Exhaust
            • User Info Exhaust
            • Progress Exhaust
          • Other Jobs
            • Collection Summary Job
            • Course Batch Status Updater Job
            • Cassandra Migrator Job
            • Score Metric Migration Job
            • Assessment Score Correction Job
            • Collection Reconciliation Job
            • Course Enrollment Job
            • Course Consumption Job
        • Logs, Telemetry Events
        • Configuration
          • System Configuration
          • Functional Configuration
        • Dependencies
        • Certificate Registry and Credentialing using Sunbird-RC
          • Configuring PublicKey in Sunbird-RC
          • Server Setup guide for Sunbird-RC
          • API Guide For Sunbird-RC
        • Certificate Flow
          • Certificates Creation and Configuration
        • FAQs
      • GROUPS
        • Features/Core Capabilities
        • Architecture
          • Code Flow
        • Developer Installation
          • System Requirements
          • Tech Stack
          • Installation Guide
          • Source Code
          • Installation Configuration
        • Data Models
          • Cassandra
            • Data Dictionary
          • Redis
        • APIs
          • Create Group
        • Logs, Telemetry Events
          • UI Telemetry Events
          • Service Telemetry Events
        • Configuration
          • Functional Configurations
        • Design References
        • Dependencies
        • Unit Tests and Code Coverage
      • NOTIFICATION SERVICE
        • Features/Core Capabilities
        • Architecture
          • Code Flow
        • Developer Installation
          • System Requirements
          • Tech Stack
          • Installation Guide
          • Source Code
          • Installation Configuration
        • Data Models
          • Data Dictionary
        • APIs
        • Flink Jobs
        • Logs, Telemetry Events
        • Configuration
          • Functional Configurations
        • Dependencies
        • Unit Tests and Code Coverage
      • DISCUSSION FORUM
        • Features/Core capabilities
        • Architecture
          • Code Flow
        • Developer Installation
          • System Requirements
          • Tech Stack
          • Installation Guide
            • Nodebb setup
            • Discussion Middleware Setup
            • Discussion Middleware
            • Discussion forum integration with any application
            • Discussion-UI setup along with demo application.
            • Sunbird-lern portal for DF
          • Source Code
        • APIs
          • Category APIs
          • User APIs
          • Post APIs
          • Topic APIs
          • Forum APIs
        • Context Schema
        • Configurations
          • Nodebb Admin panel settings
          • Discussion MW & Nodebb System Config
        • Telemetry Events
        • Dependencies
      • ML SERVICE
        • DATA PIPELINE (Flink Jobs)
          • Program User Info
            • Component Diagram
            • Data Model
            • Folder Structure
          • Ml User Delete
            • Component Diagram
            • Data Model
            • Folder Structure
        • DATA PRODUCTS
          • Program Exhaust
            • Component Diagram
            • Folder Structure
    • Server Installation
    • Dependency Setup
    • Deprecation
      • Release-5.4.0
    • Jenkins Jobs
    • Release Calendar
    • Learn More
      • Tech References
      • Telemetry Processing
      • Data Dictionary
        • Sample Data
      • Delete User Functionality
      • Asset Ownership Transfer
    • FAQs
  • Engage
    • Discuss
    • Contribute to Sunbird Lern
    • Raise an Issue
    • Contribution Guidelines
Powered by GitBook
On this page

Was this helpful?

Edit on GitHub
  1. USE
  2. Developer Guide
  3. LMS(BATCH) SERVICE
  4. Reports
  5. On-Demand Exhaust

User Info Exhaust

PreviousResponse ExhaustNextProgress Exhaust

Last updated 1 year ago

Was this helpful?

User personal info exhaust contains the additional information of the users that have joined the course batch. The information contains personal details such as Email, Phone number etc and all such personal information is provided only with explicit consent by the user. Each record represents user details of the enrolled users in the course batch.Mail id and phone number are encrypted and will be decrypted based on consent

The UserInfoExhaustJob processes the data, applies consent rules, decrypts user information, and generates a user information exhaust report based on the provided user enrolment data and collection batch information.The encryption key is mandatory only for user info exhaust Data provider: cassandra

  1. user redis

  2. user_enrolments

  3. user_consent

postgres

  1. job_request table

File Structure

Format

Nomenclature

Example

CSV zip (Password protected)

user-info-exhaust/{request_id}/<batch_id>_userinfo_<updatedDate>.zip

do_1130264512015646721166_userinfo_26_08_2020.zip

File Contents

Column Label

Column Type

Data Type

Description

Collection Id

Static

String

Unique Collection Identifier.

Collection Name

Static

String

Collection Title

Batch Id

Static

String

Batch Id

Batch Name

Static

String

Batch Title

User UUID

Static

String

The system generated unique user ID

User Name

Static

String

Name of the user

User Type

Static

String

Type of the user

User Sub Type

Static

String

Sub Type of the user

State

Static

String

User declared state for self signed up users. If the user is a org validated user then the state as passed from org SSO or derived from sub-org ID.

District

Static

String

User declared district for self signed up users. If the user is a org validated user then the district as passed from org SSO or derived from sub-org ID.

Org Name

Static

String

Name of user org - Custodian for self signed up users and respective org name for org validated users

Sub-Org Id

Static

String

If user is org validated user then the sub-org ID mapped to this user. If user is self declared user then the user declared sub-org ID.

Sub-Org Name

Static

String

If user is org validated user then the sub-org name mapped to this user. If user is self declared user then the user declared org/sub-org name.

Block Name

Static

String

Block name mapped to the user’s org/sub-org id

Declared Board

Static

String

The board selected by the user during onboarding.

Declared Org

Static

String

If the user is a self signed up user then this is the value filled by the user in the 'With' part of the self signed up declaration.

Mobile Number

Static

String

User declared unmasked mobile number

Email ID

Static

String

User declared unmasked email ID

Consent Provided

Static

String

Yes/No. Flag to denote whether user has consented to the data sharing.

Consent Provided Date

Static

Date

Date when the user has consented to share the data

Consent Fields

Following are the fields/columns that will be available in the file only when the user consented for the data sharing.

Sub-org ID

Sub-org Name

Block Name

Mobile number

Email ID

Sample Data

Collection Id,Collection Name,Batch Id,Batch Name,User UUID,User Name,User Type,User Sub Type,State,District,Block,Cluster,Sub-org Id,Sub-org Name,Org Name,Email ID,Mobile Number,Consent Provided,Consent Provided Date
do_21364005085239705611078,Copy of course with merit cert testing,BatchId_01364005724219801651,batch123,91a81041-bbbd-4bd7-947f-09f9e469213c,newtncr,administrator,"hm,asst_als_coordinator,meo",Andhra Pradesh,EAST GODAVARI,ADDATEEGALA,"",28140306106,APTWRS ADDATEEGALA,DR B R OMNI INTERNATIONAL2,newtncr@yopmail.com,"",true,06/10/2022
do_21364005085239705611078,Copy of course with merit cert testing,BatchId_01364005724219801651,batch123,2f97ee31-c190-4adc-8ca1-129f641858e2,bgm,administrator,"chm,meo,diet_lecturer,lib_bdc",Andhra Pradesh,ANANTAPUR,AGALI,"",28226200605,MPPS P.BYADAGERA,Staging Custodian Organization,bgm@yopmail.com,"",true,06/10/2022// Some code