Katelynn's Report

Katelynn's Report

(US Market)

Help










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=23245 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=11850 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.