Salary Calculation System

Companies

Name	Day Start	Day End	Night Start	Night End	Saturday	Sunday	Poya	Mercantile	Leaves/Month	Active	Action
IT Signature	08:30:00	05:00:00	18:00:00	02:00:00	HALF	OFF	OFF	OFF	0	Yes
company a	07:00:00	19:00:00	19:00:00	07:00:00	FULL	FULL	FULL	FULL	4	Yes

Employee Levels

Name	Base Salary	Active	Action
Manager	100000.00	Yes
Designer	50000.00	Yes
Workers	40000.00	Yes

Employees

Name	Phone Number	Level	Active	Action
Dharshi	0771384526	Manager	Yes
Prasanthan	0773966920	Manager	Yes
Frank	0752315902	Designer	Yes
Sharneeshan	073456782	Workers	Yes

Company Level Rules

Company	Level	Day Start	Day End	Night Start	Night End	Saturday	Sunday	Poya	Mercantile	Leaves/Month	Action
IT Signature	Manager	09:00:00	17:00:00	19:00:00	04:00:00	OFF	OFF	OFF	OFF	1
company a	Manager	08:00:00	17:00:00	-	-	OFF	OFF	OFF	OFF	50000

Company Employee Rules

Company	Employee	Day Start	Day End	Night Start	Night End	Saturday	Sunday	Poya	Mercantile	Leaves/Month	Action
company a	Dharshi	09:00:00	18:30:00	-	-	FULL	OFF	FULL	FULL	5

Monthly Company Settings

Company	Month-Year	Day Start	Day End	Night Start	Night End	Saturday	Sunday	Poya	Mercantile	Leaves/Month	Action

Monthly Level Rules

Company	Level	Month-Year	Day Start	Day End	Night Start	Night End	Saturday	Sunday	Poya	Mercantile	Leaves/Month	Action

Monthly Employee Rules

Company	Employee	Month-Year	Day Start	Day End	Night Start	Night End	Saturday	Sunday	Poya	Mercantile	Leaves/Month	Action

Monthly Employee Positions

Employee	Level	Month-Year	Salary	Allowed Leaves	Action

Employee Assignments

Employee	Company	Position	Start Date	End Date	Shift Type	Month-Year	Action