Entity NSPayCase

Description of Entity NSPayCase

This entity contains the training dates, the venue, contact details and other required information for the National Service. Only employees who are in supervisory position are available for selection under the Authorisation Name field. It also stores the computation function related for NS.


List of all Dependencies of the Entity NSPayCase

Name

Code

Class Name

Relation_457718

Relation_457718

Reference

Relation_454804

Relation_454804

Reference

Relation_494476

Relation_494476

Reference


List of Attributes of the Entity NSPayCase

Name

Code

EmployeeSysId

EmployeeSysId

NSPaySysId

NSPaySysId

Date From

NSStartDate

Date To

NSEndDate

Working Days

NSDays

Position

NSPositionId

Venue

NSVenue

Address

Address1

Address2

Address2

Address3

Address3

Postal Code

PostalCode

Contact > Person

ContactPerson

Contact > Number

ContactNumber

Computation Formula

NSFormulaCategory

NSFormulaCode

NSFormulaCode

Pay Element ID

NSPayElementId

NSPeriodStart

NSPeriodStart

NSPayoutAmt

NSPayoutAmt

NSLastGeneration

NSLastGeneration

Submitted Time

NSSubmited

First Saturday Off

NSDateFirstSatOff

NSShiftWorkStart

NSShiftWorkStart

NSShiftWorkEnd

NSShiftWorkEnd

NSInsertPayElement

NSInsertPayElement

Payroll Date

PayrollDate

Year

PayrollYear

Period

PayrollPeriod

Sub Period

PayrollSubPeriod

Processed On

PayrollProcessDate

NSPayRecId

NSPayRecId

Authorisation > Name

AuthorisedName

Authorisation > Designation

NSDesignation

NSMonth1Str

NSMonth1Str

NSMonth2Str

NSMonth2Str

NSMonth3Str

NSMonth3Str

NSMonth4Str

NSMonth4Str

NSMonth5Str

NSMonth5Str

NSMonth6Str

NSMonth6Str

Batch ID

BatchID

Payroll Start Day (2 to 31)

PayPeriodStartDay


Entity Attribute EmployeeSysId of the Entity NSPayCase

Card of Attribute EmployeeSysId of the Entity NSPayCase

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

No


Description of Attribute EmployeeSysId of the Entity NSPayCase

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


Entity Attribute NSPaySysId of the Entity NSPayCase

Card of Attribute NSPaySysId of the Entity NSPayCase

Name

NSPaySysId

Code

NSPaySysId

Data Type

integer

Mandatory

Yes


Description of Attribute NSPaySysId of the Entity NSPayCase

A system generated identity. It is blind to the user. It also holds the primary key for the NSPayCase table.


Entity Attribute Date From of the Entity NSPayCase

Card of Attribute Date From of the Entity NSPayCase

Name

Date From

Code

NSStartDate

Data Type

date

Mandatory

No


Description of Attribute Date From of the Entity NSPayCase

The start date of the employee's National Service.
It is in the format: DD-MM-YYYY.


Entity Attribute Date To of the Entity NSPayCase

Card of Attribute Date To of the Entity NSPayCase

Name

Date To

Code

NSEndDate

Data Type

date

Mandatory

No


Description of Attribute Date To of the Entity NSPayCase

The end date of the employee's National Service.
It is in the format: DD-MM-YYYY.


Entity Attribute Working Days of the Entity NSPayCase

Card of Attribute Working Days of the Entity NSPayCase

Name

Working Days

Code

NSDays

Data Type

double

Mandatory

No


Description of Attribute Working Days of the Entity NSPayCase

Stores the number of days the employee is serving NS.


Entity Attribute Position of the Entity NSPayCase

Card of Attribute Position of the Entity NSPayCase

Name

Position

Code

NSPositionId

Data Type

char(40)

Mandatory

No


Description of Attribute Position of the Entity NSPayCase

Shows the position of the employee in the company.
Example: Clerk / Manager etc


Entity Attribute Venue of the Entity NSPayCase

Card of Attribute Venue of the Entity NSPayCase

Name

Venue

Code

NSVenue

Data Type

char(100)

Mandatory

No


Description of Attribute Venue of the Entity NSPayCase

The venue of the employee's National Service.


Entity Attribute Address of the Entity NSPayCase

Card of Attribute Address of the Entity NSPayCase

Name

Address

Code

Address1

Data Type

char(40)

Mandatory

No


Description of Attribute Address of the Entity NSPayCase

First line of the address.


Entity Attribute Address2 of the Entity NSPayCase

Card of Attribute Address2 of the Entity NSPayCase

Name

Address2

Code

Address2

Data Type

char(40)

Mandatory

No


Description of Attribute Address2 of the Entity NSPayCase

Second line of the address.


Entity Attribute Address3 of the Entity NSPayCase

Card of Attribute Address3 of the Entity NSPayCase

Name

Address3

Code

Address3

Data Type

char(40)

Mandatory

No


Description of Attribute Address3 of the Entity NSPayCase

Third line of the address.


Entity Attribute Postal Code of the Entity NSPayCase

Card of Attribute Postal Code of the Entity NSPayCase

Name

Postal Code

Code

PostalCode

Data Type

char(6)

Mandatory

No


Description of Attribute Postal Code of the Entity NSPayCase

Stores the postal code of the person's address.


Entity Attribute Contact > Person of the Entity NSPayCase

Card of Attribute Contact > Person of the Entity NSPayCase

Name

Contact > Person

Code

ContactPerson

Data Type

char(50)

Mandatory

No


Description of Attribute Contact > Person of the Entity NSPayCase

Shows the name of the person to contact other than the employee.


Entity Attribute Contact > Number of the Entity NSPayCase

Card of Attribute Contact > Number of the Entity NSPayCase

Name

Contact > Number

Code

ContactNumber

Data Type

char(30)

Mandatory

No


Description of Attribute Contact > Number of the Entity NSPayCase

This field contains the contact number for the person.


Entity Attribute Computation Formula of the Entity NSPayCase

Card of Attribute Computation Formula of the Entity NSPayCase

Name

Computation Formula

Code

NSFormulaCategory

Data Type

char(2)

Mandatory

No


Description of Attribute Computation Formula of the Entity NSPayCase

Shows the computation formula.


Entity Attribute NSFormulaCode of the Entity NSPayCase

Card of Attribute NSFormulaCode of the Entity NSPayCase

Name

NSFormulaCode

Code

NSFormulaCode

Data Type

char(1)

Mandatory

No


Description of Attribute NSFormulaCode of the Entity NSPayCase

Shows the code for the formula.


Entity Attribute Pay Element ID of the Entity NSPayCase

Card of Attribute Pay Element ID of the Entity NSPayCase

Name

Pay Element ID

Code

NSPayElementId

Data Type

char(20)

Mandatory

No


Description of Attribute Pay Element ID of the Entity NSPayCase

Shows the identity of the pay element.
Example:
INCO = Income Tax Deduction / Withheld
NOIL = Notice in Lieu Deductions
NATI = National Service Pay
COMC = Community Chest
etc


Entity Attribute NSPeriodStart of the Entity NSPayCase

Card of Attribute NSPeriodStart of the Entity NSPayCase

Name

NSPeriodStart

Code

NSPeriodStart

Data Type

integer

Mandatory

No


Description of Attribute NSPeriodStart of the Entity NSPayCase

Shows the period when NS has commenced.


Entity Attribute NSPayoutAmt of the Entity NSPayCase

Card of Attribute NSPayoutAmt of the Entity NSPayCase

Name

NSPayoutAmt

Code

NSPayoutAmt

Data Type

double

Mandatory

No


Description of Attribute NSPayoutAmt of the Entity NSPayCase

Shows the payout amount for NS.


Entity Attribute NSLastGeneration of the Entity NSPayCase

Card of Attribute NSLastGeneration of the Entity NSPayCase

Name

NSLastGeneration

Code

NSLastGeneration

Data Type

timestamp

Mandatory

No


Description of Attribute NSLastGeneration of the Entity NSPayCase

Shows the last generation of the National Service.


Entity Attribute Submitted Time of the Entity NSPayCase

Card of Attribute Submitted Time of the Entity NSPayCase

Name

Submitted Time

Code

NSSubmited

Data Type

smallint

Mandatory

No


Description of Attribute Submitted Time of the Entity NSPayCase

States the time of the eBatch submission.


Entity Attribute First Saturday Off of the Entity NSPayCase

Card of Attribute First Saturday Off of the Entity NSPayCase

Name

First Saturday Off

Code

NSDateFirstSatOff

Data Type

date

Mandatory

No


Description of Attribute First Saturday Off of the Entity NSPayCase

Shows when the employee gets the first Saturday off.
It is usually in the format: DD-MM-YYYY.


Entity Attribute NSShiftWorkStart of the Entity NSPayCase

Card of Attribute NSShiftWorkStart of the Entity NSPayCase

Name

NSShiftWorkStart

Code

NSShiftWorkStart

Data Type

time

Mandatory

No


Description of Attribute NSShiftWorkStart of the Entity NSPayCase

Shows the start time of the shift work.


Entity Attribute NSShiftWorkEnd of the Entity NSPayCase

Card of Attribute NSShiftWorkEnd of the Entity NSPayCase

Name

NSShiftWorkEnd

Code

NSShiftWorkEnd

Data Type

time

Mandatory

No


Description of Attribute NSShiftWorkEnd of the Entity NSPayCase

Shows the end time of the shift work.


Entity Attribute NSInsertPayElement of the Entity NSPayCase

Card of Attribute NSInsertPayElement of the Entity NSPayCase

Name

NSInsertPayElement

Code

NSInsertPayElement

Data Type

smallint

Mandatory

No


Description of Attribute NSInsertPayElement of the Entity NSPayCase

Shows the pay element inserted


Entity Attribute Payroll Date of the Entity NSPayCase

Card of Attribute Payroll Date of the Entity NSPayCase

Name

Payroll Date

Code

PayrollDate

Data Type

date

Mandatory

No


Description of Attribute Payroll Date of the Entity NSPayCase

Shows the date of the payroll.
It is in the format: DD-MM-YYYY.


Entity Attribute Year of the Entity NSPayCase

Card of Attribute Year of the Entity NSPayCase

Name

Year

Code

PayrollYear

Data Type

integer

Mandatory

No


Description of Attribute Year of the Entity NSPayCase

Shows the year for the payroll.
Example: 2013


Entity Attribute Period of the Entity NSPayCase

Card of Attribute Period of the Entity NSPayCase

Name

Period

Code

PayrollPeriod

Data Type

integer

Mandatory

No


Description of Attribute Period of the Entity NSPayCase

Shows the period of the payroll.
Example: January = "1" / February = "2" / March = "3" etc


Entity Attribute Sub Period of the Entity NSPayCase

Card of Attribute Sub Period of the Entity NSPayCase

Name

Sub Period

Code

PayrollSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute Sub Period of the Entity NSPayCase

Shows the sub period for the payroll.

Example:
Sub period 1 = 1 Payment Group (Hourly, Daily & Monthly rated)
Sub period 2 = 2 Payment Group (Hourly, Daily & Monthly rated)
Sub period 3 = 3 Payment Group (Hourly & Daily rated), divided by 3 and the balance is placed in the last sub-period
Sub Period 4 = 4 Payment Group (Hourly & Daily rated)


Entity Attribute Processed On of the Entity NSPayCase

Card of Attribute Processed On of the Entity NSPayCase

Name

Processed On

Code

PayrollProcessDate

Data Type

date

Mandatory

No


Description of Attribute Processed On of the Entity NSPayCase

Shows when the payment was processed.
It is usually in the format: DD-MM-YYYY.


Entity Attribute NSPayRecId of the Entity NSPayCase

Card of Attribute NSPayRecId of the Entity NSPayCase

Name

NSPayRecId

Code

NSPayRecId

Data Type

char(20)

Mandatory

No


Description of Attribute NSPayRecId of the Entity NSPayCase

Stores the identity for the pay record.
Example: Normal / Normal Time Sheet


Entity Attribute Authorisation > Name of the Entity NSPayCase

Card of Attribute Authorisation > Name of the Entity NSPayCase

Name

Authorisation > Name

Code

AuthorisedName

Data Type

char(60)

Mandatory

No


Description of Attribute Authorisation > Name of the Entity NSPayCase

The name and identity of the employee who gave authorisation.


Entity Attribute Authorisation > Designation of the Entity NSPayCase

Card of Attribute Authorisation > Designation of the Entity NSPayCase

Name

Authorisation > Designation

Code

NSDesignation

Data Type

char(20)

Mandatory

No


Description of Attribute Authorisation > Designation of the Entity NSPayCase

Shows the position of the employer who gave authorisation.
Example: Accountant / CEO / Director etc


Entity Attribute NSMonth1Str of the Entity NSPayCase

Card of Attribute NSMonth1Str of the Entity NSPayCase

Name

NSMonth1Str

Code

NSMonth1Str

Data Type

char(20)

Mandatory

No


Description of Attribute NSMonth1Str of the Entity NSPayCase

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


Entity Attribute NSMonth2Str of the Entity NSPayCase

Card of Attribute NSMonth2Str of the Entity NSPayCase

Name

NSMonth2Str

Code

NSMonth2Str

Data Type

char(20)

Mandatory

No


Description of Attribute NSMonth2Str of the Entity NSPayCase

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


Entity Attribute NSMonth3Str of the Entity NSPayCase

Card of Attribute NSMonth3Str of the Entity NSPayCase

Name

NSMonth3Str

Code

NSMonth3Str

Data Type

char(20)

Mandatory

No


Description of Attribute NSMonth3Str of the Entity NSPayCase

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


Entity Attribute NSMonth4Str of the Entity NSPayCase

Card of Attribute NSMonth4Str of the Entity NSPayCase

Name

NSMonth4Str

Code

NSMonth4Str

Data Type

char(20)

Mandatory

No


Description of Attribute NSMonth4Str of the Entity NSPayCase

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


Entity Attribute NSMonth5Str of the Entity NSPayCase

Card of Attribute NSMonth5Str of the Entity NSPayCase

Name

NSMonth5Str

Code

NSMonth5Str

Data Type

char(20)

Mandatory

No


Description of Attribute NSMonth5Str of the Entity NSPayCase

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


Entity Attribute NSMonth6Str of the Entity NSPayCase

Card of Attribute NSMonth6Str of the Entity NSPayCase

Name

NSMonth6Str

Code

NSMonth6Str

Data Type

char(20)

Mandatory

No


Description of Attribute NSMonth6Str of the Entity NSPayCase

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


Entity Attribute Batch ID of the Entity NSPayCase

Card of Attribute Batch ID of the Entity NSPayCase

Name

Batch ID

Code

BatchID

Data Type

char(20)

Mandatory

No


Description of Attribute Batch ID of the Entity NSPayCase

Shows the identity of the Batch.


Entity Attribute Payroll Start Day (2 to 31) of the Entity NSPayCase

Card of Attribute Payroll Start Day (2 to 31) of the Entity NSPayCase

Name

Payroll Start Day (2 to 31)

Code

PayPeriodStartDay

Data Type

integer

Mandatory

No


Description of Attribute Payroll Start Day (2 to 31) of the Entity NSPayCase

Shows the start day for the payroll.