Corporate actions. Stock splits and cash dividends. A split adjusts every open tax lot (quantity times the ratio, unit cost divided by it) on the ex-date; a dividend books cash to each account holding the security. Applied deterministically and undoable with the batch. Key: ref. One file: the header attributes, then the records. The business date the data is for (YYYY-MM-DD). Your firm code, shown on Data › Feeds (e.g. F00012). Who produced the file (vendor or system name). When the file was produced (UTC). The number of record elements. A file whose count does not match is refused (F004): it was probably cut short. delta: only the records in the file change. full: the file is complete (this data set has no inactivation: full behaves as delta). One corporate actions record. Elements may appear in any order. Your (or the vendor's) reference for the event. The key. A code: letters, digits, "_", "." or "-", up to 40. Part of the key. The security. A ticker symbol: letters, digits, "." or "-", up to 12. split or dividend. One of: split, dividend. The ex-date: the action applies to holdings at the start of this day. An ISO date, YYYY-MM-DD. Payment date (dividends). An ISO date, YYYY-MM-DD. Split: new shares per old share (2 for a 2-for-1 split, 0.1 for a 1-for-10 reverse split). A decimal number written as text, e.g. 1234.5 (min 1.0E-6 max 1000). Dividend: cash per share, in the security's currency. A decimal number written as text, e.g. 1234.5 (min 0 max 100000). upsert (insert or update by key).