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 1 year ago