HcmContactscitizenships

Columns


Name	Type	Description
HcmContactsPersonId [KEY]	Long	HcmContactsPersonId of HcmContactscitizenships
CitizenshipId [KEY]	Long	CitizenshipId of HcmContactscitizenships
Citizenship	String	Citizenship legislation code. Valid values are defined in the hcmCountriesLov.
CitizenshipMeaning	String	CitizenshipMeaning of HcmContactscitizenships
FromDate	Date	Date from when the contact citizenship is valid.
ToDate	Date	Date until when the contact citizenship is valid.
CitizenshipStatus	String	Status of the contact citizenship. Valid values are defined in the commonLookupsLOV.
CitizenshipStatusMeaning	String	CitizenshipStatusMeaning of HcmContactscitizenships
CreatedBy	String	CreatedBy of HcmContactscitizenships
CreationDate	Datetime	CreationDate of HcmContactscitizenships
LastUpdatedBy	String	LastUpdatedBy of HcmContactscitizenships
LastUpdateDate	Datetime	LastUpdateDate of HcmContactscitizenships

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