Entity MClaimTypeRange

Description of Entity MClaimTypeRange

The range of the medical claim. This controls the eligibility of each medical claim type, i.e. a type of medical claim that is limited to a specific department. You cannot change this after saving it as the range basis. This is also the variable that controls the eligibility, i.e. hazardous jobs may have a higher medical claim amount or limit.


List of all Dependencies of the Entity MClaimTypeRange

Name

Code

Class Name

Relation_237990

Relation_237990

Reference


List of Attributes of the Entity MClaimTypeRange

Name

Code

MedClaimTypeSysId

MedClaimTypeSysId

Category

MedClaimStringMatch

MedClaimRangeFrom

MedClaimRangeFrom

MedClaimRangeTo

MedClaimRangeTo

Co Payment Type (Company)

CoPaymentType

Percentage or Fixed Amount

CoPaymentAmtPercent

Amount Limit Per Claim

LimitPerClaim


Entity Attribute MedClaimTypeSysId of the Entity MClaimTypeRange

Card of Attribute MedClaimTypeSysId of the Entity MClaimTypeRange

Name

MedClaimTypeSysId

Code

MedClaimTypeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute MedClaimTypeSysId of the Entity MClaimTypeRange

A system generated identity. It is blind to the user. This also acts as a primary key for the MClaimTypeRange table.


Entity Attribute Category of the Entity MClaimTypeRange

Card of Attribute Category of the Entity MClaimTypeRange

Name

Category

Code

MedClaimStringMatch

Data Type

char(20)

Mandatory

No


Description of Attribute Category of the Entity MClaimTypeRange

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


Entity Attribute MedClaimRangeFrom of the Entity MClaimTypeRange

Card of Attribute MedClaimRangeFrom of the Entity MClaimTypeRange

Name

MedClaimRangeFrom

Code

MedClaimRangeFrom

Data Type

double

Mandatory

No


Description of Attribute MedClaimRangeFrom of the Entity MClaimTypeRange

Shows the starting range of the medical claim.


Entity Attribute MedClaimRangeTo of the Entity MClaimTypeRange

Card of Attribute MedClaimRangeTo of the Entity MClaimTypeRange

Name

MedClaimRangeTo

Code

MedClaimRangeTo

Data Type

double

Mandatory

No


Description of Attribute MedClaimRangeTo of the Entity MClaimTypeRange

Shows the end range of the medical claim.


Entity Attribute Co Payment Type (Company) of the Entity MClaimTypeRange

Card of Attribute Co Payment Type (Company) of the Entity MClaimTypeRange

Name

Co Payment Type (Company)

Code

CoPaymentType

Data Type

smallint

Mandatory

No


Description of Attribute Co Payment Type (Company) of the Entity MClaimTypeRange

Shows the payment type, in a form of radio buttons.
Example: No Co Payment / Percentage / Fixed Amount


Entity Attribute Percentage or Fixed Amount of the Entity MClaimTypeRange

Card of Attribute Percentage or Fixed Amount of the Entity MClaimTypeRange

Name

Percentage or Fixed Amount

Code

CoPaymentAmtPercent

Data Type

double

Mandatory

No


Description of Attribute Percentage or Fixed Amount of the Entity MClaimTypeRange

Shows the percentage/amount of the co payment. It will appear if you have chosen the Percentage / Fixed Amount radio button from the CoPaymentType attribute.


Entity Attribute Amount Limit Per Claim of the Entity MClaimTypeRange

Card of Attribute Amount Limit Per Claim of the Entity MClaimTypeRange

Name

Amount Limit Per Claim

Code

LimitPerClaim

Data Type

double

Mandatory

No


Description of Attribute Amount Limit Per Claim of the Entity MClaimTypeRange

Shows the amount limit per claim. (Zero is for no limit)