PiqCds_OrgUnitPrograms

Programs in an organizational unit/department | view: PIQCDS_ORGPROG | Extraction: Not supported | Component: Campus Management
Column Name Description
OrganizationalUnit FK Object ID
OrgProgStartDate Start Date
OrgProgEndDate End Date
ActivePlanVersion FK Plan Version
ProgramOfStudy ID of Related Object
Column Name Description
Column Name Description
Column Name Description
OrgProgStartDate Start Date
OrgProgEndDate End Date
Column Name Description
Column Name Description Domain name
OrganizationalUnitShortName Object Abbreviation TEXT12
OrganizationalUnitName Object Name TEXT40
ProgramOfStudyShortName Object Abbreviation TEXT12
ProgramOfStudyName Object Name TEXT40
ProgramOfStudyType Program Type PIQPROGC_VAR
ProgramOfStudyTypeName Program Type (Description) TEXT30
OrgProgPriority Priority CHAR2
Master Data Relations Join Conditions
Plan Version
  • Plan Version
  • Client
  • PIQCDS_ORGUNITPROGRAMS.ACTIVEPLANVERSION == T778P.PLVAR
  • PIQCDS_ORGUNITPROGRAMS.MANDT == T778P.MANDT
Object ID
  • Plan Version
  • Client
  • ?
  • Object ID
  • PIQCDS_ORGUNITPROGRAMS.ACTIVEPLANVERSION == PLOGI.PLVAR
  • PIQCDS_ORGUNITPROGRAMS.MANDT == PLOGI.MANDT
  • PIQCDS_ORGUNITPROGRAMS.[column in domain "OTYPE"] == PLOGI.OTYPE
  • PIQCDS_ORGUNITPROGRAMS.ORGANIZATIONALUNIT == PLOGI.OBJID