RecruitingTaxCreditsCandidateDetailsaddressDetails
RecruitingTaxCreditsCandidateDetailsaddressDetails
Columns
| Name | Type | Description |
| RecruitingTaxCreditsCandidateDetailsCandidateNumber [KEY] | String | Unique ID and candidate number used to find a job application. |
| RecruitingTaxCreditsCandidateDetailsRequisitionNumber [KEY] | String | Unique ID and requisition number used to find a job application. |
| AddressLine1 | String | Address line 1 in the recruiting tax credits candidate details. |
| AddressLine2 | String | Address line 2 in the recruiting tax credits candidate details. |
| AddressLine3 | String | Address line 3 in the recruiting tax credits candidate details. |
| AddressLine4 | String | Address line 4 in the recruiting tax credits candidate details. |
| City | String | City in the recruiting tax credits candidate details. |
| Region1 | String | Region 1 in the recruiting tax credits candidate details. |
| Region2 | String | Region 2 in the recruiting tax credits candidate details. |
| Region3 | String | Region 3 in the address in the recruiting tax credits candidate details. |
| Country | String | Country in the recruiting tax credits candidate details. |
| PostalCode | String | Postal code in the recruiting tax credits candidate details. |
| LongPostalCode | String | Long postal code in the recruiting tax credits candidate details. |
| Building | String | Building in the recruiting tax credits candidate details. |
| FloorNumber | String | Floor number in the recruiting tax credits candidate details. |
| AddlAddressAttribute1 | String | Additional address attribute 1 in the recruiting tax credits candidate details. |
| AddlAddressAttribute2 | String | Additional address attribute 2 in the recruiting tax credits candidate details. |
| AddlAddressAttribute3 | String | Additional address attribute 3 in the recruiting tax credits candidate details. |
| AddlAddressAttribute4 | String | Additional address attribute 4 in the recruiting tax credits candidate details. |
| AddlAddressAttribute5 | String | Additional address attribute 5 in the recruiting tax credits candidate details. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CandidateNumber | String | CandidateNumber |
| RequisitionNumber | String | RequisitionNumber |
| CandidateNumber | String | candidateNumber |
| CandidateToken | String | candidateToken |
| Finder | String | finder |
| PartnerId | String | partnerId |
| RequisitionNumber | String | requisitionNumber |