S_SC_STU_TRANS_X (ver 15.7.3)
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
---|---|---|---|
StudentsDCID | 15.7.3 | Number(10,0) | The foreign key that links this record to the Students table. |
TRANS_OtherSpecNeedsReq01Ind | 15.7.3 | Varchar2(65) | Identifies the special equipment required if Special Need 8 is Yes. Migrated from [Students.SC_Trans_OtherSpecNeedsReq01Ind]. |
TRANS_OtherSpecNeedsReq02Ind | 15.7.3 | Varchar2(65) | Identifies the special equipment required if Special Need 8 is Yes and more than one type of equipment is needed. Migrated from [Students.SC_Trans_OtherSpecNeedsReq02Ind]. |
TRANS_SpecNeedsReq01Ind | 15.7.3 | Number(1,0) | Identifies if the student needs special transportation across school zone lines. Migrated from [Students.SC_Trans_SpecNeedsReq01Ind]. |
TRANS_SpecNeedsReq02Ind | 15.7.3 | Number(1,0) | Identifies if the student needs special transportation across district boundary lines. Migrated from [Students.SC_Trans_SpecNeedsReq02Ind]. |
TRANS_SpecNeedsReq03Ind | 15.7.3 | Number(1,0) | Identifies if the student needs special transportation between schools. Migrated from [Students.SC_Trans_SpecNeedsReq03Ind]. |
TRANS_SpecNeedsReq04Ind | 15.7.3 | Number(1,0) | Identifies if the student needs special transportation to medical services. Migrated from [Students.SC_Trans_SpecNeedsReq04Ind]. |
TRANS_SpecNeedsReq05Ind | 15.7.3 | Number(1,0) | Identifies if the student needs special transportation on extracurricular/field trips. Migrated from [Students.SC_Trans_SpecNeedsReq05Ind]. |
TRANS_SpecNeedsReq06Ind | 15.7.3 | Number(1,0) | Identifies if the student needs special transportation to support employment. Migrated from [Students.SC_Trans_SpecNeedsReq06Ind]. |
TRANS_SpecNeedsReq07Ind | 15.7.3 | Number(1,0) | Identifies if the student needs special transportation in and around school buildings. Migrated from [Students.SC_Trans_SpecNeedsReq07Ind]. |
TRANS_SpecNeedsReq08Ind | 15.7.3 | Number(1,0) | Identifies if the student IEP requires special equipment during transport. Migrated from [Students.SC_Trans_SpecNeedsReq08Ind]. |
TRANS_SpecNeedsReq09Ind | 15.7.3 | Number(1,0) | Identifies if the student IEP requires aide or shadow to accompany student. Migrated from [Students.SC_Trans_SpecNeedsReq09Ind]. |
TRANS_SpecNeedsReq10Ind | 15.7.3 | Number(1,0) | Identifies if the student IEP requires a nurse to accompany the student. Migrated from [Students.SC_Trans_SpecNeedsReq10Ind]. |
TRANS_StreetName | 15.7.3 | Varchar2(30) | The street name for the address where the student will be picked up and delivered. Migrated from [Students.SC_Trans_StreetName]. |
TRANS_StreetNum | 15.7.3 | Varchar2(10) | The street number for the address where the student will be picked up and delivered. Migrated from [Students.SC_Trans_StreetNum]. |
TRANS_TransIEPInd | 15.7.3 | Number(1,0) | This is Yes if the student's IEP specified that transportation is required. Migrated from [Students.SC_TransIEPInd]. |