• Rough draft

    • Linking Schools to Organization Records

    Owned by Elizabeth Storrs
    Last updated: May 15, 2024
    2 min read

    When students type in the name of their institution instead of choosing it from the dropdown list, there is no way of matching this record back to the tally of all applications from this school.

    image-20240515-201144.png

    To fix missing school codes, start with Database>Consolidate records, specifically the unlinked schools section:

    image-20240515-203601.png

    Each section describes the matching criteria.

    “Name” is an identical name:

    “Partial Key” matches are actually pointers to records that should be consolidated; instead of merging these school records, first fix the fact there are two entries in the table. (The record that no longer has a match in the table will end up back in the “name” pile to be linked.)

    “Partial Name + Location” will also bring up things that are definitely NOT matches, too…

    {{add instructions here on exactly what the fancy buttons do}}

    There will be some schools for which Slate has no helpful suggestions. to find those ..standard query

    When the school is not in the Organization Table

    There are three possibilities:

    (1) what the student put in can be be matched with an existing organization

    • Tufts University Fletcher School > Tufts University

    • John Caroll University > John Carroll University

    • UNC > University of North Carolina

    • Univ of the Pacific > University of the Pacific

    (2) a current organization needs to be updated

    • Heidelberg University > Heidelberg University (formerly Heidelberg College)

    • Nevada State University > Nevada State University (formerly Nevada State College)

    • standard format for these is new name (formerly old name)

    (3) A new organization needs to be created

    • College of the Muscogee Nation

    • Indian Maritime University