The Name Master table is the core of the database. This table stores the name and name-related information about individuals and organizations. Each entity in Name Master is associated with a unique ID Number on this table, and each individual or organization has only one row on the Name Master table. Individuals in the Name Master table can include prospective students, applicants, enrolled students, faculty, staff, and donors. Organizations can include colleges, high schools, vendors, and community organizations.
When a Name Master row is saved, the system updates the Soundex Code column in the Soundex table on the basis of the individual's last name or the name of the business/organization.
Because this table is used by all offices, the Name Master table is a Common table.
|
|
Payroll uses employee names from the Name Master; Registration uses student names from the Name Master; and Development uses alumni and donor names from the Name Master. |