Entity WeeklyPayPattern

Description of Entity WeeklyPayPattern

This entity would record the different types of Pay patterns for any week in general. This weekly Pay Pattern would not include the public holiday or company given holiday.


List of all Dependencies of the Entity WeeklyPayPattern

Name

Code

Class Name

Relation_52459

Relation_52459

Reference


List of Attributes of the Entity WeeklyPayPattern

Name

Code

Weekly Pay Pattern ID

WeeklyPayPatternId

Pay Sunday

PaySunday

Pay Monday

PayMonday

Pay Tuesday

PayTuesday

Pay Wenesday

PayWenesday

Pay Thursday

PayThursday

Pay Friday

PayFriday

Pay Saturday

PaySaturday


Entity Attribute Weekly Pay Pattern ID of the Entity WeeklyPayPattern

Card of Attribute Weekly Pay Pattern ID of the Entity WeeklyPayPattern

Name

Weekly Pay Pattern ID

Code

WeeklyPayPatternId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Weekly Pay Pattern ID of the Entity WeeklyPayPattern

This attribute is the unique identity for this entity. It uniquely identifies the weekly pay pattern of the company. This is the primary key for the WeeklyPayPattern table.


Entity Attribute Pay Sunday of the Entity WeeklyPayPattern

Card of Attribute Pay Sunday of the Entity WeeklyPayPattern

Name

Pay Sunday

Code

PaySunday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Pay Sunday of the Entity WeeklyPayPattern

This attribute holds the payment pattern for that particular day, i.e. Sunday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc


Entity Attribute Pay Monday of the Entity WeeklyPayPattern

Card of Attribute Pay Monday of the Entity WeeklyPayPattern

Name

Pay Monday

Code

PayMonday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Pay Monday of the Entity WeeklyPayPattern

This attribute holds the payment pattern for that particular day, i.e. Monday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc


Entity Attribute Pay Tuesday of the Entity WeeklyPayPattern

Card of Attribute Pay Tuesday of the Entity WeeklyPayPattern

Name

Pay Tuesday

Code

PayTuesday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Pay Tuesday of the Entity WeeklyPayPattern

This attribute holds the payment pattern for that particular day, i.e. Tuesday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc


Entity Attribute Pay Wenesday of the Entity WeeklyPayPattern

Card of Attribute Pay Wenesday of the Entity WeeklyPayPattern

Name

Pay Wenesday

Code

PayWenesday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Pay Wenesday of the Entity WeeklyPayPattern

This attribute holds the payment pattern for that particular day, i.e. Wednesday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc


Entity Attribute Pay Thursday of the Entity WeeklyPayPattern

Card of Attribute Pay Thursday of the Entity WeeklyPayPattern

Name

Pay Thursday

Code

PayThursday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Pay Thursday of the Entity WeeklyPayPattern

This attribute holds the payment pattern for that particular day, i.e. Thursday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc


Entity Attribute Pay Friday of the Entity WeeklyPayPattern

Card of Attribute Pay Friday of the Entity WeeklyPayPattern

Name

Pay Friday

Code

PayFriday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Pay Friday of the Entity WeeklyPayPattern

This attribute holds the payment pattern for that particular day, i.e. Friday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc


Entity Attribute Pay Saturday of the Entity WeeklyPayPattern

Card of Attribute Pay Saturday of the Entity WeeklyPayPattern

Name

Pay Saturday

Code

PaySaturday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Pay Saturday of the Entity WeeklyPayPattern

This attribute holds the payment pattern for that particular day, i.e. Saturday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc