Skip to main content
Skip table of contents

Setup

Introduction

Before you can begin using Georgia LDS, you must perform the following setup items:

  • Configure PowerSchool Application Node or Load Balancer
  • Configure PowerSchool's External Web Address
  • Configure the District Security Certificate
  • Configure Georgia Single Sign-On
  • Configure Georgia LDS Roles (optional)
  • Delete Custom Staff Fields (optional)
  • Assign Georgia LDS Roles

Note: It is recommended that you do not use the browser Back button to navigate through PowerSchool, as it may not produce the desired results. Use the appropriate button shown on each page.

Configure PowerSchool Application Node or Load Balancer

  • The Georgia LDS requires that the PowerSchool Identity Provider component be installed to support the SAML connection between the two systems.
  • The Georgia DOE requires a Secure Socket Layer (SSL) connection to access LDS data. 

    If you have not enabled PowerSchool Identity Provider or configured SSL on your PowerSchool application node or load balancer, do so now. For step-by step instructions, see the SSL Configuration section in the PowerSchool Installation and Upgrade Guide available on PowerSource

    If you have already enabled PowerSchool Identity Provider component and configured SSL on your PowerSchool application node or load balancer, proceed to the next section.

Configure PowerSchool’s External Web Address

Once you have configured SSL, you can then configure the PowerSchool’s external web address settings needed in order to establish a successful SSO connection with Georgia LDS.

How to Configure PowerSchool’s External Web Address

  1. On the start page, choose System from the main menu. The System Administrator page appears.
  2. Click System Settings. The System Settings page appears.
  3. Click Global Server Settings. The Global Server Settings page appears.
  4. Use the following table to enter information in the PowerSchool Configuration - External Access fields:

Field

Description

Secure Server SSL

Select the checkbox to enable SSL.

Server Host name or IP Address

Enter external server host name or IP address.

Port

Enter 443. This is the default SSL port.

Note: You can also configure a different port if you wish to do so.

5. Click Submit.

Configure the District Security Certificate

Once you have configured the PowerSchool’s external web address settings, you can then configure the district security certificate and private key. The security certificate and private key are used to authenticate the PowerSchool server with the Georgia LDS system. The certificate and private key must be stored in PowerSchool, and sent to and accepted by the Georgia LDS system.

How to Configure the District Security Certificate

  1. On the start page, click Special Functions. The Special Functions page appears.
  2. Click Interfaces to other systems. The Interfaces to Other Systems page appears.
  3. Click Georgia Longitudinal Data System. The Georgia Longitudinal Data System page appears.
  4. Click Manage District Security Certificate. The Manage District Security Certificate page appears.
  5. Use the following table to enter information in the fields:

Field

Description

Certificate Status

This field indicates the status of the certificate used to authenticate the PowerSchool server with the Georgia LDS system. The certificate must be created and stored in PowerSchool, then sent and accepted by the Georgia LDS system.

One of the following messages appears:

  • Loaded – Indicates that the certificate is stored in the PowerSchool database and available for all nodes in a server array.
  • Not Loaded – Indicates that a certificate must be created and loaded into the PowerSchool database.

Certificate Expiration

If a certificate already exists in the PowerSchool database, this is the date that the certificate expires.

Export District Security Private Key

Click the link to export an existing private key file from the PowerSchool database. The private key file is saved to your desktop with the name key.pem. Contact the Georgia Department of Education for instructions for uploading the private key to the LDS system.

Export District Security Certificate

Click the link to export an existing certificate from the PowerSchool database. The certificate is saved to your desktop with the name certificate.pem. Contact the Georgia Department of Education for instructions for uploading the certificate to the LDS system.

Import

Select the option to import an existing security certificate. Populate the Private Key File, Private Key Password (if applicable) and Certificate File fields below and click Import to import the certificate and private key file into the PowerSchool database.

Generate Self Signed Certificate

Select the option to refresh the page and access the Generate button. Click Generate to generate a self-signed security certificate and private key file, which are automatically saved in the PowerSchool database.

Note: It is not necessary to generate a self-signed certificate and private key file if your district already has a certificate from a Certificate Authority.

Private Key File

Click Browse… to locate an existing private key file.

Note: The supported private key types are RSA and DSA, with an encoding of PKCS 8. The private key file format must be PEM.

Private Key Password

Enter the password for the private key, if applicable.

Note: PowerSchool supports uploading an encrypted private key file with a password.

Certificate File

Click Browse… to locate an existing security certificate file.

Note: The supported certificate type for PowerSchool is X509 and the file format must be PEM.

6. Click Import or Generate. The page refreshes with one of the following messages:

    • Changes Saved – indicates that the Georgia Longitudinal Data System settings are saved in the PowerSchool database.
    • A warning message regarding the information entered on the page, such as:
      • A valid Private Key File is required to import a Certificate.
      • A valid Certificate File is required to import a Certificate.

Back to Top

Configure Georgia Single Sign-On

After you have configured the district security certificate, you can configure the settings needed for establishing a successful SSO connection between PowerSchool and Georgia LDS making the transition between PowerSchool and Georgia LDS seamless.

How to Configure Georgia Single Sign-On

Use this procedure to enable and configure Georgia Single Sign-On.

  1. On the start page, click Special Functions. The Special Functions page appears.
  2. Click Interfaces to other systems. The Interfaces to Other Systems page appears.
  3. Click Georgia Longitudinal Data System. The Georgia Longitudinal Data System page appears.
  4. Use the following table to enter information in the fields:

Field

Description

Enable Single Sign-On to Georgia LDS

Select the checkbox to enable single sign-on functionality for the district.

Note: If you select the checkbox and click Submit, a Georgia LDS link appears on the PowerSchool and/or PowerTeacher start page for staff members assigned Georgia LDS role(s) on the staff Security Settings page.

Certificate Status

This field indicates the status of the security certificate used to authenticate the PowerSchool server with the Georgia LDS system. The certificate and a private key must be created and stored in PowerSchool, then sent to and accepted by the Georgia LDS system.

One of the following messages appears:

  • Loaded – Indicates that the certificate is stored in the PowerSchool database and accessible to all nodes in a server array.
  • Not Loaded – Indicates that a certificate must be created and loaded into the PowerSchool database.

Expires

If a certificate already exists in the PowerSchool database, this is the date that the certificate expires.

Export District Security Private Key

Click the link to export an existing private key file from the PowerSchool database. The private key file is saved to your desktop with the name key.pem. Contact the Georgia Department of Education for instructions for uploading the private key to the LDS system.

Export District Security Certificate

Click the link to export an existing certificate from the PowerSchool database. The certificate is saved to your desktop with the name certificate.pem. Contact the Georgia Department of Education for instructions for uploading the certificate to the LDS system.

Manage District Security Certificate

Click the link to open the Manage District Security Certificate page. Use the options on that page to generate or import a certificate and private key file into the PowerSchool database.

Georgia LDS SAML Metadata URL

Enter the URL for the state’s SAML metadata, a standard protocol for exchanging security information related to single sign-on.

District SAML Provider ID

Enter http:// followed by the district number, such as http://1234. This element is used to identify the PowerSchool server to the Georgia LDS.

District Identity Provider Endpoint URL

The URL of the district identity provider, which must use HTTPS. This URL indicates to the Georgia LDS where to redirect when an LDS session times out (approximately every 20 minutes). If the staff member is actively working in PowerSchool, then the LDS session is automatically renewed, with no action required by the staff member. If the staff member is not actively working in PowerSchool, then the browser redirects to the PowerSchool login page.

5. Click Submit. The page refreshes with one of the following messages:

    • Changes Saved – indicates that the Georgia Longitudinal Data System settings are saved in the PowerSchool database.
    • A warning message regarding the information entered on the page, such as:
      • The given District SAML Provider ID value is not valid.
      • The given Metadata URL value is not valid.

Back to Top

Complete Secure Connection

Lastly, the following items need to be sent to the Georgia Department of Education (DOE). It is recommended to send this information via a secure channel, such as Cisco certified email.

  • District Security Certificate – This item is used to sign messages sent between PowerSchool and the Georgia LDS in order to ensure that the communication is secure. The Georgia LDS maintains this certificate and the related private key on file.
  • District Identifier – This item allows the Georgia DOE to uniquely identify the district and ensures that only staff members from the district see the district’s data in the Georgia LDS.
  • SAML IdP Endpoint URL – The URL of the SAML Identify Provider Endpoint installed in the PowerSchool Node server folder with PowerSchool versions 6.2.1.1 and later. This URL, which must use HTTPS, allows single sign-on to occur securely and without the need to synchronize staff member accounts between PowerSchool and the Georgia LDS.

Configure Georgia LDS Roles

Using Georgia LDS roles, you can control the level of access within the Georgia LDS system given to PowerSchool users who access Georgia LDS from within PowerSchool and PowerTeacher. By default, there are four predefined Georgia LDS staff level roles that you can assign to PowerSchool users: District Administrator, School Administrator, Teacher and Counselor. In addition, you can create as many other roles as needed based on your district’s needs.

How to Create a Role

  1. On the start page, choose System from the main menu. The System Administrator page appears.
  2. Click Roles Administration. The Roles Administration page appears.
  3. Click User Access. The User Access Roles page appears.
  4. Click New. The Edit User Access Role page appears.
  5. Use the following table to enter information in the fields:

Field

Description

Name

Enter the name of the role, such as Nurse.

Description

Enter a description of the role, such as Nurse Configuration.

Enabled

Select the checkbox to enable the role. When enabled, the role appears on the User Access Mapping for [Name] pop-up.

Alternatively, deselect the checkbox to disable the role. When disabled, the role no longer appears on the User Access Mapping for [Name] pop-up.

Note: The User Access Mapping for [Name] pop-up is accessible via Manage Roles on the Security Settings page.

Is access to the GA LDS system granted?

Select the checkbox to indicate access to the Georgia LDS system is granted.

Alternatively, deselect the checkbox to indicate access to the Georgia LDS system is not granted.

GA LDS Token

If the Is access to the GA LDS system granted checkbox is selected, enter the access token to be used for data exchange.

Note: The access token must be recognized by Georgia LDS.

6. Click Submit. A confirmation message appears.

Back to Top

How to View User Access Roles

  1. On the start page, choose System from the main menu. The System Administrator page appears.
  2. Click Roles Administration. The Roles Administration page appears.
  3. Click User Access. The User Access Roles page displays the following information:
  4. Use the following table to enter information in the fields:

Field

Description

Name

The name of the role, such as Nurse. Click to access the Edit User Access Role page.

Description

Description of the role, such as Nurse Configuration.

GA LDS Access

A green checkmark indicates the user has been granted access to the Georgia LDS system.

GA LDS Token

The access token to be used for data exchange.

How to Sort User Access Roles

Use the following procedure to arrange the user access roles into the order in which you want the roles to appear on the User Access Roles page, the Mass Assign User Access Roles page, and the Manage Roles pop-up on the Security Settings page.

  1. On the start page, choose System from the main menu. The System Administrator page appears.
  2. Click Roles Administration. The Roles Administration page appears.
  3. Click User Access. The User Access Roles page appears.
  4. Drag and drop the user access role you want to move. A message appears indicating the user access role is being updated.
  5. Repeat Step 4 for each user access role you want to move. When you are done, the changes are automatically saved.

Note: If a role is added, it appears as the last item in the sort order. If a role is deleted, the sort order is automatically updated and re-sequenced as needed.

Back to Top

How to Edit a Role

  1. On the start page, choose System from the main menu. The System Administrator page appears.
  2. Click Roles Administration. The Roles Administration page appears.
  3. Click User Access. The User Access Roles page appears.
  4. Click the name of the user access role you want to edit. The Edit User Access Role page appears.
  5. Edit information as needed. For field descriptions, see How to Create a Role.
  6. Click Submit. A confirmation message appears.

Back to Top

How to Delete a Role

Note: A role may not be deleted if it is assigned to user(s). To search for staff members that are assigned to a particular role, see How to Search for Staff by Roles. To unassign an individual teacher or a group of teachers from a role you want to delete, see How to Unassign a Georgia LDS Role and How to Mass Unassign Georgia LDS Roles, respectively.

  1. On the start page, choose System from the main menu. The System Administrator page appears.
  2. Click Roles Administration. The Roles Administration page appears.
  3. Click User Access. The User Access Roles page appears.
  4. Click the name of the user access role you want to delete. The Edit User Access Role page appears.
  5. Click Delete.
  6. Click Confirm Delete. The User Access Roles page appears.

Back to Top

How to Configure the Roles Table

  1. On the start page, choose System from the main menu. The System Administrator page appears.
  2. Click Roles Administration. The Roles Administration page appears.
  3. Click User Access. The User Access Roles page appears.
  4. Click Configure Table. The User Access Configure Matrix View page appears.
  5. Use the following table to enter information in the fields:

Field

Description

Is access to the GA LDS system granted?

Enter the heading row text in the Short Name field.

Select the Show in Matrix checkbox if you want this column to appear on User Access Roles page.

Alternatively, deselect the Show in Matrix checkbox if you do not want this column to appear on User Access Roles page.

GA LDS Token

Enter the heading row text in the Short Name field.

Select the Show in Matrix checkbox if you want this column to appear on User Access Roles page.

Alternatively, deselect the Show in Matrix checkbox if you do not want this column to appear on User Access Roles page.

6. Click Submit. A confirmation message appears.

Back to Top

Delete Custom Staff Fields

After configuring Georgia LDS Roles, you may want to perform data cleanup of any legacy roles that are no longer used, such as:

  • GA_LDS_counselor
  • GA_LDS_districtadmin
  • GA_LDS_schooladmin
  • GA_LDS_teacher

How to Delete Custom Staff Fields

Note: Deleting a custom field also deletes that field and its values from any custom pages.

  1. On the start page, choose System from the main menu. The System Administrator page appears.
  2. Click Custom Fields/Screens. The Custom Fields/Screens page appears.
  3. Click Staff Fields. The Staff Fields page appears.
  4. Click the name of the field you want to delete. The Edit Staff Field page appears.
  5. Select the checkbox to confirm that you want to delete the field.
    Note: If you do not select the checkbox and click Delete, the system displays a message indicating that the field was not deleted. Click Back to return to the previous page. Select the checkbox, and then click Delete.
  6. Click Delete.
  7. Click Confirm Delete. Do not leave the page until a message indicates that the process is complete. The Custom Field Deleted page appears.

Note: The system lists any PowerSchool pages that include the custom field. If any pages appear, you must manually remove the fields from those pages.

Back to Top

Assign Georgia LDS Roles

Staff members must be assigned the appropriate role(s) in PowerSchool to access the Georgia LDS system.

Note: By default, there are four predefined Georgia LDS staff level roles that you can assign to PowerSchool users: District Administrator, School Administrator, Teacher and Counselor.

How to Assign a Georgia LDS Role

Use this procedure to assign Georgia LDS roles to an individual staff member.

1. On the start page, click Staff. The Search Staff page appears.
2. Search for and select a staff member.
3. Click Security Settings. The Security Settings page appears.
4. Click the Role Assignment tab. The Role Assignment page appears.

Note: The Submit button appears shaded until you click the Add button.

5. Click Add. The Role pop-up menu appears.

Note: If the Add button does not appear, all roles have been assigned.

6. Choose the role you want to assign to the staff member.
7. Repeat Step 5 and Step 6 for each role you want to add.

Note: Once all roles have been assigned, the Add button appears shaded.

8. Click Submit. A confirmation message appears.

Back to Top

How to Unassign a Georgia LDS Role

Use this procedure to remove Georgia LDS roles from an individual staff member.

  1. On the start page, click Staff. The Search Staff page appears.
  2. Search for and select a staff member.
  3. Click Security Settings. The Security Settings page appears.
  4. Click the Role Assignment tab. The Role Assignment page appears.
  5. Click Remove next to the role you want to unassign. A confirmation message appears.
  6. Repeat Step 4 and Step 5 for each role you want to remove.

How to Mass Assign Georgia LDS Roles

Use this procedure to assign Georgia LDS roles to multiple staff members.

Note: This page is also accessible via System > Security > Mass Assign User Access Roles.

  1. On the start page, click Staff. The Search Staff page appears.
  2. Search for multiple staff members. The Select A Staff Member page appears.
  3. Click Functions. The Group Staff Functions page appears.
  4. Click Mass Assign User Access Roles. The Mass Assign User Access Roles page appears.
  5. Use the following table to enter information in the fields:

Field

Description

Mass assign User Access Roles with () selected teachers

The selected teachers appear as the current selection.

Possible Roles

Indicate which roles you want to assign.

To assign a role:

  1. Select the role you want to assign.
    Note: To select multiple roles, press and hold COMMAND (Mac) or CONTROL (Windows) as you click each role.
  2. Click the single arrow pointing right.

To assign all roles, click the double arrows pointing right.

Selected Roles

The roles selected from the Available User Access Roles appear.

To remove a role from this list:

  1. Select the role you want to remove.
    Note: To select multiple roles, press and hold COMMAND (Mac) or CONTROL (Windows) as you click each role.
  2. Click the single arrow pointing left.

To remove all roles from this list, click the double arrows pointing left.

6. Click Assign. The Mass Assignment Results page displays a summary of the processed records and any failures. Possible error messages include:

Error

Description

Failed to update the database – Caused by internal error.

Check the system logs. For more information, see the PowerSchool Monitor section of the System Administrator User Guide available on PowerSource.

Contact your PowerSchool system administrator, if needed.

Back to Top

How to Mass Unassign Georgia LDS Roles

Use this procedure to remove Georgia LDS roles from multiple staff members.

Note: This page is also accessible via System > Security > Mass Assign User Access Roles.

  1. On the start page, click Staff. The Search Staff page appears.
  2. Search for multiple staff members. The Select A Staff Member page appears.
  3. Click Functions. The Group Staff Functions page appears.
  4. Click Mass Assign User Access Roles. The Mass Assign User Access Roles page appears.
  5. Use the following table to enter information in the fields:

Field

Description

Mass assign User Access Roles with () selected teachers

The selected teachers appear as the current selection.

Possible Roles

Indicate which roles you want to unassign.

To unassign a role:

  1. Select the role you want to unassign.
    Note: To select multiple roles, press and hold COMMAND (Mac) or CONTROL (Windows) as you click each role.
  2. Click the single arrow pointing right.

To unassign all roles, click the double arrows pointing right.

Selected Roles

The roles selected from the Available User Access Roles appear.

To remove a role from this list:

  1. Select the role you want to remove.
    Note: To select multiple roles, press and hold COMMAND (Mac) or CONTROL (Windows) as you click each role.
  2. Click the single arrow pointing left.

To remove all roles from this list, click the double arrows pointing left.

6. Click Remove.

7. Click Confirm Delete. The Mass Assignment Results page displays a summary of the processed records and any failures. Possible error messages include:

Error

Description

Failed to update the database – Caused by internal error.

Check the system logs.

Contact your PowerSchool system administrator, if needed.

Back to Top

Search for Staff by Roles

Using the Search Staff function, you can search for staff members that are assigned to a particular role.

How to Search for Staff by Roles

  1. On the start page, choose Staff Search from the main menu. The Search Staff page appears.
  2. In the Search Staff field, enter the role of a staff member whose record you want to review. For example:
  • Role.useraccess= District Administrator
  • Role.useraccess= School Administrator
  • Role.useraccess= Teacher
  • Role.useraccess= Counselor

Note: Leading and trailing spaces are removed from the value for which you are searching, embedded spaces are not, and considered part of the term to match.

  1. Click the Search icon. Staff members associated to the role appears.
  2. Click the name of the individual whose record you want to review. To work with the entire group of staff members, click Functions at the bottom of the list to display the Group Staff Functions page. For more information about the group staff functions, see Work With Staff Groups.

Back to Top

Troubleshooting

The following section provides information about troubleshooting errors you may encounter when using Georgia LDS.

Georgia LDS Link Does Not Appear

If the Georgia LDS link does not appear in the PowerSchool admin or PowerTeacher portal, then verify the following:

  • SSL on PowerSchool application node or load balancer is configured.
  • PowerSchool’s external web address is configured.
  • District security certificate is configured
  • Georgia single sign-on is configured.
  • Georgia LDS roles are configured.
  • Georgia LDS roles are assigned.
  • The staff member is signed in to PowerSchool or PowerTeacher using the correct URL, such as https://[PowerSchool IP address]/admin or https://[PowerSchool IP address]/teachers.

If the Georgia LDS link does not appear in the PowerSchool Student and Parent portal, then verify the following:

  • The state_studentnumber fields are populated for the students being viewed.

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.