CDS Views for Campus Management (IS-HER-CM)

CDS View NameDescriptionSQL View Name
C_ACADEMICEVENTBOOKINGQRYAcademic Event Booking DataCACADEVENTBKNG
C_STUDENTREGISTRATIONQRYStudent Registration DataCSTUDENTREGIS
I_ACADEMICEVENTAcademic Event DataIACADEMICEVENT
I_ACADEMICEVENTBOOKINGAcademic Event Booking DataIACADEVENTBKNG
I_ACADEMICEVENTBOOKINGCUBEAcademic Event Booking Data - CubeIACADEVENTBKNGC
I_STUDENTREGISTRATIONCUBEStudent Registration - CubeISTUDENTREGISC
PIQCDSACADEMICACTIVITYAcademic ActivitiesPIQCDSACDMCACTY
PIQCDSACADEMICACTIVITYTEXTText for Academic ActivitiesPIQCDSACDMCACTYT
PIQCDSACADEMICHONORSAcademic HonorsPIQCDSACDMCHNRS
PIQCDSACADEMICHONORSTEXTTexts for Academic HonorsPIQCDSACDMCHNRST
PIQCDSACADEMICLEVELAcademic LevelsPIQCDSACDMCLVL
PIQCDSACADEMICLEVELTEXTText for Academic LevelsPIQCDSACDMCLVLT
PIQCDSACADEMICLEVELTXTAcademic Level TextPIQCDSACADLVLTXT
PIQCDSACADEMICLEVLAcademic LevelPIQCDSACADLEVL
PIQCDSACADEMICSCALEAcademic ScalePIQCDSACADSCALE
PIQCDSACADEMICSCALETEXTAcademic Scale TextPIQCDSACADSCLTXT
PIQCDSACADEMICSESSIONAcademic SessionPIQCDSACDMCSESN
PIQCDSACADEMICSESSIONTEXTText for Academic SessionsPIQCDSACDMCSESNT
PIQCDSACADEMICYEARAcademic YearPIQCDSACDMCYEAR
PIQCDSACADEMICYEARTEXTText for Academic YearsPIQCDSACDMCYEART
PIQCDSACDMCEVTAPRSLTYPEAcademic Event Type Appraisal TypesPIQCDSACDMCEVTA
PIQCDSACDMCEVTAPRSLTYPETEXTTexts for Academic Event Type Appraisal TypesPIQCDSACDMCEVTAT
PIQCDSACDMCEVTDELIVERYMODEAcademic Event Delivery ModePIQCDSEVTDELMOD
PIQCDSACDMCEVTDELIVERYMODETEXTTexts for Academic Event Delivery ModesPIQCDSEVTDELMODT
PIQCDSACDMCEVTPLNGPROCGSTSAcademic Event Planning Process StatusPIQCDSAEVTPPSTS
PIQCDSACDMCEVTPLNGPROCGSTSTEXTNames of Academic Event Planning Process StatusPIQCDSAEVTPPSTST
PIQCDSACDMCEVTTYPECATEGORYAcademic Event Type CategoryPIQCDSEVTTYPCAT
PIQCDSACDMCEVTTYPECATEGORYTEXTText for Academic Event Type CategoriesPIQCDSEVTTYPCATT
PIQCDSACDMCPRGRSCLASSFCTNTEXTText for Academic Progress ClassificationPIQCDSPRGRSCLAST
PIQCDSACDMCPRGRSCLASSIFICATIONAcademic Progress ClassificationPIQCDSPRGRSCLAS
PIQCDSACDMCPRGRSSNSTANDINGAcademic Progression Standing DataPIQCDSPRGRSSNST
PIQCDSACDMCPRGRSSNSTANDINGTEXTAcademic Progression Standing TextsPIQCDSPRGRSSNSTT
PIQCDSACDMCPRGRSSNSTNDGFINAcademic Progression Standing Financial AidPIQCDSPRGRSSNSTF
PIQCDSACDMCPRGRSSNSTNDGFINTEXTTexts for Academic Progression Standing Financial AidPIQCDSPRGRSSNSFT
PIQCDSACDMCTEACHINGMETHODAcademic Event Type Teaching MethodPIQCDSACDMCTHM
PIQCDSACDMCTEACHINGMETHODTEXTTexts for Academic Event Type Teaching MethodsPIQCDSACDMCTHMT
PIQCDSADMISSIONCATEGORYAdmission CategoryPIQCDSADMNCAT
PIQCDSADMISSIONCATEGORYTEXTText for Admission CategoriesPIQCDSADMNCATT
PIQCDSAGRREMARKAppraisal remarksPIQSQLAGRREM
PIQCDSAGRREMARKTEXTAppraisal remarks textsPIQSQLAGRREMTEXT
PIQCDSAGRSTATAppraisal statusPIQSQLAGRSTAT
PIQCDSAGRSTATTEXTAppraisal status textsPIQSQLAGRSTAT_T
PIQCDSALTASSMETHODAlternative asessment methodPIQCDSALTASMETHD
PIQCDSALTASSMETHODTEXTAlternative asessment method textPIQCDSALTASMETXT
PIQCDSAPPRAISALTYPEAppraisal typesPIQCDSAPPRTYPE
PIQCDSAPPRAISALTYPETEXTAppraisal types textsPIQCDSAPPRTYPET
PIQCDSBOOKINGCANCRSNBooking Cancellation ReasonPIQCDSBOOKCANCL
PIQCDSBOOKINGCANCRSNTEXTcancellation reason textPIQCDSCANCRSON
PIQCDSBOOKINGSTATUSBooking StatusPIQCDSBOOKSTATUS
PIQCDSBOOKINGSTATUSTEXTBooking Status Text NamePIQCDSBOOKSTATXT
PIQCDSHRP1001View for HRP1001PIQ_SQL_HRP1001
PIQCDSMODULEBOOKINGREASONModuleBookingReasonPIQCDSMODBOOKRSN
PIQCDSMODULEBOOKINGREASONTEXTModuleBookingReasonTextPIQCDSMODBKRSTXT
PIQCDSMODULECATEGORYModule CategoryPIQCDSMODULCATEG
PIQCDSMODULECATEGORYTEXTModule Category TextPIQCDSMODCATTXT
PIQCDSPROGRAMCHOICEProgram choicePIQCDS_PRGCHOIC
PIQCDSPROGRAMCHOICETEXTProgram choice text tablePIQCDS_PRGCHOICT
PIQCDSPROGRAMTYPEProgram TypesPIQCDSPROGTYPE
PIQCDSPROGRAMTYPETEXTText for Program TypesPIQCDSPROGTYPET
PIQCDSPROGREGNCLASSFCTNTEXTText for Program Registration ClassificationPIQCDSPROGREGNCT
PIQCDSPROGREGNCLASSIFICATIONProgram Registration ClassificationsPIQCDSPROGREGNC
PIQCDSPROGRESCLASIFICATIONTEXTText for Progress ClassificationsPIQCDSPRGRSCLAT
PIQCDSPROGRESSCLASSIFICATIONProgress ClassificationsPIQCDSPRGRSCLA
PIQCDSREASONReasonsPIQCDSACDMCRSN
PIQCDSREASONTEXTText for ReasonsPIQCDSACDMCRSNT
PIQCDSREGISTRATIONTYPERegistration TypesPIQCDSREGNTYPE
PIQCDSREGISTRATIONTYPETEXTText for Registrstion TypesPIQCDSREGNTYPET
PIQCDSREPETITIONTYPERepetitionTypePIQCDSREPTYPE
PIQCDSREPETITIONTYPETEXTRepetitionTypeTextPIQCDSREPTYPETXT
PIQCDSSESSIONPATTERNSessionPatternPIQCDSSESSPATT
PIQCDSSESSIONPATTERNTEXTsession pattern textPIQCDSSESPATTTXT
PIQCDSSESSIONVARIANTsession variantPIQCDSSESSVAR
PIQCDSSESSIONVARIANTTEXTSession Variant TextPIQCDSSESSVARTXT
PIQCDSSPECIALIZATIONCATEGORYSpecialization CategoriesPIQCDSSPLCAT
PIQCDSSPECIALIZATIONCATTEXTText for Specialization CategoriesPIQCDSSPLCATT
PIQCDSSTUDENTDATAStudent Data Privacy Level AssociationPIQCDSSTUDDATAP
PIQCDSSTUDENTDATATEXTStudent Data Privacy Level Text AssociationPIQCDSSTUDDATAPT
PIQCDSSTUDENTFEECATEGORYStudent fee categoryPIQCDSSTFEECATG
PIQCDSSTUDENTFEECATEGORYTEXTStudent fee category textsPIQCDSSTFEECATGT
PIQCDSSTUDENTGROUPStudent Group AssociationPIQCDSSTUDGRP
PIQCDSSTUDENTGROUPTEXTStudent Group Text AssociationPIQCDSSTUDGRPT
PIQCDSSTUDENTORIGINStudent Origin AssociationPIQCDSSTUDORIG
PIQCDSSTUDENTORIGINTEXTStudent Origin Text AssociationPIQCDSSTUDORIGT
PIQCDS_ACADEMICEVENTDATAsdsdPIQCDSACDMCEVENT
PIQCDS_ACADEMICEVENTLOCATIONAcademcPIQCDSACDMCEVTLC
PIQCDS_ACADEMICEVENTMODULEsdsPIQCDSACDMCEVTMD
PIQCDS_ACADEMICEVENTPACKAGEsdsdPIQCDSACDMCEVTPG
PIQCDS_ACADEMICHOLDDATAsdsPIQCDSACDMCHOLD
PIQCDS_ACDMCEVENTBOOKINGDATAsdsPIQCDSACDMCEVTBK
PIQCDS_ADMISSIONDATAAdmission data of students in an org./program of studyPIQCDS_ADMISSION
PIQCDS_GRADINGDATAGrading/appraisal informationPIQCDSGRADING
PIQCDS_MODULEBKGOFFERSModule booking and offersPIQCDS_MODBKOFFR
PIQCDS_MODULEBOOKINGModule BookingPIQCDSSTDMODBOOK
PIQCDS_MODULEBOOKINGDATAModule DataPIQCDSMODBKGDATA
PIQCDS_MODULEDATAModule DataPIQCDSMODBKNDATA
PIQCDS_MODULEOFFERSOfferings of a modulePIQCDS_MODOFFR
PIQCDS_ORGUNITPROGRAMSPrograms in an organizational unit/departmentPIQCDS_ORGPROG
PIQCDS_PROGRAMSTUDYStudy objects per programPIQCDS_PRG_STDY
PIQCDS_PROGRESSIONDATAProgression DataPIQCDSPRGRSSN
PIQCDS_REGISTRATIONDATAAcademic Program Registration DataPIQCDSREGNDATA
PIQCDS_SPECIALIZATIONSTUDENTSsdsPIQCDSSPLSTUDENT
PIQCDS_SPECIALIZATIONSTUDYdsdPIQCDSSPLSTDY
PIQCDS_STUDENTDATAStudent Data CDS VIewPIQCDSSTUDDATA
PIQCDS_STUDYPROGRAMffPIQCDSSTDYPROG
PIQCDS_STUDYSTUDENTADMISSIONStudents for study data (Admission)PIQCDS_CS_ST
PIQCDS_STUDYSTUDENTREGNGet Students for a Study ObjectPIQCDSCSSTREGN