load(
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: 20,
    sort: a!sortInfo(
      field: "university_id",
      ascending: true
    )
  ),
  with(
    local!datasubset: a!queryEntity(
      entity: cons!APPLICATION_ENTITY,
      query: a!query(
        selection: a!querySelection(columns: {
          a!queryColumn(field: "status"),
          a!queryColumn(field: "primary_major"),
          a!queryColumn(field: "secondary_major"),
          a!queryColumn(field: "student_id"),
          a!queryColumn(field: "university_id"),
        }),
        pagingInfo: local!pagingInfo
      )
    ),
	local!pairs: rule!getUniversityNamesAndIdsByIds(index(local!datasubset.data, "university_id", 0)),
    a!gridField(
      totalCount: local!datasubset.totalCount,
      columns: {
        a!gridTextColumn(
          label: "University",
          field: "university",
          data: apply(fn!displayvalue,local!datasubset.data, "university_id", null,local!pairs.id,local!pairs.name,"")
        ),
        a!gridTextColumn(
          label: "Student",
          field: "student",
          data: index(local!datasubset.data, "student_id", null)
        ),
        a!gridTextColumn(
          label: "Status",
          field: "status",
          data: index(local!datasubset.data, "status", null)
        ),
        a!gridTextColumn(
          label: "Primary Major",
          field: "primary_major",
          data: index(local!datasubset.data, "primary_major", null)
        ),
        a!gridTextColumn(
          label: "Secondary Major",
          field: "secondary_major",
          data: index(local!datasubset.data, "secondary_major", null)
        )
      },
      value: local!pagingInfo,
      saveInto: local!pagingInfo
    )
  )
)