S_ID_SEN_X (ver 15.7.0)
This is an extension of the SpEnrollments table.
Column Name | Version | Data Type | Description |
---|---|---|---|
SpEnrollmentsDCID | 15.7.0 | Number(10,0) | Primary Key |
AcademicGift | 15.7.0 | Varchar2(5) | Academically Gifted (Y/N). Migrated from [SpEnrollments.ID_AcademicGift]. |
Acc1 | 15.7.0 | Varchar2(5) | No longer in use. Migrated from [SpEnrollments.ID_Acc1]. |
Acc2 | 15.7.0 | Varchar2(5) | No longer in use. Migrated from [SpEnrollments.ID_Acc2]. |
Acc3 | 15.7.0 | Varchar2(5) | No longer in use. Migrated from [SpEnrollments.ID_Acc3]. |
Adapt | 15.7.0 | Varchar2(5) | Adaptation (Y/N). Migrated from [SpEnrollments.ID_Adapt]. |
ArtsGift | 15.7.0 | Varchar2(5) | Visual/Performing Arts Gifted (Y/N). Migrated from [SpEnrollments.ID_ArtsGift]. |
CaseManager | 15.7.0 | Varchar2(20) | Case Manager (Idaho Staff ID). Migrated from [SpEnrollments.ID_CaseManager]. |
CMDADate | 15.7.0 | Date | Current CMDA Date. Migrated from [SpEnrollments.ID_CMDADate]. |
ConsentDate | 15.7.0 | Date | Date the parents signed consent for initial assessment/eligibility determination. Starts 60 day timeline. |
CreativeGift | 15.7.0 | Varchar2(5) | Creatively Gifted (Y/N). Migrated from [SpEnrollments.ID_CreativeGift]. |
DaysLate | 15.7.0 | Number(11,0) | 60-day Timeline Compliance Days Late. Migrated from [SpEnrollments.ID_DaysLate]. |
Environment | 15.7.0 | Varchar2(5) | Special Education Environment. Migrated from [SpEnrollments.ID_Environment]. |
Exceptionality | 15.7.0 | Varchar2(5) | Primary Exceptionality (2 digit code). Migrated from [SpEnrollments.ID_Exceptionality]. |
Exceptionality2 | 15.7.0 | Varchar2(5) | Exceptionality 2 (2 digit code). Migrated from [SpEnrollments.ID_Exceptionality2]. |
Exceptionality3 | 15.7.0 | Varchar2(5) | Exceptionality 3 (2 digit code). Migrated from [SpEnrollments.ID_Exceptionality3]. |
Exceptionality4 | 15.7.0 | Varchar2(5) | Exceptionality 4 (2 digit code). Migrated from [SpEnrollments.ID_Exceptionality4]. |
Exceptionality5 | 15.7.0 | Varchar2(5) | Exceptionality 5 (2 digit code). Migrated from [SpEnrollments.ID_Exceptionality5]. |
ExRule | 15.7.0 | Varchar2(5) | 60-day Timeline Compliance Late Exception Rule. Migrated from [SpEnrollments.ID_ExRule]. |
GTIdDate | 15.7.0 | Date | First Identified as Gifted/Talented. Migrated from [SpEnrollments.ID_GTIdDate]. |
HomelessResidence | 15.7.0 | Varchar2(5) | Homeless Residence (1 digit code). Migrated from [SpEnrollments.ID_HomelessResidence]. |
HomelessUAY | 15.7.0 | Varchar2(5) | Homeless Unaccomp. Youth (Y/N). Migrated from [SpEnrollments.ID_HomelessUAY]. |
IDSpedDate | 15.7.0 | Date | First Identified as qualifying for SPED Services. Migrated from [SpEnrollments.ID_IDSpedDate]. |
IEPDate | 15.7.0 | Date | Active IEP Date. Migrated from [SpEnrollments.ID_IEPDate]. |
InFosterCare | 15.7.0 | Varchar2(5) | No UI element, not in use. Migrated from [SpEnrollments.ID_InFosterCare]. |
IntellectualGift | 15.7.0 | Varchar2(5) | Intellectually Gifted (Y/N). Migrated from [SpEnrollments.ID_IntellectualGift]. |
LanguageAA | 15.7.0 | Number(1,0) | Language Alternatively Assessed (1/null). Migrated from [SpEnrollments.ID_LanguageAA]. |
LanguageDictAcmd | 15.7.0 | Number(1,0) | Language LEP Word for Word Dictionary (1/null). Migrated from [SpEnrollments.ID_LanguageDictAcmd]. |
LanguageFormAcmd | 15.7.0 | Varchar2(5) | Language Accommodation 1 Form (1/null). Migrated from [SpEnrollments.ID_LanguageFormAcmd]. |
LanguageHS | 15.7.0 | Varchar2(5) | Language Usage Home School where taught (Y/N). Migrated from [SpEnrollments.ID_LanguageHS]. |
LanguageOtherAcmd | 15.7.0 | Number(1,0) | Language Additional Accommodation(s) (1/null). Migrated from [SpEnrollments.ID_LanguageOtherAcmd]. |
LDRea | 15.7.0 | Varchar2(5) | 60-day Timeline Compliance Late Determination Reason. Migrated from [SpEnrollments.ID_LDRea]. |
LeadershipGift | 15.7.0 | Varchar2(5) | Leadership Gifted (Y/N). Migrated from [SpEnrollments.ID_LeadershipGift]. |
LEPLanguage | 15.7.0 | Varchar2(5) | LEP Language (1 char code). Migrated from [SpEnrollments.ID_LEPLanguage]. |
LEPStatus | 15.7.0 | Varchar2(5) | LEP Status (2 char code). Migrated from [SpEnrollments.ID_LEPStatus]. |
MathDictAcmd | 15.7.0 | Number(1,0) | Mathematics LEP Word for Word Dictionary (1/null). Migrated from [SpEnrollments.ID_MathDictAcmd]. |
MathematicsAA | 15.7.0 | Number(1,0) | Mathematics Alternatively Assessed (1/null). Migrated from [SpEnrollments.ID_MathematicsAA]. |
MathematicsHS | 15.7.0 | Varchar2(5) | Mathematics Home School where taught (Y/N). Migrated from [SpEnrollments.ID_MathematicsHS]. |
MathFormAcmd | 15.7.0 | Varchar2(5) | Mathematics Accommodation 1 Form (1/null). Migrated from [SpEnrollments.ID_MathFormAcmd]. |
MathOtherAcmd | 15.7.0 | Number(1,0) | Mathematics Additional Accommodation(s) (1/null). Migrated from [SpEnrollments.ID_MathOtherAcmd]. |
MinPerWeek | 15.7.0 | Number(11,0) | Special Education Minutes Per Week. Migrated from [SpEnrollments.ID_MinPerWeek]. |
ReadingAA | 15.7.0 | Number(1,0) | Reading Alternatively Assessed (1/null). Migrated from [SpEnrollments.ID_ReadingAA]. |
ReadingDictAcmd | 15.7.0 | Number(1,0) | Reading LEP Word for Word Dictionary (1/null). Migrated from [SpEnrollments.ID_ReadingDictAcmd]. |
ReadingFormAcmd | 15.7.0 | Varchar2(5) | Reading Accommodation 1 Form (1/null). Migrated from [SpEnrollments.ID_ReadingFormAcmd]. |
ReadingHS | 15.7.0 | Varchar2(5) | Reading Home School where taught (Y/N). Migrated from [SpEnrollments.ID_ReadingHS]. |
ReadingOtherAcmd | 15.7.0 | Number(1,0) | Reading Additional Accommodation(s) (1/null). Migrated from [SpEnrollments.ID_ReadingOtherAcmd]. |
RelServ1 | 15.7.0 | Varchar2(5) | Related Service (2 digit code). Migrated from [SpEnrollments.ID_RelServ1]. |
RelServ10 | 15.7.0 | Varchar2(5) | Related Service (2 digit code). Migrated from [SpEnrollments.ID_RelServ10]. |
RelServ2 | 15.7.0 | Varchar2(5) | Related Service (2 digit code). Migrated from [SpEnrollments.ID_RelServ2]. |
RelServ3 | 15.7.0 | Varchar2(5) | Related Service (2 digit code). Migrated from [SpEnrollments.ID_RelServ3]. |
RelServ4 | 15.7.0 | Varchar2(5) | Related Service (2 digit code). Migrated from [SpEnrollments.ID_RelServ4]. |
RelServ5 | 15.7.0 | Varchar2(5) | Related Service (2 digit code). Migrated from [SpEnrollments.ID_RelServ5]. |
RelServ6 | 15.7.0 | Varchar2(5) | Related Service (2 digit code). Migrated from [SpEnrollments.ID_RelServ6]. |
RelServ7 | 15.7.0 | Varchar2(5) | Related Service (2 digit code). Migrated from [SpEnrollments.ID_RelServ7]. |
RelServ8 | 15.7.0 | Varchar2(5) | Related Service (2 digit code). Migrated from [SpEnrollments.ID_RelServ8]. |
RelServ9 | 15.7.0 | Varchar2(5) | Related Service (2 digit code). Migrated from [SpEnrollments.ID_RelServ9]. |
ScienceAA | 15.7.0 | Number(1,0) | Science Alternatively Assessed (1/null). Migrated from [SpEnrollments.ID_ScienceAA]. |
ScienceDictAcmd | 15.7.0 | Number(1,0) | Science LEP Word for Word Dictionary (1/null). Migrated from [SpEnrollments.ID_ScienceDictAcmd]. |
ScienceFormAcmd | 15.7.0 | Varchar2(5) | Science Accommodation 1 Form (1/null). Migrated from [SpEnrollments.ID_ScienceFormAcmd]. |
ScienceHS | 15.7.0 | Varchar2(5) | Science Home School where taught (Y/N). Migrated from [SpEnrollments.ID_ScienceHS]. |
ScienceOtherAcmd | 15.7.0 | Number(1,0) | Science Additional Accommodation(s) (1/null). Migrated from [SpEnrollments.ID_ScienceOtherAcmd]. |
ServiceSchoolID | 15.7.0 | Varchar2(8) | Service School ID (services at different school). Migrated from [SpEnrollments.ID_ServiceSchoolID]. |
SixtyDTline | 15.7.0 | Varchar2(5) | 60-Day timeline compliance. Migrated from [SpEnrollments.ID_60DTline]. |
SpedEligible | 15.7.0 | Varchar2(5) | SPED Eligibility (1 char code). Migrated from [SpEnrollments.ID_SpedEligible]. |
sse_ASLELA | 16.2.2 | Varchar2(40) | Indicates if the American Sign Language videos accommodation is available for all tests in the indicated subject. (ELA) |
sse_ASLELAPT | 16.2.2 | Varchar2(40) | Indicates if the American Sign Language videos accommodation is available for all tests in the indicated subject. (ELA-PT) |
sse_ASLMath | 16.2.2 | Varchar2(40) | Indicates if the American Sign Language videos accommodation is available for all tests in the indicated subject. (Math) |
sse_ClosedCapELA | 16.2.2 | Varchar2(40) | Indicates if Closed Captioning is available for ELA tests. |
sse_ColorContELA | 16.2.2 | Varchar2(40) | Color of text and background for all tests in the indicated subject. (ELA) |
sse_ColorContELAPT | 16.2.2 | Varchar2(40) | Color of text and background for all tests in the indicated subject. (ELA-PT) |
sse_ColorContMath | 16.2.2 | Varchar2(40) | Color of text and background for all tests in the indicated subject. (Math) |
sse_LangELA | 16.2.2 | Varchar2(40) | Language in which the tests in the indicated subject appear. (ELA) |
sse_LangELAPT | 16.2.2 | Varchar2(40) | Language in which the tests in the indicated subject appear. (ELA-PT) |
sse_LangMath | 16.2.2 | Varchar2(40) | Language in which the tests in the indicated subject appear. (Math) |
sse_MaskingELA | 16.2.2 | Varchar2(40) | Allows masking for all tests in the indicated subject. (ELA) |
sse_MaskingELAPT | 16.2.2 | Varchar2(40) | Allows masking for all tests in the indicated subject. (ELA-PT) |
sse_MaskingMath | 16.2.2 | Varchar2(40) | Allows masking for all tests in the indicated subject. (Math) |
sse_PermModeELA | 16.2.2 | Varchar2(40) | Permissive mode setting for tests in the indicated subject. (ELA) |
sse_PermModeELAPT | 16.2.2 | Varchar2(40) | Permissive mode setting for tests in the indicated subject. (ELA-PT) |
sse_PermModeMath | 16.2.2 | Varchar2(40) | Permissive mode setting for tests in the indicated subject. (Math) |
sse_PrintSizeELA | 16.2.2 | Varchar2(40) | Student’s print-size accommodation for all tests in the indicated subject. (ELA) |
sse_PrintSizeELAPT | 16.2.2 | Varchar2(40) | Student’s print-size accommodation for all tests in the indicated subject. (ELA-PT) |
sse_PrintSizeMath | 16.2.2 | Varchar2(40) | Student’s print-size accommodation for all tests in the indicated subject. (Math) |
sse_StreamModeELA | 16.2.2 | Varchar2(40) | Streamlined interface setting for tests in the indicated subject. (ELA) |
sse_StreamModeELAPT | 16.2.2 | Varchar2(40) | Streamlined interface setting for tests in the indicated subject. (ELA-PT) |
sse_StreamModeMath | 16.2.2 | Varchar2(40) | Streamlined interface setting for tests in the indicated subject. (Math) |
sse_TransELA | 16.2.2 | Varchar2(40) | Indicates which glossary, if any, is available for all tests in the indicated subject. (ELA) |
sse_TransELAPT | 16.2.2 | Varchar2(40) | Indicates which glossary, if any, is available for all tests in the indicated subject. (ELA-PT) |
sse_TransMath | 16.2.2 | Varchar2(40) | Indicates which glossary, if any, is available for all tests in the indicated subject. (Math) |
sse_TTSELA | 16.2.2 | Varchar2(40) | Student’s text-to-speech accommodation for all tests in the indicated subject. (ELA) |
sse_TTSELAPT | 16.2.2 | Varchar2(40) | Student’s text-to-speech accommodation for all tests in the indicated subject. (ELA-PT) |
sse_TTSMath | 16.2.2 | Varchar2(40) | Student’s text-to-speech accommodation for all tests in the indicated subject. (Math) |
Tested_Ineligible | 15.7.0 | Number(1,0) | Tested - Ineligible for Special Education (1/null). Migrated from [SpEnrollments.ID_Tested_Ineligible]. |
UndetRea | 15.7.0 | Varchar2(5) | SPED Eligibility Undetermined Reason (2 char code). Migrated from [SpEnrollments.ID_UndetRea]. |