Entity TrainingBatch

Description of Entity TrainingBatch

This feature is for creating a training record with the same details for multiple employees. If you are doing this for a large number of employees, it is advisable to double check that all the details are correct. The reason being that if there is an error, it will be replicated on all the affected training records. There is no mass delete or global change feature.

If this has happened, there are several methods you can try. You can attempt to delete all the affected training records and recreate them using the corrected batch. However, if you have processed the payroll with the course fees reimbursements, then it is not advisable as the training records would have been linked. The alternative is to manually change the records. Either case, one of the first things to do is to create a query to filter the affected employees.


List of all Dependencies of the Entity TrainingBatch

Name

Code

Class Name

Relation_290305

Relation_290305

Reference

Relation_290300

Relation_290300

Reference

Relation_361748

Relation_361748

Reference

Relation_293547

Relation_293547

Reference

Relation_287053

Relation_287053

Reference

Relation_353154

Relation_353154

Reference


List of Attributes of the Entity TrainingBatch

Name

Code

Course Code

CourseCode

Training Batch ID

TrainingBatchId

Description

TrainingBatchDesc

Submission Date

SubmissionDate

Approve the Status

Approve

Remarks

TrainingRemarks

Training and Tax Computation

TrainTaxComputation

Total Training Amount

TotalTrainingFee

Total Tax Amount

TotalTaxAmount

Sponsorship Type

SponsorType

SponsorValue

SponsorValue

Received

SponsorReceived

Government Grant Type

GovGrantType

GovGrantValue

GovGrantValue

GovGrantReceived

GovGrantReceived

Approve Claim

ClaimApprove

Payroll Date

PayrollDate

Pay Element ID

PayrollPayElementId

Paid Claim

TrainingPaid

Plan Date

PlanDate

Last Modified

LastModified


Entity Attribute Course Code of the Entity TrainingBatch

Card of Attribute Course Code of the Entity TrainingBatch

Name

Course Code

Code

CourseCode

Data Type

char(20)

Mandatory

No


Description of Attribute Course Code of the Entity TrainingBatch

Shows the code for the course. This is the primary key for the Course table.


Entity Attribute Training Batch ID of the Entity TrainingBatch

Card of Attribute Training Batch ID of the Entity TrainingBatch

Name

Training Batch ID

Code

TrainingBatchId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Training Batch ID of the Entity TrainingBatch

Shows the identity of the training batch. This is the primary key for the TrainingBatch table.


Entity Attribute Description of the Entity TrainingBatch

Card of Attribute Description of the Entity TrainingBatch

Name

Description

Code

TrainingBatchDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity TrainingBatch

Stores the description about the training batch.


Entity Attribute Submission Date of the Entity TrainingBatch

Card of Attribute Submission Date of the Entity TrainingBatch

Name

Submission Date

Code

SubmissionDate

Data Type

date

Mandatory

No


Description of Attribute Submission Date of the Entity TrainingBatch

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


Entity Attribute Approve the Status of the Entity TrainingBatch

Card of Attribute Approve the Status of the Entity TrainingBatch

Name

Approve the Status

Code

Approve

Data Type

smallint

Mandatory

No


Description of Attribute Approve the Status of the Entity TrainingBatch

Indicates if the status is approved or not, in a form of a checkbox.


Entity Attribute Remarks of the Entity TrainingBatch

Card of Attribute Remarks of the Entity TrainingBatch

Name

Remarks

Code

TrainingRemarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity TrainingBatch

Stores any remarks about the training.


Entity Attribute Training and Tax Computation of the Entity TrainingBatch

Card of Attribute Training and Tax Computation of the Entity TrainingBatch

Name

Training and Tax Computation

Code

TrainTaxComputation

Data Type

smallint

Mandatory

No


Description of Attribute Training and Tax Computation of the Entity TrainingBatch

Indicates if the training and tax computation is:
System to compute Training and Tax Amount
To use user-defined Training and Tax Amount,
in a form of radio buttons.


Entity Attribute Total Training Amount of the Entity TrainingBatch

Card of Attribute Total Training Amount of the Entity TrainingBatch

Name

Total Training Amount

Code

TotalTrainingFee

Data Type

double

Mandatory

No


Description of Attribute Total Training Amount of the Entity TrainingBatch

Shows the total fee for the training.


Entity Attribute Total Tax Amount of the Entity TrainingBatch

Card of Attribute Total Tax Amount of the Entity TrainingBatch

Name

Total Tax Amount

Code

TotalTaxAmount

Data Type

double

Mandatory

No


Description of Attribute Total Tax Amount of the Entity TrainingBatch

States the tax amount for the training.


Entity Attribute Sponsorship Type of the Entity TrainingBatch

Card of Attribute Sponsorship Type of the Entity TrainingBatch

Name

Sponsorship Type

Code

SponsorType

Data Type

integer

Mandatory

No


Description of Attribute Sponsorship Type of the Entity TrainingBatch

Shows the type of sponsorship, in a form of radio buttons.
Example: Percentage / Amount


Entity Attribute SponsorValue of the Entity TrainingBatch

Card of Attribute SponsorValue of the Entity TrainingBatch

Name

SponsorValue

Code

SponsorValue

Data Type

double

Mandatory

No


Description of Attribute SponsorValue of the Entity TrainingBatch

Shows the value of the sponsorship. It can either be in percentage or an amount.


Entity Attribute Received of the Entity TrainingBatch

Card of Attribute Received of the Entity TrainingBatch

Name

Received

Code

SponsorReceived

Data Type

date

Mandatory

No


Description of Attribute Received of the Entity TrainingBatch

Shows the date of when the sponsorship was received.
It is in the format: DD-MM-YYYY.


Entity Attribute Government Grant Type of the Entity TrainingBatch

Card of Attribute Government Grant Type of the Entity TrainingBatch

Name

Government Grant Type

Code

GovGrantType

Data Type

integer

Mandatory

No


Description of Attribute Government Grant Type of the Entity TrainingBatch

Shows the type of government grant, in a form of radio buttons.
Example: Percentage / Amount


Entity Attribute GovGrantValue of the Entity TrainingBatch

Card of Attribute GovGrantValue of the Entity TrainingBatch

Name

GovGrantValue

Code

GovGrantValue

Data Type

double

Mandatory

No


Description of Attribute GovGrantValue of the Entity TrainingBatch

Shows the value of the government grant. It can either be in percentage or an amount.


Entity Attribute GovGrantReceived of the Entity TrainingBatch

Card of Attribute GovGrantReceived of the Entity TrainingBatch

Name

GovGrantReceived

Code

GovGrantReceived

Data Type

date

Mandatory

No


Description of Attribute GovGrantReceived of the Entity TrainingBatch

Shows the date of when the government grant was received.
It is in the format: DD-MM-YYYY.


Entity Attribute Approve Claim of the Entity TrainingBatch

Card of Attribute Approve Claim of the Entity TrainingBatch

Name

Approve Claim

Code

ClaimApprove

Data Type

smallint

Mandatory

No


Description of Attribute Approve Claim of the Entity TrainingBatch

Indicates if the claim has been approved, in a form of a checkbox.


Entity Attribute Payroll Date of the Entity TrainingBatch

Card of Attribute Payroll Date of the Entity TrainingBatch

Name

Payroll Date

Code

PayrollDate

Data Type

date

Mandatory

No


Description of Attribute Payroll Date of the Entity TrainingBatch

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


Entity Attribute Pay Element ID of the Entity TrainingBatch

Card of Attribute Pay Element ID of the Entity TrainingBatch

Name

Pay Element ID

Code

PayrollPayElementId

Data Type

char(20)

Mandatory

No


Description of Attribute Pay Element ID of the Entity TrainingBatch

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

or

Transport and/or Medical Claims for the Training entity.


Entity Attribute Paid Claim of the Entity TrainingBatch

Card of Attribute Paid Claim of the Entity TrainingBatch

Name

Paid Claim

Code

TrainingPaid

Data Type

smallint

Mandatory

No


Description of Attribute Paid Claim of the Entity TrainingBatch

Indicates if the payment for the training has been made or not, in a form of a checkbox.


Entity Attribute Plan Date of the Entity TrainingBatch

Card of Attribute Plan Date of the Entity TrainingBatch

Name

Plan Date

Code

PlanDate

Data Type

date

Mandatory

No


Description of Attribute Plan Date of the Entity TrainingBatch

Shows the date of when the plan was made for the training.
It is in the format: DD-MM-YYYY.


Entity Attribute Last Modified of the Entity TrainingBatch

Card of Attribute Last Modified of the Entity TrainingBatch

Name

Last Modified

Code

LastModified

Data Type

timestamp

Mandatory

No


Description of Attribute Last Modified of the Entity TrainingBatch

Shows when the entry was last modified.