S_OR_STU_CumADM_X (ver 15.7.0)
This table is an extension of the [Students] table. These fields are related to Cumulative ADM reporting.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 15.7.0 | Number(10,0) | Primary key that relates the extended table back to the Students table. |
| DiplomaTypCd | 15.10.3 | Varchar2(1) | Code indicating the type of diploma issued by the district. Migrated from [Students.OR_ADMDiplomaTypCd]. |
| DistSPEDPrgFg | 15.10.3 | Number(1,0) | Indicates the student is in a district SPED program during the enrollment. Migrated from [Students.OR_PTDistSPEDPrgFg]. |
| EndDtCd | 15.10.3 | Varchar2(2) | Code describing the student's enrollment status on the Enrollment End Date. Migrated from [Students.OR_ADMEndDtCd]. |
| EsntlSkill_Fill | 15.10.3 | Varchar2(100) | Local essential skill information (filler). Reserved for future use by ODE. Migrated from [Students.OR_EsntlSkillFill]. |
| EsntlSkill_MathCd | 15.10.3 | Varchar2(1) | Code indicating how the assessment of essential skill requirement to "Apply mathematics in a variety of settings" was met. Migrated from [Students.OR_MaEsntlSkillCd]. |
| EsntlSkill_MathDt | 15.10.3 | Date | Date the test was administered that serves as evidence of proficiency for the Mathematics Essential Skill. Migrated from [Students.OR_MaEsntlSkillDtTxt]. |
| EsntlSkill_ReadCd | 15.10.3 | Varchar2(1) | Code indicating how the assessment of essential skill requirement to "Read and comprehend a variety of texts" was met. Migrated from [Students.OR_RdEsntlSkillCd]. |
| EsntlSkill_ReadDt | 15.10.3 | Date | Date the test was administered that serves as evidence of proficiency for the Reading Essential Skill. Migrated from [Students.OR_RdEsntlSkillDtTxt]. |
| EsntlSkill_SpeakCd | 15.10.3 | Varchar2(1) | Code indicating how the assessment of essential skill requirement to "Listen actively and speak clearly and coherently" was met. Migrated from [Students.OR_SkEsntlSkillCd]. |
| EsntlSkill_SpeakDt | 15.10.3 | Date | Date the test was administered that serves as evidence of proficiency for the Speaking Essential Skill. Migrated from [Students.OR_SkEsntlSkillDtTxt]. |
| EsntlSkill_WriteCd | 15.10.3 | Varchar2(1) | Code indicating how the assessment of essential skill requirement to "Write clearly and accurately" was met. Migrated from [Students.OR_WrEsntlSkillCd]. |
| EsntlSkill_WriteDt | 15.10.3 | Date | Date the test was administered that serves as evidence of proficiency for the Writing Essential Skill. Migrated from [Students.OR_WrEsntlSkillDtTxt]. |
| Fill | 15.10.3 | Varchar2(100) | Reserved for future use. Migrated from [Students.OR_ADMFill]. |
HalfDayKGFg | 15.7.0 | Number(1,0) | Flag indicating that this student participates in the half-day kindergarten program. |
| InstrctHrs_CaseMngmnt | 15.10.3 | Number(25,10) | The number of hours of case management instruction received by a student during the reporting period. Migrated from [Students.OR_ADMInstrctHrs_CaseMngmnt]. |
| InstrctHrs_EmpMinors | 15.10.3 | Number(25,10) | The number of hours of employed minors instruction received by a student during the reporting period. Migrated from [Students.OR_ADMInstrctHrs_EmpMinors]. |
| InstrctHrs_Expanded | 15.10.3 | Number(25,10) | The number of hours of Expanded options received by a student during the reporting period. Migrated from [Students.OR_ADMInstrctHrs_Expanded]. |
| InstrctHrs_InterGroup | 15.10.3 | Number(25,10) | The number of hours of intermediate group instruction received by a student during the reporting period. Migrated from [Students.OR_ADMInstrctHrs_InterGroup]. |
| InstrctHrs_LargeGroup | 15.10.3 | Number(25,10) | The number of hours of large group instruction received by a student during the reporting period. Migrated from [Students.OR_ADMInstrctHrs_LargeGroup]. |
| InstrctHrs_NotExpanded | 15.10.3 | Number(25,10) | The number of hours of College Coursework not expanded options received by a student during the reporting period. Migrated from [Students.OR_ADMInstrctHrs_CCourseworkNExpanded]. |
| InstrctHrs_SharedTime | 15.10.3 | Number(25,10) | The number of hours of shared time instruction received by a student during the reporting period. Migrated from [Students.OR_ADMInstrctHrs_SharedTime]. |
| InstrctHrs_SmallGroup | 15.10.3 | Number(25,10) | The number of hours of small group instruction received by a student during the reporting period. Migrated from [Students.OR_ADMInstrctHrs_SmallGroup]. |
| InstrctHrs_Tutorial | 15.10.3 | Number(25,10) | The number of hours of tutorial instruction received by a student during the reporting period. Migrated from [Students.OR_ADMInstrctHrs_Tutorial]. |
| MltryCnctFg | 17.4.0 | Number(1,0) | Flag indicating that this student had a parent or guardian who was a member of the Armed Forces on active duty or full-time National Guard at any time during the school year. |
| ReportInstructHoursOnly | 15.10.3 | Number(1,0) | Indicates that instructional hours only and not standard membership should be reported for the school enrollment. Migrated from [Students.OR_ReportInstructHoursOnly]. |
| TuitionTypCd | 15.10.3 | Varchar2(1) | Code indicating the tuition type the student is enrolled under during the reporting period. Migrated from [Students.OR_ADMTuitionTypCd]. |
| WthdrFctrCd | 15.10.3 | Varchar2(2) | Code indicating the primary factor influencing the student's decision to withdraw. Migrated from [Students.OR_ADMWthdrFctrCd]. |
| ADMPrgTypCdOvride | 21.8.2.0 | Varchar2(2) | Code indicating the Program Type Code Override (Overrides the calculated standard program value). |