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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
81491 | 223 | 1on1-25-Meg | 2023-07-07 | 12:20 | Past | 81,491 | 0 | 12: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. | ||||||||
81490 | 223 | 1on1-25-Meg | 2023-06-30 | 12:20 | Past | 81,490 | 0 | 0 | 12:50 | 65 | 0 | 0 | 0 | 0 | -0001-11-30 | 1 | 0 | 0 | 0 | 10 | 1,800 | 1 | daily_25 | 1 | 0 | ALL | This class is a one to one class and costs 2 points. The teacher will be able to focus on the student's English and help them improve as an individual. 25 minutes. | ||||
81489 | 223 | 1on1-25-Meg | 2023-08-09 | 12:20 | Past | 81,489 | 0 | 12: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. | ||||||||
81482 | 1084 | 中級 Gary | 2023-06-25 | 22:50 | Past | 81,482 | 0 | 23:50 | 65 | 0 | 0 | 6 | 0 | 0 | 0 | 10 | 3,600 | 1 | business_advanced | 1 | 0 | ALL | |||||||||
81483 | 1084 | 1on1-45-Gary | 2023-06-25 | 07:50 | Past | 81,483 | 0 | 0 | 08:50 | 65 | 0 | 0 | 0 | 0 | -0001-11-30 | 1 | 0 | 0 | 0 | 10 | 3,600 | 1 | daily_all | 1 | 0 | ALL | This class is a one to one class and costs 4 points. The teacher will be able to focus on the student's English and help them improve as an individual. 45 minutes. | ||||
81481 | 1423 | 中級 Cara | 2023-06-25 | 22:50 | Past | 81,481 | 0 | 23:50 | 65 | 0 | 0 | 6 | 0 | 0 | 0 | 10 | 3,600 | 1 | daily_advanced | 1 | 0 | ALL | |||||||||
81479 | 1423 | 中級 Cara | 2023-06-25 | 21:50 | Past | 81,479 | 0 | 22:50 | 65 | 0 | 0 | 6 | 0 | 0 | 0 | 10 | 3,600 | 1 | business_advanced | 1 | 0 | ALL | |||||||||
81480 | 1084 | (O)初級 Gary | 2023-06-25 | 21:50 | Past | 81,480 | 0 | 22:50 | 65 | 0 | 0 | 6 | 0 | 0 | 0 | 10 | 3,600 | 1 | daily_basic | 0 | 0 | ALL | |||||||||
81478 | 218 | 上級 Lala | 2023-06-25 | 20:50 | Past | 81,478 | 0 | 21:50 | 65 | 0 | 0 | 6 | 0 | 0 | 0 | 10 | 3,600 | 1 | business_super | 1 | 0 | ALL | |||||||||
81477 | 212 | Open Talk Hana | 2023-06-25 | 20:50 | Past | 81,477 | 0 | 21:50 | 65 | 0 | 0 | 6 | 0 | 0 | 0 | 10 | 3,600 | 1 | daily_entry | 1 | 0 | ALL | Open Talk Lesson intended for Basic Level students. | ||||||||
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 |
---|---|---|---|---|---|---|---|
85868 | 212 | 212 | 0 | 1 | 174882 | ||
85732 | 77 | 218 | 0 | 1 | 174881 | ||
85888 | 1464 | 226 | 1 | 1 | 174780 | ||
85889 | 1464 | 226 | 1 | 1 | 174781 | ||
85890 | 1464 | 226 | 1 | 1 | 174782 | ||
85891 | 1464 | 226 | 1 | 1 | 174783 | ||
85698 | 194 | 194 | 0 | 1 | 174784 | ||
85700 | 218 | 218 | 0 | 1 | 174785 | ||
85699 | 1515 | 1515 | 0 | 1 | 174786 | ||
85699 | 151 | 1515 | 0 | 1 | 174787 | ||
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 |
1327 | 6 | 89766 | alloc_hrs |
1314 | 1 | 86209 | alloc_hrs |
1286 | 1 | 83457 | alloc_hrs |
77 | 8 | 8124 | alloc_hrs |
178 | 4 | 8130 | alloc_hrs |
90 | 15 | 8134 | alloc_hrs |
19 | 2 | 8136 | alloc_hrs |
37 | 1 | 8138 | alloc_hrs |
179 | 1 | 8142 | 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 |
---|---|---|---|---|---|---|
85748 | Super Lala | 2023-12-24 | 218 | 148 | -2 | 0 |
85726 | 1on1-45 DJ | 2023-12-23 | 1510 | 67 | -2 | 0 |
85742 | 1on1-45 DJ | 2023-12-24 | 1510 | 67 | -2 | 0 |
85731 | 1on1-45 Jackie | 2023-12-23 | 213 | 67 | -2 | 0 |
85814 | 1on1-45 Ako | 2023-12-28 | 1514 | 43 | -2 | 0 |
85883 | 1on1-25-Kumiko | 2024-01-04 | 217 | 1132 | -2 | 0 |
85749 | Open Talk Hana | 2023-12-24 | 212 | 260 | -2 | 0 |
85254 | ASPJ2 Juanita | 2023-11-30 | 1513 | 1446 | -2 | 0 |
85348 | ASP8 Dave | 2023-12-04 | 201 | 969 | -2 | 0 |
85135 | 1on1-45 Jackie | 2023-11-25 | 213 | 761 | -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