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. |