RecruitingCandidateslicensesAndCertificates
RecruitingCandidateslicensesAndCertificates
Columns
| Name | Type | Description |
| RecruitingCandidatesCandidateNumber [KEY] | String | Finds recruiting candidate using unique ID and candidate number |
| CertificationId [KEY] | Long | Certification ID in recruiting candidate licenses and certificates. |
| Comments | String | Comments in recruiting candidate licenses and certificates. |
| RenewalInprogressFlag | Bool | Renewal in progress indicator in recruiting candidate licenses and certificates. |
| IssueDate | Date | Issue date in recruiting candidate licenses and certificates. |
| TotalAmount | Long | Total amount in recruiting candidate licenses and certificates. |
| CompletedAmount | Long | Completed amount in recruiting candidate licenses and certificates. |
| EducationalEstablishmentId | Long | Educational establishment ID in recruiting candidate licenses and certificates. |
| EducationalEstablishment | String | Educational establishment in recruiting candidate licenses and certificates. |
| RenewalDate | Date | Renewal date in recruiting candidate licenses and certificates. |
| Restrictions | String | Restrictions in recruiting candidate licenses and certificates. |
| RenewalRequiredFlag | Bool | Renewal required indicator in recruiting candidate licenses and certificates. |
| StateProvinceId | Long | State province ID in recruiting candidate licenses and certificates. |
| Title | String | Title in recruiting candidate licenses and certificates. |
| CompletedTrainingUnits | String | Completed training units in recruiting candidate licenses and certificates. |
| CertificationNumber | String | Certification number in recruiting candidate licenses and certificates. |
| VerifiedFlag | Bool | Verified indicator in recruiting candidate licenses and certificates. |
| CertificationName | String | Certification name in recruiting candidate licenses and certificates. |
| ContentItemId | Long | Content item ID in recruiting candidate licenses and certificates. |
| ExpirationDate | Date | Expiration date in recruiting candidate licenses and certificates. |
| CountryId | Long | Country ID in recruiting candidate licenses and certificates. |
| IssuedBy | String | Issued using in recruiting candidate licenses and certificates. |
| LastRenewalDate | Date | Last renewal date in recruiting candidate licenses and certificates. |
| ActualCompletionDate | Date | Actual completion date in recruiting candidate licenses and certificates. |
| SectionId | Long | Section ID in recruiting candidate licenses and certificates. |
| OriginalIssueYear | Long | Original issue year in recruiting candidate licenses and certificates. |
| Status | String | Status in recruiting candidate licenses and certificates. |
| CertificationURL | String | Certification URL in recruiting candidate licenses and certificates. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CandidateNumber | String | CandidateNumber |
| Finder | String | finder |
| Keywords | String | keywords |
| PersonId | String | personId |