ACTUALS
What table will show who updated the Go-forward actual value?
act_goforward_a
Provide 2 tables that can be used to show who processed the document.
analyzer_queue; analyzer_queue_h; est_official_source_a
What table can you use to check for changes in the error correction screen?
est_official_ercor
What table can be used to determine if the ticker is active?
Is this the correct syntax?
select top 1 distinct ibes_tkr
from prod..act_official with (nolock)
No, the correct syntax would be:
select distinct top 1 ibes_tkr
from prod..act_official with (nolock)
What column name does the ticker column have?
select distinct top 10 estimator as 'ticker', ibes_tkr as 'estimator', prd_yr as 'fiscal_yr'
from prod..est_official with (nolock)
estimator
If retrieving for negative values what expression can I use in the where statement?
where val < 0
Fill in the quote:
"The best practice for creating queries is _______ the result or answer you want to see."
visualizing
If username is NULL in the actual queue, what does it mean?
The line is yet to be locked.
What datatype is used when users use the comment function in the Queue screen?
Varchar/Variable character
If there are multiple audit users in an audit table what column and arrangement do I use to get the recent change?
audit_time desc
What is the research report date? Announce date or Add date
Announce date
How many EPS actuals were updated for the ticker MSFT since 2017?
8 (3 are restatements)
How many revisions does AAPL have for the measure TOL under JPMORGAN for the year 2025?
10
How many instances are there where ROE is negative but SHE is positive for the same year? Use only ANN periodicity - 2023.
157
How many tickers ending with the letter T are active?
1536
Calculate ROE using the arithmetic function in SQL for the ticker AAPL for the year 2023 for all interims.
AAPL 2023 QTR 6 60274 19881 32.98
AAPL 2023 QTR 12 74100 33916 45.77
AAPL 2023 QTR 3 62158 24160 38.87
AAPL 2023 QTR 9 62146 22956 36.94
AAPL 2023 ANN 9 62146 96995 156.08
Retrieve the 2023 ANN Sales Mean for the ticker LSEG. Only retrieve for the first revision excluding STOPPED values.
8155.11
Retrieve instances where Annual GRM exceeds the calculated value of GRI/SAL for the year 2024.
37700 without any defined percentage difference
Retrieve at least 10 tickers with active coverage starting with the letter A. Provide the active coverage for each ticker.
ibes_tkr coverage
AA 28
AA05 3
AA07 1
AA09 2
AA0T 3
AA0V 4
AA10 1
AA11 3
AA1I 1
AA1N 12