Entity CoreKeyWord

Description of Entity CoreKeyWord

This table contains a list of Keywords for

1. Formula components like OT Fixed Rate, Shift Frequency, Hours per Week etc.
2. Formula Range Basis like CPF Wage, Total Wage, SDF Wage etc.
3. Wage Setup like SDF Wage, Ordinary Wage.
4. Property Setup like Subject to OT, Subject to NS.

The entity contains User defined Keywords created from Property.


List of Attributes of the Entity CoreKeyWord

Name

Code

CoreKeyWordId

CoreKeyWordId

CoreKeyWordCategory

CoreKeyWordCategory

CoreKeyWordDefaultName

CoreKeyWordDefaultName

CoreUserDefinedName

CoreUserDefinedName

Description

CoreKeyWordDesc


Entity Attribute CoreKeyWordId of the Entity CoreKeyWord

Card of Attribute CoreKeyWordId of the Entity CoreKeyWord

Name

CoreKeyWordId

Code

CoreKeyWordId

Data Type

char(20)

Mandatory

Yes


Description of Attribute CoreKeyWordId of the Entity CoreKeyWord

Shows the identity for the core keyword. It is also the primary key for the CoreKeyWord table.


Entity Attribute CoreKeyWordCategory of the Entity CoreKeyWord

Card of Attribute CoreKeyWordCategory of the Entity CoreKeyWord

Name

CoreKeyWordCategory

Code

CoreKeyWordCategory

Data Type

char(20)

Mandatory

No


Description of Attribute CoreKeyWordCategory of the Entity CoreKeyWord

Shows the category of the core keyword.


Entity Attribute CoreKeyWordDefaultName of the Entity CoreKeyWord

Card of Attribute CoreKeyWordDefaultName of the Entity CoreKeyWord

Name

CoreKeyWordDefaultName

Code

CoreKeyWordDefaultName

Data Type

char(100)

Mandatory

No


Description of Attribute CoreKeyWordDefaultName of the Entity CoreKeyWord

This is the original name where the software will reference to. Users cannot amend this attribute.


Entity Attribute CoreUserDefinedName of the Entity CoreKeyWord

Card of Attribute CoreUserDefinedName of the Entity CoreKeyWord

Name

CoreUserDefinedName

Code

CoreUserDefinedName

Data Type

char(100)

Mandatory

No


Description of Attribute CoreUserDefinedName of the Entity CoreKeyWord

This is the user defined name which can be amended from the User Defined Module in the Core Module.


Entity Attribute Description of the Entity CoreKeyWord

Card of Attribute Description of the Entity CoreKeyWord

Name

Description

Code

CoreKeyWordDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity CoreKeyWord

Shows the description of the core keyword.