Reference Numbers: Key /ky refnum

Reference Numbers are numeric codes assigned to Compustat data. Like Reference Codes, Reference Number data can be used in two ways: to return a list of unknown numeric codes, or to find the meaning of a specific numeric code.

Like reference codes, if reference numbers are unknown, the full list can be retrieved by using the asterisk as a wild card key, “*”. If the reference number is known but its meaning is not, entering the identified reference number key will return its information.

To obtain a full list of Cash Flow Format reference numbers,

Enter identifier or new option beginning with a slash.
Type ? for help.
/ky refnum
Date range: 20080215 - 20090215
 
 
Enter identifier or new option beginning with a slash.
Type ? for help.
/cf
Keep previous data options? (y/n)
n
Date range: 20080215 - 20090215
options have been reset.
 
 
Enter identifier or new option beginning with a slash.
Type ? for help.
*
 
NUM = 0
 
Cash Flow Format
----------------
SCFCD SCFDESC
0 No usable statement
1 Working Capital Statement
2 Cash Statement Classified by Source and Use
3 Cash Statement Classified by Activity
4 ROW Cash Flow Format
 
 

When a Cash Flow Format reference number is known but its meaning is not, use the number to return its meaning:

Enter identifier or new option beginning with a slash.
Type ? for help.
/cf
Keep previous data options? (y/n)
n
Date range: 20080215 - 20090215
options have been reset.
 
Enter identifier or new option beginning with a slash.
Type ? for help.
5
 
NUM = 5
 
Cash Flow Format
----------------

SCFCD

SCFDESC
 
       5 Net Liquid Funds/Net Funds Statement Classified by Source and Use

Each of these groups contains:

  • an integer code item (*CD) which describes a base item from the CCM data
  • occasional secondary keys (which cannot be used to filter data)
  • a text description (*DESC) of the code
Print Pption Description Base Item Items
/ao Auditor Opinion AUOP AUOPCD
AUOPDESC
/au Auditor AU AUCD
AUDESC
/cf Cash Flow Format SCF SCFCD
SCFDESC
/do Source Document SRC SRCCD
SRCDESC
/dq Source Document (Quarterly) SRCQ SRCQCD
SRCQDESC
/es S&P Economic Sector SPCSEC SPSECCD
SPSECDESC
/ex Stock Exchange EXCHG EXCHGCD
EXCHGDESC
/fi Fortune Industry FORI FORICD
FORISTAT
FORIDESC
/gi GICS GGROUP, GIND, GSECTOR, GSUBIND GICCD
GICSTAT
GICDESC
/ii S&P Industry Index SPII SPIICD
SPIISTAT
SPIIDESC
/im Income Statement Model ISMOD ISMODCD
ISMODDESC
/iv Inventory Valuation INVVAL INVVALCD
INVVALDESC
/na NAICS NAICS NAICSCD
NAICSTAT
NAICSDESC
/pr Price Status PRCSTD PRCSTDCD
PRCSTDDESC
/sc SIC SIC, SICH XPFSICCD
SICSTAT
SICDESC
/si S&P Industry Sector SPIND SPINDCD
SPINDDESC
/sm S&P Major Index SPMI SPMICD
SPMISTAT
SPMIDESC
/so Stock Ownership STKO STKOCD
STKODESC
/up Update UPD UPDCD
UPDDESC