S_PA_SEN_SPED_X (ver 15.3.0)
This table is an extension table the Spenrollments table containing information specifically about Title 1 programs.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| Category_Set_Code | 15.3.0 | Varchar2(20) | Field 5. Category Set Code. |
| Program_Intensity | 16.10.1 | Number(11,0) | Program Intensity. Migrated from [Spenrollments.PA_Prog_Intensity]. |
| Service_Provider | 17.2.0 | Varchar2(100) | Service Provider. Migrated from [Spenrollments.PA_Serv_Prov]. |
| EDU_Environment_Percent | 16.10.1 | Number(11,0) | Educational Environment Percent. Migrated from [Spenrollments.PA_Edu_Envir_Per]. |
| PASA_YN | 16.10.1 | Varchar2(1) | PASA Flag (Y/N). Migrated from [Spenrollments.PA_PASA]. |
| Include_State_Report_YN | 16.10.1 | Varchar2(1) | Include State Report Flag (Y/N). Migrated from [Spenrollments.PA_Include_State_Report]. |
| Educational_Environment_Code | 16.10.1 | Varchar2(4) | Educational Environment Code. Migrated from [Spenrollments.PA_LRE_Cat]. |
| Reason_Exited_SPED_Code | 16.10.1 | Varchar2(4) | Reason Exited SPED Code. Migrated from [Spenrollments.PA_Reas_Exit]. |
| Secondary_Disability_Code | 16.10.1 | Varchar2(4) | Secondary Disability Code. Migrated from [Spenrollments.PA_Chall_Type]. |
| Amount_SPED_Services_Code | 16.10.1 | Varchar2(6) | Amount SPED Services Code. Migrated from [Spenrollments.PA_Amount_Sp_Ser]. |
| Type_Support_Code | 16.10.1 | Varchar2(6) | Type Support Code. Migrated from [Spenrollments.PA_Type_Support]. |
| Location_SPED_Services | 17.2.0 | Varchar2(100) | Location SPED Services. Migrated from [Spenrollments.PA_Receiv_Schl_Cd]. |
| Residency_Code | 16.10.1 | Varchar2(20) | Residency Code. Migrated from[Spenrollments.PA_Residency]. |
| SPED_Teacher_Name | 16.10.1 | Varchar2(30) | SPED Teacher Name. Migrated from [Spenrollments.PA_Spec_Ed_Teach]. |
| Related_Services | 16.10.1 | Varchar2(50) | Related Services. Migrated from [Spenrollments.PA_Relat_Serv]. |
| Services_Fact_Prov | 16.10.1 | Varchar2(100) | Services Fact Prov. Migrated from [Spenrollments.PA_Services_Fact_Prov]. |
| SPED_Exit_Date | 16.10.1 | Date | SPED Exit Date. Migrated from [Spenrollments.PA_Date_Exited_SpEd]. |
| Service_Start_Date | 16.10.1 | Date | Service Start Date. Migrated from [Spenrollments.PA_Service_Start_Date]. |
| TransIEP_status_code | 17.2.0 | Varchar2(1) | Field 45. Transition IEP Status Code. |
| TransIEP_paid_wrkbased_lrning | 17.2.0 | Varchar2(1) | Field 73. Transition IEP Paid Work-based Learning. |
| TransIEP_job_support_coaching | 17.2.0 | Varchar2(1) | Field 74. Transition IEP Job Supports/Coaching. |
| TransIEP_careerdev_jobexplor | 17.2.0 | Varchar2(1) | Field 75. Transition IEP Career Dev/Job Exploration. |
| TransIEP_modified_for_services | 17.2.0 | Varchar2(1) | Field 76. Transition IEP Modified for Services. |
| Primary_Placement_Type_YN | 17.10.0 | Varchar2(1) | Field 32. Primary Placement Type. |