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