Page last modified 07:54, 5 May 2018 by kgirrard

    Version as of 09:40, 26 Sep 2023

    to this version.

    Return to Version archive.

    View current version

    Although the amount of information maintained for for this area is quite small, no other area is used as much as this one. Everyone who exists in the database, students, faculty, even users of the database, must first be defined as a person with a name and an ID number.


    A name and ID number together form a person's identity. Even if a person's name changes, or they request that their ID number be changed, their identity stays the same.

    Equally important is that each person has only one identity. If you fail to locate someone's existing name and ID and create a second one, it is very difficult to draw those two identities back together again.

    ID Numbers

    Each person is assigned a unique, system-generated seven-digit ID number when their identity is created. Doing this avoids the legal issues with using SSN or other government supplied number, or the long-term problems of using parts of a person's name, which often changes.


    While ID numbers are unique, multiple people can share the same name. Supplying addtional information on the Person form (date of birth, gender, etc.) can help to correctly identify the person you're looking for. Names should be entered as accurately and completely as possible, including middle names, to make this task easier as well.


    When working with person data, locating someone who already exists in the database, or confirming that they don't exist, is critical. Each form's ID field can be used to search for people, or the the Identity Search form can be used when additional information is needed to distinguish between people with the same or similar names.

    When you start typing a name in the ID number field the database will search for records with a last name starting with what you have typed, or a last name that sounds like what you've typed.If you then enter a comma or space followed by another part of the name, all parts will be matched against first, middle or last names. 

    IDSearch1.pngThe order doesn't matter, but one part of what you type much match the last name (using either the sounds-like comparison, or a name that starts with what you have entered).

    The example (right) shows how varied the sounds-like match can be.

    Notice that all parts of the name entered in the ID field must match some part of the name. First-, middle- and last-names are all considered, but a match must be made for everything entered. Here the matched last names start with or sound like "Reynol" and the first names all start with "Mar."


    The second example shows names matched on the partially-entered names "Shru" and "Re." "Shru" matched the last name "Shrew" where the middle name was similar to the other characters entered, and the last name "Shirai" where the first name stated with "Re." "Rena, Shirai" was matched because the last name starts with "Re" and the first name sounds like "Shru."



    This form allows for a limited amount of information to be supplied when searching for people. If you are unsure of spelling you can use parts of names, or even single letters.

    The example shown here searches for anyone with a first name starting with "s" and a last name containing the letters "ac." The result of the query shows the full name, ID number, and the current ID (in case it's been changed). Once you've located someone, you can copy their ID number for use in other forms.

    When searching, be sure to use the "%" wildcard or the search will try and match on exactly what you enter, e.g. entering just "s" in the First name field would only locate people whose first name is just "s" and nothing else.

    Creating a Person

    Once you've confirmed that someone doesn't exist in the database, you can use the Name and ID form to create a new person.

    The form contains three distinct areas, or blocks: Search, used to locate and retrieve existing Name and ID records for name changes; Create or Update, used to create new person, or to update an existing Name and ID; NameID0.pngPrior Name and ID History, which lists prior names for the person displayed on the form.

    To create a new person, there must not be an ID present in the Search block. If an ID is present, you are changing someone's name, not creating a new person! To be safe, use the Reset button to clear the form before creating a new person.

    With the Search ID blank, supply Name information in the Create or Update block. Suffix should contain any designation like Jr, Sr, II, etc. (not prefixes like Mr. or Ms.). Notice that the Generate New ID indicator is checked. This indicates that when the name is submitted an ID number will be generated automatically and displayed on the form.

    Click on Submit, and an ID number will be displayed in the ID field.

    Name Changes

    To record a name change, the ID number for the person requesting the change must be present in the Search block. This will cause their current Name and ID information to be displayed in the Create or Update block where it can be updated with new information.NameID.png

    In this example the middle initial of "R." has been added.

    Note that the Generate New ID indicator is not checked in this example. Replacing someone's ID number is something that should rarely be necessary. Remember, too, that doing so is merely requesting a new ID number for the same person, not creating a new person. Don't confuse Generate New ID with creating a new person in the database.

    When this change is submitted, a new row will be displayed in the Prior Name block, showing the name without the middle initial. It is possible to delete records from this block when they aren't needed. Adding a middle initial or fixing the spelling of a name are good examples of when a prior name record could reasonably be deleted. Check the delete control for the newly displayed row, then click Submit again and it's gone.

    Person Data

    In addtion to name and ID number, basic biographical information is collected. This information is managed using the Person form.person1.png

    The Person form is just one of many that manage person-specific information and have an ID number as a key field. Entering an ID number directly is the best guarantee that you are viewing the record you want.

    All ID fields will suggest ID and Name information based on a partial entry, which is useful when an ID number isn't known. Typing just "nob" would likely be enough to display the suggestion of "Noble, Barnes." You'll see suggestions when entering part of an ID number as well.

    The person form contains birth date, US and FSM SSNs, gender, ethnicity, indicators for veteran status, requested confidentiality, and deceased status. There are separate blocks for entry of mailing and e-mail addresses.

    Within the mailing address block, City will suggest known values from the City validation table. Using a known value will automatically supply municipality, state, country and ZIP. Municipality also provides suggestions from it's list of municipalities in the FSM, Marshalls, CNMI, and Palau.

    E-mail addresses and mailing addresses share the same Address Type codes.

    Powered by MindTouch Core