Created by Corina C Larsen, last modified on Apr 11, 2018
A version of this table, PERSON_NAME - Current Primary Name View (CS), is also available in the CSRPT Database.
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| ASOFDATE - As Of Date | Date | As Of | ||
| COUNTRY_NM_FORMAT - Format Using | Char3 | Use | ||
| → | EMPLID - Empl ID | Char11 | ID | |
| FIRST_NAME - First Name | Char30 | First Name | ||
| FIRST_NAME_SRCH - First Name | Char30 | First Name | ||
| LAST_NAME - Last Name | Char30 | Last | ||
| LAST_NAME_PREF_NLD - Last Name Preference | Char1 | N | Preference | |
| LAST_NAME_SRCH - Last Name | Char30 | Last | ||
| MIDDLE_NAME - Middle Name | Char30 | Middle | ||
| NAME - Name | Char50 | Name | ||
| NAME_AC - Alternate Character Name | Char50 | AC Name | ||
| NAME_DISPLAY - Display Name | Char50 | Display Name | ||
| NAME_DISPLAY_SRCH - Name | Char50 | Name | ||
| NAME_FORMAL - Formal Name | Char60 | Formal Name | ||
| NAME_INITIALS - Name Initials | Char6 | Initials | ||
| NAME_PREFIX - Name Prefix | Char4 | Prefix | ||
| NAME_PSFORMAT - Name (LN,FN) | Char50 | LN,FN | ||
| NAME_ROYAL_PREFIX - Name Royal Prefix | Char15 | Royal Prefix | ||
| NAME_ROYAL_SUFFIX - Name Royal Suffix | Char15 | Royal Suffix | ||
| NAME_SUFFIX - Name Suffix | Char15 | Suffix | ||
| NAME_TITLE - Title | Char30 | Title | ||
| NAME_TYPE - Type of Name | Char3 | Name Type | ||
| PARTNER_LAST_NAME - Last Name Partner | Char30 | Last Name | ||
| PARTNER_ROY_PREFIX - Prefix Partner | Char15 | Prefix | ||
| PREF_FIRST_NAME - Preferred First Name | Char30 | Preferred First | ||
| SECOND_LAST_NAME - Second Last Name | Char30 | Second Last | ||
| SECOND_LAST_SRCH - Second Last Name | Char30 | Second Last |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.