Insiders

Description:

Provides insider activity as reported on forms 3, 4, 5, and 144. 2 years of history is available.

Data Source:

B&B (Wealth Mgmt) -- TFN2 database

Update Schedule:

Daily (expect Sunday)

Request Syntax:

CUSIP=xxxxx to back all (derivative transactions, stock transactions, proposed transactions)

CUSIP=xxxxx/ACTUAL to get back the "actual" transactions (stock and derivative transactions)

Example:CUSIP=56418H100/ACTUAL

CUSIP=xxxxx /PROPOSED to get back the "proposed" transactons only

Example: CUSIP=56418H100/PROPOSED

Field Listing:

The following fields are available. More fields can be enable if needed.:

Field Description
ACQDISFLAG Acquisition/Disposition Flag
ACQDISFLAGALT As reported Acquisition/Disposition Flag code
AMEND Amendment Indicator
BROKERNAME Name of Broker Used in Selling
BROKID Thomson Broker ID
CLEANSE Cleanse Code: TF level of confidence concerning the accuracy of a particular record contained in the database
CNVRPRICE Conversion Price of Derivatives
COMPANY Company
CUSIP CUSIP
CUSIPCHK CUSIP number at the time of the transaction
DCNNUM Internal Thomson Document Control Number
DERVPRICE Price of Derivative Security
EXERDATE Exercisable Date of Derivatives
EXPIRDATE Expiration Date of Derivatives
FULLNAME The insider’s last, first and middle name
FUNCAREA1 Insider's functional area in the company (eg: Corporate Affairs/Public Relations, Finance/Accounting...)
FUNCAREA2 Insider's functional area in the company (eg: Corporate Affairs/Public Relations, Finance/Accounting...)
HOLDINGS Resulting Shares Held
HOLDINGSRC Source of Holdings: AP (adjusted from Proxy) and AR (as reported in insider filing)
MKTVAL Market Value of Proposed Transaction
MKTVALALT Market Value of Proposed Transaction, As-reported
NATACQ Nature of the Acquisition Transaction
NRDERVS Number of Derivatives
NRSHARES Number of Shares
OPTSELLIND ...
OWNTYPE Form of Ownership: Direct (d) or Indirect (I)
PERSID TF ID for each individual insider
PROPNRALT Proposed Number of Shares to be Sold, As-Reported
RECORDTYPE ...
RELATION1 The roles reported by the insider on Forms 3, 4, and 5
RELATION2 The roles reported by the insider on Forms 3, 4, and 5
RELATION3 The roles reported by the insider on Forms 3, 4, and 5
RELATION4 The roles reported by the insider on Forms 3, 4, and 5
ROWNUMBER ...
SCYTYPE Type of Security: common or preferred
SECRPTDATE Date of SEC Receipt
SECURITYID Thomson Permanent Security ID
TICKER Ticker
TRANCODE Transaction Code: describes the nature of the underlying transaction. Eg: “P” for open market purchase, “S” for open market sale, “X” for an conversion.
TRANCODEALT Transaction Code, As-Reported
TRANDATE Transaction date or holdings report date
TRANDATEALT As-reported transaction date
TRANPRICE Transaction Price
TRANPRICEALT Transaction Price, As-Reported
UNDSHARES Number of Shares Underlying the Derivatives