Table name of Std & Ext Calendar

[zeeshank]

Hi,

 

Can someone help me to identify the calendar table in DB.

 

Whether AEDBADMIN.ujo_calendar will store both Standard & Extended calendars? If so how can we pull the dates of standard or extended calendar from DB with string of calendar name like Shared_std & Shared_ext?

#calendar #aedb

Regards,

Zeeshan

[Roya Phamgia-Piroux]

Hello,

 

The "ujo_calendar" table contains a list of the dates for each calendar. 

This table contains the following columns:
■ name
■ cal_id
■ day

 

The "ujo_ext_calendar" table stores extended calendar definitions.
This table contains the following columns:
■ name
■ cal_id
■ as_work
■ as_holcal
■ as_cyccal
■ as_hact
■ as_nwact
■ as_adj
■ as_datecon

 

You can consult these tables for information.

 

But the manual "update" of AEDB tables is Not recommended nor supported.

 

I hope this can help.

 

Thanks,

Roya