database REFINITIV_QAC_DB table TRESumPer column PerType - how do i map to a type description

barry.chapman

Hi, i am using Snowflake to select from the TRESumPer table, in the where clause there is a clause "where PerType = 4".

I can't find any documentation that states what the foreign key would be for that item. I need to find a mapping from "4" to a description (Annual?), so that I can also select other periods (I don't know what the PerType for Semi-Annual is).

Can you show me where in the documentation the PerTyp is defined (eg 4 = Annual etc).

Thanks,

Barry.

Jirapongse

@barry.chapman

Thank you for reaching out to us.

I found the definitions of the TRESumPer table in the Quantitative Analytics Database Schema - I/B/E/S Estimates Version 2 document under the LSEG Quantitative Analytics product.

According to the document, the PerType values are defined in the TRECode table with (CodeType=2).

barry.chapman

Thanks!