spb/firc0001_uqo

1% Generated by code/make_tables.py from data/datamodel_audit.csv. Longtable: input outside a float.2{\footnotesize3\begin{longtable}{p{2.6cm}p{6.9cm}p{3.4cm}}4\caption{Tables required by the research design, current implementation and status}\label{tab:datamodel}\\5\toprule6Required table & Current implementation (database, table, key fields) & Status \\7\midrule8\endfirsthead9\multicolumn{3}{l}{\itshape Table \thetable{} (continued)}\\10\toprule11Required table & Current implementation (database, table, key fields) & Status \\12\midrule13\endhead14\midrule15\multicolumn{3}{r}{\itshape continued on the next page}\\16\endfoot17\bottomrule18\multicolumn{3}{p{12.8cm}}{\scriptsize Status at revision \texttt{2324b58}; ``partial'' and ``proposed'' rows are schema changes to be added by migration. The \texttt{amount\_raw} field is a formatted copy of the coerced float, not the filing's string; the ledger stores no model, prompt or call status.}\\19\endlastfoot20\texttt{universe\_\allowbreak{}snapshots} & \texttt{data/metadata/universe.json} + \texttt{companies} (CIK, ticker(s), name, sector, flags \texttt{in\_sp500}/\texttt{in\_russell3000}, fund weight, SIC, state, exchange, FYE, shard); snapshot date and source URL recorded & Partial: no file hash, no membership dates, no match confidence \\21\texttt{issuers} & \texttt{companies} (one row per CIK; former names from SEC header stored in metadata JSON only) & Partial: no name history, no parent/\allowbreak{}subsidiary links \\22\texttt{filings} & \texttt{filings} (accession PK, CIK FK, form, filing/report dates, SEC URL, local path, size, download and parse status) & Implemented; no acceptance timestamp, no checksum \\23\texttt{sections} & \texttt{filing\_sections} (UUID PK, accession FK, name, item, order, text, counts) & Implemented; no character offsets into raw HTML \\24\texttt{project\_\allowbreak{}mentions} & \texttt{project\_mentions} (SHA-1 id, accession, CIK, section id, name, type, description, objective, amount, formatted amount string (\texttt{amount\_raw}, not the filing's string), lists, years, status, confidence, backend, issuer context) & Implemented; no evidence span, no prompt hash, no five-way label \\25\texttt{projects} & \texttt{projects} (MD5 of CIK$|$type$|$location-or-name, representative fields, max amount, counts, first/last seen and cited years) & Implemented (deterministic key) \\26\texttt{project\_\allowbreak{}mention\_\allowbreak{}links} & implicit in the key (every mention maps to exactly one project) & Proposed: explicit table with score, resolver version, adjudication \\27\texttt{project\_\allowbreak{}events} & \texttt{project\_timeline} (one row per mention: date, form, status, amount, confidence, snippet) & Partial: mention rows, not typed events \\28\texttt{project\_\allowbreak{}amounts} & \texttt{amount\_usd}/\texttt{amount\_raw} on mentions; max on projects & Proposed: type, currency, scale, basis, realization flag \\29\texttt{extraction\_\allowbreak{}runs} & \texttt{extracted\_sections} ledger (section, accession, backend, n\_mentions, timestamp) + run logs & Partial: no prompt/\allowbreak{}schema/\allowbreak{}taxonomy hashes, no call status \\30\texttt{human\_\allowbreak{}labels} & --- & Proposed \\31\end{longtable}32}33