topic RE: Database Tables - BPAPublicHoliday in Product Forum

Database Tables - BPAPublicHoliday

AbhijithB_S — Thu, 10 Sep 2020 06:10:00 GMT

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
------------------------------

RE: Database Tables - BPAPublicHoliday

james.man — Fri, 11 Sep 2020 01:25:00 GMT

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
------------------------------

RE: Database Tables - BPAPublicHoliday

roberto.campione — Fri, 29 Jan 2021 11:45:00 GMT

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
------------------------------