Early Care and Learning PK Extract (Legacy)

Introduction

The Early Care and Leaning report includes pre-kindergarten student information including name, socio-economic category, ethnicity, dual language learner indicator and waiver reason code.

Districts can generate the needed Pre-K roster extract file as needed, to be used by the Pre-K Director for uploading their students onto Roster 1 in the Bright From The Start (BFTS) Pre-K Roster System known as PANDA.

The output is submitted to the Bright From the Start -Department of Early Care and Learning.

Selection Criteria

The Early Care and Learning extract can be run for all active students or for a selection of students.

When run for all active students, the report will return students in Pre-Kindergarten grades who are active on the report run date who have a PANDAClassID entered.

When run for selected students, only Pre-Kindergarten students who have PANDA data entry completed should be included in the selection. Students without PANDAClassID will not be included in the report.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Current Selection Students	Run the report for the current selection of students or all students. Note: Only Pre-Kindergarten students who have PANDA data entry completed will be included in the report.
Report Run Date	Enter the report run date. This value is used to select active students on this date.
Print report headers	Select the Yes or No from the pop up menu. Note: The default is No. The report should not include headers when submitting to the state.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

ID	Data Element	Description	[Table]FieldName	Length
A	Site Id	The PANDA Id associated with the school.	[S_GA_SCH_X]PANDASiteID	4
B	Class Id	The PANDA Class Id associated with the student.	[S_GA_STU_PK_X]PANDAClassId [S_GA_REN_PK_X]PANDAClassId	5
C	Last Name	The student’s last name. Note: The legal last name field is extracted, if populated.	[StudentCoreFields]PSCore_Legal_Last_Name [Students]Last_Name
D	First Name	The student’s first name. Note: The legal first name field is extracted, if populated.	[StudentCoreFields]PSCore_Legal_First_Name [Students]First_Name
E	SSN	The student’s SSN. Note: Per state requirements, the SSN value is surrounded by single quotes. If the SSN starts with 99, the SSN will be blank and the Waiver Reason Code and Waiver Reason Detail field values are displayed in the report output.	[Students]SSN	9
F	Gender	The student’s gender. Note: The legal gender field is extracted, if populated.	[StudentCoreFields]PSCore_Legal_Gender [Students]Gender	1
G	Date of Birth	The student’s date of birth. Format: MM/DD/YYYY	[Students]DOB	10
H	Birth Order	The student’s birth indicator.	[S_GA_STU_PK_X]BirthOrder	1
I	Socio Economic Indicator	The students Socio Economic indicator. Valid values: 1 – Category 1 2 – Category 2	[S_GA_STU_PK_X]SocioEcIndicator	1
J	Transportation Indicator	Indicates whether transportation will be provided.	[S_GA_STU_PK_X]Transported	1
K	Ethnicity	The student’s ethnicity. The output is a string, including single quotes: ‘Not Hispanic/Latino’ ‘Hispanic/Latino’	[Students]FedEthnicity	1
L	Dual Language Learner	Indicates whether the student is a dual language learner.	[S_GA_STU_PK_X]DualLanguage	1
M	IEP	Indicates the student has an IEP.	[S_GA_STU_PK_X]IEP	1
N	Funding Source	The student’s funding source. Valid values: Lottery Blended	[S_GA_STU_PK_X]ProgramCode= ‘09’ then ‘Blended’ Otherwise default to ‘Lottery’	7
O	Begin Date in Class	The date the student began class, or August 1^st, whichever is later.	[CC]DateEnrolled	10
P	End Date	The date the student left class, or August 1^st, whichever is later. Blank when student has not left by report date.	[CC]DateLeft	10
Q	Middle Name	The student’s middle name. Defaults to ‘NMN’ when left blank. Note: The legal middle name field is extracted, if populated.	[StudentCoreFields]PSCore_Legal_Middle_Name [Students]Middle_Name
R	Suffix	The student’s name suffix.	[Students]GA_Legal_Suffix_Name
S	Waiver Reason Code	Indicates why the student’s SSN is blank. Valid values: 1 - I need help obtaining an SSN 2 - I need help replacing a lost SSN 3 - I am awaiting a replacement SSN and will provide when it arrives 4 - I forgot to bring the SSN and will provide within 30 days 5 - I choose not to provide the SSN because	[S_GA_STU_PK_X]WaiverReasonCode	1
T	Waiver Reason Detail	Provides information about why the student’s SSN is blank. Required when the waiver reason code is 5.	[S_GA_STU_PK_X]WaiverReasonDetail	200
U	American Indian/ Alaskan Native	Indicates whether the student is American Indian or Alaskan Native.	[StudentRace]RaceCd=I [StudentRace]StudentId	1
V	Asian	Indicates whether the student is Asian.	[StudentRace]RaceCd=S [StudentRace]StudentId	1
W	Black/African American	Indicates whether the student is Black/African American.	[StudentRace]RaceCd=B [StudentRace]StudentId	1
X	Native Hawaiian/ Other Pacific Islander	Indicates whether the student is Native Hawaiian/Other Pacific Islander.	[StudentRace]RaceCd=P [StudentRace]StudentId	1
Y	White	Indicates whether the student is White.	[StudentRace]RaceCd=W [StudentRace]StudentId	1
Z	GTID	The student’s GTID.	[Students]State_StudentNumber	10
AA	Parent/Guardian First Name	The first name of the student's parent/guardian	[Students]Guardian_Fn	30
AB	Parent.Guardian Last Name	The last name of the student's parent/guardian	[Students]Guardian_Ln	30
AC	Parent/Guardian Relationship	The relationship of the parent/guardian to the student	[Students]GuardianIsGrandParent	1

Back to Top