RecruitingJobRequisitions
RecruitingJobRequisitions
Columns
| Name | Type | Description |
| RequisitionNumber | String | Requisition Number in recruiting job requisitions. |
| RequisitionId [KEY] | Long | Requisition ID in recruiting job requisitions. |
| Title | String | Title in recruiting job requisitions. |
| OtherRequisitionTitle | String | Other Requisition Title in recruiting job requisitions. |
| RecruitingType | String | Recruiting Type in recruiting job requisitions. |
| TemplateId | Long | Template ID in recruiting job requisitions. |
| PipelineRequisition | String | Pipeline Requisition in recruiting job requisitions. |
| PipelineRequisitionId | Long | Pipeline Requisition ID in recruiting job requisitions. |
| StateId | Long | State ID in recruiting job requisitions. |
| StateName | String | State Name in recruiting job requisitions. |
| PhaseId | Long | Phase ID in recruiting job requisitions. |
| PhaseName | String | Phase Name in recruiting job requisitions. |
| PositionId | Long | Position ID in recruiting job requisitions. |
| UnlimitedOpenings | String | Unlimited Openings in recruiting job requisitions. |
| NumberOfOpenings | Int | Number Of Openings in recruiting job requisitions. |
| HiredCount | Int | Hired Count in recruiting job requisitions. |
| ApplyWhenNotPosted | String | Apply When Not Posted in recruiting job requisitions. |
| BusinessJustification | String | Business justification in recruiting job requisitions. |
| Comments | String | Comments in recruiting job requisitions. |
| DisplayInOrgChart | String | Display In Org Chart in recruiting job requisitions. |
| HiringManagerId | Long | Hiring Manager ID in recruiting job requisitions. |
| HiringManagerAssignmentId | Long | Hiring Manager Assignment ID in recruiting job requisitions. |
| RecruiterId | Long | Recruiter ID in recruiting job requisitions. |
| RecruiterAssignmentId | Long | Recruiter Assignment ID in recruiting job requisitions. |
| ProfileId | Long | Profile ID in recruiting job requisitions. |
| OrganizationId | Long | Organization ID in recruiting job requisitions. |
| JobFamilyId | Long | Job Family ID in recruiting job requisitions. |
| JobFunction | String | Job Function in recruiting job requisitions. |
| BusinessUnitId | Long | Business unit ID in recruiting job requisitions. |
| DepartmentId | Long | Department ID in recruiting job requisitions. |
| PrimaryWorkLocationId | Long | Primary Work Location ID in recruiting job requisitions. |
| PrimaryLocationId | Long | Primary Location ID in recruiting job requisitions. |
| JobId | Long | Job ID in recruiting job requisitions. |
| GradeId | Long | Grade ID in recruiting job requisitions. |
| LegalEmployerId | Long | Legal Employer ID in recruiting job requisitions. |
| BudgetCurrency | String | Budget Currency in recruiting job requisitions. |
| EmployeeReferralBonus | Double | Employee Referral Bonus in recruiting job requisitions. |
| SourcingBudget | Double | Sourcing Budget in recruiting job requisitions. |
| TravelBudget | Double | Travel Budget in recruiting job requisitions. |
| RelocationBudget | Double | Relocation Budget in recruiting job requisitions. |
| CompensationCurrency | String | Compensation Currency in recruiting job requisitions. |
| MinimumSalary | Double | Minimum Salary in recruiting job requisitions. |
| MaximumSalary | Double | Maximum Salary in recruiting job requisitions. |
| PayFrequency | String | Pay Frequency in recruiting job requisitions. |
| WorkerType | String | Worker Type in recruiting job requisitions. |
| RegularOrTemporary | String | Regular Or Temporary in recruiting job requisitions. |
| ManagementLevel | String | Management Level in recruiting job requisitions. |
| FullTimeOrPartTime | String | Full Time Or Part Time in recruiting job requisitions. |
| JobShift | String | Job Shift in recruiting job requisitions. |
| JobType | String | Job Type in recruiting job requisitions. |
| EducationLevel | String | Education Level in recruiting job requisitions. |
| InternalShortDescription | String | Internal Short Description in recruiting job requisitions. |
| InternalDescription | String | Internal Description in recruiting job requisitions. |
| InternalDescriptionHTML | String | Internal Description HTML in recruiting job requisitions. |
| InternalContactName | String | Internal Contact Name in recruiting job requisitions. |
| InternalContactEmail | String | Internal Contact Email in recruiting job requisitions. |
| ExternalShortDescription | String | External Short Description in recruiting job requisitions. |
| ExternalDescription | String | External Description in recruiting job requisitions. |
| ExternalDescriptionHTML | String | External Description HTML in recruiting job requisitions. |
| ExternalContactName | String | External Contact Name in recruiting job requisitions. |
| ExternalContactEmail | String | External Contact Email in recruiting job requisitions. |
| EmployerInternalDescriptionId | Long | Employer Internal Description ID in recruiting job requisitions. |
| EmployerExternalDescriptionId | Long | Employer External Description ID in recruiting job requisitions. |
| RecruitingOrganizationInternalDescriptionId | Long | Recruiting Organization Internal Description ID in recruiting job requisitions. |
| RecruitingOrganizationExternalDescriptionId | Long | Recruiting Organization External Description ID in recruiting job requisitions. |
| InternalPublishedJobStartDate | Datetime | Internal Published Job Start Date in recruiting job requisitions. |
| InternalPublishedJobEndDate | Datetime | Internal Published Job End Date in recruiting job requisitions. |
| InternalPublishedJobStatus | String | Internal Published Job Status in recruiting job requisitions. |
| ExternalPublishedJobStartDate | Datetime | External Published Job Start Date in recruiting job requisitions. |
| ExternalPublishedJobEndDate | Datetime | External Published Job End Date in recruiting job requisitions. |
| ExternalPublishedJobStatus | String | External Published Job Status in recruiting job requisitions. |
| ExternalApplicationFlowId | Long | External Application Flow ID in recruiting job requisitions. |
| CandidateSelectionProcessId | Long | Candidate Selection Process ID in recruiting job requisitions. |
| RequisitionLastModifiedDate | Datetime | Requisition Last Modified Date in recruiting job requisitions. |
| CreatedBy | String | Create job requisitions. |
| CreationDate | Datetime | Creation Date in recruiting job requisitions. |
| LastUpdatedBy | String | Last Update using in recruiting job requisitions. |
| LastUpdateDate | Datetime | Last Update Date in recruiting job requisitions. |
| AutomaticallyOpenRequisitionForSourcing | String | Determines if a job requisition is opened automatically for sourcing and if the job is posted internally and externally. |
| DelayBeforePostingExpires | Int | Determines the number of days of delay before the job posting expires. The value can't be higher than 0 if the job requisition isn't configured to be posted automatically. |
| InternalResp | String | Responsibilities for internal candidates in recruiting job requisitions. |
| InternalRespHTML | String | HTML representation of responsibilities for internal candidates in recruiting job requisitions. |
| ExternalResp | String | Responsibilities for external candidates in recruiting job requisitions. |
| ExternalRespHTML | String | HTML representation of responsibilities for external candidates in recruiting job requisitions. |
| InternalRespStr | String | String representation of responsibilities for internal candidates in recruiting job requisitions. |
| ExternalRespStr | String | String representation of responsibilities for external candidates in recruiting job requisitions. |
| ExternalQual | String | Qualifications for external candidates in recruiting job requisitions. |
| ExternalQualHTML | String | HTML representation of qualifications for external candidates in recruiting job requisitions. |
| InternalQual | String | Qualifications for internal candidates in recruiting job requisitions. |
| InternalQualHTML | String | HTML representation of qualifications for internal candidates in recruiting job requisitions. |
| InternalQualStr | String | String representation of qualifications for internal candidates in recruiting job requisitions. |
| ExternalQualStr | String | String representation of qualifications for external candidates in recruiting job requisitions. |
| WorkplaceTypeCode | String | Code of the workplace type of the job requisition. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |