| Data element |
Definition |
EMPLID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for individual (non-org) records. |
NAME_TYPE
Indexed - Yes
Format - VARCHAR2
Nullable - N |
Indicates type of name, e.g. preferred name or birth name. See warehouse table WHSE_NAME_TYPE_LKUP for decode values. |
EFFDT
Indexed - Yes
Format - DATE
Nullable - N | Effective date of the table row. Tells you which data is most "up to date", and which rows have been changed. By definition, tables with an "MV" suffix only show the "most effective dated row", i.e. the current valid row. |
COUNTRY_NM_FORMAT
Indexed - No
Format - VARCHAR2
Nullable - N | |
NAME
Indexed - Yes
Format - VARCHAR2
Nullable - N | Name field (format ex. Mr. John Smith) |
NAME_INITIALS
Indexed - No
Format - VARCHAR2
Nullable - N | |
NAME_PREFIX
Indexed - Yes
Format - VARCHAR2
Nullable - N | |
NAME_SUFFIX
Indexed - No
Format - VARCHAR2
Nullable - N | |
NAME_ROYAL_PREFIX
Indexed - No
Format - VARCHAR2
Nullable - N | |
NAME_ROYAL_SUFFIX
Indexed - No
Format - VARCHAR2
Nullable - N | |
NAME_TITLE
Indexed - No
Format - VARCHAR2
Nullable - N | |
LAST_NAME_SRCH
Indexed - Yes
Format - VARCHAR2
Nullable - N | |
FIRST_NAME_SRCH
Indexed - No
Format - VARCHAR2
Nullable - N | |
LAST_NAME
Indexed - Yes
Format - VARCHAR2
Nullable - N | Last name, determined by NAME_TYPE field. |
FIRST_NAME
Indexed - No
Format - VARCHAR2
Nullable - N | First name, determined by NAME_TYPE field. |
MIDDLE_NAME
Indexed - No
Format - VARCHAR2
Nullable - N | |
SECOND_LAST_NAME
Indexed - No
Format - VARCHAR2
Nullable - N | |
SECOND_LAST_SRCH
Indexed - No
Format - VARCHAR2
Nullable - N | |
NAME_AC
Indexed - No
Format - VARCHAR2
Nullable - N | |
PREF_FIRST_NAME
Indexed - No
Format - VARCHAR2
Nullable - N | |
