(FF, FG) Student Contact Record with Core PowerSchool Contacts

Introduction

The report will export a report which contains either the (FF) Student Contact Record and/or the (FG) Student Contact Address Record for OH EMIS reporting. Field values are extracted from Core PowerSchool Contacts.

Selection Criteria

Selection criteria determine which database records are used in the report. For the Student Contact (FF), student contact records are selected and if the Student Contact Address (FG) was also selected, corresponding contact address records will be selected based on the report parameters. If the user selects One Student Contact from the Contact to Include parameter, the report will return the first contact in the list of contacts for a student. If multiple addresses exist for a contact, the first address in the list is selected if the Address Type for the Contact Address to Include matches the first address in the list. For example, if an address type is listed as Mailing and the report parameter is set to include Physical, the address will not be included in the report results.

School Selection

The report selects which school records to use based on the following criteria:

The school must be associated with a student included in the report.

Student Selection

The report selects which student contact records to use based on the following criteria:

The student must be enrolled during the enrollment period selected for the report: Student (S) reporting.
The student is not excluded from state reporting (State/Province - OH > Home > State_ExcludeFromReporting or for a previous fiscal year S_OH_STU_SNAP_C.State_ExcludeFromReporting).
The student must have at least one associated contact record in Core PowerSchool Contacts.

Report Input

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

The report input is done for each student in Contact Management. See more information on Entering Ohio Student Contacts.

Field		Description
Record Type*		Choose the record type(s) to include in the report.
Date Source		Choose the data source for the report.
Schools for which to run?*		If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Report Start Date*		Enter the start date for scanning school enrollments. Format: [M]M/[D]D/[YY]YY
Report End Date*		Enter the end date for scanning school enrollments. Format: [M]M/[D]D/[YY]YY
Current Selection Students*		Indicate which students to include in the report by selecting one of the following options: The Selected [number] Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Reporting Period*		Select the reporting period for which you are creating the extract.
Fiscal Year*		Enter the fiscal year for the report.
Contact to Include*		Select all student contacts or one student contact. If one student contact is to be included, the contact at the top of the list will be pulled for the FF/FG unless the Primary Contact is marked on a subsequent line.
Contact Address to Include*		Select the addressee type(s) to include in the report. If multiple addresses are listed for the contact, the first address in the list is selected. If Physical is checked, the corresponding Home address from Core PowerSchool Contacts will be included. If Mailing is checked, the corresponding Mailing address from Core PowerSchool Contacts will be included. If Other is checked, the address from Core PowerSchool Contacts with a blank Address Type will be included.
Scheduling
Run Now		Select this option to execute the report in the order it is received in the report queue.
Schedule (available Version 7.1.1.)		Enter the start date and start time for the report. Select Run Once and Submit to run the report at the specified date and time. Select Repeat to set future dates (Daily, Weekly, Monthly, Yearly) and Submit.

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.

Note: For documentation of XML report output from the state department of education, refer to http://www.ode.state.oh.us.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length	Begin/ End Position
FF
N/A	Filler	Filler	N/A	Numeric	8	1–8
FF010	Sort Type	The sort type equals FF for the Student Contact Record Report.	N/A	Alpha-numeric	2	9–10
N/A	Filler	Filler	N/A	Alpha-numeric	1	11
FF020	Fiscal Year	The fiscal year is set by report input.	N/A	Alpha-numeric	4	12–15
FF030	Data Set	The reporting period is set by report input.	N/A	Alpha-numeric	1	16
FF040	LEA IRN	This field contains the district number. This field value is extracted from the Edit District page, Start Page > District Setup > District Information.	[Prefs]DistrictNumber CST_SUBDISTRICTS.Subdistrict_number	Alpha-numeric	6	17–22
FF050	EMIS Student ID Number	This field contains the EMIS student ID number assigned by the district to this student. This field value is extracted from the Student Number field on the Student Profile > Demographics page, and prepended with the EMIS Prefix ID, if entered, else zeroes are added to create a 9-digit number.	[Students]Student_Number	Alpha-numeric	9	23–31
FF060	Contact Sequence Order Number	This field contains the call sequence number for the contact. The person listed first in the sort order on the page is considered call sequence 01.	[StudentContactAssoc]ContactPriorityOrder			32-33
FF070	Contact Relationship Code	This field contains the value defining the student/contact relationship.	[Codeset]ReportedValue	Numeric	8	34-37
FF080	Legal Guardianship Flag	This field contains the value defining the student contact relationship regarding legal guardianship.	[StudentContactDetailCoreFields]IsCareGiver	Alpha-numeric	1	38
FF090	Custodial Flag	This field contains the value defining the student/ contact relationship regarding custody.	[StudentContactDetailCoreFields]IsCustodial	Alpha-numeric	1	39
FF100	First Name	This field contains the contact’s first name prefix.	[Codeset]Code	Alpha-numeric	23	40–45
FF110	Prefix Name	This field contains the contact’s name prefix.	[Codeset]Code	Alpha-numeric	3	46-90
FF120	Middle Name	This field contains the contact’s middle name.	[Person]MiddleName	Alpha-numeric	18	91-120
FF130	Last Name	This field contains the contact’s last name.	[Person]LastName	Alpha-numeric	30	121-165
FF140	Suffix Name	This field contains the contact’s name suffix.	[Codeset]Code	Alpha-numeric	30	166-171
FF150	Telephone Number	This field contains the contact’s telephone number.	[PhoneNumber]PhoneNumber	Alpha-numeric	30	172-191
FF160	Telephone Extension	This field contains the contact’s telephone number extension.	[PhoneNumber]PhoneNumberExt	Alpha-numeric	30	192-197
FF170	Email Address	This field contains the contact’s email address.	[EmailAddress]EmailAddress	Alpha-numeric	33	198-257
FF180	Type of Email Address	This field contains the email address type.	[Codeset]ReportedValue	Alpha-numeric	3	258-259
FF190	Type of Telephone Number	This field contains the telephone number type..	Defaults to blank.	Alpha-numeric	1	260-261
FG
N/A	Filler	Filler	N/A	Numeric	8	1–8
FG010	Sort Type	The sort type equals FF for the Student Contact Record Report.	N/A	Alpha-numeric	2	9–10
N/A	Filler	Filler	N/A	Alpha-numeric	1	11
FG020	Fiscal Year	The fiscal year is set by report input.	N/A	Alpha-numeric	4	12–15
FG030	Reporting Period	The reporting period is set by report input.	N/A	Alpha-numeric	1	16
FG040	LEA IRN	This field contains the district number. This field value is extracted from the Edit District page, Start Page > District Setup > District Information.	[Prefs]DistrictNumber CST_SUBDISTRICTS.Subdistrict_number	Alpha-numeric	6	17–22
FG050	EMIS Student ID Number	This field contains the EMIS student ID number assigned by the district to this student. This field value is extracted from the Student Number field on the Student Profile > Demographics page, and prepended with the EMIS Prefix ID, if entered, else zeroes are added to create a 9-digit number.	[Students]Student_Number	Alpha-numeric	9	23–31
FG060	Contact Sequence Order Number	This field contains the call sequence number for the contact. The person listed first in the sort order on the page is considered call sequence 01.	[StudentContactAssoc]ContactPriorityOrder	Numeric	2	32-33
FG070	Address Type	This field contains the value defining the student/contact relationship. Home is reported as Physical. Mailing is reported as Mailing. Blank is reported as Other.	[Codeset]Code	Alpha-numeric	4	34-37
FG080	Address Line 1	This field contains the contact’s street address.	[PersonAddress]Street	Alpha-numeric	60	38-97
FG090	Address Line 2	This field contains the contact’s address line 2.	[PersonAddress]LineTwo	Alpha-numeric	60	98-157
FG100	City	This field contains the contact’s address city.	[PersonAddress]City	Alpha-numeric	30	158-187
FG110	County Code	This field contains the contact’s address county code.	[Codeset]ReportedValue	Alpha-numeric	2	188-189
FG120	State Province Code	This field contains the contact’s address state code.	[Codeset]Code	Alpha-numeric	2	190-191
FG130	Postal Code	This field contains the contact’s address zip code.	[PersonAddress]PostalCode	Alpha-numeric	11	192-202
FG140	Country Code	This field contains the contact’s address country code.	[Codeset]Code	Alpha-numeric	2	203-204
FG150	Effective Start Date	This field contains the contact’s address effective start date.	[PersonAddressAssoc]StartDate	Numeric	8	205-212