RecruitingTaxCreditsCandidateDetails
RecruitingTaxCreditsCandidateDetails
Columns
| Name | Type | Description |
| RequisitionNumber [KEY] | String | Job requisition's requisition number. |
| CandidateNumber [KEY] | String | Candidate's candidate number. |
| PipelineRequisitionNumber | String | Number assigned to each pipeline job requisition. |
| CandidateEmail | String | Candidate's email address. |
| FirstName | String | Candidate's first name. |
| LastName | String | Candidate's last name. |
| MiddleNames | String | Candidate's middle name. |
| NamePrefix | String | Candidate's name prefix. |
| NameSuffix | String | Candidate's name suffix. |
| Address | String | Candidate's address. |
| PhoneCountryCode | String | Candidate's phone country code in the recruiting tax credits. |
| PhoneAreaCode | String | Candidate's phone area code in the recruiting tax credits. |
| PhoneNumber | String | Candidate's phone number in the recruiting tax credits. |
| RequisitionTitle | String | Title for the job requisition. |
| RequisitionLocation | String | Job requisition primary location. |
| WorkLocation | String | Job requisition primary work location. |
| WorkLocationCode | String | Work location code in the job requisition. |
| RequisitionOrganization | String | Organization name for the job requisition. |
| Language | String | Job application language. |
| JobApplicationDate | String | Job application date. |
| PlannedStartDate | String | Candidate's planned start date. |
| ExtendedDate | String | Job offer extended date. |
| AcceptedDate | String | Job offer accepted date. |
| Salary | Double | Candidate's salary. |
| SalaryCurrency | String | Currency for the salary. |
| PayBasis | String | Salary pay basis. |
| OfferWorkLocation | String | Work location specified in the candidate job offer. |
| OfferWorkLocationCode | String | Work location code in the candidate job offer. |
| DateOfBirth | String | Candidate's date of birth. |
| CandidatePIIInformationIncludedFlag | Bool | Indicates if personally identifiable information data from candidate is included in payload. |
| CandidateToken | String | Candidate token in the recruiting tax credits candidate details. |
| ConfirmedSubmissionFlag | Bool | Indicates whether the candidate has been confirmed. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |
| PartnerId | String | partnerId |