HcmContactspassports
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 |
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 |