Each name entity has three columns to record the name of the individual or organization: First Name, Middle Name, and Last Name.
These three columns are used as three separate columns for the name of an individual or are concatenated for a business or organization name. The Name Format column on the Name Master table dictates how the three name columns are used:
Name Format |
Display/Print |
Example |
Individual |
Last, First Middle |
Roth, Jennifer Sue |
Individual |
First Middle Last |
Jennifer Sue Roth |
Business |
Last First Middle (concatenated) |
Edison High School Smith Manufacturing Company |
For data entry, the Name Format column also dictates whether the three columns are separate columns on the window or if one single Business Name column is on the window.
Two values exist for the Name Format column and are stored in the drop-down list:
Name Format Value |
Name Format Description |
Purpose |
I |
Individual |
When the names are stored as Last Name, First Name, Middle Name for an individual, they may be displayed as noted above. |
B |
Business |
The business name is stored and displayed concatenated with no spaces between the three columns. |