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]. |