Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StudentAssessmentResultsSeq | int | 4 | null |
|
|
|||
| SubjectClassesSeq | int | 4 | null |
|
|
|||
| FileType | varchar | 5 | null |
|
|
|||
| FileYear | smallint | 2 | null |
|
|
|||
| FileSemester | smallint | 2 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| ClassCampus | varchar | 3 | null |
|
|
|||
| ClassCode | varchar | 15 | null |
|
|
|||
| AreaSeq | smallint | 2 | null |
|
|
|||
| Result | varchar | 30 | null |
|
|
|||
| ResultNumeric | decimal | 22,10 | √ | null |
|
|
||
| ResultPercent | decimal | 22,10 | √ | null |
|
|
||
| ResultNumericRaw | decimal | 22,10 | √ | null |
|
|
||
| ResultNumericRawNULLIfBlank | decimal | 22,10 | √ | null |
|
|
||
| ResultNumericRawNULLIfBlankOrNonAssessable | decimal | 22,10 | √ | null |
|
|
||
| ResultNumericFlag | int | 4 | √ | null |
|
|
||
| GradeToMarkFlag | bit | 1 | √ | null |
|
|
||
| ResultSort | varchar | 30 | √ | null |
|
|
||
| OverrideFlag | bit | 1 | null |
|
|
|||
| TopicComment | nvarchar | 1073741823 | √ | null |
|
|
||
| PrintFlag | bit | 1 | null |
|
|
|||
| AssessableFlag | bit | 1 | null |
|
|
|||
| StartDate | datetime | 16,3 | √ | null |
|
|
||
| StopDate | datetime | 16,3 | √ | null |
|
|
||
| ResultClassification | varchar | 15 | null |
|
|
|||
| SubjectAssessmentsSeq | int | 4 | √ | null |
|
|
||
| AssessmentCode | varchar | 15 | null |
|
|
|||
| AreaUnderlayFollowingAreaFlag | bit | 1 | null |
|
|
|||
| AreaOverallFlag | bit | 1 | null |
|
|
|||
| AreaOverallSeq | smallint | 2 | null |
|
|
|||
| AreaResultEntryFlag | bit | 1 | null |
|
|
|||
| AreaResultPrintFlag | bit | 1 | null |
|
|
|||
| AreaCalculatedFieldFlag | bit | 1 | null |
|
|
|||
| AreaMarkOutOf | int | 4 | null |
|
|
|||
| AreaMarkOutOfNonZero | int | 4 | null |
|
|
|||
| AreaResultType | varchar | 15 | null |
|
|
|||
| AreaSummariseToSeq | smallint | 2 | √ | null |
|
|
||
| AreaAreaBlockEndFlag | bit | 1 | null |
|
|
|||
| AreaAutoPickFlag | bit | 1 | null |
|
|
|||
| AreaHdgAbbrev1 | varchar | 10 | null |
|
|
|||
| AreaHdgAbbrev2 | varchar | 10 | null |
|
|
|||
| AreaHeading | varchar | 255 | null |
|
|
|||
| AreaOverview | varchar | 2147483647 | √ | null |
|
|
||
| AreaSubjectAssessmentAreaGUID | int | 4 | null |
|
|
|||
| AreaResultGroup | varchar | 15 | null |
|
|
|||
| AreaWeightingFactor | numeric | 10,4 | null |
|
|
|||
| AreaExternalLinkSeq | int | 4 | null |
|
|
|||
| AreaDefaultResultClassification | varchar | 15 | null |
|
|
|||
| AssessmentHeading | varchar | 255 | null |
|
|
|||
| AssessmentUnitName | varchar | 255 | null |
|
|
|||
| AssessmentOverview | varchar | 2147483647 | √ | null |
|
|
||
| AssessmentReportStyle | varchar | 50 | null |
|
|
|||
| AssessmentInterimReportStyle | varchar | 30 | null |
|
|
|||
| AssessmentCommentsUsedFlag | bit | 1 | null |
|
|
|||
| AssessmentOverrideReportSortSeq | int | 4 | null |
|
|
|||
| AssessmentOverrideCommentLines | smallint | 2 | null |
|
|
|||
| AssessmentTopicCommentsUsedFlag | bit | 1 | null |
|
|
|||
| AssessmentProgressiveFlag | bit | 1 | null |
|
|
|||
| AssessmentPrintSelectableFlag | bit | 1 | null |
|
|
|||
| AssessmentOverrideCommentWords | smallint | 2 | null |
|
|
|||
| AssessmentShowResultClassificationFlag | bit | 1 | null |
|
|
|||
| AssessmentResultCalculationStoredProcName | varchar | 50 | null |
|
|
|||
| ResultGroupLockedFlag | bit | 1 | null |
|
|
|||
| ResultDate | datetime | 16,3 | √ | null |
|
|
||
| AreaResultTypeSynergyMeaning | varchar | 30 | √ | null |
|
|
||
| AreaResultTypeNumericFlag | bit | 1 | √ | null |
|
|
||
| ActualSemester | smallint | 2 | √ | null |
|
|
||
| PercentGreaterEqualThan | decimal | 9,2 | √ | null |
|
|
||
| PercentLessThan | decimal | 9,2 | √ | null |
|
|
||
| PercentUseForCalc | decimal | 9,2 | √ | null |
|
|
||
| ShortCourseFlag | bit | 1 | null |
|
|
|||
| CommPortalPublishFlag | bit | 1 | null |
|
|
|||
| LearningAreaReportSortSeq | int | 4 | √ | null |
|
|
||
| ClassDescription | varchar | 100 | null |
|
|
|||
| AssessmentResultDatesUsedFlag | bit | 1 | null |
|
|
|||
| ResultCalculationDecimalPlaces | tinyint | 1 | √ | null |
|
|
||
| ResultCalculationDecimalPlacesFixedFlag | bit | 1 | null |
|
|
|||
| ResultCalculationDecimalPlacesTruncateFlag | bit | 1 | null |
|
|
Table contained 0 rows