RecruitingCandidatescandidateAddress
RecruitingCandidatescandidateAddress
Columns
Name | Type | Description |
RecruitingCandidatesCandidateNumber [KEY] | String | Finds recruiting candidate using unique ID and candidate number |
AddressLine1 | String | Address Line 1 in recruiting candidate address. |
AddressLine2 | String | Address Line 2 in recruiting candidate address. |
AddressLine3 | String | Address Line 3 in recruiting candidate address. |
City | String | City in recruiting candidate address. |
Region1 | String | Region 1 in recruiting candidate address. |
Region2 | String | Region 2 in recruiting candidate address. |
Region3 | String | Region 3 in recruiting candidate address. |
Country | String | Country in recruiting candidate address. |
PostalCode | String | Postal code in recruiting candidate address. |
LongPostalCode | String | Long postal code in recruiting candidate address. |
Building | String | Building in recruiting candidate address. |
FloorNumber | String | Floor number in recruiting candidate address. |
AddlAddressAttribute1 | String | Add Address Attribute 1 in recruiting candidate address. |
AddlAddressAttribute2 | String | Add Address Attribute 2 in recruiting candidate address. |
AddlAddressAttribute3 | String | Add Address Attribute 3 in recruiting candidate address. |
AddlAddressAttribute4 | String | Add Address Attribute 4 in recruiting candidate address. |
AddlAddressAttribute5 | String | Add Address Attribute 5 in recruiting candidate address. |
AddressId [KEY] | String | ID assigned to each recruiting candidate address. |
CreatedBy | String | Created using in recruiting candidate address. |
CreationDate | Datetime | Creation date in recruiting candidate address. |
LastUpdatedBy | String | Last update using in recruiting candidate address. |
LastUpdateDate | Datetime | Last update date in recruiting candidate address. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
CandidateNumber | String | CandidateNumber |
Finder | String | finder |
Keywords | String | keywords |
PersonId | String | personId |