Categories
Name format HR - CX prefix not in datatable
We noticed that the prefix is not filled in the data tables, see below example:
HR |
|
|
|
|
|
|
|---|---|---|---|---|---|---|
FIRST_ NAME | PREFIX | LAST_NAME | KNOWN_AS (Roepnaam) | TITLE | MIDDLE_NAME | SUFFIX |
Wilhelmus | van | Nassouwe | Willem |
|
|
|
|
|
|
|
|
|
|
In HR the name is build as: KNOWN_AS PREFIX LAST_NAME > Willem van Nassouwe | ||||||
|
|
|
|
|
|
|
CX |
|
|
|
|
|
|
TITLE | FIRST_ NAME | MIDDLE_NAME | LAST_NAME | SUFFIX |
|
|
| Wilhelmus |
| Nassouwe |
|
|
|
|
|
|
|
|
|
|
In CX only the above names are synced with HR > Wilhelmus Nassouwe. So the prefix is missing. |
|
Looking into the documentation for tables and views in Oracle we have below columns containing the 'de' particle
• For TCA table HZ_PERSON_PROFILES
The HZ_PERSON_PROFILES table stores personal and family information about a party of the 'Person' type. For example, this table would store the gender, marital status, academic title, previous last name of the person etc. Note that some informaiton in this table may also be entered into the HZ_PARTIES table
https://docs.oracle.com/en/cloud/saas/sales/oedms/hzpersonprofiles-13208.html#hzpersonprofiles-13208
- Column PERSON_LAST_NAME_PREFIX is used to capture the Last name prefix (e.g. 'fon', 'van', etc.) for a person. It is used in the same way the new field PERSON_LAST_NAME_PREFIX in HZ_PERSON_PROFILES is used. Corresponds to the field Last Name Prefix in HL7.
• For HCM table PER_PERSON_NAMES_F
This table is to hold core (common) and legislative-specific name components for a person, and names represented in different character sets. The table is date effective to record changes over time.
https://docs.oracle.com/en/cloud/saas/human-resources/24b/oedmh/perpersonnamesf-29732.html
- column PRE_NAME_ADJUNCT is used for storing prefix to a person's last name, generally not considered when sorting
The request is to have the prefix also in the current design, so that the names are un sync between HR and CX