Entity MClaimPolicyRec

Description of Entity MClaimPolicyRec

A medical policy determines which type of claims an employee is able to submit and for how much. An employee can have more than 1 medical policy.If you are going to assign more than 1 policy to an employee, then you should check that each of the medical policies do not contain the same medical claim type, otherwise an error will result and you are prevented from doing so.


List of all Dependencies of the Entity MClaimPolicyRec

Name

Code

Class Name

Relation_244193

Relation_244193

Reference

Relation_244194

Relation_244194

Reference


List of Attributes of the Entity MClaimPolicyRec

Name

Code

Medical Claim Policy ID

MedClaimPolicyId

MedClaimPolicySysId

MedClaimPolicySysId

Category

MedClaimStringMatch

From

MedClaimPolicyFrom

To

MedClaimPolicyTo


Entity Attribute Medical Claim Policy ID of the Entity MClaimPolicyRec

Card of Attribute Medical Claim Policy ID of the Entity MClaimPolicyRec

Name

Medical Claim Policy ID

Code

MedClaimPolicyId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Medical Claim Policy ID of the Entity MClaimPolicyRec

Shows the identity of the medical claim policy. It also acts as a primary key for the MClaimPolicy table.
Example: Co. Medical Policy


Entity Attribute MedClaimPolicySysId of the Entity MClaimPolicyRec

Card of Attribute MedClaimPolicySysId of the Entity MClaimPolicyRec

Name

MedClaimPolicySysId

Code

MedClaimPolicySysId

Data Type

integer

Mandatory

Yes


Description of Attribute MedClaimPolicySysId of the Entity MClaimPolicyRec

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


Entity Attribute Category of the Entity MClaimPolicyRec

Card of Attribute Category of the Entity MClaimPolicyRec

Name

Category

Code

MedClaimStringMatch

Data Type

char(20)

Mandatory

No


Description of Attribute Category of the Entity MClaimPolicyRec

Shows which category the medical claim belongs to.
Example: Management / Non-Executive / ??? (Wildcard) etc


Entity Attribute From of the Entity MClaimPolicyRec

Card of Attribute From of the Entity MClaimPolicyRec

Name

From

Code

MedClaimPolicyFrom

Data Type

double

Mandatory

No


Description of Attribute From of the Entity MClaimPolicyRec

Shows the start date for the medical claim policy.
It is in the format: DD-MM-YYYY.


Entity Attribute To of the Entity MClaimPolicyRec

Card of Attribute To of the Entity MClaimPolicyRec

Name

To

Code

MedClaimPolicyTo

Data Type

double

Mandatory

No


Description of Attribute To of the Entity MClaimPolicyRec

Shows the end date for the medical claim policy.
It is in the format: DD-MM-YYYY.