RecruitingJobApplicationslicensesAndCertificates
RecruitingJobApplicationslicensesAndCertificates
Columns
Name | Type | Description |
RecruitingJobApplicationsJobApplicationId [KEY] | Long | Finds the job application using a primary key and an application ID |
Comments | String | Additional comments on the licenses and certifications acquired by the candidate. |
CertificationId [KEY] | Long | ID assigned to the licenses or certifications acquired by the candidate. |
RenewalInprogressFlag | Bool | Indicates if the licenses and certificates renewal is in progress. |
IssueDate | Date | Date when the licenses and certificates were issued. |
TotalAmount | Long | Total cost incurred for the licenses and certifications. |
CompletedAmount | Long | Percentage of completion of the course. |
EducationalEstablishmentId | Long | ID assigned to the educational establishment that conducted the course. |
EducationalEstablishment | String | Name of the educational establishment that conducted the course. |
RenewalDate | Date | Renewal date for the licenses and certificates. |
Restrictions | String | Restrictions associated with the licenses and certificates. |
RenewalRequiredFlag | Bool | Indicates if the licenses and certificates must be renewed. |
StateProvinceId | Long | ID assigned to the state or province where the licenses and certificates were issues. |
Title | String | Title of the licenses and certifications. |
CompletedTrainingUnits | String | Completed training units of the course. |
CertificationNumber | String | Number of the licenses or certifications acquired by the candidate. |
VerifiedFlag | Bool | Indicates that the licenses and certificates are verified. |
CertificationName | String | Name of the licenses or certifications acquired by the candidate. |
ContentItemId | Long | ID assigned to each item in the licenses and certificates section. |
ExpirationDate | Date | Expiration date of the licenses and certificates held by the candidate. |
CountryId | Long | ID assigned to the country where the course was done. |
IssuedBy | String | Authority issuing the licenses and certificates. |
LastRenewalDate | Date | Last date when the licenses and certificates were renewed. |
ActualCompletionDate | Date | Actual completion date of the course. |
SectionId | Long | ID assigned to each section of the licenses and certificates. |
OriginalIssueYear | Long | Year when the licenses and certificates were originally issues. |
Status | String | Status of the licenses and certifications. |
CertificationURL | String | URL of the licenses or certifications acquired by the candidate. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
EmailAddress | String | EmailAddress |
JobApplicationId | Long | JobApplicationId |
RequisitionNumber | String | RequisitionNumber |
Finder | String | finder |