Skip to main content
Skip table of contents

S_IA_STU_EC_X (ver 17.2.0)

This table is an extension of the Students table, and holds Iowa-specific state reporting fields related to Early Childhood Education.

Column Name

Version

Data Type

Description

StudentsDCID

17.2.0

Number (10,0)

System generated primary key.

KG_Assessment_Instrument17.2.0Varchar2(2)The kindergarten assessment instrument. Migrated from [Students]IA_KG_AssessmentInstrument.
KG_Assessment_Score_1

17.2.0

Number(11,0)The first kindergarten assessment score. Migrated from [Students]IA_KG_AssessmentScore1.
KG_Assessment_Score_2

17.2.0

Number(11,0)The second kindergarten assessment score. Migrated from [Students]IA_KG_AssessmentScore2.
KG_Assessment_Score_3

17.2.0

Number(11,0)The third kindergarten assessment score. Migrated from [Students]IA_KG_AssessmentScore3.
PK_Funded_By_CDCC

17.2.0

Number(1,0)Indicates whether PK was funded by Shared Visions/CDCC. Migrated from [Students]IA_PKFundedByCDCC.
PK_Funded_By_EPWM

17.2.0

Number(1,0)Indicates whether PK was funded by Early Childhood Iowa (ECI)/EPWM. Migrated from [Students]IA_PKFundedByEPWM.
PK_Funded_By_HS

17.2.0

Number(1,0)Indicates whether PK was funded by Head Start. Migrated from [Students]IA_PKFundedByHS.
PK_Funded_By_Other

17.2.0

Number(1,0)Indicates whether PK was funded by other sources. Migrated from [Students]IA_PKFundedByOther.
PK_Funded_By_Parent

17.2.0

Number(1,0)Indicates whether PK was funded by the Parent. Migrated from [Students]IA_PKFundedByParent.
PK_Funded_By_SWVPP

17.2.0

Number(1,0)Indicates whether PK was funded by SWVPP. Migrated from [Students]IA_PKFundedBySWVPP
PK_Funded_By_Title_I

17.2.0

Number(1,0)Indicates whether PK was funded by Title I. Migrated from [Students]IA_PKFundedByTitleI.
PK_Attendance_Indicator

17.2.0

Varchar2(2)Indicates whether the student attended a preschool program, and if district-sponsored. Migrated from [Students]IA_PreschoolAttendIndicator.
PK_Program_1_Hours

17.2.0

DoubleThe number of hours the preschool student is attending Preschool Program 1. Migrated from [Students]IA_PreschoolProgramOneHours.
PK_Program_1_Session

17.2.0

Varchar2(20)The user-defined code for Preschool Session 1. Migrated from [Students]IA_PreschoolProgramOneSession.
PK_Program_1_Type

17.2.0

Varchar2(2)The program type for Preschool Program 1. Migrated from [Students]IA_PreschoolProgramOneType.
PK_Program_2_Hours

17.2.0

DoubleThe number of hours the preschool student is attending Preschool Program 2. Migrated from [Students]IA_PreschoolProgramTwoHours.
PK_Program_2_Session

17.2.0

Varchar2(20)The user-defined code for Preschool Session 2. Migrated from [Students]IA_PreschoolProgramTwoSession.
PK_Program_2_Type

17.2.0

Varchar2(2)The program type for Preschool Program 2. Migrated from [Students]IA_PreschoolProgramTwoType.
JavaScript errors detected

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

If this problem persists, please contact our support.