PSM_ReportCardItem (ver1.5)
This table contains information pertaining to any line items on a report card not related to assignments.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ColorCode | 1.5 | Number(10,0) | Currently not used. |
Description | 1.5 | Varchar2(4000) | Simple description of what is being measured i.e. Citizenship Grade, Student's ability to interact well with others, etc. |
ExportPercentGrade | 1.5 | Number(3,0) | 1 indicates grades attached to this report card item will export the percent to SyncStudentGrade instead of the letter grade. |
GradeScaleID | 1.5 | Number(19,0) | Internal number for the associated PSM_GradeScale record. |
ID | 1.5 | Number(19,0) | Unique sequential number generated by the application. Required. |
IncludeNarrativeComment | 1.5 | Number(5,0) | 1 indicates a narrative comment is collected for the report card item. |
IncludeStandardComment | 1.5 | Number(5,0) | 1 indicates a standard comment is collected for the report card item. |
IsOptional | 1.5 | Number(5,0) | Currently not used. |
ItemLevel | 1.5 | Number(5,0) | The hierarchy level for this report card item, values start with 1. |
ItemType | 1.5 | Number(5,0) | 1 indicates the report card item is associated to the final grade stored in the PSM_FinalScore table. Values 2-6 not currently used. 9 indicates neither a letter or numeric grade type was used. |
MaxNarrativeLength | 1.5 | Number(10,0) | The maximum length of the narrative comment for report card items that include narrative comment. |
MaxStandardComments | 1.5 | Number10,0) | The maximum number of standard comments collected for report card items that include standard comments. |
Name | 1.5 | Varchar2(256) | Required. |
ParentReportCardItemID | 1.5 | Number(19,0) | Internal number for the associated PSM_ReportCardItem record. |
PointPossible | 1.5 | Number(10,0) | Currently not used. |
PrepopulationValue | 1.5 | Varchar2(20) | Currently not used. |
PreviousStandardID | 2.8.0.13 | Number(19,0) | Internal number for the associated PSM_StandardID record of a report card item in which the course was removed from the standard. |
ReportingTermID | 1.5 | Number(19,0) | Internal number for the associated PSM_ReportingTerm record. Required. |
ScoreType | 1.5 | Varchar2(20) | Valid types: Comment, Percent or GradeScale |
SectionID | 1.5 | Number(19,0) | Internal number for the associated PSM_Section record. |
SortOrder | 1.5 | Number(10,0) | Indicates order to display the report card item within a hierarchy level defined in ItemLevel. |
StandardID | 1.5.1 | Number(19,0) | Internal number for the associated PSM_StandardID record. Nulled when removing the course from the standard. |