Configure Table Lookups for Child Table Data for PowerSchool Imports

Use table lookups to map information from specific records within a child table, such as a particular medication, emergency contact, or other related data in PowerSchool.

What Are Table Lookups?
Creating a Table Lookup Condition
Using a Table Lookup in a Mapping

 

What Are Table Lookups?

Some data sources contain child tables, which are groups of related records connected to a student. Examples might include medications, contacts, immunizations, or other repeating information.

Table lookups allow you to identify a specific record within one of these tables by creating a condition. Once the condition is created, you can use it when building your mappings to pull data from the correct record.

 

Creating a Table Lookup Condition

Note: You will first need to download the updated PowerSchool plugin before getting started. You can find instructions in the article here.

1. Click the kebab menu (three dots) next to the mapping field.

   

2. Select Configure Lookup > Add New Condition.
3. Select the Table that contains the data you want to search. Enter the Index of the field you want to search within. The index represents the field's position in the table:
   • 1 = First field
   • 2 = Second field
   • 3 = Third field
   • And so on
4. Enter the Value you want to find in that field.
   For example, if the medication name is stored in the first field of the Medications table and you want to find records for "Insulin," you would enter:
   • Table: Medications
   • Index: 1
   • Value: Equals
     • medication field
     • Value Input -> insulin
       
5. Click Save to create the lookup condition.

This condition can then be used in your mappings to pull data from records that match the criteria you specified.

 

Using a Table Lookup in a Mapping

After creating a table lookup condition, it becomes available when configuring field mappings.

When selecting data to map, choose the lookup condition you created. The mapping will then pull information from the matching record within the child table.

This process works similarly to how Contact records are mapped, which you can learn more about here.