Program Contacts

Contents

Introduction

The Program Contacts report is a district level report that extracts data pertaining to the primary contacts and contact information for specific programs within the district.

Prior to running the report, the primary program contacts must be designated on the following page in PowerSchool.

Start Page> Select Staff Member> Edit Information> Staff Demographics and Employment> Program Contacts

Note: If a staff member has multiple records in PowerSchool, any Program Contact records should be created under the record that’s flagged as the primary record.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Staff Selection

The report selects records from the [Users] table based on the following criteria:

The staff must have a Program Contacts record.
The start date of the Program Contact record must be less than, or equal to, the user defined end date.
The end date of the Program Contact record must be greater than the user defined start date, or 0/0/0.
The staff must be active.
The staffs Idaho hire date must be less than, or equal to, the user defined report end date.
The staffs Idaho termination date must be greater than the user defined start date, or blank.
The staff must have an Idaho Staff ID.
Staff with assignments at multiple schools must have a designated Primary Staff Record.

Back to Top

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 from the pop-up menu: Current School Only – Includes all student 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. Note: This option is for troubleshooting purposes only for this report. All Schools (default) – Includes all student records on the PowerSchool server that meet the selection criteria.
Staff List Option	Choose one of the following from the pop-up menu: All Staff – Includes all staff for the selected school(s) Select Staff – Includes staff selected from the Select Staff option
Select Staff	Select the staff name(s) to run the report for selected staff.
Report Start Date	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy for the first day of the report date range.
Report End Date	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy for the last day of the report date range.
Include Audit Fields	Choose Yes or No from the pop-up menu. The default option is No. Choosing Yes includes additional fields used for troubleshooting to identify data that may need to be modified prior to submitting the report to the state.
Validate Data	Choose Yes or No from the pop-up menu. The default option is Yes. Choosing No requires PowerSchool to validate whether the records meet the selection criteria listed above. The report returns a validation error if any of the selection criteria are not met.

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.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length	Reqd
1	districtId	The Idaho assigned district identifier.	[S_ID_USR_ProgramContacts_C]Location [Prefs]Value [Prefs]Name=districtnumber	Option Set	3	Yes
2	schoolId	The idaho assigned school or building identifier for which this role applies.	[Prefs]Value where [Prefs]Name = ID_BuildingNumber [Schools]Alternate_School_Number [Schools]School_Number	Option Set	4	Yes
3	roleCode	The code for the role.	[S_ID_USR_ProgramContacts_C] foreignkey_alpha	Option Set	3	Yes
4	roleTitle	A role title for the "Other" role code. Note: This will only report if the role code of “Other” is selected.	[S_ID_USR_ProgramContacts_C]RoleTitle	Varchar	50	Cond
5	isPrimaryContact	A flag indicating if this person is the primary contact for the role.	Always Y	Option Set	1	Yes
6	IDStaffId	The Idaho state assigned EDUID for this individual.	[S_ID_USR_X]IdahoStaffID	Varchar	9	Yes
7	lastName	The staff member’s last name.	[S_ID_USR_X]LegalLastName [Users]Last_Name	Varchar	35	Yes
8	firstName	The staff member’s first name.	[S_ID_USR_X]LegalFirstName [Users]First_Name	Varchar	35	Yes
9	jobTitle	The staff member's primary job title.	[S_ID_USR_ProgramContacts_C]JobTitle	Varchar	50	Yes
10	roleEmail	The primary staff member’s primary email address.	[Users]Email_Addr	Varchar	50	Yes
11	contactSchoolId	If this person is based out of an alternative location in the school district, state assigned school number for that location.	[Schools]Alternate_School_Number [Schools]School_Number	Option Set	4	No
12	phone1	An optional primary phone number to use to contact this individual about this role.	[Prefs]Value [Prefs]Name=districtphone	Number	10	No
13	phone1Extension	An optional extension for the primary phone.	Always blank	Number	5	No
14	phone1Type	The type of phone for the primary phone.	Always M	Option Set	1	Cond
15	phone2	An optional secondary phone number to use in attempts to contact this person in relation to this role. Note: This will be blank for the district office record.	[Schools]SchoolPhone	Number	10	No
16	phone2Extension	An optional extension for the secondary phone.	Always blank	Number	5	No
17	phone2Type	The type of phone for the secondary phone. Note: This will be blank for the district office record.	Always M	Option Set	1	Cond
18	altAddressLine1	The first line of an alternate address to use when mailing information about this role to this individual.	[Prefs]Value [Prefs]Name=districtaddress [S_ID_SCH_X]MailingAddressLine1 [Schools]SchoolAddress	Varchar	35	No
19	altAddressLine2	The second line of an alternate address to use when mailing information about this role to this individual.	[S_ID_SCH_X]MailingAddressLine2	Varchar	35	No
20	altCity	The city for the alternate mailing address.	[Prefs]Value [Prefs]Name=districtcity [S_ID_SCH_X]MailingCity [Schools]SchoolCity	Varchar	20	No
21	altStateCode	The state postal code for the alternate mailing address.	[Prefs]Value [Prefs]Name=districtstate [S_ID_SCH_X]MailingStateCode [Schools]SchoolState	Varchar	2	No
22	altZipCode	The five or nine-digit zip code for the alternate mailing address.	[Prefs]Value [Prefs]Name=districtzip [S_ID_SCH_X]MailingZipCode [Schools]SchoolZip	Character	9	No
23	Notes	Notes.	N/A	Varchar	250	No

Back to Top