Entity MedExRec

Description of Entity MedExRec

If employees have regular scheduled medical examinations, this will be a useful feature for keeping track of these examinations. The cost of each examination can be links to a medical claim and an alert (using Alert Module) can be generated based on the follow up date.


List of all Dependencies of the Entity MedExRec

Name

Code

Class Name

Relation_389025

Relation_389025

Reference

Relation_389026

Relation_389026

Reference

Relation_404362

Relation_404362

Reference

Relation_385713

Relation_385713

Reference

Relation_389028

Relation_389028

Reference


List of Attributes of the Entity MedExRec

Name

Code

MedExRecSysId

MedExRecSysId

PersonalSysId

PersonalSysId

Receipt No

ReceiptNo

Receipt Date

ReceiptDate

Status

ePortalStatus

Employee ID

ePortalEmployeeSysId

Review Date

ReviewDate

Review Fee

ReviewFee

Remarks

Remarks

Follow up Date

FollowUpDate


Entity Attribute MedExRecSysId of the Entity MedExRec

Card of Attribute MedExRecSysId of the Entity MedExRec

Name

MedExRecSysId

Code

MedExRecSysId

Data Type

integer

Mandatory

Yes


Description of Attribute MedExRecSysId of the Entity MedExRec

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 MedExRec

Card of Attribute PersonalSysId of the Entity MedExRec

Name

PersonalSysId

Code

PersonalSysId

Data Type

integer

Mandatory

No


Description of Attribute PersonalSysId of the Entity MedExRec

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 Receipt No of the Entity MedExRec

Card of Attribute Receipt No of the Entity MedExRec

Name

Receipt No

Code

ReceiptNo

Data Type

char(20)

Mandatory

No


Description of Attribute Receipt No of the Entity MedExRec

Shows the receipt number for the medical examination.


Entity Attribute Receipt Date of the Entity MedExRec

Card of Attribute Receipt Date of the Entity MedExRec

Name

Receipt Date

Code

ReceiptDate

Data Type

date

Mandatory

No


Description of Attribute Receipt Date of the Entity MedExRec

Shows the date of the receipt of the medical examination.
It is in the format: DD-MM-YYYY.


Entity Attribute Status of the Entity MedExRec

Card of Attribute Status of the Entity MedExRec

Name

Status

Code

ePortalStatus

Data Type

char(20)

Mandatory

No


Description of Attribute Status of the Entity MedExRec

Displays the ePortal status.


Entity Attribute Employee ID of the Entity MedExRec

Card of Attribute Employee ID of the Entity MedExRec

Name

Employee ID

Code

ePortalEmployeeSysId

Data Type

integer

Mandatory

No


Description of Attribute Employee ID of the Entity MedExRec

Shows the identity of the employee.


Entity Attribute Review Date of the Entity MedExRec

Card of Attribute Review Date of the Entity MedExRec

Name

Review Date

Code

ReviewDate

Data Type

date

Mandatory

No


Description of Attribute Review Date of the Entity MedExRec

Shows the review date of the medical examination for the employee.
It is in the format: DD-MM-YYYY.


Entity Attribute Review Fee of the Entity MedExRec

Card of Attribute Review Fee of the Entity MedExRec

Name

Review Fee

Code

ReviewFee

Data Type

double

Mandatory

No


Description of Attribute Review Fee of the Entity MedExRec

Shows the review fee of the medical examination.


Entity Attribute Remarks of the Entity MedExRec

Card of Attribute Remarks of the Entity MedExRec

Name

Remarks

Code

Remarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity MedExRec

Store remarks.


Entity Attribute Follow up Date of the Entity MedExRec

Card of Attribute Follow up Date of the Entity MedExRec

Name

Follow up Date

Code

FollowUpDate

Data Type

date

Mandatory

No


Description of Attribute Follow up Date of the Entity MedExRec

Shows the follow-up date for the medical / award / discipline.
It is in the format: DD-MM-YYYY.


Previous
Home
Next