JobApplications
Returns a list of job applications.
Table Specific Information
Select
No filters are supported server side for this table. All criteria will be handled client side within the add-in.
For example, the following query is processed server side:
SELECT * FROM JobApplications
Columns
| Name | Type | References | Description |
| ItemID | String | ||
| RequisitionID | String | ||
| RequisitionTitle | String | ||
| ClientRequisitionID | String | ||
| InternalIndicator | Boolean | ||
| ExternalIndicator | Boolean | ||
| HiringManagerID | String | ||
| HiringManagerWorkerID | String | ||
| HiringManagerGivenName | String | ||
| HiringManagerFamilyName | String | ||
| HiringManagerFormattedName | String | ||
| ApplicationEffectiveDate | Date | ||
| ApplicationShortName | String | ||
| ApplicationCode | String | ||
| ApplicationPostingChannelID | String | ||
| ApplicationPostingChannelCode | String | ||
| ApplicationPostingChannelShortName | String | ||
| ApplicationSubmittedByAssociateOID | String | ||
| ApplicationSubmittedByGivenName | String | ||
| ApplicationSubmittedByFamilyName | String | ||
| ApplicationSubmittedDate | Date | ||
| ApplicantID | String | ||
| ApplicantInternalIndicator | Boolean | ||
| ApplicantWotcScreeningShortName | String | ||
| ApplicantWotcScreeningLongName | String | ||
| ApplicantWotcScreeningCode | String | ||
| ApplicantBackgroundScreeningLongName | String | ||
| ApplicantBackgroundScreeningCode | String | ||
| ApplicantCountryCode | String | ||
| ApplicantCityName | String | ||
| ApplicantCountrySubdivisionType | String | ||
| ApplicantCountrySubdivisionShortName | String | ||
| ApplicantCountrySubdivisionCode | String | ||
| ApplicantAddressLine1 | String | ||
| ApplicantPostalCode | String | ||
| CommunicationLandlines | String | ||
| CommunicationMobiles | String | ||
| ApplicantGivenName | String | ||
| ApplicantFamilyName | String | ||
| ApplicantFormattedName | String | ||
| AppliedLocationItemID | String | ||
| AppliedLocationCode | String | ||
| AppliedLocationShortName | String |