GET http://localhost/api/applications/25171

Response
200 OK
IP
172.22.0.1
Profiled on
Token
22fa44

Query Metrics

75 Database Queries
43 Different statements
45.08 ms Query time
15 Invalid entities
1143 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.49 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.55 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.33 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.37 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.32 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.53 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 1.30 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.41 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.88 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.34 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.95 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.74 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.32 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.16 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
15 0.38 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_application_by_id"
  "http://localhost/api/applications/25171"
  "GET"
  null
  "1.0.0"
  Symfony\Component\HttpFoundation\Request {#13
    __toString(): """
      GET /api/applications/25171 HTTP/1.1\r\n
      Accept:          application/json\r\n
      Accept-Encoding: gzip, deflate\r\n
      Accept-Language: *\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
      Connection:      keep-alive\r\n
      Host:            localhost\r\n
      Sec-Fetch-Mode:  cors\r\n
      User-Agent:      node\r\n
      X-Php-Ob-Level:  0\r\n
      \r\n
      """
  }
  ""
  "172.22.0.1"
  "2026-09-28 19:13:55"
  "2026-09-28 19:13:55"
  null
  657
  3
  null
]
View formatted query    View runnable query
16 0.31 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
17 0.29 ms 
SELECT Organizations.id AS id, Organizations.name AS name, Organizations.identifier AS identifier, Organizations.loginSubdomain AS loginSubdomain, Organizations.contractExpires AS contractExpires, Organizations.telephone AS telephone, Organizations.email AS email, Organizations.theme AS theme, Organizations.active AS active, Organizations.isDemoSite AS isDemoSite, Organizations.isARootOrganization AS isARootOrganization, Organizations.remoteOrganizationId AS remoteOrganizationId, Organizations.partnerArchivedAt AS partnerArchivedAt, Organizations.createdAt AS createdAt, Organizations.updatedAt AS updatedAt, Organizations.deletedAt AS deletedAt, Organizations.retainDataTo AS retainDataTo, Organizations.lastLoginAt AS lastLoginAt, Organizations.aiCreditLimit AS aiCreditLimit, Organizations.aiCreditsUsed AS aiCreditsUsed, Organizations.aiCreditResetDate AS aiCreditResetDate, Organizations.aiCreditResetDay AS aiCreditResetDay, Organizations.aiEnabled AS aiEnabled, Organizations.parentId AS parentId, Organizations.rootDomainId AS rootDomainId, Organizations.planTypeId AS planTypeId, Organizations.lastLoginUserId AS lastLoginUserId, Organizations.aiCreditPlanId AS aiCreditPlanId FROM Organizations WHERE id = ?   LIMIT 1
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
18 0.58 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_34, t12.publisherId AS publisherId_35 FROM Providers t0 LEFT JOIN ProviderListings t12 ON t12.providerId = t0.id WHERE t0.identifier = ? LIMIT 1
Parameters: 
[
  "ORGANIZATION_SETTINGS"
]
View formatted query    View runnable query    Explain query
19 0.85 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
20 0.29 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_34, t12.publisherId AS publisherId_35 FROM Providers t0 LEFT JOIN ProviderListings t12 ON t12.providerId = t0.id WHERE t0.identifier = ? LIMIT 1
Parameters: 
[
  "ORGANIZATION_SETTINGS"
]
View formatted query    View runnable query    Explain query
21 0.67 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
22 0.24 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_34, t12.publisherId AS publisherId_35 FROM Providers t0 LEFT JOIN ProviderListings t12 ON t12.providerId = t0.id WHERE t0.identifier = ? LIMIT 1
Parameters: 
[
  "ORGANIZATION_SETTINGS"
]
View formatted query    View runnable query    Explain query
23 0.21 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
24 0.63 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
25 0.42 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
26 1.89 ms 
SELECT DISTINCT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.street1 AS street1_3, l0_.street2 AS street2_4, l0_.street3 AS street3_5, l0_.masterLocationId AS masterLocationId_6, l0_.postalCode AS postalCode_7, l0_.createdAt AS createdAt_8, l0_.updatedAt AS updatedAt_9, l0_.archivedAt AS archivedAt_10, l0_.deletedAt AS deletedAt_11, l0_.latitude AS latitude_12, l0_.longitude AS longitude_13, c1_.id AS id_14, c1_.label AS label_15, c1_.abbreviation AS abbreviation_16, c1_.createdAt AS createdAt_17, c1_.updatedAt AS updatedAt_18, c1_.deletedAt AS deletedAt_19, c2_.id AS id_20, c2_.name AS name_21, c2_.iso AS iso_22, c2_.iso3 AS iso3_23, c2_.displayOrder AS displayOrder_24, c2_.createdAt AS createdAt_25, c2_.updatedAt AS updatedAt_26, c2_.deletedAt AS deletedAt_27, s3_.id AS id_28, s3_.label AS label_29, s3_.abbreviation AS abbreviation_30, s3_.createdAt AS createdAt_31, s3_.updatedAt AS updatedAt_32, s3_.deletedAt AS deletedAt_33, s3_.createdOn AS createdOn_34, s3_.latitude AS latitude_35, s3_.longitude AS longitude_36, l0_.cityId AS cityId_37, l0_.stateId AS stateId_38, l0_.countryId AS countryId_39, l0_.organizationId AS organizationId_40, l0_.userId AS userId_41, c1_.stateId AS stateId_42, s3_.countryId AS countryId_43 FROM Locations l0_ INNER JOIN OrganizationLocations o4_ ON l0_.id = o4_.locationId INNER JOIN Organizations o5_ ON o4_.organizationId = o5_.id LEFT JOIN Cities c1_ ON l0_.cityId = c1_.id LEFT JOIN Countries c2_ ON l0_.countryId = c2_.id LEFT JOIN States s3_ ON l0_.stateId = s3_.id WHERE (o5_.id = ? OR (o5_.identifier = ? AND l0_.masterLocationId = 1)) ORDER BY l0_.name ASC
Parameters: 
[
  3
  "EXACTHIRE"
]
View formatted query    View runnable query    Explain query
27 1.04 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.street1 AS street1_4, t0.street2 AS street2_5, t0.street3 AS street3_6, t0.masterLocationId AS masterLocationId_7, t0.postalCode AS postalCode_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.archivedAt AS archivedAt_11, t0.deletedAt AS deletedAt_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.cityId AS cityId_15, t0.stateId AS stateId_16, t0.countryId AS countryId_17, t0.organizationId AS organizationId_18, t0.userId AS userId_19 FROM Locations t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  21777
  951
  938
  768
  724
  762
  759
  761
  818
  774
  730
  832
  769
  689
  697
  783
  714
  805
  813
  700
  800
  690
  687
  756
  788
  693
  752
  720
  746
  819
  694
  795
  775
  836
  793
  731
  718
  767
  765
  753
  733
  826
  828
  871
  873
  194
  798
  799
  704
  838
  684
  809
  262
  739
  831
  829
  822
  743
  780
  784
  715
  726
  742
  808
  763
  789
  785
  787
  807
  716
  757
  201
  811
  771
  821
  725
  823
  755
  773
  709
  814
  792
  732
  779
  747
  680
  681
  682
  810
  816
  713
  723
  695
  801
  777
  699
  754
  744
  827
  688
  691
  812
  830
  796
  702
  772
  740
  751
  735
  790
  727
  781
  817
  707
  782
  749
  736
  778
  802
  791
  806
  803
  705
  758
  692
  745
  804
  766
  717
  738
  815
  760
  706
  786
  734
  825
  741
  698
  748
  686
  712
  200
  703
  750
  833
  710
  776
  261
  728
  737
  722
  797
  231
  936
  937
  721
  764
  729
  824
  835
  820
  770
  794
  701
  696
  708
  834
  719
  711
]
View formatted query    View runnable query    Explain query
28 0.28 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 1=0
Parameters: 
[]
View formatted query    View runnable query    Explain query
29 2.78 ms 
SELECT a0_.id AS id_0, a0_.startedAt AS startedAt_1, a0_.submittedAt AS submittedAt_2, a0_.archivedAt AS archivedAt_3, a0_.stageUpdatedAt AS stageUpdatedAt_4, a0_.positionTitle AS positionTitle_5, a0_.isDisqualified AS isDisqualified_6, a0_.score AS score_7, a0_.aiMatchScore AS aiMatchScore_8, a0_.aiMatchReasons AS aiMatchReasons_9, a0_.aiMatchGaps AS aiMatchGaps_10, a0_.aiMatchScoredAt AS aiMatchScoredAt_11, a0_.aiMatchRescoreCount AS aiMatchRescoreCount_12, a0_.aiMatchRescoredOn AS aiMatchRescoredOn_13, a0_.IpAddress AS IpAddress_14, a0_.isImported AS isImported_15, a0_.isFullServiceHiring AS isFullServiceHiring_16, a0_.clientNote AS clientNote_17, a0_.clientReleasedAt AS clientReleasedAt_18, a0_.remoteApplicationId AS remoteApplicationId_19, a0_.createdAt AS createdAt_20, a0_.updatedAt AS updatedAt_21, a0_.deletedAt AS deletedAt_22, a0_.initialSubmittedAt AS initialSubmittedAt_23, p1_.id AS id_24, p1_.firstName AS firstName_25, p1_.lastName AS lastName_26, p1_.middleName AS middleName_27, p1_.image AS image_28, p1_.birthDate AS birthDate_29, p1_.hireDate AS hireDate_30, p1_.gender AS gender_31, p1_.maritalStatus AS maritalStatus_32, p1_.ssn AS ssn_33, p1_.number AS number_34, p1_.masterPersonId AS masterPersonId_35, p1_.title AS title_36, p1_.neverHire AS neverHire_37, p1_.unsubscribeIncompleteApplication AS unsubscribeIncompleteApplication_38, p1_.createdAt AS createdAt_39, p1_.updatedAt AS updatedAt_40, p1_.deletedAt AS deletedAt_41, p2_.id AS id_42, p2_.title AS title_43, p2_.json AS json_44, p2_.startDate AS startDate_45, p2_.endDate AS endDate_46, p2_.statusUpdatedAt AS statusUpdatedAt_47, p2_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_48, p2_.isFullServiceHiring AS isFullServiceHiring_49, p2_.fillBy AS fillBy_50, p2_.numberOfHires AS numberOfHires_51, p2_.isTemplate AS isTemplate_52, p2_.isGeneralApplication AS isGeneralApplication_53, p2_.isImported AS isImported_54, p2_.archivedAt AS archivedAt_55, p2_.createdAt AS createdAt_56, p2_.updatedAt AS updatedAt_57, p2_.deletedAt AS deletedAt_58, p2_.locationTypeUpdatedAt AS locationTypeUpdatedAt_59, c3_.id AS id_60, c3_.name AS name_61, c3_.subdomain AS subdomain_62, c3_.theme AS theme_63, c3_.title AS title_64, c3_.description AS description_65, c3_.footer AS footer_66, c3_.displayMap AS displayMap_67, c3_.useLocation AS useLocation_68, c3_.corporateUrl AS corporateUrl_69, c3_.thankYouPageHtml AS thankYouPageHtml_70, c3_.headerJavascript AS headerJavascript_71, c3_.bodyHtml AS bodyHtml_72, c3_.archivedAt AS archivedAt_73, c3_.createdAt AS createdAt_74, c3_.updatedAt AS updatedAt_75, c3_.deletedAt AS deletedAt_76, c3_.internalTitle AS internalTitle_77, c3_.internalDescription AS internalDescription_78, c3_.jobAlertEnabled AS jobAlertEnabled_79, c3_.jobAlertName AS jobAlertName_80, c3_.jobAlertDescription AS jobAlertDescription_81, c3_.jobAlertButtonText AS jobAlertButtonText_82, c3_.generalApplicationText AS generalApplicationText_83, c3_.generalApplicationButtonText AS generalApplicationButtonText_84, c3_.generalApplicationPosition AS generalApplicationPosition_85, o4_.id AS id_86, o4_.name AS name_87, o4_.identifier AS identifier_88, o4_.loginSubdomain AS loginSubdomain_89, o4_.contractExpires AS contractExpires_90, o4_.telephone AS telephone_91, o4_.email AS email_92, o4_.theme AS theme_93, o4_.active AS active_94, o4_.isDemoSite AS isDemoSite_95, o4_.isARootOrganization AS isARootOrganization_96, o4_.remoteOrganizationId AS remoteOrganizationId_97, o4_.partnerArchivedAt AS partnerArchivedAt_98, o4_.createdAt AS createdAt_99, o4_.updatedAt AS updatedAt_100, o4_.deletedAt AS deletedAt_101, o4_.retainDataTo AS retainDataTo_102, o4_.lastLoginAt AS lastLoginAt_103, o4_.aiCreditLimit AS aiCreditLimit_104, o4_.aiCreditsUsed AS aiCreditsUsed_105, o4_.aiCreditResetDate AS aiCreditResetDate_106, o4_.aiCreditResetDay AS aiCreditResetDay_107, o4_.aiEnabled AS aiEnabled_108, p5_.id AS id_109, p5_.title AS title_110, p5_.json AS json_111, p5_.startDate AS startDate_112, p5_.endDate AS endDate_113, p5_.statusUpdatedAt AS statusUpdatedAt_114, p5_.organizationDepartmentUpdatedAt AS organizationDepartmentUpdatedAt_115, p5_.isFullServiceHiring AS isFullServiceHiring_116, p5_.fillBy AS fillBy_117, p5_.numberOfHires AS numberOfHires_118, p5_.isTemplate AS isTemplate_119, p5_.isGeneralApplication AS isGeneralApplication_120, p5_.isImported AS isImported_121, p5_.archivedAt AS archivedAt_122, p5_.createdAt AS createdAt_123, p5_.updatedAt AS updatedAt_124, p5_.deletedAt AS deletedAt_125, p5_.locationTypeUpdatedAt AS locationTypeUpdatedAt_126, a6_.id AS id_127, a6_.startedAt AS startedAt_128, a6_.submittedAt AS submittedAt_129, a6_.archivedAt AS archivedAt_130, a6_.stageUpdatedAt AS stageUpdatedAt_131, a6_.positionTitle AS positionTitle_132, a6_.isDisqualified AS isDisqualified_133, a6_.score AS score_134, a6_.aiMatchScore AS aiMatchScore_135, a6_.aiMatchReasons AS aiMatchReasons_136, a6_.aiMatchGaps AS aiMatchGaps_137, a6_.aiMatchScoredAt AS aiMatchScoredAt_138, a6_.aiMatchRescoreCount AS aiMatchRescoreCount_139, a6_.aiMatchRescoredOn AS aiMatchRescoredOn_140, a6_.IpAddress AS IpAddress_141, a6_.isImported AS isImported_142, a6_.isFullServiceHiring AS isFullServiceHiring_143, a6_.clientNote AS clientNote_144, a6_.clientReleasedAt AS clientReleasedAt_145, a6_.remoteApplicationId AS remoteApplicationId_146, a6_.createdAt AS createdAt_147, a6_.updatedAt AS updatedAt_148, a6_.deletedAt AS deletedAt_149, a6_.initialSubmittedAt AS initialSubmittedAt_150, p7_.id AS id_151, p7_.dateStarted AS dateStarted_152, p7_.isPrimary AS isPrimary_153, p7_.createdAt AS createdAt_154, p7_.updatedAt AS updatedAt_155, p7_.deletedAt AS deletedAt_156, l8_.id AS id_157, l8_.name AS name_158, l8_.description AS description_159, l8_.street1 AS street1_160, l8_.street2 AS street2_161, l8_.street3 AS street3_162, l8_.masterLocationId AS masterLocationId_163, l8_.postalCode AS postalCode_164, l8_.createdAt AS createdAt_165, l8_.updatedAt AS updatedAt_166, l8_.archivedAt AS archivedAt_167, l8_.deletedAt AS deletedAt_168, l8_.latitude AS latitude_169, l8_.longitude AS longitude_170, d9_.id AS id_171, d9_.label AS label_172, d9_.value AS value_173, d9_.description AS description_174, d9_.identifier AS identifier_175, d9_.displayOrder AS displayOrder_176, d9_.isLocked AS isLocked_177, d9_.archivedAt AS archivedAt_178, d9_.createdAt AS createdAt_179, d9_.updatedAt AS updatedAt_180, d9_.deletedAt AS deletedAt_181, p10_.id AS id_182, p10_.value AS value_183, p10_.formattedValue AS formattedValue_184, p10_.createdAt AS createdAt_185, p10_.updatedAt AS updatedAt_186, p10_.deletedAt AS deletedAt_187, p10_.isValid AS isValid_188, p11_.id AS id_189, p11_.value AS value_190, p11_.createdAt AS createdAt_191, p11_.updatedAt AS updatedAt_192, p11_.deletedAt AS deletedAt_193, p12_.id AS id_194, p12_.isPrimary AS isPrimary_195, p12_.createdAt AS createdAt_196, p12_.updatedAt AS updatedAt_197, p12_.deletedAt AS deletedAt_198, l13_.id AS id_199, l13_.name AS name_200, l13_.description AS description_201, l13_.street1 AS street1_202, l13_.street2 AS street2_203, l13_.street3 AS street3_204, l13_.masterLocationId AS masterLocationId_205, l13_.postalCode AS postalCode_206, l13_.createdAt AS createdAt_207, l13_.updatedAt AS updatedAt_208, l13_.archivedAt AS archivedAt_209, l13_.deletedAt AS deletedAt_210, l13_.latitude AS latitude_211, l13_.longitude AS longitude_212, c14_.id AS id_213, c14_.name AS name_214, c14_.iso AS iso_215, c14_.iso3 AS iso3_216, c14_.displayOrder AS displayOrder_217, c14_.createdAt AS createdAt_218, c14_.updatedAt AS updatedAt_219, c14_.deletedAt AS deletedAt_220, s15_.id AS id_221, s15_.label AS label_222, s15_.abbreviation AS abbreviation_223, s15_.createdAt AS createdAt_224, s15_.updatedAt AS updatedAt_225, s15_.deletedAt AS deletedAt_226, s15_.createdOn AS createdOn_227, s15_.latitude AS latitude_228, s15_.longitude AS longitude_229, c16_.id AS id_230, c16_.label AS label_231, c16_.abbreviation AS abbreviation_232, c16_.createdAt AS createdAt_233, c16_.updatedAt AS updatedAt_234, c16_.deletedAt AS deletedAt_235, c17_.id AS id_236, c17_.name AS name_237, c17_.iso AS iso_238, c17_.iso3 AS iso3_239, c17_.displayOrder AS displayOrder_240, c17_.createdAt AS createdAt_241, c17_.updatedAt AS updatedAt_242, c17_.deletedAt AS deletedAt_243, s18_.id AS id_244, s18_.label AS label_245, s18_.abbreviation AS abbreviation_246, s18_.createdAt AS createdAt_247, s18_.updatedAt AS updatedAt_248, s18_.deletedAt AS deletedAt_249, s18_.createdOn AS createdOn_250, s18_.latitude AS latitude_251, s18_.longitude AS longitude_252, c19_.id AS id_253, c19_.label AS label_254, c19_.abbreviation AS abbreviation_255, c19_.createdAt AS createdAt_256, c19_.updatedAt AS updatedAt_257, c19_.deletedAt AS deletedAt_258, d20_.id AS id_259, d20_.label AS label_260, d20_.value AS value_261, d20_.description AS description_262, d20_.identifier AS identifier_263, d20_.displayOrder AS displayOrder_264, d20_.isLocked AS isLocked_265, d20_.archivedAt AS archivedAt_266, d20_.createdAt AS createdAt_267, d20_.updatedAt AS updatedAt_268, d20_.deletedAt AS deletedAt_269, a0_.stageId AS stageId_270, a0_.templateStageId AS templateStageId_271, a0_.positionId AS positionId_272, a0_.sourceId AS sourceId_273, a0_.firstSourceAttributionId AS firstSourceAttributionId_274, a0_.secondSourceAttributionId AS secondSourceAttributionId_275, a0_.thirdSourceAttributionId AS thirdSourceAttributionId_276, a0_.fitBadgeId AS fitBadgeId_277, a0_.aiFitBadgeId AS aiFitBadgeId_278, a0_.positionAdId AS positionAdId_279, a0_.parentId AS parentId_280, a0_.careerSiteId AS careerSiteId_281, a0_.organizationId AS organizationId_282, a0_.personId AS personId_283, a0_.addedById AS addedById_284, p1_.organizationId AS organizationId_285, p1_.personTypeId AS personTypeId_286, p1_.userId AS userId_287, p1_.managerId AS managerId_288, p1_.preferredContactTypeId AS preferredContactTypeId_289, p2_.parentId AS parentId_290, p2_.copiedFromId AS copiedFromId_291, p2_.statusId AS statusId_292, p2_.organizationDepartmentId AS organizationDepartmentId_293, p2_.organizationId AS organizationId_294, p2_.templateId AS templateId_295, p2_.userId AS userId_296, p2_.locationTypeId AS locationTypeId_297, c3_.careerSiteDisplayTypeId AS careerSiteDisplayTypeId_298, c3_.organizationId AS organizationId_299, o4_.parentId AS parentId_300, o4_.rootDomainId AS rootDomainId_301, o4_.planTypeId AS planTypeId_302, o4_.lastLoginUserId AS lastLoginUserId_303, o4_.aiCreditPlanId AS aiCreditPlanId_304, p5_.parentId AS parentId_305, p5_.copiedFromId AS copiedFromId_306, p5_.statusId AS statusId_307, p5_.organizationDepartmentId AS organizationDepartmentId_308, p5_.organizationId AS organizationId_309, p5_.templateId AS templateId_310, p5_.userId AS userId_311, p5_.locationTypeId AS locationTypeId_312, a6_.stageId AS stageId_313, a6_.templateStageId AS templateStageId_314, a6_.positionId AS positionId_315, a6_.sourceId AS sourceId_316, a6_.firstSourceAttributionId AS firstSourceAttributionId_317, a6_.secondSourceAttributionId AS secondSourceAttributionId_318, a6_.thirdSourceAttributionId AS thirdSourceAttributionId_319, a6_.fitBadgeId AS fitBadgeId_320, a6_.aiFitBadgeId AS aiFitBadgeId_321, a6_.positionAdId AS positionAdId_322, a6_.parentId AS parentId_323, a6_.careerSiteId AS careerSiteId_324, a6_.organizationId AS organizationId_325, a6_.personId AS personId_326, a6_.addedById AS addedById_327, p7_.locationId AS locationId_328, p7_.personId AS personId_329, l8_.cityId AS cityId_330, l8_.stateId AS stateId_331, l8_.countryId AS countryId_332, l8_.organizationId AS organizationId_333, l8_.userId AS userId_334, d9_.dataPointId AS dataPointId_335, d9_.parentId AS parentId_336, d9_.organizationId AS organizationId_337, p10_.personId AS personId_338, p10_.contactTypeId AS contactTypeId_339, p11_.personId AS personId_340, p11_.emailTypeId AS emailTypeId_341, p12_.locationId AS locationId_342, p12_.positionId AS positionId_343, l13_.cityId AS cityId_344, l13_.stateId AS stateId_345, l13_.countryId AS countryId_346, l13_.organizationId AS organizationId_347, l13_.userId AS userId_348, s15_.countryId AS countryId_349, c16_.stateId AS stateId_350, s18_.countryId AS countryId_351, c19_.stateId AS stateId_352, d20_.dataPointId AS dataPointId_353, d20_.parentId AS parentId_354, d20_.organizationId AS organizationId_355 FROM Applications a0_ LEFT JOIN People p1_ ON a0_.personId = p1_.id LEFT JOIN Positions p2_ ON a0_.positionId = p2_.id LEFT JOIN CareerSites c3_ ON a0_.careerSiteId = c3_.id LEFT JOIN Organizations o4_ ON a0_.organizationId = o4_.id LEFT JOIN Positions p5_ ON a0_.positionAdId = p5_.id LEFT JOIN Applications a6_ ON a0_.parentId = a6_.id LEFT JOIN PersonLocations p7_ ON p1_.id = p7_.personId LEFT JOIN Locations l8_ ON p7_.locationId = l8_.id LEFT JOIN DataPointOptions d9_ ON a0_.stageId = d9_.id LEFT JOIN PeopleContacts p10_ ON p1_.id = p10_.personId AND (p10_.deletedAt IS NULL) LEFT JOIN PeopleEmails p11_ ON p1_.id = p11_.personId AND (p11_.deletedAt IS NULL) LEFT JOIN PositionLocations p12_ ON p2_.id = p12_.positionId LEFT JOIN Locations l13_ ON p12_.locationId = l13_.id LEFT JOIN Countries c14_ ON l13_.countryId = c14_.id LEFT JOIN States s15_ ON l13_.stateId = s15_.id LEFT JOIN Cities c16_ ON l13_.cityId = c16_.id LEFT JOIN Countries c17_ ON l8_.countryId = c17_.id LEFT JOIN States s18_ ON l8_.stateId = s18_.id LEFT JOIN Cities c19_ ON l8_.cityId = c19_.id LEFT JOIN DataPointOptions d20_ ON a0_.templateStageId = d20_.id WHERE a0_.id = ? AND a0_.organizationId = ? AND p12_.deletedAt IS NULL AND l13_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a0_.isFullServiceHiring IS NULL LIMIT 1
Parameters: 
[
  "25171"
  3
  194
  200
  201
  231
  261
  262
  680
  681
  682
  684
  686
  687
  688
  689
  690
  691
  692
  693
  694
  695
  696
  697
  698
  699
  700
  701
  702
  703
  704
  705
  706
  707
  708
  709
  710
  711
  712
  713
  714
  715
  716
  717
  718
  719
  720
  721
  722
  723
  724
  725
  726
  727
  728
  729
  730
  731
  732
  733
  734
  735
  736
  737
  738
  739
  740
  741
  742
  743
  744
  745
  746
  747
  748
  749
  750
  751
  752
  753
  754
  755
  756
  757
  758
  759
  760
  761
  762
  763
  764
  765
  766
  767
  768
  769
  770
  771
  772
  773
  774
  775
  776
  777
  778
  779
  780
  781
  782
  783
  784
  785
  786
  787
  788
  789
  790
  791
  792
  793
  794
  795
  796
  797
  798
  799
  800
  801
  802
  803
  804
  805
  806
  807
  808
  809
  810
  811
  812
  813
  814
  815
  816
  817
  818
  819
  820
  821
  822
  823
  824
  825
  826
  827
  828
  829
  830
  831
  832
  833
  834
  835
  836
  838
  871
  873
  936
  937
  938
  951
  21777
]
View formatted query    View runnable query    Explain query
30 2.15 ms 
SELECT d0_.id AS id_0, d0_.sectionOrder AS sectionOrder_1, d0_.iterationNumber AS iterationNumber_2, d0_.score AS score_3, d0_.createdAt AS createdAt_4, d0_.updatedAt AS updatedAt_5, d0_.deletedAt AS deletedAt_6, d0_.disqualified AS disqualified_7, d1_.id AS id_8, d1_.dataPointQuestionText AS dataPointQuestionText_9, d1_.valueText AS valueText_10, d1_.valueId AS valueId_11, d1_.displayOrder AS displayOrder_12, d1_.createdAt AS createdAt_13, d1_.updatedAt AS updatedAt_14, d1_.deletedAt AS deletedAt_15, d2_.id AS id_16, d2_.label AS label_17, d2_.identifier AS identifier_18, d2_.reference AS reference_19, d2_.method AS method_20, d2_.nonSelectableInsight AS nonSelectableInsight_21, d2_.isExportable AS isExportable_22, d2_.isSensitive AS isSensitive_23, d2_.isSortable AS isSortable_24, d2_.isConvertable AS isConvertable_25, d2_.displayName AS displayName_26, d2_.description AS description_27, d2_.columnWidth AS columnWidth_28, d2_.createdAt AS createdAt_29, d2_.updatedAt AS updatedAt_30, d2_.deletedAt AS deletedAt_31, d3_.id AS id_32, d3_.label AS label_33, d3_.description AS description_34, d3_.footer AS footer_35, d3_.identifier AS identifier_36, d3_.hidden AS hidden_37, d3_.searchable AS searchable_38, d3_.groupOrder AS groupOrder_39, d3_.createdAt AS createdAt_40, d3_.updatedAt AS updatedAt_41, d3_.deletedAt AS deletedAt_42, d4_.id AS id_43, d4_.text AS text_44, d4_.description AS description_45, d4_.footer AS footer_46, d4_.archivedAt AS archivedAt_47, d4_.createdAt AS createdAt_48, d4_.updatedAt AS updatedAt_49, d4_.deletedAt AS deletedAt_50, d5_.id AS id_51, d5_.label AS label_52, d5_.identifier AS identifier_53, d5_.inputRegex AS inputRegex_54, d5_.inputMask AS inputMask_55, d5_.isVisible AS isVisible_56, d5_.createdAt AS createdAt_57, d5_.updatedAt AS updatedAt_58, d5_.deletedAt AS deletedAt_59, i6_.id AS id_60, i6_.label AS label_61, i6_.identifier AS identifier_62, i6_.createdAt AS createdAt_63, i6_.updatedAt AS updatedAt_64, i6_.deletedAt AS deletedAt_65, d7_.id AS id_66, d7_.label AS label_67, d7_.value AS value_68, d7_.description AS description_69, d7_.identifier AS identifier_70, d7_.displayOrder AS displayOrder_71, d7_.isLocked AS isLocked_72, d7_.archivedAt AS archivedAt_73, d7_.createdAt AS createdAt_74, d7_.updatedAt AS updatedAt_75, d7_.deletedAt AS deletedAt_76, d0_.dataPointAnswerId AS dataPointAnswerId_77, d0_.applicationId AS applicationId_78, d0_.stageId AS stageId_79, d0_.templateStageId AS templateStageId_80, d1_.dataPointQuestionId AS dataPointQuestionId_81, d1_.dataPointId AS dataPointId_82, d1_.dataPointGroupId AS dataPointGroupId_83, d1_.userId AS userId_84, d1_.organizationId AS organizationId_85, d2_.dataPointGroupId AS dataPointGroupId_86, d2_.dataPointTypeId AS dataPointTypeId_87, d2_.dataPointResourceId AS dataPointResourceId_88, d2_.parentDataPointResourceId AS parentDataPointResourceId_89, d2_.organizationId AS organizationId_90, d2_.parentId AS parentId_91, d2_.masterId AS masterId_92, d2_.widgetId AS widgetId_93, d3_.organizationId AS organizationId_94, d3_.parentId AS parentId_95, d4_.dataPointId AS dataPointId_96, d4_.organizationId AS organizationId_97, d4_.parentId AS parentId_98, d4_.masterId AS masterId_99, d4_.userId AS userId_100, d5_.inputTypeId AS inputTypeId_101, d7_.dataPointId AS dataPointId_102, d7_.parentId AS parentId_103, d7_.organizationId AS organizationId_104 FROM DataPointAnswerApplications d0_ LEFT JOIN DataPointAnswers d1_ ON d0_.dataPointAnswerId = d1_.id LEFT JOIN DataPoints d2_ ON d1_.dataPointId = d2_.id LEFT JOIN DataPointGroups d3_ ON d1_.dataPointGroupId = d3_.id LEFT JOIN DataPointQuestions d4_ ON d1_.dataPointQuestionId = d4_.id LEFT JOIN DataPointTypes d5_ ON d2_.dataPointTypeId = d5_.id LEFT JOIN InputTypes i6_ ON d5_.inputTypeId = i6_.id LEFT JOIN DataPointOptions d7_ ON d0_.templateStageId = d7_.id WHERE d0_.applicationId = ? AND d0_.deletedAt IS NULL AND d4_.deletedAt IS NULL
Parameters: 
[
  25171
]
View formatted query    View runnable query    Explain query
31 1.13 ms 
SELECT
                DataPointAnswerApplications.id AS id0, DataPointAnswerApplications.sectionOrder AS sectionOrder1, DataPointAnswerApplications.iterationNumber AS iterationNumber2, DataPointAnswerApplications.score AS score3, DataPointAnswerApplications.createdAt AS createdAt4, DataPointAnswerApplications.updatedAt AS updatedAt5, DataPointAnswerApplications.deletedAt AS deletedAt6, DataPointAnswerApplications.disqualified AS disqualified7, DataPointAnswerApplications.dataPointAnswerId AS dataPointAnswerId8, DataPointAnswerApplications.applicationId AS applicationId9, DataPointAnswerApplications.stageId AS stageId10, DataPointAnswerApplications.templateStageId AS templateStageId11, DataPointAnswers.id AS id12, DataPointAnswers.dataPointQuestionText AS dataPointQuestionText13, DataPointAnswers.valueText AS valueText14, DataPointAnswers.valueId AS valueId15, DataPointAnswers.displayOrder AS displayOrder16, DataPointAnswers.createdAt AS createdAt17, DataPointAnswers.updatedAt AS updatedAt18, DataPointAnswers.deletedAt AS deletedAt19, DataPointAnswers.dataPointQuestionId AS dataPointQuestionId20, DataPointAnswers.dataPointId AS dataPointId21, DataPointAnswers.dataPointGroupId AS dataPointGroupId22, DataPointAnswers.userId AS userId23, DataPointAnswers.organizationId AS organizationId24
            FROM
                `DataPointAnswerApplications`
            JOIN
                `DataPointAnswers` ON DataPointAnswers.`id` = DataPointAnswerApplications.`dataPointAnswerId`
            JOIN
                `DataPoints` ON DataPoints.`id` = DataPointAnswers.`dataPointId`
            WHERE
                DataPointAnswerApplications.`deletedAt` IS NULL
            AND
                DataPointAnswers.`deletedAt` IS NULL
            AND
                DataPoints.`deletedAt` IS NULL
            AND
                DataPointAnswerApplications.`applicationId` = ?
            AND
                DataPoints.`identifier` = ?
            AND
                DataPointAnswers.`organizationId` = ?
            ORDER BY
                DataPointAnswerApplications.`id` DESC
Parameters: 
[
  25171
  "INDEED_APPLICATION_SOURCE_ATTRIBUTION"
  3
]
View formatted query    View runnable query    Explain query
32 0.93 ms 
SELECT d0_.id AS id_0, d0_.createdAt AS createdAt_1, d0_.updatedAt AS updatedAt_2, d0_.deletedAt AS deletedAt_3, d0_.dataPointTemplateId AS dataPointTemplateId_4, d0_.positionId AS positionId_5 FROM DataPointTemplatePositions d0_ INNER JOIN DataPointTemplates d1_ ON d0_.dataPointTemplateId = d1_.id INNER JOIN DataPointTemplateTypes d2_ ON d1_.dataPointTemplateTypeId = d2_.id WHERE d1_.id IN (?) AND d2_.identifier IN (?)
Parameters: 
[
  10
  "APPLICATION_TEMPLATES"
]
View formatted query    View runnable query    Explain query
33 0.49 ms 
SELECT d0_.id AS id_0, d0_.createdAt AS createdAt_1, d0_.updatedAt AS updatedAt_2, d0_.deletedAt AS deletedAt_3, d0_.dataPointTemplateId AS dataPointTemplateId_4, d0_.positionId AS positionId_5 FROM DataPointTemplatePositions d0_ INNER JOIN DataPointTemplates d1_ ON d0_.dataPointTemplateId = d1_.id INNER JOIN DataPointTemplateTypes d2_ ON d1_.dataPointTemplateTypeId = d2_.id WHERE d1_.id IN (NULL) AND d2_.identifier IN (?)
Parameters: 
[
  "JOB_QUESTIONS"
]
View formatted query    View runnable query    Explain query
34 1.10 ms 
SELECT d0_.id AS id_0, d0_.iterations AS iterations_1, d0_.label AS label_2, d0_.description AS description_3, d0_.footer AS footer_4, d0_.displayOrder AS displayOrder_5, d0_.createdAt AS createdAt_6, d0_.updatedAt AS updatedAt_7, d0_.deletedAt AS deletedAt_8, d1_.id AS id_9, d1_.label AS label_10, d1_.description AS description_11, d1_.footer AS footer_12, d1_.identifier AS identifier_13, d1_.hidden AS hidden_14, d1_.searchable AS searchable_15, d1_.groupOrder AS groupOrder_16, d1_.createdAt AS createdAt_17, d1_.updatedAt AS updatedAt_18, d1_.deletedAt AS deletedAt_19, d0_.dataPointGroupId AS dataPointGroupId_20, d0_.dataPointTemplateId AS dataPointTemplateId_21, d0_.organizationId AS organizationId_22, d1_.organizationId AS organizationId_23, d1_.parentId AS parentId_24 FROM DataPointGroupIterations d0_ LEFT JOIN DataPointGroups d1_ ON d0_.dataPointGroupId = d1_.id INNER JOIN DataPointTemplates d2_ ON d0_.dataPointTemplateId = d2_.id WHERE d2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d0_.organizationId = ? ORDER BY d0_.displayOrder ASC
Parameters: 
[
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  10
  3
]
View formatted query    View runnable query    Explain query
35 0.41 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.identifier AS identifier_3, t0.isFullServiceHiring AS isFullServiceHiring_4, t0.isLocked AS isLocked_5, t0.isMultiStage AS isMultiStage_6, t0.useIndeedShortApp AS useIndeedShortApp_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.archivedAt AS archivedAt_10, t0.publishedAt AS publishedAt_11, t0.deletedAt AS deletedAt_12, t0.masterId AS masterId_13, t0.organizationId AS organizationId_14, t0.dataPointTemplateTypeId AS dataPointTemplateTypeId_15 FROM DataPointTemplates t0 WHERE t0.id = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
36 0.31 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.identifier AS identifier_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deletedAt AS deletedAt_6 FROM DataPointTemplateTypes t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
37 0.81 ms 
SELECT 1
            FROM 
                DataPointGroupIterations dataPointGroupIteration
            WHERE
                dataPointGroupIteration.`dataPointGroupId` = ?
            AND
                dataPointGroupIteration.`deletedAt` IS NULL
            AND 
                dataPointGroupIteration.`dataPointTemplateId` = ?
            AND 
                dataPointGroupIteration.`dataPointTemplateId` NOT IN (
                    SELECT dataPointTemplateId
                    FROM
                        DataPointTemplateQuestions dataPointTemplateQuestion
                    WHERE
                        dataPointTemplateQuestion.`dataPointQuestionId` IN (
                            SELECT id
                            FROM 
                                DataPointQuestions dataPointQuestion
                            WHERE
                                dataPointQuestion.`dataPointId` IN (
                                    SELECT id
                                    FROM DataPoints dataPoint
                                    WHERE 
                                        dataPoint.`dataPointGroupId` = ?
                                )
                            AND
                                dataPointQuestion.`deletedAt` IS NULL
                    )
                    AND 
                        dataPointTemplateQuestion.`deletedAt` IS NULL
                    GROUP BY dataPointTemplateId
                )
Parameters: 
[
  19
  10
  19
]
View formatted query    View runnable query    Explain query
38 1.09 ms 
SELECT 1
            FROM 
                DataPointGroupIterations dataPointGroupIteration
            WHERE
                dataPointGroupIteration.`dataPointGroupId` = ?
            AND
                dataPointGroupIteration.`deletedAt` IS NULL
            AND 
                dataPointGroupIteration.`dataPointTemplateId` = ?
            AND 
                dataPointGroupIteration.`dataPointTemplateId` NOT IN (
                    SELECT dataPointTemplateId
                    FROM
                        DataPointTemplateQuestions dataPointTemplateQuestion
                    WHERE
                        dataPointTemplateQuestion.`dataPointQuestionId` IN (
                            SELECT id
                            FROM 
                                DataPointQuestions dataPointQuestion
                            WHERE
                                dataPointQuestion.`dataPointId` IN (
                                    SELECT id
                                    FROM DataPoints dataPoint
                                    WHERE 
                                        dataPoint.`dataPointGroupId` = ?
                                )
                            AND
                                dataPointQuestion.`deletedAt` IS NULL
                    )
                    AND 
                        dataPointTemplateQuestion.`deletedAt` IS NULL
                    GROUP BY dataPointTemplateId
                )
Parameters: 
[
  9
  10
  9
]
View formatted query    View runnable query    Explain query
39 1.03 ms 
SELECT 1
            FROM 
                DataPointGroupIterations dataPointGroupIteration
            WHERE
                dataPointGroupIteration.`dataPointGroupId` = ?
            AND
                dataPointGroupIteration.`deletedAt` IS NULL
            AND 
                dataPointGroupIteration.`dataPointTemplateId` = ?
            AND 
                dataPointGroupIteration.`dataPointTemplateId` NOT IN (
                    SELECT dataPointTemplateId
                    FROM
                        DataPointTemplateQuestions dataPointTemplateQuestion
                    WHERE
                        dataPointTemplateQuestion.`dataPointQuestionId` IN (
                            SELECT id
                            FROM 
                                DataPointQuestions dataPointQuestion
                            WHERE
                                dataPointQuestion.`dataPointId` IN (
                                    SELECT id
                                    FROM DataPoints dataPoint
                                    WHERE 
                                        dataPoint.`dataPointGroupId` = ?
                                )
                            AND
                                dataPointQuestion.`deletedAt` IS NULL
                    )
                    AND 
                        dataPointTemplateQuestion.`deletedAt` IS NULL
                    GROUP BY dataPointTemplateId
                )
Parameters: 
[
  12
  10
  12
]
View formatted query    View runnable query    Explain query
40 0.53 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, p0_.parentId AS parentId_18, p0_.copiedFromId AS copiedFromId_19, p0_.statusId AS statusId_20, p0_.organizationDepartmentId AS organizationDepartmentId_21, p0_.organizationId AS organizationId_22, p0_.templateId AS templateId_23, p0_.userId AS userId_24, p0_.locationTypeId AS locationTypeId_25 FROM Positions p0_ INNER JOIN DataPointTemplatePositions d1_ ON p0_.id = d1_.positionId INNER JOIN DataPointTemplates d2_ ON d1_.dataPointTemplateId = d2_.id INNER JOIN DataPointGroupIterations d3_ ON d2_.id = d3_.dataPointTemplateId WHERE p0_.id = ? AND d3_.id = ? AND d3_.deletedAt IS NULL LIMIT 1
Parameters: 
[
  43
  1255
]
View formatted query    View runnable query    Explain query
41 0.70 ms 
SELECT 1
            FROM 
                DataPointGroupIterations dataPointGroupIteration
            WHERE
                dataPointGroupIteration.`dataPointGroupId` = ?
            AND
                dataPointGroupIteration.`deletedAt` IS NULL
            AND 
                dataPointGroupIteration.`dataPointTemplateId` = ?
            AND 
                dataPointGroupIteration.`dataPointTemplateId` NOT IN (
                    SELECT dataPointTemplateId
                    FROM
                        DataPointTemplateQuestions dataPointTemplateQuestion
                    WHERE
                        dataPointTemplateQuestion.`dataPointQuestionId` IN (
                            SELECT id
                            FROM 
                                DataPointQuestions dataPointQuestion
                            WHERE
                                dataPointQuestion.`dataPointId` IN (
                                    SELECT id
                                    FROM DataPoints dataPoint
                                    WHERE 
                                        dataPoint.`dataPointGroupId` = ?
                                )
                            AND
                                dataPointQuestion.`deletedAt` IS NULL
                    )
                    AND 
                        dataPointTemplateQuestion.`deletedAt` IS NULL
                    GROUP BY dataPointTemplateId
                )
Parameters: 
[
  14
  10
  14
]
View formatted query    View runnable query    Explain query
42 0.43 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, p0_.parentId AS parentId_18, p0_.copiedFromId AS copiedFromId_19, p0_.statusId AS statusId_20, p0_.organizationDepartmentId AS organizationDepartmentId_21, p0_.organizationId AS organizationId_22, p0_.templateId AS templateId_23, p0_.userId AS userId_24, p0_.locationTypeId AS locationTypeId_25 FROM Positions p0_ INNER JOIN DataPointTemplatePositions d1_ ON p0_.id = d1_.positionId INNER JOIN DataPointTemplates d2_ ON d1_.dataPointTemplateId = d2_.id INNER JOIN DataPointGroupIterations d3_ ON d2_.id = d3_.dataPointTemplateId WHERE p0_.id = ? AND d3_.id = ? AND d3_.deletedAt IS NULL LIMIT 1
Parameters: 
[
  43
  35
]
View formatted query    View runnable query    Explain query
43 0.32 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, p0_.parentId AS parentId_18, p0_.copiedFromId AS copiedFromId_19, p0_.statusId AS statusId_20, p0_.organizationDepartmentId AS organizationDepartmentId_21, p0_.organizationId AS organizationId_22, p0_.templateId AS templateId_23, p0_.userId AS userId_24, p0_.locationTypeId AS locationTypeId_25 FROM Positions p0_ INNER JOIN DataPointTemplatePositions d1_ ON p0_.id = d1_.positionId INNER JOIN DataPointTemplates d2_ ON d1_.dataPointTemplateId = d2_.id INNER JOIN DataPointGroupIterations d3_ ON d2_.id = d3_.dataPointTemplateId WHERE p0_.id = ? AND d3_.id = ? AND d3_.deletedAt IS NULL LIMIT 1
Parameters: 
[
  43
  146
]
View formatted query    View runnable query    Explain query
44 0.35 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, p0_.parentId AS parentId_18, p0_.copiedFromId AS copiedFromId_19, p0_.statusId AS statusId_20, p0_.organizationDepartmentId AS organizationDepartmentId_21, p0_.organizationId AS organizationId_22, p0_.templateId AS templateId_23, p0_.userId AS userId_24, p0_.locationTypeId AS locationTypeId_25 FROM Positions p0_ INNER JOIN DataPointTemplatePositions d1_ ON p0_.id = d1_.positionId INNER JOIN DataPointTemplates d2_ ON d1_.dataPointTemplateId = d2_.id INNER JOIN DataPointGroupIterations d3_ ON d2_.id = d3_.dataPointTemplateId WHERE p0_.id = ? AND d3_.id = ? AND d3_.deletedAt IS NULL LIMIT 1
Parameters: 
[
  43
  231
]
View formatted query    View runnable query    Explain query
45 1.00 ms 
SELECT 1
            FROM 
                DataPointGroupIterations dataPointGroupIteration
            WHERE
                dataPointGroupIteration.`dataPointGroupId` = ?
            AND
                dataPointGroupIteration.`deletedAt` IS NULL
            AND 
                dataPointGroupIteration.`dataPointTemplateId` = ?
            AND 
                dataPointGroupIteration.`dataPointTemplateId` NOT IN (
                    SELECT dataPointTemplateId
                    FROM
                        DataPointTemplateQuestions dataPointTemplateQuestion
                    WHERE
                        dataPointTemplateQuestion.`dataPointQuestionId` IN (
                            SELECT id
                            FROM 
                                DataPointQuestions dataPointQuestion
                            WHERE
                                dataPointQuestion.`dataPointId` IN (
                                    SELECT id
                                    FROM DataPoints dataPoint
                                    WHERE 
                                        dataPoint.`dataPointGroupId` = ?
                                )
                            AND
                                dataPointQuestion.`deletedAt` IS NULL
                    )
                    AND 
                        dataPointTemplateQuestion.`deletedAt` IS NULL
                    GROUP BY dataPointTemplateId
                )
Parameters: 
[
  8
  10
  8
]
View formatted query    View runnable query    Explain query
46 0.46 ms 
SELECT 1
            FROM 
                DataPointGroupIterations dataPointGroupIteration
            WHERE
                dataPointGroupIteration.`dataPointGroupId` = ?
            AND
                dataPointGroupIteration.`deletedAt` IS NULL
            AND 
                dataPointGroupIteration.`dataPointTemplateId` = ?
            AND 
                dataPointGroupIteration.`dataPointTemplateId` NOT IN (
                    SELECT dataPointTemplateId
                    FROM
                        DataPointTemplateQuestions dataPointTemplateQuestion
                    WHERE
                        dataPointTemplateQuestion.`dataPointQuestionId` IN (
                            SELECT id
                            FROM 
                                DataPointQuestions dataPointQuestion
                            WHERE
                                dataPointQuestion.`dataPointId` IN (
                                    SELECT id
                                    FROM DataPoints dataPoint
                                    WHERE 
                                        dataPoint.`dataPointGroupId` = ?
                                )
                            AND
                                dataPointQuestion.`deletedAt` IS NULL
                    )
                    AND 
                        dataPointTemplateQuestion.`deletedAt` IS NULL
                    GROUP BY dataPointTemplateId
                )
Parameters: 
[
  10
  10
  10
]
View formatted query    View runnable query    Explain query
47 0.40 ms 
SELECT 1
            FROM 
                DataPointGroupIterations dataPointGroupIteration
            WHERE
                dataPointGroupIteration.`dataPointGroupId` = ?
            AND
                dataPointGroupIteration.`deletedAt` IS NULL
            AND 
                dataPointGroupIteration.`dataPointTemplateId` = ?
            AND 
                dataPointGroupIteration.`dataPointTemplateId` NOT IN (
                    SELECT dataPointTemplateId
                    FROM
                        DataPointTemplateQuestions dataPointTemplateQuestion
                    WHERE
                        dataPointTemplateQuestion.`dataPointQuestionId` IN (
                            SELECT id
                            FROM 
                                DataPointQuestions dataPointQuestion
                            WHERE
                                dataPointQuestion.`dataPointId` IN (
                                    SELECT id
                                    FROM DataPoints dataPoint
                                    WHERE 
                                        dataPoint.`dataPointGroupId` = ?
                                )
                            AND
                                dataPointQuestion.`deletedAt` IS NULL
                    )
                    AND 
                        dataPointTemplateQuestion.`deletedAt` IS NULL
                    GROUP BY dataPointTemplateId
                )
Parameters: 
[
  13
  10
  13
]
View formatted query    View runnable query    Explain query
48 0.46 ms 
SELECT 1
            FROM 
                DataPointGroupIterations dataPointGroupIteration
            WHERE
                dataPointGroupIteration.`dataPointGroupId` = ?
            AND
                dataPointGroupIteration.`deletedAt` IS NULL
            AND 
                dataPointGroupIteration.`dataPointTemplateId` = ?
            AND 
                dataPointGroupIteration.`dataPointTemplateId` NOT IN (
                    SELECT dataPointTemplateId
                    FROM
                        DataPointTemplateQuestions dataPointTemplateQuestion
                    WHERE
                        dataPointTemplateQuestion.`dataPointQuestionId` IN (
                            SELECT id
                            FROM 
                                DataPointQuestions dataPointQuestion
                            WHERE
                                dataPointQuestion.`dataPointId` IN (
                                    SELECT id
                                    FROM DataPoints dataPoint
                                    WHERE 
                                        dataPoint.`dataPointGroupId` = ?
                                )
                            AND
                                dataPointQuestion.`deletedAt` IS NULL
                    )
                    AND 
                        dataPointTemplateQuestion.`deletedAt` IS NULL
                    GROUP BY dataPointTemplateId
                )
Parameters: 
[
  16
  10
  16
]
View formatted query    View runnable query    Explain query
49 0.33 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, p0_.parentId AS parentId_18, p0_.copiedFromId AS copiedFromId_19, p0_.statusId AS statusId_20, p0_.organizationDepartmentId AS organizationDepartmentId_21, p0_.organizationId AS organizationId_22, p0_.templateId AS templateId_23, p0_.userId AS userId_24, p0_.locationTypeId AS locationTypeId_25 FROM Positions p0_ INNER JOIN DataPointTemplatePositions d1_ ON p0_.id = d1_.positionId INNER JOIN DataPointTemplates d2_ ON d1_.dataPointTemplateId = d2_.id INNER JOIN DataPointGroupIterations d3_ ON d2_.id = d3_.dataPointTemplateId WHERE p0_.id = ? AND d3_.id = ? AND d3_.deletedAt IS NULL LIMIT 1
Parameters: 
[
  43
  32
]
View formatted query    View runnable query    Explain query
50 0.28 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, p0_.parentId AS parentId_18, p0_.copiedFromId AS copiedFromId_19, p0_.statusId AS statusId_20, p0_.organizationDepartmentId AS organizationDepartmentId_21, p0_.organizationId AS organizationId_22, p0_.templateId AS templateId_23, p0_.userId AS userId_24, p0_.locationTypeId AS locationTypeId_25 FROM Positions p0_ INNER JOIN DataPointTemplatePositions d1_ ON p0_.id = d1_.positionId INNER JOIN DataPointTemplates d2_ ON d1_.dataPointTemplateId = d2_.id INNER JOIN DataPointGroupIterations d3_ ON d2_.id = d3_.dataPointTemplateId WHERE p0_.id = ? AND d3_.id = ? AND d3_.deletedAt IS NULL LIMIT 1
Parameters: 
[
  43
  208
]
View formatted query    View runnable query    Explain query
51 0.27 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, p0_.parentId AS parentId_18, p0_.copiedFromId AS copiedFromId_19, p0_.statusId AS statusId_20, p0_.organizationDepartmentId AS organizationDepartmentId_21, p0_.organizationId AS organizationId_22, p0_.templateId AS templateId_23, p0_.userId AS userId_24, p0_.locationTypeId AS locationTypeId_25 FROM Positions p0_ INNER JOIN DataPointTemplatePositions d1_ ON p0_.id = d1_.positionId INNER JOIN DataPointTemplates d2_ ON d1_.dataPointTemplateId = d2_.id INNER JOIN DataPointGroupIterations d3_ ON d2_.id = d3_.dataPointTemplateId WHERE p0_.id = ? AND d3_.id = ? AND d3_.deletedAt IS NULL LIMIT 1
Parameters: 
[
  43
  136
]
View formatted query    View runnable query    Explain query
52 0.25 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, p0_.parentId AS parentId_18, p0_.copiedFromId AS copiedFromId_19, p0_.statusId AS statusId_20, p0_.organizationDepartmentId AS organizationDepartmentId_21, p0_.organizationId AS organizationId_22, p0_.templateId AS templateId_23, p0_.userId AS userId_24, p0_.locationTypeId AS locationTypeId_25 FROM Positions p0_ INNER JOIN DataPointTemplatePositions d1_ ON p0_.id = d1_.positionId INNER JOIN DataPointTemplates d2_ ON d1_.dataPointTemplateId = d2_.id INNER JOIN DataPointGroupIterations d3_ ON d2_.id = d3_.dataPointTemplateId WHERE p0_.id = ? AND d3_.id = ? AND d3_.deletedAt IS NULL LIMIT 1
Parameters: 
[
  43
  81
]
View formatted query    View runnable query    Explain query
53 0.35 ms 
SELECT 1
            FROM 
                DataPointGroupIterations dataPointGroupIteration
            WHERE
                dataPointGroupIteration.`dataPointGroupId` = ?
            AND
                dataPointGroupIteration.`deletedAt` IS NULL
            AND 
                dataPointGroupIteration.`dataPointTemplateId` = ?
            AND 
                dataPointGroupIteration.`dataPointTemplateId` NOT IN (
                    SELECT dataPointTemplateId
                    FROM
                        DataPointTemplateQuestions dataPointTemplateQuestion
                    WHERE
                        dataPointTemplateQuestion.`dataPointQuestionId` IN (
                            SELECT id
                            FROM 
                                DataPointQuestions dataPointQuestion
                            WHERE
                                dataPointQuestion.`dataPointId` IN (
                                    SELECT id
                                    FROM DataPoints dataPoint
                                    WHERE 
                                        dataPoint.`dataPointGroupId` = ?
                                )
                            AND
                                dataPointQuestion.`deletedAt` IS NULL
                    )
                    AND 
                        dataPointTemplateQuestion.`deletedAt` IS NULL
                    GROUP BY dataPointTemplateId
                )
Parameters: 
[
  18
  10
  18
]
View formatted query    View runnable query    Explain query
54 0.39 ms 
SELECT 1
            FROM 
                DataPointGroupIterations dataPointGroupIteration
            WHERE
                dataPointGroupIteration.`dataPointGroupId` = ?
            AND
                dataPointGroupIteration.`deletedAt` IS NULL
            AND 
                dataPointGroupIteration.`dataPointTemplateId` = ?
            AND 
                dataPointGroupIteration.`dataPointTemplateId` NOT IN (
                    SELECT dataPointTemplateId
                    FROM
                        DataPointTemplateQuestions dataPointTemplateQuestion
                    WHERE
                        dataPointTemplateQuestion.`dataPointQuestionId` IN (
                            SELECT id
                            FROM 
                                DataPointQuestions dataPointQuestion
                            WHERE
                                dataPointQuestion.`dataPointId` IN (
                                    SELECT id
                                    FROM DataPoints dataPoint
                                    WHERE 
                                        dataPoint.`dataPointGroupId` = ?
                                )
                            AND
                                dataPointQuestion.`deletedAt` IS NULL
                    )
                    AND 
                        dataPointTemplateQuestion.`deletedAt` IS NULL
                    GROUP BY dataPointTemplateId
                )
Parameters: 
[
  17
  10
  17
]
View formatted query    View runnable query    Explain query
55 0.29 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, p0_.parentId AS parentId_18, p0_.copiedFromId AS copiedFromId_19, p0_.statusId AS statusId_20, p0_.organizationDepartmentId AS organizationDepartmentId_21, p0_.organizationId AS organizationId_22, p0_.templateId AS templateId_23, p0_.userId AS userId_24, p0_.locationTypeId AS locationTypeId_25 FROM Positions p0_ INNER JOIN DataPointTemplatePositions d1_ ON p0_.id = d1_.positionId INNER JOIN DataPointTemplates d2_ ON d1_.dataPointTemplateId = d2_.id INNER JOIN DataPointGroupIterations d3_ ON d2_.id = d3_.dataPointTemplateId WHERE p0_.id = ? AND d3_.id = ? AND d3_.deletedAt IS NULL LIMIT 1
Parameters: 
[
  43
  107
]
View formatted query    View runnable query    Explain query
56 0.25 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, p0_.parentId AS parentId_18, p0_.copiedFromId AS copiedFromId_19, p0_.statusId AS statusId_20, p0_.organizationDepartmentId AS organizationDepartmentId_21, p0_.organizationId AS organizationId_22, p0_.templateId AS templateId_23, p0_.userId AS userId_24, p0_.locationTypeId AS locationTypeId_25 FROM Positions p0_ INNER JOIN DataPointTemplatePositions d1_ ON p0_.id = d1_.positionId INNER JOIN DataPointTemplates d2_ ON d1_.dataPointTemplateId = d2_.id INNER JOIN DataPointGroupIterations d3_ ON d2_.id = d3_.dataPointTemplateId WHERE p0_.id = ? AND d3_.id = ? AND d3_.deletedAt IS NULL LIMIT 1
Parameters: 
[
  43
  33
]
View formatted query    View runnable query    Explain query
57 0.48 ms 
SELECT 1
            FROM 
                DataPointGroupIterations dataPointGroupIteration
            WHERE
                dataPointGroupIteration.`dataPointGroupId` = ?
            AND
                dataPointGroupIteration.`deletedAt` IS NULL
            AND 
                dataPointGroupIteration.`dataPointTemplateId` = ?
            AND 
                dataPointGroupIteration.`dataPointTemplateId` NOT IN (
                    SELECT dataPointTemplateId
                    FROM
                        DataPointTemplateQuestions dataPointTemplateQuestion
                    WHERE
                        dataPointTemplateQuestion.`dataPointQuestionId` IN (
                            SELECT id
                            FROM 
                                DataPointQuestions dataPointQuestion
                            WHERE
                                dataPointQuestion.`dataPointId` IN (
                                    SELECT id
                                    FROM DataPoints dataPoint
                                    WHERE 
                                        dataPoint.`dataPointGroupId` = ?
                                )
                            AND
                                dataPointQuestion.`deletedAt` IS NULL
                    )
                    AND 
                        dataPointTemplateQuestion.`deletedAt` IS NULL
                    GROUP BY dataPointTemplateId
                )
Parameters: 
[
  15
  10
  15
]
View formatted query    View runnable query    Explain query
58 0.30 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, p0_.parentId AS parentId_18, p0_.copiedFromId AS copiedFromId_19, p0_.statusId AS statusId_20, p0_.organizationDepartmentId AS organizationDepartmentId_21, p0_.organizationId AS organizationId_22, p0_.templateId AS templateId_23, p0_.userId AS userId_24, p0_.locationTypeId AS locationTypeId_25 FROM Positions p0_ INNER JOIN DataPointTemplatePositions d1_ ON p0_.id = d1_.positionId INNER JOIN DataPointTemplates d2_ ON d1_.dataPointTemplateId = d2_.id INNER JOIN DataPointGroupIterations d3_ ON d2_.id = d3_.dataPointTemplateId WHERE p0_.id = ? AND d3_.id = ? AND d3_.deletedAt IS NULL LIMIT 1
Parameters: 
[
  43
  523
]
View formatted query    View runnable query    Explain query
59 0.44 ms 
SELECT
                application.`id` AS id,
                application.`submittedAt` AS submittedAt,
                application.`archivedAt` AS archivedAt
            FROM
                `Applications` application
            WHERE
                application.`organizationId` = ?
            AND
                application.`personId` = ?
            AND
                application.`positionId` = ?
            AND
                application.`deletedAt` IS NULL
            AND
                application.`submittedAt` IS NOT NULL
            ORDER BY application.`submittedAt` DESC, application.`id` DESC
            LIMIT 1
Parameters: 
[
  3
  20296
  43
]
View formatted query    View runnable query    Explain query
60 0.69 ms 
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.deletedAt AS deletedAt_4, t0.positionId AS positionId_5, t0.careerSiteId AS careerSiteId_6 FROM PositionCareerSites t0 WHERE t0.positionId = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
61 0.48 ms 
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.deletedAt AS deletedAt_5 FROM EmailTypes t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
62 0.36 ms 
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.deletedAt AS deletedAt_5 FROM ContactTypes t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
63 0.39 ms 
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.deletedAt AS deletedAt_4, t0.dataPointAnswerId AS dataPointAnswerId_5, t0.personId AS personId_6 FROM DataPointAnswerPeople t0 WHERE t0.personId = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  20296
]
View formatted query    View runnable query    Explain query
64 0.30 ms 
SELECT t0.id AS id_1, t0.dataPointQuestionText AS dataPointQuestionText_2, t0.valueText AS valueText_3, t0.valueId AS valueId_4, t0.displayOrder AS displayOrder_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.deletedAt AS deletedAt_8, t0.dataPointQuestionId AS dataPointQuestionId_9, t0.dataPointId AS dataPointId_10, t0.dataPointGroupId AS dataPointGroupId_11, t0.userId AS userId_12, t0.organizationId AS organizationId_13 FROM DataPointAnswers t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  475891
]
View formatted query    View runnable query    Explain query
65 0.31 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.identifier AS identifier_3, t0.reference AS reference_4, t0.method AS method_5, t0.nonSelectableInsight AS nonSelectableInsight_6, t0.isExportable AS isExportable_7, t0.isSensitive AS isSensitive_8, t0.isSortable AS isSortable_9, t0.isConvertable AS isConvertable_10, t0.displayName AS displayName_11, t0.description AS description_12, t0.columnWidth AS columnWidth_13, t0.createdAt AS createdAt_14, t0.updatedAt AS updatedAt_15, t0.deletedAt AS deletedAt_16, t0.dataPointGroupId AS dataPointGroupId_17, t0.dataPointTypeId AS dataPointTypeId_18, t0.dataPointResourceId AS dataPointResourceId_19, t0.parentDataPointResourceId AS parentDataPointResourceId_20, t0.organizationId AS organizationId_21, t0.parentId AS parentId_22, t0.masterId AS masterId_23, t0.widgetId AS widgetId_24 FROM DataPoints t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  141
]
View formatted query    View runnable query    Explain query
66 0.27 ms 
SELECT t0.id AS id_1, t0.source AS source_2, t0.label AS label_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deletedAt AS deletedAt_6 FROM MessageSources t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
67 0.53 ms 
SELECT t0.id AS id_1, t0.startedAt AS startedAt_2, t0.submittedAt AS submittedAt_3, t0.archivedAt AS archivedAt_4, t0.stageUpdatedAt AS stageUpdatedAt_5, t0.positionTitle AS positionTitle_6, t0.isDisqualified AS isDisqualified_7, t0.score AS score_8, t0.aiMatchScore AS aiMatchScore_9, t0.aiMatchReasons AS aiMatchReasons_10, t0.aiMatchGaps AS aiMatchGaps_11, t0.aiMatchScoredAt AS aiMatchScoredAt_12, t0.aiMatchRescoreCount AS aiMatchRescoreCount_13, t0.aiMatchRescoredOn AS aiMatchRescoredOn_14, t0.IpAddress AS IpAddress_15, t0.isImported AS isImported_16, t0.isFullServiceHiring AS isFullServiceHiring_17, t0.clientNote AS clientNote_18, t0.clientReleasedAt AS clientReleasedAt_19, t0.remoteApplicationId AS remoteApplicationId_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.deletedAt AS deletedAt_23, t0.initialSubmittedAt AS initialSubmittedAt_24, t0.stageId AS stageId_25, t0.templateStageId AS templateStageId_26, t0.positionId AS positionId_27, t0.sourceId AS sourceId_28, t0.firstSourceAttributionId AS firstSourceAttributionId_29, t0.secondSourceAttributionId AS secondSourceAttributionId_30, t0.thirdSourceAttributionId AS thirdSourceAttributionId_31, t0.fitBadgeId AS fitBadgeId_32, t0.aiFitBadgeId AS aiFitBadgeId_33, t0.positionAdId AS positionAdId_34, t0.parentId AS parentId_35, t0.careerSiteId AS careerSiteId_36, t0.organizationId AS organizationId_37, t0.personId AS personId_38, t0.addedById AS addedById_39 FROM Applications t0 WHERE t0.parentId = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  25171
]
View formatted query    View runnable query    Explain query
68 0.36 ms 
SELECT t0.id AS id_1, t0.submittedAt AS submittedAt_2, t0.isDisqualified AS isDisqualified_3, t0.score AS score_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deletedAt AS deletedAt_7, t0.applicationId AS applicationId_8, t0.personSubmittedBy AS personSubmittedBy_9, t0.stageId AS stageId_10, t0.templateStageId AS templateStageId_11 FROM ApplicationSubmissionHistories t0 WHERE t0.applicationId = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  25171
]
View formatted query    View runnable query    Explain query
69 0.26 ms 
SELECT t0.id AS id_1, t0.description AS description_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.deletedAt AS deletedAt_5 FROM PersonTypes t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
70 0.34 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_15, t0.parentId AS parentId_16, t0.organizationId AS organizationId_17 FROM DataPointOptions t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters: 
[
  110
]
View formatted query    View runnable query    Explain query
71 0.53 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
72 0.45 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: 
[
  208336
]
View formatted query    View runnable query    Explain query
73 0.10 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
74 3.14 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_application_by_id"
  "http://localhost/api/applications/25171"
  "GET"
  200
  "1.0.0"
  Symfony\Component\HttpFoundation\Response {#21719
    __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 19:13:56 GMT\r\n
      X-Debug-Token: 22fa44\r\n
      \r\n
      {"code":200,"message":null,"content":{"application":{"position":{"id":43,"title":"Minimal Job","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":"Fishers","abbreviation":null,"created_at":"2019-04-10T20:24:04+00:00","updated_at":"2019-04-10T20:24:04+00:00","deleted_at":null},"country":{"id":1,"name":"United States","iso":"US","iso3":"USA","display_order":2,"created_at":"2019-04-02T02:21:36+00:00","updated_at":"2019-04-02T02:21:36+00:00","deleted_at":null},"latitude":"39.961891","longitude":"-86.009207","state":{"country":{"id":1,"iso":"US"},"id":16,"label":"Indiana","abbreviation":"IN","created_at":"2019-04-02T02:21:37+00:00","updated_at":"2022-06-02T20:13:46+00:00","deleted_at":null,"created_on":null,"latitude":"40.551217","longitude":"-85.602364"},"id":26,"is_primary":false,"created_at":"2019-08-08T19:57:06+00:00","updated_at":"2019-08-08T19:57:06+00:00","deleted_at":null},"internal_id":"","archived_at":null,"is_general_application":false},"position_ad":{"id":44,"title":"Minimal Job","career_sites":[6]},"career_site":{"id":6},"added_by":null,"person":{"id":20296,"never_hire":null,"first_name":"Zapier","middle_name":null,"last_name":"Applicant","email":"ataylor+zapierapp@exacthire.com","phone":{"exists":true,"formatted_value":"+13172568946","is_valid":true,"sms_value":"+13172568946","value":"(317) 256-8946"},"location":{"location_id":21845,"postal_code":"46033","street1":"123 Trigger Way","street2":null,"street3":null,"city":{"id":2,"label":"Carmel","abbreviation":null,"created_at":"2019-04-02T02:21:37+00:00","updated_at":"2019-04-02T02:21:37+00:00","deleted_at":null},"state":{"country":{"id":1,"iso":"US"},"id":16,"label":"Indiana","abbreviation":"IN","created_at":"2019-04-02T02:21:37+00:00","updated_at":"2022-06-02T20:13:46+00:00","deleted_at":null,"created_on":null,"latitude":"40.551217","longitude":"-85.602364"},"country":{"id":1,"name":"United States","iso":"US","iso3":"USA","display_order":2,"created_at":"2019-04-02T02:21:36+00:00","updated_at":"2019-04-02T02:21:36+00:00","deleted_at":null},"id":21312,"date_started":"2026-09-24T20:22:20+00:00","is_primary":false,"created_at":"2026-09-24T20:22:20+00:00","updated_at":"2026-09-24T20:22:20+00:00","deleted_at":null},"consent_to_text":false,"preferred_contact_type":"EMAIL","user_id":20177},"ai_match_state":{"status":"not_applicable","rescores_remaining":0},"fit_badge":null,"ai_fit_badge":null,"children":[{"id":25172,"initial_submitted_at":"2026-09-24T22:12:03+00:00","position":{"id":2026},"submitted_at":"2026-09-24T22:12:03+00:00","template_stage":null}],"applicant_full_name":"Zapier Applicant","applicant_email":"ataylor+zapierapp@exacthire.com","person_id":20296,"position_id":43,"is_never_hire_applicant":null,"data_point_answer_person":[],"last_application_submission":{"submittedAt":"2026-09-24T20:31:20+00:00","personId":20296,"personType":"Applicant"},"id":25171,"started_at":"2026-09-24T20:22:21+00:00","submitted_at":"2026-09-24T20:31:20+00:00","archived_at":null,"stage_updated_at":"2026-09-24T21:35:55+00:00","position_title":"Minimal Job","stage":{"data_point":{"id":39},"parent":{"id":null},"organization":{"id":1},"score":null,"id":112,"label":"Interview","value":null,"description":null,"identifier":"APPLICATION_STATUS_INTERVIEW","display_order":3,"is_locked":false,"archived_at":null,"updated_at":"2019-06-23T02:01:49+00:00"},"template_stage":null,"is_disqualified":false,"score":null,"ai_match_score":null,"ai_match_reasons":null,"ai_match_gaps":null,"is_imported":false,"is_full_service_hiring":null,"source":{"data_point":null,"parent":{"id":null},"organization":{"id":null},"score":null,"id":11776,"label":null,"value":null,"description":null,"identifier":null,"display_order":null,"is_locked":false,"archived_at":null,"updated_at":null},"client_note":null,"client_released_at":null,"parent":null,"created_at":"2026-09-24T20:22:21+00:00","updated_at":"2026-09-24T21:47:42+00:00","deleted_at":null,"initial_submitted_at":"2026-09-24T20:31:20+00:00"},"data_point_answer_applications":{"25171":[{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445230,"data_point_answer":{"data_point_question":{"id":null,"text":null,"deleted_at":null},"data_point":{"id":40,"label":"Application Source","identifier":"APPLICATION_SOURCE","data_point_group":{"id":6,"label":"Application","description":null,"footer":null,"identifier":"APPLICATION","hidden":1,"searchable":false,"group_order":null},"input_type":"DROPDOWN"},"value_real":"11776","id":475892,"data_point_question_text":"Application Source","value_text":"Career Site","value_id":11776,"display_order":null,"created_at":"2026-09-24T20:22:21+00:00","updated_at":"2026-09-24T20:22:21+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:22:21+00:00","updated_at":"2026-09-24T20:22:21+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445231,"data_point_answer":{"data_point_question":{"id":null,"text":null,"deleted_at":null},"data_point":{"id":3578,"label":"Job Type","identifier":"APPLICATION_JOB_TYPE","data_point_group":{"id":6,"label":"Application","description":null,"footer":null,"identifier":"APPLICATION","hidden":1,"searchable":false,"group_order":null},"input_type":"DROPDOWN"},"value_real":"11782","id":475893,"data_point_question_text":"Job Type","value_text":"External","value_id":11782,"display_order":null,"created_at":"2026-09-24T20:22:21+00:00","updated_at":"2026-09-24T20:22:21+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:22:21+00:00","updated_at":"2026-09-24T20:22:21+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445232,"data_point_answer":{"data_point_question":{"id":null,"text":null,"deleted_at":null},"data_point":{"id":41,"label":"Application App Template","identifier":"APPLICATION_APP_TEMPLATE","data_point_group":{"id":6,"label":"Application","description":null,"footer":null,"identifier":"APPLICATION","hidden":1,"searchable":false,"group_order":null},"input_type":"TEXTBOX"},"value_real":"10","id":475894,"data_point_question_text":"Application App Template","value_text":"SandBox Application Setup","value_id":10,"display_order":null,"created_at":"2026-09-24T20:22:21+00:00","updated_at":"2026-09-24T20:22:21+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:22:21+00:00","updated_at":"2026-09-24T20:22:21+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":1,"id":445233,"data_point_answer":{"data_point_question":{"id":62,"text":"School State:","deleted_at":null},"data_point":{"id":96,"label":"School State","identifier":"EDUCATION_SCHOOL_STATE","data_point_group":{"id":9,"label":"Education","description":"<p>List below your educational background, including high school, all colleges, trade and military service schools.<\/p>","footer":null,"identifier":"EDUCATION","hidden":null,"searchable":true,"group_order":2},"input_type":"TEXTBOX"},"value_real":"Stuff","id":475895,"data_point_question_text":"School State:","value_text":"Stuff","value_id":null,"display_order":1,"created_at":"2026-09-24T20:30:51+00:00","updated_at":"2026-09-24T20:30:51+00:00","deleted_at":null},"section_order":1,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:30:51+00:00","updated_at":"2026-09-24T20:30:51+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":2,"id":445234,"data_point_answer":{"data_point_question":{"id":65,"text":"Did you Graduate?","deleted_at":null},"data_point":{"id":91,"label":"Graduated?","identifier":"EDUCATION_GRADUATED","data_point_group":{"id":9,"label":"Education","description":"<p>List below your educational background, including high school, all colleges, trade and military service schools.<\/p>","footer":null,"identifier":"EDUCATION","hidden":null,"searchable":true,"group_order":2},"input_type":"RADIOBUTTON"},"value_real":"99","id":475896,"data_point_question_text":"Did you Graduate?","value_text":"Yes","value_id":99,"display_order":2,"created_at":"2026-09-24T20:30:51+00:00","updated_at":"2026-09-24T20:30:51+00:00","deleted_at":null},"section_order":1,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:30:51+00:00","updated_at":"2026-09-24T20:30:51+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":1,"id":445235,"data_point_answer":{"data_point_question":{"id":62,"text":"School State:","deleted_at":null},"data_point":{"id":96,"label":"School State","identifier":"EDUCATION_SCHOOL_STATE","data_point_group":{"id":9,"label":"Education","description":"<p>List below your educational background, including high school, all colleges, trade and military service schools.<\/p>","footer":null,"identifier":"EDUCATION","hidden":null,"searchable":true,"group_order":2},"input_type":"TEXTBOX"},"value_real":"sf","id":475897,"data_point_question_text":"School State:","value_text":"sf","value_id":null,"display_order":1,"created_at":"2026-09-24T20:30:51+00:00","updated_at":"2026-09-24T20:30:51+00:00","deleted_at":null},"section_order":1,"iteration_number":2,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:30:51+00:00","updated_at":"2026-09-24T20:30:51+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":2,"id":445236,"data_point_answer":{"data_point_question":{"id":65,"text":"Did you Graduate?","deleted_at":null},"data_point":{"id":91,"label":"Graduated?","identifier":"EDUCATION_GRADUATED","data_point_group":{"id":9,"label":"Education","description":"<p>List below your educational background, including high school, all colleges, trade and military service schools.<\/p>","footer":null,"identifier":"EDUCATION","hidden":null,"searchable":true,"group_order":2},"input_type":"RADIOBUTTON"},"value_real":"100","id":475898,"data_point_question_text":"Did you Graduate?","value_text":"No","value_id":100,"display_order":2,"created_at":"2026-09-24T20:30:51+00:00","updated_at":"2026-09-24T20:30:51+00:00","deleted_at":null},"section_order":1,"iteration_number":2,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:30:51+00:00","updated_at":"2026-09-24T20:30:51+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":1,"id":445237,"data_point_answer":{"data_point_question":{"id":42,"text":"Organization Address:","deleted_at":null},"data_point":{"id":72,"label":"Organization Address","identifier":"EMPLOYMENT_ORGANIZATION_ADDRESS","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"TEXTBOX"},"value_real":"Orggy Org Org","id":475899,"data_point_question_text":"Organization Address:","value_text":"Orggy Org Org","value_id":null,"display_order":1,"created_at":"2026-09-24T20:31:07+00:00","updated_at":"2026-09-24T20:31:07+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:07+00:00","updated_at":"2026-09-24T20:31:07+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":1,"id":445238,"data_point_answer":{"data_point_question":{"id":111,"text":"Which certs do you have?","deleted_at":null},"data_point":{"id":151,"label":"Certifications","identifier":"3_CERTIFICATIONS","data_point_group":{"id":10,"label":"General\/Other","description":null,"footer":null,"identifier":"GENERAL","hidden":null,"searchable":true,"group_order":3},"input_type":"TEXTAREA"},"value_real":"asa","id":475900,"data_point_question_text":"Which certs do you have?","value_text":"asa","value_id":null,"display_order":1,"created_at":"2026-09-24T20:31:12+00:00","updated_at":"2026-09-24T20:31:12+00:00","deleted_at":null},"section_order":4,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:12+00:00","updated_at":"2026-09-24T20:31:12+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":1,"id":445239,"data_point_answer":{"data_point_question":{"id":84,"text":"Have you ever been discharged from employment, or asked to resign?","deleted_at":null},"data_point":{"id":111,"label":"Has Been Discharged","identifier":"ADDITIONAL_INFO_HAS_BEEN_DISCHARGED","data_point_group":{"id":14,"label":"Additional Information","description":"","footer":null,"identifier":"ADDITIONAL_INFO","hidden":null,"searchable":true,"group_order":7},"input_type":"RADIOBUTTON"},"value_real":"136","id":475901,"data_point_question_text":"Have you ever been discharged from employment, or asked to resign?","value_text":"No","value_id":136,"display_order":1,"created_at":"2026-09-24T20:31:18+00:00","updated_at":"2026-09-24T20:31:18+00:00","deleted_at":null},"section_order":6,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:18+00:00","updated_at":"2026-09-24T20:31:18+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":2,"id":445240,"data_point_answer":{"data_point_question":{"id":85,"text":"If Yes, please explain:","deleted_at":null},"data_point":{"id":112,"label":"Discharge Explanation","identifier":"ADDITIONAL_INFO_DISCHARGE_EXPLANATION","data_point_group":{"id":14,"label":"Additional Information","description":"","footer":null,"identifier":"ADDITIONAL_INFO","hidden":null,"searchable":true,"group_order":7},"input_type":"TEXTAREA"},"value_real":"asd","id":475902,"data_point_question_text":"If Yes, please explain:","value_text":"asd","value_id":null,"display_order":2,"created_at":"2026-09-24T20:31:18+00:00","updated_at":"2026-09-24T20:31:18+00:00","deleted_at":null},"section_order":6,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:18+00:00","updated_at":"2026-09-24T20:31:18+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445241,"data_point_answer":{"data_point_question":{"id":2,"text":"First Name","deleted_at":null},"data_point":{"id":25,"label":"First Name","identifier":"APPLICANT_FIRST_NAME","data_point_group":{"id":7,"label":"Applicant","description":null,"footer":null,"identifier":"APPLICANT","hidden":1,"searchable":false,"group_order":null},"input_type":"TEXTBOX"},"value_real":"Zapier","id":475903,"data_point_question_text":"First Name","value_text":"Zapier","value_id":null,"display_order":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445242,"data_point_answer":{"data_point_question":{"id":3,"text":"Initial","deleted_at":null},"data_point":{"id":26,"label":"Middle Initial","identifier":"APPLICANT_MIDDLE_INITIAL","data_point_group":{"id":7,"label":"Applicant","description":null,"footer":null,"identifier":"APPLICANT","hidden":1,"searchable":false,"group_order":null},"input_type":"TEXTBOX"},"value_real":"","id":475904,"data_point_question_text":"Initial","value_text":"","value_id":null,"display_order":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445243,"data_point_answer":{"data_point_question":{"id":4,"text":"Last Name","deleted_at":null},"data_point":{"id":27,"label":"Last Name","identifier":"APPLICANT_LAST_NAME","data_point_group":{"id":7,"label":"Applicant","description":null,"footer":null,"identifier":"APPLICANT","hidden":1,"searchable":false,"group_order":null},"input_type":"TEXTBOX"},"value_real":"Applicant","id":475905,"data_point_question_text":"Last Name","value_text":"Applicant","value_id":null,"display_order":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445244,"data_point_answer":{"data_point_question":{"id":1,"text":"Email","deleted_at":null},"data_point":{"id":24,"label":"Email","identifier":"APPLICANT_EMAIL","data_point_group":{"id":7,"label":"Applicant","description":null,"footer":null,"identifier":"APPLICANT","hidden":1,"searchable":false,"group_order":null},"input_type":"TEXTBOX"},"value_real":"ataylor+zapierapp@exacthire.com","id":475906,"data_point_question_text":"Email","value_text":"ataylor+zapierapp@exacthire.com","value_id":null,"display_order":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445245,"data_point_answer":{"data_point_question":{"id":5,"text":"Address","deleted_at":null},"data_point":{"id":28,"label":"Address Line 1","identifier":"APPLICANT_STREET_1","data_point_group":{"id":7,"label":"Applicant","description":null,"footer":null,"identifier":"APPLICANT","hidden":1,"searchable":false,"group_order":null},"input_type":"TEXTBOX"},"value_real":"123 Trigger Way","id":475907,"data_point_question_text":"Address","value_text":"123 Trigger Way","value_id":null,"display_order":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445246,"data_point_answer":{"data_point_question":{"id":6,"text":"Address 2","deleted_at":null},"data_point":{"id":29,"label":"Address Line 2","identifier":"APPLICANT_STREET_2","data_point_group":{"id":7,"label":"Applicant","description":null,"footer":null,"identifier":"APPLICANT","hidden":1,"searchable":false,"group_order":null},"input_type":"TEXTBOX"},"value_real":"","id":475908,"data_point_question_text":"Address 2","value_text":"","value_id":null,"display_order":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445247,"data_point_answer":{"data_point_question":{"id":7,"text":"City","deleted_at":null},"data_point":{"id":30,"label":"City","identifier":"APPLICANT_CITY","data_point_group":{"id":7,"label":"Applicant","description":null,"footer":null,"identifier":"APPLICANT","hidden":1,"searchable":false,"group_order":null},"input_type":"TEXTBOX"},"value_real":"2","id":475909,"data_point_question_text":"City","value_text":"Carmel","value_id":2,"display_order":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445248,"data_point_answer":{"data_point_question":{"id":8,"text":"State","deleted_at":null},"data_point":{"id":31,"label":"State","identifier":"APPLICANT_STATE","data_point_group":{"id":7,"label":"Applicant","description":null,"footer":null,"identifier":"APPLICANT","hidden":1,"searchable":false,"group_order":null},"input_type":"TEXTBOX"},"value_real":"16","id":475910,"data_point_question_text":"State","value_text":"Indiana","value_id":16,"display_order":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445249,"data_point_answer":{"data_point_question":{"id":9,"text":"Zip","deleted_at":null},"data_point":{"id":32,"label":"Zip","identifier":"APPLICANT_POSTAL_CODE","data_point_group":{"id":7,"label":"Applicant","description":null,"footer":null,"identifier":"APPLICANT","hidden":1,"searchable":false,"group_order":null},"input_type":"TEXTBOX"},"value_real":"46033","id":475911,"data_point_question_text":"Zip","value_text":"46033","value_id":null,"display_order":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445250,"data_point_answer":{"data_point_question":{"id":10,"text":"Phone","deleted_at":null},"data_point":{"id":33,"label":"Phone","identifier":"APPLICANT_PHONE","data_point_group":{"id":7,"label":"Applicant","description":null,"footer":null,"identifier":"APPLICANT","hidden":1,"searchable":false,"group_order":null},"input_type":"TEXTBOX"},"value_real":"13172568946","id":475912,"data_point_question_text":"Phone","value_text":"13172568946","value_id":null,"display_order":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445251,"data_point_answer":{"data_point_question":{"id":11,"text":"Alternate Phone","deleted_at":null},"data_point":{"id":34,"label":"Alternate Phone","identifier":"APPLICANT_ALTERNATE_PHONE","data_point_group":{"id":7,"label":"Applicant","description":null,"footer":null,"identifier":"APPLICANT","hidden":1,"searchable":false,"group_order":null},"input_type":"TEXTBOX"},"value_real":"","id":475913,"data_point_question_text":"Alternate Phone","value_text":"","value_id":null,"display_order":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:31:19+00:00","updated_at":"2026-09-24T20:31:19+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":3,"id":445252,"data_point_answer":{"data_point_question":{"id":68,"text":"Attended From (MM\/YYYY):","deleted_at":null},"data_point":{"id":98,"label":"Date Attended From","identifier":"EDUCATION_DATE_ATTENDED_FROM","data_point_group":{"id":9,"label":"Education","description":"<p>List below your educational background, including high school, all colleges, trade and military service schools.<\/p>","footer":null,"identifier":"EDUCATION","hidden":null,"searchable":true,"group_order":2},"input_type":"TEXTBOX"},"value_real":null,"id":475914,"data_point_question_text":"Attended From (MM\/YYYY):","value_text":null,"value_id":null,"display_order":3,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":1,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":4,"id":445253,"data_point_answer":{"data_point_question":{"id":66,"text":"Degree\/Certificate:","deleted_at":null},"data_point":{"id":94,"label":"Degree\/Certificate","identifier":"EDUCATION_DEGREE_CERTIFICATE","data_point_group":{"id":9,"label":"Education","description":"<p>List below your educational background, including high school, all colleges, trade and military service schools.<\/p>","footer":null,"identifier":"EDUCATION","hidden":null,"searchable":true,"group_order":2},"input_type":"TEXTBOX"},"value_real":null,"id":475915,"data_point_question_text":"Degree\/Certificate:","value_text":null,"value_id":null,"display_order":4,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":1,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":3,"id":445254,"data_point_answer":{"data_point_question":{"id":68,"text":"Attended From (MM\/YYYY):","deleted_at":null},"data_point":{"id":98,"label":"Date Attended From","identifier":"EDUCATION_DATE_ATTENDED_FROM","data_point_group":{"id":9,"label":"Education","description":"<p>List below your educational background, including high school, all colleges, trade and military service schools.<\/p>","footer":null,"identifier":"EDUCATION","hidden":null,"searchable":true,"group_order":2},"input_type":"TEXTBOX"},"value_real":null,"id":475916,"data_point_question_text":"Attended From (MM\/YYYY):","value_text":null,"value_id":null,"display_order":3,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":1,"iteration_number":2,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":4,"id":445255,"data_point_answer":{"data_point_question":{"id":66,"text":"Degree\/Certificate:","deleted_at":null},"data_point":{"id":94,"label":"Degree\/Certificate","identifier":"EDUCATION_DEGREE_CERTIFICATE","data_point_group":{"id":9,"label":"Education","description":"<p>List below your educational background, including high school, all colleges, trade and military service schools.<\/p>","footer":null,"identifier":"EDUCATION","hidden":null,"searchable":true,"group_order":2},"input_type":"TEXTBOX"},"value_real":null,"id":475917,"data_point_question_text":"Degree\/Certificate:","value_text":null,"value_id":null,"display_order":4,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":1,"iteration_number":2,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":1,"id":445256,"data_point_answer":{"data_point_question":{"id":3542,"text":"<p>Please Upload Cover Letter<\/p>","deleted_at":null},"data_point":{"id":3599,"label":"Cover Letter","identifier":"3_COVER_LETTER","data_point_group":{"id":12,"label":"Resume","description":"<p>You can provide us with your resume here. You may either upload a file containing a formatted version, and\/or cut &amp; paste a text version in the space provided.<\/p>","footer":null,"identifier":"RESUME","hidden":null,"searchable":true,"group_order":5},"input_type":"FILEUPLOAD"},"value_real":null,"id":475918,"data_point_question_text":"<p>Please Upload Cover Letter<\/p>","value_text":null,"value_id":null,"display_order":1,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":2,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":2,"id":445257,"data_point_answer":{"data_point_question":{"id":3543,"text":"<p>Please upload your resume and cover letter<\/p>","deleted_at":null},"data_point":{"id":100,"label":"Resume File","identifier":"RESUME_FILE","data_point_group":{"id":12,"label":"Resume","description":"<p>You can provide us with your resume here. You may either upload a file containing a formatted version, and\/or cut &amp; paste a text version in the space provided.<\/p>","footer":null,"identifier":"RESUME","hidden":null,"searchable":true,"group_order":5},"input_type":"FILEUPLOAD"},"value_real":null,"id":475919,"data_point_question_text":"<p>Please upload your resume and cover letter<\/p>","value_text":null,"value_id":null,"display_order":2,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":2,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":2,"id":445258,"data_point_answer":{"data_point_question":{"id":44,"text":"Organization State:","deleted_at":null},"data_point":{"id":74,"label":"Organization State","identifier":"EMPLOYMENT_ORGANIZATION_STATE","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"TEXTBOX"},"value_real":null,"id":475920,"data_point_question_text":"Organization State:","value_text":null,"value_id":null,"display_order":2,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":3,"id":445259,"data_point_answer":{"data_point_question":{"id":45,"text":"Organization Country:","deleted_at":null},"data_point":{"id":75,"label":"Organization Country","identifier":"EMPLOYMENT_ORGANIZATION_COUNTRY","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"COUNTRYDROPDOWN"},"value_real":null,"id":475921,"data_point_question_text":"Organization Country:","value_text":null,"value_id":null,"display_order":3,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":4,"id":445260,"data_point_answer":{"data_point_question":{"id":46,"text":"Organization Zip Code:","deleted_at":null},"data_point":{"id":76,"label":"Organization Zip","identifier":"EMPLOYMENT_ORGANIZATION_POSTAL_CODE","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"TEXTBOX"},"value_real":null,"id":475922,"data_point_question_text":"Organization Zip Code:","value_text":null,"value_id":null,"display_order":4,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":5,"id":445261,"data_point_answer":{"data_point_question":{"id":47,"text":"Organization Phone Number:","deleted_at":null},"data_point":{"id":77,"label":"Organization Phone Number","identifier":"EMPLOYMENT_ORGANIZATION_PHONE_NUMBER","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"TEXTBOX"},"value_real":null,"id":475923,"data_point_question_text":"Organization Phone Number:","value_text":null,"value_id":null,"display_order":5,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":6,"id":445262,"data_point_answer":{"data_point_question":{"id":38,"text":"Supervisor's Name:","deleted_at":null},"data_point":{"id":68,"label":"Supervisor Name","identifier":"EMPLOYMENT_SUPERVISOR_NAME","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"TEXTBOX"},"value_real":null,"id":475924,"data_point_question_text":"Supervisor's Name:","value_text":null,"value_id":null,"display_order":6,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":7,"id":445263,"data_point_answer":{"data_point_question":{"id":39,"text":"Supervisor's Title:","deleted_at":null},"data_point":{"id":69,"label":"Supervisor Title","identifier":"EMPLOYMENT_SUPERVISOR_TITLE","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"TEXTBOX"},"value_real":null,"id":475925,"data_point_question_text":"Supervisor's Title:","value_text":null,"value_id":null,"display_order":7,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":8,"id":445264,"data_point_answer":{"data_point_question":{"id":41,"text":"Supervisor's Phone Number:","deleted_at":null},"data_point":{"id":71,"label":"Supervisor Phone","identifier":"EMPLOYMENT_SUPERVISOR_PHONE","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"TEXTBOX"},"value_real":null,"id":475926,"data_point_question_text":"Supervisor's Phone Number:","value_text":null,"value_id":null,"display_order":8,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":9,"id":445265,"data_point_answer":{"data_point_question":{"id":40,"text":"Supervisor's Email Address:","deleted_at":null},"data_point":{"id":70,"label":"Supervisor Email","identifier":"EMPLOYMENT_SUPERVISOR_EMAIL","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"TEXTBOX"},"value_real":null,"id":475927,"data_point_question_text":"Supervisor's Email Address:","value_text":null,"value_id":null,"display_order":9,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":10,"id":445266,"data_point_answer":{"data_point_question":{"id":36,"text":"Your Last Position:","deleted_at":null},"data_point":{"id":66,"label":"Last Position Title","identifier":"EMPLOYMENT_LAST_POSITION_TITLE","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"TEXTBOX"},"value_real":null,"id":475928,"data_point_question_text":"Your Last Position:","value_text":null,"value_id":null,"display_order":10,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":11,"id":445267,"data_point_answer":{"data_point_question":{"id":32,"text":"Employment Type:","deleted_at":null},"data_point":{"id":62,"label":"Employment Type","identifier":"EMPLOYMENT_TYPE","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"DROPDOWN"},"value_real":null,"id":475929,"data_point_question_text":"Employment Type:","value_text":null,"value_id":null,"display_order":11,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":12,"id":445268,"data_point_answer":{"data_point_question":{"id":55,"text":"Current Employer?","deleted_at":null},"data_point":{"id":85,"label":"Is Current Employer","identifier":"EMPLOYMENT_IS_CURRENT_EMPLOYER","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"RADIOBUTTON"},"value_real":null,"id":475930,"data_point_question_text":"Current Employer?","value_text":null,"value_id":null,"display_order":12,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":13,"id":445269,"data_point_answer":{"data_point_question":{"id":48,"text":"Employed From (MM\/YYYY):","deleted_at":null},"data_point":{"id":78,"label":"Date Employed From","identifier":"EMPLOYMENT_DATE_EMPLOYED_FROM","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"TEXTBOX"},"value_real":null,"id":475931,"data_point_question_text":"Employed From (MM\/YYYY):","value_text":null,"value_id":null,"display_order":13,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":14,"id":445270,"data_point_answer":{"data_point_question":{"id":49,"text":"Employed To (MM\/YYYY):","deleted_at":null},"data_point":{"id":79,"label":"Date Employed To","identifier":"EMPLOYMENT_DATE_EMPLOYED_TO","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"TEXTBOX"},"value_real":null,"id":475932,"data_point_question_text":"Employed To (MM\/YYYY):","value_text":null,"value_id":null,"display_order":14,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":15,"id":445271,"data_point_answer":{"data_point_question":{"id":52,"text":"Rate of Pay:","deleted_at":null},"data_point":{"id":82,"label":"Rate Of Pay","identifier":"EMPLOYMENT_RATE_OF_PAY","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"CURRENCY"},"value_real":null,"id":475933,"data_point_question_text":"Rate of Pay:","value_text":null,"value_id":null,"display_order":15,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":16,"id":445272,"data_point_answer":{"data_point_question":{"id":50,"text":"Rate of Pay (Start):","deleted_at":null},"data_point":{"id":80,"label":"Rate Of Pay Start","identifier":"EMPLOYMENT_RATE_OF_PAY_START","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"CURRENCY"},"value_real":null,"id":475934,"data_point_question_text":"Rate of Pay (Start):","value_text":null,"value_id":null,"display_order":16,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":17,"id":445273,"data_point_answer":{"data_point_question":{"id":51,"text":"Rate of Pay (End):","deleted_at":null},"data_point":{"id":81,"label":"Rate Of Pay End","identifier":"EMPLOYMENT_RATE_OF_PAY_END","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"CURRENCY"},"value_real":null,"id":475935,"data_point_question_text":"Rate of Pay (End):","value_text":null,"value_id":null,"display_order":17,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":18,"id":445274,"data_point_answer":{"data_point_question":{"id":56,"text":"Payment Type:","deleted_at":null},"data_point":{"id":86,"label":"Payment Type","identifier":"EMPLOYMENT_PAYMENT_TYPE","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"DROPDOWN"},"value_real":null,"id":475936,"data_point_question_text":"Payment Type:","value_text":null,"value_id":null,"display_order":18,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":19,"id":445275,"data_point_answer":{"data_point_question":{"id":53,"text":"Reason For Leaving:","deleted_at":null},"data_point":{"id":83,"label":"Reason For Leaving","identifier":"EMPLOYMENT_REASON_FOR_LEAVING","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"TEXTAREA"},"value_real":null,"id":475937,"data_point_question_text":"Reason For Leaving:","value_text":null,"value_id":null,"display_order":19,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":20,"id":445276,"data_point_answer":{"data_point_question":{"id":54,"text":"Your Duties:","deleted_at":null},"data_point":{"id":84,"label":"Your Duties","identifier":"EMPLOYMENT_DUTIES","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"TEXTAREA"},"value_real":null,"id":475938,"data_point_question_text":"Your Duties:","value_text":null,"value_id":null,"display_order":20,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":21,"id":445277,"data_point_answer":{"data_point_question":{"id":57,"text":"Subject To FMCSR?","deleted_at":null},"data_point":{"id":87,"label":"Subject To FMCSR","identifier":"EMPLOYMENT_SUBJECT_TO_FMCSR","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"RADIOBUTTON"},"value_real":null,"id":475939,"data_point_question_text":"Subject To FMCSR?","value_text":null,"value_id":null,"display_order":21,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":22,"id":445278,"data_point_answer":{"data_point_question":{"id":58,"text":"Subject To Drug And Alcohol Testing?","deleted_at":null},"data_point":{"id":88,"label":"Subject To Drug and Alcohol Testing","identifier":"EMPLOYMENT_SUBJECT_TO_DRUG_AND_ALCOHOL_TESTING","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"RADIOBUTTON"},"value_real":null,"id":475940,"data_point_question_text":"Subject To Drug And Alcohol Testing?","value_text":null,"value_id":null,"display_order":22,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":23,"id":445279,"data_point_answer":{"data_point_question":{"id":33,"text":"May we contact?","deleted_at":null},"data_point":{"id":63,"label":"Contact Previous Employer","identifier":"EMPLOYMENT_CAN_CONTACT_PREVIOUS_EMPLOYER","data_point_group":{"id":8,"label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer.<\/p>","footer":null,"identifier":"EMPLOYMENT","hidden":null,"searchable":true,"group_order":1},"input_type":"RADIOBUTTON"},"value_real":null,"id":475941,"data_point_question_text":"May we contact?","value_text":null,"value_id":null,"display_order":23,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":3,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":2,"id":445280,"data_point_answer":{"data_point_question":{"id":12,"text":"Are you at least 16 years old? (You must be at least 16 to apply)","deleted_at":null},"data_point":{"id":43,"label":"Minimum Age","identifier":"GENERAL_MINIMUM_AGE","data_point_group":{"id":10,"label":"General\/Other","description":null,"footer":null,"identifier":"GENERAL","hidden":null,"searchable":true,"group_order":3},"input_type":"DROPDOWN"},"value_real":null,"id":475942,"data_point_question_text":"Are you at least 16 years old? (You must be at least 16 to apply)","value_text":null,"value_id":null,"display_order":2,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":4,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":1,"id":445281,"data_point_answer":{"data_point_question":{"id":74,"text":"Reference's Name:","deleted_at":null},"data_point":{"id":103,"label":"Reference Name","identifier":"REFERENCE_NAME","data_point_group":{"id":13,"label":"References","description":"<p>Please fill out the information below regarding references.<\/p>","footer":null,"identifier":"REFERENCE","hidden":null,"searchable":true,"group_order":6},"input_type":"TEXTBOX"},"value_real":null,"id":475943,"data_point_question_text":"Reference's Name:","value_text":null,"value_id":null,"display_order":1,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":5,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":2,"id":445282,"data_point_answer":{"data_point_question":{"id":75,"text":"Reference's Organization:","deleted_at":null},"data_point":{"id":104,"label":"Reference Organization","identifier":"REFERENCE_ORGANIZATION","data_point_group":{"id":13,"label":"References","description":"<p>Please fill out the information below regarding references.<\/p>","footer":null,"identifier":"REFERENCE","hidden":null,"searchable":true,"group_order":6},"input_type":"TEXTBOX"},"value_real":null,"id":475944,"data_point_question_text":"Reference's Organization:","value_text":null,"value_id":null,"display_order":2,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":5,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":3,"id":445283,"data_point_answer":{"data_point_question":{"id":81,"text":"Reference's Occupation\/Position:","deleted_at":null},"data_point":{"id":110,"label":"Reference Occupation\/Position","identifier":"REFERENCE_OCCUPATION_POSITION","data_point_group":{"id":13,"label":"References","description":"<p>Please fill out the information below regarding references.<\/p>","footer":null,"identifier":"REFERENCE","hidden":null,"searchable":true,"group_order":6},"input_type":"TEXTBOX"},"value_real":null,"id":475945,"data_point_question_text":"Reference's Occupation\/Position:","value_text":null,"value_id":null,"display_order":3,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":5,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":4,"id":445284,"data_point_answer":{"data_point_question":{"id":77,"text":"Reference's Telephone:","deleted_at":null},"data_point":{"id":106,"label":"Reference Phone","identifier":"REFERENCE_PHONE","data_point_group":{"id":13,"label":"References","description":"<p>Please fill out the information below regarding references.<\/p>","footer":null,"identifier":"REFERENCE","hidden":null,"searchable":true,"group_order":6},"input_type":"TEXTBOX"},"value_real":null,"id":475946,"data_point_question_text":"Reference's Telephone:","value_text":null,"value_id":null,"display_order":4,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":5,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":5,"id":445285,"data_point_answer":{"data_point_question":{"id":78,"text":"Reference's Email Address:","deleted_at":null},"data_point":{"id":107,"label":"Reference Email","identifier":"REFERENCE_EMAIL","data_point_group":{"id":13,"label":"References","description":"<p>Please fill out the information below regarding references.<\/p>","footer":null,"identifier":"REFERENCE","hidden":null,"searchable":true,"group_order":6},"input_type":"TEXTBOX"},"value_real":null,"id":475947,"data_point_question_text":"Reference's Email Address:","value_text":null,"value_id":null,"display_order":5,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":5,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":6,"id":445286,"data_point_answer":{"data_point_question":{"id":79,"text":"What relationship do you have with this person?","deleted_at":null},"data_point":{"id":108,"label":"Reference Relationship Type","identifier":"REFERENCE_RELATIONSHIP_TYPE","data_point_group":{"id":13,"label":"References","description":"<p>Please fill out the information below regarding references.<\/p>","footer":null,"identifier":"REFERENCE","hidden":null,"searchable":true,"group_order":6},"input_type":"DROPDOWN"},"value_real":null,"id":475948,"data_point_question_text":"What relationship do you have with this person?","value_text":null,"value_id":null,"display_order":6,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":5,"iteration_number":1,"score":null,"template_stage":{"data_point":{"id":160},"parent":{"id":null},"organization":{"id":1},"score":null,"id":283,"label":"Step 1","value":null,"description":null,"identifier":"ORGANIZATION_MULTISTEP_STEP_1","display_order":null,"is_locked":true,"archived_at":null,"updated_at":"2020-01-15T05:10:19+00:00"},"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445287,"data_point_answer":{"data_point_question":{"id":71,"text":"Application Status","deleted_at":null},"data_point":{"id":39,"label":"Application Stage","identifier":"APPLICATION_STATUS","data_point_group":{"id":6,"label":"Application","description":null,"footer":null,"identifier":"APPLICATION","hidden":1,"searchable":false,"group_order":null},"input_type":"DROPDOWN"},"value_real":"110","id":475949,"data_point_question_text":"Application Status","value_text":"Applied","value_id":110,"display_order":null,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T20:31:20+00:00","updated_at":"2026-09-24T20:31:20+00:00","deleted_at":null,"disqualified":false},{"application":{"id":25171},"stage":{"id":110,"label":"Applied"},"display_order":null,"id":445288,"data_point_answer":{"data_point_question":{"id":71,"text":"Application Status","deleted_at":null},"data_point":{"id":39,"label":"Application Stage","identifier":"APPLICATION_STATUS","data_point_group":{"id":6,"label":"Application","description":null,"footer":null,"identifier":"APPLICATION","hidden":1,"searchable":false,"group_order":null},"input_type":"DROPDOWN"},"value_real":"112","id":475950,"data_point_question_text":"Application Status","value_text":"Interview","value_id":112,"display_order":null,"created_at":"2026-09-24T21:35:55+00:00","updated_at":"2026-09-24T21:35:55+00:00","deleted_at":null},"section_order":null,"iteration_number":1,"score":null,"template_stage":null,"created_at":"2026-09-24T21:35:55+00:00","updated_at":"2026-09-24T21:35:55+00:00","deleted_at":null,"disqualified":false}]},"indeed_source_attributions":[],"data_point_group_iterations":[{"id":19,"identifier":"THANK_YOU","label":"Thank You","description":"<p>Thank you for applying with our company. Your application has been forwarded to our HR Department, and they will contact you if they need further information or to schedule an interview.<\/p>\n<p>&nbsp;<\/p>\n<p>www.google.com<\/p>\n<p>&nbsp;<\/p>\n<p>Sincerely,<\/p>\n<p>Human Resources<\/p>","display_order":0,"footer":null,"iterations":[],"is_empty_section":false},{"id":9,"identifier":"EDUCATION","label":"Education","description":null,"display_order":1,"footer":null,"iterations":[],"is_empty_section":false},{"id":12,"identifier":"RESUME","label":"Resume","description":"<p>You can provide us with your resume here. You may either upload a file containing a formatted version, and\/or cut &amp; paste a text version in the space provided.<\/p>","display_order":2,"footer":null,"iterations":[],"is_empty_section":false},{"id":14,"identifier":"ADDITIONAL_INFO","label":"Additional Information","description":"","display_order":3,"footer":null,"iterations":[],"is_empty_section":false},{"id":8,"identifier":"EMPLOYMENT","label":"Employment","description":"<p>Please list your previous employers starting with your current, or most recent employer. <\/p>","display_order":3,"footer":"<p>You are doing great!!! Please continue<\/p>","iterations":[],"is_empty_section":false},{"id":10,"identifier":"GENERAL","label":"General\/Other","description":"<p><\/p>","display_order":4,"footer":null,"iterations":[],"is_empty_section":false},{"id":13,"identifier":"REFERENCE","label":"References","description":null,"display_order":5,"footer":null,"iterations":[],"is_empty_section":false},{"id":16,"identifier":"EEOC_COMPLIANCE","label":"Voluntary Disclosure","description":"","display_order":5,"footer":"","iterations":[],"is_empty_section":false},{"id":18,"identifier":"FAIR_CREDIT","label":"Fair Credit Reporting Act","description":"<p>As an applicant for employment or an employee of this organization, you have rights under the Fair Credit Reporting Act (FCRA). By this document, this organization discloses to you that a consumer report may be obtained for employment purposes as part of the pre-employment background investigation and at any time during your employment, if you are hired. If this organization obtains a consumer report about you, and if this organization considers any information in the consumer report when making an employment related decision that directly and adversely affects you, this organization will provide you with a copy of the consumer report and a summary of your rights under the FCRA before the decision is finalized. You also may contact the Federal Trade Commission about your rights under the FCRA.<\/p>\n<p>By submitting this application, I acknowledge that I have received the foregoing disclosure that this organization may obtain a consumer report as part of its pre-employment background investigation and\/or during the course of my employment, if I am hired. By submitting this application, I voluntarily authorize this organization to obtain consumer reports about me and to consider the consumer report in its pre-employment background investigation and\/or when making decisions during the course of my employment, if I am hired. I understand that I have rights under the Fair Credit Reporting Act, including the rights discussed above.<\/p>","display_order":6,"footer":null,"iterations":[],"is_empty_section":false},{"id":17,"identifier":"APPLICANT_AGREEMENT","label":"Applicant Agreement","description":"","display_order":6,"footer":"","iterations":[],"is_empty_section":false},{"id":15,"identifier":"PERSONAL_WORK_STYLE","label":"Personal Work Style","description":"<p>Please read each statement carefully and choose the response that best applied to you on a scale 1 - 5.<p>","display_order":7,"footer":null,"iterations":[],"is_empty_section":false}],"imported_answers":null,"data_point_answer_person":[],"latest_application":{"id":25171,"submittedAt":"2026-09-24T20:31:20+00:00","archivedAt":null},"tasks":[],"ratings":[]}}
      """
  }
  null
  "172.22.0.1"
  "2026-09-28 19:13:56"
  "2026-09-28 19:13:56"
  null
  657
  3
  208336
]
View formatted query    View runnable query
75 0.27 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\Location 170
ExactHireApi\Entity\RolePermission 158
ExactHireApi\Entity\Permission 158
ExactHireApi\Entity\City 158
ExactHireApi\Entity\Position 69
ExactHireApi\Entity\DataPointTemplatePosition 67
ExactHireApi\Entity\DataPointAnswer 60
ExactHireApi\Entity\DataPointAnswerApplication 59
ExactHireApi\Entity\DataPoint 56
ExactHireApi\Entity\DataPointQuestion 53
ExactHireApi\Entity\SubSystem 22
ExactHireApi\Entity\DataPointGroupIteration 19
ExactHireApi\Entity\DataPointGroup 13
ExactHireApi\Entity\DataPointType 13
ExactHireApi\Entity\State 11
ExactHireApi\Entity\DataPointResource 7
ExactHireApi\Entity\DataPointOption 7
ExactHireApi\Entity\InputType 7
ExactHireApi\Entity\User 3
ExactHireApi\Entity\Widget 3
ExactHireApi\Entity\Organization 2
ExactHireApi\Entity\PermissionType 2
ExactHireApi\Entity\Application 2
ExactHireApi\Entity\OrganizationUser 1
ExactHireApi\Entity\OrganizationUserRole 1
ExactHireApi\Entity\Role 1
ExactHireApi\Entity\Provider 1
ExactHireApi\Entity\RootDomain 1
ExactHireApi\Entity\AiCreditPlan 1
ExactHireApi\Entity\LocationScope 1
ExactHireApi\Entity\Country 1
ExactHireApi\Entity\Person 1
ExactHireApi\Entity\PersonType 1
ExactHireApi\Entity\MessageSource 1
ExactHireApi\Entity\CareerSite 1
ExactHireApi\Entity\CareerSiteDisplayType 1
ExactHireApi\Entity\PersonLocation 1
ExactHireApi\Entity\PersonContact 1
ExactHireApi\Entity\ContactType 1
ExactHireApi\Entity\PersonEmail 1
ExactHireApi\Entity\EmailType 1
ExactHireApi\Entity\PositionLocation 1
ExactHireApi\Entity\DataPointTemplate 1
ExactHireApi\Entity\DataPointTemplateType 1
ExactHireApi\Entity\PositionCareerSite 1
ExactHireApi\Entity\DataPointAnswerPerson 1
ExactHireApi\Entity\ApplicationSubmissionHistory 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\RootDomain No errors.
ExactHireApi\Entity\PlanType
  • The field ExactHireApi\Entity\PlanType#rootDomainPlanTypes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity ExactHireApi\Entity\RootDomainPlanType#planType does not contain the required 'inversedBy="rootDomainPlanTypes"' attribute.
ExactHireApi\Entity\AiCreditPlan No errors.
ExactHireApi\Entity\OrganizationProviderSetting No errors.
ExactHireApi\Entity\OrganizationProviderMetadata No errors.
ExactHireApi\Entity\PositionProviderMetadata No errors.
ExactHireApi\Entity\JobBoardAdProviderMetadata No errors.
ExactHireApi\Entity\ScreeningQuestion No errors.
ExactHireApi\Entity\Application No errors.
ExactHireApi\Entity\Location No errors.
ExactHireApi\Entity\JobBoardVisibility No errors.
ExactHireApi\Entity\JobBoardOrganization No errors.
ExactHireApi\Entity\JobBoardBudget No errors.
ExactHireApi\Entity\Position No errors.
ExactHireApi\Entity\CareerSite No errors.
ExactHireApi\Entity\DataPoint No errors.
ExactHireApi\Entity\DataPointOption No errors.
ExactHireApi\Entity\DataPointOptionSelection No errors.
ExactHireApi\Entity\DataPointTemplate No errors.
ExactHireApi\Entity\DataPointGroup No errors.
ExactHireApi\Entity\DataPointGroupIteration No errors.
ExactHireApi\Entity\OrganizationLocation No errors.
ExactHireApi\Entity\PersonHttpLog No errors.
ExactHireApi\Entity\ApplicationHttpLog No errors.
ExactHireApi\Entity\PositionActiveHistory No errors.
ExactHireApi\Entity\TaskStatusType No errors.
ExactHireApi\Entity\TaskAction No errors.
ExactHireApi\Entity\TaskSet No errors.
ExactHireApi\Entity\DataPointGroupSubSystem No errors.
ExactHireApi\Entity\FAQ No errors.
ExactHireApi\Entity\LoginAttempt No errors.
ExactHireApi\Entity\ImportRelation No errors.
ExactHireApi\Entity\ExportStatusType No errors.
ExactHireApi\Entity\RatingNote No errors.
ExactHireApi\Entity\DataPointResource No errors.
ExactHireApi\Entity\EventResource No errors.
ExactHireApi\Entity\LocationScope 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\PersonLocation No errors.
ExactHireApi\Entity\PositionLocation No errors.
ExactHireApi\Entity\PersonContact No errors.
ExactHireApi\Entity\PersonEmail No errors.
ExactHireApi\Entity\PersonType No errors.
ExactHireApi\Entity\MessageSource No errors.
ExactHireApi\Entity\CareerSiteDisplayType No errors.
ExactHireApi\Entity\ContactType No errors.
ExactHireApi\Entity\EmailType No errors.
ExactHireApi\Entity\ApplicationPositionAd No errors.
ExactHireApi\Entity\ApplicationSubmissionHistory
  • The association ExactHireApi\Entity\ApplicationSubmissionHistory#personSubmittedBy refers to the inverse side field ExactHireApi\Entity\Person#applicationSubmissionHistories which does not exist.
ExactHireApi\Entity\ApplicationScreeningAnswer No errors.
ExactHireApi\Entity\ApplicationNote
  • The association ExactHireApi\Entity\ApplicationNote#editedBy refers to the inverse side field ExactHireApi\Entity\Person#applicationNotes which does not exist.
  • The association ExactHireApi\Entity\ApplicationNote#deletedBy refers to the inverse side field ExactHireApi\Entity\Person#applicationNotes which does not exist.
ExactHireApi\Entity\ApplicationTag No errors.
ExactHireApi\Entity\DataPointAnswerApplication No errors.
ExactHireApi\Entity\Message No errors.
ExactHireApi\Entity\ThreadParticipant No errors.
ExactHireApi\Entity\ApplicationEventGuest No errors.
ExactHireApi\Entity\PersonHistory No errors.
ExactHireApi\Entity\Compensation No errors.
ExactHireApi\Entity\DataPointAnswerPerson
  • The association ExactHireApi\Entity\DataPointAnswerPerson#person refers to the inverse side field ExactHireApi\Entity\Person#dataPointAnswerPositions which does not exist.
ExactHireApi\Entity\EmailQueue No errors.
ExactHireApi\Entity\PersonSignature
  • The association ExactHireApi\Entity\PersonSignature#person refers to the inverse side field ExactHireApi\Entity\Person#peopleSignatures which does not exist.
ExactHireApi\Entity\DataPointAnswerPosition 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\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\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\PositionNote No errors.
ExactHireApi\Entity\JobTag No errors.
ExactHireApi\Entity\ThreadContact No errors.
ExactHireApi\Entity\DataPointAnswer
  • The field ExactHireApi\Entity\DataPointAnswer#dataPointAnswerApplications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity ExactHireApi\Entity\DataPointAnswerApplication#dataPointAnswer does not contain the required 'inversedBy="dataPointAnswerApplications"' attribute.
ExactHireApi\Entity\DataPointQuestion No errors.
ExactHireApi\Entity\DataPointType No errors.
ExactHireApi\Entity\InputType No errors.
ExactHireApi\Entity\Widget No errors.
ExactHireApi\Entity\DisqualifiedAnswer No errors.
ExactHireApi\Entity\ReportDataPoint No errors.
ExactHireApi\Entity\ReportTypeDataPoint No errors.
ExactHireApi\Entity\DataPointTemplateQuestion No errors.
ExactHireApi\Entity\DataPointQuestionRule No errors.
ExactHireApi\Entity\DataPointTemplateType No errors.