S_ND_STU_Title1Programs_C (ver 17.7.0)
This table is an extension of the [Students] table, migrated from ND_TitleIPrograms virtual table.
Column Name | Version | Data Type | Description |
---|---|---|---|
unique_ID | 17.7.0 | Number(11,0) | Unique ID. Migrated from [ND_TitleIPrograms.unique_ID]. |
schoolID | 17.7.0 | Number(11,0) | School ID. Migrated from [ND_TitleIPrograms.schoolID]. |
foreignKey | 17.7.0 | Number(11,0) | Foreign Key. Migrated from [ND_TitleIPrograms.foreignKey]. |
foreignKey_alpha | 17.7.0 | Varchar2(31) | ForeignKey Alpha. Migrated from [ND_TitleIPrograms.foreignKey_alpha]. |
startDate | 17.7.0 | Date | Program Start Date. Migrated from [ND_TitleIPrograms.user_defined_date]. |
endDate | 17.7.0 | Date | Program End Date. Migrated from [ND_TitleIPrograms.user_defined_date2]. |
ExitReasonCode | 17.7.0 | Varchar2(2) | Exit Reason Code. Migrated from [ND_TitleIPrograms.user_defined_text]. |
TargetMath | 17.7.0 | Number(1,0) | Title I Targeted Mathematics. Migrated from [ND_TitleIPrograms.ND_TargetMath]. |
TargetLanguageArts | 17.7.0 | Number(1,0) | Title I Targeted Reading/Language Arts. Migrated from [ND_TitleIPrograms.ND_TargetLanguageArts]. |
TargetScience | 17.7.0 | Number(1,0) | Title I Targeted Science. Migrated from [ND_TitleIPrograms.ND_TargetScience]. |
TargetSocialStudies | 17.7.0 | Number(1,0) | Title I Targeted Social Studies. Migrated from [ND_TitleIPrograms.ND_TargetSocialStudies]. |
TargetVocational | 17.7.0 | Number(1,0) | Title I Targeted Vocational/Career. Migrated from [ND_TitleIPrograms.ND_TargetVocational]. |
TargetOtherInstructional | 17.7.0 | Number(1,0) | Title I Targeted Other Instructional Services. Migrated from [ND_TitleIPrograms.ND_TargetOtherInstructional]. |
TargetHealth | 17.7.0 | Number(1,0) | Title I Targeted Health, Dental and Eye Care. Migrated from [ND_TitleIPrograms.ND_TargetHealth]. |
TargetGuidance | 17.7.0 | Number(1,0) | Title I Targeted Supporting Guidance/Advocacy. Migrated from [ND_TitleIPrograms.ND_TargetGuidance]. |
TargetOtherSupport | 17.7.0 | Number(1,0) | Title I Targeted Other Support Services. Migrated from [ND_TitleIPrograms.ND_TargetOtherSupport]. |
TitleIComment | 17.7.0 | Varchar2(75) | Title I Comment. Migrated from [ND_TitleIPrograms.user_defined_text2]. |