S_IL_Letter_Grade_Mapping_S (ver 17.5.0)
This is a stand alone table for migration from IL_Letter_Grade_Mapping virtual table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 17.5.0 | Number(11,0) | Primary Key |
| SchoolID | 17.5.0 | Number(11,0) | ID of the school associated with this Store code list. Migrated from [IL_Letter_Grade_Mapping .SchoolID]. |
| Code01 | 17.5.0 | Varchar2(4000) | Code01 (A+). Migrated from [IL_Letter_Grade_Mapping .Code01]. |
| Code02 | 17.5.0 | Number(25,10) | Code02 (A).Migrated from [IL_Letter_Grade_Mapping .Code02]. |
| Code03 | 17.5.0 | Number(11,0) | Code03 (A-). Migrated from [IL_Letter_Grade_Mapping .Code03]. |
| Code04 | 17.5.0 | Varchar2(50) | Code04 (B+). Migrated from [IL_Letter_Grade_Mapping .Code04]. |
| Code05 | 17.5.0 | Varchar2(50) | Code05 (B). Migrated from [IL_Letter_Grade_Mapping .Code05]. |
| Code06 | 17.5.0 | Varchar2(50) | Code06 (B-). Migrated from [IL_Letter_Grade_Mapping .Code06]. |
| Code07 | 17.5.0 | Varchar2(50) | Code07 (C+). Migrated from [IL_Letter_Grade_Mapping .Code07]. |
| Code08 | 17.5.0 | Varchar2(50) | Code08 (C ). Migrated from [IL_Letter_Grade_Mapping .Code08]. |
| Code09 | 17.5.0 | Varchar2(50) | Code09 (C-). Migrated from [IL_Letter_Grade_Mapping .Code09]. |
| Code10 | 17.5.0 | Varchar2(50) | Code10 (D+). Migrated from [IL_Letter_Grade_Mapping .Code10]. |
| Code11 | 17.5.0 | Varchar2(50) | Code11 (D). Migrated from [IL_Letter_Grade_Mapping .Code11]. |
| Code12 | 17.5.0 | Varchar2(50) | Code12 (D-). Migrated from [IL_Letter_Grade_Mapping .Code12]. |
| Code13 | 17.5.0 | Varchar2(50) | Code13 (F). Migrated from [IL_Letter_Grade_Mapping .Code13]. |
| Code14 | 17.5.0 | Varchar2(50) | Code14 (S). Migrated from [IL_Letter_Grade_Mapping .Code14]. |
| Code15 | 17.5.0 | Varchar2(50) | Code15 (U). Migrated from [IL_Letter_Grade_Mapping .Code15]. |
| Code16 | 17.5.0 | Varchar2(50) | Code16 (I). Migrated from [IL_Letter_Grade_Mapping .Code16]. |
| Code17 | 17.5.0 | Varchar2(50) | Code17 (W). Migrated from [IL_Letter_Grade_Mapping .Code17]. |
| Code18 | 17.5.0 | Varchar2(50) | Code18 (WP). Migrated from [IL_Letter_Grade_Mapping .Code18]. |
| Code19 | 17.5.0 | Varchar2(50) | Code19 (Audit). Migrated from [IL_Letter_Grade_Mapping .Code19]. |
| Code20 | 17.5.0 | Varchar2(50) | Code20 (X). Migrated from [IL_Letter_Grade_Mapping .Code20]. |
| Code21 | 17.5.0 | Varchar2(50) | Code21 (Above Average) [K-8 Only]. Migrated from [IL_Letter_Grade_Mapping .Code21]. |
| Code22 | 17.5.0 | Varchar2(50) | Code22 (Average) [K-8 Only]. Migrated from [IL_Letter_Grade_Mapping .Code22]. |
| Code23 | 17.5.0 | Varchar2(50) | Code23 (Below Average) [K-8 Only]. Migrated from [IL_Letter_Grade_Mapping .Code23]. |
| Code24 | 17.5.0 | Varchar2(50) | Code24 (P - promoted) [K-8 Only]. Migrated from [IL_Letter_Grade_Mapping .Code24]. |
| Code25 | 17.5.0 | Varchar2(50) | Code25 (R - retained) [K-8 Only]. Migrated from [IL_Letter_Grade_Mapping .Code25]. |
| Code26 | 17.5.0 | Varchar2(50) | Code26 (N - not complete) [K-8 Only]. Migrated from [IL_Letter_Grade_Mapping .Code26]. |
| Code27 | 17.5.0 | Varchar2(50) | Code27 (Exceptional). Migrated from [IL_Letter_Grade_Mapping .Code27]. |
| Code28 | 17.5.0 | Varchar2(50) | Code28 (Meets Standard). Migrated from [IL_Letter_Grade_Mapping .Code28]. |
| Code29 | 17.5.0 | Varchar2(50) | Code29 (Approaching Standard). Migrated from [IL_Letter_Grade_Mapping .Code29]. |
| Code30 | 17.5.0 | Varchar2(50) | Code30 (Below Standard). Migrated from [IL_Letter_Grade_Mapping .Code30]. |
| Code31 | 17.9.0 | Varchar2(50) | Code31 (Below Standard). Migrated from [IL_Letter_Grade_Mapping .Code31]. |
| Code99 | 17.5.0 | Varchar2(50) | Code99 (Erroneous) (A+). Migrated from [IL_Letter_Grade_Mapping .Code99]. |
| GradeScaleName | 17.5.0 | Varchar2(50) | Internal Use. Migrated from [IL_Letter_Grade_Mapping .gsid]. |
| foreignkey | 17.5.0 | Number(11,0) | No longer used. |
| foreignKey_alpha | 17.5.0 | Number(11,0) | No longer used. |