ADO.NET Provider for Greenhouse

Build 24.0.9062

Scorecards

Query the scorecards of an organization.

SELECT

Note: Filters provided with one of the supported operators listed in the "Operators" column can be processed server-side, all the other filters are processed client-side.

SELECT * FROM Scorecards WHERE Id = 5227228007;
SELECT * FROM Scorecards WHERE ApplicationId = 4230124147;
SELECT * FROM Scorecards WHERE CreatedAt = '2024-03-01 12:00:00.000';
SELECT * FROM Scorecards WHERE UpdatedAt >= '2024-01-01 12:00:00.000' AND UpdatedAt <= '2024-03-01 12:00:00.000';

Columns

Name Type Operators Description
Id [KEY] Int64 = Scorecard ID.
UpdatedAt Datetime >=,>,=,<,<= The timestamp when the scorecard was last updated.
CreatedAt Datetime >=,>,=,<,<= The timestamp when the scorecard was created.
Interview String Name of the interview.
InterviewStepId Int64 Interview step ID.
InterviewStepName String Name of the interview step.
CandidateId Int64 Candidate ID.
ApplicationId Int64 = Application ID.
InterviewedAt Datetime The timestamp when the candidate was interviewed.
SubmittedById Int64 The ID of the user who submitted the scorecard.
SubmittedByFirstName String The first name of the user who submitted the scorecard.
SubmittedByLastName String The last name of the user who submitted the scorecard.
SubmittedByName String The full name of the user who submitted the scorecard.
SubmittedByEmployeeId String The employee ID of the user who submitted the scorecard.
InterviewerId Int64 The ID of the user who interviewed the candidate.
InterviewerFirstName String The first name of the user who interviewed the candidate.
InterviewerLastName String The last name of the user who interviewed the candidate.
InterviewerName String The full name of the user who interviewed the candidate.
InterviewerEmployeeId String The employee ID of the user who interviewed the candidate.
SubmittedAt Datetime The timestamp when the scorecard was submitted.
OverallRecommendation String One of: definitely_not, no, yes, strong_yes, no_decision.
Attributes String Array of attributes.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062