S_ND_STU_HomelessPrograms_C (ver 17.7.0)
This table is an extension of the [Students] table, migrated from ND_HomelessPrograms virtual table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
unique_ID | 17.7.0 | Number(11,0) | Unique ID. Migrated from [ND_HomelessPrograms.unique_ID]. |
| schoolID | 17.7.0 | Number(11,0) | School ID. Migrated from [ND_HomelessPrograms.schoolID]. |
| foreignKey | 17.7.0 | Number(11,0) | Foreign Key. Migrated from [ND_HomelessPrograms.foreignKey]. |
| foreignKey_alpha | 17.7.0 | Varchar2(31) | ForeignKey Alpha. Migrated from [ND_HomelessPrograms.foreignKey_alpha]. |
| startDate | 17.7.0 | Date | Program Start Date. Migrated from [ND_HomelessPrograms.user_defined_date]. |
| endDate | 17.7.0 | Date | Program End Date. Migrated from [ND_HomelessPrograms.user_defined_date2]. |
| exitReasonCode | 17.7.0 | Varchar2(2) | Exit Reason Code. Migrated from [ND_HomelessPrograms.user_defined_text]. |
| homelessComment | 17.7.0 | Varchar2(75) | Homeless Comment. Migrated from [ND_HomelessPrograms.user_defined_text2]. |
| Assist_Participation | 20.4.4 | Boolean | Assistance with participation in school programs. |
| Before_After_Schl_Pgm | 20.4.4 | Boolean | Before-school, after-school, mentoring, summer programs. |
| Clothing | 20.4.4 | Boolean | Clothing. |
| Coord_Schl_Agency | 20.4.4 | Boolean | Coordination between schools and agencies. |
| Counseling | 20.4.4 | Boolean | Counseling. |
| Domestic_Violence | 20.4.4 | Boolean | Addressing needs related to domestic violence. |
| Early_Childhood | 20.4.4 | Boolean | Early childhood programs. |
| Emer_Assist_Attendance | 20.4.4 | Boolean | Emergency assistance related to school attendance. |
| Expedite_Eval | 20.4.4 | Boolean | Expedited evaluations. |
| Health_Referrals | 20.4.4 | Boolean | Referrals for medical, dental and other health services. |
| McKinney_Vento_Funds | 20.4.4 | Boolean | McKinney Vento Funds. |
| NightTimeRes | 20.4.4 | VarChar2(2) | Primary Nighttime Residence. Migrated from S_ND_STU_X in version 20.4.4. |
| Other_Svcs | 20.4.4 | Boolean | Other services or activities. |
| Parent_Education | 20.4.4 | Boolean | Parent education related to rights and resources for children. |
| Records_Transfer | 20.4.4 | Boolean | Obtaining or transferring records necessary for enrollment. |
| Refer_Other_PgmSvc | 20.4.4 | Boolean | Referrals to other programs and services. |
| RequestsNoservices | 20.4.4 | Boolean | Parent Requests No Services. Migrated from S_ND_STU_X in version 20.4.4. |
| School_Supplies | 20.4.4 | Boolean | School Supplies. |
| Staff_Prof_Dev | 20.4.4 | Boolean | Staff professional development and awareness. |
| Transportation | 20.4.4 | Boolean | Transportation. |
| Tutor_InstrSvcs | 20.4.4 | Boolean | Tutoring or other instructional support. |
| Unaccompanied | 20.4.4 | Boolean | Unaccompanied Youth. Migrated from S_ND_STU_X in version 20.4.4. |