RecruitingMyJobReferrals
RecruitingMyJobReferrals
Columns
| Name | Type | Description |
| ReferralId [KEY] | Long | Referral ID in opportunity marketplace. |
| RequisitionId | Long | Requisition ID of the referred job in opportunity marketplace. |
| ReferrerPersonId | Long | Person ID of the referrer in opportunity marketplace. |
| CandidatePersonId | Long | Candidate person ID of the referred candidate in opportunity marketplace. |
| SubmissionId | Long | Submission ID of the referral in opportunity marketplace. |
| ShareId | Long | Share ID of the referrer in opportunity marketplace. |
| ReferralTypeCode | String | Referral type in opportunity marketplace. |
| CandidateTypeCode | String | Candidate type of the referred candidate in opportunity marketplace. |
| Title | String | Title of the referral in opportunity marketplace. |
| CreationDate | Datetime | Creation date of the referral in opportunity marketplace. |
| DisplayName | String | Display name of the referral in opportunity marketplace. |
| ListName | String | List name of the referral in opportunity marketplace. |
| Notes | String | Notes entered by the referrer in opportunity marketplace. |
| Rating | Double | Rating of the referral in opportunity marketplace. |
| Status | String | Status of the referral in opportunity marketplace. |
| Message | String | Message entered by the referrer in opportunity marketplace. |
| RequisitionNumber | String | Requisition unique number in opportunity marketplace. |
| ExternalPublishJobStatus | String | External status of the referred job in opportunity marketplace. |
| IntPublishJobStatus | String | Internal status of the referred job in opportunity marketplace. |
| PublicStatus | String | Public status of the referral in opportunity marketplace. |
| CandidateNumber | String | Candidate number of the referred candidate in opportunity marketplace. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |