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 |