HcmContactsdriverLicenses

Columns


Name	Type	Description
HcmContactsPersonId [KEY]	Long	HcmContactsPersonId of HcmContactsdriverLicenses
DriversLicenseId [KEY]	Long	DriversLicenseId of HcmContactsdriverLicenses
LicenseType	String	Type of driver's license. Valid values are defined in the commonLookupsLOV.
LicenseTypeMeaning	String	LicenseTypeMeaning of HcmContactsdriverLicenses
IssuingCountry	String	Country in which the contact's driver's license was issued. Valid values are defined in the hcmCountriesLov.
IssuingCountryName	String	IssuingCountryName of HcmContactsdriverLicenses
LicenseNumber	String	Driver's license number of the contact.
IssuingAuthority	String	Issuing authority of the contact's driver's license.
IssuingLocation	String	Location where the driver's license was issued.
FromDate	Date	Start date of the contact's driver's license.
ToDate	Date	End date of the contact's driver's license.
NumberOfPoints	Long	Number of penalty points on the license.
Violations	Long	Number of violations on the license.
LicenseSuspendedFlag	Bool	Indicates whether the contact's 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 HcmContactsdriverLicenses
CreationDate	Datetime	CreationDate of HcmContactsdriverLicenses
LastUpdatedBy	String	LastUpdatedBy of HcmContactsdriverLicenses
LastUpdateDate	Datetime	LastUpdateDate of HcmContactsdriverLicenses

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。