Entity NSItemRecord

Description of Entity NSItemRecord

This entity contains the processed transactions. If there are any changes made to the formula or training dates, click on the Recalculate button.


List of all Dependencies of the Entity NSItemRecord

Name

Code

Class Name

Relation_454804

Relation_454804

Reference


List of Attributes of the Entity NSItemRecord

Name

Code

NS Formula ID

NSFormulaId

NS Formula Type

NSFormulaType

NSFormulaString

NSFormulaString

NSItemAvgAmt

NSItemAvgAmt

NSItemAmt

NSItemAmt

NS Remarks

NSRemarks

NSMonth1Amt

NSMonth1Amt

NSMonth2Amt

NSMonth2Amt

NSMonth3Amt

NSMonth3Amt

NSMonth4Amt

NSMonth4Amt

NSMonth5Amt

NSMonth5Amt

NSMonth6Amt

NSMonth6Amt


Entity Attribute NS Formula ID of the Entity NSItemRecord

Card of Attribute NS Formula ID of the Entity NSItemRecord

Name

NS Formula ID

Code

NSFormulaId

Data Type

char(20)

Mandatory

Yes


Description of Attribute NS Formula ID of the Entity NSItemRecord

Shows the identity for the National Service formula. It is the primary key for the NSItemRecord table.


Entity Attribute NS Formula Type of the Entity NSItemRecord

Card of Attribute NS Formula Type of the Entity NSItemRecord

Name

NS Formula Type

Code

NSFormulaType

Data Type

char(20)

Mandatory

Yes


Description of Attribute NS Formula Type of the Entity NSItemRecord

Shows the type of formula for National Service. This is also the primary key for the NSItemRecord table.
Example:
- Formula: The amount depends on the formula you have created
- Free: The amount varies with each payroll run
- Tabulated: The amount varies with each range based criteria
- Fixed: The amount is a constant amount


Entity Attribute NSFormulaString of the Entity NSItemRecord

Card of Attribute NSFormulaString of the Entity NSItemRecord

Name

NSFormulaString

Code

NSFormulaString

Data Type

char(100)

Mandatory

No


Description of Attribute NSFormulaString of the Entity NSItemRecord

Shows the type of string for National Service. String is a data type which includes letters, digits and special characters. It is a sequence of characters.


Entity Attribute NSItemAvgAmt of the Entity NSItemRecord

Card of Attribute NSItemAvgAmt of the Entity NSItemRecord

Name

NSItemAvgAmt

Code

NSItemAvgAmt

Data Type

double

Mandatory

No


Description of Attribute NSItemAvgAmt of the Entity NSItemRecord

Shows the average amount for the National Service item.


Entity Attribute NSItemAmt of the Entity NSItemRecord

Card of Attribute NSItemAmt of the Entity NSItemRecord

Name

NSItemAmt

Code

NSItemAmt

Data Type

double

Mandatory

No


Description of Attribute NSItemAmt of the Entity NSItemRecord

Shows the amount for the National Service item.


Entity Attribute NS Remarks of the Entity NSItemRecord

Card of Attribute NS Remarks of the Entity NSItemRecord

Name

NS Remarks

Code

NSRemarks

Data Type

char(100)

Mandatory

No


Description of Attribute NS Remarks of the Entity NSItemRecord

The remarks for National Service.


Entity Attribute NSMonth1Amt of the Entity NSItemRecord

Card of Attribute NSMonth1Amt of the Entity NSItemRecord

Name

NSMonth1Amt

Code

NSMonth1Amt

Data Type

double

Mandatory

No


Description of Attribute NSMonth1Amt of the Entity NSItemRecord

Shows the amount for the first month of National Service.


Entity Attribute NSMonth2Amt of the Entity NSItemRecord

Card of Attribute NSMonth2Amt of the Entity NSItemRecord

Name

NSMonth2Amt

Code

NSMonth2Amt

Data Type

double

Mandatory

No


Description of Attribute NSMonth2Amt of the Entity NSItemRecord

Shows the amount for the second month of National Service.


Entity Attribute NSMonth3Amt of the Entity NSItemRecord

Card of Attribute NSMonth3Amt of the Entity NSItemRecord

Name

NSMonth3Amt

Code

NSMonth3Amt

Data Type

double

Mandatory

No


Description of Attribute NSMonth3Amt of the Entity NSItemRecord

Shows the amount for the third month of National Service.


Entity Attribute NSMonth4Amt of the Entity NSItemRecord

Card of Attribute NSMonth4Amt of the Entity NSItemRecord

Name

NSMonth4Amt

Code

NSMonth4Amt

Data Type

double

Mandatory

No


Description of Attribute NSMonth4Amt of the Entity NSItemRecord

Shows the amount for the forth month of National Service.


Entity Attribute NSMonth5Amt of the Entity NSItemRecord

Card of Attribute NSMonth5Amt of the Entity NSItemRecord

Name

NSMonth5Amt

Code

NSMonth5Amt

Data Type

double

Mandatory

No


Description of Attribute NSMonth5Amt of the Entity NSItemRecord

Shows the amount for the fifth month of National Service.


Entity Attribute NSMonth6Amt of the Entity NSItemRecord

Card of Attribute NSMonth6Amt of the Entity NSItemRecord

Name

NSMonth6Amt

Code

NSMonth6Amt

Data Type

double

Mandatory

No


Description of Attribute NSMonth6Amt of the Entity NSItemRecord

Shows the amount for the sixth month of National Service.