Skip to main content
Skip table of contents

S_PA_STU_X (ver 14.9.0)

This table is an extension of the [Students] table.

Column Name

Version

Data Type

Description

StudentsDCID14.9.0Number (10,0)Foreign Key to the Students 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 - for Student Template Report

CTE_Indicator

14.9.0

Varchar2(1)

Field 190 CTE Indicator - for Student Template Report

EnrollmentDistrictCode

14.9.0

Varchar2(10)

Field 217 District of Enrollment Code - for Student Template Report

Pregnancy_Indicator14.11.0Varchar2(1)Field 121. Student is Pregnant (Used for EWS)
Neglected_Indicator14.11.0Varchar2(1)Field 124. Neglected or delinquent (Used for EWS)
Military_Family_Indicator14.11.0Varchar2(1)Field 207. Military Family Code (Used for EWS)
Refugee_Status_Code14.11.0Varchar2(1)Field 208. Asylee or refugee status code (Used for EWS)
Foster_Care_Indicator14.11.0Varchar2(1)Field 209. Foster Care (Used for EWS)
Residence_Status_Code14.11.0Varchar2(2)Residence Status Code (EWS Data)
School_Choice_Indicator14.11.0Varchar2(1)School Choice Transfer Indicator (Used for EWS)
Middle_Name_Long15.3.0Varchar2(60)Field 142. Middle Name Long
Exclude_from_EWS15.6.2Number(1,0)Exclude Student from EWS reports
Summer_Withdrawal_YN15.9.0Varchar2(1)Summer Withdrawal Flag (Y/N) (Used for PIMS School Enrollment Template).
Homebound_Inst15.10.3Number(11,0)

The total number of instructional minutes received for homebound instruction for the school year.

IU_Number16.3.2Varchar2(10)Use as an override when a students IU is different then the IU number set on the Schools/School Info page.
IS_504_YN16.10.1Varchar2(1)Is 504 Flag (Y/N). Migrated from: [Students.PA_504].
IEP_Not_Gifted_YN16.10.1Varchar2(1)IEP Not Gifted Flag (Y/N). Migrated from: [Students.PA_IEP].
IS_SPED_Student_YN16.10.1Varchar2(1)Is SPED Student Flag (Y/N). Migrated from:[Students.PA_SpecialEd].
State_ExcludeEnrollment16.10.1Varchar2(1)Exclude Enrollment Flag (Y/N). Migrated from: [Students.state_excludeenrollment].
Special_Education_IEP_Code16.10.1Varchar2(3)Special Education IEP Code. Migrated from: [Students.PA_Special_Ed].
Challenge_Type_Code16.10.1Varchar2(6)Challenge Type Code. Migrated from :[Students.PA_Challenge_Type].
Charter_School_Code17.2.0Varchar2(9)Migrated from [Students]PA_Charter_School.
Charter_School_Location_Code17.2.0Varchar2(4)Migrated from [Students]PA_Charter_School_Loc .
ELL_TF17.2.0Number(1,0)Migrated from [Students]PA_ELL.
EconomicDisadvantage_TF17.2.0Number(1,0)Migrated from [Students]PA_EconDisadv.
EducationSetting_Code17.2.0Varchar2(1)Migrated from [Students]PA_EducSetting.
Funding_District_Code17.2.0Varchar2(9)Migrated from [Students]PA_Fund_Dis.
Gifted_TF17.2.0Number(1,0)Migrated from [Students]PA_Gifted .
Graduation_Status_Code17.2.0Varchar2(1)Migrated from [Students]PA_Grad_Stat .
State_Grade_Code17.2.0Varchar2(3)Migrated from [Students]PA_GradeCode .
HSTW_TF17.2.0Number(1,0)Migrated from [Students]PA_HSTW.
PIMS_Homeless_Code17.2.0Varchar2(1)Migrated from [Students]PA_Hless.
Homeless_TF17.2.0Number(1,0)Migrated from [Students]PA_Homeless.
PIMS_Location_Residence_Code17.2.0Varchar2(4)Migrated from [Students]PA_Loc_Res.
Migrant_TF17.2.0Number(1,0)Migrated from [Students]PA_Migrant.
PIMS_Migrant_Status_Code17.2.0Varchar2(1)Migrated from [Students]PA_PIMS_Migrant.
PIMS_Residence_Status_Code17.2.0Varchar2(1)Migrated from [Students]PA_PIMS_ResidenceCode.
Calendar_ID19.5.1.0Number(11,0)Migrated from [Students]PA_StuCalendar ,Modified the data type from varchar2 to integer
Title1_TF17.2.0Number(1,0)Migrated from [Students]PA_Title1..
Calendar_Enrolled_Time_Percent17.2.0Number(11,0)Migrated from [Students]PA_stu_FTE .
Food_Participation_Code17.4.0Varchar2(1)Migrated from [Students]PA_Partic_Program
Legal_Name_Suffix17.4.0Varchar2(20)Migrated from [Students]Name_Suffix.
Immigrant_TF17.4.0Number(1,0)Migrated from [Students]PA_Imm_Ind.
LEP_ELL_Status_Code17.4.0Varchar2(2)Migrated from [Students]PA_LEP_Part..
Repeating_Last_Year_TF17.4.0Number(1,0)Migrated from [Students]PA_Repeat_LY.
Expected_Graduation_Timeframe17.4.0Varchar2(4)Migrated from [Students]PA_Expected_Grad_Time.
Student_Status_Code17.4.0Varchar2(1)Migrated from [Students]PA_Stu_Status.
ESL_Bilingual_Education_Date17.4.0DateMigrated from [Students]PA_Biling_Date.
Foreign_Exchange_Student_TF17.4.0Number(1,0)Migrated from [Students]PA_Foreign_Exch.
Gifted_And_Talented_TF17.4.0Number(1,0)Migrated from [Students]PA_No_GIEP.
Diploma_Type_Code17.4.0Varchar2(3)Migrated from [Students]PA_Dip_Type.
LEP_Eligibility_YN17.4.0Varchar2(1)Migrated from [Students]PA_LEP_Eligibility.
Grade9_Entry_Date17.4.0DateMigrated from: [Students]PA_Grade_Entry.
State_Entry_Date17.4.0DateMigrated from [Students]PA_State_Entry.
First_Enroll_US_School_Date17.4.0DateMigrated from [Students]PA_Initial_US_Entry.
Single_Parent_TF17.4.0Number(1,0)Migrated from [Students]PA_Sing_Parent.
Home_Language_Code17.4.0Varchar2(10)Migrated from [Students]PA_Home_Lang_Code.
Years_In_US_Schools_Code17.4.0Varchar2(1)Migrated from [Students]PA_Years_US_Schools.
Last_Name_Long17.4.0Varchar2(60)Migrated from [Students]PA_Last_Long.
First_Name_Long17.4.0Varchar2(60)Migrated from: [Students]PA_First_Long
Address_317.4.0Varchar2(40)Migrated from [Students]PA_Address_3.
Displaced_Homemaker_TF17.4.0Number(1,0)Migrated from [Students]PA_Dis_Homemaker.
Home_Address_State_County_Code17.4.0Varchar2(2)Migrated from [Students]PA_Home_Add_State.
Language_Breakdown17.4.0Varchar2(4)Migrated from [Students]PA_Race_Ethn.
Educationally_Disadvantaged_TF17.4.0Number(1,0)Migrated from [Students]PA_Edu_Dis.
English_Proficiency_Code17.4.0Varchar2(4)Migrated from [Students]PA_Eng_Prof.
Birth_Country_Code17.4.0Varchar2(4)Migrated from: [Students]PA_Country_Birth.
Birth_Date_Verify_Code17.4.0Varchar2(4)Migrated from: [Students]PA_Birth_Date_Ver.
Birth_City17.4.0Varchar2(30)Migrated from: [Students]PA_CoB.
Birth_State_Code17.4.0Varchar2(2)Migrated from: [Students]PA_SoB.
Assessment_Participation_Code17.4.0Varchar2(1)Migrated from [Students]PA_Assessment_Participation.
Address_217.4.0Varchar2(40)Migrated from [Students]PA_Address_2.
Guardian_Relationship_Code17.4.0Varchar2(1)Migrated from [Students]PA_Guard_Relation.
Post_Secondary_Plans_Code17.4.0Varchar2(3)Migrated from [Students]PA_PostSecondaryPlans.
Post_Dropout_Activity_Code17.4.0Varchar2(1)Migrated from [Students]PA_PostDropoutActivity.
Dropout_Reason_Code17.4.0Varchar2(2)Migrated from [Students]PA_DropoutReason.
Enrollment_Program_Code17.4.0Varchar2(1)Migrated from [Students]PA_EnrollmentProgram.
AVTSProgram_TF17.5.0Number(1,0)Migrated from [Students]PA_AVTSProgram.
IUInclusion_TF17.5.0Number(1,0)Migrated from [Students]PA_IUInclusion.
Benchmarks_Indicator17.12Varchar2(1)Data entry field at the student level to record the Benchmark Indicator value of Y or N.
Student_Mobility

18.9.0

Varchar2(1)Data entry field to record the Student Mobility value.
Gifted_IEP_Field80_Code19.9.2.0Varchar2(2)Data entry field to record the Gifted and IEP value.
Access_ELLS_Assessment19.9.2.0Varchar2(20)Data entry field to record Access ELLS Assessment value
ELAAssessment_Exempt_Ind19.9.2.0Varchar2(1)Data entry field to record ELA Assessment Exempt Indicator value
Building_Override20.11.2.0Number(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.
KeystoneComment_ALG21.2.2.0Varchar2(6)Data entry field to record comment for Algebra KeySubTestIdentifier
KeystoneComment_BIO21.2.2.0Varchar2(6)Data entry field to record comment for Biology KeySubTestIdentifier
KeystoneComment_LIT21.2.2.0Varchar2(6)Data entry field to record comment for Literature KeySubTestIdentifier




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close