RecruitingOppMktJobDetails
RecruitingOppMktJobDetails
Columns
| Name | Type | Description |
| RequisitionId [KEY] | Long | Requisition ID of a job in opportunity marketplace |
| RequisitionNumber | String | Requisition number of a job in opportunity marketplace. |
| Title | String | Job title of a job in opportunity marketplace. |
| PublishJobStartDate | Datetime | Date when the job is published in opportunity marketplace. |
| PublishJobEndDate | Datetime | Date when the job is no longer published in opportunity marketplace. |
| Description | String | Description of the job requisition in opportunity marketplace. |
| JobFamilyName | String | Name of the job family of a job in opportunity marketplace. |
| JobGradeName | String | Name of the job grade of a job in opportunity marketplace. |
| JobShiftName | String | Name of the job shift of a job in opportunity marketplace. |
| FullPartTimeName | String | Full time or part time job in opportunity marketplace. |
| OrganizationName | String | Name of the organization of a job in opportunity marketplace. |
| BookmarkFlag | Bool | Indicates whether the job is a job in opportunity marketplace. |
| HasAppliedFlag | Bool | Indicates whether the person has already applied to a job in opportunity marketplace. The default value is 0 |
| RequisitionValidFlag | Bool | Indicates whether the requisition is valid in opportunity marketplace. The default value is 1 |
| Responsibilities | String | Responsibilities of the job requisition. |
| Qualifications | String | Qualifications of the job requisition. |
| PrimaryLocationFlatName | String | Name of the primary location of a job in opportunity marketplace. |
| PrimaryWorkLocationName | String | Name of the primary work location of a job in opportunity marketplace. |
| TravelRequiredFlag | Bool | Indicates whether the job requires travel in opportunity marketplace. |
| DescriptionStr | String | Plain string value of the job requisition description in opportunity marketplace. |
| EmployerDescriptionStr | String | Plain string value of the employer description of a job requisition in opportunity marketplace. |
| OrganizationDescriptionStr | String | Plain string value of the organization description of a job requisition in opportunity marketplace. |
| JobShareId | Long | ID of the job requisition being shared in opportunity marketplace. |
| JobShareURL | String | URL of the job page in opportunity marketplace. |
| InternallyPostedFlag | Bool | Indicates whether the job requisition is posted internally in opportunity marketplace. Default value is 0. |
| ExternallyPostedFlag | Bool | Indicate whether the job requisition is posted externally in opportunity marketplace. Default value is 0. |
| QualificationsStr | String | String value of the job requisition qualifications. |
| ResponsibilitiesStr | String | String value of the job requisition responsibilities. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |