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 |