Entity CalendarDay

Description of Entity CalendarDay

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.


List of Attributes of the Entity CalendarDay

Name

Code

Calendar ID

CalendarIdCode

Date

CalendarDate

Wk Calendar Day Leave Pattern

WkCalenDayLvePattern

Wk Calendar Day Pay Pattern

WkCalenDayPayPattern

Wk Calendar Day Wk Pattern

WkCalenDayWkPattern

Date Type

DateType

Public Holiday

PublicHoliday

Week No

WeekNo

WeekWorkPatternCode

WeekWorkPatternCode

WeekLeavePatternCode

WeekLeavePatternCode

WeekPayPatternCode

WeekPayPatternCode


Entity Attribute Calendar ID of the Entity CalendarDay

Card of Attribute Calendar ID of the Entity CalendarDay

Name

Calendar ID

Code

CalendarIdCode

Data Type

char(20)

Mandatory

Yes


Description of Attribute Calendar ID of the Entity CalendarDay

Shows the identity of the calendar. It also acts as a primary key for the CalendarDay table.
Example: 5Days Week Cal / 5.5Days Week Cal / 6Days Week Cal etc


Entity Attribute Date of the Entity CalendarDay

Card of Attribute Date of the Entity CalendarDay

Name

Date

Code

CalendarDate

Data Type

date

Mandatory

Yes


Description of Attribute Date of the Entity CalendarDay

Shows the date of the calendar. This is also the primary key for the CalendarDay table.


Entity Attribute Wk Calendar Day Leave Pattern of the Entity CalendarDay

Card of Attribute Wk Calendar Day Leave Pattern of the Entity CalendarDay

Name

Wk Calendar Day Leave Pattern

Code

WkCalenDayLvePattern

Data Type

numeric(6,3)

Mandatory

No


Description of Attribute Wk Calendar Day Leave Pattern of the Entity CalendarDay

Shows the working calendar day leave pattern.


Entity Attribute Wk Calendar Day Pay Pattern of the Entity CalendarDay

Card of Attribute Wk Calendar Day Pay Pattern of the Entity CalendarDay

Name

Wk Calendar Day Pay Pattern

Code

WkCalenDayPayPattern

Data Type

numeric(6,3)

Mandatory

No


Description of Attribute Wk Calendar Day Pay Pattern of the Entity CalendarDay

Shows the working calendar day pay pattern.


Entity Attribute Wk Calendar Day Wk Pattern of the Entity CalendarDay

Card of Attribute Wk Calendar Day Wk Pattern of the Entity CalendarDay

Name

Wk Calendar Day Wk Pattern

Code

WkCalenDayWkPattern

Data Type

numeric(6,3)

Mandatory

No


Description of Attribute Wk Calendar Day Wk Pattern of the Entity CalendarDay

Shows the working calendar day week pattern.


Entity Attribute Date Type of the Entity CalendarDay

Card of Attribute Date Type of the Entity CalendarDay

Name

Date Type

Code

DateType

Data Type

char(20)

Mandatory

No


Description of Attribute Date Type of the Entity CalendarDay

Shows the date type for the calendar.


Entity Attribute Public Holiday of the Entity CalendarDay

Card of Attribute Public Holiday of the Entity CalendarDay

Name

Public Holiday

Code

PublicHoliday

Data Type

smallint

Mandatory

No


Description of Attribute Public Holiday of the Entity CalendarDay

Shows the public holidays for the calendar.


Entity Attribute Week No of the Entity CalendarDay

Card of Attribute Week No of the Entity CalendarDay

Name

Week No

Code

WeekNo

Data Type

integer

Mandatory

No


Description of Attribute Week No of the Entity CalendarDay

Shows the week number.
Example: Week 1 is the first week of January


Entity Attribute WeekWorkPatternCode of the Entity CalendarDay

Card of Attribute WeekWorkPatternCode of the Entity CalendarDay

Name

WeekWorkPatternCode

Code

WeekWorkPatternCode

Data Type

char(20)

Mandatory

No


Description of Attribute WeekWorkPatternCode of the Entity CalendarDay

Shows the code of the work pattern for the week.


Entity Attribute WeekLeavePatternCode of the Entity CalendarDay

Card of Attribute WeekLeavePatternCode of the Entity CalendarDay

Name

WeekLeavePatternCode

Code

WeekLeavePatternCode

Data Type

char(20)

Mandatory

No


Description of Attribute WeekLeavePatternCode of the Entity CalendarDay

Shows the code of the leave pattern for the week.


Entity Attribute WeekPayPatternCode of the Entity CalendarDay

Card of Attribute WeekPayPatternCode of the Entity CalendarDay

Name

WeekPayPatternCode

Code

WeekPayPatternCode

Data Type

char(20)

Mandatory

No


Description of Attribute WeekPayPatternCode of the Entity CalendarDay

Shows the code of the pay pattern for the week.