| Variable Name |
Type |
Stata Format |
Variable Label |
| |
|
|
|
| dnum |
int |
%8.0g |
industry classification code |
| cnum |
str6 |
%6s |
cusip issuer code |
| cic |
str3 |
%3s |
cusip issue number and check digit |
| file |
byte |
%8.0g |
file identification code |
| zlist |
byte |
%8.0g |
exchange listing & s&p major index code |
| smbl |
str7 |
%7s |
stock ticker symbol |
| xrel |
int |
%8.0g |
s&p industry index relative code |
| stk |
byte |
%8.0g |
stock ownership code |
| dup |
byte |
%8.0g |
duplicate file code |
| state |
byte |
%8.0g |
company location code - state |
| county |
int |
%8.0g |
company location code - county |
| finc |
byte |
%8.0g |
incorporation code - foreign |
| cpspin |
str1 |
%1s |
s&p index primary market |
| csspin |
str2 |
%2s |
s&p index secondary identifier |
| csspii |
str1 |
%1s |
s&p index subset identifier |
| spdrc |
str2 |
%2s |
s&p lt domest. issuer credit rating- cur |
| spdrcf |
str1 |
%1s |
ftnt- s&p lt dom issuer cred rating- cur |
| subdbt |
str1 |
%1s |
s&p subordinated debt rating - current |
| spcprc |
str3 |
%3s |
s&p st domest. issuer credit rating- cur |
| ein |
str10 |
%10s |
employer identification number |
| naics |
str6 |
%6s |
n. american industry classification sys. |
| date |
long |
%dD_m_Y |
fiscal year |
| fyr |
byte |
%8.0g |
fiscal yearend month of data |
| ucode |
byte |
%8.0g |
update code |
| aftnt1 |
str2 |
%2s |
sales (net) (data12) |
| aftnt2 |
str2 |
%2s |
cost of goods sold (data41) |
| aftnt3 |
str2 |
%2s |
research and development expense(data46) |
| aftnt4 |
str2 |
%2s |
rental expense (data47) |
| aftnt5 |
str2 |
%2s |
depreciation and amortization (data14) |
| aftnt6 |
str2 |
%2s |
interest expense (data15) |
| aftnt7 |
str2 |
%2s |
income taxes...(data63,64,173,211) |
| aftnt8 |
str2 |
%2s |
investment tax credit (data51) |
| aftnt9 |
str2 |
%2s |
income taxes - total (data16) |
| aftnt10 |
str2 |
%2s |
income before ei/net income(data18,172) |
| aftnt11 |
str2 |
%2s |
income before ei- adj. for cse (data20) |
| aftnt12 |
str2 |
%2s |
eps (basic) inc/exc ei (data53,58) |
| aftnt13 |
str2 |
%2s |
captial expenditures (scf) (data128) |
| aftnt14 |
str2 |
%2s |
rental commitments...(data96,164-167) |
| aftnt15 |
str2 |
%2s |
deprec, depletion, and amort...(data196) |
| aftnt16 |
str2 |
%2s |
accounts payable/esp from op(data70,233) |
| aftnt17 |
str2 |
%2s |
income taxes payable (data71) |
| aftnt18 |
str2 |
%2s |
equity in earnings (data55) |
| aftnt19 |
str2 |
%2s |
debt/long-term debt (data79-84,148,154) |
| aftnt20 |
str2 |
%2s |
long-term debt - total (data9) |
| aftnt22 |
str2 |
%2s |
labor and related expense (data42) |
| aftnt23 |
str1 |
%1s |
debt - capitalized lease oblig. (data84) |
| aftnt24 |
str2 |
%2s |
debt - maturing in ___ year (data91-94) |
| aftnt25 |
str2 |
%2s |
employees (data29) |
| aftnt26 |
str2 |
%2s |
preferred stock- liq/red val (data10,56) |
| aftnt27 |
str2 |
%2s |
assets - total... (data6) |
| aftnt28 |
str2 |
%2s |
common stock (data85) |
| aftnt29 |
str2 |
%2s |
retained earnings (data36) |
| aftnt30 |
str2 |
%2s |
foreign currency adj...(data150) |
| aftnt31 |
str2 |
%2s |
property, plant & equipment...(data8) |
| aftnt32 |
str2 |
%2s |
source document code |
| aftnt33 |
str1 |
%1s |
month of deletion |
| aftnt34 |
str1 |
%1s |
year of deletion |
| aftnt35 |
str1 |
%1s |
reason for deletion code |
| data1 |
float |
%9.0g |
cash and short-term investments (mm$) |
| data2 |
float |
%9.0g |
receivables - total (mm$) |
| data3 |
float |
%9.0g |
inventories - total (mm$) |
| data4 |
float |
%9.0g |
current assets - total (mm$) |
| data5 |
float |
%9.0g |
current liabilities - total (mm$) |
| data6 |
float |
%9.0g |
assets - total (mm$) |
| data7 |
float |
%9.0g |
property, plant & equip -...(gross)(mm$) |
| data8 |
float |
%9.0g |
property, plant & equip - ...(net)(mm$) |
| data9 |
float |
%9.0g |
long-term debt - total (mm$) |
| data10 |
float |
%9.0g |
preferred stock - liquidating value(mm$) |
| data11 |
float |
%9.0g |
common equity - tangible (mm$) |
| data12 |
float |
%9.0g |
sales (net) (mm$) |
| data13 |
float |
%9.0g |
operating income before deprec. (mm$) |
| data14 |
float |
%9.0g |
depreciation and amortization (mm$) |
| data15 |
float |
%9.0g |
interest expense (mm$) |
| data16 |
float |
%9.0g |
income taxes - total (mm$) |
| data17 |
float |
%9.0g |
special items (mm$) |
| data18 |
float |
%9.0g |
income before extraordinary items (mm$) |
| data19 |
float |
%9.0g |
dividends - preferred (mm$) |
| data20 |
float |
%9.0g |
income before ei- adj for common...(mm$) |
| data21 |
float |
%9.0g |
dividends - common (mm$) |
| data22 |
float |
%9.0g |
price - calendar year - high ($&c) |
| data23 |
float |
%9.0g |
price - calendar year - low ($&c) |
| data24 |
float |
%9.0g |
price - calendar year - close ($&c) |
| data25 |
float |
%9.0g |
common shares outstanding (mm) |
| data26 |
float |
%9.0g |
dividends per share - ex-date ($&c) |
| data27 |
float |
%9.0g |
adjustment factor (cum.) by ex-date |
| data28 |
float |
%9.0g |
common shares traded- calendar year (mm) |
| data29 |
float |
%9.0g |
employees (m) |
| data30 |
float |
%9.0g |
property, plant & equip-capital ex(mm$) |
| data31 |
float |
%9.0g |
invest. & advances - equity method (mm$) |
| data32 |
float |
%9.0g |
investments and advances - other (mm$) |
| data33 |
float |
%9.0g |
intangibles (mm$) |
| data34 |
float |
%9.0g |
debt in current liabilities (mm$) |
| data35 |
float |
%9.0g |
deferred tax & invest tax credit...(mm$) |
| data36 |
float |
%9.0g |
retained earnings (mm$) |
| data37 |
float |
%9.0g |
invested capital - total (mm$) |
| data38 |
float |
%9.0g |
minority interest (balance sheet) (mm$) |
| data39 |
float |
%9.0g |
convertible debt & preferred stock (mm$) |
| data40 |
float |
%9.0g |
common shares reserved for conver...(mm) |
| data41 |
float |
%9.0g |
cost of goods sold (mm$) |
| data42 |
float |
%9.0g |
labor and related expenses (mm$) |
| data43 |
float |
%9.0g |
pension and retirement expenses (mm$) |
| data44 |
float |
%9.0g |
debt - due in one year (mm$) |
| data45 |
float |
%9.0g |
advertising expense (mm$) |
| data46 |
float |
%9.0g |
research and development expense (mm$) |
| data47 |
float |
%9.0g |
rental expense (mm$) |
| data48 |
float |
%9.0g |
extra. items & discontinued oper. (mm$) |
| data49 |
float |
%9.0g |
minority interest (income account) (mm$) |
| data50 |
float |
%9.0g |
deferred taxes (income account) (mm$) |
| data51 |
float |
%9.0g |
investment tax credit (income acct)(mm$) |
| data52 |
float |
%9.0g |
net oper. loss carry fwd-unused...(mm$) |
| data53 |
float |
%9.0g |
eps (basic) - include extra. items ($&c) |
| data54 |
float |
%9.0g |
common shares used to calculate eps (mm) |
| data55 |
float |
%9.0g |
equity in earnings (mm$) |
| data56 |
float |
%9.0g |
preferred stock - redemption value (mm$) |
| data57 |
float |
%9.0g |
eps (diluted) - excl. extra. items ($&c) |
| data58 |
float |
%9.0g |
eps (basic) - exclude extra. items ($&c) |
| data59 |
int |
%8.0g |
inventory valuation method... |
| data60 |
float |
%9.0g |
common equity - total (mm$) |
| data61 |
float |
%9.0g |
nonoperating income (expense) (mm$) |
| data62 |
float |
%9.0g |
interest income (mm$) |
| data63 |
float |
%9.0g |
income taxes - federal (mm$) |
| data64 |
float |
%9.0g |
income taxes - foreign (mm$) |
| data65 |
float |
%9.0g |
amortization of intangibles (mm$) |
| data66 |
float |
%9.0g |
discontinued operations (mm$) |
| data67 |
float |
%9.0g |
receivables - estimated doubtful (mm$) |
| data68 |
float |
%9.0g |
current assets - other (mm$) |
| data69 |
float |
%9.0g |
assets - other (mm$) |
| data70 |
float |
%9.0g |
accounts payable (mm$) |
| data71 |
float |
%9.0g |
income taxes payable (mm$) |
| data72 |
float |
%9.0g |
current liabilities - other (mm$) |
| data73 |
float |
%9.0g |
property, plant & equip- cip... (mm$) |
| data74 |
float |
%9.0g |
deferred taxes (balance sheet) (mm$) |
| data75 |
float |
%9.0g |
liabilities - other (mm$) |
| data76 |
float |
%9.0g |
inventories - raw materials (mm$) |
| data77 |
float |
%9.0g |
inventories - work in process (mm$) |
| data78 |
float |
%9.0g |
inventories - finished goods (mm$) |
| data79 |
float |
%9.0g |
debt - convertible (mm$) |
| data80 |
float |
%9.0g |
debt - subordinated (mm$) |
| data81 |
float |
%9.0g |
debt - notes (mm$) |
| data82 |
float |
%9.0g |
debt - debentures (mm$) |
| data83 |
float |
%9.0g |
long-term debt - other (mm$) |
| data84 |
float |
%9.0g |
debt - capitalized lease obligation(mm$) |
| data85 |
float |
%9.0g |
common stock (mm$) |
| data86 |
float |
%9.0g |
treasury stock (memo entry) (mm$) |
| data87 |
float |
%9.0g |
treasury stock- num of common shares(mm) |
| data88 |
float |
%9.0g |
treasury stock - total dollar amt (mm$) |
| data89 |
float |
%9.0g |
pension c- unfunded vested benefits(mm$) |
| data90 |
float |
%9.0g |
pension c- unfunded past/prior serv(mm$) |
| data91 |
float |
%9.0g |
debt - maturing in 2nd year (mm$) |
| data92 |
float |
%9.0g |
debt - maturing in 3rd year (mm$) |
| data93 |
float |
%9.0g |
debt - maturing in 4th year (mm$) |
| data94 |
float |
%9.0g |
debt - maturing in 5th year (mm$) |
| data95 |
float |
%9.0g |
rental commitments- min - 5 yr tota(mm$) |
| data96 |
float |
%9.0g |
rental commitments - min - 1st year(mm$) |
| data97 |
float |
%9.0g |
retained earnings - unrestricted (mm$) |
| data98 |
float |
%9.0g |
order backlog (mm$) |
| data99 |
float |
%9.0g |
retained earnings restatement (mm$) |
| data100 |
float |
%9.0g |
common shareholders (m) |
| data101 |
float |
%9.0g |
interest expense on long-term debt (mm$) |
| data102 |
float |
%9.0g |
excise taxes (mm$) |
| data103 |
float |
%9.0g |
depreciation expense (schedulevi) (mm$) |
| data104 |
float |
%9.0g |
short-term borrowings - average (mm$) |
| data105 |
float |
%9.0g |
short-term borrowings - avg int. rate(%) |
| data106 |
float |
%9.0g |
equity in net loss (earnings)... (mm$) |
| data107 |
float |
%9.0g |
sale of property, plant & equip... (mm$) |
| data108 |
float |
%9.0g |
sale of common and pref. stock... (mm$) |
| data109 |
float |
%9.0g |
sale of investments... (mm$) |
| data110 |
float |
%9.0g |
funds from operations - total... (mm$) |
| data111 |
float |
%9.0g |
long-term debt - issuance...(mm$) |
| data112 |
float |
%9.0g |
sources of funds - total...(mm$) |
| data113 |
float |
%9.0g |
increase in investments... (mm$) |
| data114 |
float |
%9.0g |
long-term debt - reduction...(mm$) |
| data115 |
float |
%9.0g |
purchase of common and pref. stock (mm$) |
| data116 |
float |
%9.0g |
uses of funds - total... (mm$) |
| data117 |
float |
%9.0g |
sales (restated) (mm$) |
| data118 |
float |
%9.0g |
income before extra items(restated)(mm$) |
| data119 |
float |
%9.0g |
eps (basic) - exclud. ei (restated)($&c) |
| data120 |
float |
%9.0g |
assets - total (restated) (mm$) |
| data121 |
float |
%9.0g |
working captial (restated) (mm$) |
| data122 |
float |
%9.0g |
pretax income (restated) (mm$) |
| data123 |
float |
%9.0g |
income before extra items (scf) (mm$) |
| data124 |
float |
%9.0g |
ei & discontinued oper (scf)(mm$) |
| data125 |
float |
%9.0g |
depreciation and amortization (scf)(mm$) |
| data126 |
float |
%9.0g |
deferred taxes (statement of cf) (mm$) |
| data127 |
float |
%9.0g |
cash dividends (statement of cf) (mm$) |
| data128 |
float |
%9.0g |
capital expenditures (scf) (mm$) |
| data129 |
float |
%9.0g |
acquisitions (statement of cf) (mm$) |
| data130 |
float |
%9.0g |
preferred stock - carrying value (mm$) |
| data131 |
float |
%9.0g |
cost of goods sold (restated) (mm$) |
| data132 |
float |
%9.0g |
sg&a expenses (restated) (mm$) |
| data133 |
float |
%9.0g |
deprec. & amortization (restated) (mm$) |
| data134 |
float |
%9.0g |
interest expense (restated) (mm$) |
| data135 |
float |
%9.0g |
income taxes - total (restated) (mm$) |
| data136 |
float |
%9.0g |
ei & discontinued oper (restated)(mm$) |
| data137 |
float |
%9.0g |
eps (basic) - incl ei (restarted)($&c) |
| data138 |
float |
%9.0g |
com shares used to calc eps...(r)(mm) |
| data139 |
float |
%9.0g |
eps (diluted) - excl ei (restated)($&c) |
| data140 |
float |
%9.0g |
eps (diluted) - incl ei (restated)($&c) |
| data141 |
float |
%9.0g |
prop, plant &equip- total (net)(r)(mm$) |
| data142 |
float |
%9.0g |
long-term debt - total (restated) (mm$) |
| data143 |
float |
%9.0g |
retained earnings (restated) (mm$) |
| data144 |
float |
%9.0g |
stockholders' equity (restated) (mm$) |
| data145 |
float |
%9.0g |
capital expenditures (restated) (mm$) |
| data146 |
float |
%9.0g |
employees (restated) (m) |
| data147 |
float |
%9.0g |
interest capitalized (mm$) |
| data148 |
float |
%9.0g |
long-term debt tied to prime (mm$) |
| data149 |
int |
%8.0g |
auditor/auditor's opinion (code) |
| data150 |
float |
%9.0g |
foreign currency adj (income acct) (mm$) |
| data151 |
float |
%9.0g |
receivables - trade (mm$) |
| data152 |
float |
%9.0g |
deferred charges (mm$) |
| data153 |
float |
%9.0g |
accrued expenses (mm$) |
| data154 |
float |
%9.0g |
debt - subordinated convertible (mm$) |
| data155 |
float |
%9.0g |
ppe - buildings (net) (mm$) |
| data156 |
float |
%9.0g |
ppe - machinery & equip (net) (mm$) |
| data157 |
float |
%9.0g |
ppe - natural resources (net) (mm$) |
| data158 |
float |
%9.0g |
ppe - land and improvements (net) (mm$) |
| data159 |
float |
%9.0g |
ppe - leases (net) (mm$) |
| data160 |
float |
%9.0g |
prepaid expense (mm$) |
| data161 |
float |
%9.0g |
income tax refund (mm$) |
| data162 |
float |
%9.0g |
cash (mm$) |
| data163 |
float |
%9.0g |
rental income (mm$) |
| data164 |
float |
%9.0g |
rental commitments - min - 2nd year(mm$) |
| data165 |
float |
%9.0g |
rental commitments - min - 3rd year(mm$) |
| data166 |
float |
%9.0g |
rental commitments - min - 4th year(mm$) |
| data167 |
float |
%9.0g |
rental commitments - min - 5th year(mm$) |
| data168 |
float |
%9.0g |
compensating balance (mm$) |
| data169 |
float |
%9.0g |
eps (diluted) - incl extra items ($&c) |
| data170 |
float |
%9.0g |
pretax income (mm$) |
| data171 |
float |
%9.0g |
com shares used to calc eps (dil) (mm) |
| data172 |
float |
%9.0g |
net income (loss) (mm$) |
| data173 |
float |
%9.0g |
income taxes - state (mm$) |
| data174 |
float |
%9.0g |
depletion expense (schedule vi) (mm$) |
| data175 |
float |
%9.0g |
preferred stock - redeemable (mm$) |
| source |
byte |
%8.0g |
source document code |
| aftnt36 |
str2 |
%2s |
operating income after deprec. (data178) |
| aftnt37 |
str2 |
%2s |
acquisition- sales contribution(data249) |
| aftnt38 |
str2 |
%2s |
debt - senior convertible (data188) |
| aftnt39 |
str2 |
%2s |
deprec, depletion, and amort...(data196) |
| aftnt40 |
str2 |
%2s |
capital surplus (data210) |
| aftnt41 |
str2 |
%2s |
selling, general & adm expenses(data189) |
| aftnt42 |
str2 |
%2s |
pretax income dom/foreign (data272,273) |
| aftnt43 |
str2 |
%2s |
pension - prepaid...(overfund)(data290) |
| aftnt44 |
str2 |
%2s |
pension - prepaid...(underfund)(data300) |
| aftnt45 |
str2 |
%2s |
treasury stock (dollar amt)... (data226) |
| aftnt46 |
str2 |
%2s |
debt - consolidated subsidiary (data329) |
| aftnt47 |
str2 |
%2s |
debt - finance subsidiary (data328) |
| aftnt48 |
str2 |
%2s |
contingent guarantees - liab. (data327) |
| aftnt49 |
str2 |
%2s |
account changes - cum. effect (data183) |
| aftnt50 |
str2 |
%2s |
s&p lt dom issuer credit rat...(data280) |
| aftnt51 |
str2 |
%2s |
eps from operations (data233) |
| data177 |
float |
%9.0g |
net income (loss)(restated) (mm$) |
| data178 |
float |
%9.0g |
operating income after deprec. (mm$) |
| data179 |
float |
%9.0g |
working capital (balance sheet) (mm$) |
| data180 |
float |
%9.0g |
working capital change - total(soc)(mm$) |
| data181 |
float |
%9.0g |
liabilities - total (mm$) |
| data182 |
float |
%9.0g |
ppe - beginning balance (sched v) (mm$) |
| data183 |
float |
%9.0g |
accounting changes - cum. effect (mm$) |
| data184 |
float |
%9.0g |
ppe - retirements (schedule v) (mm$) |
| data185 |
float |
%9.0g |
ppe - other changes (schedule v) (mm$) |
| data186 |
float |
%9.0g |
inventories - other (mm$) |
| data187 |
float |
%9.0g |
ppe - ending balance (schedule v)(mm$) |
| data188 |
float |
%9.0g |
debt - senior convertible (mm$) |
| data189 |
float |
%9.0g |
selling, general & admin. expenses (mm$) |
| data190 |
float |
%9.0g |
nonop. income (expense)- ex int inc(mm$) |
| data191 |
float |
%9.0g |
common stock equiv - dollar savings(mm$) |
| data192 |
float |
%9.0g |
extraordinary items (mm$) |
| data193 |
float |
%9.0g |
short-term investments (mm$) |
| data194 |
float |
%9.0g |
receivables - current - other (mm$) |
| data195 |
float |
%9.0g |
cur assets- other- ex prepaid expen(mm$) |
| data196 |
float |
%9.0g |
depr., depl. & amort. (accum.)(bs)(mm$) |
| data197 |
float |
%9.0g |
price -- fiscal year -- high ($&c) |
| data198 |
float |
%9.0g |
price -- fiscal year -- low ($&c) |
| data199 |
float |
%9.0g |
price -- fiscal year -- close ($&c) |
| data200 |
float |
%9.0g |
common shares reserved for conv- cd (mm) |
| data201 |
float |
%9.0g |
dividends per share - payable date ($&c) |
| data202 |
float |
%9.0g |
adjustment factor (cum) by payable date |
| data203 |
float |
%9.0g |
common shares reserved for conv- ps (mm) |
| data204 |
float |
%9.0g |
goodwill (mm$) |
| data205 |
float |
%9.0g |
assets- other- excl deferred charge(mm$) |
| data206 |
float |
%9.0g |
notes payable (mm$) |
| data207 |
float |
%9.0g |
cur. liab.- other- excl accrued exp(mm$) |
| data208 |
float |
%9.0g |
investment tax credit (balance sht)(mm$) |
| data209 |
float |
%9.0g |
preferred stock - nonredeemable (mm$) |
| data210 |
float |
%9.0g |
capital surplus (mm$) |
| data211 |
float |
%9.0g |
income taxes - other (mm$) |
| data213 |
float |
%9.0g |
sale of ppe & invest-loss(gain)...(mm$) |
| data214 |
float |
%9.0g |
preferred stock - convertible (mm$) |
| data215 |
float |
%9.0g |
common shares reserved for conv- so (mm) |
| data216 |
float |
%9.0g |
stockholders' equity - total (mm$) |
| data217 |
float |
%9.0g |
funds from operations - other(scf)(mm$) |
| data218 |
float |
%9.0g |
sources of funds - other (soc) (mm$) |
| data219 |
float |
%9.0g |
uses of funds - other (soc) (mm$) |
| data220 |
float |
%9.0g |
deprec. (accum.)- beg. balanace...(mm$) |
| data221 |
float |
%9.0g |
deprec. (accum.)- retirements... (mm$) |
| data222 |
float |
%9.0g |
deprec. (accum.)- other changes...(mm$) |
| data223 |
float |
%9.0g |
deprec. (accum)- ending balance...(mm$) |
| data224 |
float |
%9.0g |
nonoperating income (expense)(r) (mm$) |
| data225 |
float |
%9.0g |
minority interest (restated) (mm$) |
| data226 |
float |
%9.0g |
treasury stock (dollar amt)- common(mm$) |
| data227 |
float |
%9.0g |
treasury stock (dollar amt) - pref (mm$) |
| data228 |
float |
%9.0g |
currency translaton rate ($&c) |
| data229 |
float |
%9.0g |
com shares reserved for conv- war...(mm) |
| data230 |
float |
%9.0g |
retained earnings - cum. trans. adj(mm$) |
| data231 |
float |
%9.0g |
retained earnings - other adj. (mm$) |
| data232 |
float |
%9.0g |
common stock -- per share carry val($&c) |
| data233 |
float |
%9.0g |
earnings per share from operations ($&c) |
| data234 |
float |
%9.0g |
adr ratio |
| data235 |
float |
%9.0g |
common equity - liquidation value (mm$) |
| data236 |
float |
%9.0g |
working capital change- other... (mm$) |
| data237 |
float |
%9.0g |
income before ei- avail for common(mm$) |
| data238 |
float |
%9.0g |
marketable securities adj (bal sht)(mm$) |
| data239 |
float |
%9.0g |
interest capital- net income effect(mm$) |
| data240 |
float |
%9.0g |
inventories - lifo reserve (mm$) |
| data241 |
float |
%9.0g |
debt - mortgages and other secured (mm$) |
| data242 |
float |
%9.0g |
dividends - preferred - in arrears (mm$) |
| data243 |
float |
%9.0g |
pension benefits - pv of vested (mm$) |
| data244 |
float |
%9.0g |
pension benefits - pv of nonvested (mm$) |
| data245 |
float |
%9.0g |
pension benefits - net assets (mm$) |
| data246 |
float |
%9.0g |
pension benefits - assumed rate of ret. |
| data247 |
float |
%9.0g |
pension benefits - info date (mmddyy) |
| data248 |
float |
%9.0g |
acquisition - income contribution (mm$) |
| data249 |
float |
%9.0g |
acquisition - sales contribution (mm$) |
| data250 |
float |
%9.0g |
property, plant & equip-other(net)(mm$) |
| data251 |
float |
%9.0g |
deprec (accum)- land and improvemen(mm$) |
| data252 |
float |
%9.0g |
deprec. (accum) - natural resources(mm$) |
| data253 |
float |
%9.0g |
deprec. (accum) - buildings (mm$) |
| data254 |
float |
%9.0g |
deprec. (accum) - machinery & equip(mm$) |
| data255 |
float |
%9.0g |
depreciation (accumulated) - leases(mm$) |
| data256 |
float |
%9.0g |
deprec. (accum) - construct in prog(mm$) |
| data257 |
float |
%9.0g |
depreciation (accumulated) - other (mm$) |
| data258 |
float |
%9.0g |
net income- adj for com stock equiv(mm$) |
| data259 |
float |
%9.0g |
retained earnings - unadjusted (mm$) |
| data260 |
float |
%9.0g |
ppe - land and improvements at cost(mm$) |
| data261 |
float |
%9.0g |
ppe - natural resources at cost (mm$) |
| data263 |
float |
%9.0g |
ppe - buildings at cost (mm$) |
| data264 |
float |
%9.0g |
ppe - machinery & equipment at cost(mm$) |
| data265 |
float |
%9.0g |
ppe - leases at cost (mm$) |
| data266 |
float |
%9.0g |
ppe - construct in progress at cost(mm$) |
| data267 |
float |
%9.0g |
ppe - other at cost (mm$) |
| data268 |
float |
%9.0g |
debt - unamortized debt discount...(mm$) |
| data269 |
float |
%9.0g |
deferred taxes - federal (mm$) |
| data270 |
float |
%9.0g |
deferred taxes - foreign (mm$) |
| data271 |
float |
%9.0g |
deferred taxes - state (mm$) |
| data272 |
float |
%9.0g |
pretax income - domestic (mm$) |
| data273 |
float |
%9.0g |
pretax income - foreign (mm$) |
| data274 |
float |
%9.0g |
cash & cash equiv- increase(dec)...(mm$) |
| data276 |
float |
%9.0g |
s&p major index code - historical |
| data277 |
int |
%8.0g |
s&p industry index code - historical |
| data278 |
float |
%9.0g |
fortune industry code |
| data279 |
int |
%8.0g |
fortune rank |
| data280 |
byte |
%8.0g |
s&p lt domestic issuer credit rating |
| data282 |
byte |
%8.0g |
s&p common stock ranking |
| data283 |
int |
%8.0g |
s&p st dom. issuer credit rating- hist |
| data284 |
float |
%9.0g |
pension- vested benefit obl.(ovfnd)(mm$) |
| data285 |
float |
%9.0g |
pension- accum benefit obl. (ovfnd)(mm$) |
| data286 |
float |
%9.0g |
pension- projectd benefit ob(ovfnd)(mm$) |
| data287 |
float |
%9.0g |
pension plan assets (overfunded) (mm$) |
| data288 |
float |
%9.0g |
pension- unrec. prior serv..(ovfnd)(mm$) |
| data289 |
float |
%9.0g |
pension - other adj. (overfunded) (mm$) |
| data290 |
float |
%9.0g |
pension- prepaid/accrued cos(ovfnd)(mm$) |
| data291 |
float |
%9.0g |
pension- vested benefit obl.(unfnd)(mm$) |
| data292 |
float |
%9.0g |
periodic postretirement benefit cos(mm$) |
| data293 |
float |
%9.0g |
pension- accum benefit oblig(unfnd)(mm$) |
| data294 |
float |
%9.0g |
pension- projectd benefit ob(unfnd)(mm$) |
| data295 |
float |
%9.0g |
periodic pension cost (net) (mm$) |
| data296 |
float |
%9.0g |
pension plan assets (underfunded) (mm$) |
| data297 |
float |
%9.0g |
pension- unrec prior sv cost(unfnd)(mm$) |
| data298 |
float |
%9.0g |
pension- addl min. liability(unfnd)(mm$) |
| data299 |
float |
%9.0g |
pension - other adj. (underfunded) (mm$) |
| data300 |
float |
%9.0g |
pension- prepaid/accrued cos(unfnd)(mm$) |
| data301 |
float |
%9.0g |
changes in current debt (scf) (mm$) |
| data302 |
float |
%9.0g |
accounts receivable- dec(inc)(scf)(mm$) |
| data303 |
float |
%9.0g |
inventory - decrease(incr.) (socf)(mm$) |
| data304 |
float |
%9.0g |
accts payable & accrued liab inc...(mm$) |
| data305 |
float |
%9.0g |
income taxes- accrued - inc(dec)...(mm$) |
| data307 |
float |
%9.0g |
assets & liab- other(net chg)(socf)(mm$) |
| data308 |
float |
%9.0g |
operating activities- net cf (socf)(mm$) |
| data309 |
float |
%9.0g |
short-term invest. - change (socf) (mm$) |
| data310 |
float |
%9.0g |
investing activities - other (socf)(mm$) |
| data311 |
float |
%9.0g |
investing activities- net cf (socf)(mm$) |
| data312 |
float |
%9.0g |
financing activities - other (socf)(mm$) |
| data313 |
float |
%9.0g |
financing activities- net cf (socf)(mm$) |
| data314 |
float |
%9.0g |
exchange rate effect (socf)(mm$) |
| data315 |
float |
%9.0g |
interest paid - net (socf) (mm$) |
| data317 |
float |
%9.0g |
income taxes paid (socf) (mm$) |
| data318 |
byte |
%8.0g |
format code (statement of cash flows) |
| data319 |
float |
%9.0g |
dilution adjustment |
| data320 |
byte |
%8.0g |
s&p subordinated debt rating |
| data321 |
float |
%9.0g |
interest income - total (fin serv)(mm$) |
| data322 |
float |
%9.0g |
diluted available - excl |
| data323 |
float |
%9.0g |
diluted eps from operations |
| data324 |
int |
%8.0g |
historical sic code |
| data327 |
float |
%9.0g |
contingent liab. - guarantees (mm$) |
| data328 |
float |
%9.0g |
debt - finance subsidiary (mm$) |
| data329 |
float |
%9.0g |
debt - consolidated subsidiary (mm$) |
| data330 |
float |
%9.0g |
postretirement benefit asset(liab)(mm$) |
| data331 |
float |
%9.0g |
pension plans - service cost (mm$) |
| data332 |
float |
%9.0g |
pension plans - interest cost (mm$) |
| data333 |
float |
%9.0g |
pension plans- return on plan asset(mm$) |
| data334 |
float |
%9.0g |
pension plans- other periodic cc...(mm$) |
| data335 |
float |
%9.0g |
pension plans- rate of compen. increase |
| data336 |
float |
%9.0g |
pension plans- anticipat lt ror on pa(%) |
| data337 |
float |
%9.0g |
risk-adjusted capital ratio - tier i |
| data339 |
float |
%9.0g |
interest expense -- total(fin serv)(mm$) |
| data340 |
float |
%9.0g |
net interest income(tax equivalent)(mm$) |
| data341 |
float |
%9.0g |
nonperforming assets -- total (mm$) |
| data342 |
float |
%9.0g |
provision for loan/asset losses (mm$) |
| data343 |
float |
%9.0g |
reserve for loan/asset losses (mm$) |
| data344 |
float |
%9.0g |
net interest margin |
| data348 |
float |
%9.0g |
risk-adjusted capital ratio -- total |
| data349 |
float |
%9.0g |
net charge-offs (mm$) |
| coname |
str28 |
%28s |
company name |
| iname |
str28 |
%28s |
industry name |
| gvkey |
long |
%12.0g |
spc permanent number |
| yeara |
int |
%8.0g |
fiscal year |