S_MN_TESTINGDSR_S (ver 17.9.2)
This table is a standalone table and stores student-level testing results.
Column Name | Version | Data Type | Description |
---|---|---|---|
ID | 17.9.2 | Number (11,0) | Primary Key. |
Unique_ID | 17.9.2 | Number (11,0) | Primary key from the Virtual Table. |
Accommodation12 | 17.9.2 | Varchar2(1) | Indicates if the student used 12-point regular print paper test booklet with the document or test opportunity. |
Accommodation18 | 17.9.2 | Varchar2(1) | Indicates if the student used large print test book with the document or test opportunity. |
Accommodation24 | 17.9.2 | Varchar2(1) | Indicates if the student used large print test book with the document or test opportunity. |
AccommodationAT | 17.9.2 | Varchar2(1) | Indicates if the student used assistive technology with the document or test opportunity. |
AccommodationBR | 17.9.2 | Varchar2(1) | Indicates if the student used Braille version with the document or test opportunity. |
AccommodationCA | 17.9.2 | Varchar2(1) | Indicates if the student used this accommodation with the document or test opportunity. No longer being used. |
AccommodationHM | 17.9.2 | Varchar2(1) | Indicates if the student used this accommodation with the document or test opportunity. No longer being used. |
AccommodationMC | 17.9.2 | Varchar2(1) | Indicates if the student used text-to-speech with the document or test opportunity. |
AccommodationMS | 17.9.2 | Varchar2(1) | Indicates if the student used scripts with the document or test opportunity. |
AccommodationMT | 17.9.2 | Varchar2(1) | Indicates if the student had a recording of a reading test with this test opportunity. |
AccommodationOA | 17.9.2 | Varchar2(1) | Indicates if the student used extended time or signed interpretation with the document or test opportunity. |
AccommodationOL | 17.9.2 | Varchar2(1) | Indicates if the student used this accommodation with the document or test opportunity. No longer being used. |
AccommodationSC | 17.9.2 | Varchar2(1) | Indicates if the student used scribe with the document or test opportunity. |
AccommodationSO | 17.9.2 | Varchar2(1) | Indicates if the student used this accommodation with the document or test opportunity. No longer being used. |
AccommodationSP | 17.9.2 | Varchar2(1) | Indicates if the student used this accommodation with the document or test opportunity. No longer being used. |
AccommodationSS | 17.9.2 | Varchar2(1) | Indicates if the student used special settings with the document or test opportunity. |
AccommodationTD | 17.9.2 | Varchar2(1) | Indicates if the student used signed interpretation of directions with the document or test opportunity. |
AccommodationVT | 17.9.2 | Varchar2(1) | Indicates if the student used this accommodation with the document or test opportunity. No longer being used. |
AchievementLevel | 17.9.2 | Varchar2(10) | The student's achievement level or pass status. |
ADM97 | 17.9.2 | Varchar2(10) | The student's Average Daily Membership (ADM) since 1997 (Approximate years in MN). |
AdultBasicEducationIndicator | 17.9.2 | Varchar2(10) | The student's adult basic education indicator. No longer being used. |
BaseItemHandScoreCount | 17.9.2 | Varchar2(20) | No longer being used.(FY18) |
BaseItemHandScorePoints | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
BaseItemMachineScoreCount | 17.9.2 | Varchar2(20) | No longer being used.(FY18) |
BaseItemMachineScorePoints | 17.9.2 | Varchar2(20) | No longer being used.(FY18) |
DateOfBirth | 17.9.2 | Varchar2(8) | The student's date of birth (YYYYMMDD). |
DocumentCharacteristic1 | 17.9.2 | Varchar2(10) | Document Code 1 (Example codes: SIG- Significant Gap; NTC- New To Country, FE- Foreign Exchange; HS- Home School Student; GRID-Identifiers manually gridded on paper docs). |
DocumentCharacteristic2 | 17.9.2 | Varchar2(10) | Document Code 2 (Example codes: SIG- Significant Gap; NTC- New To Country, FE- Foreign Exchange; HS- Home School Student; GRID-Identifiers manually gridded on paper docs). |
DocumentCharacteristic3 | 17.9.2 | Varchar2(10) | Document Code 3(Example codes: SIG- Significant Gap; NTC- New To Country, FE- Foreign Exchange; HS- Home School Student; GRID-Identifiers manually gridded on paper docs). |
DocumentCharacteristic4 | 17.9.2 | Varchar2(10) | Document Code 4(Example codes: SIG- Significant Gap; NTC- New To Country, FE- Foreign Exchange; HS- Home School Student; GRID-Identifiers manually gridded on paper docs). |
DocumentCharacteristic5 | 17.9.2 | Varchar2(10) | Document Code 5 (Example codes: SIG- Significant Gap; NTC- New To Country, FE- Foreign Exchange; HS- Home School Student; GRID-Identifiers manually gridded on paper docs). |
EthnicCode | 17.9.2 | Varchar2(10) | The student's race/ethnic reporting group. |
ForeignExchangeStudent | 17.9.2 | Varchar2(1) | The student's foreign exchange designation. No longer being used. |
FormNumber | 17.9.2 | Varchar2(10) | The form number (or tier for ACCESS). |
FRPFlag | 17.9.2 | Varchar2(1) | The student's Free/Reduced Priced Meal eligible designation. |
Gender | 17.9.2 | Varchar2(1) | The student's gender. |
Grade | 17.9.2 | Number(25,10) | The grade level of the test. |
HomelessFlag | 17.9.2 | Varchar2(1) | The student's homeless designation. |
HomeSchoolIndicator | 17.9.2 | Varchar2(10) | The student's home schooled designation. No longer being used. |
LanguageCode | 17.9.2 | Varchar2(10) | The primary language code spoken by student at home. |
LearningLocator | 17.9.2 | Varchar2(30) | Learning Locator (MCA only) |
LEPFlag | 17.9.2 | Varchar2(1) | The student's English Learner (EL) designation. |
LexileScore | 17.9.2 | Varchar2(20) | Reading Lexile Score (Reading MCA only) |
LexileScoreRange | 17.9.2 | Varchar2(20) | Reading Lexile Score Range (Reading MCA only) |
LocalStudentID | 17.9.2 | Number(11,0) | The district's local student ID. |
MARSSStateReportingNumber | 17.9.2 | Varchar2(20) | The MARSS State Student ID. |
MIGFlag | 17.9.2 | Varchar2(1) | The student's migrant designation. |
MTASOperationalPassage1 | 17.9.2 | Varchar2(10) | MTAS Passage Access indicator (1=read to; 2=read along, 3=read alone |
MTASOperationalPassage2 | 17.9.2 | Varchar2(10) | MTAS Passage Access indicator (1=read to; 2=read along, 3=read alone) |
MTASOperationalPassage3 | 17.9.2 | Varchar2(10) | MTAS Passage Access indicator (1=read to; 2=read along, 3=read alone) |
MTASPassageAccessAll | 17.9.2 | Varchar2(20) | MTAS Passage Access indicators (operational and non-operational) |
NewToCountryFlag | 17.9.2 | Varchar2(1) | Indicates if the student is new to the country. No longer being used. |
OCT1DistrictFlag | 17.9.2 | Varchar2(1) | Indicator if student was enrolled in same district on Oct 1. |
OCT1SchoolFlag | 17.9.2 | Varchar2(1) | Indicator if student was enrolled in same school on Oct 1. |
Prior2YearLEPFlag | 17.9.2 | Varchar2(1) | The student's English Learner designation within prior two years. |
Prior2YearSPEFlag | 17.9.2 | Varchar2(1) | The student's Special Education designation within prior two years . |
PriorYear | 17.9.2 | Varchar2(10) | No longer being used .(FY18) |
PriorYearScore | 17.9.2 | Varchar2(25) | The student’s prior year score for this subject . |
PriorYearTest | 17.9.2 | Varchar2(25) | The student’s prior year test code for this subject. |
PriorYearTestedGrade | 17.9.2 | Varchar2(1) | No longer being used. (FY18) |
Reserved | 17.9.2 | Varchar2(10) | No longer being used. (FY18) |
SchoolID | 17.9.2 | Number (11,0) | The state assigned school number associated with the student test result. |
Score1 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score1Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank. For Reading and Math MCA 'Score1Characteristic’ may include a growth level. |
Score1Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing - see Score Label Definition tab in DSR/SSR |
Score1Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score1Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score1Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score2 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score2Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank. For Reading and Math MCA 'Score1Characteristic’ may include a growth level. |
Score2Label | 17.9.2 | Varchar2(20) | State Percentile, Raw Score, or Performance within Subject |
Score2Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score2Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score2Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score3 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score3Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank. For Reading and Math MCA 'Score1Characteristic’ may include a growth level. |
Score3Label | 17.9.2 | Varchar2(20) | Raw Score, Strand/ Substrands, Performance within Subject |
Score3Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score3Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score3Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score4 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score4Characteristic | 17.9.2 | Varchar2(20) | For all MCA subjectsmay include Strand Performance Level Descriptors of Below (B), At or Near (N), or Above (A) |
Score4Label | 17.9.2 | Varchar2(20) | Strand/Substrands or Performance within Subject |
Score4Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score4Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score4Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score5 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score5Characteristic | 17.9.2 | Varchar2(20) | For all MCA subjectsmay include Strand Performance Level Descriptors of Below (B), At or Near (N), or Above (A) |
Score5Label | 17.9.2 | Varchar2(20) | Strand/ Substrands or Performance within Subject |
Score5Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score5Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score5Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score6 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score6Characteristic | 17.9.2 | Varchar2(20) | For all MCA subjectsmay include Strand Performance Level Descriptors of Below (B), At or Near (N), or Above (A) |
Score6Label | 17.9.2 | Varchar2(20) | Reading MCA VSS label, Strand/ Substrands or Performance within Subject |
Score6Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score6Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score6Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score7 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score7Characteristic | 17.9.2 | Varchar2(20) | For all MCA subjectsmay include Strand Performance Level Descriptors of Below (B), At or Near (N), or Above (A) |
Score7Label | 17.9.2 | Varchar2(20) | Strand/ Substrands or Performance within Subject |
Score7Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score7Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score7Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score8 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score8Characteristic | 17.9.2 | Varchar2(20) | For all MCA subjects may include Strand Performance Level Descriptors of Below (B), At or Near (N), or Above (A) |
Score8Label | 17.9.2 | Varchar2(20) | Grades 3-8 Math MCA VSS label |
Score8Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score8Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score8Sign | 17.9.2 | Varchar2(20) | No longer being used. |
Score9 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score9Characteristic | 17.9.2 | Varchar2(20) | For all MCA subjects may include Strand Performance Level Descriptors of Below (B), At or Near (N), or Above (A). |
Score9Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score9Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score9Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score9Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score10 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score10Characteristic | 17.9.2 | Varchar2(20) | For all MCA subjects may include Strand Performance Level Descriptors of Below (B), At or Near (N), or Above (A). |
Score10Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score10Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score10Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score10Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score11 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score11Characteristic | 17.9.2 | Varchar2(20) | For all MCA subjects may include Strand Performance Level Descriptors of Below (B), At or Near (N), or Above (A). |
Score11Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score11Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score11Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score11Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score12 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score12Characteristic | 17.9.2 | Varchar2(20) | For all MCA subjects may include Strand Performance Level Descriptors of Below (B), At or Near (N), or Above (A). |
Score12Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score12Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score12Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score12Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score13 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score13Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank |
Score13Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score13Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score13Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score13Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score14 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score14Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank. |
Score14Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score14Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score14Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score14Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score15 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score15Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank |
Score15Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score15Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score15Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score15Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score16 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score16Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank |
Score16Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score16Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score16Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score16Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score17 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score17Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank |
Score17Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score17Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score17Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score17Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score18 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score18Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank |
Score18Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score18Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score18Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score18Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score19 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score19Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank |
Score19Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score19Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score19Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score19Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score20 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score20Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank |
Score20Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score20Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score20Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score20Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score21 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score21Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank |
Score21Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score21Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score21Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score21Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score22 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score22Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank |
Score22Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score22Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score22Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score22Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score23 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score23Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank |
Score23Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score23Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score23Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score23Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score24 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score24Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank |
Score24Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score24Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score24Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score24Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
Score25 | 17.9.2 | Varchar2(20) | The score associated with the score label. |
Score25Characteristic | 17.9.2 | Varchar2(20) | A score may have an associated characteristic or this field may be blank |
Score25Label | 17.9.2 | Varchar2(20) | Each score has a label describing what the score is referencing. |
Score25Maximum | 17.9.2 | Varchar2(20) | The maximum score associated with the score label. |
Score25Minimum | 17.9.2 | Varchar2(20) | The minimum score associated with the score label. |
Score25Sign | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
SecondaryDistrictNumber | 17.9.2 | Varchar2(10) | No longer being used. (FY18) |
SecondaryDistrictType | 17.9.2 | Varchar2(10) | No longer being used. (FY18) |
SecondarySchoolNumber | 17.9.2 | Varchar2(10) | No longer being used. (FY18) |
SignificantGap | 17.9.2 | Varchar2(1) | The student's significant gap designation. No longer being used. |
SLifeFlag | 17.9.2 | Varchar2(1) | Indicates a student with Limited or Interrupted Formal Education. |
SPECode | 17.9.2 | Varchar2(10) | The student's primary disability code or 504 accommodation code. |
SPEFlag | 17.9.2 | Varchar2(1) | The student's special education designation. |
StatusGroup | 17.9.2 | Varchar2(20) | No longer being used. (FY18) |
StudentFirstName | 17.9.2 | Varchar2(50) | The student's first name. |
StudentLastName | 17.9.2 | Varchar2(50) | The student's last name. |
StudentMiddleName | 17.9.2 | Varchar2(30) | The student's middle name. |
TestCode | 17.9.2 | Varchar2(10) | Test code indicating Valid Score or why the test couldn't be scored. |
TestDate | 17.9.2 | Number(11,0) | The beginning of the the testing window for this assessment (YYYYMMDD) |
TestForm | 17.9.2 | Varchar2(10) | The test form (or cluster for ACCESS). |
TestName | 17.9.2 | Varchar2(20) | The name of the assessment. |
TestSubject | 17.9.2 | Varchar2(10) | The subject of the assessment. |
TestingDistrictNumber | 17.9.2 | Varchar2(10) | The district number from where the test was generated. |
TestingDistrictType | 17.9.2 | Varchar2(10) | The district type from where the test was generated. |
TestingSchoolNumber | 17.9.2 | Varchar2(10) | The school number from where the test was generated. |
UIN | 17.9.2 | Varchar2(20) | Universal Identification Number (Unique record number for this test and subject). |
UnkFlag | 17.9.2 | Varchar2(1) | No longer being used. (FY18) |
ForeignKey | 17.9.2 | Number (11,0) | Default field. No longer used. |
ForeignKey_Alpha | 17.9.2 | Varchar2 (31) | Default field. No longer used. |