S_IA_STU_SIF_X (ver 17.2.0)
This table is an extension of the Students table, and holds Iowa-specific fields used for reporting via SIF.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.7.2 | Number(10,0) | System generated primary key. |
| SIF_Adjusted_GPA | 17.2.0 | Double | The student's adjusted GPA. Migrated from [Students]IA_SIFRAIAdjustedGPA. |
| SIF_Class_Rank | 17.2.0 | Number(11,0) | The student's rank in class. Migrated from [Students]IA_SIFNonWeightedClassRank. |
| SIF_Cumulative_Summary | 17.2.0 | Varchar2(30) | The student's cumulative summary. Migrated from [Students]IA_SIFCumulativeSummary. |
| SIF_Cumulative_GPA | 17.2.0 | Double | The student's cumulative GPA. Migrated from [Students]IA_SIFCumWeightedGPA. |
| SIF_Days_Enrolled | 17.2.0 | Double | The number of days the student was enrolled. Migrated from [Students]IA_SIFDaysEnrolled. |
| SIF_Days_Present | 17.2.0 | Double | The number of days the student was present. Migrated from [Students]IA_SIFDaysPresent. |
| SIF_Excessive_GPA | 17.2.0 | Number(1,0) | Indicates excessive GPA. Migrated from [Students]SIF_Excessive_GPA. |
| SIF_Non_Weighted_GPA | 17.2.0 | Double | The student's non-weighted GPA. Migrated from [Students]IA_SIFNonWeightedGPA |
| SIF_Total_Number_Class | 17.2.0 | Number(11,0) | The total number of students in the class for Class Rank. Migrated from [Students]IA_SIFTotalNumberClass. |
| SIF_Weighted_Class_Rank | 17.2.0 | Double | The student's weighted class rank. Migrated from [Students]IA_SIFWeightedClassRank. |
| State_Not_Complete_Reason | 17.2.0 | Varchar2(30) | The state not complete reason. Migrated from [Students]IA_State_NotCompleteReason. |