Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql

Source identity

Field	Recorded value
Source type	GitHub source
Original record	Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql
Date	Not specified in source
Repository	Janady13/missionmatch
Revision	720d47fae476b0d38477ae4401697d372b1ea2bc
Branch	feature/opportunity-to-outcome
Path or archive member	db/migrations/0024_model_version_v1_4_0.sql
Original SHA-256	f09879369b891f3608da0bceab52f0104e0b22b8b755c3aa2d13b3a0a5a34a16
Git blob SHA	159a0c230c47700caafbeb32916bd5445ebc1d80
Reading-copy SHA-256	f09879369b891f3608da0bceab52f0104e0b22b8b755c3aa2d13b3a0a5a34a16

Original source ↗

Every recorded occurrence

These 17 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/migrations/0024_model_version_v1_4_0.sql	feature/opportunity-to-outcome	720d47fae476b0d38477ae4401697d372b1ea2bc	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	collision-deconfliction	4ee5a09972608ed89f8377c6665542d5f450f0a6	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	ws6-retrieval	6c56e29231ec05735927fa265c97d517499dfeaf	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	m5-price-to-win	41000ad30fff4129fdaf5ec84e15ba14c27d4890	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	master	1e9249840a4302ec82e123b9c9cb6f75badea3e4	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	ws8-teaching-loop	c823f0fb6bb2aba0f39001eb6de96f4000d9321f	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	mag-substrate	b82c7100a492dec67dfd1eda6b3f53def859be35	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	phase2-eval-fairness	d361af254701975fe239927656ababb56374655e	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	time-to-fill-survival	b66e1e505863d4f17741a4b9ede73509e45bd6c6	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	graphrag-foundation	b0ddeb9f633fd138d09309d1a17b7d13bc3a67f7	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	ws9-bench-ingestion	f585a9ef32fa554663ce1fba9a414a54b6e49cf0	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	presentation-readiness	eb574acaa29d71ce4d0f852572e87c275c79fdb7	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	vendor-intelligence	fe9796a19c261951d3f2565206c0c1b5ac294465	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	ws7-federal-signal	6a9f6ce9cfb13345ffb47770d4960e7c2d9c17c2	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	phase2-connectors	e038d4c687aec16f8bd9bc4d907eea14d91f8704	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	feature/aioe-upgrade	2178e7298d0e5d9af83afa12402fd587f0ba6ed8	Open original
Janady13/missionmatch / db/migrations/0024_model_version_v1_4_0.sql	capture-readiness	bae6af7cb2997e819174a9e9cfff5e16067a1975	Open original

Recovered source transcript

Download complete source text ↓24 lines · 2.1 KB

-- +goose Up
-- v1.4.0 model registration. Two deterministic band caps are added to the engine; the six component
-- weights, the band cut points (Green >= 90, Yellow >= 75), and the DefaultSemanticThreshold (0.62)
-- are unchanged from v1.3.0. The Total score is never altered by the caps; only the Band can be
-- lowered. Both caps are checked after bandFor(Total) and take effect in this precedence order:
--
--   1. CLEARANCE GAP: if the requirement specifies a clearance at or above Confidential AND the
--      clearance component scored 0 (insufficient level, inactive or expired status, unsatisfied
--      poly, or a missing required compartment), the band is capped at Red regardless of the total.
--   2. MANDATORY SKILL GAP: if any required skill marked Mandatory is unmet AND the weighted total
--      produced a Green band, the band is lowered to Yellow. A Yellow or Red band is unchanged.
--
-- Clearance remains a self reported indicator, never an input proxy for a protected attribute.
-- The cap reasons are always appended to the Explanation field for AEDT auditability.
INSERT INTO aedt_model_versions (version, weights, band_cuts, notes) VALUES (
    'v1.4.0',
    '{"clearance":0.25,"skills":0.25,"certifications":0.15,"customer_experience":0.15,"experience":0.10,"location_availability":0.10}',
    '{"green":90,"yellow":75}',
    'Adds two deterministic band caps that lower the band after bandFor(Total); the Total, the six weights, the band cut points, and the 0.62 semantic threshold are unchanged from v1.3.0. Cap 1: a required clearance (RequiredLevel >= Confidential) with a zero clearance score caps the band at Red (covers insufficient level, inactive or expired status, unsatisfied poly, and a missing required compartment). Cap 2: any unmet mandatory required skill caps a Green band at Yellow (Yellow and Red are unchanged). Precedence: clearance cap wins. Cap reasons are recorded in the Explanation field for AEDT explainability. Clearance stays a self reported indicator.'
) ON CONFLICT (version) DO NOTHING;

-- +goose Down
DELETE FROM aedt_model_versions WHERE version = 'v1.4.0';