S_NM_STU_X (ver 14.8.2)
This is an extension of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.8.2 | Number(10,0) | Primary Key |
BUSA | 14.8.2 | Varchar2(1) | Eligibility for BUSA |
Bus_Number | 14.8.2 | Varchar2(20) | Bus number |
LastStatusUpdate | 14.9.0 | Date | LastStatus update date |
EconomicDisAdvCode | 14.9.0 | Number(10,0) | Economic Disadvantaged Status Code for lunch |
AtRiskStudent | 14.9.0 | Varchar2(1) | Y/N option to identify AtRiskStudent |
MilitaryFamily | 14.9.0 | Varchar2(2) | Military Family Code Indicator |
Bus_number2 | 14.9.3 | Varchar2(20) | Second bus number for student |
VocBus_Number | 14.9.3 | Varchar2(20) | Bus to Vocational School |
RodeBus40D | 14.9.3 | Number(1,0) | Rode Bus on the 40D Date |
MSIXID | 14.10.1 | Varchar2(12) | Migrant student MSIXID |
ArrivalDate | 14.10.1 | Date | Migrant student arrival Date |
MoveFromState | 14.10.1 | Varchar2(3) | Migrant student MoveFromState |
MoveToState | 14.10.1 | Varchar2(3) | Migrant student MoveToState |
EligExpDate | 14.10.1 | Date | Migrant student EligExpDate |
COEStatus | 14.10.1 | Varchar2(3) | Migrant student COEStatus |
LastMoveDate | 14.10.1 | Date | Migrant student LastMoveDate |
StartSmart_PF | 15.2.0 | Number(10,0) | ProgramFact StartSmart field |
TitleIAND | 15.2.0 | Varchar2(1) | ProgramFact TitleIAND field |
TitleIAPR | 15.2.0 | Varchar2(1) | ProgramFact TitleIAPR field |
HSDA | 15.4.0 | Number(1,0) | Student Misc and Programs Fact field |
HSDALocation | 15.4.0 | Number(11,0) | Student Misc and Programs Fact field |
Grade9EntryDate | 15.7.0 | Date | Migrated from [Students.NM_9th_Grd_Entry]. |
SpEdPercentage | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_AmountSpecialEducation]. |
BEPModel | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_BEPModel]. |
BilingualEducation | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_BilingualEducation]. |
Braille_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Braille]. |
CareerCluster | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Cluster]. |
CompletedCareerTechCrs_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_CompletedThreeCareerTechCoursesFlag]. |
DevDisabilitiesSvc_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_DevelopmentalDisabilitiesServicesUponExit]. |
Disability | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Disability]. |
Displaced_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_DISPLACED]. |
DwellingArrangementCode | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_DwellingArrangementCode]. |
EarlyChildhoodEd_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_EarlyChildhoodEducation]. |
EligibleBusSvc_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_EligibleBusService]. |
EligibleBusSvcVocEd_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_EligibleBusServiceVocationalEducation]. |
ReclassificationMethod | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ELLReclassifiedAsEnglishProficientMethod]. |
ELLAssessDate | 15.7.0 | Date | Migrated from [Students.NM_EnglishLanguageLearnersAssessed]. |
ELL_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_EnglishLanguageLearnersFlag]. |
EnrAtStart_TF | 15.7.0 | Number(1,0) | Migrated from [Students.NM_Enr_At_Start]. |
EnrollChangeCode | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_EnrollChangeCode]. |
EnrolledInCarlDPerkinsProg_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_EnrolledInCarlDPerkinsProgram]. |
SpEdEntryDate | 15.7.0 | Date | Migrated from [Students.NM_EnteredSpecialEducation]. |
ESLModel | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ESLModel]. |
SpEdEvalDate | 15.7.0 | Date | Migrated from [Students.NM_EvaluationSpecialEducation]. |
SpEdExitDate | 15.7.0 | Date | Migrated from [Students.NM_ExitedSpecialEducation]. |
ExitedSpEdStatus | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ExitedSpecialEducationStatus]. |
ExpectedDiplomaType | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ExpectedDiplomaType]. |
ExpectedGradDate | 15.7.0 | Date | Migrated from [Students.NM_ExpectGradTimeframe]. |
FAEA_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_FAEA]. |
FederalForm506_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_FederalForm506Flag]. |
FEPClass | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_FEPClass]. |
FirstGradeSchCode | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_FirstGradeSCHLCODE]. |
ForeignExchange73_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Foreign_Exchange_73]. |
GiftedPartCode80_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Gifted_Part_Code_80]. |
GradCohort | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_GradCohort]. |
OSGrade_TF | 15.7.0 | Number(1,0) | Migrated from [Students.NM_GradeInd]. |
GradStudentAppliedTo | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_GraduatingStudentAppliedToFlag]. |
GraduationTerm | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_GraduationTerm]. |
GuardianFirstName | 15.7.0 | Varchar2(40) | Migrated from [Students.NM_Guardian_FN]. |
GuardianLastName | 15.7.0 | Varchar2(40) | Migrated from [Students.NM_Guardian_LN]. |
HabitualTruant_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_HabitualTruant]. |
HearingImpaired | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_HearingImpaired]. |
Homeless | 15.7.0 | Varchar2(3) | Migrated from [Students.NM_HOMELESS]. |
Immigrant_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_IMMIGRANT]. |
IndependentLivingSvc_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_IndependentLivingServicesUponExit]. |
IntegratedSS_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_IntegratedSS]. |
KindergartenSchCode | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_KindergartenSCHLCODE]. |
LanguageAssessed | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_LanguageOfProficiencyAssessed]. |
LangProfAssessment | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_LanguageOfProficiencyAssessedTest]. |
LangSpokenInHome | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_LanguageSpokenInHome]. |
LastIEPDate | 15.7.0 | Date | Migrated from [Students.NM_LastIepDate]. |
LocationCode | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_LocationCode]. |
CareerTechStudentOrg1 | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_MemberOfCareerTechnicalStudentOrganizations]. |
CareerTechStudentOrg2 | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_MemberOfCareerTechnicalStudentOrganizations2]. |
CareerTechStudentOrg3 | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_MemberOfCareerTechnicalStudentOrganizations3]. |
MentalHealthSvc_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_MentalHealthServicesUponExit]. |
ELLIdMethod | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_MethodToIdentifyELL]. |
Migrant112_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Migrant_112]. |
OtherDisabilities1 | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_OtherDisabilities]. |
OtherDisabilities2 | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_OtherDisabilities2]. |
OtherDisabilities3 | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_OtherDisabilities3]. |
PassAllCareerTechCourses_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_PassAllCareerTechCoursesFlag]. |
PlacementType6 | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_placement_type_6]. |
PLAN504_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_PLAN504]. |
PostSecondaryEdSvc_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_PostsecondaryEducationServicesUponExit]. |
PrimAddCity | 15.7.0 | Varchar2(25) | Migrated from [Students.NM_PrimAddCity]. |
PrimAddState | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_PrimAddStateCode]. |
PrimAddZip | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_PrimAddZip]. |
PrimaryAreaDisability59 | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Primary_Area_Disability_59]. |
PrimarySettingCode | 15.7.0 | Varchar2(10) | Migrated from [Students.NM_PrimarySettingCode]. |
PrimHomeAddL1 | 15.7.0 | Varchar2(30) | Migrated from [Students.NM_PrimHomeAddL1]. |
PrimHomeAddL2 | 15.7.0 | Varchar2(30) | Migrated from [Students.NM_PrimHomeAddL2]. |
ProficiencyCredential_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ProficiencyCredentialFlag]. |
RecvResService_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Receiving_Res_Service]. |
RecvAudiologistSvc_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ReceivingAudiologistService]. |
RecvExtendedYearSvc_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ReceivingExtendedYearServices]. |
RecvInterpreterForDeafSvc_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ReceivingInterpreterForDeafService]. |
RecvOccupationalTherapy_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ReceivingOccupationalTherapyAsRelatedService]. |
RecvOrientation_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ReceivingOrientationAsRelatedService]. |
RecvPhysicalTherapy_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ReceivingPhysicalTherapyAsRelatedService]. |
RecvPsychologicalSvc_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ReceivingPsychologicalService]. |
RecvRecreationalTherapy_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ReceivingRecreationalTherapyAsRelatedService]. |
RecvSocialWorkSvc_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ReceivingSocialWorkService]. |
RecvSpedSvc_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ReceivingSpedServices]. |
RecvSpeech_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ReceivingSpeechAsRelatedService]. |
RecvSpeechOnly_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ReceivingSpeechOnly]. |
ResidentStatusCode | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_ResidentStatusCode]. |
Retained_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_RetainedOrFailedFlag]. |
SecondGradeSchCode | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_SecondGradeSCHLCODE]. |
ServiceCycle | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Serv_Cycle]. |
ServiceFreq | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Service_Freq]. |
ServiceProvider21 | 15.7.0 | Varchar2(50) | Migrated from [Students.NM_service_provider_21]. |
ServiceSize | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Service_Size]. |
ServicesNMSBVI_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Services_NMSBVI]. |
ServicesNMSD_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Services_NMSD]. |
SpEdSetting | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_SettingSpecialEducation]. |
DisabledStudentSetting | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_SettingWhereDisabledStudentLives]. |
SingleParent_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_SingleParentFlag]. |
SpEdSvc_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_SpecialEducationalServicesFlag]. |
SpEd_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_SpecialEducationFlag]. |
SpEd38_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_SpecialEducationFlag_38]. |
SpEdReferralCode | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_SpedReferralCode]. |
CaseloadTeacherSSN | 15.7.0 | Varchar2(11) | Migrated from [Students.NM_SSNCaseloadTeacher]. |
TitleIEnvCode | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleI_Env_Cde]. |
TitleIGED_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleI_GED]. |
TitleIJobPrep_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleI_JobPart]. |
TitleIaParticipation | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleIaParticipation]. |
TitleICounselSocialWork_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleICounselingSocialWork]. |
TitleICParticipation_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleIcParticipation]. |
TitleID_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleID]. |
TitleIGeneralTutoring_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleIGeneralTutoring]. |
TitleIGeography_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleIGeography]. |
TitleIHealthDental_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleIHealthDental]. |
TitleIHistory_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleIHistory]. |
TitleIIIParticipation_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleIiiParticipation]. |
TitleIInstructOtherDesc | 15.7.0 | Varchar2(100) | Migrated from [Students.NM_TitleIInstructionalOtherDesc]. |
TitleIMath_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleIMath]. |
TitleIOther_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleIOther]. |
TitleIReadingELA_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleIReadingELA]. |
TitleIScience_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleIScience]. |
TitleISupportOther_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleISupportOther]. |
TitleISupportOtherDesc | 15.7.0 | Varchar2(20) | Migrated from [Students.NM_TitleISupportOtherDesc]. |
TitleIVocationalCareer_TF | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleIVocationalCareer]. |
TitleVIIIParticipation_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleViiiParticipation]. |
TitleVIIParticipation_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TitleViiParticipation]. |
TransitionIEPStatus | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TransitionIEPStatus]. |
TransitionStatementOnIep_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TransitionStatementOnIep]. |
Tribe | 15.7.0 | Varchar2(2) | Migrated from [Students.NM_Tribe]. |
Truant_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Truant]. |
DiplomaType | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_TypeOfDiploma]. |
UnaccYouth25 | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_Unacc_Youth_25]. |
US3YEARS_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_US3YEARS]. |
VerifiedStateID_TF | 15.7.0 | Number(1,0) | Migrated from [Students.NM_VERIFY4]. |
VisionAndHearingImpaired | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_VisionAndHearingImpaired]. |
VisionImpaired | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_VisionImpaired]. |
VocRehabSvc_YN | 15.7.0 | Varchar2(5) | Migrated from [Students.NM_VocationalRehabilitationServicesUponExit]. |
RodeBus80D | 15.9.0 | Number(1,0) | Rode Bus on 80D Date |
RodeBus120D | 15.9.0 | Number(1,0) | Rode Bus on 120D Date |
AltGuardFirstName | 15.9.0 | Varchar2(40) | Alternate Guardian's First Name |
AltGuardLastName | 15.9.0 | Varchar2(40) | Alternate Guardian's Last Name |
ExpectingStudent | 15.9.0 | Varchar2(3) | Student is Expecting |
PreferredName | 16.5.0 | Varchar2(60) | Student's Preferred Name |
PreferredGender | 16.5.0 | Varchar2(1) | Student's Preferred Gender |
NMPreK | 16.8.1 | Number(1,0) | Student is participating in a NMPreK program. |
CSDA | 16.8.1 | Number(1,0) | Student is participating in a CSDA program. |
CSDALocation | 16.8.1 | Number(11,0) | Alternate school number for CSDA program, if different than home school. |
AlternateAssessment | 18.8.0 | Varchar2(1) | Alternate Assessment for Special Education |
EventCode40 | 18.8.0 | Number(1,0) | LEA assures that compliance has met for the following Post-secondary Transition |
EventCode40Date | 18.8.0 | Date | Post-secondary Transition Goals Compliance Date |
MathADC | 19.8.1.0 | Number(1,0) | Math ADC |
ELAADC | 19.8.1.0 | Number(1,0) | ELA ADC |
ScienceADC | 19.8.1.0 | Number(1,0) | Science ADC |
SocStudADC | 19.8.1.0 | Number(1,0) | Social Studies ADC |
RodeBusK5P | 19.8.1.0 | Number(1,0) | Rode Bus during K5P Dates |
HomeSchooledClasses | 20.8.2.0 | Boolean | Home Schooled & Taking Class(es) in the District |
SPEDPostGradActivity | 21.8.2.0 | VARCHAR2(5 CHAR) | Sped Post Graduation Activity |
K5P | 21.8.2.0 | VARCHAR2(3 CHAR) | k5P |
DENTALEXAMWAIVER | 21.9.1.0 | VARCHAR2(6 CHAR) | Dental Examination Verification Waiver |
ANNUALDELAYRSNCD | 21.9.1.0 | VARCHAR2(2 CHAR) | Anual review delay reason code |
TRIENNIALDELAYRSNCD | 21.9.1.0 | VARCHAR2(2 CHAR) | Triennial review delay reason code |
DiplomaAwardDate | 22.3.2.0 | Date | Diploma Award Date (Ed-Fi) |
DateEnteredUSSchools | 22.3.2.0 | Date | Date Entered US Schools (Ed-Fi) |
OSS_Service number | 22.9.1.0 | Number(11,0) | OSS service number |
OSS_Responsible number | 22.9.1.0 | Number(11,0) | OSS responsible number |
Include_Exclude | 22.9.2.0 | Boolean | Include or Exclude Students from the EELTO -ELTP After School Program |