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 component.
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 |