Janady13/missionmatch / db/queries/slates.sql

Source identity

Field	Recorded value
Source type	GitHub source
Original record	Janady13/missionmatch / db/queries/slates.sql
Date	Not specified in source
Repository	Janady13/missionmatch
Revision	09015496d565a172bcaa15cfe9a8e4b072b13df0
Branch	workstream-b-screenmatch
Path or archive member	db/queries/slates.sql
Original SHA-256	8b070f23e9f22372144887f9fa9fbbfb89d4e24702d83fb0e49fd31327f9b839
Git blob SHA	78522e5e20a7fbc6f40a98445f9018e70a29a809
Reading-copy SHA-256	8b070f23e9f22372144887f9fa9fbbfb89d4e24702d83fb0e49fd31327f9b839

Original source ↗

Every recorded occurrence

These 5 records contain identical original source bytes. Their paths and revisions remain part of the archive.

Original record	Branch or archive	Revision / identifier	Original location
Janady13/missionmatch / db/queries/slates.sql	workstream-b-screenmatch	09015496d565a172bcaa15cfe9a8e4b072b13df0	Open original
Janady13/missionmatch / db/queries/slates.sql	ruthless-debug-sweep	b7d742f8f032984be3817efffa3eb8b13b651c1f	Open original
Janady13/missionmatch / db/queries/slates.sql	workstream-a-shared-core	e0de03ac3a1ec826bd15d0e048e3b02baa23eeff	Open original
Janady13/missionmatch / db/queries/slates.sql	ruthless-debug-sweep	b7d742f8f032984be3817efffa3eb8b13b651c1f	Open original
Janady13/missionmatch / db/queries/slates.sql	workstream-b-screenmatch	09015496d565a172bcaa15cfe9a8e4b072b13df0	Open original

Recovered source transcript

Download complete source text ↓40 lines · 1.4 KB

-- name: CreateSlate :one
INSERT INTO slates (organization_id, requirement_id, name, status, created_by)
VALUES ($1,$2,$3,$4,$5)
RETURNING *;

-- name: GetSlate :one
SELECT * FROM slates WHERE id = $1;

-- name: ListSlatesForRequirement :many
SELECT * FROM slates WHERE requirement_id = $1 ORDER BY created_at DESC, id;

-- name: UpdateSlateStatus :one
UPDATE slates SET status = $2, updated_at = now() WHERE id = $1 RETURNING *;

-- name: AddSlateMember :one
INSERT INTO slate_members (
    organization_id, slate_id, candidate_id,
    total_score, band,
    clearance_score, skills_score, certs_score, customer_score, experience_score, location_score,
    explanation, trace, gap_summary, rank, model_version
) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16)
RETURNING *;

-- name: ListSlateMembers :many
SELECT * FROM slate_members
WHERE slate_id = $1
ORDER BY rank NULLS LAST, total_score DESC, candidate_id;  -- PK tiebreaker => total order [review SQLC-5]

-- name: GetSlateMember :one
-- The frozen decision record for one member: the full per component trace, rationale, and gap summary
-- for the audit and candidate facing explanation.
SELECT * FROM slate_members WHERE slate_id = $1 AND candidate_id = $2;

-- name: SetSlateMemberDecision :one
-- Human-in-the-loop: a person approves/rejects each member. Never auto-decided.
UPDATE slate_members
SET decision = $3, decided_by = $4, decided_at = now()
WHERE slate_id = $1 AND candidate_id = $2
RETURNING *;