Entity MedClaim

Description of Entity MedClaim

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'.


List of all Dependencies of the Entity MedClaim

Name

Code

Class Name

Relation_247279

Relation_247279

Reference

Relation_252841

Relation_252841

Reference

Relation_247268

Relation_247268

Reference

Relation_247270

Relation_247270

Reference

Relation_247282

Relation_247282

Reference

Relation_250345

Relation_250345

Reference

Relation_250346

Relation_250346

Reference

Relation_404362

Relation_404362

Reference


List of Attributes of the Entity MedClaim

Name

Code

MedExRecSysId

MedExRecSysId

PersonalSysId

PersonalSysId

MedClaimSysId

MedClaimSysId

Submission Date

SubmissionDate

MedClaimNo

MedClaimNo

Receipt Date

MedReceiptDate

Claim Amount

ClaimAmount

Reimburse Amount

ReimburseAmt

Approve Claim

MedClaimAppr

Payroll Date

PayrollDate

MedClaimPaid

MedClaimPaid

Processed On

PayrollProcessDate

PayrollEmployeeSysId

PayrollEmployeeSysId

Year

PayrollYear

Period

PayrollPeriod

Sub Period

PayrollSubPeriod

Has Billed Vendor

VendorBilled

Vendor

Vendor

Amount

VendorAmount

Use Medisave

UseMedSaveClaim

Claim Insurance

InsuranceClaim

Insurance Ref No

InsuranceRefNo

Hospital or Clinic

HospitalClinic

Treatment From

TreatmentFrom

Treatment To

TreatmentTo

Days

TreatmentLength

Status

ePortalStatus

Remarks

Remarks


Entity Attribute MedExRecSysId of the Entity MedClaim

Card of Attribute MedExRecSysId of the Entity MedClaim

Name

MedExRecSysId

Code

MedExRecSysId

Data Type

integer

Mandatory

No


Description of Attribute MedExRecSysId of the Entity MedClaim

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


Entity Attribute PersonalSysId of the Entity MedClaim

Card of Attribute PersonalSysId of the Entity MedClaim

Name

PersonalSysId

Code

PersonalSysId

Data Type

integer

Mandatory

No


Description of Attribute PersonalSysId of the Entity MedClaim

This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table.


Entity Attribute MedClaimSysId of the Entity MedClaim

Card of Attribute MedClaimSysId of the Entity MedClaim

Name

MedClaimSysId

Code

MedClaimSysId

Data Type

integer

Mandatory

Yes


Description of Attribute MedClaimSysId of the Entity MedClaim

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


Entity Attribute Submission Date of the Entity MedClaim

Card of Attribute Submission Date of the Entity MedClaim

Name

Submission Date

Code

SubmissionDate

Data Type

date

Mandatory

No


Description of Attribute Submission Date of the Entity MedClaim

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


Entity Attribute MedClaimNo of the Entity MedClaim

Card of Attribute MedClaimNo of the Entity MedClaim

Name

MedClaimNo

Code

MedClaimNo

Data Type

char(20)

Mandatory

No


Description of Attribute MedClaimNo of the Entity MedClaim

Shows the medical claim number.


Entity Attribute Receipt Date of the Entity MedClaim

Card of Attribute Receipt Date of the Entity MedClaim

Name

Receipt Date

Code

MedReceiptDate

Data Type

date

Mandatory

No


Description of Attribute Receipt Date of the Entity MedClaim

Shows the date on the receipt.
It is in the format: DD-MM-YYYY.


Entity Attribute Claim Amount of the Entity MedClaim

Card of Attribute Claim Amount of the Entity MedClaim

Name

Claim Amount

Code

ClaimAmount

Data Type

double

Mandatory

No


Description of Attribute Claim Amount of the Entity MedClaim

Shows the employee claim amount.


Entity Attribute Reimburse Amount of the Entity MedClaim

Card of Attribute Reimburse Amount of the Entity MedClaim

Name

Reimburse Amount

Code

ReimburseAmt

Data Type

double

Mandatory

No


Description of Attribute Reimburse Amount of the Entity MedClaim

Shows the amount for the reimbursement.


Entity Attribute Approve Claim of the Entity MedClaim

Card of Attribute Approve Claim of the Entity MedClaim

Name

Approve Claim

Code

MedClaimAppr

Data Type

smallint

Mandatory

No


Description of Attribute Approve Claim of the Entity MedClaim

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


Entity Attribute Payroll Date of the Entity MedClaim

Card of Attribute Payroll Date of the Entity MedClaim

Name

Payroll Date

Code

PayrollDate

Data Type

date

Mandatory

No


Description of Attribute Payroll Date of the Entity MedClaim

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


Entity Attribute MedClaimPaid of the Entity MedClaim

Card of Attribute MedClaimPaid of the Entity MedClaim

Name

MedClaimPaid

Code

MedClaimPaid

Data Type

smallint

Mandatory

No


Description of Attribute MedClaimPaid of the Entity MedClaim

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


Entity Attribute Processed On of the Entity MedClaim

Card of Attribute Processed On of the Entity MedClaim

Name

Processed On

Code

PayrollProcessDate

Data Type

date

Mandatory

No


Description of Attribute Processed On of the Entity MedClaim

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


Entity Attribute PayrollEmployeeSysId of the Entity MedClaim

Card of Attribute PayrollEmployeeSysId of the Entity MedClaim

Name

PayrollEmployeeSysId

Code

PayrollEmployeeSysId

Data Type

integer

Mandatory

No


Description of Attribute PayrollEmployeeSysId of the Entity MedClaim

A system generated identity. It is blind to the user.


Entity Attribute Year of the Entity MedClaim

Card of Attribute Year of the Entity MedClaim

Name

Year

Code

PayrollYear

Data Type

integer

Mandatory

No


Description of Attribute Year of the Entity MedClaim

Shows the year for the payroll.
Example: 2013


Entity Attribute Period of the Entity MedClaim

Card of Attribute Period of the Entity MedClaim

Name

Period

Code

PayrollPeriod

Data Type

integer

Mandatory

No


Description of Attribute Period of the Entity MedClaim

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


Entity Attribute Sub Period of the Entity MedClaim

Card of Attribute Sub Period of the Entity MedClaim

Name

Sub Period

Code

PayrollSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute Sub Period of the Entity MedClaim

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 Has Billed Vendor of the Entity MedClaim

Card of Attribute Has Billed Vendor of the Entity MedClaim

Name

Has Billed Vendor

Code

VendorBilled

Data Type

smallint

Mandatory

No


Description of Attribute Has Billed Vendor of the Entity MedClaim

Indicates if the medical claim was billed to the vendor, in a form of a checkbox.


Entity Attribute Vendor of the Entity MedClaim

Card of Attribute Vendor of the Entity MedClaim

Name

Vendor

Code

Vendor

Data Type

char(20)

Mandatory

No


Description of Attribute Vendor of the Entity MedClaim

Shows the information of the vendor.


Entity Attribute Amount of the Entity MedClaim

Card of Attribute Amount of the Entity MedClaim

Name

Amount

Code

VendorAmount

Data Type

double

Mandatory

No


Description of Attribute Amount of the Entity MedClaim

Shows the amount the vendor has been billed.


Entity Attribute Use Medisave of the Entity MedClaim

Card of Attribute Use Medisave of the Entity MedClaim

Name

Use Medisave

Code

UseMedSaveClaim

Data Type

smallint

Mandatory

No


Description of Attribute Use Medisave of the Entity MedClaim

Indicates if the employee used his/her medisave to claim the medical bill, in a form of a checkbox.


Entity Attribute Claim Insurance of the Entity MedClaim

Card of Attribute Claim Insurance of the Entity MedClaim

Name

Claim Insurance

Code

InsuranceClaim

Data Type

smallint

Mandatory

No


Description of Attribute Claim Insurance of the Entity MedClaim

Indicates if the employee used his/her insurance to claim the medical bill, in a form of a checkbox.


Entity Attribute Insurance Ref No of the Entity MedClaim

Card of Attribute Insurance Ref No of the Entity MedClaim

Name

Insurance Ref No

Code

InsuranceRefNo

Data Type

char(50)

Mandatory

No


Description of Attribute Insurance Ref No of the Entity MedClaim

States the reference number of the insurance, if the insurance was used.


Entity Attribute Hospital or Clinic of the Entity MedClaim

Card of Attribute Hospital or Clinic of the Entity MedClaim

Name

Hospital or Clinic

Code

HospitalClinic

Data Type

char(20)

Mandatory

No


Description of Attribute Hospital or Clinic of the Entity MedClaim

Shows the hospital or clinic to claim the medical bill.


Entity Attribute Treatment From of the Entity MedClaim

Card of Attribute Treatment From of the Entity MedClaim

Name

Treatment From

Code

TreatmentFrom

Data Type

date

Mandatory

No


Description of Attribute Treatment From of the Entity MedClaim

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


Entity Attribute Treatment To of the Entity MedClaim

Card of Attribute Treatment To of the Entity MedClaim

Name

Treatment To

Code

TreatmentTo

Data Type

date

Mandatory

No


Description of Attribute Treatment To of the Entity MedClaim

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


Entity Attribute Days of the Entity MedClaim

Card of Attribute Days of the Entity MedClaim

Name

Days

Code

TreatmentLength

Data Type

double

Mandatory

No


Description of Attribute Days of the Entity MedClaim

States the number of days the treatment took.


Entity Attribute Status of the Entity MedClaim

Card of Attribute Status of the Entity MedClaim

Name

Status

Code

ePortalStatus

Data Type

char(20)

Mandatory

No


Description of Attribute Status of the Entity MedClaim

Displays the ePortal status.


Entity Attribute Remarks of the Entity MedClaim

Card of Attribute Remarks of the Entity MedClaim

Name

Remarks

Code

Remarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity MedClaim

Store remarks.