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