# Data Dictionary

### sunbird\_courses.question \[PRIMARY KEY: id] - <mark style="color:green;">(User Defined Type  - used in</mark> <mark style="color:green;">sunbird\_courses.assessment\_aggregator)</mark>

<table><thead><tr><th width="164">Column Name</th><th width="199.33333333333331">Data Type</th><th>Description</th><th>Sample Data</th></tr></thead><tbody><tr><td>id</td><td>text</td><td>identifier of the question</td><td>do_2129173993575219201147</td></tr><tr><td>assess_ts</td><td>timestamp</td><td>Time at which the question was attempted by the user</td><td>2020-02-12 05:02:18.172000+0000</td></tr><tr><td>max_score</td><td>double</td><td>Maximum score that can be secured on the Question</td><td>1</td></tr><tr><td>score</td><td>double</td><td>Score secured by the user on the Question</td><td>0</td></tr><tr><td>type</td><td>text</td><td>Type of the Question</td><td>mcq</td></tr><tr><td>title</td><td>text</td><td>Title of the Question</td><td>Explore Question 1</td></tr><tr><td>resvalues</td><td>list&#x3C;frozen&#x3C;map&#x3C;text, text>>></td><td>Question Response Value</td><td>[{'2': '{"text":"Chlorophyll\n"}'}]</td></tr><tr><td>params</td><td>list&#x3C;frozen&#x3C;map&#x3C;text, text>>></td><td>List of Question Parameters</td><td>[{'1': '{"text":"Stomata\n"}'}, {'2': '{"text":"Chlorophyll\n"}'}, {'3': '{"text":"Chloroplast\n"}'}, {'4': '{"text":"Guard cells (correct)\n"}'}, {'answer': '{"correct":["4"]}'}]</td></tr><tr><td>description</td><td>text</td><td>Question Description</td><td>Sample Question</td></tr><tr><td>duration</td><td>decimal</td><td>time in seconds</td><td>2.0</td></tr></tbody></table>

### sunbird\_courses.user\_content\_consumption \[PRIMARY KEY (userid, contentid, batchid, courseid)]

Table used to store user content consumption status as part of Course consumption.

<table><thead><tr><th width="199.33333333333331">Column Name</th><th width="114">Data Type</th><th>Description</th><th>Sample Data</th></tr></thead><tbody><tr><td>userid</td><td>text</td><td>UUID of the user</td><td>e44c93fb-ca7f-4d14-a8cb-c10144fc34c4</td></tr><tr><td>contentid</td><td>text</td><td>Content Identifier whose consumption details is recorded in the row</td><td>do_2129175755621335041147</td></tr><tr><td>batchid</td><td>text</td><td>Batch Identifier enrolled by the user</td><td>01291957301247180833</td></tr><tr><td>courseid</td><td>text</td><td>Course Identifier to which Batch belongs to</td><td>do_2129195698820055041246</td></tr><tr><td>completedcount</td><td>text</td><td></td><td>1</td></tr><tr><td><del>contentversion</del></td><td>text</td><td>Not used</td><td></td></tr><tr><td>datetime</td><td>timestamp</td><td></td><td></td></tr><tr><td><del>gra</del>de</td><td>text</td><td>Not used</td><td></td></tr><tr><td>lastaccesstime</td><td>text</td><td>Last Content access time</td><td>2020-06-04 13:10:31:296+0000</td></tr><tr><td>lastcompletedtime</td><td>text</td><td>Last Content Completion time</td><td>2020-06-04 12:52:23:964+0000</td></tr><tr><td>lastupdatedtime</td><td>text</td><td>Latest record updated time </td><td>2020-06-04 13:10:31:307+0000</td></tr><tr><td>progress</td><td>int</td><td>Maximum Content Consumption Progress percentage irrespective of view</td><td>70</td></tr><tr><td>result</td><td>text</td><td></td><td></td></tr><tr><td><del>score</del></td><td>text</td><td>Not used</td><td></td></tr><tr><td>status</td><td>int</td><td>Content consumption completion status</td><td>2</td></tr><tr><td>viewcount</td><td>int</td><td>Number of times user has consumed the content</td><td>7</td></tr></tbody></table>

### sunbird\_courses.user\_activity\_agg \[PRIMARY KEY ((activity\_type, activity\_id, user\_id), context\_id)]

Table used to store User's Course consumption progress aggregates

<table><thead><tr><th width="186.33333333333331">Column Name</th><th width="147">Data Type</th><th>Description</th><th>Sample Data</th></tr></thead><tbody><tr><td>activity_type</td><td>text</td><td>Type of the activity - Course, CourseUnit, Quiz etc</td><td>Course</td></tr><tr><td>activity_id</td><td>text</td><td>Id of the activity - course_id, content_id etc</td><td>do_21282054143234048014178</td></tr><tr><td>user_id</td><td>text</td><td>User Id</td><td>9ac843e9-47ee-4019-80ad-4ab23bf96045</td></tr><tr><td>context_id</td><td>text</td><td>Context in which the activity happened. Combination of type:value.</td><td>cb:01282120178297241653</td></tr><tr><td><del>agg</del></td><td>map&#x3C;text, int></td><td><p>Number of contents consumed by the user in the course</p><p><strong>Not used now. Migrated to aggregates column. aggregates column is created to get the attempts counts.</strong></p></td><td>{'completedCount': 2}</td></tr><tr><td>agg_details</td><td>list&#x3C;text></td><td>Aggregate metrics for the user and activity combination</td><td>['{"max_score":5.0,"score":4.0,"type":"attempt_metrics","attempt_id":"19ac65ea5ec2e9ed9d29aacdbd46fddd","content_id":"do_212959942036119552130","attempted_on":1582086185}']</td></tr><tr><td>agg_last_updated</td><td>map&#x3C;text, timestamp></td><td>When did the aggregate metrics were last updated?</td><td>{'completedCount': '2020-08-19 05:55:48.000000+0000', 'max_score:do_212959942036119552130': '2021-12-02 06:42:17.037000+0000', 'score:do_212959942036119552130': '2021-12-02 06:42:17.037000+0000'}</td></tr><tr><td>aggregates</td><td>map&#x3C;text, double></td><td>consumption aggregate metrics of the assessments in the course </td><td>{'attempts_count:do_212959942036119552130': 1, 'completedCount': 2, 'max_score:do_212959942036119552130': 5, 'score:do_212959942036119552130': 4}</td></tr></tbody></table>

### sunbird\_courses.assessment\_aggregator \[PRIMARY KEY ((user\_id, course\_id), batch\_id, content\_id, attempt\_id)]

Table used to store User's Assessment Contents' consumption aggregates

<table><thead><tr><th width="189.33333333333331">Column Name</th><th width="127">Data Type</th><th width="167">Description</th><th>Sample Data</th></tr></thead><tbody><tr><td>user_id</td><td>text</td><td>UUID of the user</td><td>30b2571f-08f9-49ce-b97a-c643df0c82f7</td></tr><tr><td>course_id</td><td>text</td><td>Course Identifier</td><td>do_21295500947955712011099</td></tr><tr><td>batch_id</td><td>text</td><td>Batch Identifier</td><td>01295501508689100844</td></tr><tr><td>content_id</td><td>text</td><td>Assessment Content Identifier</td><td>do_2129493126207324161154</td></tr><tr><td>attempt_id</td><td>text</td><td>Attempt Identifier</td><td>638a8d6240f8df4b8cc5ef9b79fa0d67</td></tr><tr><td>created_on</td><td>timestamp</td><td>Record created on</td><td>2020-02-12 03:52:51.687000+0000</td></tr><tr><td>grand_total</td><td>text</td><td>Assessment aggregate score</td><td>1.0/8.0</td></tr><tr><td>last_attempted_on</td><td>timestamp</td><td>Last attempted timestamp of the assessment</td><td>2020-02-12 03:52:19.666000+0000</td></tr><tr><td>question</td><td>list&#x3C;frozen&#x3C;question>></td><td>Question Details</td><td><pre class="language-json"><code class="lang-json">[{id: 'do_2129173993575219201147', assess_ts: '2020-02-12 05:02:18.172000+0000', max_score: 1, score: 0, type: 'mcq', title: 'Explore Question 1', resvalues: [{'2': '{"text":"Chlorophyll\n"}'}], params: [{'1': '{"text":"Stomata\n"}'}, {'2': '{"text":"Chlorophyll\n"}'}, {'3': '{"text":"Chloroplast\n"}'}, {'4': '{"text":"Guard cells (correct)\n"}'}, {'answer': '{"correct":["4"]}'}], description: 'By kiruba', duration: 2.000000000000000000}, {id: 'do_2129174037204910081236', assess_ts: '2020-02-12 05:02:16.590000+0000', max_score: 1, score: 0, type: 'mcq', title: 'Explore Question 6', resvalues: [{'2': '{"text":"FeSO4 acts as an oxidising agent and oxidises KMnO4\n"}'}], params: [{'1': '{"text":"KMnO4 is an oxidising agent, it oxidises FeSO4 (correct)\n"}'}, {'2': '{"text":"FeSO4 acts as an oxidising agent and oxidises KMnO4\n"}'}, {'3': '{"text":"The colour disappears due to dilution, no reaction is involved\n"}'}, {'4': '{"text":"KMnO4 is an unstable compound and decomposes in the presence of FeSO4 to a colourless compound\n"}'}, {'answer': '{"correct":["1"]}'}], description: 'By kiruba', duration: 2.000000000000000000}, {id: 'do_2129174014605885441232', assess_ts: '2020-02-12 05:02:14.750000+0000', max_score: 1, score: 0, type: 'mcq', title: 'Explore Question 3', resvalues: [{'2': '{"text":"Breaking down water molecule\n"}'}], params: [{'1': '{"text":"Absorbing light (correct)\n"}'}, {'2': '{"text":"Breaking down water molecule\n"}'}, {'3': '{"text":"No function\n"}'}, {'4': '{"text":"Reduction of CO2\n"}'}, {'answer': '{"correct":["1"]}'}], description: 'By kiruba', duration: 2.000000000000000000}, {id: 'do_2129174030324285441235', assess_ts: '2020-02-12 05:02:13.160000+0000', max_score: 1, score: 1, type: 'mcq', title: 'Explore Question 5', resvalues: [{'2': '{"text":"a brown residue is left (correct)\xa0\n"}'}], params: [{'1': '{"text":"crystals immediately melt\n"}'}, {'2': '{"text":"a brown residue is left (correct)\xa0\n"}'}, {'3': '{"text":"white fumes appear in the test tube\n"}'}, {'4': '{"text":"a yellow residue is left\n"}'}, {'answer': '{"correct":["2"]}'}], description: 'By kiruba', duration: 2.000000000000000000}, {id: 'do_2129195303901757441628', assess_ts: '2020-02-12 05:02:11.348000+0000', max_score: 1, score: 0, type: 'mcq', title: 'Question 7', resvalues: [{'2': '{"text":"Ravivarman\n"}'}], params: [{'1': '{"text":"Narasimhavarman II (correct)\n"}'}, {'2': '{"text":"Ravivarman\n"}'}, {'3': '{"text":"Mahendravarman\n"}'}, {'4': '{"text":"Devavarman\n"}'}, {'answer': '{"correct":["1"]}'}], description: 'By kiruba', duration: 2.000000000000000000}, {id: 'do_2129195314499747841629', assess_ts: '2020-02-12 05:02:09.774000+0000', max_score: 1, score: 0, type: 'mcq', title: 'Question 8', resvalues: [{'2': '{"text":"Sabha\n"}'}], params: [{'1': '{"text":"Ur (correct)\n"}'}, {'2': '{"text":"Sabha\n"}'}, {'3': '{"text":"Nagaram\n"}'}, {'4': '{"text":"Kurram\n"}'}, {'answer': '{"correct":["1"]}'}], description: 'By kiruba', duration: 2.000000000000000000}, {id: 'do_2129174008785797121231', assess_ts: '2020-02-12 05:02:08.046000+0000', max_score: 1, score: 0, type: 'mcq', title: 'Explore Question 2', resvalues: [{'2': '{"text":"Water\n"}'}], params: [{'1': '{"text":"Chlorophyll\n"}'}, {'2': '{"text":"Water\n"}'}, {'3': '{"text":"Blood\n"}'}, {'4': '{"text":"haemoglobin (correct)\n"}'}, {'answer': '{"correct":["4"]}'}], description: 'By kiruba', duration: 3.000000000000000000}, {id: 'do_2129174021075271681233', assess_ts: '2020-02-12 05:02:05.443000+0000', max_score: 1, score: 0, type: 'mcq', title: 'Explore Question 4', resvalues: [{'2': '{"text":"Small globules\n"}'}], params: [{'1': '{"text":"Carbohydrates\n"}'}, {'2': '{"text":"Small globules\n"}'}, {'3': '{"text":"Amino acids (correct)\n"}'}, {'4': '{"text":"Starch\n"}'}, {'answer': '{"correct":["3"]}'}], description: 'By kiruba', duration: 3.000000000000000000}]
</code></pre></td></tr><tr><td>total_max_score</td><td>double</td><td>Total Maximum score of assessments of the course</td><td>8</td></tr><tr><td>total_score</td><td>double</td><td>Total score achieved by the user</td><td>1</td></tr><tr><td>updated_on</td><td>timestamp</td><td>record updated on</td><td>2020-02-12 05:02:33.088000+0000</td></tr></tbody></table>

### sunbird\_courses.course\_batch \[PRIMARY KEY (courseid, batchid)]

Table used to store Batch information created against Courses.

<table><thead><tr><th width="199.33333333333331">Column Name</th><th width="169">Data Type</th><th>Description</th><th>Sample Data</th></tr></thead><tbody><tr><td>courseid</td><td>text</td><td>Course Identifier</td><td>do_2134405168915005441176</td></tr><tr><td>batchid</td><td>text</td><td>Batch Identifier</td><td>013440524934594560116</td></tr><tr><td>cert_templates</td><td>map&#x3C;text, frozen&#x3C;map&#x3C;text, text>>></td><td>Certificate template details linked to the Batch</td><td><pre><code>{'do_2134278778780631041124': {'criteria': '{"enrollment":{"status":2},"assessment":{"score":{">=":50}}}', 'identifier': 'do_2134278778780631041124', 'issuer': '{"name":"Gujarat Council of Educational Research and Training","url":"https://gcert.gujarat.gov.in/gcert/"}', 'name': 'sandhya', 'previewUrl': 'https://sunbirdstagingpublic.blob.core.windows.net/sunbird-content-staging/content/do_2134278778780631041124/artifact/do_2134278778780631041124_1639145248983_certificate_2021-12-10_19_37.svg', 'signatoryList': '[{"name":"sadndy","image":"data:image/png;base64,/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAIBAQIBAQICAgICAgICAwUDAwMDAwYEBAMFBwYHBwcGBwcICQsJCAgKCAcHCg0KCgsMDAwMBwkODw0MDgsMDAz/wAALCAAuAHABAREA/8QAHAABAAIDAAMAAAAAAAAAAAAAAAYHAwUIAgQJ/8QAMBAAAQQBAwMCBAYCAwAAAAAAAgEDBAUABgcREhMhCEEUIjEyI0JRYXFyFTOBgpL/2gAIAQEAAD8A+/mMYxjNBrPcGr28qEmW0n4dtxwWGgECcekOl9rTYCikZr7CKKuR/TXqI03qXV7GnzK0pruYBORYNxWv1700R8krPdEUc6ffpVeMn+MYxjGMZFd0twWdt9MuTljPTJrpjGgQ2v8AZOkmvS20P8r9V/KPK5odgr3UdzJ1YzqOwi2L1ZahFbWNHRpmOXwkdx1pv3IAdcMUIvmXjzlkZUu8bHY9Q20suUqDWjLs448/ak1yGvYX+3bCSKfzmDfOAuut+9qaKMXz0Vs/quaQfVlhmG/FBF/Y3ZYp/wBVy4cZBd690JG21ZTM1sVqwvNR28apr4zhqIkply64vHnpbZF1xf6ZOsYxjGVrpeS3ubvXd2R9LtfoV1KiAP5fjDaByS7/ACIONtJ+n4v65DNIeqrT0DV17U0Gm7D/AA8Kej0mzR1sWrB+VLVlXGBUlJ7qf608ceUyzIW8+nLS1r4cWyCVItJ0uvjoy2RIbsXqSR54+1shUSL7erhOcgG9m6+mNf8ApomX0h+dFizJDiafdjohS5Mth4vhpMcff52u6Kr47fzFwnPHKcT1b7lX2zeoLiugXVbuJqqbHpbC6rqX4xtiWbgMRIdcLn4aRhF9HhfeL8TuuGIefHZWjt+Y7Op4ekJlZqBq2g1AWM16xdhibEVFJtJD/Q8vT1k2a/T2XJtN15S1hmki1r2VbfZil1yBHpde4Rlvyv3H1J0p785BZzAa49YEESQXGNB6cOT/AFlWD3bBf5RmI7/w7lrYxjGMp2w2H1U+GoaWs1W1p/T2obKTYvyoMVf8s38R5cbacJe23wSrw50kX7Z46e9I1fpfRdDWQLmXFmUrzLiTmojIkYtRzjtgIdPSCALhEHHPSa9XnINvXsDo/wBPexdhduXWs3JGn6CZVxO1NQpc+MTan8EKC2n3E2hKYILnKKRH45SNbN7AG3N0JW7ly6loKXSsaQtcLvTWxgDpbCCx18IQB20cfcX5nS7X5E4y0aXQ8T1CTtVXUOQdfUyLGsco7FhtFV1+vXuDLESTpNtXCRtPYhaX6eMyTPRbTXjtxOsr7Ur19qeIcC9to77caRaxyFRFgkEOltsEX5BDjjleVXNRbeiuwK8YsK/XM+U5GvWtSCxdQGprUiaDAsCTqh2yIAEepsAUBAvKftLvT9s7cbZax3Cn3M1+3k6mtY0xuxedTrlCEJhpRRsfDLYOC4ggnt598tbGMYxjPUsrBmphOSpDgMR2AVx1wy6RbFPKquc3atu5O+VdBF0Xhm7kIUGhhLx3KqhUg+LnuD+U3mv/AD3Wg5+udDX+j6jVUdpi0q66yZYLraCXGB4W1T3RCReF/fNk20LQIIiIiP2pmTGMYxjGMZo9w9Exdx9A3VBON5uFeQnoD5Ml0uI26CgXC/rwq5qtudmKrbSRImtOzLK5nADMmymmJSHmw+xtOkRBtsfYGxEU/TJjjGMYxjP/2Q==","designation":"CEO","id":"CEO/CEO"}]', 'url': 'https://sunbirdstagingpublic.blob.core.windows.net/sunbird-content-staging/content/do_2134278778780631041124/artifact/do_2134278778780631041124_1639145248983_certificate_2021-12-10_19_37.svg'}}
</code></pre></td></tr><tr><td>created_date</td><td>timestamp</td><td>Batch Creation Date</td><td>2021-12-15 12:19:07.049000+0000</td></tr><tr><td>createdby</td><td>text</td><td>Batch Created By</td><td>fca2925f-1eee-4654-9177-fece3fd6afc9</td></tr><tr><td><del>createddate</del></td><td>text</td><td>Not used</td><td></td></tr><tr><td>createdfor</td><td>list&#x3C;text></td><td>Batch creator user Organisations</td><td>['01269878797503692810', '01275629407654707220300']</td></tr><tr><td>description</td><td>text</td><td>Batch Description</td><td>Sample Batch</td></tr><tr><td>end_date</td><td>timestamp</td><td>Batch End Date</td><td></td></tr><tr><td><del>enddate</del></td><td>text</td><td>Not used</td><td></td></tr><tr><td>enrollment_enddate</td><td>timestamp</td><td>Batch Enrolment End Date</td><td>2022-06-20</td></tr><tr><td><del>enrollmentenddate</del></td><td>text</td><td>Not used</td><td></td></tr><tr><td>enrollmenttype</td><td>text</td><td>Batch Enrolment Type</td><td>open</td></tr><tr><td>mentors</td><td>list&#x3C;text></td><td>Mentors of the batch</td><td></td></tr><tr><td>name</td><td>text</td><td>Name of the Batch</td><td>Sample Batch</td></tr><tr><td>start_date</td><td>timestamp</td><td>Batch Enrolment Start Date</td><td>2021-12-15 12:19:07.049000+0000</td></tr><tr><td><del>startdate</del></td><td>text</td><td>Not used</td><td></td></tr><tr><td>status</td><td>int</td><td>status of the Batch (running or closed)</td><td>1</td></tr><tr><td><del>tandc</del></td><td>boolean</td><td>Not used</td><td></td></tr><tr><td>updated_date</td><td>timestamp</td><td>record last updated date</td><td>2021-12-15 12:19:07.049000+0000</td></tr><tr><td><del>updateddate</del></td><td>text</td><td>Not used</td><td></td></tr></tbody></table>

### sunbird\_courses.user\_enrolments \[PRIMARY KEY (userid, courseid, batchid)]

Table used to capture User's information who have enrolled to Course Batch

<table><thead><tr><th width="230">Column Name</th><th width="161.33333333333331">Data Type</th><th>Description</th><th>Sample Data</th></tr></thead><tbody><tr><td>userid</td><td>text</td><td>UUID of the user</td><td>02b8bade-c8ed-44c7-87fd-ebabeaed98c2</td></tr><tr><td>courseid</td><td>text</td><td>Course Identifier</td><td>do_213432103242072064167</td></tr><tr><td>batchid</td><td>text</td><td>Batch Identifier</td><td>0134321075692503049</td></tr><tr><td>active</td><td>boolean</td><td>User Batch Enrolment status</td><td>True</td></tr><tr><td>addedby</td><td>text</td><td></td><td>abf44b3d-877d-7de8-1da3-1603a727cb10</td></tr><tr><td><del>certificates</del></td><td>list&#x3C;frozen&#x3C;map&#x3C;text, text>>></td><td>Not Used</td><td></td></tr><tr><td><del>certstatus</del></td><td>int</td><td>Not Used</td><td></td></tr><tr><td>completedon</td><td>timestamp</td><td>Time at which user has completed the course consumption</td><td>2023-03-23 12:38:05.055000+0000</td></tr><tr><td>completionpercentage</td><td>int</td><td>Course Consumption percentage</td><td></td></tr><tr><td>contentstatus</td><td>map&#x3C;text, int></td><td>Course's Content consumption status</td><td>{'do_21337188080177971211': 2, 'do_21353023582218649615542': 2}</td></tr><tr><td>datetime</td><td>timestamp</td><td>record last updated on</td><td>2023-03-23 12:38:05.063000+0000</td></tr><tr><td>enrolled_date</td><td>timestamp</td><td>Time at which user enrolled to Course Batch</td><td>2023-03-23 12:37:12.105000+0000</td></tr><tr><td><del>enrolleddate</del></td><td>text</td><td>Not Used</td><td></td></tr><tr><td>issued_certificates</td><td>list&#x3C;frozen&#x3C;map&#x3C;text, text>>></td><td>Certificate details issued to the user upon course completion</td><td><pre class="language-json"><code class="lang-json">[{'identifier': '1-ee112467-bea6-4218-82c6-692ad62d3f76', 'lastIssuedOn': '2023-03-23T12:38:05.981+0000', 'name': 'KA merit cert', 'templateUrl': 'https://sunbirdstagingpublic.blob.core.windows.net/sunbird-content-staging/content/do_213550147041189888119/artifact/do_213550147041189888119_1654070683979_certificate_2022-06-01_13_34.svg', 'token': '', 'type': 'TrainingCertificate'}]
</code></pre></td></tr><tr><td>lastcontentaccesstime</td><td>timestamp</td><td>Latest Timestamp at which user accessed the course</td><td>2023-03-23 12:37:57.451000+0000</td></tr><tr><td>lastreadcontentid</td><td>text</td><td>Latest content id consumed by the user from the course</td><td>do_21337188080177971211</td></tr><tr><td>lastreadcontentstatus</td><td>int</td><td>Consumption completion status of the recently consumed content by the user from the course</td><td>2</td></tr><tr><td>progress</td><td>int</td><td>Count of contents part of the Course that are consumed completely</td><td>3</td></tr><tr><td>status</td><td>int</td><td>User Course consumption completion status<br>(1 -> in progress, 2 -> completed)</td><td>2</td></tr></tbody></table>

### sunbird\_courses.report\_user\_enrolments \[PRIMARY KEY (userid, courseid, batchid)]&#x20;

<mark style="color:purple;">Table same as that of 'sunbird\_courses.user\_enrolments' used for certificate migration</mark>

### sunbird\_courses.bulk\_upload\_process \[PRIMARY KEY: id]

Table used to store information about the bulk user enrolments file upload process.

<table><thead><tr><th width="182.33333333333331">Column Name</th><th width="121">Data Type</th><th>Description</th><th>Sample Data</th></tr></thead><tbody><tr><td>id</td><td>text</td><td>Bulk Upload process Id</td><td>0128261582844723205</td></tr><tr><td>data</td><td>text</td><td>Bulk Enrolment request Data</td><td><pre class="language-json"><code class="lang-json">[{"userIds":"eda95496-75db-4c98-bdcf-9812d62d49a8","batchId":"01282120178297241000"},{"userIds":"bfbd3ce2-d55e-45d2-9ca7-939dfaf18db4","batchId":"01282120178297241653"},{"userIds":"46cde213-a7fd-4f3d-a38b-f0b0b147ef60","batchId":"01282120178297241653"},{"userIds":"f8db86ba-bfe5-4f40-bfb5-c16a402beac2","batchId":"01282120178297241653"},{"userIds":"4a58a3ff-cfc2-445b-b961-3cb5b630ef90","batchId":"01282120178297241653"},{"userIds":"526f9591-c023-46cc-9c80-e8d3ec89b6b9","batchId":"01282120178297241653"},{"userIds":"e2187344-27f7-4683-8376-52181bffc4b4","batchId":"01282120178297241653"},{"userIds":"e905d310-f559-4dfc-a856-ff50a85c5e55","batchId":"01282120178297241653"},{"userIds":"872cdf0d-df7b-4845-be50-eb9d8aa37fcc","batchId":"01282120178297241653"},{"userIds":"1295ef17-38aa-48d3-ac08-e8eb9db00bd8","batchId":"01282120178297241653"},{"userIds":"e507427b-2bde-4aed-bc9a-b2b0f9020305","batchId":"01282120178297241653"},{"batchId":"0128212017829724165391350a7c-56ec-42d0-ba5e-75b2ab943d81"},{"userIds":"85fc81c7-7ac0-4416-b1c0-c8591a88fc8d","batchId":"01282120178297241653"},{"userIds":"162e2865-461c-4793-beb0-9012800b11f2","batchId":"01282120178297241653"},{"userIds":"10b11cbe-f328-4e4e-a350-bdcd54d2ba97","batchId":"01282120178297241653"},{"userIds":"ced03895-9fce-4db2-9cfe-db097ca3e224","batchId":"01282120178297241653"},{"userIds":"9cdaea2e-c7c5-4a44-b846-b4379682abd2","batchId":"01282120178297241653"}]
</code></pre></td></tr><tr><td>failureresult</td><td>text</td><td>Enrolment Failure Data</td><td><pre class="language-json"><code class="lang-json">[{"userIds":"eda95496-75db-4c98-bdcf-9812d62d49a8","batchId":"01282120178297241000","err_msg":"Invalid course batch id "},{"01282120178297241653":[]},{"01282120178297241653":[]},{"01282120178297241653":[]},{"01282120178297241653":[]},{"01282120178297241653":[]},{"01282120178297241653":[]},{"01282120178297241653":[]},{"01282120178297241653":[]},{"01282120178297241653":[]},{"01282120178297241653":[]},{"batchId":"0128212017829724165391350a7c-56ec-42d0-ba5e-75b2ab943d81","err_msg":"Invalid course batch id "},{"01282120178297241653":[]},{"01282120178297241653":[]},{"01282120178297241653":[]},{"01282120178297241653":[]},{"01282120178297241653":[]}]
</code></pre></td></tr><tr><td>objecttype</td><td>text</td><td>Bulk Upload Process Type</td><td>batchLearnerEnrol</td></tr><tr><td>processendtime</td><td>text</td><td>Time at which record processing was completed</td><td>2019-08-13 10:40:32:476+0000</td></tr><tr><td>processstarttime</td><td>text</td><td>Time at which records processing was started</td><td>2019-08-13 10:40:31:178+0000</td></tr><tr><td>status</td><td>int</td><td>Status of the Process</td><td>3</td></tr><tr><td>successresult</td><td>text</td><td>Enrolment Success Data</td><td><pre class="language-json"><code class="lang-json">[{"01282120178297241653":[{"bfbd3ce2-d55e-45d2-9ca7-939dfaf18db4":"SUCCESS"}]},{"01282120178297241653":[{"46cde213-a7fd-4f3d-a38b-f0b0b147ef60":"SUCCESS"}]},{"01282120178297241653":[{"f8db86ba-bfe5-4f40-bfb5-c16a402beac2":"SUCCESS"}]},{"01282120178297241653":[{"4a58a3ff-cfc2-445b-b961-3cb5b630ef90":"SUCCESS"}]},{"01282120178297241653":[{"526f9591-c023-46cc-9c80-e8d3ec89b6b9":"SUCCESS"}]},{"01282120178297241653":[{"e2187344-27f7-4683-8376-52181bffc4b4":"SUCCESS"}]},{"01282120178297241653":[{"e905d310-f559-4dfc-a856-ff50a85c5e55":"SUCCESS"}]},{"01282120178297241653":[{"872cdf0d-df7b-4845-be50-eb9d8aa37fcc":"SUCCESS"}]},{"01282120178297241653":[{"1295ef17-38aa-48d3-ac08-e8eb9db00bd8":"SUCCESS"}]},{"01282120178297241653":[{"e507427b-2bde-4aed-bc9a-b2b0f9020305":"SUCCESS"}]},{"01282120178297241653":[{"85fc81c7-7ac0-4416-b1c0-c8591a88fc8d":"SUCCESS"}]},{"01282120178297241653":[{"162e2865-461c-4793-beb0-9012800b11f2":"SUCCESS"}]},{"01282120178297241653":[{"10b11cbe-f328-4e4e-a350-bdcd54d2ba97":"SUCCESS"}]},{"01282120178297241653":[{"ced03895-9fce-4db2-9cfe-db097ca3e224":"SUCCESS"}]},{"01282120178297241653":[{"9cdaea2e-c7c5-4a44-b846-b4379682abd2":"SUCCESS"}]}]
</code></pre></td></tr><tr><td>uploadedby</td><td>text</td><td>UUID of the user who initiated Bulk upload process</td><td>4707a109-edee-455b-9e6c-a9a45e7f331c</td></tr><tr><td>uploadeddate</td><td>text</td><td>Time at which Bulk upload was done</td><td>2019-08-13 10:40:31:163+0000</td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://lern.sunbird.org/use/developer-guide/lms-service/data-models/cassandra/data-dictionary.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.