AnsweredAssumed Answered

Reading company holidays from base calendars

Question asked by MangeshGohad on Feb 25, 2013
Latest reply on Feb 26, 2013 by another_martink
Hi All,

I want to read all company holidays marked in a particular base calendar through SQL query.

I am able to read it from individual resource calendars, but I want to read it from base calendars, as there is no way to distinguish company holidays from resource PTO in resource calendars through SQL.

I guess, this data is stored in column PRVALUE (which holds a BLOB value) in PRCALENDAR. However, I am not sure which slice does this data get stored into.

Any help in this regard is greatly appreacited.

Outcomes