PiqCds_AcdmcEventBookingData

Column Name Description
Column Name Description
Column Name Description
Column Name Description
AcademicEventStartDate Start Date
AcademicEventStartTime Start Time
AcademucEventEndDate End Date
AcadelicEventEndTime End Time
Column Name Description
AcademicEventIsDeleted Delete flag Show values
AcademicEventIsExternal Display external business event Show values
AcademicEventIsLocked Lock flag Show values
IsEvTypeAttendanceCompulsory Attendance Compulsory Show values
Column Name Description Domain name
StudentNumber Object Abbreviation TEXT12
StudentName Object Name TEXT40
ModuleBookingID Module Booking Identification SYSUUID_C
AcademicEventName Object Name TEXT40
AcademicEventShortName Object Abbreviation TEXT12
AcademicEventInstructor Instructor Identification (ID) NUM08
AcademicEventInstructorName null
AcademicEventInstructorType Instructor Object Type OTYPE
AcdmcEventInstructorTypeName Object Type Text TEXT25
AcademicEventLocation ID of Related Object CHAR45
AcademicEventLocationName Object Name TEXT40
AcademicEventLocationShortName Object Abbreviation TEXT12
AcademicEventPackage ID of Related Object CHAR45
AcademicEventPackageName Object Name TEXT40
AcademicEventPackageShortName Object Abbreviation TEXT12
AcademicEventRoom Business event room: Key NUM08
AcademicEventRoomName Object Name TEXT40
AcademicEventRoomShortName Object Abbreviation TEXT12
AcademicEventType ID of Related Object CHAR45
AcademicEventTypeName Object Name TEXT40
AcademicEventTypeShortName Object Abbreviation TEXT12
AcademicEventTypeCategory Category PIQCATEGORY
AcademicEventTypeCategoryName Category (Description) TEXT40
AcademicSession Academic Session PIQPERID
AcademicSessionName Academic Session (Description) TEXT20
AcademicYear Academic Year PIQPERYR
AcademicYearName Academic Year (Description) TEXT20
AcdmcEventTypeDeliveryMode Delivery Mode PIQDELMODE
AcdmcEventTypeDeliveryModeName Delivery Mode (Description) TEXT40
AcdmcEvtCancellationReasonName Text: reason for cancellation of business event TEXT40
AcdmcEvtTypeAppraisalType Appraisal Type PIQAGRTYPE
AcdmcEvtTypeAppraisalTypeName Appraisal Type (Description) TEXT25
AcdmcEvtTypeTeachingMethod Teaching Method PIQMETHOD
AcdmcEvtTypeTeachingMethodName Teaching Method (Description) TEXT40
NumberOfTotalBookings Number of normal bookings NUMC5
StudyModule ID of Related Object CHAR45
StudyModuleName Object Name TEXT40
StudyModuleShortName Object Abbreviation TEXT12
Master Data Relations Join Conditions
Object ID
  • Client
  • Object ID
  • Object ID
  • ?
  • ?
  • PIQCDS_ACDMCEVENTBOOKINGDATA.MANDT == PLOGI.MANDT
  • PIQCDS_ACDMCEVENTBOOKINGDATA.STUDENTOBJECTID == PLOGI.OBJID
  • PIQCDS_ACDMCEVENTBOOKINGDATA.ACADEMICEVENT == PLOGI.OBJID
  • PIQCDS_ACDMCEVENTBOOKINGDATA.[column in domain "OTYPE"] == PLOGI.OTYPE
  • PIQCDS_ACDMCEVENTBOOKINGDATA.[column in domain "PLVAR"] == PLOGI.PLVAR
Business event language PIQCDS_ACDMCEVENTBOOKINGDATA.ACADEMICEVENTLANGUAGE == T002.SPRAS
Foreign key: reason for cancellation
  • Key: reason for cancellation of business event
  • Client
  • PIQCDS_ACDMCEVENTBOOKINGDATA.ACDMCEVTCANCELLATIONREASON == T77CR.CANCR
  • PIQCDS_ACDMCEVENTBOOKINGDATA.MANDT == T77CR.MANDT
Subtype
  • Client
  • ?
  • Subtype
  • PIQCDS_ACDMCEVENTBOOKINGDATA.MANDT == T778U.MANDT
  • PIQCDS_ACDMCEVENTBOOKINGDATA.[column in domain "INFOTYP"] == T778U.INFTY
  • PIQCDS_ACDMCEVENTBOOKINGDATA.RELATIONSHIPSUBTYPE == T778U.SUBTY
Object ID
  • Client
  • Object ID
  • Object ID
  • ?
  • ?
  • PIQCDS_ACDMCEVENTBOOKINGDATA.MANDT == PLOGI.MANDT
  • PIQCDS_ACDMCEVENTBOOKINGDATA.STUDENTOBJECTID == PLOGI.OBJID
  • PIQCDS_ACDMCEVENTBOOKINGDATA.ACADEMICEVENT == PLOGI.OBJID
  • PIQCDS_ACDMCEVENTBOOKINGDATA.[column in domain "OTYPE"] == PLOGI.OTYPE
  • PIQCDS_ACDMCEVENTBOOKINGDATA.[column in domain "PLVAR"] == PLOGI.PLVAR