user-info-exhaust.md

User Info Exhaust

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