Katelynn's Report

(US Market)

Help

Introduction
Function Introduction
Key Metrics
Data Portal
API
- API access
SEC Forms
- Form 4
- Form 3
- Form 5
- CT ORDER
- Form 13F
- Form SC 13D
- Form SC 14D9
- Form SC 13G
- Form SC 13E1
- Form SC 13E3
- Form SC TO
- Form S-3D
- Form S-1
- Form F-1
- Form 8-k
- Form 1-E
- Form 144
- Form 20-F
- Form ARS
- Form 6-K
- Form 10-K
- Form 10-Q
- Form 10-KT
- Form 10-QT
- Form 11-K
- Form DEF 14A
- Form 10-D
- Form 13H
- Form 24F-2
- Form 15
- Form 25
- Form 40-F
- Form 424
- Form 425
- Form 8-A
- Form 8-M
- Form ADV-E
- Form ANNLRPT
- Form APP WD
- Form AW
- Form CB
- Form CORRESP
- Form DSTRBRPT
- Form EFFECT
- Form F-10
- Form F-3
- Form F-4
- Form F-6
- Form F-7
- Form F-9
- Form F-n
- Form X-17A-5
- Form F-X
- Form FWP
- Form G-405
- Form G-FIN
- Form MSD
- Form N-14
- Form N-18F1
- Form N-18F1
- Form N-30B-2
- Form N-54A
- Form N-8A
- Form N-CSR
- Form N-MFP
- Form N-PX
- Form N-Q
- Form TTW
- Form TA-1
- Form T-3
- Form SC 14F1
- Form SE
- Form SP 15D2
- Form SUPPL
- Form 10-12G
- Form 18-K
- Form SD
- Form STOP ORDER
- Form TH
- Form 1
- Form 19B-4(e)
- Form 40-APP
- Form 497
- Form ABS-15G
- Form DRS
- Form MA
- Form UNDER
AI sentiment
Access guide
Academy
Term of service
GDPR compliance
Contact Us
Question Center

Font Size:

Late filing

Late filing table keeps records for Form NT 10-K, NT 20-F, NT 11-K, NT 10-Q, NT 10-D, as well as their amendments, which delay corresponding period report for several days. It also monitors whether and when the delayed form was reported.

CREATE TABLE `latefiling` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fdate` date NOT NULL,
`cik` bigint(20) NOT NULL,
`name` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
`form` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`period` date NOT NULL,
`reportdate` date DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_latefiling_on_cik_form_period_fdate` (`cik`,`form`,`period`,`fdate`)
) ENGINE=InnoDB AUTO_INCREMENT=23249 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Field definition

fdate: The filing date of the late filing form.

cik: CIK of the reporter.

name: Full name of the reporter.

form: Type of late filing form.

period: The reporting period intended to be delayed.

reportdate: The actually filing date of the period report. This field is NULL if the period report is not filed yet.

Delisting

Delisting table keeps records for securities that were delisted through Form 25 or 25-NSE.

CREATE TABLE `delisting` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fdate` date NOT NULL,
`form` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
`exchangecik` int(11) DEFAULT NULL,
`exchangename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`issuercik` int(11) NOT NULL,
`issuername` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`filenumber` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`security` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`rule` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`signaturename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`signaturedate` date DEFAULT NULL,
`link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_issuercik_filenumber_security` (`issuercik`,`filenumber`,`security`),
KEY `index_exchangecik` (`exchangecik`)
) ENGINE=InnoDB AUTO_INCREMENT=11866 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Field definition

fdate: The filing date of the late filing form.

form: Either 25 or 25-NSE. The latter is filed by stock exchange to the SEC.

exchangecik: CIK of the stock exchange.

exchangename: Name of the stock exchange.

issuercik: CIK of the security issuer.

filenumber: File number.

security: The class of security being delisted.

rule: The governing rule.

signaturename: Name of the personnel who authorized the delisting.

signaturedate: Date of signature.

link: Http link to the original document.