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

linkedIn

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


© 2020 EdCast Inc.