HcmContactsnames
HcmContactsnames
Columns
| Name | Type | Description |
| HcmContactsPersonId [KEY] | Long | HcmContactsPersonId of HcmContactsnames |
| PersonNameId [KEY] | Long | PersonNameId of HcmContactsnames |
| EffectiveStartDate [KEY] | Date | Start date of the date-effective changes to the record. |
| EffectiveEndDate [KEY] | Date | End date of the date-effective changes to the record. |
| LegislationCode | String | Legislation code of the contact. Valid values are defined in the hcmCountriesLov. |
| LegislationName | String | LegislationName of HcmContactsnames |
| LastName | String | Contact's last name. |
| FirstName | String | Contact's first name. |
| Title | String | Person salutation such as Mr., Ms., and so on. Valid values are defined in the commonLookupsLOV. |
| TitleMeaning | String | TitleMeaning of HcmContactsnames |
| PreNameAdjunct | String | Part of the name added before a person's first name. |
| Suffix | String | Part of the name appended to a person's last name such as Jr., III, and so on. |
| MiddleNames | String | Contact's middle name. |
| Honors | String | Higher qualification appended to a person's name such as PhD. |
| KnownAs | String | Contact's preferred name. |
| PreviousLastName | String | Contact's previous last name. |
| DisplayName | String | DisplayName of HcmContactsnames |
| OrderName | String | OrderName of HcmContactsnames |
| ListName | String | ListName of HcmContactsnames |
| FullName | String | FullName of HcmContactsnames |
| MilitaryRank | String | Contact's military rank. |
| NameLanguage | String | NameLanguage of HcmContactsnames |
| NameLanguageMeaning | String | NameLanguageMeaning of HcmContactsnames |
| NameInformation1 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation2 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation3 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation4 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation5 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation6 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation7 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation8 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation9 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation10 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation11 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation12 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation13 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation14 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation15 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation16 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation17 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation18 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation19 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation20 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation21 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation22 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation23 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation24 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation25 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation26 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation27 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation28 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation29 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation30 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| CreatedBy | String | CreatedBy of HcmContactsnames |
| CreationDate | Datetime | CreationDate of HcmContactsnames |
| LastUpdatedBy | String | LastUpdatedBy of HcmContactsnames |
| LastUpdateDate | Datetime | LastUpdateDate of HcmContactsnames |
| LocalPersonNameId [KEY] | Long | Surrogate identifier for the local contact's name record. |
| LocalEffectiveStartDate [KEY] | Date | Start date of the date-effective changes to the record. |
| LocalEffectiveEndDate [KEY] | Date | End date of the date-effective changes to the record. |
| LocalLegislationCode | String | Legislation code of the local language. Valid values are defined in the hcmCountriesLov. |
| LocalLegislationName | String | LocalLegislationName of HcmContactsnames |
| LocalLastName | String | Contact's last name in local language. |
| LocalFirstName | String | Contact's first name in local language. |
| LocalTitle | String | Person salutation such as Mr., Ms., and so on, in local language. Valid values are defined in the commonLookupsLOV. |
| LocalTitleMeaning | String | LocalTitleMeaning of HcmContactsnames |
| LocalPreNameAdjunct | String | Part of the name added before a person's first name in local language. |
| LocalSuffix | String | Part of the name appended to a person's last name such as Jr., III, and so on, in local language. |
| LocalMiddleNames | String | Contact's middle name in local language. |
| LocalHonors | String | Higher qualification appended to a person's name such as PhD in local language. |
| LocalKnownAs | String | Contact 's preferred name in local language. |
| LocalPreviousLastName | String | Contact 's previous last name in local language. |
| LocalDisplayName | String | LocalDisplayName of HcmContactsnames |
| LocalOrderName | String | LocalOrderName of HcmContactsnames |
| LocalListName | String | LocalListName of HcmContactsnames |
| LocalFullName | String | LocalFullName of HcmContactsnames |
| LocalMilitaryRank | String | Contact's military rank in local language. |
| LocalNameLanguage | String | Local language of the name. This is not required for global names. If you're creating a local name, you must provide the language code. |
| LocalNameLanguageMeaning | String | LocalNameLanguageMeaning of HcmContactsnames |
| LocalNameInformation1 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation2 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation3 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation4 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation5 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation6 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation7 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation8 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation9 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation10 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation11 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation12 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation13 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation14 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation15 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation16 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation17 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation18 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation19 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation20 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation21 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation22 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation23 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation24 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation25 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation26 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation27 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation28 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation29 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation30 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalCreatedBy | String | LocalCreatedBy of HcmContactsnames |
| LocalCreationDate | Datetime | LocalCreationDate of HcmContactsnames |
| LocalLastUpdatedBy | String | LocalLastUpdatedBy of HcmContactsnames |
| LocalLastUpdateDate | Datetime | LocalLastUpdateDate of HcmContactsnames |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ContactType | String | ContactType |
| EmergencyContactFlag | String | EmergencyContactFlag |
| PersonId | Long | PersonId |
| RelatedPersonId | Long | RelatedPersonId |
| RelatedPersonNumber | String | RelatedPersonNumber |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |