Entity MClaimType

Description of Entity MClaimType

Medical claims are classified into various types.
Example: Dental, Hospital etc


List of all Dependencies of the Entity MClaimType

Name

Code

Class Name

Relation_237990

Relation_237990

Reference

Relation_244194

Relation_244194

Reference

Relation_247268

Relation_247268

Reference


List of Attributes of the Entity MClaimType

Name

Code

Medical Claim Type ID

MedClaimTypeId

Description

MedClaimTypeDesc

Range Basis

MedClaimRangeBasis

Limit Per Cycle

LimitPerCycle

Pay Element ID

PayrollPayElementId

Claim Function As

MedClaimFunctionId

Limit No of Claims per Policy

SubjNoPerPolicy

ProrateMethod

ProrateMethod

Prorate newly hire employee

ProrateHire

Prorate terminated employee

ProrateCessation

LimitPerCycleType

LimitPerCycleType

LimitPerCycleKeyword

LimitPerCycleKeyword


Entity Attribute Medical Claim Type ID of the Entity MClaimType

Card of Attribute Medical Claim Type ID of the Entity MClaimType

Name

Medical Claim Type ID

Code

MedClaimTypeId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Medical Claim Type ID of the Entity MClaimType

Shows the identity of the type of medical claim. It holds the primary key for the MClaimType table.
Example: OutPatient / Medical / Dental Surgery etc


Entity Attribute Description of the Entity MClaimType

Card of Attribute Description of the Entity MClaimType

Name

Description

Code

MedClaimTypeDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity MClaimType

Stores the description about the medical claim.
Example: Out-patient claims / Medical claims / Dental surgery claims etc


Entity Attribute Range Basis of the Entity MClaimType

Card of Attribute Range Basis of the Entity MClaimType

Name

Range Basis

Code

MedClaimRangeBasis

Data Type

char(20)

Mandatory

No


Description of Attribute Range Basis of the Entity MClaimType

Shows the range basis for the medical claim. This is the variable that controls the eligibility. Hazardous jobs may have a higher medical claim amount or limit.
Example: Category / Marital Status / Position etc


Entity Attribute Limit Per Cycle of the Entity MClaimType

Card of Attribute Limit Per Cycle of the Entity MClaimType

Name

Limit Per Cycle

Code

LimitPerCycle

Data Type

double

Mandatory

No


Description of Attribute Limit Per Cycle of the Entity MClaimType

Shows the limit per cycle.
Example: Fixed / Factor


Entity Attribute Pay Element ID of the Entity MClaimType

Card of Attribute Pay Element ID of the Entity MClaimType

Name

Pay Element ID

Code

PayrollPayElementId

Data Type

char(20)

Mandatory

No


Description of Attribute Pay Element ID of the Entity MClaimType

Shows the identity of the pay element.
Example:
INCO = Income Tax Deduction / Withheld
NOIL = Notice in Lieu Deductions
NATI = National Service Pay
COMC = Community Chest
etc

or

Transport and/or Medical Claims for the Training entity.


Entity Attribute Claim Function As of the Entity MClaimType

Card of Attribute Claim Function As of the Entity MClaimType

Name

Claim Function As

Code

MedClaimFunctionId

Data Type

char(20)

Mandatory

No


Description of Attribute Claim Function As of the Entity MClaimType

Shows the identity of the medical claim function.
Example: Medical / Hospital / Dental etc


Entity Attribute Limit No of Claims per Policy of the Entity MClaimType

Card of Attribute Limit No of Claims per Policy of the Entity MClaimType

Name

Limit No of Claims per Policy

Code

SubjNoPerPolicy

Data Type

smallint

Mandatory

No


Description of Attribute Limit No of Claims per Policy of the Entity MClaimType

Indicates the limit for the number of claims per policy, in a form of a checkbox.


Entity Attribute ProrateMethod of the Entity MClaimType

Card of Attribute ProrateMethod of the Entity MClaimType

Name

ProrateMethod

Code

ProrateMethod

Data Type

char(20)

Mandatory

No


Description of Attribute ProrateMethod of the Entity MClaimType

Displays the prorate method for the medical claim type.
Example: None / Calendar Days / Working Calendar Days


Entity Attribute Prorate newly hire employee of the Entity MClaimType

Card of Attribute Prorate newly hire employee of the Entity MClaimType

Name

Prorate newly hire employee

Code

ProrateHire

Data Type

smallint

Mandatory

No


Description of Attribute Prorate newly hire employee of the Entity MClaimType

Indicates if the medical claim will prorate the newly hired employees, in a form of a checkbox.


Entity Attribute Prorate terminated employee of the Entity MClaimType

Card of Attribute Prorate terminated employee of the Entity MClaimType

Name

Prorate terminated employee

Code

ProrateCessation

Data Type

smallint

Mandatory

No


Description of Attribute Prorate terminated employee of the Entity MClaimType

Indicates if the medical claim will prorate the terminated employees, in a form of a checkbox.


Entity Attribute LimitPerCycleType of the Entity MClaimType

Card of Attribute LimitPerCycleType of the Entity MClaimType

Name

LimitPerCycleType

Code

LimitPerCycleType

Data Type

char(20)

Mandatory

No


Description of Attribute LimitPerCycleType of the Entity MClaimType

Shows the type of limit per cycle.
Example: Fixed / Factor


Entity Attribute LimitPerCycleKeyword of the Entity MClaimType

Card of Attribute LimitPerCycleKeyword of the Entity MClaimType

Name

LimitPerCycleKeyword

Code

LimitPerCycleKeyword

Data Type

char(20)

Mandatory

No


Description of Attribute LimitPerCycleKeyword of the Entity MClaimType

Shows the keyword for the limit per cycle.