JDBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9062

HcmContactsvisasPermits

HcmContactsvisasPermits

Columns

Name Type Description
HcmContactsPersonId [KEY] Long HcmContactsPersonId of HcmContactsvisasPermits
VisaPermitId [KEY] Long VisaPermitId of HcmContactsvisasPermits
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.
IssuingCountry String Country in which the contact's visa or permit was issued. Valid values are defined in the hcmCountriesLov.
IssuingCountryName String IssuingCountryName of HcmContactsvisasPermits
VisaPermitType String Type of the contact's visa or permit. Valid values are defined in the commonLookupsLOV.
VisaPermitTypeMeaning String VisaPermitTypeMeaning of HcmContactsvisasPermits
VisaPermitCategory String Category of the contact's visa or permit. Valid values are defined in the commonLookupsLOV.
VisaPermitCategoryMeaning String VisaPermitCategoryMeaning of HcmContactsvisasPermits
VisaPermitNumber String Contact's visa or permit number.
VisaPermitStatus String Indicates whether the contact's visa or permit is current. Valid values are defined in the commonLookupsLOV.
VisaPermitStatusMeaning String VisaPermitStatusMeaning of HcmContactsvisasPermits
IssuingAuthority String Issuing authority of the contact's visa or permit.
IssuingLocation String Location where the contact's visa or permit was issued.
IssueDate Date Date of issue of the contact's visa or permit.
EntryDate Date Entry date of the contact into the country.
ExpirationDate Date Expiration date of the contact's visa or permit.
VisaPermitStatusDate Date Date from when the contact's permit status is effective.
Profession String Profession of the visa or permit holder.
CreatedBy String CreatedBy of HcmContactsvisasPermits
CreationDate Datetime CreationDate of HcmContactsvisasPermits
LastUpdatedBy String LastUpdatedBy of HcmContactsvisasPermits
LastUpdateDate Datetime LastUpdateDate of HcmContactsvisasPermits
ContactType String ContactType of HcmContactsvisasPermits
EmergencyContactFlag String EmergencyContactFlag of HcmContactsvisasPermits
Finder String Finder of HcmContactsvisasPermits
PersonId Long PersonId of HcmContactsvisasPermits
RelatedPersonId Long RelatedPersonId of HcmContactsvisasPermits
RelatedPersonNumber String RelatedPersonNumber of HcmContactsvisasPermits
SysEffectiveDate String SysEffectiveDate of HcmContactsvisasPermits

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