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 本製品.
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 |