Examples of dimension & event files

This page gives an example of cQube Dimension & Event schema for better understanding

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

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	DD/MM/YY format to be used
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.

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