PiqCds_GradingData

Column Name Description
AppraisalID FK Appraisal ID
Column Name Description
Column Name Description
📏 Unit of Measurement for Credits (AppraisalCreditUnit):
AppraisalAttemptedCredits Attempted Credits
AppraisalEarnedCredits Earned Credits
AppraisalGradedCredits Graded Credits
Column Name Description
AppraisalValidityStartDate Start of Appraisal Validity
AppraisalValidityEndDate End of Appraisal Validity
AppraisalEarliestGradingDate Earliest Appraisal Date
AppraisalLatestGradingDate Latest Appraisal Date
LastDayOfAttendance Last Day of Attendance
AppraisalDate Appraisal Date
Column Name Description
AppraisalGradeIsNotRelevant Appraisal Grade Not Relevant Show values
AppraisalIsCompleted Appraisal Completed Show values
AppraisalGradeHasChanged Appraisal Grade Changed Show values
Column Name Description Domain name
ModuleId Extended Object ID CHAR45
ModuleShortName Object Abbreviation TEXT12
ModuleName Object Name TEXT40
StudentObjectID ID of Related Object CHAR45
StudentNumber Object Abbreviation TEXT12
StudentName Object Name TEXT40
ModuleBookingID Module Booking Identification SYSUUID_C
AuditID Audit ID SYSUUID_C
ProgramOfStudy ID of Related Object CHAR45
ProgramOfStudyName Object Name TEXT40
ProgramOfStudyShortName Object Abbreviation TEXT12
AttemptNumber Repetition Attempt Number NUM03
AppraisalTypeName Appraisal Type (Description) TEXT25
AppraisalStatusName Appraisal Status (Description) TEXT30
agrremark Appraisal Remark PIQAGRREMARK
AppraisalRemarkText Appraisal Remark (Description) TEXT30
AcademicYearName Academic Year (Description) TEXT20
AcademicSessionName Academic Session (Description) TEXT20
AppraisalWeighting Appraisal Weighting PIQAGRWEIGHT
AppraisalGradeSymbol Grade Symbol PIQGRADESYM
AppraisalStandardGradeValue Std Value for Scale Value PIQSCALE_NORM_VAL
AcademicScaleName Academic Scale (Description) PIQSCALE_TEXT
AppraisalNoteID GUID - Unique Note Identifier SYSUUID_C
AppraisalText Appraisal (Description) TEXT50
Master Data Relations Join Conditions
Academic Session
  • Academic Session
  • Client
Academic Year
  • Academic Year
  • Client
  • PIQCDS_GRADINGDATA.ACADEMICYEAR == T7PIQYEAR.PERYR
  • PIQCDS_GRADINGDATA.MANDT == T7PIQYEAR.MANDT
Appraisal Status
  • Appraisal Status
  • Client
Academic Scale Identification (ID)
  • Academic Scale Identification (ID)
  • Client
  • PIQCDS_GRADINGDATA.APPRAISALGRADINGSCALE == T7PIQSCALE.SCALEID
  • PIQCDS_GRADINGDATA.MANDT == T7PIQSCALE.MANDT
Appraisal Type
  • Appraisal Type
  • Client