S_NY_STU_ProgramSvc_C (ver 17.7.0)
This table is a child table of the [Students] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| unique_ID | 17.7.0 | Number(11,0) | Migrated From [ProgramSvc]unique_ID |
| schoolID | 17.7.0 | Number(11,0) | Migrated From [ProgramSvc]schoolID |
| foreignKey | 17.7.0 | Number(11,0) | Migrated From [ProgramSvc]foreignKey |
| foreignKey_alpha | 17.7.0 | Varchar2(31) | Migrated From [ProgramSvc]foreignKey_alpha |
| ProgramServiceLevel | 17.7.0 | Varchar2(1) | Migrated From [ProgramSvc]ProgramServiceLevel |
| ParticipationInfoCode | 17.7.0 | Varchar2(6) | Migrated From [ProgramSvc]ParticipationInfoCode |
| ExitReasonCode | 17.7.0 | Varchar2(10) | Migrated From [ProgramSvc]ExitReasonCode |
| StateLocationID | 17.7.0 | Varchar2(20) | Migrated From [ProgramSvc]StateLocationID |
| ProgramServiceCode | 17.7.0 | Varchar2(8) | Migrated From [ProgramSvc]ProgramServiceCode |
| CTETechPrepCategory | 17.7.0 | Varchar2(10) | Migrated From [ProgramSvc]CTETechPrepCategory |
| ProgramIntensity | 17.7.0 | Varchar2(20) | Migrated From [ProgramSvc]ProgramIntensity |
| ProgramServiceCategory | 17.7.0 | Varchar2(10) | Migrated From [ProgramSvc]ProgramServiceCategory |
| ProgramDuration | 17.7.0 | Varchar2(1) | Migrated From [ProgramSvc]ProgramDuration |
| BeginningDate | 17.7.0 | Date | Migrated From [ProgramSvc]user_defined_date |
| EndingDate | 17.7.0 | Date | Migrated From [ProgramSvc]user_defined_date2 |
| ProgramEligibilitycode1 | 17.9.0 | Varchar2(20) | Migrated From [ProgramSvc]ProgramEligibilitycode1 |
| ProgramEligibilitycode2 | 17.9.0 | Varchar2(20) | Migrated From [ProgramSvc]ProgramEligibilitycode2 |
| ProgramEligibilitycode3 | 17.9.0 | Varchar2(20) | Migrated From [ProgramSvc]ProgramEligibilitycode3 |
| ProgramEligibilitycode4 | 17.9.0 | Varchar2(20) | Migrated From [ProgramSvc]ProgramEligibilitycode4 |
| ProgramEligibilitycode5 | 17.9.0 | Varchar2(20) | Migrated From [ProgramSvc]ProgramEligibilitycode5 |
| ProgramEligibilitycode6 | 17.9.0 | Varchar2(20) | Migrated From [ProgramSvc]ProgramEligibilitycode6 |
| NighttimeResidence | 18.12.0 | Varchar2(20) | Store PRIMARY NIGHTTIME RESIDENCE for student |