ODBC Driver for Oracle Fusion Cloud HCM

Build 23.0.8839

HcmContactsnationalIdentifiers

HcmContactsnationalIdentifiers

Columns

Name Type Description
HcmContactsPersonId [KEY] Long HcmContactsPersonId of HcmContactsnationalIdentifiers
NationalIdentifierId [KEY] Long NationalIdentifierId of HcmContactsnationalIdentifiers
LegislationCode String Legislation code of the contact's national identifier. Valid values are defined in the hcmCountriesLov.
LegislationName String LegislationName of HcmContactsnationalIdentifiers
NationalIdentifierType String Type of national identifier. Valid values are defined in the commonLookupsLOV.
NationalIdentifierTypeMeaning String NationalIdentifierTypeMeaning of HcmContactsnationalIdentifiers
NationalIdentifierNumber String National identification number of the contact.
IssueDate Date Issue date of the contact's national identifier.
ExpirationDate Date Expiration date of the contact's national identifier.
PlaceOfIssue String Place where the contact's national identifier was issued.
CreatedBy String CreatedBy of HcmContactsnationalIdentifiers
CreationDate Datetime CreationDate of HcmContactsnationalIdentifiers
LastUpdatedBy String LastUpdatedBy of HcmContactsnationalIdentifiers
LastUpdateDate Datetime LastUpdateDate of HcmContactsnationalIdentifiers
PrimaryFlag Bool Indicates whether the national identifier is the contact's primary national identifier.

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839