S_TX_TRM_C (ver 17.10.0)
This table is an extension of the Terms table, and holds information about Texas Store Code Mapping used for TREx, AAR, and PEIMS reporting.
Column Name | Version | Data Type | Description |
|---|---|---|---|
TermsDCID | 17.10.0 | Number(10,0) | A foreign key that relates the extended table to the [Terms] table. |
| AAR_GRADECOLUMN_MAPPING | 17.10.0 | Varchar2(2) | Identifies the AAR Transcript column to which the store code is mapped (S1, S2 or AVG). |
| FINAL_GRADE | 17.10.0 | Number(1,0) | Indicates whether the store code is considered a final grade. |
| MARKING_PERIOD | 17.10.0 | Number(1,0) | Indicates whether the store code is considered a marking period grade. |
| STORECODE | 17.10.0 | Varchar2(2) | The store code used for a marking period grade, final grade, or average grade. |