|
A medical claim record represents a single claim submission by an employee. You can store the type of illness, the treatment received and where it was given. This is the primary window for creating or modifying an existing medical claim record. It is a record of a claim submitted by an employee that can be submitted to payroll (via Payroll Module) for processing and subsequently be picked up using the Costing module for cost distribution. Medical claims submitted by the employee via the ePortal application have the remarks 'Created by ePortal'. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
A system generated identity. It is blind to the user. It holds the primary key for the MedExRec table. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
Yes |
|
A system generated identity. It is blind to the user. This holds the primary key for the MedClaim table. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the date of submission. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the medical claim number. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the date on the receipt. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the employee claim amount. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the amount for the reimbursement. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the claim has been approved, in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the date of the payroll. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the claim has been paid, in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows when the payment was processed. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
A system generated identity. It is blind to the user. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the year for the payroll. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the period of the payroll. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the sub period for the payroll. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the medical claim was billed to the vendor, in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the information of the vendor. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the amount the vendor has been billed. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the employee used his/her medisave to claim the medical bill, in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the employee used his/her insurance to claim the medical bill, in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
States the reference number of the insurance, if the insurance was used. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the hospital or clinic to claim the medical bill. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the starting date of the treatment. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the end date of the treatment. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
States the number of days the treatment took. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Displays the ePortal status. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Store remarks. |
|
|
|