JDBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9062

WorkersdriverLicenses

WorkersdriverLicenses

Columns

Name Type Description
WorkersPersonId [KEY] Long WorkersPersonId of WorkersdriverLicenses
DriversLicenseId [KEY] Long DriversLicenseId of WorkersdriverLicenses
LicenseType String Type of license. Valid values are defined in the commonLookupsLOV.
LicenseTypeMeaning String LicenseTypeMeaning of WorkersdriverLicenses
IssuingCountry String Country in which the driver's license was issued. Valid values are defined in the hcmCountriesLov.
IssuingCountryName String IssuingCountryName of WorkersdriverLicenses
LicenseNumber String Driver's license number.
IssuingAuthority String Issuing authority of the driver's license.
IssuingLocation String Location where the driver's license was issued.
FromDate Date Date from when the driver's license is valid.
ToDate Date Date until when the driver's license is valid.
NumberOfPoints Long Number of penalty points on the license.
Violations Long Number of violations on the license.
LicenseSuspendedFlag Bool Indicates whether the driver's license is suspended.
SuspendedFromDate Date Start date of suspension period, if any.
SuspendedToDate Date End date of suspension period, if any.
CreatedBy String CreatedBy of WorkersdriverLicenses
CreationDate Datetime CreationDate of WorkersdriverLicenses
LastUpdatedBy String LastUpdatedBy of WorkersdriverLicenses
LastUpdateDate Datetime LastUpdateDate of WorkersdriverLicenses
AssignmentId Long AssignmentId of WorkersdriverLicenses
AssignmentName String AssignmentName of WorkersdriverLicenses
AssignmentNumber String AssignmentNumber of WorkersdriverLicenses
DirectReportsFlag String DirectReportsFlag of WorkersdriverLicenses
Finder String Finder of WorkersdriverLicenses
LineManagerFlag String LineManagerFlag of WorkersdriverLicenses
PersonId Long PersonId of WorkersdriverLicenses
PersonNumber String PersonNumber of WorkersdriverLicenses
PrimaryAssignmentFlag String PrimaryAssignmentFlag of WorkersdriverLicenses
RelationshipType String RelationshipType of WorkersdriverLicenses
SysEffectiveDate String SysEffectiveDate of WorkersdriverLicenses
WorkerType String WorkerType of WorkersdriverLicenses
EffectiveDate Date EffectiveDate of WorkersdriverLicenses

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