Student Contact Report

Contents

Introduction

Use the Student Contact report to collect address/email/phone information for students and their primary and secondary contacts.

Selection Criteria

Selection criteria determine which database records are used in the report.

School Selection

The report selects which school records to use based on the following criteria:
The school is not excluded from state reporting.
The school must be associated with a student included in the report.

Student Selection

Student is not excluded from State reporting.

Required Data Setup

You must define the following information before generating this extract.

Exclude students from this report by selecting Yes for Exclude from State Reporting on the General tab of the state/province-RI page (if applicable).
Complete Student Contact Extract Fields page for primary and secondary contacts, Start Page > District Setup > Student Contact Extract Fields.
If using Unlimited Contacts the Primary and Secondary contact must have the following:
- Custody flag
- Using the ‘Relationship’ Code Set, the Reported Value field must be updated with an acceptable RIDE Item Value for PC_STUDENT_RELATION and SC_STUDENT_RELATION which can be found here: https://www.eride.ri.gov/doc/DataCollections/StudentContactCollection.pdf
- The Primary Contact will be the contact with the lowest sort order. The Secondary Contact will be the contact with the second lowest sort order.

Back to Top

Report Input

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

Field	Description
Submit	Click the submit button
Scheduling Options	Description
Scheduling – Run Now	Leave Run Now selected to run the report now.
Submit	Click Submit to run the report now.
Scheduling – Please Select When to run	Click the Schedule button to schedule this report to run.
Please Select Schedule Settings	Enter the Start Date and Start time. Click the Repeat button.
Please select repeat cycle options.	Choose the applicable option.
Please select end date range option	Enter the appropriate information.
Submit	Click Submit to schedule the report

Districts using the Automated Data Transfer (ADT) system may utilize the SQL script for state reporting purposes provided at the bottom of the report page.

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.

Column	Data Element	Description	[Table]FieldName	Field Type	Field Length
A	DISTCODE	The district code assigned to the school district reporting the student information as noted on District Setup page, Start Page > District Setup > District Information.	[Schools]District_Number	Text	2
B	SCHCODE	The five-digit RIDE ID for the school that the student attends as noted on the Edit School page, Start Page > District Setup > Schools/School Info > Edit School.	[S_RI_SCH_X]Ride_ID	Text	5
C	SASID	The student's state identification code as noted on Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information.	[Students]State_StudentNumber	Text	10
D	LASID	The student's local school identification code as noted on Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information.	[Students]Student_Number	Text	16
E	LASTNAME	The last name of the student as noted on the General Demographics page, Start Page > Student Selection > General Demographics, or if the legal last name is populated on the Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information.	[Students]Last_Name OR [StudentCoreFields]PSCore_Legal_Last_Name	Text	50
F	ADDRESS_M_L1	The field contains the student mailing address.	[Students]Mailing_Street	Text	50
G	ADDRESS_M_L2	The field contains the student mailing address line 2.	Blank - non-PowerSchool field	Text	50
H	ADDRESS_M_CITY	The field contains the student mailing city/town.	[Students]Mailing_City	Text	50
I	ADDRESS_M_STATE	The field contains the student mailing state.	[Students]Mailing_State	Text	2
J	ADDRESS_M_ZIP	The field contains the student mailing zip.	[Students]Mailing_Zip	Text	5
K	ADDRESS_M_ZIP4	The field contains the student mailing last 4 digits of the zip code.	[Students]Mailing_Zip	Text	4
L	ADDRESS_D_L1	The field contains the student home address.	[Students]Street	Text	50
M	ADDRESS_D_L2	The field contains the student home address line 2.	Blank - non-PowerSchool field	Text	50
N	ADDRESS_D_CITY	The field contains the student home address city/town.	[Students]City	Text	50
O	ADDRESS_D_STATE	The field contains the student home address state.	[Students]State	Text	2
P	ADDRESS_D_ZIP	The field contains the student home address zip code.	[Students]zip	Text	5
Q	ADDRESS_D_ZIP4	This field contains the last four digits from the student home zip code.	[Students]zip	Text	4
R	PHONE_HOME_ST	This field contains the home phone number for the student.	[Students]Home_Phone	Text	15
S	PHONE_EMG	This field contains the emergency phone number for the student.	[Students]Emerg_Phone_1	Text	15
T	PC_FIRSTNAME If using Unlimited Contacts see Required Setup	This field contains the first name of the primary contact.	See Student Contact Extract Fields page If using Unlimited Contacts see Required Setup	Text	50
U	PC_LASTNAME	This field contains the first name of the primary contact.	See Student Contact Extract Fields page	Text	50
V	PC_STUDENT_RELATION	This field contains the relationship to the student of the primary contact.	See Student Contact Extract Fields page	Text	20
W	PC_EMAIL	This field contains the email address of the primary contact.	See Student Contact Extract Fields page	Text	60
X	PC_PHONE_HOME	This field contains the home phone of the primary contact.	See Student Contact Extract Fields page OR if populated, [S_RI_STU_X]Primary_Contact_Phone	Text	15
Y	PC_PHONE_CELL	This field contains the cell phone of the primary contact.	See Student Contact Extract Fields page	Text	15
Z	PC_PHONE_WORK	This field contains the work phone of the primary contact.	See Student Contact Extract Fields page	Text	15
AA	PC_PRIMARY_LANGUAGE	This field contains the primary language spoken of the primary contact.	See Student Contact Extract Fields page	Text	4
AB	PC_ADDRESS_M_L1	The field contains the mailing address of the primary contact.	See Student Contact Extract Fields page	Text	50
AC	PC_ADDRESS_M_L2	The field contains the mailing address line 2 of the primary contact.	See Student Contact Extract Fields page	Text	50
AD	PC_ADDRESS_M_CITY	The field contains the mailing address city of the primary contact.	See Student Contact Extract Fields page	Text	50
AE	PC_ADDRESS_M_STATE	The field contains the mailing address state of the primary contact.	See Student Contact Extract Fields page	Text	2
AF	PC_ADDRESS_M_ZIP	The field contains the mailing address zip of the primary contact.	See Student Contact Extract Fields page	Text	5
AG	PC_ADDRESS_M_ZIP4	The field contains the mailing address zip+4 of the primary contact.	See Student Contact Extract Fields page	Text	4
AH	SC_FIRSTNAME If using Unlimited Contacts see Required Setup	This field contains the first name of the secondary contact.	See Student Contact Extract Fields page If using Unlimited Contacts see Required Setup	Text	50
AI	SC_LASTNAME	This field contains the first name of the secondary contact.	See Student Contact Extract Fields page	Text	50
AJ	SC_STUDENT_RELATION	This field contains the relationship to the student of the secondary contact.	See Student Contact Extract Fields page	Text	20
AK	SC_EMAIL	This field contains the email address of the secondary contact.	See Student Contact Extract Fields page	Text	60
AL	SC_PHONE_HOME	This field contains the home phone of the secondary contact.	See Student Contact Extract Fields page OR if populated, [S_RI_STU_X]Secondary_Contact_Phone	Text	15
AM	SC_PHONE_CELL	This field contains the cell phone of the secondary contact.	See Student Contact Extract Fields page	Text	15
AN	SC_PHONE_WORK	This field contains the work phone of the secondary contact.	See Student Contact Extract Fields page	Text	15
AO	SC_PRIMARY_LANGUAGE	This field contains the primary language spoken of the secondary contact.	See Student Contact Extract Fields page	Text	4
AP	SC_ADDRESS_M_L1	The field contains the mailing address of the secondary contact.	See Student Contact Extract Fields page	Text	50
AQ	SC_ADDRESS_M_L2	The field contains the mailing address line 2 of the secondary contact.	See Student Contact Extract Fields page	Text	50
AR	SC_ADDRESS_M_CITY	The field contains the mailing address city of the secondary contact.	See Student Contact Extract Fields page	Text	50
AS	SC_ADDRESS_M_STATE	The field contains the mailing address state of the secondary contact.	See Student Contact Extract Fields page	Text	2
AT	SC_ADDRESS_M_ZIP	The field contains the mailing address zip of the secondary contact.	See Student Contact Extract Fields page	Text	5
AU	SC_ADDRESS_M_ZIP4	The field contains the mailing address zip+4 of the secondary contact.	See Student Contact Extract Fields page	Text	4

Back to Top