Skip to main content
Liaison

Shared Lookup Table Updates for Spring 2023

Overview

Many fields in the Applicant Portal contain predefined answer values that applicants can select; for example, the Country and County fields both have predefined answer values. These values are housed in shared "lookup tables" which are viewable in your CAS's/UniCAS's data dictionary file (located under Help in WebAdMIT).

Periodically, we receive requests to update these lookup tables to include additional response options for some of the standard questions in the Applicant Portal. We strive to respond to these requests while acknowledging that some updates can potentially impact schools that are leveraging that data in many of our portals, including:

See below for the timeline and guidance for optimal implementation.

Timeline

  • September 11 – October 31, 2022: Account Managers meet with clients to review the upcoming changes.
  • November 1, 2022: final date to submit lookup table value requests.
  • November 30, 2022: new lookup table values finalized.
  • March 8 (updated from March 5) and April 2, 2023*: new lookup table values appear in the Applicant Portal and updated data dictionaries are available. These values will be released in two phases; see Changes to Applicant Portal Lookup Tables below to learn when new values are available.

*This date is subject to change.

Changes to Applicant Portal Lookup Tables

Colleges

Released on March 8, 2023.

Degrees

Released on March 8, 2023.

The following degrees will be added:

  • Bachelor of Science in Nuclear Engineering
  • Master of Veterinary Science
  • Post-Baccalaureate Certificate
  • Post-Baccalaureate Certificate in Integrated Animal Health Sciences

High Schools

To be released on April 2, 2023 (subject to change).

Majors

Released on March 8, 2023.

The following majors will be added:

  • Administration of Justice
  • Agriculture Animal Sciences
  • Agriculture Business
  • Agriculture Plant Sciences
  • Business Administration 2.0
  • Child and Adolescent Development
  • Elementary Teacher Education
  • Environmental Science
  • Film, Television, and Electronic Media
  • Integrated Animal Health Sciences
  • Law, Public Policy, and Society
  • Livestock Systems Health
  • Nuclear Engineering
  • Nutrition and Dietetics
  • Nutritional Sciences
  • Public Health Science
  • Social Justice Studies
  • Social Work and Human Services
  • Studio Arts

States

Released on March 8, 2023.

Changes to the Data Dictionaries and Master Code Lists

On March 8 and April 2, 2023, applicants are able to select the new options in the application. Additionally, you can download your new data dictionary, which contains the new lookup table values that correspond to the Changes to Applicant Portal Lookup Tables.

Note that the Master Code Lists for college, degree, and high school data are not published in our data dictionaries. Instead, they are available online in the WebAdMIT Help Center. Additionally, these Master Code Lists are updated once a year in the spring.

If you currently export data from our portals to your school's Student Information System (SIS) or another database, share this information with your Information Technology (IT) team.

If your school imports these fields directly from our system to yours, these new options will begin appearing in your exports as applicants select them. If you currently export data from our portals to your school's Student Information System (SIS) or another database, share these new lookup table values and data dictionaries with your Information Technology (IT) team. Additionally, if you created a "crosswalk" from our portals to your local data in your SIS/CRM, you may need to update this crosswalk for the newly added options.

Where New Lookup Table Values Appear

Once the new lookup table values become available to applicants, they're reflected in our portals in the applicant's profile, within the application PDF, and in lists and exports.

Future Changes

Lookup table change requests should be sent to your Account Manager, who will compile and review these requests before inclusion in the next lookup table update. A similar schedule will be provided closer to that time.

  • Was this article helpful?