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. |