RecruitingCEJobRequisitionDetails
RecruitingCEJobRequisitionDetails
Columns
Name | Type | Description |
Id [KEY] | String | ID assigned to the job requisitions and pertains to a published job. |
Title | String | Title associated with the job requisition that pertains to a published job. |
Category | String | Category of the job requisition and pertains to a published job. |
RequisitionType | String | Type of the job requisition that pertains to a published job. |
JobGrade | String | Grade of the job requisition that pertains to a published job. |
RequisitionId | Long | ID assigned to each job requisition. |
ExternalPostedStartDate | Datetime | Start date of the external posting of the job requisition and pertains to a published job. |
JobLevel | String | Level of the job requisition that pertains to a published job. |
JobSchedule | String | Schedule of the job requisition that pertains to a published job. |
JobShift | String | Shift associated with the job requisition that pertains to a published job. |
StudyLevel | String | Education level mentioned in the job requisition that pertains to a published job. |
DomesticTravelRequired | String | Indicates if domestic travel is required as per the job requisition and pertains to a published job. |
InternationalTravelRequired | String | Indicates if international travel is required for the job posting and pertains to a published job. |
ExternalContactName | String | External contact name of the candidate in the job requisition and pertains to a published job. |
ExternalContactEmail | String | External email of the candidate in the job requisition and pertains to a published job. |
ContractType | String | Type of contract of the job requisition and pertains to a published job. |
ExternalPostedEndDate | Datetime | End date of the external posting of the job requisition and pertains to a published job. |
JobFamilyId | Long | ID assigned to the job family the job requisition belongs to and pertains to a published job. |
GeographyId | Long | Geography ID assigned to the job requisitions and pertains to a published job. |
GeographyNodeId | Long | Geography node ID assigned to the job requisitions and pertains to a published job. |
ExternalDescriptionStr | String | External description string of the job requisition. |
CorporateDescriptionStr | String | Corporate description of the job requisition and pertains to a published job. |
OrganizationDescriptionStr | String | Description string for the organization in the job requisition that pertains to a published job. |
ShortDescriptionStr | String | Short description string of the job requisition that pertains to a published job. |
ContentLocale | String | Location of the content of the job requisition and pertains to a published job. |
PrimaryLocation | String | Primary location of the job requisition that pertains to a published job. |
PrimaryLocationCountry | String | Country of the primary location of the job requisition that pertains to a published job. |
ObjectVerNumberProfile | String | Object version number assigned to the profile in the job requisition that pertains to a published job. |
ApplyWhenNotPostedFlag | Bool | Indicates when a job requisition isn't posted and pertains to a published job. |
ExternalQualificationsStr | String | External qualifications string of the job requisition. |
InternalQualificationsStr | String | Internal qualifications string of the job requisition. |
InternalResponsibilitiesStr | String | Internal responsibilities string of the job requisition. |
ExternalResponsibilitiesStr | String | External responsibilities string of the job requisition. |
JobFunctionCode | String | Job function code of the published job requisition. |
HotJobFlag | Bool | Indicates whether the job requisition is considered a hot job and pertains to a published job. |
TrendingFlag | Bool | Indicates whether the job requisition has a high number of job applications and should be displayed as trending. |
BeFirstToApplyFlag | Bool | Indicates whether the job requisition has a low number of job applications and should invite candidates to be the first to apply. |
WorkplaceTypeCode | String | Code of the workplace type of the job requisition. |
WorkplaceType | String | Label of the workplace type of the job requisition. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Finder | String | finder |
SiteNumber | String | siteNumber |