HcmContactspassports

Columns


Name	Type	Description
HcmContactsPersonId [KEY]	Long	HcmContactsPersonId of HcmContactspassports
PassportId [KEY]	Long	PassportId of HcmContactspassports
IssuingCountry	String	Country in which the contact's passport was issued. Valid values are defined in the hcmCountriesLov.
IssuingCountryName	String	IssuingCountryName of HcmContactspassports
PassportType	String	Type or category of the contact's passport. Valid values are defined in the commonLookupsLOV.
PassportTypeMeaning	String	PassportTypeMeaning of HcmContactspassports
PassportNumber	String	Passport number of the contact.
IssuingAuthority	String	Issuing authority for the contact's passport.
IssueDate	Date	Issue date of the contact's passport.
ExpirationDate	Date	Expiration date of the contact's passport.
IssuingLocation	String	Location where the contact's passport was issued.
Profession	String	Profession of the passport holder.
CreatedBy	String	CreatedBy of HcmContactspassports
CreationDate	Datetime	CreationDate of HcmContactspassports
LastUpdatedBy	String	LastUpdatedBy of HcmContactspassports
LastUpdateDate	Datetime	LastUpdateDate of HcmContactspassports

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