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	1675031db74316e100782d063e9eda1a597fe3a1
Branch	workstream-a-opportunity-intelligence
Path or archive member	db/queries/slates.sql
Original SHA-256	05e3012760caadad35c349fbf6d4aa3f708fe77fe85ab5490e918ffd4b01f711
Git blob SHA	cd0dec6546c140a8063555dcc6449f8cb392c226
Reading-copy SHA-256	05e3012760caadad35c349fbf6d4aa3f708fe77fe85ab5490e918ffd4b01f711

Original source ↗

Every recorded occurrence

These 9 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-a-opportunity-intelligence	1675031db74316e100782d063e9eda1a597fe3a1	Open original
Janady13/missionmatch / db/queries/slates.sql	workstream-d-command-center	255e7d1d420abf5e277d0cd8c9b14f6f72b6acb9	Open original
Janady13/missionmatch / db/queries/slates.sql	w0-aedt-compliance	39df94f92b2a33f852481fe1954dabed841524bb	Open original
Janady13/missionmatch / db/queries/slates.sql	workstream-e-commercial-stubs	4437da660539284a400ee380b9b427a300c369ee	Open original
Janady13/missionmatch / db/queries/slates.sql	workstream-b-sam-contract-awards	d5101cceb98e70000cebb31d3e7ac73d747d3a6d	Open original
Janady13/missionmatch / db/queries/slates.sql	workstream-d-command-center	255e7d1d420abf5e277d0cd8c9b14f6f72b6acb9	Open original
Janady13/missionmatch / db/queries/slates.sql	workstream-a-opportunity-intelligence	1675031db74316e100782d063e9eda1a597fe3a1	Open original
Janady13/missionmatch / db/queries/slates.sql	workstream-e-commercial-stubs	4437da660539284a400ee380b9b427a300c369ee	Open original
Janady13/missionmatch / db/queries/slates.sql	w0-aedt-compliance	39df94f92b2a33f852481fe1954dabed841524bb	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;

-- 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 *;