GET http://localhost/api/positions?limit=50&page=1

Response
200 OK
IP
172.22.0.1
Profiled on
Token
333bb7

Query Metrics

45 Database Queries
28 Different statements
23.12 ms Query time
9 Invalid entities
526 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.47 ms 
SELECT t0.id AS id_1, t0.token AS token_2, t0.jti AS jti_3, t0.usedAt AS usedAt_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deletedAt AS deletedAt_7, t0.userId AS userId_8 FROM SSOTokens t0 WHERE t0.token = ? AND ((t0.deletedAt IS NULL)) LIMIT 1
Parameters: 
[
  "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3OTA2MjAwNTIsImV4cCI6MTc5MDcwNjQ1Miwicm9sZXMiOlsiUk9MRV9BRE1JTklTVFJBVE9SIl0sImlkIjo2NTcsIm9yZ2FuaXphdGlvbklkIjozLCJ0aW1lWm9uZSI6bnVsbH0.GRZkero3yfy1xUgWfi2u6ggNCYDYccBqI3V7SbmsgjoaIAlHbpRHAcYxZnD2dbKYPAarFaFeqwUMXcek_124AiHIuTuYCSZ7ohlzphsxTkFIdwS8UEv_SKnI9r84EPanmFGhkhPHCpWeGvby3bCzp_KtwRF7WjHFKP8OyJST6S7eUfAg54BcYWNUAgs3CkcrHVaPzwIeHxCYgM8EHl4__m6tFf05ZRufYeVDA-GYd6igDbWwit9yt6VhoOxWT-GuS-3h6ZPwaCF86MF16Bn6lwHROswL3F6JtvUO08Csa-vm8s7yLhhPxERdtHh1yCAATbuk5mcPGrIUIoL2lf7yNT37ZoZm_bJMeHxA43IySTW7k3teJ52q6j3MuDhc7tmtIZ3EHHY81wgwX8W5B065Hd_oGIKy6HJFozqZ5AqLQs1WAwpN6mF22G9p0gkkCuOpFdwvZyENdFKX7mV5rUmnf6IEnv_umL-1Bl0-Lk8eAg2F_wRgb-axd5dBtiPwuPOGEueDsYRD5a-bqRTtjPhakUH6_r-up04xtM1qQw0202AZRv3fYu3tqIOrIl7N0OQP-WVCm7JqvSu2RPt3-aX2QPps7B-PcOYdfmU8442EUeLFIREgJE1fU4aRKIO_um_nmsS4BiNTuxO33x3liETrdRS4iAogWLjQ6nt7tYKr-z8"
]
View formatted query    View runnable query    Explain query
2 0.47 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.confirmation_token AS confirmation_token_3, u0_.password_requested_at AS password_requested_at_4, u0_.authIP AS authIP_5, u0_.enabled AS enabled_6, u0_.isLocked AS isLocked_7, u0_.isAuthy AS isAuthy_8, u0_.lastLogin AS lastLogin_9, u0_.createdAt AS createdAt_10, u0_.updatedAt AS updatedAt_11, u0_.deletedAt AS deletedAt_12, u0_.jobNotificationName AS jobNotificationName_13, u0_.jobNotificationFrequency AS jobNotificationFrequency_14, u0_.jobNotificationLastSentAt AS jobNotificationLastSentAt_15, u0_.jobNotificationSetAt AS jobNotificationSetAt_16, u0_.unsubscribeToken AS unsubscribeToken_17, u0_.jobNotificationChannel AS jobNotificationChannel_18, u0_.organizationId AS organizationId_19 FROM Users u0_ INNER JOIN OrganizationUsers o1_ ON u0_.id = o1_.userId AND (o1_.deletedAt IS NULL) WHERE (u0_.id = ?) AND (u0_.deletedAt IS NULL) LIMIT 1
Parameters: 
[
  "657"
]
View formatted query    View runnable query    Explain query
3 0.44 ms 
SELECT t0.id AS id_1, t0.isDefault AS isDefault_2, t0.isExpired AS isExpired_3, t0.archivedAt AS archivedAt_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deletedAt AS deletedAt_7, t0.userId AS userId_8, t0.organizationId AS organizationId_9 FROM OrganizationUsers t0 WHERE t0.userId = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  657
]
View formatted query    View runnable query    Explain query
4 0.26 ms 
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.deletedAt AS deletedAt_4, t0.roleId AS roleId_5, t0.organizationUserId AS organizationUserId_6 FROM OrganizationUserRoles t0 WHERE t0.organizationUserId = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  721
]
View formatted query    View runnable query    Explain query
5 0.30 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.identifier AS identifier_3, t0.sequence AS sequence_4, t0.locked AS locked_5, t0.visibility AS visibility_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.deletedAt AS deletedAt_9, t0.organizationId AS organizationId_10, t0.masterRoleId AS masterRoleId_11 FROM Roles t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
6 0.54 ms 
SELECT t0.id AS id_1, t0.clientRegistrationPolicy AS clientRegistrationPolicy_2, t0.identifier AS identifier_3, t0.label AS label_4, t0.description AS description_5, t0.logoUrl AS logoUrl_6, t0.endpoint AS endpoint_7, t0.credentials AS credentials_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t12.id AS id_13, t12.status AS status_14, t12.tagline AS tagline_15, t12.overview AS overview_16, t12.logoUrl AS logoUrl_17, t12.heroMediaUrl AS heroMediaUrl_18, t12.videoUrl AS videoUrl_19, t12.links AS links_20, t12.requirementsText AS requirementsText_21, t12.connectsToLabel AS connectsToLabel_22, t12.subscriptionNote AS subscriptionNote_23, t12.accessType AS accessType_24, t12.languages AS languages_25, t12.featured AS featured_26, t12.displayOrder AS displayOrder_27, t12.deprecated AS deprecated_28, t12.createdAt AS createdAt_29, t12.updatedAt AS updatedAt_30, t12.deletedAt AS deletedAt_31, t12.providerId AS providerId_32, t12.publisherId AS publisherId_33 FROM Providers t0 LEFT JOIN ProviderListings t12 ON t12.providerId = t0.id AND ((t12.deletedAt IS NULL)) WHERE t0.identifier = ? AND ((t0.deletedAt IS NULL)) LIMIT 1
Parameters: 
[
  "ORGANIZATION_SETTINGS"
]
View formatted query    View runnable query    Explain query
7 0.90 ms 
SELECT
                DataPointTypes.`identifier` AS `dataPointTypeIdentifier`,
                COALESCE(Organizations.`id`, rootOrganization.`id`, systemRootOrganization.`id`) `organizationId`,
                PlanTypes.`identifier` `planTypeIdentifier`,
                Providers.`identifier` `providerIdentifier`,
                ProviderSettings.`description`,
                ProviderSettings.`identifier`,
                ProviderSettings.`label`,
                ProviderSettings.`aiFeatureId`,
                IF(ProviderSettingViewTypes.`id` IS NULL, 0, 1) `hasClientServiceViewType`,
                IF(OrganizationProviderSettings.`id` IS NULL, 0, 1) `hasOrganizationOverride`,
                COALESCE(OrganizationProviderSettings.`value`, PlanTypeProviderSettings.`value`, rootOrganizationProviderSettings.`value`, systemRootOrganizationProviderSettings.`value`) `value`,
                COALESCE(
                    PlanTypeProviderSettings.`value`,
                    rootOrganizationProviderSettings.`value`,
                    systemRootOrganizationProviderSettings.`value`
                ) `defaultValue`,
                /*
                 * Which level the inherited default came from, mirroring the COALESCE
                 * above. The value alone cannot say: a UI telling a customer where a
                 * setting comes from has to distinguish "your plan includes this" from
                 * "this is the default for every organization", and those carry very
                 * different weight when someone is deciding whether to override it.
                 */
                CASE
                    WHEN PlanTypeProviderSettings.`value` IS NOT NULL THEN 'plan'
                    WHEN rootOrganizationProviderSettings.`value` IS NOT NULL THEN 'domain'
                    WHEN systemRootOrganizationProviderSettings.`value` IS NOT NULL THEN 'system'
                    ELSE NULL
                END `defaultSource`
            FROM `Organizations`
            LEFT JOIN `PlanTypes`
                ON PlanTypes.`id` = Organizations.`planTypeId`
                AND PlanTypes.`deletedAt` IS NULL
            JOIN `RootDomains`
                ON RootDomains.`id` = Organizations.`rootDomainId`
            JOIN `Organizations` rootOrganization
                ON rootOrganization.`id` = RootDomains.`mainOrganizationId`
            JOIN `Organizations` systemRootOrganization
                ON systemRootOrganization.`identifier` = ?
            JOIN `Providers`
                ON Providers.`id` = ?
            JOIN `ProviderSettings`
                ON ProviderSettings.`providerId` = Providers.`id`
                AND ProviderSettings.`deletedAt` IS NULL
            JOIN `DataPointTypes`
                ON DataPointTypes.`id` = ProviderSettings.`dataPointTypeId`
            JOIN `ViewTypes`
                ON ViewTypes.`identifier` = ?
            LEFT JOIN `ProviderSettingViewTypes`
                ON ProviderSettingViewTypes.`providerSettingId` = ProviderSettings.`id`
                AND ProviderSettingViewTypes.`viewTypeId` = ViewTypes.`id`
                AND ProviderSettingViewTypes.`deletedAt` IS NULL
            LEFT JOIN `OrganizationProviderSettings`
                ON OrganizationProviderSettings.`organizationId` = Organizations.`id`
                AND OrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND OrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `PlanTypeProviderSettings`
                ON PlanTypeProviderSettings.`planTypeId` = PlanTypes.`id`
                AND PlanTypeProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND PlanTypeProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` rootOrganizationProviderSettings
                ON rootOrganizationProviderSettings.`organizationId` = rootOrganization.`id`
                AND rootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND rootOrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` systemRootOrganizationProviderSettings
                ON systemRootOrganizationProviderSettings.`organizationId` = systemRootOrganization.`id`
                AND systemRootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND systemRootOrganizationProviderSettings.`deletedAt` IS NULL
            WHERE Organizations.`id` = ?
                AND Providers.`id` = ?
                AND NOT (OrganizationProviderSettings.`id` IS NULL AND PlanTypeProviderSettings.`id` IS NULL AND rootOrganizationProviderSettings.`id` IS NULL AND systemRootOrganizationProviderSettings.`id` IS NULL)
         AND ProviderSettings.`identifier` IN (?) GROUP BY ProviderSettings.`id`
Parameters: 
[
  "EXACTHIRE"
  5
  "CLIENT_SERVICES"
  3
  5
  "OPERATING_MODE"
]
View formatted query    View runnable query    Explain query
8 0.28 ms 
SELECT t0.id AS id_1, t0.clientRegistrationPolicy AS clientRegistrationPolicy_2, t0.identifier AS identifier_3, t0.label AS label_4, t0.description AS description_5, t0.logoUrl AS logoUrl_6, t0.endpoint AS endpoint_7, t0.credentials AS credentials_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t12.id AS id_13, t12.status AS status_14, t12.tagline AS tagline_15, t12.overview AS overview_16, t12.logoUrl AS logoUrl_17, t12.heroMediaUrl AS heroMediaUrl_18, t12.videoUrl AS videoUrl_19, t12.links AS links_20, t12.requirementsText AS requirementsText_21, t12.connectsToLabel AS connectsToLabel_22, t12.subscriptionNote AS subscriptionNote_23, t12.accessType AS accessType_24, t12.languages AS languages_25, t12.featured AS featured_26, t12.displayOrder AS displayOrder_27, t12.deprecated AS deprecated_28, t12.createdAt AS createdAt_29, t12.updatedAt AS updatedAt_30, t12.deletedAt AS deletedAt_31, t12.providerId AS providerId_32, t12.publisherId AS publisherId_33 FROM Providers t0 LEFT JOIN ProviderListings t12 ON t12.providerId = t0.id AND ((t12.deletedAt IS NULL)) WHERE t0.identifier = ? AND ((t0.deletedAt IS NULL)) LIMIT 1
Parameters: 
[
  "ORGANIZATION_SETTINGS"
]
View formatted query    View runnable query    Explain query
9 0.72 ms 
SELECT
                DataPointTypes.`identifier` AS `dataPointTypeIdentifier`,
                COALESCE(Organizations.`id`, rootOrganization.`id`, systemRootOrganization.`id`) `organizationId`,
                PlanTypes.`identifier` `planTypeIdentifier`,
                Providers.`identifier` `providerIdentifier`,
                ProviderSettings.`description`,
                ProviderSettings.`identifier`,
                ProviderSettings.`label`,
                ProviderSettings.`aiFeatureId`,
                IF(ProviderSettingViewTypes.`id` IS NULL, 0, 1) `hasClientServiceViewType`,
                IF(OrganizationProviderSettings.`id` IS NULL, 0, 1) `hasOrganizationOverride`,
                COALESCE(OrganizationProviderSettings.`value`, PlanTypeProviderSettings.`value`, rootOrganizationProviderSettings.`value`, systemRootOrganizationProviderSettings.`value`) `value`,
                COALESCE(
                    PlanTypeProviderSettings.`value`,
                    rootOrganizationProviderSettings.`value`,
                    systemRootOrganizationProviderSettings.`value`
                ) `defaultValue`,
                /*
                 * Which level the inherited default came from, mirroring the COALESCE
                 * above. The value alone cannot say: a UI telling a customer where a
                 * setting comes from has to distinguish "your plan includes this" from
                 * "this is the default for every organization", and those carry very
                 * different weight when someone is deciding whether to override it.
                 */
                CASE
                    WHEN PlanTypeProviderSettings.`value` IS NOT NULL THEN 'plan'
                    WHEN rootOrganizationProviderSettings.`value` IS NOT NULL THEN 'domain'
                    WHEN systemRootOrganizationProviderSettings.`value` IS NOT NULL THEN 'system'
                    ELSE NULL
                END `defaultSource`
            FROM `Organizations`
            LEFT JOIN `PlanTypes`
                ON PlanTypes.`id` = Organizations.`planTypeId`
                AND PlanTypes.`deletedAt` IS NULL
            JOIN `RootDomains`
                ON RootDomains.`id` = Organizations.`rootDomainId`
            JOIN `Organizations` rootOrganization
                ON rootOrganization.`id` = RootDomains.`mainOrganizationId`
            JOIN `Organizations` systemRootOrganization
                ON systemRootOrganization.`identifier` = ?
            JOIN `Providers`
                ON Providers.`id` = ?
            JOIN `ProviderSettings`
                ON ProviderSettings.`providerId` = Providers.`id`
                AND ProviderSettings.`deletedAt` IS NULL
            JOIN `DataPointTypes`
                ON DataPointTypes.`id` = ProviderSettings.`dataPointTypeId`
            JOIN `ViewTypes`
                ON ViewTypes.`identifier` = ?
            LEFT JOIN `ProviderSettingViewTypes`
                ON ProviderSettingViewTypes.`providerSettingId` = ProviderSettings.`id`
                AND ProviderSettingViewTypes.`viewTypeId` = ViewTypes.`id`
                AND ProviderSettingViewTypes.`deletedAt` IS NULL
            LEFT JOIN `OrganizationProviderSettings`
                ON OrganizationProviderSettings.`organizationId` = Organizations.`id`
                AND OrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND OrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `PlanTypeProviderSettings`
                ON PlanTypeProviderSettings.`planTypeId` = PlanTypes.`id`
                AND PlanTypeProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND PlanTypeProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` rootOrganizationProviderSettings
                ON rootOrganizationProviderSettings.`organizationId` = rootOrganization.`id`
                AND rootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND rootOrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` systemRootOrganizationProviderSettings
                ON systemRootOrganizationProviderSettings.`organizationId` = systemRootOrganization.`id`
                AND systemRootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND systemRootOrganizationProviderSettings.`deletedAt` IS NULL
            WHERE Organizations.`id` = ?
                AND Providers.`id` = ?
                AND NOT (OrganizationProviderSettings.`id` IS NULL AND PlanTypeProviderSettings.`id` IS NULL AND rootOrganizationProviderSettings.`id` IS NULL AND systemRootOrganizationProviderSettings.`id` IS NULL)
         AND ProviderSettings.`identifier` IN (?) GROUP BY ProviderSettings.`id`
Parameters: 
[
  "EXACTHIRE"
  5
  "CLIENT_SERVICES"
  3
  5
  "MANAGED_RECRUITER_MODE"
]
View formatted query    View runnable query    Explain query
10 0.36 ms 
SELECT t0.id AS id_1, t0.clientRegistrationPolicy AS clientRegistrationPolicy_2, t0.identifier AS identifier_3, t0.label AS label_4, t0.description AS description_5, t0.logoUrl AS logoUrl_6, t0.endpoint AS endpoint_7, t0.credentials AS credentials_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t12.id AS id_13, t12.status AS status_14, t12.tagline AS tagline_15, t12.overview AS overview_16, t12.logoUrl AS logoUrl_17, t12.heroMediaUrl AS heroMediaUrl_18, t12.videoUrl AS videoUrl_19, t12.links AS links_20, t12.requirementsText AS requirementsText_21, t12.connectsToLabel AS connectsToLabel_22, t12.subscriptionNote AS subscriptionNote_23, t12.accessType AS accessType_24, t12.languages AS languages_25, t12.featured AS featured_26, t12.displayOrder AS displayOrder_27, t12.deprecated AS deprecated_28, t12.createdAt AS createdAt_29, t12.updatedAt AS updatedAt_30, t12.deletedAt AS deletedAt_31, t12.providerId AS providerId_32, t12.publisherId AS publisherId_33 FROM Providers t0 LEFT JOIN ProviderListings t12 ON t12.providerId = t0.id AND ((t12.deletedAt IS NULL)) WHERE t0.identifier = ? AND ((t0.deletedAt IS NULL)) LIMIT 1
Parameters: 
[
  "ORGANIZATION_SETTINGS"
]
View formatted query    View runnable query    Explain query
11 0.92 ms 
SELECT
                DataPointTypes.`identifier` AS `dataPointTypeIdentifier`,
                COALESCE(Organizations.`id`, rootOrganization.`id`, systemRootOrganization.`id`) `organizationId`,
                PlanTypes.`identifier` `planTypeIdentifier`,
                Providers.`identifier` `providerIdentifier`,
                ProviderSettings.`description`,
                ProviderSettings.`identifier`,
                ProviderSettings.`label`,
                ProviderSettings.`aiFeatureId`,
                IF(ProviderSettingViewTypes.`id` IS NULL, 0, 1) `hasClientServiceViewType`,
                IF(OrganizationProviderSettings.`id` IS NULL, 0, 1) `hasOrganizationOverride`,
                COALESCE(OrganizationProviderSettings.`value`, PlanTypeProviderSettings.`value`, rootOrganizationProviderSettings.`value`, systemRootOrganizationProviderSettings.`value`) `value`,
                COALESCE(
                    PlanTypeProviderSettings.`value`,
                    rootOrganizationProviderSettings.`value`,
                    systemRootOrganizationProviderSettings.`value`
                ) `defaultValue`,
                /*
                 * Which level the inherited default came from, mirroring the COALESCE
                 * above. The value alone cannot say: a UI telling a customer where a
                 * setting comes from has to distinguish "your plan includes this" from
                 * "this is the default for every organization", and those carry very
                 * different weight when someone is deciding whether to override it.
                 */
                CASE
                    WHEN PlanTypeProviderSettings.`value` IS NOT NULL THEN 'plan'
                    WHEN rootOrganizationProviderSettings.`value` IS NOT NULL THEN 'domain'
                    WHEN systemRootOrganizationProviderSettings.`value` IS NOT NULL THEN 'system'
                    ELSE NULL
                END `defaultSource`
            FROM `Organizations`
            LEFT JOIN `PlanTypes`
                ON PlanTypes.`id` = Organizations.`planTypeId`
                AND PlanTypes.`deletedAt` IS NULL
            JOIN `RootDomains`
                ON RootDomains.`id` = Organizations.`rootDomainId`
            JOIN `Organizations` rootOrganization
                ON rootOrganization.`id` = RootDomains.`mainOrganizationId`
            JOIN `Organizations` systemRootOrganization
                ON systemRootOrganization.`identifier` = ?
            JOIN `Providers`
                ON Providers.`id` = ?
            JOIN `ProviderSettings`
                ON ProviderSettings.`providerId` = Providers.`id`
                AND ProviderSettings.`deletedAt` IS NULL
            JOIN `DataPointTypes`
                ON DataPointTypes.`id` = ProviderSettings.`dataPointTypeId`
            JOIN `ViewTypes`
                ON ViewTypes.`identifier` = ?
            LEFT JOIN `ProviderSettingViewTypes`
                ON ProviderSettingViewTypes.`providerSettingId` = ProviderSettings.`id`
                AND ProviderSettingViewTypes.`viewTypeId` = ViewTypes.`id`
                AND ProviderSettingViewTypes.`deletedAt` IS NULL
            LEFT JOIN `OrganizationProviderSettings`
                ON OrganizationProviderSettings.`organizationId` = Organizations.`id`
                AND OrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND OrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `PlanTypeProviderSettings`
                ON PlanTypeProviderSettings.`planTypeId` = PlanTypes.`id`
                AND PlanTypeProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND PlanTypeProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` rootOrganizationProviderSettings
                ON rootOrganizationProviderSettings.`organizationId` = rootOrganization.`id`
                AND rootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND rootOrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` systemRootOrganizationProviderSettings
                ON systemRootOrganizationProviderSettings.`organizationId` = systemRootOrganization.`id`
                AND systemRootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND systemRootOrganizationProviderSettings.`deletedAt` IS NULL
            WHERE Organizations.`id` = ?
                AND Providers.`id` = ?
                AND NOT (OrganizationProviderSettings.`id` IS NULL AND PlanTypeProviderSettings.`id` IS NULL AND rootOrganizationProviderSettings.`id` IS NULL AND systemRootOrganizationProviderSettings.`id` IS NULL)
         AND ProviderSettings.`identifier` IN (?) GROUP BY ProviderSettings.`id`
Parameters: 
[
  "EXACTHIRE"
  5
  "CLIENT_SERVICES"
  3
  5
  "FULL_SERVICE_HIRING"
]
View formatted query    View runnable query    Explain query
12 0.77 ms 
SELECT t0.id AS id_1, t0.locked AS locked_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.deletedAt AS deletedAt_5, t0.permissionId AS permissionId_6, t7.id AS id_8, t7.label AS label_9, t7.description AS description_10, t7.identifier AS identifier_11, t7.visibility AS visibility_12, t7.displayOrder AS displayOrder_13, t7.createdAt AS createdAt_14, t7.updatedAt AS updatedAt_15, t7.deletedAt AS deletedAt_16, t7.subSystemId AS subSystemId_17, t7.permissionTypeId AS permissionTypeId_18, t0.roleId AS roleId_19 FROM RolePermissions t0 LEFT JOIN Permissions t7 ON t0.permissionId = t7.id AND ((t7.deletedAt IS NULL)) WHERE t0.roleId = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
13 0.18 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.confirmation_token AS confirmation_token_4, t0.password_requested_at AS password_requested_at_5, t0.authIP AS authIP_6, t0.enabled AS enabled_7, t0.isLocked AS isLocked_8, t0.isAuthy AS isAuthy_9, t0.lastLogin AS lastLogin_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deletedAt AS deletedAt_13, t0.jobNotificationName AS jobNotificationName_14, t0.jobNotificationFrequency AS jobNotificationFrequency_15, t0.jobNotificationLastSentAt AS jobNotificationLastSentAt_16, t0.jobNotificationSetAt AS jobNotificationSetAt_17, t0.unsubscribeToken AS unsubscribeToken_18, t0.jobNotificationChannel AS jobNotificationChannel_19, t0.organizationId AS organizationId_20 FROM Users t0 WHERE t0.id = ?
Parameters: 
[
  657
]
View formatted query    View runnable query    Explain query
14 0.11 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
15 0.26 ms 
INSERT INTO HttpLogs (type, userAgent, device, os, osVersion, routeName, url, method, status, appVersion, data, formData, IpAddress, createdAt, updatedAt, deletedAt, userId, organizationId, requestId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "REQUEST"
  null
  ""
  "UNK"
  "UNK"
  "get_positions"
  "http://localhost/api/positions?limit=50&page=1"
  "GET"
  null
  "1.0.0"
  Symfony\Component\HttpFoundation\Request {#13
    __toString(): """
      GET /api/positions?page=1&limit=50 HTTP/1.1\r\n
      Accept:         */*\r\n
      Authorization:  Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3OTA2MjAwNTIsImV4cCI6MTc5MDcwNjQ1Miwicm9sZXMiOlsiUk9MRV9BRE1JTklTVFJBVE9SIl0sImlkIjo2NTcsIm9yZ2FuaXphdGlvbklkIjozLCJ0aW1lWm9uZSI6bnVsbH0.GRZkero3yfy1xUgWfi2u6ggNCYDYccBqI3V7SbmsgjoaIAlHbpRHAcYxZnD2dbKYPAarFaFeqwUMXcek_124AiHIuTuYCSZ7ohlzphsxTkFIdwS8UEv_SKnI9r84EPanmFGhkhPHCpWeGvby3bCzp_KtwRF7WjHFKP8OyJST6S7eUfAg54BcYWNUAgs3CkcrHVaPzwIeHxCYgM8EHl4__m6tFf05ZRufYeVDA-GYd6igDbWwit9yt6VhoOxWT-GuS-3h6ZPwaCF86MF16Bn6lwHROswL3F6JtvUO08Csa-vm8s7yLhhPxERdtHh1yCAATbuk5mcPGrIUIoL2lf7yNT37ZoZm_bJMeHxA43IySTW7k3teJ52q6j3MuDhc7tmtIZ3EHHY81wgwX8W5B065Hd_oGIKy6HJFozqZ5AqLQs1WAwpN6mF22G9p0gkkCuOpFdwvZyENdFKX7mV5rUmnf6IEnv_umL-1Bl0-Lk8eAg2F_wRgb-axd5dBtiPwuPOGEueDsYRD5a-bqRTtjPhakUH6_r-up04xtM1qQw0202AZRv3fYu3tqIOrIl7N0OQP-WVCm7JqvSu2RPt3-aX2QPps7B-PcOYdfmU8442EUeLFIREgJE1fU4aRKIO_um_nmsS4BiNTuxO33x3liETrdRS4iAogWLjQ6nt7tYKr-z8\r\n
      Host:           localhost\r\n
      User-Agent:     curl/8.5.0\r\n
      X-Php-Ob-Level: 0\r\n
      \r\n
      """
  }
  ""
  "172.22.0.1"
  "2026-09-28 21:20:50"
  "2026-09-28 21:20:50"
  null
  657
  3
  null
]
View formatted query    View runnable query
16 0.13 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
17 0.28 ms 
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.description AS description_2, r0_.isVisible AS isVisible_3, r0_.isExportable AS isExportable_4, r0_.isSystemDefault AS isSystemDefault_5, r0_.routeUrl AS routeUrl_6, r0_.displayOrder AS displayOrder_7, r0_.filterSettings AS filterSettings_8, r0_.archivedAt AS archivedAt_9, r0_.createdAt AS createdAt_10, r0_.updatedAt AS updatedAt_11, r0_.deletedAt AS deletedAt_12, r0_.parentId AS parentId_13, r0_.reportTypeId AS reportTypeId_14, r0_.userId AS userId_15, r0_.organizationId AS organizationId_16 FROM Reports r0_ INNER JOIN ReportTypes r1_ ON r0_.reportTypeId = r1_.id AND (r1_.deletedAt IS NULL) INNER JOIN Organizations o2_ ON r0_.organizationId = o2_.id AND (o2_.deletedAt IS NULL) WHERE ((r0_.isVisible = 1 AND r0_.archivedAt IS NULL AND (o2_.identifier = ? OR o2_.id = ?) AND r0_.id = ?)) AND (r0_.deletedAt IS NULL) LIMIT 1
Parameters: 
[
  "EXACTHIRE"
  3
  null
]
View formatted query    View runnable query    Explain query
18 0.16 ms 
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.resource AS resource_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deletedAt AS deletedAt_6 FROM DataPointResources t0 WHERE t0.identifier = ? LIMIT 1
Parameters: 
[
  "POSITION"
]
View formatted query    View runnable query    Explain query
19 0.13 ms 
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.resource AS resource_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deletedAt AS deletedAt_6 FROM DataPointResources t0 WHERE t0.identifier = ? LIMIT 1
Parameters: 
[
  "USER"
]
View formatted query    View runnable query    Explain query
20 0.31 ms 
SELECT
                LocationScopes.id AS id0, LocationScopes.resourceId AS resourceId1, LocationScopes.createdAt AS createdAt2, LocationScopes.updatedAt AS updatedAt3, LocationScopes.deletedAt AS deletedAt4, LocationScopes.archivedAt AS archivedAt5, LocationScopes.locationId AS locationId6, LocationScopes.dataPointResourceId AS dataPointResourceId7, LocationScopes.userId AS userId8, LocationScopes.organizationId AS organizationId9
            FROM
                `LocationScopes`
            JOIN
                `Locations` ON Locations.`id` = LocationScopes.`locationId`
                AND Locations.`deletedAt` IS NULL
            WHERE
                LocationScopes.`organizationId` = ?
            AND
                LocationScopes.`resourceId` = ?
            AND
                LocationScopes.`dataPointResourceId` = ?
            AND
                LocationScopes.`deletedAt` IS NULL
Parameters: 
[
  3
  657
  23
]
View formatted query    View runnable query    Explain query
21 0.25 ms 
SELECT Locations.id AS id, Locations.name AS name, Locations.description AS description, Locations.street1 AS street1, Locations.street2 AS street2, Locations.street3 AS street3, Locations.masterLocationId AS masterLocationId, Locations.postalCode AS postalCode, Locations.createdAt AS createdAt, Locations.updatedAt AS updatedAt, Locations.archivedAt AS archivedAt, Locations.deletedAt AS deletedAt, Locations.latitude AS latitude, Locations.longitude AS longitude, Locations.cityId AS cityId, Locations.stateId AS stateId, Locations.countryId AS countryId, Locations.organizationId AS organizationId, Locations.userId AS userId FROM Locations WHERE masterLocationId = ? AND name = ?   LIMIT 1
Parameters: 
[
  1
  "All"
]
View formatted query    View runnable query    Explain query
22 0.27 ms 
SELECT
                TagScopes.id AS id0, TagScopes.resourceId AS resourceId1, TagScopes.createdAt AS createdAt2, TagScopes.updatedAt AS updatedAt3, TagScopes.deletedAt AS deletedAt4, TagScopes.archivedAt AS archivedAt5, TagScopes.dataPointId AS dataPointId6, TagScopes.dataPointOptionId AS dataPointOptionId7, TagScopes.userId AS userId8, TagScopes.organizationId AS organizationId9, TagScopes.dataPointResourceId AS dataPointResourceId10
            FROM
                `TagScopes`
            JOIN
                `DataPointOptions` ON DataPointOptions.`id` = TagScopes.`dataPointOptionId`
                AND DataPointOptions.`deletedAt` IS NULL
            WHERE
                TagScopes.`organizationId` = ?
            AND
                TagScopes.`resourceId` = ?
            AND
                TagScopes.`dataPointResourceId` = ?
            AND
                TagScopes.`deletedAt` IS NULL
Parameters: 
[
  3
  657
  23
]
View formatted query    View runnable query    Explain query
23 0.21 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.identifier = ? LIMIT 1
Parameters: 
[
  "ORGANIZATION_TAGS_ALL"
]
View formatted query    View runnable query    Explain query
24 0.16 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.identifier = ? LIMIT 1
Parameters: 
[
  "ORGANIZATION_TAGS_ALL"
]
View formatted query    View runnable query    Explain query
25 0.55 ms 
SELECT DISTINCT `Positions`.`id`
            FROM
                `Positions`
                
                
                
                
                
            WHERE
                `Positions`.`organizationId` = ?
                
            AND
                `Positions`.`deletedAt` IS NULL
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
26 2.95 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.json AS json_2, p0_.startDate AS startDate_3, p0_.endDate AS endDate_4, p0_.statusUpdatedAt AS statusUpdatedAt_5, p0_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_6, p0_.isFullServiceHiring AS isFullServiceHiring_7, p0_.fillBy AS fillBy_8, p0_.numberOfHires AS numberOfHires_9, p0_.isTemplate AS isTemplate_10, p0_.isGeneralApplication AS isGeneralApplication_11, p0_.isImported AS isImported_12, p0_.archivedAt AS archivedAt_13, p0_.createdAt AS createdAt_14, p0_.updatedAt AS updatedAt_15, p0_.deletedAt AS deletedAt_16, p0_.locationTypeUpdatedAt AS locationTypeUpdatedAt_17, p1_.id AS id_18, p1_.isPrimary AS isPrimary_19, p1_.createdAt AS createdAt_20, p1_.updatedAt AS updatedAt_21, p1_.deletedAt AS deletedAt_22, l2_.id AS id_23, l2_.name AS name_24, l2_.description AS description_25, l2_.street1 AS street1_26, l2_.street2 AS street2_27, l2_.street3 AS street3_28, l2_.masterLocationId AS masterLocationId_29, l2_.postalCode AS postalCode_30, l2_.createdAt AS createdAt_31, l2_.updatedAt AS updatedAt_32, l2_.archivedAt AS archivedAt_33, l2_.deletedAt AS deletedAt_34, l2_.latitude AS latitude_35, l2_.longitude AS longitude_36 FROM Positions p0_ INNER JOIN Organizations o3_ ON p0_.organizationId = o3_.id LEFT JOIN DataPointOptions d4_ ON p0_.statusId = d4_.id INNER JOIN PositionLocations p1_ ON p0_.id = p1_.positionId AND (p1_.deletedAt IS NULL) INNER JOIN Locations l2_ ON p1_.locationId = l2_.id LEFT JOIN HiringTeamManagers h5_ ON p0_.id = h5_.positionId LEFT JOIN DataPointOptions d6_ ON p0_.locationTypeId = d6_.id WHERE o3_.id = ? AND p0_.parentId IS NULL AND p0_.isTemplate = ? AND (p0_.archivedAt IS NULL) AND (p0_.deletedAt IS NULL) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND (p1_.deletedAt IS NULL AND h5_.deletedAt IS NULL) ORDER BY p0_.id DESC, p0_.id DESC) dctrn_result) dctrn_table
Parameters: 
[
  3
  0
  19
  20
  21
  22
  23
  24
  25
  26
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
  41
  42
  43
  44
  45
  46
  47
  48
  52
  53
  54
  55
  67
  68
  69
  70
  71
  72
  75
  76
  77
  78
  79
  80
  81
  82
  83
  84
  85
  86
  87
  88
  89
  90
  91
  92
  93
  94
  95
  96
  97
  98
  99
  860
  861
  866
  867
  868
  869
  870
  871
  872
  873
  874
  875
  876
  877
  878
  879
  880
  881
  882
  883
  884
  885
  886
  887
  888
  889
  891
  892
  893
  894
  895
  896
  897
  898
  899
  900
  905
  906
  907
  908
  909
  910
  921
  922
  923
  924
  925
  926
  927
  930
  931
  932
  933
  934
  935
  936
  937
  944
  945
  976
  977
  996
  997
  1000
  1001
  1006
  1007
  1008
  1009
  1010
  1011
  1012
  1013
  1014
  1015
  1024
  1025
  1026
  1027
  1028
  1029
  1030
  1031
  1036
  1037
  1038
  1039
  1040
  1041
  1052
  1053
  1058
  1059
  1062
  1067
  1068
  1071
  1072
  1073
  1074
  1075
  1076
  1077
  1078
  1079
  1963
  1964
  1965
  1966
  2014
  2015
  2016
  2017
  2018
  2019
  2022
  2023
  2024
  2025
  2026
  2027
]
View formatted query    View runnable query    Explain query
27 2.85 ms 
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.json AS json_2, p0_.startDate AS startDate_3, p0_.endDate AS endDate_4, p0_.statusUpdatedAt AS statusUpdatedAt_5, p0_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_6, p0_.isFullServiceHiring AS isFullServiceHiring_7, p0_.fillBy AS fillBy_8, p0_.numberOfHires AS numberOfHires_9, p0_.isTemplate AS isTemplate_10, p0_.isGeneralApplication AS isGeneralApplication_11, p0_.isImported AS isImported_12, p0_.archivedAt AS archivedAt_13, p0_.createdAt AS createdAt_14, p0_.updatedAt AS updatedAt_15, p0_.deletedAt AS deletedAt_16, p0_.locationTypeUpdatedAt AS locationTypeUpdatedAt_17, p1_.id AS id_18, p1_.isPrimary AS isPrimary_19, p1_.createdAt AS createdAt_20, p1_.updatedAt AS updatedAt_21, p1_.deletedAt AS deletedAt_22, l2_.id AS id_23, l2_.name AS name_24, l2_.description AS description_25, l2_.street1 AS street1_26, l2_.street2 AS street2_27, l2_.street3 AS street3_28, l2_.masterLocationId AS masterLocationId_29, l2_.postalCode AS postalCode_30, l2_.createdAt AS createdAt_31, l2_.updatedAt AS updatedAt_32, l2_.archivedAt AS archivedAt_33, l2_.deletedAt AS deletedAt_34, l2_.latitude AS latitude_35, l2_.longitude AS longitude_36, o3_.id AS id_37, o3_.name AS name_38, o3_.identifier AS identifier_39, o3_.loginSubdomain AS loginSubdomain_40, o3_.contractExpires AS contractExpires_41, o3_.telephone AS telephone_42, o3_.email AS email_43, o3_.theme AS theme_44, o3_.active AS active_45, o3_.isDemoSite AS isDemoSite_46, o3_.isARootOrganization AS isARootOrganization_47, o3_.remoteOrganizationId AS remoteOrganizationId_48, o3_.partnerArchivedAt AS partnerArchivedAt_49, o3_.createdAt AS createdAt_50, o3_.updatedAt AS updatedAt_51, o3_.deletedAt AS deletedAt_52, o3_.retainDataTo AS retainDataTo_53, o3_.lastLoginAt AS lastLoginAt_54, o3_.aiCreditLimit AS aiCreditLimit_55, o3_.aiCreditsUsed AS aiCreditsUsed_56, o3_.aiCreditResetDate AS aiCreditResetDate_57, o3_.aiCreditResetDay AS aiCreditResetDay_58, o3_.aiEnabled AS aiEnabled_59, h4_.id AS id_60, h4_.createdAt AS createdAt_61, h4_.updatedAt AS updatedAt_62, h4_.deletedAt AS deletedAt_63 FROM Positions p0_ INNER JOIN Organizations o3_ ON p0_.organizationId = o3_.id LEFT JOIN DataPointOptions d5_ ON p0_.statusId = d5_.id INNER JOIN PositionLocations p1_ ON p0_.id = p1_.positionId AND (p1_.deletedAt IS NULL) INNER JOIN Locations l2_ ON p1_.locationId = l2_.id LEFT JOIN HiringTeamManagers h4_ ON p0_.id = h4_.positionId LEFT JOIN DataPointOptions d6_ ON p0_.locationTypeId = d6_.id WHERE o3_.id = ? AND p0_.parentId IS NULL AND p0_.isTemplate = ? AND (p0_.archivedAt IS NULL) AND (p0_.deletedAt IS NULL) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND (p1_.deletedAt IS NULL AND h4_.deletedAt IS NULL)) dctrn_result_inner ORDER BY id_0 DESC, id_0 DESC) dctrn_result LIMIT 50
Parameters: 
[
  3
  0
  19
  20
  21
  22
  23
  24
  25
  26
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
  41
  42
  43
  44
  45
  46
  47
  48
  52
  53
  54
  55
  67
  68
  69
  70
  71
  72
  75
  76
  77
  78
  79
  80
  81
  82
  83
  84
  85
  86
  87
  88
  89
  90
  91
  92
  93
  94
  95
  96
  97
  98
  99
  860
  861
  866
  867
  868
  869
  870
  871
  872
  873
  874
  875
  876
  877
  878
  879
  880
  881
  882
  883
  884
  885
  886
  887
  888
  889
  891
  892
  893
  894
  895
  896
  897
  898
  899
  900
  905
  906
  907
  908
  909
  910
  921
  922
  923
  924
  925
  926
  927
  930
  931
  932
  933
  934
  935
  936
  937
  944
  945
  976
  977
  996
  997
  1000
  1001
  1006
  1007
  1008
  1009
  1010
  1011
  1012
  1013
  1014
  1015
  1024
  1025
  1026
  1027
  1028
  1029
  1030
  1031
  1036
  1037
  1038
  1039
  1040
  1041
  1052
  1053
  1058
  1059
  1062
  1067
  1068
  1071
  1072
  1073
  1074
  1075
  1076
  1077
  1078
  1079
  1963
  1964
  1965
  1966
  2014
  2015
  2016
  2017
  2018
  2019
  2022
  2023
  2024
  2025
  2026
  2027
]
View formatted query    View runnable query    Explain query
28 1.64 ms 
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.json AS json_2, p0_.startDate AS startDate_3, p0_.endDate AS endDate_4, p0_.statusUpdatedAt AS statusUpdatedAt_5, p0_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_6, p0_.isFullServiceHiring AS isFullServiceHiring_7, p0_.fillBy AS fillBy_8, p0_.numberOfHires AS numberOfHires_9, p0_.isTemplate AS isTemplate_10, p0_.isGeneralApplication AS isGeneralApplication_11, p0_.isImported AS isImported_12, p0_.archivedAt AS archivedAt_13, p0_.createdAt AS createdAt_14, p0_.updatedAt AS updatedAt_15, p0_.deletedAt AS deletedAt_16, p0_.locationTypeUpdatedAt AS locationTypeUpdatedAt_17, p1_.id AS id_18, p1_.isPrimary AS isPrimary_19, p1_.createdAt AS createdAt_20, p1_.updatedAt AS updatedAt_21, p1_.deletedAt AS deletedAt_22, l2_.id AS id_23, l2_.name AS name_24, l2_.description AS description_25, l2_.street1 AS street1_26, l2_.street2 AS street2_27, l2_.street3 AS street3_28, l2_.masterLocationId AS masterLocationId_29, l2_.postalCode AS postalCode_30, l2_.createdAt AS createdAt_31, l2_.updatedAt AS updatedAt_32, l2_.archivedAt AS archivedAt_33, l2_.deletedAt AS deletedAt_34, l2_.latitude AS latitude_35, l2_.longitude AS longitude_36, p0_.parentId AS parentId_37, p0_.copiedFromId AS copiedFromId_38, p0_.statusId AS statusId_39, p0_.organizationDepartmentId AS organizationDepartmentId_40, p0_.organizationId AS organizationId_41, p0_.templateId AS templateId_42, p0_.userId AS userId_43, p0_.locationTypeId AS locationTypeId_44, p1_.locationId AS locationId_45, p1_.positionId AS positionId_46, l2_.cityId AS cityId_47, l2_.stateId AS stateId_48, l2_.countryId AS countryId_49, l2_.organizationId AS organizationId_50, l2_.userId AS userId_51 FROM Positions p0_ INNER JOIN Organizations o3_ ON p0_.organizationId = o3_.id LEFT JOIN DataPointOptions d4_ ON p0_.statusId = d4_.id INNER JOIN PositionLocations p1_ ON p0_.id = p1_.positionId AND (p1_.deletedAt IS NULL) INNER JOIN Locations l2_ ON p1_.locationId = l2_.id LEFT JOIN HiringTeamManagers h5_ ON p0_.id = h5_.positionId LEFT JOIN DataPointOptions d6_ ON p0_.locationTypeId = d6_.id WHERE o3_.id = ? AND p0_.parentId IS NULL AND p0_.isTemplate = ? AND (p0_.archivedAt IS NULL) AND (p0_.deletedAt IS NULL) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND (p1_.deletedAt IS NULL AND h5_.deletedAt IS NULL) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id DESC, p0_.id DESC
Parameters: 
[
  3
  0
  19
  20
  21
  22
  23
  24
  25
  26
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
  41
  42
  43
  44
  45
  46
  47
  48
  52
  53
  54
  55
  67
  68
  69
  70
  71
  72
  75
  76
  77
  78
  79
  80
  81
  82
  83
  84
  85
  86
  87
  88
  89
  90
  91
  92
  93
  94
  95
  96
  97
  98
  99
  860
  861
  866
  867
  868
  869
  870
  871
  872
  873
  874
  875
  876
  877
  878
  879
  880
  881
  882
  883
  884
  885
  886
  887
  888
  889
  891
  892
  893
  894
  895
  896
  897
  898
  899
  900
  905
  906
  907
  908
  909
  910
  921
  922
  923
  924
  925
  926
  927
  930
  931
  932
  933
  934
  935
  936
  937
  944
  945
  976
  977
  996
  997
  1000
  1001
  1006
  1007
  1008
  1009
  1010
  1011
  1012
  1013
  1014
  1015
  1024
  1025
  1026
  1027
  1028
  1029
  1030
  1031
  1036
  1037
  1038
  1039
  1040
  1041
  1052
  1053
  1058
  1059
  1062
  1067
  1068
  1071
  1072
  1073
  1074
  1075
  1076
  1077
  1078
  1079
  1963
  1964
  1965
  1966
  2014
  2015
  2016
  2017
  2018
  2019
  2022
  2023
  2024
  2025
  2026
  2027
  2026
  2024
  2022
  2018
  2016
  2014
  1965
  1963
  1078
  1075
  1073
  1071
  1067
  1052
  1040
  1038
  1036
  1030
  1028
  1026
  1024
  1014
  1012
  1010
  1008
  1006
  1000
  996
  976
  936
  934
  930
  926
  924
  909
  907
  905
  899
  897
  895
  893
  888
  886
  884
  882
  880
  878
  876
  873
  871
]
View formatted query    View runnable query    Explain query
29 0.27 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
30 0.11 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
31 0.09 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
32 0.08 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
33 0.08 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  11951
]
View formatted query    View runnable query    Explain query
34 0.07 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  11950
]
View formatted query    View runnable query    Explain query
35 0.07 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  11949
]
View formatted query    View runnable query    Explain query
36 0.09 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
37 0.47 ms 
SELECT
            positionNote.`positionId` AS positionId
        FROM
            `PositionNotes` positionNote
        JOIN
            `Positions` position ON position.`id` = positionNote.`positionId`
        WHERE
            positionNote.`deletedAt` IS NULL
        AND
            positionNote.`positionId` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
        AND 
            position.`organizationId` = ?
        GROUP BY positionId LIMIT 30
Parameters: 
[
  2026
  2024
  2022
  2018
  2016
  2014
  1965
  1963
  1078
  1075
  1073
  1071
  1067
  1052
  1040
  1038
  1036
  1030
  1028
  1026
  1024
  1014
  1012
  1010
  1008
  1006
  1000
  996
  976
  936
  934
  930
  926
  924
  909
  907
  905
  899
  897
  895
  893
  888
  886
  884
  882
  880
  878
  876
  873
  871
  3
]
View formatted query    View runnable query    Explain query
38 0.16 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.description AS description_4, t0.identifier AS identifier_5, t0.displayOrder AS displayOrder_6, t0.isLocked AS isLocked_7, t0.archivedAt AS archivedAt_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t0.dataPointId AS dataPointId_12, t0.parentId AS parentId_13, t0.organizationId AS organizationId_14 FROM DataPointOptions t0 WHERE t0.identifier = ? AND ((t0.deletedAt IS NULL)) LIMIT 1
Parameters: 
[
  "ORGANIZATION_MULTISTEP_STEP_1"
]
View formatted query    View runnable query    Explain query
39 0.87 ms 
SELECT COUNT(a0_.id) AS sclr_0, p1_.id AS id_1 FROM Applications a0_ INNER JOIN Positions p1_ ON a0_.positionId = p1_.id AND (p1_.deletedAt IS NULL) WHERE (a0_.positionId IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a0_.isDisqualified = 0 AND a0_.submittedAt IS NOT NULL AND (a0_.templateStageId IS NULL OR a0_.templateStageId = ?)) AND (a0_.deletedAt IS NULL) GROUP BY p1_.id
Parameters: 
[
  2026
  2024
  2022
  2018
  2016
  2014
  1965
  1963
  1078
  1075
  1073
  1071
  1067
  1052
  1040
  1038
  1036
  1030
  1028
  1026
  1024
  1014
  1012
  1010
  1008
  1006
  1000
  996
  976
  936
  934
  930
  926
  924
  909
  907
  905
  899
  897
  895
  893
  888
  886
  884
  882
  880
  878
  876
  873
  871
  283
]
View formatted query    View runnable query    Explain query
40 0.94 ms 
SELECT COUNT(a0_.id) AS sclr_0, p1_.id AS id_1 FROM Applications a0_ INNER JOIN Positions p1_ ON a0_.positionId = p1_.id AND (p1_.deletedAt IS NULL) WHERE (a0_.positionId IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a0_.submittedAt IS NOT NULL AND (a0_.templateStageId IS NULL OR a0_.templateStageId = ?)) AND (a0_.deletedAt IS NULL) GROUP BY p1_.id
Parameters: 
[
  2026
  2024
  2022
  2018
  2016
  2014
  1965
  1963
  1078
  1075
  1073
  1071
  1067
  1052
  1040
  1038
  1036
  1030
  1028
  1026
  1024
  1014
  1012
  1010
  1008
  1006
  1000
  996
  976
  936
  934
  930
  926
  924
  909
  907
  905
  899
  897
  895
  893
  888
  886
  884
  882
  880
  878
  876
  873
  871
  283
]
View formatted query    View runnable query    Explain query
41 0.28 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.confirmation_token AS confirmation_token_4, t0.password_requested_at AS password_requested_at_5, t0.authIP AS authIP_6, t0.enabled AS enabled_7, t0.isLocked AS isLocked_8, t0.isAuthy AS isAuthy_9, t0.lastLogin AS lastLogin_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deletedAt AS deletedAt_13, t0.jobNotificationName AS jobNotificationName_14, t0.jobNotificationFrequency AS jobNotificationFrequency_15, t0.jobNotificationLastSentAt AS jobNotificationLastSentAt_16, t0.jobNotificationSetAt AS jobNotificationSetAt_17, t0.unsubscribeToken AS unsubscribeToken_18, t0.jobNotificationChannel AS jobNotificationChannel_19, t0.organizationId AS organizationId_20 FROM Users t0 WHERE t0.id = ?
Parameters: 
[
  657
]
View formatted query    View runnable query    Explain query
42 0.22 ms 
SELECT t0.id AS id_1, t0.type AS type_2, t0.userAgent AS userAgent_3, t0.device AS device_4, t0.os AS os_5, t0.osVersion AS osVersion_6, t0.routeName AS routeName_7, t0.url AS url_8, t0.method AS method_9, t0.status AS status_10, t0.appVersion AS appVersion_11, t0.data AS data_12, t0.formData AS formData_13, t0.IpAddress AS IpAddress_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deletedAt AS deletedAt_17, t0.userId AS userId_18, t0.organizationId AS organizationId_19, t0.requestId AS requestId_20 FROM HttpLogs t0 WHERE t0.id = ?
Parameters: 
[
  208991
]
View formatted query    View runnable query    Explain query
43 0.08 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
44 2.12 ms 
INSERT INTO HttpLogs (type, userAgent, device, os, osVersion, routeName, url, method, status, appVersion, data, formData, IpAddress, createdAt, updatedAt, deletedAt, userId, organizationId, requestId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "RESPONSE"
  null
  ""
  "UNK"
  "UNK"
  "get_positions"
  "http://localhost/api/positions?limit=50&page=1"
  "GET"
  200
  "1.0.0"
  Symfony\Component\HttpFoundation\Response {#14734
    __toString(): """
      HTTP/1.1 200 OK\r\n
      Cache-Control: no-cache, private\r\n
      Content-Type:  application/json\r\n
      Date:          Mon, 28 Sep 2026 21:20:50 GMT\r\n
      X-Debug-Token: 333bb7\r\n
      \r\n
      {"code":200,"message":null,"content":{"positions":[{"template":{"id":892},"decoded_description":"<p>Test job template creation<\/p>","full_location":{"parent_id":706,"name":"Remote","postal_code":"00000","street1":"Remote","street2":"","street3":"","description":"<p>Remote location<\/p>","city":{"id":392,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.768403","longitude":"-86.158068","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":1556,"is_primary":false,"created_at":"2025-08-31T02:46:00+00:00","updated_at":"2025-08-31T02:46:00+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-08-31T02:46:00+00:00"},"is_general_application":false,"id":2026,"title":"Test Job iFrame","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2025-08-31T02:46:00+00:00","updated_at":"2025-12-01T19:38:45+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>If I approve this job with a job job approval group, set it to Active, then delete the Job Approval Group, then Pause the Job, Then try to set the job to Active, the error occurs.<br \/><br \/>I should be able to set the job back to Active once it has been approved. The error prevents this since it can not find the approved job approval since there is a join on the deleted Job Approval Group aka the Workflow.<\/p>","full_location":{"parent_id":684,"name":"Fishers Indiana","postal_code":"46038","street1":"8924 East 116th Street","street2":null,"street3":null,"description":"<p>Fishers Indiana<\/p>","city":{"id":11,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.957382","longitude":"-86.012038","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":1555,"is_primary":false,"created_at":"2025-08-15T18:19:02+00:00","updated_at":"2025-04-22T21:27:23+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-22T21:27:23+00:00"},"is_general_application":false,"id":2024,"title":"Testing Job Approval Group","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2025-08-15T18:19:02+00:00","updated_at":"2025-08-15T18:22:50+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>If I approve this job with a job job approval group, set it to Active, then delete the Job Approval Group, then Pause the Job, Then try to set the job to Active, the error occurs.<br \/><br \/>I should be able to set the job back to Active once it has been approved. The error prevents this since it can not find the approved job approval since there is a join on the deleted Job Approval Group aka the Workflow.<\/p>","full_location":{"parent_id":684,"name":"Fishers Indiana","postal_code":"46038","street1":"8924 East 116th Street","street2":null,"street3":null,"description":"<p>Fishers Indiana<\/p>","city":{"id":11,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.957382","longitude":"-86.012038","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":1554,"is_primary":false,"created_at":"2025-08-12T13:46:34+00:00","updated_at":"2025-04-22T21:27:23+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-22T21:27:23+00:00"},"is_general_application":false,"id":2022,"title":"Testing Deleted Job Approval Group","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2025-08-12T13:46:34+00:00","updated_at":"2025-08-12T14:03:43+00:00","deleted_at":null},{"template":null,"decoded_description":"<h2 data-start=\"144\" data-end=\"216\"><strong data-start=\"147\" data-end=\"214\">We're Hiring a Senior Full Stack Engineer (PHP, React, AWS, K8s)<\/strong><\/h2>\n<p data-start=\"217\" data-end=\"261\"><strong data-start=\"217\" data-end=\"230\">Location:<\/strong> Remote (U.S. only) | Full-time<\/p>\n<p data-start=\"263\" data-end=\"534\">Are you a Full Stack Developer who enjoys working across both frontend and backend, and feels at home in the cloud? We're looking for an experienced engineer to join our team and help build scalable, containerized applications using Symfony (PHP), React, Docker, and AWS.<\/p>\n<h3 data-start=\"536\" data-end=\"558\"><strong data-start=\"540\" data-end=\"558\">What You\u2019ll Do<\/strong><\/h3>\n<ul data-start=\"559\" data-end=\"977\">\n<li data-start=\"559\" data-end=\"612\">\n<p data-start=\"561\" data-end=\"612\">Build and maintain robust APIs in <strong data-start=\"595\" data-end=\"612\">Symfony (PHP)<\/strong><\/p>\n<\/li>\n<li data-start=\"613\" data-end=\"661\">\n<p data-start=\"615\" data-end=\"661\">Develop modern, responsive UIs using <strong data-start=\"652\" data-end=\"661\">React<\/strong><\/p>\n<\/li>\n<li data-start=\"662\" data-end=\"745\">\n<p data-start=\"664\" data-end=\"745\">Work with <strong data-start=\"674\" data-end=\"684\">Docker<\/strong> locally and help deploy services to <strong data-start=\"721\" data-end=\"745\">AWS EKS (Kubernetes)<\/strong><\/p>\n<\/li>\n<li data-start=\"746\" data-end=\"804\">\n<p data-start=\"748\" data-end=\"804\">Use <strong data-start=\"752\" data-end=\"768\">RDS, EC2, S3<\/strong>, and other AWS services effectively<\/p>\n<\/li>\n<li data-start=\"805\" data-end=\"865\">\n<p data-start=\"807\" data-end=\"865\">Write <strong data-start=\"813\" data-end=\"824\">Cypress<\/strong> E2E tests and ensure application quality<\/p>\n<\/li>\n<li data-start=\"866\" data-end=\"926\">\n<p data-start=\"868\" data-end=\"926\">Collaborate via <strong data-start=\"884\" data-end=\"892\">Jira<\/strong> (tasks) and <strong data-start=\"905\" data-end=\"919\">Confluence<\/strong> (docs)<\/p>\n<\/li>\n<li data-start=\"927\" data-end=\"977\">\n<p data-start=\"929\" data-end=\"977\">Use <strong data-start=\"933\" data-end=\"949\">Azure DevOps<\/strong> for PRs and CI\/CD pipelines<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"979\" data-end=\"997\"><strong data-start=\"983\" data-end=\"997\">Tech Stack<\/strong><\/h3>\n<ul data-start=\"998\" data-end=\"1202\">\n<li data-start=\"998\" data-end=\"1048\">\n<p data-start=\"1000\" data-end=\"1048\"><strong data-start=\"1000\" data-end=\"1014\">Languages:<\/strong> PHP (Symfony), JavaScript (React)<\/p>\n<\/li>\n<li data-start=\"1049\" data-end=\"1071\">\n<p data-start=\"1051\" data-end=\"1071\"><strong data-start=\"1051\" data-end=\"1065\">Databases:<\/strong> MySQL<\/p>\n<\/li>\n<li data-start=\"1072\" data-end=\"1135\">\n<p data-start=\"1074\" data-end=\"1135\"><strong data-start=\"1074\" data-end=\"1091\">DevOps\/Cloud:<\/strong> AWS (EKS, EC2, RDS, S3), Docker, Kubernetes<\/p>\n<\/li>\n<li data-start=\"1136\" data-end=\"1158\">\n<p data-start=\"1138\" data-end=\"1158\"><strong data-start=\"1138\" data-end=\"1150\">Testing:<\/strong> Cypress<\/p>\n<\/li>\n<li data-start=\"1159\" data-end=\"1202\">\n<p data-start=\"1161\" data-end=\"1202\"><strong data-start=\"1161\" data-end=\"1171\">Tools:<\/strong> Jira, Confluence, Azure DevOps<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"1204\" data-end=\"1227\"><strong data-start=\"1208\" data-end=\"1227\">You Should Have<\/strong><\/h3>\n<ul data-start=\"1228\" data-end=\"1529\">\n<li data-start=\"1228\" data-end=\"1278\">\n<p data-start=\"1230\" data-end=\"1278\">4+ years of experience in full stack development<\/p>\n<\/li>\n<li data-start=\"1279\" data-end=\"1325\">\n<p data-start=\"1281\" data-end=\"1325\">Solid skills in both PHP (Symfony) and React<\/p>\n<\/li>\n<li data-start=\"1326\" data-end=\"1387\">\n<p data-start=\"1328\" data-end=\"1387\">Hands-on experience with Docker and Kubernetes (EKS a plus)<\/p>\n<\/li>\n<li data-start=\"1388\" data-end=\"1431\">\n<p data-start=\"1390\" data-end=\"1431\">Experience using AWS cloud infrastructure<\/p>\n<\/li>\n<li data-start=\"1432\" data-end=\"1492\">\n<p data-start=\"1434\" data-end=\"1492\">Familiarity with CI\/CD pipelines and E2E testing (Cypress)<\/p>\n<\/li>\n<li data-start=\"1493\" data-end=\"1529\">\n<p data-start=\"1495\" data-end=\"1529\">A proactive, team-oriented mindset<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"1531\" data-end=\"1551\"><strong data-start=\"1535\" data-end=\"1551\">Why Join Us?<\/strong><\/h3>\n<ul data-start=\"1552\" data-end=\"1710\">\n<li data-start=\"1552\" data-end=\"1583\">\n<p data-start=\"1554\" data-end=\"1583\">Competitive salary + benefits<\/p>\n<\/li>\n<li data-start=\"1584\" data-end=\"1606\">\n<p data-start=\"1586\" data-end=\"1606\">Remote work<\/p>\n<\/li>\n<li data-start=\"1607\" data-end=\"1649\">\n<p data-start=\"1609\" data-end=\"1649\">Work on a modern cloud-native tech stack<\/p>\n<\/li>\n<li data-start=\"1650\" data-end=\"1710\">\n<p data-start=\"1652\" data-end=\"1710\">Make an immediate impact on real-world software used daily<\/p>\n<\/li>\n<\/ul>\n<p class=\"whitespace-normal break-words\">\u00a0<\/p>","full_location":{"parent_id":684,"name":"Fishers Indiana","postal_code":"46038","street1":"8924 East 116th Street","street2":null,"street3":null,"description":"<p>Fishers Indiana<\/p>","city":{"id":11,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.957382","longitude":"-86.012038","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":1552,"is_primary":false,"created_at":"2025-04-22T21:27:23+00:00","updated_at":"2025-04-22T21:27:23+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-22T21:27:23+00:00"},"is_general_application":false,"id":2018,"title":"Senior Full Stack Engineer \u2013 PHP, React, AWS & Kubernetes","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2025-04-22T21:27:23+00:00","updated_at":"2025-11-04T08:13:11+00:00","deleted_at":null},{"template":{"id":37},"decoded_description":"<p>This is a sample description for a template ERP System(s)<\/p>","full_location":{"parent_id":194,"name":"Example Location","postal_code":"46038","street1":"9032 Technology Dr","street2":"","street3":null,"description":"<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location.<\/p>\n<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. <a href=\"https:\/\/www.exacthire.com\" target=\"_blank\" rel=\"noopener\">Lean more<\/a><\/p>","city":{"id":11,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.961891","longitude":"-86.009207","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":1551,"is_primary":false,"created_at":"2025-02-27T22:03:04+00:00","updated_at":"2025-02-27T22:03:04+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":2016,"title":"Internal Dev","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":"2025-03-01T01:34:34+00:00","fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2025-02-27T22:03:04+00:00","updated_at":"2025-07-23T13:56:36+00:00","deleted_at":null},{"template":{"id":892},"decoded_description":"<p>Test job template creation<\/p>","full_location":{"parent_id":706,"name":"Remote","postal_code":"00000","street1":"Remote","street2":"","street3":"","description":"<p>Remote location<\/p>","city":{"id":392,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.768403","longitude":"-86.158068","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":1550,"is_primary":false,"created_at":"2025-01-22T20:51:04+00:00","updated_at":"2025-01-22T20:51:04+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":2014,"title":"Allen Job Template","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2025-01-22T20:51:04+00:00","updated_at":"2025-04-06T00:23:53+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>INTERN!\u00a0 This is my super long description that is silly and just long enough for stuff to get to ZR properly.<\/p>","full_location":{"parent_id":724,"name":"Arkansas City, KS - 40","postal_code":"67005","street1":"2715 North Summit Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":267,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"37.091753","longitude":"-97.042619","state":{"country":null,"id":17,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":1510,"is_primary":false,"created_at":"2024-10-04T18:28:59+00:00","updated_at":"2024-10-04T18:28:59+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1965,"title":"Andrew's New Job","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2024-10-04T18:28:59+00:00","updated_at":"2026-03-30T20:09:37+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>FULL TIME! Here is my updated description, which should be long enough to show up.<\/p>","full_location":{"parent_id":769,"name":"Boone, IA - 87","postal_code":"50036","street1":"1125 SE Marshall Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":311,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"42.035991","longitude":"-93.875004","state":{"country":null,"id":13,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":1509,"is_primary":false,"created_at":"2024-09-30T16:37:04+00:00","updated_at":"2024-09-30T16:37:04+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1963,"title":"Andrew Test My Work Job","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2024-09-30T16:37:04+00:00","updated_at":"2026-04-02T19:52:35+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>Join our team of sand box builders<\/p>\n<p><br \/><br \/><img style=\"text-align: right; height: auto; width: auto; float: left;\" src=\"https:\/\/www.exacthire.com\/wp-content\/uploads\/2014\/12\/eh-logo.png\" alt=\"undefined\" \/><\/p>\n<p>\u00a0<\/p>","full_location":{"parent_id":938,"name":"Archived Location","postal_code":"46062","street1":"","street2":"","street3":null,"description":null,"city":{"id":397,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"40.068342","longitude":"-86.063156","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":787,"is_primary":false,"created_at":"2024-04-01T20:27:43+00:00","updated_at":"2022-12-12T16:12:33+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1078,"title":"Copy of Sand Box Builder - Both","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2024-04-01T20:27:43+00:00","updated_at":"2025-07-30T18:35:34+00:00","deleted_at":null},{"template":{"id":42},"decoded_description":"<p>test test<\/p>","full_location":{"parent_id":689,"name":"Boonville, MO - 4","postal_code":"65233","street1":"1920 Main Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":233,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"38.956097","longitude":"-92.739439","state":{"country":null,"id":25,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":786,"is_primary":false,"created_at":"2023-10-31T16:48:48+00:00","updated_at":"2023-10-31T16:48:48+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1075,"title":"Test Developer","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2023-10-31T16:48:48+00:00","updated_at":"2025-05-21T14:01:27+00:00","deleted_at":null},{"template":null,"decoded_description":"<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><strong><u><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">GENERAL DESCRIPTION<\/span><\/u><\/strong><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">The job functions consist of aiding sworn personnel and the public, directing calls that come into the non-emergency line, monitoring the cell block through closed-circuit television (CCTV), communicating on a Township monitored radio as well as county-monitored radio, and performing clerical duties.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">This position requires excellent communication skills when interacting with the public, uniformed officers, detectives, and Township personnel.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><strong><u><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">SUPERVISION RECEIVED<\/span><\/u><\/strong><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Under the direct supervision of the Communication Specialist Supervisor and Assistant Supervisor, with occasional direction from the Lieutenants or the Chief of Police. <\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><strong><u><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">SUPERVISION EXERCISED<\/span><\/u><\/strong><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">None.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><strong><u><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">ESSENTIAL JOB FUNCTIONS<\/span><\/u><\/strong><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Monitor the following systems, and perform data entry as necessary:<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">\u00a0 \u00a0The Advance Law Enforcement Intelligence System - ALEIS - Record Management System<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">\u00a0 Commonwealth Law Enforcement Assistance Network - CLEAN - Scope<\/span>\u00a0<\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">\u00a0 \u00a0National Crime Information Center - NCIC - Scope<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">\u00a0 \u00a0Montgomery County Computer Aided Dispatch - CAD<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Monitor and communicate with officers and agencies as needed, through the law enforcement radio channels County Radio - Township Channel.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Monitor the safety and security of prisoners and officers in the Detention Facility via CCTV.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Assist sworn employees with law enforcement activities.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Receive, prioritize, process and forward radio and phone calls for service to appropriate agencies\/officers.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Prepare and maintain records and files.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Assist the public with general information-direction.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Arrange arraignment hearings and assist with related paperwork.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Handle checks, cash & money orders for reports, parking tickets and solicitation permits.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Process solicitation permit applications.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Process mail, protection from abuse orders, vacant home checks, PA One calls.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Make notifications to PennDOT-Game Commission. <\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Follow department policies and procedures in accordance with the duties and responsibilities of this position.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">The above functions are intended to describe the general nature and level of work being performed in this position; they are not intended to be an exhaustive list of all duties, responsibilities and qualifications of this position.\u00a0 Perform related duties and responsibilities as required.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><strong><u><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">JOB STANDARDS<\/span><\/u><\/strong><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\"> - Minimum qualifications needed to perform essential functions:<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to work various shifts, which include day, evening, weekend and holiday hours.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">A high degree of dependability.\u00a0 Willingness and ability to report for duty during inclement weather and other adverse situations.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Assist the public in a calm and courteous manner.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to operate the communication center under stressful conditions.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to prioritize and organize workflow. <\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to use discretion when handling confidential and sensitive information.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Assist in law enforcement calls for service.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to operate county system, state system and local system.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to type at a reasonable rate of speed.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to work in a fast-paced environment.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to establish and maintain effective working relationships with supervisors, co-workers, elected officials and representatives of governmental and other agencies, and the general public.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to sit for eight to twelve hours and move about the communication center and police department.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Perform repetitive fine manipulation; handle office implements frequently; bend, lift, and carry up to 35 lbs. (box of computer paper), and reach at shoulder level, occasionally.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Possess good visual acuity - near vision continuously, mid-vision occasionally.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to simultaneously listen to, process and respond to information being received from multiple channels.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to operate keyboard and push button consoles.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to speak and communicate clearly in order to be understood over radio equipment and phone system.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to receive satisfactory ratings throughout the Communication Specialist training process.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Knowledge of Township and department practices, policies and procedures.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Knowledge of department emergency dispatch operations.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Knowledge of Township layout and ability to effectively direct emergency personnel to incident. <\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><strong><u><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">JOB LOCATION<\/span><\/u><\/strong><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\"> - Place where work is performed:<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Montgomery Township, 1001 Stump Road, Montgomeryville, PA, 18936.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><strong><u><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">EQUIPMENT<\/span><\/u><\/strong><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\"> - Examples of machines, devices, tools, etc., used in job performance include but not limited to:<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Computer, copier, printer, fax machine, telephone, surveillance system, automated entry system, internal call box system, and scanner.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><strong><u><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">EDUCATION, EXPERIENCE AND TRAINING<\/span><\/u><\/strong><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">High school diploma or equivalent, required.<\/span><\/p>\n<p><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Successful results upon completion of pre-employment background checks, pre-employment physical, assessments or tests, as applicable, required.\u00a0 <\/span><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">All applicants are subject to a criminal background investigation, which must meet the requirements for access to confidential law enforcement databases. <\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Ability to communicate and perform well in an interview and demonstrate proven skills and abilities, required.<\/span><\/p>\n<p style=\"tab-stops: -.75in -.5in 0in .5in 1.0in 1.5in 2.0in 2.5in 3.0in 3.5in 4.0in 4.5in 4.75in 5.5in 6.0in 6.5in 7.0in 7.5in 8.0in;\"><span style=\"font-size: 11.0pt; font-family: 'Arial',sans-serif;\">Remain current in all position applicable trainings as required.<\/span><\/p>","full_location":{"parent_id":724,"name":"Arkansas City, KS - 40","postal_code":"67005","street1":"2715 North Summit Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":267,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"37.091753","longitude":"-97.042619","state":{"country":null,"id":17,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":785,"is_primary":false,"created_at":"2023-10-31T14:05:35+00:00","updated_at":"2023-10-31T14:05:35+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1073,"title":"Dispatch Specialist-v1","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2023-10-31T14:05:35+00:00","updated_at":"2025-07-30T18:35:34+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>I am trying to create a job with (test)<\/p>","full_location":{"parent_id":724,"name":"Arkansas City, KS - 40","postal_code":"67005","street1":"2715 North Summit Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":267,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"37.091753","longitude":"-97.042619","state":{"country":null,"id":17,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":784,"is_primary":false,"created_at":"2023-10-31T13:59:24+00:00","updated_at":"2023-10-31T13:59:24+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1071,"title":"Testing (test)","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2023-10-31T13:59:24+00:00","updated_at":"2025-07-30T18:35:34+00:00","deleted_at":null},{"template":{"id":1062},"decoded_description":"<p>test test<\/p>","full_location":{"parent_id":724,"name":"Arkansas City, KS - 40","postal_code":"67005","street1":"2715 North Summit Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":267,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"37.091753","longitude":"-97.042619","state":{"country":null,"id":17,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":782,"is_primary":false,"created_at":"2023-09-14T00:09:55+00:00","updated_at":"2023-09-14T00:09:55+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1067,"title":"Job Approval - Director of Human Resources","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2023-09-14T00:09:55+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":{"id":37},"decoded_description":"<p>This is a sample description for a template<\/p>","full_location":{"parent_id":194,"name":"Example Location","postal_code":"46038","street1":"9032 Technology Dr","street2":"","street3":null,"description":"<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location.<\/p>\n<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. <a href=\"https:\/\/www.exacthire.com\" target=\"_blank\" rel=\"noopener\">Lean more<\/a><\/p>","city":{"id":11,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.961891","longitude":"-86.009207","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":774,"is_primary":false,"created_at":"2023-05-01T18:34:02+00:00","updated_at":"2023-05-01T18:34:02+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1052,"title":"Front End Developer","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2023-05-01T18:34:02+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":{"id":42},"decoded_description":"<p>test test<\/p>","full_location":{"parent_id":724,"name":"Arkansas City, KS - 40","postal_code":"67005","street1":"2715 North Summit Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":267,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"37.091753","longitude":"-97.042619","state":{"country":null,"id":17,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":767,"is_primary":false,"created_at":"2023-04-19T14:49:11+00:00","updated_at":"2023-04-19T14:49:11+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1040,"title":"Director of Human Resources","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2023-04-19T14:49:11+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":{"id":37},"decoded_description":"<p>This is a sample description for a template<\/p>","full_location":{"parent_id":194,"name":"Example Location","postal_code":"46038","street1":"9032 Technology Dr","street2":"","street3":null,"description":"<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location.<\/p>\n<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. <a href=\"https:\/\/www.exacthire.com\" target=\"_blank\" rel=\"noopener\">Lean more<\/a><\/p>","city":{"id":11,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.961891","longitude":"-86.009207","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":766,"is_primary":false,"created_at":"2023-04-18T19:47:51+00:00","updated_at":"2023-04-18T19:47:51+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1038,"title":"Sand Box Test","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2023-04-18T19:47:51+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":{"id":891},"decoded_description":"<p>test test<\/p>","full_location":{"parent_id":761,"name":"Auburn, NE - 78","postal_code":"68305","street1":"409 Central Avenue","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":303,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"40.391992","longitude":"-95.831052","state":{"country":null,"id":30,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":765,"is_primary":false,"created_at":"2023-04-18T19:13:38+00:00","updated_at":"2023-04-18T19:13:38+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1036,"title":"Director of Human Resources - New","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2023-04-18T19:13:37+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":{"id":37},"decoded_description":"<p>This is a sample description for a template<\/p>","full_location":{"parent_id":762,"name":"Atchison, KS - 80","postal_code":"66002","street1":"605 South 10th Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":304,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.556579","longitude":"-95.128630","state":{"country":null,"id":17,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":1508,"is_primary":false,"created_at":"2024-06-28T20:33:55+00:00","updated_at":"2024-06-28T20:33:55+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1030,"title":"Front End Dev","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2023-04-12T18:46:09+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":{"id":37},"decoded_description":"<p>This is a sample description for a template<\/p>","full_location":{"parent_id":194,"name":"Example Location","postal_code":"46038","street1":"9032 Technology Dr","street2":"","street3":null,"description":"<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location.<\/p>\n<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. <a href=\"https:\/\/www.exacthire.com\" target=\"_blank\" rel=\"noopener\">Lean more<\/a><\/p>","city":{"id":11,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.961891","longitude":"-86.009207","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":761,"is_primary":false,"created_at":"2023-04-12T18:43:19+00:00","updated_at":"2023-04-12T18:41:03+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1028,"title":"Copy of Stage Manager","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2023-04-12T18:43:19+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":{"id":37},"decoded_description":"<p>This is a sample description for a template<\/p>","full_location":{"parent_id":194,"name":"Example Location","postal_code":"46038","street1":"9032 Technology Dr","street2":"","street3":null,"description":"<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location.<\/p>\n<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. <a href=\"https:\/\/www.exacthire.com\" target=\"_blank\" rel=\"noopener\">Lean more<\/a><\/p>","city":{"id":11,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.961891","longitude":"-86.009207","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":760,"is_primary":false,"created_at":"2023-04-12T18:41:03+00:00","updated_at":"2023-04-12T18:41:03+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1026,"title":"Stage Manager","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2023-04-12T18:41:03+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":{"id":37},"decoded_description":"<p>This is a sample description for a template<\/p>","full_location":{"parent_id":194,"name":"Example Location","postal_code":"46038","street1":"9032 Technology Dr","street2":"","street3":null,"description":"<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location.<\/p>\n<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. <a href=\"https:\/\/www.exacthire.com\" target=\"_blank\" rel=\"noopener\">Lean more<\/a><\/p>","city":{"id":11,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.961891","longitude":"-86.009207","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":759,"is_primary":false,"created_at":"2023-04-11T18:24:42+00:00","updated_at":"2023-04-11T18:24:42+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1024,"title":"Senior Developer","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2023-04-11T18:24:42+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":{"id":891},"decoded_description":"<p>test test testing update<\/p>","full_location":{"parent_id":768,"name":"Ardmore, OK - 86","postal_code":"73401","street1":"1925 North Rockford Road","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":310,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"34.198325","longitude":"-97.161565","state":{"country":null,"id":37,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":750,"is_primary":false,"created_at":"2022-12-07T19:45:47+00:00","updated_at":"2022-12-07T19:45:47+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1014,"title":"Test Job Dec 7 2022","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2022-12-07T19:45:47+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>Testing<\/p>","full_location":{"parent_id":724,"name":"Arkansas City, KS - 40","postal_code":"67005","street1":"2715 North Summit Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":267,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"37.091753","longitude":"-97.042619","state":{"country":null,"id":17,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":749,"is_primary":false,"created_at":"2022-12-01T15:35:40+00:00","updated_at":"2022-12-01T15:35:40+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1012,"title":"Testing Job with no promote tab part 2","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2022-12-01T15:35:40+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>Testing<\/p>","full_location":{"parent_id":724,"name":"Arkansas City, KS - 40","postal_code":"67005","street1":"2715 North Summit Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":267,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"37.091753","longitude":"-97.042619","state":{"country":null,"id":17,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":748,"is_primary":false,"created_at":"2022-12-01T15:34:54+00:00","updated_at":"2022-12-01T15:34:54+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1010,"title":"Testing Job with no promote tab","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2022-12-01T15:34:54+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>This is a test job for Access Tags<\/p>","full_location":{"parent_id":768,"name":"Ardmore, OK - 86","postal_code":"73401","street1":"1925 North Rockford Road","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":310,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"34.198325","longitude":"-97.161565","state":{"country":null,"id":37,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":747,"is_primary":false,"created_at":"2022-10-28T15:49:27+00:00","updated_at":"2022-10-28T15:49:27+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1008,"title":"Testing","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2022-10-28T15:49:27+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>Testing<\/p>","full_location":{"parent_id":714,"name":"Brookfield, MO - 30","postal_code":"64628","street1":"710 South Main Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":257,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.772689","longitude":"-93.070588","state":{"country":null,"id":25,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":745,"is_primary":false,"created_at":"2022-10-06T15:22:32+00:00","updated_at":"2022-10-06T15:22:32+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1006,"title":"Nurse Practitioner","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2022-10-06T15:22:32+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":{"id":87},"decoded_description":"<ul>\n<li>This job is for the testing purpose to auto knock out an applicant.<\/li>\n<\/ul>","full_location":{"parent_id":690,"name":"Cape Girardeau, MO - 5","postal_code":"63703","street1":"338 Christine Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":234,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"37.299781","longitude":"-89.550721","state":{"country":null,"id":25,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":744,"is_primary":false,"created_at":"2022-09-13T18:57:26+00:00","updated_at":"2022-09-13T18:57:26+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":1000,"title":"Copy of Knock Out Job","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2022-08-11T17:02:02+00:00","updated_at":"2025-04-06T00:23:50+00:00","deleted_at":null},{"template":{"id":87},"decoded_description":"<ul>\n<li>This job is for the testing purpose to auto knock out an applicant.<\/li>\n<\/ul>","full_location":{"parent_id":690,"name":"Cape Girardeau, MO - 5","postal_code":"63703","street1":"338 Christine Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":234,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"37.299781","longitude":"-89.550721","state":{"country":null,"id":25,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":743,"is_primary":false,"created_at":"2022-09-13T18:57:26+00:00","updated_at":"2022-09-13T18:57:26+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":996,"title":"Knock Out Job","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2022-07-26T14:14:36+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":null,"decoded_description":"<ul>\n<li>building and setting up new development tools and infrastructure<\/li>\n<li>understanding the needs of stakeholders and conveying this to developers<\/li>\n<li>working on ways to automate and improve development and release processes<\/li>\n<li>testing and examining code written by others and analysing results<\/li>\n<li>ensuring that systems are safe and secure against cybersecurity threats<\/li>\n<li>identifying technical problems and developing software updates and \u2018fixes\u2019<\/li>\n<li>working with software developers and software engineers to ensure that development follows established processes and works as intended<\/li>\n<li>planning out projects and being involved in project management decisions.<\/li>\n<\/ul>","full_location":{"parent_id":768,"name":"Ardmore, OK - 86","postal_code":"73401","street1":"1925 North Rockford Road","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":310,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"34.198325","longitude":"-97.161565","state":{"country":null,"id":37,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":746,"is_primary":false,"created_at":"2022-10-28T15:48:51+00:00","updated_at":"2022-10-28T15:48:51+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":976,"title":"DevOps engineer","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2022-04-18T20:07:30+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>Description!!!<\/p>","full_location":{"parent_id":706,"name":"Remote","postal_code":"00000","street1":"Remote","street2":"","street3":"","description":"<p>Remote location<\/p>","city":{"id":392,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.768403","longitude":"-86.158068","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":703,"is_primary":false,"created_at":"2022-01-06T17:59:21+00:00","updated_at":"2022-01-06T17:59:21+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":936,"title":"Marketing Associate","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2022-01-06T17:59:21+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>Test<\/p>","full_location":{"parent_id":690,"name":"Cape Girardeau, MO - 5","postal_code":"63703","street1":"338 Christine Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":234,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"37.299781","longitude":"-89.550721","state":{"country":null,"id":25,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":742,"is_primary":false,"created_at":"2022-09-13T18:57:25+00:00","updated_at":"2022-09-13T18:57:25+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":934,"title":"Chris Job Post 2","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2021-12-24T00:47:23+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":{"id":87},"decoded_description":"<ul>\n<li>Assist residents in ADLs<\/li>\n<li>Assist RN and LPN as instructed<\/li>\n<li>Provide compassionate care and professionalism<\/li>\n<\/ul>","full_location":{"parent_id":769,"name":"Boone, IA - 87","postal_code":"50036","street1":"1125 SE Marshall Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":311,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"42.035991","longitude":"-93.875004","state":{"country":null,"id":13,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":700,"is_primary":false,"created_at":"2021-09-16T15:52:47+00:00","updated_at":"2021-09-16T15:52:47+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":930,"title":"Allen Job - with file type uploads","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2021-09-16T15:52:47+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":{"id":23},"decoded_description":"<p>ExactHire is looking for a Software Engineer Level 4.\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>Software Engineer Level 4 is for advanced level development, security, and debugging.<\/p>","full_location":{"parent_id":871,"name":"ExactHire HQ","postal_code":"46290","street1":"10333 N. Meridian St","street2":"","street3":null,"description":null,"city":{"id":1,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.937053","longitude":"-86.156655","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":697,"is_primary":false,"created_at":"2021-06-19T18:30:02+00:00","updated_at":"2021-06-19T18:30:02+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":926,"title":"Software Engineer Level 4","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2021-06-19T18:30:02+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":{"id":891},"decoded_description":"<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>\n<p>This job uses indeed short apps<\/p>","full_location":{"parent_id":690,"name":"Cape Girardeau, MO - 5","postal_code":"63703","street1":"338 Christine Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":234,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"37.299781","longitude":"-89.550721","state":{"country":null,"id":25,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":741,"is_primary":false,"created_at":"2022-09-13T18:57:25+00:00","updated_at":"2022-09-13T18:57:25+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":924,"title":"AE Test Indeed","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2021-06-04T00:45:14+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":{"id":37},"decoded_description":"<p>This is a sample description for a template<\/p>","full_location":{"parent_id":194,"name":"Example Location","postal_code":"46038","street1":"9032 Technology Dr","street2":"","street3":null,"description":"<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location.<\/p>\n<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. <a href=\"https:\/\/www.exacthire.com\" target=\"_blank\" rel=\"noopener\">Lean more<\/a><\/p>","city":{"id":11,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.961891","longitude":"-86.009207","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":684,"is_primary":false,"created_at":"2021-05-14T13:36:26+00:00","updated_at":"2021-05-14T13:36:26+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":909,"title":"Developer Sample","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2021-05-14T13:36:26+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":{"id":37},"decoded_description":"<p>This is a sample description for a template<\/p>","full_location":{"parent_id":706,"name":"Remote","postal_code":"00000","street1":"Remote","street2":"","street3":"","description":"<p>Remote location<\/p>","city":{"id":392,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.768403","longitude":"-86.158068","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":683,"is_primary":false,"created_at":"2021-04-24T21:04:02+00:00","updated_at":"2021-04-24T21:04:02+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":907,"title":"JobTarget Testing","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2021-04-24T21:04:02+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":{"id":87},"decoded_description":"<ul>\n<li>Assist residents in ADLs<\/li>\n<li>Assist RN and LPN as instructed<\/li>\n<li>Provide compassionate care and professionalism<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p><iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/PkWMWcKX-rs\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>","full_location":{"parent_id":769,"name":"Boone, IA - 87","postal_code":"50036","street1":"1125 SE Marshall Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":311,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"42.035991","longitude":"-93.875004","state":{"country":null,"id":13,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":682,"is_primary":false,"created_at":"2021-04-21T20:13:31+00:00","updated_at":"2021-04-21T20:13:31+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":905,"title":"Job A","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2021-04-21T20:13:31+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":{"id":23},"decoded_description":"<p>ExactHire is looking for a Software Engineer Level 3.\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>Software Engineer Level 3 is for advanced level development, security, and debugging.<\/p>","full_location":{"parent_id":871,"name":"ExactHire HQ","postal_code":"46290","street1":"10333 N. Meridian St","street2":"","street3":null,"description":null,"city":{"id":1,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.937053","longitude":"-86.156655","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":696,"is_primary":false,"created_at":"2021-06-09T19:20:30+00:00","updated_at":"2021-06-09T19:20:30+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":899,"title":"Software Engineer Level 3","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2021-01-23T19:48:36+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>bread maker<\/p>","full_location":{"parent_id":706,"name":"Remote","postal_code":"00000","street1":"Remote","street2":"","street3":"","description":"<p>Remote location<\/p>","city":{"id":392,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.768403","longitude":"-86.158068","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":678,"is_primary":false,"created_at":"2020-12-08T23:09:21+00:00","updated_at":"2020-12-08T23:09:21+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":897,"title":"Bread Maker 2","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2020-12-08T23:09:21+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":{"id":23},"decoded_description":"<p>software engineer<\/p>","full_location":{"parent_id":706,"name":"Remote","postal_code":"00000","street1":"Remote","street2":"","street3":"","description":"<p>Remote location<\/p>","city":{"id":392,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.768403","longitude":"-86.158068","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":675,"is_primary":false,"created_at":"2020-11-25T20:38:54+00:00","updated_at":"2020-11-25T20:38:54+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":895,"title":"Allen Multi-Step Agreement Step 1","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2020-11-25T20:38:54+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":{"id":26},"decoded_description":"<p>Require 2 year Sous Chef Experience<\/p>\n<p>Require 5 years Line Cook Experience<\/p>","full_location":{"parent_id":706,"name":"Remote","postal_code":"00000","street1":"Remote","street2":"","street3":"","description":"<p>Remote location<\/p>","city":{"id":392,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.768403","longitude":"-86.158068","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":674,"is_primary":false,"created_at":"2020-11-25T16:02:46+00:00","updated_at":"2020-11-25T16:02:46+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":893,"title":"Allen Job Question Scoring","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2020-11-25T16:02:46+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>This job is a multi step job<\/p>","full_location":{"parent_id":706,"name":"Remote","postal_code":"00000","street1":"Remote","street2":"","street3":"","description":"<p>Remote location<\/p>","city":{"id":392,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.768403","longitude":"-86.158068","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":672,"is_primary":false,"created_at":"2020-11-01T20:30:29+00:00","updated_at":"2020-11-01T20:30:29+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":888,"title":"Allen Multi-Step Job","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2020-11-01T20:30:29+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":{"id":875},"decoded_description":"<p>Test job template creation<\/p>","full_location":{"parent_id":706,"name":"Remote","postal_code":"00000","street1":"Remote","street2":"","street3":"","description":"<p>Remote location<\/p>","city":{"id":392,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.768403","longitude":"-86.158068","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":671,"is_primary":false,"created_at":"2020-10-28T01:59:24+00:00","updated_at":"2020-10-28T01:59:24+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":886,"title":"Job 2020-10-27","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2020-10-28T01:59:24+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>bread maker test job<\/p>","full_location":{"parent_id":706,"name":"Remote","postal_code":"00000","street1":"Remote","street2":"","street3":"","description":"<p>Remote location<\/p>","city":{"id":392,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.768403","longitude":"-86.158068","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":670,"is_primary":false,"created_at":"2020-10-23T17:00:49+00:00","updated_at":"2020-10-23T17:00:49+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":884,"title":"Bread Maker","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2020-10-23T17:00:49+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":{"id":875},"decoded_description":"<p>Test job template creation<\/p>","full_location":{"parent_id":706,"name":"Remote","postal_code":"00000","street1":"Remote","street2":"","street3":"","description":"<p>Remote location<\/p>","city":{"id":392,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.768403","longitude":"-86.158068","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":669,"is_primary":false,"created_at":"2020-10-23T00:14:05+00:00","updated_at":"2020-10-23T00:14:05+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":882,"title":"Job 2020-10-22","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2020-10-23T00:14:05+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":{"id":87},"decoded_description":"<ul>\n<li>Assist residents in ADLs<\/li>\n<li>Assist RN and LPN as instructed<\/li>\n<li>Provide compassionate care and professionalism<\/li>\n<\/ul>","full_location":{"parent_id":194,"name":"Example Location","postal_code":"46038","street1":"9032 Technology Dr","street2":"","street3":null,"description":"<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location.<\/p>\n<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. <a href=\"https:\/\/www.exacthire.com\" target=\"_blank\" rel=\"noopener\">Lean more<\/a><\/p>","city":{"id":11,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.961891","longitude":"-86.009207","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":668,"is_primary":false,"created_at":"2020-10-22T18:21:47+00:00","updated_at":"2020-10-22T18:21:47+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":880,"title":"Test Job from Template 10-22-2020","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2020-10-22T18:21:47+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":{"id":42},"decoded_description":"<p>test test<\/p>","full_location":{"parent_id":231,"name":"Test Location","postal_code":"90210","street1":"1 place","street2":null,"street3":null,"description":"<p>stuff to cook - be clean - come to work <\/p>","city":{"id":13,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"34.068995","longitude":"-118.402469","state":{"country":null,"id":5,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":667,"is_primary":false,"created_at":"2020-09-02T21:52:42+00:00","updated_at":"2020-09-02T21:52:42+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":878,"title":"Test - Director of Human Resources","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2020-09-02T21:52:42+00:00","updated_at":"2025-09-22T14:22:08+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>Test<\/p>","full_location":{"parent_id":706,"name":"Remote","postal_code":"00000","street1":"Remote","street2":"","street3":"","description":"<p>Remote location<\/p>","city":{"id":392,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.768403","longitude":"-86.158068","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":666,"is_primary":false,"created_at":"2020-07-23T20:22:52+00:00","updated_at":"2020-07-23T20:22:52+00:00","deleted_at":null},"location_type":{"id":12228,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":876,"title":"Voluntary Disclosure Job","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2020-07-23T20:22:52+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>A new Job<\/p>","full_location":{"parent_id":690,"name":"Cape Girardeau, MO - 5","postal_code":"63703","street1":"338 Christine Street","street2":"","street3":"","description":"Orscheln Farm and Home Retail Store","city":{"id":234,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"37.299781","longitude":"-89.550721","state":{"country":null,"id":25,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":740,"is_primary":false,"created_at":"2022-09-13T18:57:25+00:00","updated_at":"2022-09-13T18:57:25+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":873,"title":"Job 2020-07-22","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2020-07-22T14:13:53+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null},{"template":null,"decoded_description":"<p>Build Legos competitively<\/p>\n","full_location":{"parent_id":194,"name":"Example Location","postal_code":"46038","street1":"9032 Technology Dr","street2":"","street3":null,"description":"<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location.<\/p>\n<p>This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. This is a example location. <a href=\"https:\/\/www.exacthire.com\" target=\"_blank\" rel=\"noopener\">Lean more<\/a><\/p>","city":{"id":11,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null},"country":{"id":1,"name":null,"iso":null,"iso3":null,"display_order":null,"created_at":null,"updated_at":null,"deleted_at":null},"latitude":"39.961891","longitude":"-86.009207","state":{"country":null,"id":16,"label":null,"abbreviation":null,"created_at":null,"updated_at":null,"deleted_at":null,"created_on":null,"latitude":null,"longitude":null},"id":661,"is_primary":false,"created_at":"2020-05-05T19:29:39+00:00","updated_at":"2020-05-05T19:29:39+00:00","deleted_at":null},"location_type":{"id":12227,"updated_at":"2025-04-06T00:23:45+00:00"},"is_general_application":false,"id":871,"title":"NDM Test - Lego Builder","start_date":null,"end_date":null,"parent":null,"is_full_service_hiring":null,"fill_by":null,"number_of_hires":null,"is_template":false,"archived_at":null,"created_at":"2020-05-05T19:29:39+00:00","updated_at":"2025-04-06T00:23:49+00:00","deleted_at":null}],"positionNotes":[],"positionStatuses":{"2026":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"2024":{"id":4,"identifier":"POSITION_STATUS_PENDING_APPROVAL","label":"Pending Approval"},"2022":{"id":6,"identifier":"POSITION_STATUS_PAUSED","label":"Pause"},"2018":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"2016":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"2014":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"1965":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"1963":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"1078":{"id":3,"identifier":"POSITION_STATUS_DRAFT","label":"Draft"},"1075":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"1073":{"id":3,"identifier":"POSITION_STATUS_DRAFT","label":"Draft"},"1071":{"id":3,"identifier":"POSITION_STATUS_DRAFT","label":"Draft"},"1067":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"1052":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"1040":{"id":11951,"identifier":"POSITION_STATUS_APPROVED","label":"Approved"},"1038":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"1036":{"id":3,"identifier":"POSITION_STATUS_DRAFT","label":"Draft"},"1030":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"1028":{"id":11950,"identifier":"POSITION_STATUS_APPROVAL_CANCELED","label":"Job Approval Canceled"},"1026":{"id":11949,"identifier":"POSITION_STATUS_APPROVAL_REJECTED","label":"Job Approval Rejected"},"1024":{"id":11951,"identifier":"POSITION_STATUS_APPROVED","label":"Approved"},"1014":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"1012":{"id":3,"identifier":"POSITION_STATUS_DRAFT","label":"Draft"},"1010":{"id":3,"identifier":"POSITION_STATUS_DRAFT","label":"Draft"},"1008":{"id":3,"identifier":"POSITION_STATUS_DRAFT","label":"Draft"},"1006":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"1000":{"id":3,"identifier":"POSITION_STATUS_DRAFT","label":"Draft"},"996":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"976":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"936":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"934":{"id":3,"identifier":"POSITION_STATUS_DRAFT","label":"Draft"},"930":{"id":3,"identifier":"POSITION_STATUS_DRAFT","label":"Draft"},"926":{"id":4,"identifier":"POSITION_STATUS_PENDING_APPROVAL","label":"Pending Approval"},"924":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"909":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"907":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"905":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"899":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"897":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"895":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"893":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"888":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"886":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"884":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"882":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"880":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"878":{"id":8,"identifier":"POSITION_STATUS_FILLED","label":"Filled"},"876":{"id":8,"identifier":"POSITION_STATUS_FILLED","label":"Filled"},"873":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"},"871":{"id":5,"identifier":"POSITION_STATUS_ACTIVE","label":"Active"}},"insights":[{"getActiveApplicationsNumber":1,"getTotalApplicationsNumber":1},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":2,"getTotalApplicationsNumber":2},{"getActiveApplicationsNumber":2,"getTotalApplicationsNumber":2},{"getActiveApplicationsNumber":3,"getTotalApplicationsNumber":3},{"getActiveApplicationsNumber":1,"getTotalApplicationsNumber":1},{"getActiveApplicationsNumber":1,"getTotalApplicationsNumber":1},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":1,"getTotalApplicationsNumber":1},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":2,"getTotalApplicationsNumber":2},{"getActiveApplicationsNumber":3,"getTotalApplicationsNumber":3},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":2,"getTotalApplicationsNumber":2},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":1},{"getActiveApplicationsNumber":3,"getTotalApplicationsNumber":3},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":4,"getTotalApplicationsNumber":4},{"getActiveApplicationsNumber":15,"getTotalApplicationsNumber":15},{"getActiveApplicationsNumber":3,"getTotalApplicationsNumber":6},{"getActiveApplicationsNumber":11,"getTotalApplicationsNumber":12},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":7,"getTotalApplicationsNumber":8},{"getActiveApplicationsNumber":2,"getTotalApplicationsNumber":2},{"getActiveApplicationsNumber":4,"getTotalApplicationsNumber":4},{"getActiveApplicationsNumber":10,"getTotalApplicationsNumber":10},{"getActiveApplicationsNumber":17,"getTotalApplicationsNumber":17},{"getActiveApplicationsNumber":10,"getTotalApplicationsNumber":10},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":5,"getTotalApplicationsNumber":5},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":0,"getTotalApplicationsNumber":0},{"getActiveApplicationsNumber":1,"getTotalApplicationsNumber":1},{"getActiveApplicationsNumber":1,"getTotalApplicationsNumber":1},{"getActiveApplicationsNumber":3,"getTotalApplicationsNumber":4}],"reportVersion":"","total":79}}
      """
  }
  null
  "172.22.0.1"
  "2026-09-28 21:20:50"
  "2026-09-28 21:20:50"
  null
  657
  3
  208991
]
View formatted query    View runnable query
45 0.23 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection
hirecentric doctrine.dbal.hirecentric_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
ExactHireApi\Entity\RolePermission 158
ExactHireApi\Entity\Permission 158
ExactHireApi\Entity\Position 60
ExactHireApi\Entity\PositionLocation 50
ExactHireApi\Entity\SubSystem 22
ExactHireApi\Entity\Location 15
ExactHireApi\Entity\DataPointOption 15
ExactHireApi\Entity\City 13
ExactHireApi\Entity\User 12
ExactHireApi\Entity\State 7
ExactHireApi\Entity\DataPoint 3
ExactHireApi\Entity\Organization 2
ExactHireApi\Entity\PermissionType 2
ExactHireApi\Entity\DataPointResource 2
ExactHireApi\Entity\OrganizationUser 1
ExactHireApi\Entity\OrganizationUserRole 1
ExactHireApi\Entity\Role 1
ExactHireApi\Entity\Provider 1
ExactHireApi\Entity\LocationScope 1
ExactHireApi\Entity\TagScope 1
ExactHireApi\Entity\Country 1

Entities Mapping

Class Mapping errors
ExactHireApi\Entity\SSOToken No errors.
ExactHireApi\Entity\User No errors.
ExactHireApi\Entity\OrganizationUser No errors.
ExactHireApi\Entity\Organization
  • The field ExactHireApi\Entity\Organization#loginAttempts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity ExactHireApi\Entity\LoginAttempt#organization does not contain the required 'inversedBy="loginAttempts"' attribute.
ExactHireApi\Entity\Person
  • The mappings ExactHireApi\Entity\Person#dataPointAnswerPeople and ExactHireApi\Entity\DataPointAnswerPerson#person are inconsistent with each other.
  • The mappings ExactHireApi\Entity\Person#personSignatures and ExactHireApi\Entity\PersonSignature#person are inconsistent with each other.
ExactHireApi\Entity\RemoteUser No errors.
ExactHireApi\Entity\HttpLog No errors.
ExactHireApi\Entity\Workflow No errors.
ExactHireApi\Entity\WorkflowAssignment
  • The association ExactHireApi\Entity\WorkflowAssignment#organization refers to the inverse side field ExactHireApi\Entity\Organization#workflowAssignments which does not exist.
ExactHireApi\Entity\TaskUser No errors.
ExactHireApi\Entity\Task
  • The association ExactHireApi\Entity\Task#timeType refers to the inverse side field ExactHireApi\Entity\TimeType#tasks which does not exist.
  • The association ExactHireApi\Entity\Task#taskAction refers to the inverse side field ExactHireApi\Entity\TaskAction#tasks which does not exist.
  • The association ExactHireApi\Entity\Task#workflowAssignment refers to the inverse side field ExactHireApi\Entity\WorkflowAssignment#tasks which does not exist.
ExactHireApi\Entity\TaskStatus No errors.
ExactHireApi\Entity\Credential No errors.
ExactHireApi\Entity\Report No errors.
ExactHireApi\Entity\Export No errors.
ExactHireApi\Entity\UserProviderMetadata No errors.
ExactHireApi\Entity\AssignedUserApplication No errors.
ExactHireApi\Entity\Rating No errors.
ExactHireApi\Entity\EmailTemplate No errors.
ExactHireApi\Entity\HiringTeamManager No errors.
ExactHireApi\Entity\HiringTeam No errors.
ExactHireApi\Entity\HiringTeamNotification No errors.
ExactHireApi\Entity\OrganizationUserRole No errors.
ExactHireApi\Entity\ScreeningSetup No errors.
ExactHireApi\Entity\Role No errors.
ExactHireApi\Entity\RolePermission No errors.
ExactHireApi\Entity\TaskRole No errors.
ExactHireApi\Entity\RoleInheritedPermissionExclusion No errors.
ExactHireApi\Entity\RoleInheritedPermissionAddition No errors.
ExactHireApi\Entity\Provider No errors.
ExactHireApi\Entity\ProviderListing No errors.
ExactHireApi\Entity\Publisher No errors.
ExactHireApi\Entity\ProviderEndpoint No errors.
ExactHireApi\Entity\ProviderSetting No errors.
ExactHireApi\Entity\ProviderViewType No errors.
ExactHireApi\Entity\OrganizationProviderStatus No errors.
ExactHireApi\Entity\ProviderMetadata No errors.
ExactHireApi\Entity\JobBoard No errors.
ExactHireApi\Entity\Permission No errors.
ExactHireApi\Entity\SubSystem No errors.
ExactHireApi\Entity\PermissionType No errors.
ExactHireApi\Entity\ReportType No errors.
ExactHireApi\Entity\DataPointResource No errors.
ExactHireApi\Entity\DataPoint No errors.
ExactHireApi\Entity\EventResource No errors.
ExactHireApi\Entity\LocationScope No errors.
ExactHireApi\Entity\Location No errors.
ExactHireApi\Entity\City
  • The field ExactHireApi\Entity\City#locations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity ExactHireApi\Entity\Location#city does not contain the required 'inversedBy="locations"' attribute.
ExactHireApi\Entity\State
  • The field ExactHireApi\Entity\State#locations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity ExactHireApi\Entity\Location#state does not contain the required 'inversedBy="locations"' attribute.
ExactHireApi\Entity\Country No errors.
ExactHireApi\Entity\OrganizationLocation No errors.
ExactHireApi\Entity\PersonLocation No errors.
ExactHireApi\Entity\PositionLocation No errors.
ExactHireApi\Entity\TagScope No errors.
ExactHireApi\Entity\DataPointOption No errors.
ExactHireApi\Entity\DataPointOptionSelection No errors.
ExactHireApi\Entity\Position No errors.
ExactHireApi\Entity\DataPointAnswerPosition No errors.
ExactHireApi\Entity\PositionProviderMetadata No errors.
ExactHireApi\Entity\PositionProviderSetting No errors.
ExactHireApi\Entity\PositionAnalytic No errors.
ExactHireApi\Entity\PositionView
  • The mappings ExactHireApi\Entity\PositionView#positionAd and ExactHireApi\Entity\Position#positionViews are inconsistent with each other.
ExactHireApi\Entity\PositionActiveHistory No errors.
ExactHireApi\Entity\PositionStatusHistory No errors.
ExactHireApi\Entity\JobBoardAd
  • The association ExactHireApi\Entity\JobBoardAd#organization refers to the inverse side field ExactHireApi\Entity\Organization#jobBoardAds which does not exist.
  • The mappings ExactHireApi\Entity\JobBoardAd#jobBoardAdAnalytics and ExactHireApi\Entity\JobBoardAdAnalytic#jobBoardAd are inconsistent with each other.
ExactHireApi\Entity\PositionCareerSite No errors.
ExactHireApi\Entity\ApplicationPositionAd No errors.
ExactHireApi\Entity\DataPointTemplatePosition No errors.
ExactHireApi\Entity\PositionRoleAssignment
  • The association ExactHireApi\Entity\PositionRoleAssignment#positionRole refers to the inverse side field ExactHireApi\Entity\PositionRole#positionRoles which does not exist.
ExactHireApi\Entity\Application No errors.
ExactHireApi\Entity\PositionNote No errors.
ExactHireApi\Entity\JobTag No errors.