Compustat Executive Compensation

Back to Main Page.
Department of Finance and Graduate Statistical Assistant Program, FMRC

Documentation of the Compustat Executive Compensation

General Information:


Standard & Poor's ExecuComp is a unique database for effective executice compensation analyses. The ExecuComp report library acesses more that 100 up-to-date compensation and financial items from 1992 to 1998. 
 
Data Range: 1992-2000
Number of Banks:  2081 (16,411 Executives)
Update Schedule: Annually
Last Updated: June 2001

Specific Variables Information:

Executive Compensation Data Items
 
  Variable Name Type Variable Label
 
  GVKEY num GVkey
  CO_PER_R num Executive/Company Combination ID
  SALARY num Salary ($Thous)
  BONUS num Bonus ($Thous)
  OTHANN num Other Annual ($Thous)
  TCC num Total Current Compensation ($Thous)
  TDC1 num Total Compensation Incl Option Grants
  TDC2 num Total Compensation Inc Options Exercised
  RSTKGRNT num Restricted Stock Grants ($)
  RSTKHLD num Restricted Stock Holdings (# shares)
  RSTKHLDV num Restricted Stock Holdings ($ value)
  SOPTGRNT num Options Granted (# shares)
  BLK_VALU num Options Granted ($ Black-Scholes value)
  LTIP num Long Term Incentive Payouts
  ALLOTHTO num All Other Total
  ALLOTHPD num All Other Paid
  SOPTEXSH num Options Exercised (# shares)
  SOPTEXER num Value Realized from Options Exercised
  UEXNUMEX num Unexercised Exercisable Options (# shr)
  UEXNUMUN num Unexercised Unexercisable Options(# shr)
  INMONEX num Unexercised Exercisable Options ($)
  INMONUN num Unexercised Unexercisable Options ($)
  SHROWN num Shares Owned (Excl Options)
  SHROWNPC num Pct. of Company Stock Held
  CEOPERF1 num CEO Performance - Up Market
  CEOPERF2 num CEO Performance - Down Market
  SAL_PCT num Salary Percent Change Year-to-Year
  TCC_PCT num TCC Percent Change Year-to-Year
  TDC1_PCT num TDC1 Percent Change Year-to-Year
  TDC2_PCT num TDC2 Percent Change Year-to-Year
  PINCLOPT char Shares Owned Includes Options Flag
  SOPTVAL num Options Granted ($ as valued by company)
  CEOANN char Annual CEO Flag
  TITLEANN char Annual Title
  YEAR num Fiscal Year
  RSTKVYRS num Yrs Until Restr Stock Grants Beg to Vest
  COMMENT char Footnote Text
  PINTRLOC char Interlock Flag
  RETYRS num Retirement Years
  PREPRICE char Reprice Flag
  STFN char Short-Term Footnote Flag
  LTFN char Long-Term Footnore Flag
  EXEC_DIR char Executive Is Director
  AWDNUM num Award Number Identifier
  NUMBER num Number of Units Awarded
  PERIOD num Performance Period (years)
  VALTHRES num Threshold Future Payout ($)
  VALTARG num Target Future Payout ($)
  VALMAX num Maximum Future Payout ($)
  SHRTHRES num Threshold Future Payout (# shares)
  SHRTARG num Target Future Payout (# shares)
  SHRMAX num Maximum Future Payout (# shares)
  GRNTNUM num Grant Number Identifier
  PRELOAD char Reload Flag
  NUMSECUR num Number of Options Granted
  PCTTOTOP num Pct of Total Options Grantd to Employees
  MKTPRIC num Market Price of Stock on Date of Grant
  EXPRIC num Exercise Price
  EXDATE num Expiration Date
  PCDVALUE char Company Valuation Method
  VALUE num Value (Company)
  BLKSHVAL num Value (Black-Scholes)
  PERMID num Company ID Number (GVkey)
  SRCDATE num Source Date
  ANNDIRRE num Annual Director Retainer ($Thous)
  DIRMTGFE num Director Meeting Fee ($Thous)
  NUMMTGS num Number of Board Meetings
  PCOMMFEE char Director Committee Meeting Fees Flag
  PEXECDIR char Exec Directors Receive Directr Fees Flag
  PDIRPENS char Director Pension Plan Flag
  DIRSTK num Shares Received by All Directors (Thous)
  DIRSTKAD num Max Add'l Shares Received by Directors
  DIROPT num Options Received by All Directors(Thous)
  DIROPTAD num Max Add'l Options Received by Directors
  SALES num Net Sales
  SALECHG num Sales 1 Year Percent Change
  SALE3LS num Sales 3 Year Growth Rate (least squares)
  SALE5LS num Sales 5 Year Growth Rate (least squares)
  OIBD num Operating Income Before Depreciation
  OIBDCHG num OIBD 1 Year Percent Change
  OIBD3LS num OIBD 3 Year Growth Rate (least squares)
  OIBD5LS num OIBD 5 Year Growth Rate (least squares)
  PRETAX num Pretax Income
  NIBEX num Net Income Before EI and DO
  NI num Net Income (After EI and DO)
  NICHG num Net Income 1 Year Percent Change
  NI3LS num Net Income 3 Yr Growth Rate (least sqr)
  NI5LS num Net Income 5 Yr Growth Rate (least sqr)
  NIAC num Net Income Bef EI less Pref Div Reqrmnts
  EPSEX num EPS Excl EI and Discontinued Operations
  EPSEXCHG num EPS 1 Year Percent Change
  EPSEX3LS num EPS 3 Year Growth Rate (least squares)
  EPSEX5LS num EPS 5 Year Growth Rate (least squares)
  EPSIN num EPS Incl EI and Discontinued Operations
  EPSINCHG num EPS (Incl EI & DO) 1 Yr Percent Change
  COMMEQ num Common Equity
  SEQ num Stockholders Equity
  ROEPER num Return on Equity
  ROEAVG num Return on Average Equity
  ASSETS num Total Assets
  ASSETCHG num Assets 1 Year Percent Change
  ROA num Return on Assets
  MKTVAL num Market Value (Fiscal Year-End)
  DIVYIELD num Dividend Yield (Fiscal Year-End)
  PRCCF num Close Price (Fiscal Year-End)
  PRCC num Close Price (Calendar Year-End)
  SHRSOUT num Common Shares Outstanding
  TRS1YR num 1 Yr Return to Shareholders (Div Reinv)
  TRS3YR num 3 Yr Return to Shareholders (Div Reinv)
  TRS5YR num 5 Yr Return to Shareholders (Div Reinv)
  EMPL num Employees (# Thous)
  AJEX num Adjustment Factor for Stock Splits
  BS_VOLAT num Volatility (60mo) used to calc BS values
  BS_YIELD num Div Yield (3 Yr Avg) used to calc BS val
  FYR num Month of Fiscal Year End
  PCEO char Current CEO
  BECAMECE num Date Became CEO
  JOINED_C num Date Joined Company
  REJOIN num Date Rejoined Company
  LEFTOFC num Date Left as CEO
  LEFTCO num Date Left Company
  RELEFT num Date Releft Company
  TITLE char Most Recent Title
  REASON char Reason Left Company
  EXECRANK char Current Rank by Salary + Bonus
  EXECID num Executive ID Number
  CONAME char Company Name
  TICKER char Ticker Symbol
  EXCHANGE char Stock Exchange Company Trades on
  INDDESC char Industry Group Description
  CUSIP char CUSIP and Issue Number
  ADDRESS char Street Address
  CITY char City
  STATE char State
  ZIP char Zip Code
  SUB_TELE char Area Code
  TELE char Telephone Number
  SPCODE char S&P Index
  SICDESC char SIC Code Description
  SPINDEX num Industry Group
  SIC num SIC Code
  EXEC_LNA char Last Name
  EXEC_FNA char First Name
  EXEC_MNA char Middle Name
  PGENDER char Gender
  NAMEPREF char Name Prefix
  P_AGE_2 num Age

 


Back to Main Page.
Updated:  November2001 , GSA.