S_PA_REN_X (ver 14.9.0)
This table is an extension of the [ReEnrollments] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ReEnrollmentsDCID | 14.9.0 | Number(10,0) | Foreign Key to the ReEnrollments table. |
PIMS_EntryCode | 14.9.0 | Varchar2(6) | Entry Code - Used for School Enrollment Report. |
PIMS_ExitCode | 14.9.0 | Varchar2(6) | Exit Code - Used for School Enrollment Report. |
SpecialEdReferral | 14.9.0 | Varchar2(1) | Field 167 Special Education Referral - Used for Student Template Report. |
CTE_Indicator | 14.9.0 | Varchar2(1) | Field 190 CTE Indicator - Used for PIMS Student Template Report. |
EnrollmentDistrictCode | 14.9.0 | Varchar2(10) | Field 217 District of Enrollment Code - Used for Student Template Report. |
| Pregnancy_Indicator | 14.11.0 | Varchar2(1) | Field 121 Student is Pregnant (Used for EWS). |
| Neglected_Indicator | 14.11.0 | Varchar2(1) | Field 124. Neglected or delinquent (Used for EWS). |
| Military_Family_Indicator | 14.11.0 | Varchar2(1) | Field 207. Military Family Code (Used for EWS). |
| Refugee_Status_Code | 14.11.0 | Varchar2(1) | Field 208. Asylee or refugee status code (Used for EWS). |
| Foster_Care_Indicator | 14.11.0 | Varchar2(1) | Field 209. Foster Care (Used for EWS). |
| Residence_Status_Code | 14.11.0 | Varchar2(2) | Residence Status Code (Used EWS). |
| School_Choice_Indicator | 14.11.0 | Varchar2(1) | School Choice Transfer Indicator (Used for EWS). |
| Summer_Withdrawal_YN | 15.9.0 | Varchar2(1) | Summer Withdrawal Flag (Y/N) (Used for PIMS School Enrollment Template). |
| Homebound_Inst | 15.10.3 | Number(11,0) | The total number of instructional minutes received for Homebound Instruction for the school year. Note: Field is not displayed on the Edit Previous Enrollment Student Page. |
| IU_Number | 16.3.2 | Varchar2(10) | Use as an override when a students IU is different then the IU number set on the Schools/School Info page. |
| IS_504_YN | 16.10.1 | Varchar2(1) | Is 504 Flag (Y/N). Migrated from [Reenrollments.PA_504]. |
| IEP_Not_Gifted_YN | 16.10.1 | Varchar2(1) | IEP Not Gifted Flag (Y/N). Migrated from [Reenrollments.PA_IEP]. |
| IS_SPED_Student_YN | 16.10.1 | Varchar2(1) | Is SPED Student Flag (Y/N). Migrated from [Reenrollments.PA_SpecialEd]. |
| State_ExcludeEnrollment | 16.10.1 | Varchar2(1) | Exclude Enrollment Flag (Y/N). Migrated from [Reenrollments .state_excludeenrollment]. |
| Special_Education_IEP_Code | 16.10.1 | Varchar2(3) | Special Education IEP Code. Migrated from [Reenrollments .PA_Special_Ed]. |
| Challenge_Type_Code | 16.10.1 | Varchar2(6) | Challenge Type Code. Migrated from [Reenrollments .PA_Challenge_Type]. |
| Charter_School_Code | 17.2.0 | Varchar2(9) | Migrated from [Reenrollments ]PA_Charter_School. |
| Charter_School_Location_Code | 17.2.0 | Varchar2(4) | Migrated from [Reenrollments ]PA_Charter_School_Loc. |
| ELL_TF | 17.2.0 | Number(1,0) | Migrated from: [Reenrollments ]PA_ELL. |
| EconomicDisadvantage_TF | 17.2.0 | Number(1,0) | Migrated from: [Reenrollments ]PA_EconDisadv. |
| EducationSetting_Code | 17.2.0 | Varchar2(1) | Migrated from: [Reenrollments ]PA_EducSetting. |
| Funding_District_Code | 17.2.0 | Varchar2(9) | Migrated from: [Reenrollments ]PA_Fund_Dis. |
| Gifted_TF | 17.2.0 | Number(1,0) | Migrated from: [Reenrollments ]PA_Gifted. |
| Graduation_Status_Code | 17.2.0 | Varchar2(1) | Migrated from: [Reenrollments ]PA_Grad_Stat. |
| State_Grade_Code | 17.2.0 | Varchar2(3) | Migrated from: [Reenrollments ]PA_GradeCode. |
| HSTW_TF | 17.2.0 | Number(1,0) | Migrated from: [Reenrollments ]PA_HSTW. |
| PIMS_Homeless_Code | 17.2.0 | Varchar2(1) | Migrated from: [Reenrollments ]PA_Hless. |
| Homeless_TF | 17.2.0 | Number(1,0) | Migrated from: [Reenrollments ]PA_Homeless. |
| PIMS_Location_Residence_Code | 17.2.0 | Varchar2(4) | Migrated from: [Reenrollments ]PA_Loc_Res. |
| Migrant_TF | 17.2.0 | Number(1,0) | Migrated from: [Reenrollments ]PA_Migrant. |
| PIMS_Migrant_Status_Code | 17.2.0 | Varchar2(1) | Migrated from: [Reenrollments ]PA_PIMS_Migrant. |
| PIMS_Residence_Status_Code | 17.2.0 | Varchar2(1) | Migrated from: [Reenrollments ]PA_PIMS_ResidenceCode. |
| Calendar_ID | 19.5.1.0 | Number(11,0) | Migrated from: [Reenrollments ]PA_StuCalendar. , Modified the data type from varchar2 to integer |
| Title1_TF | 17.2.0 | Number(1,0) | Migrated from: [Reenrollments ]PA_Title1. |
| Calendar_Enrolled_Time_Percent | 17.2.0 | Number(11,0) | Migrated from: [Reenrollments ]PA_stu_FTE. |
| AVTSProgram_TF | 17.5.0 | Number(1,0) | Migrated from: [Reenrollments ]PA_AVTSProgram. |
| IUInclusion_TF | 17.5.0 | Number(1,0) | Migrated from: [Reenrollments ]PA_IUInclusion. |
| Before_After_School_Funding | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_befaft_sch_prog_funding. |
| Clothing_Funding | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_clothing_funding. |
| Birth_City | 17.5.0 | Varchar2(30) | Migrated from: [Reenrollments ]PA_CoB. |
| Coord_school_agency_Funding | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_coord_sch_ag_funding. |
| Counseling_Funding | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_counseling_funding. |
| Birth_Country_Code | 17.5.0 | Varchar2(4) | Migrated from: [Reenrollments ]PA_Country_Birth. |
| Identification_Date | 17.5.0 | Date | Migrated from: [Reenrollments ]PA_Date_of_Id. |
| School_Enrollment_Date | 17.5.0 | Date | Migrated from: [Reenrollments ]PA_Date_of_SchEnr. |
| Diploma_Type_Code | 17.5.0 | Varchar2(3) | Migrated from: [Reenrollments ]PA_Dip_Type. |
| Direct_Supplemental_Services | 17.5.0 | Varchar2(7) | Migrated from: [Reenrollments ]PA_dir_supp_serv. |
| Domestic_Violence_Funding | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_domest_vio_funding. |
| Early_Childhood_Programs | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_early_child_funding. |
| Educationally_Disadvantaged_TF | 17.5.0 | Number(1,0) | Migrated from: [Reenrollments ]PA_Edu_Dis. |
| Eligibility_Homeless_Services | 17.5.0 | Varchar2(3) | Migrated from: [Reenrollments ]PA_Elig_homeless_services. |
| Emergency_Assist_Attn_Funding | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_emer_asst_attn_funding. |
| English_Proficiency_Code | 17.5.0 | Varchar2(4) | Migrated from: [Reenrollments ]PA_Eng_Prof. |
| Expedited_Evaluations_Funding | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_exp_eval_funding. |
| Expected_Graduation_Timeframe | 17.5.0 | Varchar2(4) | Migrated from: [Reenrollments ]PA_Expected_Grad_Time. |
| Guardian_Relationship_Code | 17.5.0 | Varchar2(1) | Migrated from: [Reenrollments ]PA_Guard_Relation. |
| Immunizations | 17.5.0 | Varchar2(3) | Migrated from: [Reenrollments ]PA_Immunizations. |
| LEA_Current_Enrollment | 17.5.0 | Varchar2(80) | Migrated from: [Reenrollments ]PA_LEA_Of_CurEnr. |
| LEA_Origin | 17.5.0 | Varchar2(80) | Migrated from: [Reenrollments ]PA_LEA_Of_Origin. |
| LEP_Eligibility_YN | 17.5.0 | Varchar2(1) | Migrated from: [Reenrollments ]PA_LEP_Eligibility. |
| LEP_ELL_Status_Code | 17.5.0 | Varchar2(2) | Migrated from: [Reenrollments ]PA_LEP_Part. |
| Med_Dental_Health_Ser_Referral | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_med_refer_funding. |
| Identification_Method | 17.5.0 | Varchar2(25) | Migrated from: [Reenrollments ]PA_Meth_of_Id . |
| Obtaining_Record_Funding | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_obt_records_funding. |
| Other_Barriers | 17.5.0 | Varchar2(3) | Migrated from: [Reenrollments ]PA_Oth_Barriers. |
| Other_Medical_Records | 17.5.0 | Varchar2(3) | Migrated from: [Reenrollments ]PA_Oth_Med_Records. |
| Other_Service_Description | 17.5.0 | Varchar2(50) | Migrated from: [Reenrollments ]PA_oth_serv_desc. |
| Other_Services_Funding | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_oth_serv_funding. |
| Food_Participation_Code | 17.5.0 | Varchar2(1) | Migrated from: [Reenrollments ]PA_Partic_Program. |
| Precipitating_Event | 17.5.0 | Varchar2(40) | Migrated from: [Reenrollments ]PA_Prec_Event. |
| Prog_Services_Referral_Funding | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_ref_oth_progser_funding. |
| Repeating_Last_Year_TF | 17.5.0 | Number(1,0) | Migrated from: [Reenrollments ]PA_Repeat_LY. |
| School_Program_Part_Assist | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_sch_prog_funding. |
| School_Supplies_Funding | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_sch_supples_funding. |
| School_Current_Enrollment | 17.5.0 | Varchar2(80) | Migrated from: [Reenrollments ]PA_School_Of_CurEnr. |
| School_Records | 17.5.0 | Varchar2(3) | Migrated from: [Reenrollments ]PA_School_Records. |
| School_Selection | 17.5.0 | Varchar2(3) | Migrated from: [Reenrollments ]PA_School_selection. |
| Student_Status_Code | 17.5.0 | Varchar2(1) | Migrated from: [Reenrollments ]PA_Stu_Status. |
| Transportation | 17.5.0 | Varchar2(3) | Migrated from: [Reenrollments ]PA_Transportation. |
| Transportation_Funding | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_transportation_funding. |
| Tutor_Funding | 17.5.0 | Varchar2(10) | Migrated from: [Reenrollments ]PA_tutor_funding. |
| Unaccompanied_Youth | 17.5.0 | Varchar2(25) | Migrated from: [Reenrollments ]PA_Unaccompanied_Youth. |
| State_ExcludeFromReporting | 17.9.0 | Number(1) | State Exclude From Reporting Flag |
| Benchmarks_Indicator | 17.12 | Varchar2(1) | Data entry field at the student level to record the Benchmark Indicator value of Y or N. |
| LIEP_Type | 18.1.0 | Varchar2(2) | Field for showing LIEP Type in previous enrollment. |
| Student_Mobility | 18.9.0 | Varchar2(1) | Data entry field to record the Student Mobility value |
| Gifted_IEP_Field80_Code | 19.9.2.0 | Varchar2(2) | Data entry field to record the Gifted and IEP value. |
| Building_Override | 20.11.2.0 | Number(1) | A new field to identify a student's school building is located on the Current Enrollment and Previous Enrollment pages in the General State Reporting section. |