Class Records
| ZE Class ID | Instructor | Class Name | Date | Start Time | Status | parent_id | course_id | Braincert ID | end_time | classtimezone | ispaid | is_recurring | is_repeat | weekdays | end_classes_count | end_date | attendee_limit | recordclass | recording_id | recording_url | is_board | is_lang | region | duration | sync | vc_user_id | class_level | reserved | restricted | user_role | description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 95717 | 178 | Basic Alex | 2025-02-18 | 20:50 | Past | 95,717 | 0 | 21:50 | 65 | 0 | 0 | 6 | 0 | 0 | 0 | 10 | 3,600 | 1 | daily_basic | 1 | 0 | ALL | |||||||||
| 95718 | 1583 | 1on1-45 Brandon | 2025-02-18 | 20:50 | Past | 95,718 | 0 | 21:50 | 65 | 0 | 0 | 1 | 0 | 0 | 0 | 10 | 3,600 | 1 | daily_all | 1 | 0 | ALL | This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 45min lesson. | ||||||||
| 95713 | 1513 | 1on1-25 Juanita | 2025-02-18 | 17:20 | Past | 95,713 | 0 | 17:50 | 65 | 0 | 0 | 1 | 0 | 0 | 0 | 10 | 1,800 | 1 | daily_25 | 1 | 0 | ALL | This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 25min lesson. | ||||||||
| 96257 | 212 | 1on1-45 Hana | 2025-03-06 | 20:50 | Past | 96,257 | 0 | 0 | 21:50 | 65 | 0 | 0 | 0 | 0 | -0001-11-30 | 1 | 0 | 0 | 0 | 10 | 3,600 | 1 | daily_all | 0 | 0 | ALL | This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 45min lesson. | ||||
| 95742 | 178 | Advanced Alex | 2025-02-19 | 21:50 | Past | 95,742 | 0 | 22:50 | 65 | 0 | 0 | 6 | 0 | 0 | 0 | 10 | 3,600 | 1 | daily_advanced | 1 | 0 | ALL | |||||||||
| 95743 | 214 | 1on1-45 Jim | 2025-02-19 | 21:50 | Past | 95,743 | 0 | 22:50 | 65 | 0 | 0 | 1 | 0 | 0 | 0 | 10 | 3,600 | 1 | daily_all | 1 | 0 | ALL | This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 45min lesson. | ||||||||
| 95733 | 201 | Advanced Dave | 2025-02-19 | 09:50 | Past | 95,733 | 0 | 10:50 | 65 | 0 | 0 | 6 | 0 | 0 | 0 | 10 | 3,600 | 1 | daily_advanced | 1 | 0 | ALL | |||||||||
| 95734 | 201 | Elite (R) Dave | 2025-02-19 | 10:50 | Past | 95,734 | 0 | 11:50 | 65 | 0 | 0 | 6 | 0 | 0 | 0 | 10 | 3,600 | 1 | daily_super | 1 | 1 | ALL | This is for students who are critical thinkers who can analyse different situations using their English and have strong discussion skills. | ||||||||
| 95712 | 1513 | 1on1-25 Juanita | 2025-02-18 | 16:50 | Past | 95,712 | 0 | 17:20 | 65 | 0 | 0 | 1 | 0 | 0 | 0 | 10 | 1,800 | 1 | daily_25 | 1 | 0 | ALL | This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 25min lesson. | ||||||||
| 95579 | 178 | 1on1-45 Alex | 2025-02-12 | 22:50 | Past | 95,579 | 0 | 23:50 | 65 | 0 | 0 | 1 | 0 | 0 | 0 | 10 | 3,600 | 1 | daily_all | 1 | 0 | ALL | This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 45min lesson. | ||||||||
| ZE Class ID | Instructor | Class Name | Date | Start Time | Status | parent_id | course_id | Braincert ID | end_time | classtimezone | ispaid | is_recurring | is_repeat | weekdays | end_classes_count | end_date | attendee_limit | recordclass | recording_id | recording_url | is_board | is_lang | region | duration | sync | vc_user_id | class_level | reserved | restricted | user_role | description |
Attendance - Editable
| ZE Class ID | Student ID | Teacher ID | Registered | Attended | Attendance ID | Level | level_date |
|---|---|---|---|---|---|---|---|
| 91723 | 761 | 194 | -1 | 0 | 187140 | ||
| 91727 | 761 | 226 | -1 | 0 | 187141 | ||
| 91821 | 1258 | 1584 | -1 | 0 | 187204 | ||
| 91705 | 260 | 1513 | -2 | 0 | 187176 | ||
| 91802 | 260 | 1584 | -2 | 0 | 187173 | ||
| 91745 | 260 | 226 | -1 | 0 | 187172 | ||
| 92005 | 1587 | 1533 | 1 | 1 | 187153 | ||
| 92336 | 1592 | 214 | -1 | 0 | 187759 | ||
| 92334 | 1592 | 218 | -1 | 0 | 187757 | ||
| 92333 | 1592 | 218 | -1 | 0 | 187756 | ||
| ZE Class ID | Student ID | Teacher ID | Registered | Attended | Attendance ID | Level | level_date |
Please choose input type for columns that you want to edit
Allocated Hours
| User ID | Allocated Hours | umeta_id | meta_key |
|---|---|---|---|
| 1401 | 1 | 100816 | alloc_hrs |
| 1314 | 1 | 86209 | alloc_hrs |
| 1286 | 1 | 83457 | alloc_hrs |
| 77 | 9 | 8124 | alloc_hrs |
| 178 | 4 | 8130 | alloc_hrs |
| 90 | 18 | 8134 | alloc_hrs |
| 37 | 1 | 8138 | alloc_hrs |
| 179 | 1 | 8142 | alloc_hrs |
| 136 | 12 | 8144 | alloc_hrs |
| 133 | 13 | 8148 | alloc_hrs |
| User ID | Allocated Hours | umeta_id | meta_key |
Please choose input type for columns that you want to edit
Unused Reservations
| ZE Class ID | Class Name | Date | Teacher ID | User ID | registered | attended |
|---|---|---|---|---|---|---|
| 96636 | ASP-1on1 Gary | 2025-03-24 | 1084 | 1300 | -2 | 0 |
| 96555 | ASPJ5 Juanita | 2025-03-21 | 1513 | 1441 | -2 | 0 |
| 96555 | ASPJ5 Juanita | 2025-03-21 | 1513 | 1444 | -2 | 0 |
| 96534 | ASPJ4 Juanita | 2025-03-20 | 1513 | 1272 | -2 | 0 |
| 96515 | ASPJ8 Juanita | 2025-03-19 | 1513 | 1272 | -2 | 0 |
| 96514 | ASPJ7 Juanita | 2025-03-19 | 1513 | 1272 | -2 | 0 |
| 96489 | ASPJ4 Juanita | 2025-03-18 | 1513 | 1272 | -2 | 0 |
| 96488 | ASPJ5 Dave | 2025-03-18 | 201 | 1272 | -2 | 0 |
| 96487 | ASPJ4 Juanita | 2025-03-18 | 1513 | 1272 | -2 | 0 |
| 96486 | ASPJ5 Juanita | 2025-03-18 | 1513 | 1272 | -2 | 0 |
| ZE Class ID | Class Name | Date | Teacher ID | User ID | registered | attended |
Please choose input type for columns that you want to edit
Memberpress Transactions
| ID | User ID | Transaction Number | Date Created |
|---|---|---|---|
| 17017 | 1259 | mp-txn-65e1ca221b3bd | 2024-03-01 12:29 |
| 5 | 178 | mp-txn-58e2f4ef1a6ab | 2017-04-04 01:20 |
| 6 | 194 | mp-txn-58e2f5ad2ff1c | 2017-04-04 01:23 |
| 17016 | 127 | ch_3OpNoFIFISrEtWMJ1cCG2lTH | 2024-03-01 04:35 |
| 9 | 201 | mp-txn-58e2f6f6b89e5 | 2017-04-04 01:29 |
| 17015 | 9 | ch_3OpNmpIFISrEtWMJ0wbhEFmD | 2024-03-01 04:33 |
| 12 | 237 | mp-txn-58e2f7dd1dfb6 | 2017-04-04 01:33 |
| 13 | 234 | mp-txn-58e2f82f4c585 | 2017-04-04 01:34 |
| 14 | 215 | mp-txn-58e2f87bc8b61 | 2017-04-04 01:35 |
| 17014 | 1300 | ch_3OpNR5IFISrEtWMJ0AlWh1QA | 2024-03-01 04:11 |
| ID | User ID | Transaction Number | Date Created |
Please choose input type for columns that you want to edit
