Source identity
| Field | Recorded value |
|---|---|
| Source type | GitHub source |
| Original record | Janady13/missionmatch / db/migrations/0045_term_expansions_mega.sql |
| Date | Not specified in source |
| Repository | Janady13/missionmatch |
| Revision | 720d47fae476b0d38477ae4401697d372b1ea2bc |
| Branch | feature/opportunity-to-outcome |
| Path or archive member | db/migrations/0045_term_expansions_mega.sql |
| Original SHA-256 | 3145ae2aaf788e39af5599b454766330101c9126f75444cfe8b0d77f5ea609c9 |
| Git blob SHA | a05b32a38c8e8e9633a44994f1ac1f1a6d365a0b |
| Reading-copy SHA-256 | 3145ae2aaf788e39af5599b454766330101c9126f75444cfe8b0d77f5ea609c9 |
Every recorded occurrence
These 2 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/0045_term_expansions_mega.sql | feature/opportunity-to-outcome | 720d47fae476b0d38477ae4401697d372b1ea2bc | Open original |
| Janady13/missionmatch / db/migrations/0045_term_expansions_mega.sql | feature/aioe-upgrade | 2178e7298d0e5d9af83afa12402fd587f0ba6ed8 | Open original |
Recovered source transcript
Download complete source text ↓203 lines · 13.9 KB
-- +goose Up
-- The vocabulary mega seed for the acronym and term expansion layer (knowledge layer growth).
-- Migration 0044 seeded the core GovCon and DoD terms; this extends the GLOBAL seed
-- (organization_id NULL, migrator owned, read only to every tenant) across the intelligence, cyber,
-- space, acquisition, clearance, compliance, and program management vocabulary a cleared staffing
-- platform actually reads. 144 pairs. Editorial rule: every alias is UNAMBIGUOUS in the
-- cleared staffing context (one canonical expansion). Ambiguous acronyms are deliberately absent
-- (IOC, SDA, SSA, SAP, SAR, EOD, CNA, CAP, FAR, EAR, CISA, and all bare two letter tokens collide
-- across domains and would let the deterministic resolver invent a match), which is the AEDT safe
-- choice: a wrong expansion is a wrong skill match.
--
-- Generated from a single source list (scratchpad gen0045.js) so the UP insert and the DOWN delete
-- can never drift. Idempotent: ON CONFLICT DO NOTHING against the (scope, lower(alias),
-- lower(expansion)) unique index, so it runs cleanly before or after 0044 and is safe to re-run.
INSERT INTO term_expansions (alias, expansion) VALUES
('FININT', 'Financial Intelligence'),
('TECHINT', 'Technical Intelligence'),
('CYBINT', 'Cyber Intelligence'),
('SOCMINT', 'Social Media Intelligence'),
('IMINT', 'Imagery Intelligence'),
('ACINT', 'Acoustic Intelligence'),
('RADINT', 'Radar Intelligence'),
('FISINT', 'Foreign Instrumentation Signals Intelligence'),
('AllSource', 'All Source Intelligence'),
('F3EAD', 'Find Fix Finish Exploit Analyze Disseminate'),
('PIR', 'Priority Intelligence Requirement'),
('EEI', 'Essential Elements of Information'),
('IPB', 'Intelligence Preparation of the Battlefield'),
('I&W', 'Indications and Warning'),
('HVT', 'High Value Target'),
('BDA', 'Battle Damage Assessment'),
('PED', 'Processing Exploitation and Dissemination'),
('TCPED', 'Tasking Collection Processing Exploitation and Dissemination'),
('GMTI', 'Ground Moving Target Indicator'),
('FMV', 'Full Motion Video'),
('SEI', 'Specific Emitter Identification'),
('EOB', 'Electronic Order of Battle'),
('ORSA', 'Operations Research and Systems Analysis'),
('SIGDEV', 'Signals Development'),
('JADC2', 'Joint All Domain Command and Control'),
('GCCS', 'Global Command and Control System'),
('DCGS', 'Distributed Common Ground System'),
('TAK', 'Tactical Assault Kit'),
('ATAK', 'Android Tactical Assault Kit'),
('MPE', 'Mission Partner Environment'),
('DODIN', 'Department of Defense Information Network'),
('DREN', 'Defense Research and Engineering Network'),
('JRSS', 'Joint Regional Security Stacks'),
('GIG', 'Global Information Grid'),
('NSANet', 'NSA Network'),
('SSBI', 'Single Scope Background Investigation'),
('NDA', 'Non Disclosure Agreement'),
('SF86', 'Standard Form 86'),
('LAA', 'Limited Access Authorization'),
('IT-I', 'Information Technology Level 1'),
('IT-II', 'Information Technology Level 2'),
('NBIS', 'National Background Investigation Services'),
('DCSA', 'Defense Counterintelligence and Security Agency'),
('DFIR', 'Digital Forensics and Incident Response'),
('CTI', 'Cyber Threat Intelligence'),
('TTP', 'Tactics Techniques and Procedures'),
('APT', 'Advanced Persistent Threat'),
('EDR', 'Endpoint Detection and Response'),
('XDR', 'Extended Detection and Response'),
('NDR', 'Network Detection and Response'),
('SOAR', 'Security Orchestration Automation and Response'),
('DLP', 'Data Loss Prevention'),
('CASB', 'Cloud Access Security Broker'),
('WAF', 'Web Application Firewall'),
('IDS', 'Intrusion Detection System'),
('IPS', 'Intrusion Prevention System'),
('NAC', 'Network Access Control'),
('PAM', 'Privileged Access Management'),
('VDI', 'Virtual Desktop Infrastructure'),
('MFA', 'Multi Factor Authentication'),
('SSO', 'Single Sign On'),
('RBAC', 'Role Based Access Control'),
('ABAC', 'Attribute Based Access Control'),
('CND', 'Computer Network Defense'),
('CNE', 'Computer Network Exploitation'),
('CPT', 'Cyber Protection Team'),
('SAST', 'Static Application Security Testing'),
('DAST', 'Dynamic Application Security Testing'),
('SBOM', 'Software Bill of Materials'),
('CVSS', 'Common Vulnerability Scoring System'),
('SCADA', 'Supervisory Control and Data Acquisition'),
('IATO', 'Interim Authority to Operate'),
('IATT', 'Interim Authorization to Test'),
('ATC', 'Authority to Connect'),
('SCA', 'Security Control Assessor'),
('ISSO', 'Information System Security Officer'),
('ISSM', 'Information System Security Manager'),
('AO', 'Authorizing Official'),
('CCI', 'Control Correlation Identifier'),
('SRG', 'Security Requirements Guide'),
('SSP', 'System Security Plan'),
('SCTM', 'Security Controls Traceability Matrix'),
('SCAP', 'Security Content Automation Protocol'),
('A&A', 'Assessment and Authorization'),
('C&A', 'Certification and Accreditation'),
('ConMon', 'Continuous Monitoring'),
('FISMA', 'Federal Information Security Modernization Act'),
('NIST', 'National Institute of Standards and Technology'),
('CNSS', 'Committee on National Security Systems'),
('CNSSI', 'Committee on National Security Systems Instruction'),
('DAAPM', 'DoD Assessment and Authorization Process Manual'),
('ICD 503', 'Intelligence Community Directive 503'),
('JSIG', 'Joint SAP Implementation Guide'),
('CDS', 'Cross Domain Solutions'),
('ITAR', 'International Traffic in Arms Regulations'),
('PII', 'Personally Identifiable Information'),
('PHI', 'Protected Health Information'),
('HIPAA', 'Health Insurance Portability and Accountability Act'),
('RPO', 'Rendezvous and Proximity Operations'),
('EHF', 'Extremely High Frequency'),
('SATCOM', 'Satellite Communications'),
('GPS', 'Global Positioning System'),
('PNT', 'Positioning Navigation and Timing'),
('IDIQ', 'Indefinite Delivery Indefinite Quantity'),
('BPA', 'Blanket Purchase Agreement'),
('GWAC', 'Government Wide Acquisition Contract'),
('RFP', 'Request for Proposal'),
('RFI', 'Request for Information'),
('RFQ', 'Request for Quotation'),
('SOW', 'Statement of Work'),
('PWS', 'Performance Work Statement'),
('CDRL', 'Contract Data Requirements List'),
('CLIN', 'Contract Line Item Number'),
('CPARS', 'Contractor Performance Assessment Reporting System'),
('OCI', 'Organizational Conflict of Interest'),
('LPTA', 'Lowest Price Technically Acceptable'),
('FFP', 'Firm Fixed Price'),
('CPFF', 'Cost Plus Fixed Fee'),
('CPIF', 'Cost Plus Incentive Fee'),
('WBS', 'Work Breakdown Structure'),
('IMS', 'Integrated Master Schedule'),
('IMP', 'Integrated Master Plan'),
('EVM', 'Earned Value Management'),
('ROM', 'Rough Order of Magnitude'),
('COR', 'Contracting Officer Representative'),
('CMMI', 'Capability Maturity Model Integration'),
('MBSE', 'Model Based Systems Engineering'),
('IaC', 'Infrastructure as Code'),
('SRE', 'Site Reliability Engineering'),
('K8s', 'Kubernetes'),
('NLP', 'Natural Language Processing'),
('ETL', 'Extract Transform Load'),
('API', 'Application Programming Interface'),
('CISSP', 'Certified Information Systems Security Professional'),
('CISM', 'Certified Information Security Manager'),
('CEH', 'Certified Ethical Hacker'),
('OSCP', 'Offensive Security Certified Professional'),
('GSEC', 'GIAC Security Essentials'),
('GCIH', 'GIAC Certified Incident Handler'),
('GCIA', 'GIAC Certified Intrusion Analyst'),
('CCNA', 'Cisco Certified Network Associate'),
('CCNP', 'Cisco Certified Network Professional'),
('CASP', 'CompTIA Advanced Security Practitioner'),
('ITIL', 'Information Technology Infrastructure Library')
ON CONFLICT DO NOTHING;
-- +goose Down
-- Remove ONLY the global rows this migration introduced (by their exact expansions), leaving the
-- 0044 core seed and every tenant addition untouched.
DELETE FROM term_expansions WHERE organization_id IS NULL AND expansion IN (
'Financial Intelligence','Technical Intelligence','Cyber Intelligence','Social Media Intelligence',
'Imagery Intelligence','Acoustic Intelligence','Radar Intelligence','Foreign Instrumentation Signals Intelligence',
'All Source Intelligence','Find Fix Finish Exploit Analyze Disseminate','Priority Intelligence Requirement','Essential Elements of Information',
'Intelligence Preparation of the Battlefield','Indications and Warning','High Value Target','Battle Damage Assessment',
'Processing Exploitation and Dissemination','Tasking Collection Processing Exploitation and Dissemination','Ground Moving Target Indicator','Full Motion Video',
'Specific Emitter Identification','Electronic Order of Battle','Operations Research and Systems Analysis','Signals Development',
'Joint All Domain Command and Control','Global Command and Control System','Distributed Common Ground System','Tactical Assault Kit',
'Android Tactical Assault Kit','Mission Partner Environment','Department of Defense Information Network','Defense Research and Engineering Network',
'Joint Regional Security Stacks','Global Information Grid','NSA Network','Single Scope Background Investigation',
'Non Disclosure Agreement','Standard Form 86','Limited Access Authorization','Information Technology Level 1',
'Information Technology Level 2','National Background Investigation Services','Defense Counterintelligence and Security Agency','Digital Forensics and Incident Response',
'Cyber Threat Intelligence','Tactics Techniques and Procedures','Advanced Persistent Threat','Endpoint Detection and Response',
'Extended Detection and Response','Network Detection and Response','Security Orchestration Automation and Response','Data Loss Prevention',
'Cloud Access Security Broker','Web Application Firewall','Intrusion Detection System','Intrusion Prevention System',
'Network Access Control','Privileged Access Management','Virtual Desktop Infrastructure','Multi Factor Authentication',
'Single Sign On','Role Based Access Control','Attribute Based Access Control','Computer Network Defense',
'Computer Network Exploitation','Cyber Protection Team','Static Application Security Testing','Dynamic Application Security Testing',
'Software Bill of Materials','Common Vulnerability Scoring System','Supervisory Control and Data Acquisition','Interim Authority to Operate',
'Interim Authorization to Test','Authority to Connect','Security Control Assessor','Information System Security Officer',
'Information System Security Manager','Authorizing Official','Control Correlation Identifier','Security Requirements Guide',
'System Security Plan','Security Controls Traceability Matrix','Security Content Automation Protocol','Assessment and Authorization',
'Certification and Accreditation','Continuous Monitoring','Federal Information Security Modernization Act','National Institute of Standards and Technology',
'Committee on National Security Systems','Committee on National Security Systems Instruction','DoD Assessment and Authorization Process Manual','Intelligence Community Directive 503',
'Joint SAP Implementation Guide','Cross Domain Solutions','International Traffic in Arms Regulations','Personally Identifiable Information',
'Protected Health Information','Health Insurance Portability and Accountability Act','Rendezvous and Proximity Operations','Extremely High Frequency',
'Satellite Communications','Global Positioning System','Positioning Navigation and Timing','Indefinite Delivery Indefinite Quantity',
'Blanket Purchase Agreement','Government Wide Acquisition Contract','Request for Proposal','Request for Information',
'Request for Quotation','Statement of Work','Performance Work Statement','Contract Data Requirements List',
'Contract Line Item Number','Contractor Performance Assessment Reporting System','Organizational Conflict of Interest','Lowest Price Technically Acceptable',
'Firm Fixed Price','Cost Plus Fixed Fee','Cost Plus Incentive Fee','Work Breakdown Structure',
'Integrated Master Schedule','Integrated Master Plan','Earned Value Management','Rough Order of Magnitude',
'Contracting Officer Representative','Capability Maturity Model Integration','Model Based Systems Engineering','Infrastructure as Code',
'Site Reliability Engineering','Kubernetes','Natural Language Processing','Extract Transform Load',
'Application Programming Interface','Certified Information Systems Security Professional','Certified Information Security Manager','Certified Ethical Hacker',
'Offensive Security Certified Professional','GIAC Security Essentials','GIAC Certified Incident Handler','GIAC Certified Intrusion Analyst',
'Cisco Certified Network Associate','Cisco Certified Network Professional','CompTIA Advanced Security Practitioner','Information Technology Infrastructure Library'
);