CEP Datasets
CEP Datasets
EdCast Marketplace event data is processed and stored inside EdData. Below are the Marketplace datasets.
- mkp_course_dim_m
- mkp_course_event_dim_m
- mkp_class_events_dim_m
- mkp_course_event_instructors_dim_m
- mkp_addresses_dim_m
- mkp_class_event_learners_dim_m
- mkp_users_dim_m
- mkp_agenda_item_attendances_dim_m
- mkp_agenda_items_dim_m
- mkp_course_event_reviews_dim_m
- mkp_course_event_buyer_specifications_dim_m
- mkp_certificate_template_dim_m
- mkp_custom_attendance_dim_m
- mkp_external_meeting_dim_m
Courses
(mkp_course_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| agendaEditable | Boolean | |
| agoraProductSegmentCode | String | |
| agoraProductSegmentNonEditable | Boolean | |
| agoraProductSegmentValue | String | |
| archived | Boolean | |
| automaticApproval | Boolean | |
| availableForCourseCreation | Boolean | |
| availableForQuotations | Boolean | |
| averageRating | Double | |
| bannerKey | String | |
| catalogCode | String | |
| categoryCode | String | |
| categoryId | String | |
| categoryName | String | |
| code | String | |
| description | String | |
| durationInDays | Decimal (19,2) | |
| durationInHours | Decimal (19,2) | |
| editLock | Boolean | |
| externalId | String | |
| externalSKU | String | |
| hasCustomImage | Boolean | |
| internalOnly | Boolean | |
| isInternal | Boolean | |
| maxSeats | Integer | |
| maxSeatsBookedAtOnce | Integer | |
| name | String | |
| objectives | String | |
| online | Boolean | |
| onlineDelivery | Boolean | |
| registrationApprovalRequired | Boolean | |
| root | Boolean | |
| subcategoryCode | String | |
| subcategoryName | String | |
| tab | String | |
| targetAudience | String | |
| thumbnailBucket | String | |
| thumbnailKey | String | |
| thumbnailProcess | Boolean | |
| thumbnailUrl | String | |
| totalNumberOfReviews | Integer | |
| waitingList | Boolean | |
| waitingListSize | Integer | |
| format_id | String | |
| language_id | String | |
| level_id | String | |
| parent_id | String | |
| participationCertificate_id | String | |
| seat_cancellation_policy_definition | String | |
| seat_cancellation_policy_config_id | String | |
| level | String | |
| format | String | |
| publish_status | String | |
| language | String | |
| enrollment_policy | String | |
| seat_cancellation_policy_value | String | |
| courseCustomAttributes | String | |
| publishStatus_id | String | |
| lxpRestrictGroups | String | |
| lxpPrivate | Boolean | |
| lxpRestrictUsers | String | |
| enrollmentPolicy_id | String | |
| cancellationPolicy_id | String | |
| version | Integer | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| hour | String |
Course Events
(mkp_course_event_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| automaticCourseCompletion | Boolean | |
| averageRating | Double | |
| cancellationMessage | String | |
| conferenceLink | String | |
| csvBucket | String | |
| csvKey | String | |
| enrolledLearnerCounter | Integer | |
| historical | Boolean | |
| isInternal | Boolean | |
| nextTicketNumber | Integer | |
| publishEvent | Boolean | |
| registrationDeadline | Timestamp | |
| registrationDeadlineDependsOnEventStartDate | Boolean | |
| remainingSeats | Integer | |
| returnPeriodDependsOnEventStartDate | Boolean | |
| returnablePeriod | Timestamp | |
| reviewsEnabled | Boolean | |
| selfRegistration | Boolean | |
| serviceMarketplaceOrigin | Boolean | |
| sku | String | |
| step | String | |
| totalNumberOfReviews | Integer | |
| trainingManagerEmail | String | |
| trainingManagerId | String | |
| trainingManagerName | String | |
| userLock | Boolean | |
| classEvent_id | String | |
| course_id | String | |
| instructor_id | String | |
| venuePreparationType_id | String | |
| waitingQueueStatus_id | String | |
| launchURL | String | |
| externalMeetingType_id | String | |
| automaticAttendanceCompletion | Boolean | |
| automaticAttendanceTracking | Boolean | |
| completionRate | Integer | |
| waitingListRemainingSeats | Integer | |
| expected_venue_type | String | |
| external_meeting_type | String | |
| waiting_list_status | String | |
| version | Integer | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| hour | String |
Class Events
(mkp_class_events_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| dateReleasedOn | Timestamp | |
| displayName | String | |
| endDate | Timestamp | |
| name | String | |
| redirectLearnerEmails | String | |
| releaseDate | Timestamp | |
| releaseDateWithZone | Timestamp | |
| releasedManually | Boolean | |
| selfPacedClass | Boolean | |
| startDate | Timestamp | |
| timezone | String | |
| virtualVenue | Boolean | |
| certificate_id | String | |
| status_id | String | |
| type_id | String | |
| venue_id | String | |
| status | String | |
| type | String | |
| version | Integer | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| hour | String |
Course Event Instructors
(mkp_course_event_instructors_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| courseEvent_id | String | |
| instructor_id | String | |
| main | Boolean | |
| version | Integer | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| hour | String |
Addresses
(mkp_addresses_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| address | String | |
| city | String | |
| country | String | |
| name | String | |
| postalCode | String | |
| province | String | |
| room | String | |
| state | String | |
| transactional | Boolean | |
| parent_id | String | |
| houseNumber | String | |
| version | Integer | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| hour | String |
Class Event Learners
(mkp_class_event_learners_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| user_id | String | |
| classEvent_id | String | |
| status_id | String | |
| completionPercentage | Integer | |
| markedAsCompletedOn | Timestamp | |
| enrollmentDate | Timestamp | |
| iCalSequence | Integer | |
| seatSku | String | |
| waitingQueueTicketNumber | Integer | |
| rebookCount | Integer | |
| status | String | |
| version | Integer | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| hour | String |
Users
(mkp_users_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| externalId | String | |
| firstName | String | |
| lastName | String | |
| username | String | |
| isRegistered | Boolean | |
| language | String | |
| timeZone | String | |
| type | String | |
| invitationSent | Boolean | |
| whitelisted | Boolean | |
| consentDate | Timestamp | |
| privacyPolicyLastUpdateDate | Timestamp | |
| invitationResentTimes | Integer | |
| String | ||
| instructorRole | Boolean | |
| lxpUser | Boolean | |
| hybrid | Boolean | |
| avatar | String | |
| version | Integer | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| hour | String |
Agenda Item Attendances
(mkp_agenda_item_attendances_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| agendaItem_id | String | |
| attendance_id | String | |
| learner_id | String | |
| participationTime | Integer | |
| customAttendance_id | String | |
| status | String | |
| version | Integer | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| time | String |
Agenda Items
(mkp_agenda_items_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| agenda_day | Integer | |
| description | String | |
| duration | Integer | |
| endDateTime | Timestamp | |
| itemOrder | Integer | |
| startDateTime | Timestamp | |
| title | String | |
| course_agenda_id | String | |
| type_id | String | |
| externalMeetingEnabled | Boolean | |
| meeting_id | String | |
| type | String | |
| version | Integer | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| time | String |
Course Event Reviews
(mkp_course_event_reviews_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| anonymous | Boolean | |
| message | String | |
| rating | Integer | |
| course_event_id | String | |
| reviewer_id | String | |
| status_id | String | |
| status | String | |
| version | Integer | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| hour | String |
Course Event Buyer Specifications
(mkp_course_event_buyer_specifications_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| automaticApproval | Boolean | |
| automaticCourseCompletion | Boolean | |
| registrationDeadline | Timestamp | |
| registrationDeadlineDependsOnEventStartDate | Boolean | |
| selfRegistration | Boolean | |
| status_id | String | |
| status | String | |
| trainingManagerEmail | String | |
| trainingManagerId | String | |
| trainingManagerName | String | |
| courseEvent_id | String | |
| seatPurchaseOrigin | Boolean | |
| launchURL | String | |
| version | Integer | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| time | String |
Certificate Template
(mkp_certificate_template_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| displayName | String | |
| s3Bucket | String | |
| s3Key | String | |
| sku | String | |
| status_id | String | |
| type_id | String | |
| validityPeriod | Integer | |
| fileName | String | |
| status | String | |
| type | String | |
| version | Integer | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| hour | String |
Custom Attendance
(mkp_custom_attendance_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| config | Boolean | |
| customAttendanceName | String | |
| reason | String | |
| reasonMandatory | Boolean | |
| status_id | String | |
| status | String | |
| version | String | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| hour | String |
External Meeting
(mkp_external_meeting_dim_m)
| Name | Type | Description |
|---|---|---|
| id | String | |
| externalId | BigInt | |
| joinURL | String | |
| duration | Integer | |
| version | Integer | |
| domain_id | String | |
| created_by | String | |
| created_at | Timestamp | |
| updated_by | String | |
| updated_at | Timestamp | |
| deleted | Boolean | |
| deleted_by | String | |
| deleted_at | Timestamp | |
| org_id_s | String | |
| record_insert_time | String | |
| yr | String | |
| month | String | |
| day | String | |
| hour | String |
Updated over 2 years ago