| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DOCID | Activity Document Identification Key | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | LINE | Activity Document: Segment Line Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | ID | Module Booking Identification | nvarchar | 32 | 0 | | | | Allow NULL? |
| 5 | PACKNUMBER | Event Package | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | TRANSFERFLAG | External Academic Work or Qualification Transferred | char | 1 | 0 | | | | Allow NULL? |
| 7 | ANNULMENT | Exclusion Indicator for Module Bookings | char | 1 | 0 | | | | Allow NULL? |
| 8 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | PERID | Academic Session | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | PERYR | Academic Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | BOOKDATE | Booking Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | SMRATING | Alternative Assessment Method for Module | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | STORREASON | Cancellation Reason | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | STORDATE | Cancellation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | COBOK | Conditional Booking | char | 1 | 0 | | | | Allow NULL? |
| 17 | SMSTATUS | Module Booking Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | BOOKREASON | Module Booking Reason | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | AGRID | Appraisal ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 20 | AGRTYPE | Appraisal Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | AGRSTAT | Appraisal Status | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | AGRNOTRATED | Appraisal Grade Not Relevant | char | 1 | 0 | | | | Allow NULL? |
| 23 | AGRDATE | Appraisal Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | NOTEID | GUID - Unique Note Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 25 | AGRREMARK | Appraisal Remark | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | AGRBEGDA | Start of Appraisal Validity | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | AGRENDDA | End of Appraisal Validity | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | PLVAR | Plan Version | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | OTYPE | Object Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 30 | OBJID | Object ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | IS_ACST_USED | Relevant for Academic Standing | char | 1 | 0 | | | | Allow NULL? |
| 32 | IS_ACSTFA_USED | Relevant for Academic Standing Based On Financial Aid Rules | char | 1 | 0 | | | | Allow NULL? |
| 33 | IS_PRCL_USED | Relevant for Progress Classification | char | 1 | 0 | | | | Allow NULL? |
| 34 | IS_PRCLFA_USED | Relevant for Progress Classification Based On FA Regulations | char | 1 | 0 | | | | Allow NULL? |
| 35 | IS_AWARD_USED | Relevant for Academic Honors | char | 1 | 0 | | | | Allow NULL? |
| 36 | PROG_KEY_DATE | Valid From Date for Progression | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | AGRCOMPLETED | Appraisal Completed | char | 1 | 0 | | | | Allow NULL? |
| 38 | CPATTEMP | Attempted Credits | decimal | 10 | 5 | | | | |
| 39 | CPEARNED | Earned Credits | decimal | 10 | 5 | | | | |
| 40 | CPGRADED | Graded Credits | decimal | 10 | 5 | | | | |
| 41 | CPUNIT | Unit of Measurement for Credits | nvarchar | 3 | 0 | | | | Allow NULL? |
| 42 | GRADESYM | Grade Symbol | nvarchar | 10 | 0 | | | | Allow NULL? |
| 43 | GRADE | Std Value for Scale Value | decimal | 8 | 2 | | | | |
| 44 | GRADESCALE | Academic Scale Identification (ID) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 45 | WEIGHTING | Weighting Determined from Hierarchy | decimal | 5 | 2 | | | | |
