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 |