candidates

Every statement both blind runs produced (3,819), with its full trail: script check → verifier verdict and reason → adjudicator ruling and reason → whether it is in the final set. Most rejections are duplicates between the two runs.

Data license: Not yet licensed — internal review only · Data source: Ahmed ElBatanony, Innopolis University

156 rows where app_id = "F2-043" and verifier_verdict = "rejected"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_url, source_file, adjudicator_reason

run 2

  • b 148
  • a 8

in_final_set 2

verifier_verdict 1

  • rejected · 156 ✖

app_id 1

  • ServiceNow IT Service Management · 156 ✖
candidate_id ▼ app_id run statement excerpt source_url source_file script_check verifier_verdict verifier_reason verifier_correction adjudicator adjudicator_reason in_final_set
F2-043-A012 ServiceNow IT Service Management F2-043 a The system lets an agent create a problem to identify the root cause of an incident Create a problem to identify the root cause of the incident https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/ACZcXVdTEEC8UAvjvEDQ~g/content 04.txt passed rejected duplicate of F2-043-A010   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-A020 ServiceNow IT Service Management F2-043 a The system automatically redirects UI16 module links to the equivalent Service Operations Workspace pages when redirection is enabled navigating through UI16 paths automatically redirects you to the equivalent list or record pages in SOW https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/ACZcXVdTEEC8UAvjvEDQ~g/content 04.txt passed rejected UI navigation redirect for an upgrade/admin setting, not a business capability.   rejected Redirecting legacy UI paths to the new workspace is an upgrade navigation setting, not a business capability. 0.0
F2-043-A055 ServiceNow IT Service Management F2-043 a The system automatically prevents creating another record of the same task type when an incident already has an associated problem or change record If the incident already has an associated https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/Uc8KCF0LjG~p2cz7LcOYiw/content 10.txt passed rejected Describes a restriction or validation rule, not a user-observable capability.   rejected Blocking creation of a second record of the same task type is a validation rule, not a capability. 0.0
F2-043-A077 ServiceNow IT Service Management F2-043 a The system automatically suggests resolutions to service desk agents based on similar incidents Service desk agents get resolution suggestions based on similar incidents https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/VJrgA~RGa2uCwOB_SKOI9A/content 12.txt passed rejected duplicate of F2-043-A025   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-A092 ServiceNow IT Service Management F2-043 a The system lets a user log an incident by sending an email Log incidents in the instance or by sending email https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/YPPvhvaR2f1XnxYWSOG6Cg/content 14.txt passed rejected duplicate of F2-043-A091   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-A122 ServiceNow IT Service Management F2-043 a The system lets a user create a change from an incident or a problem you can create a standard, normal, or an emergency change from an incident or a problem https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/uXk8LEj8iwoJoS8~QkyrIA/content 21.txt passed rejected duplicate of F2-043-A054   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-A130 ServiceNow IT Service Management F2-043 a The system automatically prevents editing of the fields of a change request after it is authorized The fields are set to read only to prevent unintended changes after approval https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/uXk8LEj8iwoJoS8~QkyrIA/content 21.txt passed rejected Describes a restriction or validation rule, not a user-observable capability.   rejected Making fields read only after authorization is an edit restriction, not a capability. 0.0
F2-043-A131 ServiceNow IT Service Management F2-043 a The system automatically prevents changing the primary configuration item of a change request after it leaves the New state You can set or change the primary configuration item (CI) only while the change request is in the New state https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/uXk8LEj8iwoJoS8~QkyrIA/content 21.txt passed rejected Describes a restriction or validation rule, not a user-observable capability.   rejected Limiting changes of the primary CI to the New state is an edit restriction, not a capability. 0.0
F2-043-B001 ServiceNow IT Service Management F2-043 b The system lets a user propose an incident as a major incident candidate Propose an incident as a major incident candidate by clicking Propose Major Incident from the context menu of the Incident form. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/8UWRElZ4IQNPa0zvDxoFkg/content 01.txt passed rejected duplicate of F2-043-A001   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B003 ServiceNow IT Service Management F2-043 b The system automatically marks an incident as a major incident candidate based on the major incident trigger rules Mark an incident as a major incident candidate based on the major incident trigger rules. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/8UWRElZ4IQNPa0zvDxoFkg/content 01.txt passed rejected duplicate of F2-043-A002   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B004 ServiceNow IT Service Management F2-043 b The system lets a major incident manager promote a candidate to a major incident Promote a candidate to a major incident by clicking Promote to Major Incident from the context menu. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/8UWRElZ4IQNPa0zvDxoFkg/content 01.txt passed rejected duplicate of F2-043-A003   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B005 ServiceNow IT Service Management F2-043 b The system lets a major incident manager create a major incident Create a new major incident by clicking Create Major Incident from the left navigation pane. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/8UWRElZ4IQNPa0zvDxoFkg/content 01.txt passed rejected duplicate of F2-043-A004   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B006 ServiceNow IT Service Management F2-043 b The system lets a major incident manager promote an incident to a major incident without going through the proposal process Promote an incident to a major incident without going through the proposal process. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/8UWRElZ4IQNPa0zvDxoFkg/content 01.txt passed rejected duplicate of F2-043-A005   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B007 ServiceNow IT Service Management F2-043 b The system lets a user define communication plans associated with a major incident based on pre-defined conditions Using Task Communications Management, you can define communication plans that are associated with a major incident based on pre-defined conditions. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/8UWRElZ4IQNPa0zvDxoFkg/content 01.txt passed rejected duplicate of F2-043-A006   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B008 ServiceNow IT Service Management F2-043 b The system automatically creates incident communication plans and related communication tasks for a major incident based on the communication plan definitions communication plans and related communication tasks are created for a major incident based on the communication plan definitions. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/8UWRElZ4IQNPa0zvDxoFkg/content 01.txt passed rejected duplicate of F2-043-A007   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B009 ServiceNow IT Service Management F2-043 b The system lets a user request catalog items that are fulfilled based on defined flows Request Management allows catalog items to be requested and fulfilled based on defined flows. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/a2los583a4PJQtchAGt1nA/content 02.txt passed rejected duplicate of F2-043-A008   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B010 ServiceNow IT Service Management F2-043 b The system lets a user create approval policies for change requests create the approval policies as required to meet https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/AC1RbHtQCismhtsRtYi7Ow/content 03.txt passed rejected duplicate of F2-043-A009   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B011 ServiceNow IT Service Management F2-043 b The system automatically controls the process of a change request through workflows defined for its change request type The Change Management processes for a change request are controlled by workflows defined for a specific change request type. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/kRZWB8AWQf6HrVDixdzHzg/content 08.txt passed rejected duplicate of F2-043-A110   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B012 ServiceNow IT Service Management F2-043 b The system lets a user record problems You can record problems, associate incidents, and assign them to the appropriate groups. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/ACZcXVdTEEC8UAvjvEDQ~g/content 04.txt passed rejected duplicate of F2-043-A010   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B013 ServiceNow IT Service Management F2-043 b The system lets a user associate incidents with a problem You can record problems, associate incidents, and assign them to the appropriate groups. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/ACZcXVdTEEC8UAvjvEDQ~g/content 04.txt passed rejected duplicate of F2-043-A011   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B014 ServiceNow IT Service Management F2-043 b The system lets a user assign problems to the appropriate groups You can record problems, associate incidents, and assign them to the appropriate groups. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/ACZcXVdTEEC8UAvjvEDQ~g/content 04.txt passed rejected duplicate of F2-043-A013   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B015 ServiceNow IT Service Management F2-043 b The system lets an agent add multiple incidents to a problem Add multiple incidents to a problem to avoid creating multiple problems for incidents that have the same issue. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/ACZcXVdTEEC8UAvjvEDQ~g/content 04.txt passed rejected duplicate of F2-043-A011   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B016 ServiceNow IT Service Management F2-043 b The system lets an agent create a problem task to initiate the root cause analysis Create a problem task to initiate the root cause analysis. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/ACZcXVdTEEC8UAvjvEDQ~g/content 04.txt passed rejected duplicate of F2-043-A015   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B017 ServiceNow IT Service Management F2-043 b The system lets a user mark a problem as a duplicate of an existing problem to close it Mark this problem as a duplicate of an existing problem to close the problem. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/ACZcXVdTEEC8UAvjvEDQ~g/content 04.txt passed rejected duplicate of F2-043-A014   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B020 ServiceNow IT Service Management F2-043 b The system lets a problem coordinator document and communicate a workaround for a problem Document and communicate a workaround to restore service failures and lessen the impact of a problem that an actual resolution is not yet available. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/ACZcXVdTEEC8UAvjvEDQ~g/content 04.txt passed rejected duplicate of F2-043-A016   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B022 ServiceNow IT Service Management F2-043 b The system lets a problem coordinator create a known error article Create known error articles as reference material. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/ACZcXVdTEEC8UAvjvEDQ~g/content 04.txt passed rejected duplicate of F2-043-A017   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B023 ServiceNow IT Service Management F2-043 b The system lets a user create a change request to fix the root cause of a problem If you can fix the root cause, create a change request and assign it to the relevant team. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/ACZcXVdTEEC8UAvjvEDQ~g/content 04.txt passed rejected duplicate of F2-043-A018   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B025 ServiceNow IT Service Management F2-043 b The system lets a problem manager reanalyze a problem that resurfaces you can decide to reanalyze the problem. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/ACZcXVdTEEC8UAvjvEDQ~g/content 04.txt passed rejected duplicate of F2-043-A019   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B026 ServiceNow IT Service Management F2-043 b The system automatically redirects a user from UI16 module links to the equivalent Service Operations Workspace pages when UI16 module link redirection is enabled navigating through UI16 paths automatically redirects you to the equivalent list or record pages in SOW instead of displaying the UI16 forms or lists. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/ACZcXVdTEEC8UAvjvEDQ~g/content 04.txt passed rejected UI navigation redirect for an upgrade/admin setting, not a business capability.   rejected Redirecting legacy UI paths to the new workspace is an upgrade navigation setting, not a business capability. 0.0
F2-043-B027 ServiceNow IT Service Management F2-043 b The system lets an agent view an overview of outages, service announcements, and assignments on a landing page It provides an overview of outages, service announcements, and assignments to efficiently prioritize the work. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/IuHkukKoSrzunmpTtJoRPA/content 06.txt passed rejected duplicate of F2-043-A027   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B028 ServiceNow IT Service Management F2-043 b The system lets an agent manage incidents with contextual information and targeted actions Agents can manage incidents effectively with contextual information and targeted actions. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/IuHkukKoSrzunmpTtJoRPA/content 06.txt passed rejected Too generic to be a distinct capability; incident handling is covered by more specific statements.   rejected Too generic to name a distinct capability; incident handling is covered by the specific surviving statements. 0.0
F2-043-B029 ServiceNow IT Service Management F2-043 b The system lets an agent use knowledge articles to accelerate incident resolution Agents can use information from similar incidents and knowledge articles to accelerate incident resolution. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/IuHkukKoSrzunmpTtJoRPA/content 06.txt passed rejected duplicate of F2-043-A025   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B030 ServiceNow IT Service Management F2-043 b The system lets an agent reach out to experts on-call for high-priority tasks Agents can reach out to experts on-call for high-priority tasks. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/IuHkukKoSrzunmpTtJoRPA/content 06.txt passed rejected duplicate of F2-043-A021   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B031 ServiceNow IT Service Management F2-043 b The system lets an agent collaborate with the requester and peers from a task using a team chat tool Agents can collaborate with the requester and peers from the task using Microsoft Teams chat. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/IuHkukKoSrzunmpTtJoRPA/content 06.txt passed rejected duplicate of F2-043-A022   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B032 ServiceNow IT Service Management F2-043 b The system lets an agent manage the entire life cycle of requests Agents can also manage the entire life cycle of requests. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/IuHkukKoSrzunmpTtJoRPA/content 06.txt passed rejected duplicate of F2-043-A008   confirmed Agent-side management of the request life cycle (06.txt line 82) differs from a user requesting catalog items in A008. 1.0
F2-043-B033 ServiceNow IT Service Management F2-043 b The system lets an agent review and manage walk-up interactions Agents and administrators can review and manage walk-up interactions, appointments, stockrooms, and kiosks at the walk-up service location. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/IuHkukKoSrzunmpTtJoRPA/content 06.txt passed rejected duplicate of F2-043-A024   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B034 ServiceNow IT Service Management F2-043 b The system lets an agent review and manage walk-up appointments Agents and administrators can review and manage walk-up interactions, appointments, stockrooms, and kiosks at the walk-up service location. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/IuHkukKoSrzunmpTtJoRPA/content 06.txt passed rejected duplicate of F2-043-A024   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B035 ServiceNow IT Service Management F2-043 b The system lets an agent review and manage stockrooms at the walk-up service location Agents and administrators can review and manage walk-up interactions, appointments, stockrooms, and kiosks at the walk-up service location. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/IuHkukKoSrzunmpTtJoRPA/content 06.txt passed rejected duplicate of F2-043-A024   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B036 ServiceNow IT Service Management F2-043 b The system lets an agent review and manage kiosks at the walk-up service location Agents and administrators can review and manage walk-up interactions, appointments, stockrooms, and kiosks at the walk-up service location. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/IuHkukKoSrzunmpTtJoRPA/content 06.txt passed rejected duplicate of F2-043-A024   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B037 ServiceNow IT Service Management F2-043 b The system lets an agent follow a guided tour of interactive steps through a process or task Use a guided tour that is sequence of interactive steps to guide an agent through a specific process or task https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/IuHkukKoSrzunmpTtJoRPA/content 06.txt passed rejected duplicate of F2-043-A029   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B038 ServiceNow IT Service Management F2-043 b The system lets an agent create an incident based on the issue reported The agent can create an incident based on the issue reported. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/IuHkukKoSrzunmpTtJoRPA/content 06.txt passed rejected duplicate of F2-043-A028   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B039 ServiceNow IT Service Management F2-043 b The system lets an agent create a change request to fix an issue The agent can create a change request to fix the issue. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/IuHkukKoSrzunmpTtJoRPA/content 06.txt passed rejected duplicate of F2-043-A054   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B040 ServiceNow IT Service Management F2-043 b The system lets a user track the physical, technological, contractual, and financial aspects of IT assets Track the physical, technological, contractual, and financial aspects of IT assets. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/kSjKycBSAxqdKWB1aGBJiA/content 09.txt passed rejected duplicate of F2-043-A030   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B041 ServiceNow IT Service Management F2-043 b The system lets a user compare KPIs and trends with industry averages Get instant visibility into KPIs and trends with comparative insight relative to industry averages. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/kSjKycBSAxqdKWB1aGBJiA/content 09.txt passed rejected duplicate of F2-043-A031   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B043 ServiceNow IT Service Management F2-043 b The system lets a manager coach employees to improve their skill set Monitor your teams' performance and coach employees to improve their skill set. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/kSjKycBSAxqdKWB1aGBJiA/content 09.txt passed rejected duplicate of F2-043-A032   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B044 ServiceNow IT Service Management F2-043 b The system lets a user communicate and collaborate in real time from task records Communicate and collaborate in real time from task records and through communication plan channels. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/kSjKycBSAxqdKWB1aGBJiA/content 09.txt passed rejected duplicate of F2-043-A047   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B045 ServiceNow IT Service Management F2-043 b The system lets a user request improvement opportunities Request improvement opportunities and implement phases and tasks to meet performance goals. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/kSjKycBSAxqdKWB1aGBJiA/content 09.txt passed rejected duplicate of F2-043-A033   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B047 ServiceNow IT Service Management F2-043 b The system lets a user import data from an external DevOps tool chain to deliver changes Import data from your DevOps tool chain to the ServiceNow platform and deliver changes faster without sacrificing compliance. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/kSjKycBSAxqdKWB1aGBJiA/content 09.txt passed rejected duplicate of F2-043-A034   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B048 ServiceNow IT Service Management F2-043 b The system lets a user validate and manage configuration data of enterprise applications across the stages of a DevOps pipeline Validate and manage configuration data of enterprise applications across every stage of the DevOps pipeline. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/kSjKycBSAxqdKWB1aGBJiA/content 09.txt passed rejected duplicate of F2-043-A035   rejected (duplicate upheld) duplicate upheld 0.0
F2-043-B049 ServiceNow IT Service Management F2-043 b The system lets a user monitor applications, networks, and devices Monitor applications, networks, and devices to promote optimal performance across all channels. https://www.servicenow.com/docs/api/khub/maps/eH2O6EPUpf09wX0~2cZBFg/topics/kSjKycBSAxqdKWB1aGBJiA/content 09.txt passed rejected duplicate of F2-043-A073   rejected (duplicate upheld) duplicate upheld 0.0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [candidates] ([candidate_id] TEXT PRIMARY KEY, [app_id] TEXT, [run] TEXT, [statement] TEXT, [excerpt] TEXT, [source_url] TEXT, [source_file] TEXT, [script_check] TEXT, [verifier_verdict] TEXT, [verifier_reason] TEXT, [verifier_correction] TEXT, [adjudicator] TEXT, [adjudicator_reason] TEXT, [in_final_set] REAL, FOREIGN KEY ([app_id]) REFERENCES apps(app_id));
CREATE INDEX [idx_candidates_app_id] ON [candidates]([app_id]);
CREATE INDEX [idx_candidates_run] ON [candidates]([run]);
CREATE INDEX [idx_candidates_verifier_verdict] ON [candidates]([verifier_verdict]);
CREATE INDEX [idx_candidates_adjudicator] ON [candidates]([adjudicator]);