story points in current_dw.story

[Raj]

Hi, We are using jira align for the initiatives but the epics and stories get synched or refreshed from the jira system - unfortunately, i do not see the story points column or the field in current_dw schema view story

could anyone please advise where would be the story points of any given story within the jira align database

[Francois Panaget · Accepted solution]

Hi Raj,

In the Jira Align Enterprise Insight schema definition, the current_dw schema view for the story holds the Story point information in the Level of Effort column.

Here is an extract of the schema definition:

I hope this will help you.

Thank you and Regards, François

[Raj]

Thank you so much. It is really helpful

[Jamie Giantonio]

@Raj in the api, for stories the points field synched with Jira is effortPoints. Hope this helps