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 |