S_NY_STU_X (ver 16.8.0)
This table is an extension of the [Students] table.
Column Name | Version | Data Type | Description |
---|---|---|---|
StudentsDCID | 16.1.0 | NUMBER(10,0) | Primary key that relates the extended table back to the [Students] table. |
Neglected | 16.1.0 | NUMBER(1,0) | Indicates if the student is considered neglected or not. Migrates from [Students]AtRisk. |
DiplomaType | 16.1.0 | VARCHAR2(3) | The type of graduation credential earned by the student. Migrates from [Students]Diploma_Kind. |
BackmappingBEDSCode | 16.1.0 | VARCHAR2(12) | The 12-digit BEDS code of the student's feeder code. Migrates from [Students]NY_Backmapping_BEDS_Code. |
CreditAttemptedMethod | 16.8.0 | VARCHAR2(8) | The GPA method to be used as an override for calculating cumulative potential credits earned by this student. Migrates from [Students]NY_Crd_Att_Method. |
CreditEarnedMethod | 16.8.0 | VARCHAR2(8) | The GPA method to be used as an override for calculating cumulative credits earned by this student. Migrates from [Students]NY_Crd_Ern_Method. |
DateOfEntryGrade9 | 16.1.0 | DATE | The date the student entered the 9th grade in a U.S. school. Migrates from [Students]NY_dateofentrygrade9. |
ExcludeFromAttendance | 16.1.0 | NUMBER(1,0) | If checked, the student is excluded from the AT-6 and SA-129 reports. Migrates from [Students]NY_ExcludeAttendance. |
GPAMethod | 16.8.0 | VARCHAR2(8) | The GPA method to be used as an override for this student. Migrates from [Students]NY_Gpa_Method. |
KindergartenCode | 16.1.0 | VARCHAR2(2) | The type of kindergarten program this student is enrolled in, if applicable. Migrates from [Students]NY_Kindergarten. |
PreviousStudentNumber | 16.1.0 | VARCHAR2(12) | The student's previous ID, if applicable. Migrates from [Students]NY_LocalStudentID. |
LocationCode | 16.1.0 | VARCHAR2(6) | The overridden local BOCES building code for this enrollment. Migrates from [Students]NY_LocationCode. |
MaxGPA | 16.1.0 | NUMBER(25,10) | The maximum possible GPA value to be used as an override for this student. Migrates from [Students]NY_Max_GPA. |
MinGPA | 16.1.0 | NUMBER(25,10) | The minimum possible GPA value to be used as an override for this student. Migrates from [Students]NY_Min_GPA. |
R4B_EnrollCode | 16.1.0 | VARCHAR2(4) | Override code indicating the reason for beginning the enrollment if none of the standard entry codes apply. Migrates from [Students]NY_R4B_EnrollCode. |
R4E_EnrollCode | 16.1.0 | VARCHAR2(4) | Override code indicating the reason for ending the enrollment if none of the standard exit codes apply. Migrates from [Students]NY_R4E_EnrollCode. |
SSE_GradeLevel | 16.1.0 | VARCHAR2(5) | Override school enrollment grade level for the enrollment if none of the standard grade levels apply. Migrates from [Students]NY_SSE_GradeLevel. |
PostGradDestination | 16.1.0 | VARCHAR2(2) | The student’s planned postgraduate activity. Migrates from [Students]Postgrad_Destin. |
State_ExcludeEnrollment | 16.1.0 | NUMBER(1,0) | Indicates if the specific school enrollment should be excluded from state reporting. Migrates from [Students]State_ExcludeEnrollment. |
Adult_Student_Indicator_TF | 16.12.0 | Boolean | Indicate if the student is adult student. |
StuDistCodeEn | 19.9.2 | VARCHAR2(8) | STUDENT DISTRICT CODE |