Database Tables - BPAPublicHoliday

[AbhijithB_S]

Hi All,

I would like to know more about the database table BPAPublicHoliday. More specifically, I would like to understand the columns and their meaning of the said table.
Looking forward to making use of this table in custom reports.

Thanks,
Abhijith B S.

------------------------------
Abhijith B S
Automation Architect
Ericsson
Bangalore, India
------------------------------

[james.man]

If would help if you could let us know which columns you want more details on.  But some of the less straightforward columns are:

dayofweek: 0=Sunday, 6=Saturday
nthofmonth: The occurrence within the month of the holiday: 1=First, 2=Second etc. Special case: -1 = Last
relativetoholiday: Set to the ID of the holiday that this holiday is relative to, NULL if it is not relative to another holiday (use with the column below)
relativedaydiff: The number of days offset from the holiday that this holiday is relative to. eg. Boxing Day is Xmas Day + 1 day
eastersunday: Bit indicating that this holiday represents easter sunday - created primarily to allow dates relative to Easter Sunday to be specified

------------------------------
James Man
Professional Services
Blue Prism
Asia/Hong_Kong
------------------------------

[RobertoCampione]

Hello James, I found this post, searching for information about the new columns introduced with one of the last versions of Blue Prism. The new columns are "shiftdaytype" and "relativedayofweek" both part of the BPAPublicHoliday table. I am trying to set a new Calendar with the Belgium Holiday days. Attached you can find the query I created, but I am not 100% sure about these 2 new columns' setting. Can you help me with it? Thank you, Roberto https://higherlogicdownload.s3.amazonaws.com/BLUEPRISM/UploadedImages/c381e545-75f1-4270-9e46-c762cb5a0984/BelgiumCalendarSetup.txt

------------------------------
Roberto Campione
Computer Engineer
Accenture
Europe/Amsterdam
------------------------------