DET_GUIDANCE
Column Name Label
TICKER I/B/E/S ticker
PDICITY Periodicity (e.g. ANN, QTR)
MEASURE Measure (data type indicator)
CURR ISO 3-digit currency code
UNITS Units of guidance values
RANGE_DESC Guidance Range
DIFF_CODE Difference reason (e.g. asset writedown)
ACT_STD Accounting standard (e.g. US GAAP)
ACTION Action by TR (e.g. split adjusted)
GUIDANCE_CODE Guidance relative to consensus (e.g. beat, match)
ACTDATS Activation date when data was captured by TR
ANNDATS Announce date when data was announced by the company
MOD_DATE Modified date when data was modified by TR
ACTTIMS Activation time when data was captured by TR
ANNTIMS Announce time when data was announced by the company
MOD_TIME Modified time when data was modified by TR
PRD_YR Calendar year
PRD_MON Calendar month
EEFYMO Earnings estimates fiscal year end month (e.g. 12=December )
VAL_1 Guidance value if given
VAL_2 Upper value of guidance value range if given
MEAN_AT_DATE Analyst Estimate Consensus (mean)
Column Name Label
Name: ACT_EPSINT
I/B/E/S Detail History - Actuals File (EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
PENDS Period End Date, SAS Format
MEASURE Measure Data Type Indicator
PDICITY Periodicity
ANNDATS Announce Date
ANNTIMS Announce time
ACTDATS Activation Date
ACTTIMS Activation time
VALUE Actual Value
CURR_ACT Currency (Company Level)
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
Name: ACT_EPSUS
Description: I/B/E/S Detail History - Actuals File (EPS for US Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
PENDS Period End Date, SAS Format
MEASURE Measure Data Type Indicator
PDICITY Periodicity
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
ACTDATS Activation Date, SAS Format
ACTTIMS Activation time, SAS Format
VALUE Actual Value
CURR_ACT Currency (Company Level)
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
Name: ACT_XEPSINT
Description: I/B/E/S Detail History - Actuals File (Non-EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
PENDS Period End Date, SAS Format
MEASURE Measure Data Type Indicator
PDICITY Periodicity
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
ACTDATS Activation Date, SAS Format
ACTTIMS Activation time, SAS Format
VALUE Actual Value
CURR_ACT Currency (Company Level)
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
Name: ACT_XEPSUS
Description: I/B/E/S Detail History - Actuals File (Non-EPS for US Region)
Column Name Label
ACTDATS Activation Date, SAS Format
ACTTIMS Activation time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
CNAME Company Name
CURR_ACT Currency (Company Level)
CUSIP CUSIP/SEDOL
MEASURE Measure Data Type Indicator
OFTIC Official Ticker Symbol
PDICITY Periodicity
PENDS Period End Date, SAS Format
TICKER IBES Ticker Symbol
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
VALUE Actual Value
Name: ACTG
Description: I/B/E/S - Go - Forward Actuals File
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
PENDS Period End Date, SAS Format
MEASURE Measure Data Type Indicator
PDICITY Periodicity
VALUE Actual Value
CURR_ACT Currency (Company Level)
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
ACTDATS
ANNDATS Announce Date, SAS Format
ACTTIMS
ANNTIMS Announce time, SAS Format
Name: ACTGU
Description: I/B/E/S - Go - Forward Unadjusted Actuals File
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
PENDS Period End Date, SAS Format
MEASURE Measure Data Type Indicator
PDICITY Periodicity
VALUE Actual Value
CURR_ACT Currency (Company Level)
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
ACTDATS
ANNDATS Announce Date, SAS Format
ACTTIMS
ANNTIMS Announce time, SAS Format
Name: ACTPSUM_EPSINT
Description: I/B/E/S Summary History - Actuals + Pricing and Ancillary File (EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS IBES Statistical Period, SAS Format
MEASURE Measure Data Type Indicator
FY0A Fiscal Year 0 Actual Value of the Measure
CURCODE Summary Actual Currency Code
FVYRGRO 5 Year Growth of the Measure
FVYRSTA 5 Year Stability of the Measure
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FY0EDATS Fiscal Year 0 End Date, SAS Format
INT0A Interim 0 Actual Value of the Measure
INT0DATS Interim 0 Date, SAS Format
PRICE Price
PRDAYS Pricing Date, SAS Format
SHOUT Shares Outstanding: in millions
IADIV Indicated Annual Dividend
CURR_PRICE Pricing Currency Code
Name: ACTPSUM_XEPSINT
Description: I/B/E/S Summary History - Actuals + Pricing and Ancillary File (Non-EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS IBES Statistical Period, SAS Format
MEASURE Measure Data Type Indicator
FY0A Fiscal Year 0 Actual Value of the Measure
CURCODE Summary Actual Currency Code
FVYRGRO 5 Year Growth of the Measure
FVYRSTA 5 Year Stability of the Measure
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FY0EDATS Fiscal Year 0 End Date, SAS Format
INT0A Interim 0 Actual Value of the Measure
INT0DATS Interim 0 Date, SAS Format
PRICE Price
PRDAYS Pricing Date, SAS Format
SHOUT Shares Outstanding: in millions
IADIV Indicated Annual Dividend
CURR_PRICE Pricing Currency Code
Name: ACTPSUMU_XEPSUS
Description: I/B/E/S Summary Actuals + Pricing and Ancillary Unadjusted File (Non-EPS for US Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS IBES Statistical Period, SAS Format
MEASURE Measure Data Type Indicator
FY0A Fiscal Year 0 Actual Value of the Measure
CURCODE Summary Actual Currency Code
FVYRGRO 5 Year Growth of the Measure
FVYRSTA 5 Year Stability of the Measure
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FY0EDATS Fiscal Year 0 End Date, SAS Format
INT0A Interim 0 Actual Value of the Measure
INT0DATS Interim 0 Date, SAS Format
PRICE Price
PRDAYS Pricing Date, SAS Format
SHOUT Shares Outstanding: in millions
IADIV Indicated Annual Dividend
CURR_PRICE Pricing Currency Code
Name: ACTU_EPSINT
Description: I/B/E/S Detail History - Actuals Unadjusted File (EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
PENDS Period End Date, SAS Format
MEASURE Measure Data Type Indicator
PDICITY Periodicity
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
ACTDATS Activation Date, SAS Format
ACTTIMS Activation time, SAS Format
VALUE Actual Value
CURR_ACT Currency (Company Level)
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
Name: ACTU_XEPSINT
Description: I/B/E/S Detail History - Actuals Unadjusted File (Non-EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
PENDS Period End Date, SAS Format
MEASURE Measure Data Type Indicator
PDICITY Periodicity
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
ACTDATS Activation Date, SAS Format
ACTTIMS Activation time, SAS Format
VALUE Actual Value
CURR_ACT Currency (Company Level)
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
Name: ADJ
Description: I/B/E/S Detail History - Adjustments File
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
SPDATES Effective Split Date, SAS Format
ADJ Adjustment Factor
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
Name: ADJSUM
Description: I/B/E/S Summary History - Adjustment Factors
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS I/B/E/S Statistical Period, SAS Format
ADJSPF Adjustment/Split Factor
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
Name: CFNSUM
Description: I/B/E/S Summary History - Company Level Footnote File
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ENTDATS Entry Date, SAS Format
FNTYPE Footnote type
FNTEXT Footnote text
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
ENTTIMS Entry Time, SAS Format
EXPDATS Expiration Date, SAS Format
Name: CURR
Description: I/B/E/S Detail History - Report Currency File
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
SDATES Start Date, SAS Format
CURR Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
Name: DET_EPSINT
Description: I/B/E/S Detail History - Detail File with Actuals (EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
CURRFL Canadian Currency Flag (Estimate Level)
PDF Primary/Diluted Flag (Estimate Level)
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
REVDATS Review Date, SAS Format
REVTIMS Review Time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
ACTUAL Actual Value, from the Detail Actuals File
ACTDATS_ACT Activation date of the Actual, from the Actuals File
ACTTIMS_ACT Activation time of the Actual, from the Actuals File
ANNDATS_ACT Announce date of the Actual, from the Actuals File
ANNTIMS_ACT Announce time of the Actual, from the Actuals File
CURR_ACT Currency from the Detail Actuals file
REPORT_CURR Report Currency
Name: DET_EPSUS
Description: I/B/E/S Detail History - Detail File with Actuals (EPS for US Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
CURRFL Canadian Currency Flag (Estimate Level)
PDF Primary/Diluted Flag (Estimate Level)
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
REVDATS Review Date, SAS Format
REVTIMS Review Time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
ACTUAL Actual Value, from the Detail Actuals File
ACTDATS_ACT Activation date of the Actual, from the Actuals File
ACTTIMS_ACT Activation time of the Actual, from the Actuals File
ANNDATS_ACT Announce date of the Actual, from the Actuals File
ANNTIMS_ACT Announce time of the Actual, from the Actuals File
CURR_ACT Currency from the Detail Actuals file
REPORT_CURR Report Currency
Name: DET_XEPSINT
Description: I/B/E/S Detail History - Detail File with Actuals (Non-EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
CURRFL Canadian Currency Flag (Estimate Level)
PDF Primary/Diluted Flag (Estimate Level)
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
REVDATS Review Date, SAS Format
REVTIMS Review Time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
ACTUAL Actual Value, from the Detail Actuals File
ACTDATS_ACT Activation date of the Actual, from the Actuals File
ACTTIMS_ACT Activation time of the Actual, from the Actuals File
ANNDATS_ACT Announce date of the Actual, from the Actuals File
ANNTIMS_ACT Announce time of the Actual, from the Actuals File
CURR_ACT Currency from the Detail Actuals file
REPORT_CURR Report Currency
Name: DET_XEPSUS
Description: I/B/E/S Detail History - Detail File with Actuals (Non-EPS for US Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
CURRFL Canadian Currency Flag (Estimate Level)
PDF Primary/Diluted Flag (Estimate Level)
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
REVDATS Review Date, SAS Format
REVTIMS Review Time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
ACTUAL Actual Value, from the Detail Actuals File
ACTDATS_ACT Activation date of the Actual, from the Actuals File
ACTTIMS_ACT Activation time of the Actual, from the Actuals File
ANNDATS_ACT Announce date of the Actual, from the Actuals File
ANNTIMS_ACT Announce time of the Actual, from the Actuals File
CURR_ACT Currency from the Detail Actuals file
REPORT_CURR Report Currency
Name: DETSECD_SEPINT
Description: I/B/E/S Detail History - SEP Detail File (Secondary Measure)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
CURRFL Canadian Currency Flag (Estimate Level)
PDF Primary/Diluted Flag (Estimate Level)
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
REVDATS Review Date, SAS Format
REVTIMS Review Time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
Name: DETSECD_XSEPINT
Description: I/B/E/S Detail History - NON-SEP Detail File (Secondary Measure)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
CURRFL Canadian Currency Flag (Estimate Level)
PDF Primary/Diluted Flag (Estimate Level)
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
REVDATS Review Date, SAS Format
REVTIMS Review Time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
Name: DETU_EPSINT
Description: I/B/E/S Detail History - Unadjusted (EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
CURRFL Canadian Currency Flag (Estimate Level)
PDF Primary/Diluted Flag (Estimate Level)
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
REVDATS Review Date, SAS Format
REVTIMS Review Time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
REPORT_CURR Report Currency
Name: DETU_EPSUS
Description: I/B/E/S Detail History - Unadjusted (EPS for US Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
CURRFL Canadian Currency Flag (Estimate Level)
PDF Primary/Diluted Flag (Estimate Level)
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
REVDATS Review Date, SAS Format
REVTIMS Review Time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
REPORT_CURR Report Currency
Name: DETU_XEPSINT
Description: I/B/E/S Detail History - Unadjusted (Non-EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
CURRFL Canadian Currency Flag (Estimate Level)
PDF Primary/Diluted Flag (Estimate Level)
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
REVDATS Review Date, SAS Format
REVTIMS Review Time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
REPORT_CURR Report Currency
Name: DETU_XEPSUS
Description: I/B/E/S Detail History - Unadjusted (Non-EPS for US Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
CURRFL Canadian Currency Flag (Estimate Level)
PDF Primary/Diluted Flag (Estimate Level)
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
REVDATS Review Date, SAS Format
REVTIMS Review Time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
REPORT_CURR Report Currency
Name: DETUSECD_SEPINT
Description: I/B/E/S Detail History - Unadjusted SEP Detail File (Secondary Measure)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
CURRFL Canadian Currency Flag (Estimate Level)
PDF Primary/Diluted Flag (Estimate Level)
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
REVDATS Review Date, SAS Format
REVTIMS Review Time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
Name: DETUSECD_XSEPINT
Description: I/B/E/S Detail History - Unadjusted NON-SEP Detail File (Secondary Measure)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
CURRFL Canadian Currency Flag (Estimate Level)
PDF Primary/Diluted Flag (Estimate Level)
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
REVDATS Review Date, SAS Format
REVTIMS Review Time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce time, SAS Format
Name: EURX
Description: I/B/E/S Summary History - EURO Exchange Rate File
Column Name Label
CURCODEF Currency Code From
CURCODET Currency Code To
EXCHRATE Exchange Rate
SDATES Start Date, SAS Format
Name: EXC_EPSINT
Description: I/B/E/S Detail History - Excluded Estimates File (EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
EXCFLA Exclude Flag
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
CURR Currency
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
EXCDATS Exclude Date, SAS Format
EXCTIMS Exclude Time, SAS Format
EXCENDS Exclude End Date, SAS Format
EXCETIMS Exclude End Time, SAS Format
Name: EXCU_XEPSUS
Description: I/B/E/S Detail History - Excluded Estimates Unadjusted File (Non-EPS for US Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
EXCFLA Exclude Flag
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
CURR Currency
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
EXCDATS Exclude Date, SAS Format
EXCTIMS Exclude Time, SAS Format
EXCENDS Exclude End Date, SAS Format
EXCETIMS Exclude End Time, SAS Format
Name: EXCUSECD_SEPINT
Description: I/B/E/S Detail History - Unadjusted SEP Excluded Estimates File
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
EXCFLA Exclude Flag
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
EXCDATS Exclude Date, SAS Format
EXCTIMS Exclude Time, SAS Format
EXCENDS Exclude End Date, SAS Format
EXCETIMS Exclude End Time, SAS Format
Name: EXCUSECD_XSEPINT
Description: I/B/E/S Detail History - Unadjusted NON-SEP Excluded Estimates File
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
ACTDATS Activation Date, SAS Format
ESTIMATOR Contributing estimator code
ANALYS Analyst Code
FPI Forecast Period Indicator
MEASURE Measure (Data Type Indicator)
VALUE Estimate Value
CURR Currency
EXCFLA Exclude Flag
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date, SAS Format
ACTTIMS Activation Time, SAS Format
EXCDATS Exclude Date, SAS Format
EXCTIMS Exclude Time, SAS Format
EXCENDS Exclude End Date, SAS Format
EXCETIMS Exclude End Time, SAS Format
Name: NRACTU_XEPSUS
Description: I/B/E/S Detail History Unadjusted- Normalized Restated Actuals Unadjusted File (Non-EPS for US Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
PENDS Period End Date, SAS Format
MEASURE Measure (Data Type Indicator)
PDICITY Periodicity
VALUE Value
CURR Company Level Currency
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
ACTDATS Activation Date, SAS Format
ACTTIMS Activation Time, SAS Format
ANNDATS Announce Date, SAS Format
ANNTIMS Announce Time, SAS Format
Name: NSECDSSUM
Description: I/B/E/S Summary History - Normalized Summary Statistics (2nd Mean)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS I/B/E/S Statistical Period (SAS Format)
MEASURE Measure
FISCALP Periodicity
FPI Forecast Period Indicator
ESTFLAG Estimate Flag (P=Primary, S=Secondary)
CURCODE Currency Code
NUMEST Number of Estimates
MEANEST Mean Estimate
STDEV Standard Deviation
HIGHEST High Estimate
LOWEST Low Estimate
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date (SAS Format)
Name: NSECDSSUMU
Description: I/B/E/S Summary History Unadjusted - Normalized Unadjusted Summary Statistics (2nd Mean)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS I/B/E/S Statistical Period (SAS Format)
MEASURE Measure
FISCALP Periodicity
FPI Forecast Period Indicator
ESTFLAG Estimate Flag (P=Primary, S=Secondary)
CURCODE Currency Code
NUMEST Number of Estimates
MEANEST Mean Estimate
STDEV Standard Deviation
HIGHEST High Estimate
LOWEST Low Estimate
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date (SAS Format)
Name: NSTATSUM_EPSINT
Description: I/B/E/S Summary History - Normalized Summary Statistics with Actuals (EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS I/B/E/S Statistical Period (SAS Format)
MEASURE Measure
FISCALP Periodicity
FPI Forecast Period Indicator
ESTFLAG Estimate Flag (P=Primary, S=Secondary)
CURCODE Currency Code
NUMEST Number of Estimates
NUMUP Number Up
NUMDOWN Number Down
MEDEST Median Estimate
MEANEST Mean Estimate
STDEV Standard Deviation
HIGHEST High Estimate
LOWEST Low Estimate
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date (SAS Format)
ACTUAL Actual Value
ACTDATS_ACT Activation date of the Actual (from the Normalized Actuals File)
ACTTIMS_ACT Activation time of the Actual (from the Normalized Actuals File)
ANNDATS_ACT Announce date of the Actual (from Normalized Actual File)
ANNTIMS_ACT Announce time of the Actual (from Normalized Actual File)
CURR_ACT Currency from Normalized Actual file
Name: NSTATSUM_EPSUS
Description: I/B/E/S Summary History - Normalized Summary Statistics with Actuals (EPS for US Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS I/B/E/S Statistical Period (SAS Format)
MEASURE Measure
FISCALP Periodicity
FPI Forecast Period Indicator
ESTFLAG Estimate Flag (P=Primary, S=Secondary)
CURCODE Currency Code
NUMEST Number of Estimates
NUMUP Number Up
NUMDOWN Number Down
MEDEST Median Estimate
MEANEST Mean Estimate
STDEV Standard Deviation
HIGHEST High Estimate
LOWEST Low Estimate
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date (SAS Format)
ACTUAL Actual Value
ACTDATS_ACT Activation date of the Actual (from the Normalized Actuals File)
ACTTIMS_ACT Activation time of the Actual (from the Normalized Actuals File)
ANNDATS_ACT Announce date of the Actual (from Normalized Actual File)
ANNTIMS_ACT Announce time of the Actual (from Normalized Actual File)
CURR_ACT Currency from Normalized Actual file
Name: NSTATSUM_XEPSINT
Description: I/B/E/S Summary History - Normalized Summary Statistics with Actuals (Non-EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS I/B/E/S Statistical Period (SAS Format)
MEASURE Measure
FISCALP Periodicity
FPI Forecast Period Indicator
ESTFLAG Estimate Flag (P=Primary, S=Secondary)
CURCODE Currency Code
NUMEST Number of Estimates
NUMUP Number Up
NUMDOWN Number Down
MEDEST Median Estimate
MEANEST Mean Estimate
STDEV Standard Deviation
HIGHEST High Estimate
LOWEST Low Estimate
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date (SAS Format)
ACTUAL Actual Value
ACTDATS_ACT Activation date of the Actual (from the Normalized Actuals File)
ACTTIMS_ACT Activation time of the Actual (from the Normalized Actuals File)
ANNDATS_ACT Announce date of the Actual (from Normalized Actual File)
ANNTIMS_ACT Announce time of the Actual (from Normalized Actual File)
CURR_ACT Currency from Normalized Actual file
Name: NSTATSUM_XEPSUS
Description: I/B/E/S Summary History - Normalized Summary Statistics with Actuals (Non-EPS for US Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS I/B/E/S Statistical Period (SAS Format)
MEASURE Measure
FISCALP Periodicity
FPI Forecast Period Indicator
ESTFLAG Estimate Flag (P=Primary, S=Secondary)
CURCODE Currency Code
NUMEST Number of Estimates
NUMUP Number Up
NUMDOWN Number Down
MEDEST Median Estimate
MEANEST Mean Estimate
STDEV Standard Deviation
HIGHEST High Estimate
LOWEST Low Estimate
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date (SAS Format)
ACTUAL Actual Value
ACTDATS_ACT Activation date of the Actual (from the Normalized Actuals File)
ACTTIMS_ACT Activation time of the Actual (from the Normalized Actuals File)
ANNDATS_ACT Announce date of the Actual (from Normalized Actual File)
ANNTIMS_ACT Announce time of the Actual (from Normalized Actual File)
CURR_ACT Currency from Normalized Actual file
Name: NSTATSUMU_EPSINT
Description: I/B/E/S Summary History - Normalized Unadjusted Summary Statistics (EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS I/B/E/S Statistical Period (SAS Format)
MEASURE Measure
FISCALP Periodicity
FPI Forecast Period Indicator
ESTFLAG Estimate Flag (P=Primary, S=Secondary)
CURCODE Currency Code
NUMEST Number of Estimates
NUMUP Number Up
NUMDOWN Number Down
MEDEST Median Estimate
MEANEST Mean Estimate
STDEV Standard Deviation
HIGHEST High Estimate
LOWEST Low Estimate
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date (SAS Format)
Name: NSTATSUMU_EPSUS
Description: I/B/E/S Summary History - Normalized Unadjusted Summary Statistics (EPS for US Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS I/B/E/S Statistical Period (SAS Format)
MEASURE Measure
FISCALP Periodicity
FPI Forecast Period Indicator
ESTFLAG Estimate Flag (P=Primary, S=Secondary)
CURCODE Currency Code
NUMEST Number of Estimates
NUMUP Number Up
NUMDOWN Number Down
MEDEST Median Estimate
MEANEST Mean Estimate
STDEV Standard Deviation
HIGHEST High Estimate
LOWEST Low Estimate
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date (SAS Format)
Name: NSTATSUMU_XEPSINT
Description: I/B/E/S Summary History - Normalized Unadjusted Summary Statistics (Non-EPS for International Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS I/B/E/S Statistical Period (SAS Format)
MEASURE Measure
FISCALP Periodicity
FPI Forecast Period Indicator
ESTFLAG Estimate Flag (P=Primary, S=Secondary)
CURCODE Currency Code
NUMEST Number of Estimates
NUMUP Number Up
NUMDOWN Number Down
MEDEST Median Estimate
MEANEST Mean Estimate
STDEV Standard Deviation
HIGHEST High Estimate
LOWEST Low Estimate
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date (SAS Format)
Name: NSTATSUMU_XEPSUS
Description: I/B/E/S Summary History - Normalized Unadjusted Summary Statistics (Non-EPS for US Region)
Column Name Label
TICKER IBES Ticker Symbol
CUSIP CUSIP/SEDOL
OFTIC Official Ticker Symbol
CNAME Company Name
STATPERS I/B/E/S Statistical Period (SAS Format)
MEASURE Measure
FISCALP Periodicity
FPI Forecast Period Indicator
ESTFLAG Estimate Flag (P=Primary, S=Secondary)
CURCODE Currency Code
NUMEST Number of Estimates
NUMUP Number Up
NUMDOWN Number Down
MEDEST Median Estimate
MEANEST Mean Estimate
STDEV Standard Deviation
HIGHEST High Estimate
LOWEST Low Estimate
USFIRM USFIRM=0 if from .INT file and USFIRM=1 if from .US file
FPEDATS Forecast Period End Date (SAS Format)