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 |