Entity AdjustCredit

Description of Entity AdjustCredit

A credit leave type cannot be assigned to a leave policy, does not have any entitlement and cannot be initialised. This entity makes an adjustment to the leave credit.


List of all Dependencies of the Entity AdjustCredit

Name

Code

Class Name

Relation_170786

Relation_170786

Reference

Relation_151994

Relation_151994

Reference

Relation_151993

Relation_151993

Reference


List of Attributes of the Entity AdjustCredit

Name

Code

EmployeeSysId

EmployeeSysId

Effective Date

AdjEffectiveDate

Leave Type ID

AdjType

Credit Days

AdjDays

Expiry Date

CreditExpireDate

Remarks

Remarks


Entity Attribute EmployeeSysId of the Entity AdjustCredit

Card of Attribute EmployeeSysId of the Entity AdjustCredit

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity AdjustCredit

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.


Entity Attribute Effective Date of the Entity AdjustCredit

Card of Attribute Effective Date of the Entity AdjustCredit

Name

Effective Date

Code

AdjEffectiveDate

Data Type

date

Mandatory

Yes


Description of Attribute Effective Date of the Entity AdjustCredit

Shows the effective date for the credit leave. It holds the primary key for the AdjustCredit table.
It is in the format: DD-MM-YYYY.


Entity Attribute Leave Type ID of the Entity AdjustCredit

Card of Attribute Leave Type ID of the Entity AdjustCredit

Name

Leave Type ID

Code

AdjType

Data Type

smallint

Mandatory

Yes


Description of Attribute Leave Type ID of the Entity AdjustCredit

Stores the type of leave. It is also the primary key for the AdjustCredit table.
Example: Absent / Annual / Late etc.


Entity Attribute Credit Days of the Entity AdjustCredit

Card of Attribute Credit Days of the Entity AdjustCredit

Name

Credit Days

Code

AdjDays

Data Type

double

Mandatory

No


Description of Attribute Credit Days of the Entity AdjustCredit

Shows the number of credit days.


Entity Attribute Expiry Date of the Entity AdjustCredit

Card of Attribute Expiry Date of the Entity AdjustCredit

Name

Expiry Date

Code

CreditExpireDate

Data Type

date

Mandatory

No


Description of Attribute Expiry Date of the Entity AdjustCredit

Shows the expiry date of the credit leave.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Remarks of the Entity AdjustCredit

Card of Attribute Remarks of the Entity AdjustCredit

Name

Remarks

Code

Remarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity AdjustCredit

Store remarks.