# Examples of dimension & event files

### **Dimension Schema**

**Ex : School Dimension**

This is the data for all schools, clusters, blocks and districts in the state.

**If CSV is being ingested, the file name should be -> school-dimension.data.csv**

| #  | Column               | Data type | Description                                         | Validation  |
| -- | -------------------- | --------- | --------------------------------------------------- | ----------- |
| 1  | district\_id         | string    | Unique ID in the district                           | NA          |
| 2  | district\_name       | string    | Name of the district                                | NA          |
| 3  | block\_id            | string    | Unique ID in the block                              | NA          |
| 4  | block\_name          | string    | Name of the block                                   | NA          |
| 5  | cluster\_id          | string    | Unique ID in the cluster                            | NA          |
| 6  | cluster\_name        | string    | Name of the cluster                                 | NA          |
| 7  | school\_id           | string    | Unique ID in the school                             | NA          |
| 8  | school\_name         | string    | Name of the school                                  | NA          |
| 9  | schoolcategory\_name | string    | ID of the school category for the respective school | NA          |
| 10 | grade                | string    | ID of the grade present in the school               | NA          |
| 11 | latitude             | string    | Latitude of the school                              | NA          |
| 12 | longitude            | string    | Longitude of the school                             | NA          |
| 13 | udise\_code          | string    | Unique ID                                           | <p><br></p> |

### Event Schemas:

**Ex : Teacher Attendance**

This program entails indicators to monitor compliance and performance of teacher attendance. Following are the reports within this program:

* **Teacher Attendance Compliance:** This report shows the compliance of attendance being marked by teachers.
* **Teacher Attendance Summary:** This report shows the summary of teachers being present in the school (out of the ones marking their attendance).

Following schema will be required to enable the teacher attendance program:

**If CSV is being ingested, the file name should be -> teachersattendance-event.data.csv**

#### **Note: The name for grammar file & event file should be same. e.g: teachersattendance-event.data.csv , teachersattendance-event.grammar.csv**

| #  | Column Name                  | Data Type | Description                                                            | Validation                              |
| -- | ---------------------------- | --------- | ---------------------------------------------------------------------- | --------------------------------------- |
| 1  | date                         | string    | Date when the data was recorded                                        | <p>DD/MM/YY</p><p>format to be used</p> |
| 2  | district\_id                 | string    | Unique ID of the district as per the dimension table                   | NA                                      |
| 3  | block\_id                    | string    | Unique ID of the block as per the dimension table                      | NA                                      |
| 4  | cluster\_id                  | string    | Unique ID of the cluster as per the dimension table                    | NA                                      |
| 5  | school\_id                   | string    | Unique ID of the school as per the dimension table                     | NA                                      |
| 6  | schoolcategory\_name         | string    | Category\_id which the school ID belongs to as per the dimension table | NA                                      |
| 7  | grade                        | string    | Grade for which the data is being entered                              | NA                                      |
| 8  | total\_teachers              | string    | Total number of teachers                                               | NA                                      |
| 9  | teachers\_attendance\_marked | string    | Total number of teachers whose attendance was marked                   | NA                                      |
| 10 | teachers\_marked\_present    | string    | Total number of teachers who were present                              | NA                                      |

#### NOTE :  Each metric should be part of a separate event table.&#x20;

E.g. In teacher attendance event file, we will have 3 tables: one for total\_teachers, one for teachers\_attendance\_marked & one for teachers\_marked\_present


---

# 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://cqube.sunbird.org/use-cqube/getting-started-1/examples-of-dimension-and-event-files.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.