|
A newly created calendar is empty, meaning that the work days have not been computed. You will need to initialise a calendar where it generated the workdays for the year, meaning that every year, someone has to do an initialisation. |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
Shows the identity of the calendar. It also acts as a primary key for the CalendarDay table. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
Yes |
|
Shows the date of the calendar. This is also the primary key for the CalendarDay table. |
|
Name |
|
|
Code |
|
|
Data Type |
numeric(6,3) |
|
Mandatory |
No |
|
Shows the working calendar day leave pattern. |
|
Name |
|
|
Code |
|
|
Data Type |
numeric(6,3) |
|
Mandatory |
No |
|
Shows the working calendar day pay pattern. |
|
Name |
|
|
Code |
|
|
Data Type |
numeric(6,3) |
|
Mandatory |
No |
|
Shows the working calendar day week pattern. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the date type for the calendar. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Shows the public holidays for the calendar. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the week number. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the code of the work pattern for the week. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the code of the leave pattern for the week. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the code of the pay pattern for the week. |
|
|
|