S_MT_STU_Academics_X (ver 15.7.0)
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
---|---|---|---|
StudentsDCID | 15.7.0 | Number (10,0) | Primary key that relates the extended table to the Studentss table. |
AggregateHoursInstruct | 15.7.0 | Varchar2 (1) | The hours of pupil instruction for which a school course or program is offered or for which a pupil is enrolled. Migrates from [Students]MT_AggregateHours |
AreaOfConcentration | 15.7.0 | Varchar2 (2) | The CTE (Career Technical Education) program area in which the majority of the CTE credits were earned. Migrates from [Students]MT_AreaOfConcentration |
CTEInd | 15.7.0 | Number (1,0) | Indicates the student is a 12th grade student who has earned 3 or more credits in a CTE area of concentration. Migrates from [Students]MT_CTE |
CTEFollowUpDateContacted | 15.7.0 | Date | The date a prior year CTE student was contacted to determine their post graduation status. Migrates from [Students]MT_DateContacted |
PostGradStatus | 15.7.0 | Varchar2 (2) | The primary placement status of a CTE Concentrator in the fourth quarter of the year of graduation. Migrates from [Students]MT_PostGraduationStatus |
DiplomaPeriod | 15.7.0 | Varchar2 (2) | The time a student took to graduate from the first date they entered 9th grade to the date of graduation. Migrates from [Students]MT_DiplomaPeriod |
DiplomaType | 15.7.0 | Varchar2 (2) | The type of diploma a student is awarded by a district. Migrates from [Students]MT_DiplomaType |
DropOut | 15.7.0 | Varchar2 (2) | Code showing the reason the student dropped out of school. Migrates from [Students]MT_DropOut |
HalfDayKG | 15.7.0 | Number (1,0) | Indicates the student is enrolled in a half day kindergarten program. Migrates from [Students]MT_Half_Day_KG |
NoShow | 15.7.0 | Number (1,0) | Indicates the student was expected to attend the school but did not show up to attend. Migrates from [Students]MT_NoShow |
Pathway_Indicator | 22.5.3 | Varchar2 (4) | CTE Pathway Indicator |
Pathway_Credits_District | 22.5.3 | NUMBER(25,10) | Pathway Credits earned in District limited to 4 digits (or 2 digits and 1 decimal place) |
Pathway_Credits_NonDistrict | 22.5.3 | NUMBER(25,10) | Pathway Credits earned outside of the District limited to 4 digits (or 2 digits and 1 decimal place) |