S_ND_STU_MigrantPrograms_C (ver 17.7.0)
This table is an extension of the [Students] table, migrated from ND_MigrantPrograms virtual table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
unique_ID | 17.7.0 | Number(11,0) | Unique ID. Migrated from [ND_MigrantPrograms.unique_ID]. |
| schoolID | 17.7.0 | Number(11,0) | School ID. Migrated from [ND_MigrantPrograms.schoolID]. |
| foreignKey | 17.7.0 | Number(11,0) | Foreign Key. Migrated from [ND_MigrantPrograms.foreignKey]. |
| foreignKey_alpha | 17.7.0 | Varchar2(31) | ForeignKey Alpha. Migrated from [ND_MigrantPrograms.foreignKey_alpha]. |
| startDate | 17.7.0 | Date | Program Start Date. Migrated from [ND_MigrantPrograms.user_defined_date]. |
| endDate | 17.7.0 | Date | Program End Date. Migrated from [ND_MigrantPrograms.user_defined_date2]. |
| exitReasonCode | 17.7.0 | Varchar2(2) | Exit Reason Code. Migrated from [ND_MigrantPrograms.user_defined_text]. |
| migrantComment | 17.7.0 | Varchar2(75) | Migrant Comment. Migrated from [ND_MigrantPrograms.user_defined_text2]. |
| LastQualifyingMove_QAD | 21.6.2.0 | Date | Identifies the date the child arrives at the place to join the worker. |