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.
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 | 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 | This field contains the first name of the primary contact. | See Student Contact Extract Fields page | 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 | This field contains the first name of the secondary contact. | See Student Contact Extract Fields page | 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 |