S_AL_STU_GiftedReferralTrk_X (ver 20.8.2.0)
This is an extension of the Students table and is used for reporting Special Programs data to the state ODS.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ApprovalDate | 20.8.2.0 | Date | Report Start Date |
| ATEligibleTest | 20.8.2.0 | Varchar2(3) | Aptitudes Eligible Test |
| ATScore_S1 | 20.8.2.0 | Number(11,0) | Aptitudes Test Score - S1 |
| ATScore_S2 | 20.8.2.0 | Number(11,0) | Aptitudes Test Score - S2 |
| ATScore_S3 | 20.8.2.0 | Number(11,0) | Aptitudes Test Score - S3 |
| ATScore_S4 | 20.8.2.0 | Number(11,0) | Aptitudes Test Score - S4 |
| ATScore_S5 | 20.8.2.0 | Number(11,0) | Aptitudes Test Score - S5 |
| ATScore_S6 | 20.8.2.0 | Number(11,0) | Aptitudes Test Score - S6 |
| ATScore_S7 | 20.8.2.0 | Number(11,0) | Aptitudes Test Score - S7 |
| ATScore_S8 | 20.8.2.0 | Number(11,0) | Aptitudes Test Score - S8 |
| ATScore_S9 | 20.8.2.0 | Number(11,0) | Aptitudes Test Score - S9 |
| ATScore_S10 | 20.8.2.0 | Number(11,0) | Aptitudes Test Score - S10 |
| ATTest | 20.8.2.0 | Varchar2(50) | Aptitudes Test |
| BirthDate | 20.8.2.0 | Date | Student Date of Birth |
| District | 20.8.2.0 | Varchar2(100) | District Name |
| DistrictID | 20.8.2.0 | Varchar2(15) | District number |
| Enddate | 20.8.2.0 | Date | SnapShot Approval Date |
| FirstName | 20.8.2.0 | Varchar2(30) | Student First Name |
| GAptitudeTest2 | 20.8.2.0 | Varchar2(50) | Aptitudes Test - 2 |
| GAptitudeTest2Score_S1 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 2 Score - S1 |
| GAptitudeTest2Score_S2 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 2 Score - S2 |
| GAptitudeTest2Score_S3 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 2 Score - S3 |
| GAptitudeTest2Score_S4 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 2 Score - S4 |
| GAptitudeTest2Score_S5 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 2 Score - S5 |
| GAptitudeTest2Score_S6 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 2 Score - S6 |
| GAptitudeTest2Score_S7 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 2 Score - S7 |
| GAptitudeTest2Score_S8 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 2 Score - S8 |
| GAptitudeTest2Score_S9 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 2 Score - S9 |
| GAptitudeTest2Score_S10 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 2 Score - S10 |
| GAptitudeTest3 | 20.8.2.0 | Varchar2(50) | Aptitudes Test - 3 |
| GAptitudeTest3Score_S1 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 3 Score - S1 |
| GAptitudeTest3Score_S2 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 3 Score - S2 |
| GAptitudeTest3Score_S3 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 3 Score - S3 |
| GAptitudeTest3Score_S4 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 3 Score - S4 |
| GAptitudeTest3Score_S5 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 3 Score - S5 |
| GAptitudeTest3Score_S6 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 3 Score - S6 |
| GAptitudeTest3Score_S7 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 3 Score - S7 |
| GAptitudeTest3Score_S8 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 3 Score - S8 |
| GAptitudeTest3Score_S9 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 3 Score - S9 |
| GAptitudeTest3Score_S10 | 20.8.2.0 | Number(11,0) | Aptitudes Test - 3 Score - S10 |
| GCharInstrument | 20.8.2.0 | Varchar2(50) | Characteristics RS |
| GCharPoints | 20.8.2.0 | Number(11,0) | Characteristics PE |
| GCharSubscale | 20.8.2.0 | Varchar2(50) | Characteristics A |
| GEligDate | 20.8.2.0 | Date | Gifted Eligibility Date |
| GEligibility | 20.8.2.0 | Varchar2(3) | Gifted Eligible |
| Gender | 20.8.2.0 | Varchar2(10) | Gender |
| GiftedAptitudeTest2Eligible | 20.12.1.0 | Varchar2(3) | Aptitudes Eligible Test - 2 |
| GiftedAptitudeTest3Eligible | 20.12.1.0 | Varchar2(3) | Aptitudes Eligible Test - 3 |
| GiftedIndicator1 | 20.8.2.0 | Varchar2(50) | Performance P1 |
| GiftedIndicator2 | 20.8.2.0 | Varchar2(50) | Performance P2 |
| GiftedIndicator3 | 20.8.2.0 | Varchar2(50) | Performance P3 |
| GiftedIndicatorPoints1 | 20.8.2.0 | Number(11,0) | Performance S1 |
| GiftedIndicatorPoints2 | 20.8.2.0 | Number(11,0) | Performance S2 |
| GiftedIndicatorPoints3 | 20.8.2.0 | Number(11,0) | Performance S3 |
| GNumDays | 20.8.2.0 | Number(11,0) | Number of days fr Ref. to Elig. |
| GPassScreen | 20.8.2.0 | Varchar2(3) | Passed Screening? |
| Grade | 20.8.2.0 | Varchar2(20) | Grade |
| GRefDate | 20.8.2.0 | Date | Date of Referral |
| GRefSource | 20.8.2.0 | Varchar2(50) | Source of Referral |
| GTimeDelays | 20.8.2.0 | Varchar2(50) | Timeline Delays |
| GTrackCom | 20.8.2.0 | Varchar2(25) | Tracking Log Comments |
| LastName | 20.8.2.0 | Varchar2(30) | Student Last Name |
| MiddleInt | 20.8.2.0 | Varchar2(1) | Student Middle Name |
| Race_A | 20.8.2.0 | Varchar2(3) | Race - Asian |
| Race_B | 20.8.2.0 | Varchar2(3) | Race - Black or African American |
| Race_H | 20.8.2.0 | Varchar2(3) | Race - Hispanic or Latino |
| Race_I | 20.8.2.0 | Varchar2(3) | Race - American Indian or Alaskan Native |
| Race_M | 20.8.2.0 | Varchar2(3) | Race - Two or More Races |
| Race_P | 20.8.2.0 | Varchar2(3) | Race - Native Hawaiian or Pacific Islander |
| Race_W | 20.8.2.0 | Varchar2(3) | Race - White |
| School | 20.8.2.0 | Varchar2(100) | School Name |
| SchoolID | 20.8.2.0 | Varchar2(15) | School Code |
| StartDate | 20.8.2.0 | Date | Report End Date |
| StateID | 20.8.2.0 | Varchar2(30) | State ID |