RecruitingJobOffers
RecruitingJobOffers
Columns
| Name | Type | Description |
| OfferId [KEY] | Long | ID assigned to each job offer. |
| OfferName | String | Name for each job offer. |
| Description | String | Description of the job offer. |
| Comments | String | Additional comments about the job offer. |
| HireDate | Date | Date of hiring the candidate. |
| ExpirationDate | Datetime | Date when the job offer will expire. |
| EsignatureInstructions | String | Instructions for the candidate's electronic signature. |
| AdditionalTextOne | String | Additional text one. |
| AdditionalTextTwo | String | Additional text two. |
| StateId | Long | ID assigned to each state of recruitment. |
| StateName | String | Name for each state of recruitment. |
| PhaseId | Long | ID assigned to each phase of the job offer. |
| PhaseName | String | Name of each phase of the job offer. |
| AcceptedOnBehalfFlag | Bool | Indicates if the offer was accepted on behalf of the candidate. |
| AcceptedOnBehalfPersonId | Long | ID assigned to the individual who accepted the job offer on behalf of the candidate. |
| AcceptedOnBehalfDate | Datetime | Date when the job offer was accepted on behalf of the candidate. |
| AssignmentOfferId | Long | ID assigned to the assignment offer. |
| HiringManagerId | Long | ID assigned to the hiring manager. |
| HiringManagerAssignmentId | Long | ID given to the assignment of the hiring manager. |
| RecruiterId | Long | ID assigned to each recruiter. |
| RecruiterAssignmentId | Long | ID assigned to each assignment given to a recruiter. |
| OfferLetterLayoutId | Long | ID assigned to each offer letter layout. |
| JobApplicationId | Long | ID assigned for each job application. |
| RequisitionId | Long | ID assigned to each requisition. |
| CandidatePersonId | Long | Person ID assigned to the candidate. |
| CreatedBy | String | Name of the person who created the job offer. |
| CreationDate | Datetime | Date when the job offer was created. |
| LastUpdatedBy | String | Person who last updated the job offer. |
| LastUpdateDate | Datetime | Date when the job offer was last updated. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |