Claims

Table Name Cla_ClaCor_Correspond_dtl

Table Comment This table hold the Claim Correspondence details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

ClaCor_Supplier_Remarks

varchar(20)

NULL

This field holds the Correspondence supplier remarks for a row

No

No

ClaCor_Claimant_Remarks

varchar(20)

NULL

This field holds the Correspondence claimant remarks for a row

No

No

ClaCor_Status

varchar(20)

NULL

This field holds the correspondence status

No

No

ClaCor_Reference

char(18)

NULL

This field holds the Correspondence reference

No

No

ClaCor_File_Name

varchar(20)

NULL

This field holds the file name of the multiline

No

No

ClaCor_Claim_No

varchar(20)

NOT NULL

The unique identifying reference allotted to the Claim. This is mandatory information.

Yes

Yes

ClaCor_OUInstance

int

NOT NULL

The Organization unit at which user has logged in the system, and created the Claim Details.

Yes

Yes

ClaCor_Category

varchar(20)

NULL

This field holds the Correspondence category for a row

No

No

ClaCor_Seq_No

int

NOT NULL

This field holds the Sequence number of correspondence multiline row

Yes

No

ClaCor_Corresp_Date

datetime

NULL

This field holds the Correspondence date

No

No

Table Name Cla_ClaDtl_Claim_Dtl

Table Comment Claim Detail table. This table stores the Claim details like part, quantity uom claim amount,accepted amount etc

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

ClaDtl_File_Name

varchar(20)

NULL

This field holds the file name of the claim details multiline

No

No

ClaDtl_Expense_Amt

int

NULL

This field holds the Expense amount for a part

No

No

ClaDtl_Claim_Remarks

varchar(20)

NULL

This field holds the remarks of the claim details multiline

No

No

ClaDtl_Uom

varchar(20)

NULL

This field holds the UOM of the part number in claim details multiline

No

No

ClaDtl_Process_Remarks

varchar(20)

NULL

This field holds the Process remarks for a part

No

No

ClaDtl_Claim_Amt

int

NULL

This field holds the Claim amount for a part

No

No

ClaDtl_Accepted_Amt

int

NULL

This field holds the Accepted amount for a part

No

No

ClaDtl_Process_Comments

varchar(20)

NULL

This field holds the Process comments for a part

No

No

ClaDtl_Claim_No

varchar(20)

NOT NULL

The unique identifying reference allotted to the Claim. This is mandatory information.

Yes

Yes

ClaDtl_Line_No

int

NOT NULL

This fields holds the line number of the Claims details multiline

Yes

No

ClaDtl_OUInstance

int

NOT NULL

The Organization unit at which user has logged in the system, and created the Claim Details.

Yes

Yes

ClaDtl_Quantity

int

NULL

This field holds the quantity of the multiline

No

No

ClaDtl_Part

varchar(20)

NULL

This field holds the part number of the claims details multiline

No

No

ClaDtl_Expense_cate

varchar(20)

NULL

This field holds the expense category for a claims details multiline

No

No

ClaDtl_Particulars

varchar(20)

NULL

This field holds the particulars of the claims details multiline

No

No

ClaDtl_Ref_No

varchar(20)

NULL

This fields holds the reference number of the claim details multline

No

No

Table Name Cla_ClaHdr_Claim_Hdr

Table Comment Claim Header table. This table stores the Claim no, Status and etc

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

ClaHrd_OUInstance

int

NOT NULL

The Organization unit at which user has logged in the system, and created the Claim Details.

Yes

No

ClaHrd_Claim_No

varchar(20)

NOT NULL

The unique identifying reference allotted to the Claim. This is mandatory information. Cannot be modified or deleted

Yes

No

ClaHrd_Desc

varchar(20)

NULL

This field holds the Claims Description

No

No

ClaHrd_Category

varchar(20)

NULL

The category to which the Claim is associated. The combo gets loaded with values defined in quick codes. Category value can be changed

No

No

ClaHrd_Status

varchar(20)

NULL

Sets status of Claims as: Active (A) or Inactive (I) Status value can be reset.

No

No

ClaHrd_Numbering_Type

char(18)

NULL

This field holds the numbering type selected for Claim Number

No

No

ClaHrd_Claim_DateTime

datetime

NULL

This field holds the Claim Date and time

No

No

ClaHrd_Initiated_by

varchar(20)

NULL

This field holds the User name who Initiated the claim

No

No

ClaHrd_Initiated_DateTime

datetime

NULL

This field holds the Initiated Date time

No

No

ClaHrd_User_Status

varchar(20)

NULL

This field holds the User status

No

No

ClaHrd_Implications

varchar(20)

NULL

This field holds the claims implications. Combo values loaded from claim quick code table

No

No

ClaHrd_Ref_DocNo

varchar(20)

NULL

This field holds the Reference document number for the claim

No

No

ClaHrd_Ref_Doc_Date

datetime

NULL

This field holds the Reference document date

No

No

ClaHrd_Ref_Details

varchar(20)

NULL

This field holds the Reference Details of the claim

No

No

ClaHrd_Contract_RefNO

varchar(20)

NULL

This fields holds the Contract Reference number of the claims

No

No

ClaHrd_Contract_Date

datetime

NULL

This fields holds the Contract Reference date of the claims

No

No

ClaHrd_Addl_Ref

varchar(20)

NULL

This fields holds the Addl. References of the claims

No

No

ClaHrd_Audit_Reqd

varchar(20)

NULL

This fields holds the Audit required flag Yes or NO

No

No

ClaHrd_Supplier

varchar(20)

NULL

This field holds the supplier of the claim

No

No

ClaHrd_Cont_Person_dtl

varchar(20)

NULL

This field holds the Contact person name

No

No

ClaHrd_Claim_Curr

char(18)

NULL

This field holds the Claim currency

No

No

ClaHrd_Expense_Curr

char(18)

NULL

This field holds the Expense currency

No

No

ClaHrd_Comments

char(18)

NULL

This field holds the comments of the claims

No

No

ClaHrd_File_Name

varchar(20)

NULL

This field holds the file names of the claims

No

No

ClaHrd_Regist_Comments

varchar(20)

NULL

This field holds the registration comments

No

No

ClaHrd_Ack_Ref

varchar(20)

NULL

This field holds the Acknowledgement reference

No

No

ClaHrd_Ack_Ref_DateTime

datetime

NULL

This field holds the Acknowledgment Reference datetime

No

No

ClaHrd_Processed_by

char(18)

NULL

This field holds the Processed by of a claim

No

No

ClaHrd_Payment_Ref

varchar(20)

NULL

This field holds the Payment reference of the claim

No

No

ClaHrd_Payment_Date

datetime

NULL

This field holds the Payment date of the claim

No

No

ClaHrd_Payment_Comments

varchar(20)

NULL

This field holds the Payment comments of the claim

No

No

ClaHrd_Release_Comments

varchar(20)

NULL

This field holds the Release comments of the claim

No

No

ClaHrd_Acc_Rej_Comments

varchar(20)

NULL

This field holds the Accepted or Rejected comments

No

No

ClaHrd_Created_By

varchar(20)

NULL

Name of the login user who created the Claims information.

No

No

ClaHrd_Created_date

datetime

NULL

This field holds the Date on which the Claims information is created.

No

No

ClaHrd_Modified_By

varchar(20)

NULL

Name of the login user who is the last to modify respective claims information.

No

No

ClaHrd_Modified_Date

datetime

NULL

The last date on which the particular claims information was modified.

No

No

ClaHrd_Registered_by

varchar(20)

NULL

This field holds the registered by of the claims

No

No

ClaHrd_Registered_Date

datetime

NULL

This field holds the registered date of the claims

No

No

ClaHrd_Released_By

varchar(20)

NULL

This field holds the Released by of the claim

No

No

ClaHrd_Released_Date

datetime

NULL

This field holds the Released date of the claim

No

No

ClaHrd_Closed_by

varchar(20)

NULL

This field holds the closed by of the claim

No

No

ClaHrd_Closed_Date

datetime

NULL

This field holds the closed date information of the claim

No

No

ClaHrd_Timestamp

int

NULL

This field holds the timestamp so that more than one user cant modified same record in the same time

No

No

Table Name Cla_ClaPrm_parameter_dtl

Table Comment Stores Parameter detail information.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

ClaPrm_ComponentName

varchar(20)

NOT NULL

This field holds the Component Code which table belongs to

Yes

No

ClaPrm_ParamCategory

varchar(20)

NOT NULL

This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.

Yes

No

ClaPrm_ParamType

varchar(20)

NOT NULL

Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.

Yes

No

ClaPrm_ParamCode

varchar(20)

NOT NULL

Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component

Yes

No

ClaPrm_Langid

int

NOT NULL

Language id. This is the language id of the record.

Yes

No

ClaPrm_ParamDesc

varchar(20)

NULL

This field holds the description of the Param Code

No

No

ClaPrm_sort_by

int

NULL

The order in which the values are populated.

No

No

ClaPrm_CreationDate

datetime

NULL

This field holds the record creation date

No

No

Table Name Cla_ClaQcd_Quick_Code_Dtl

Table Comment Quick Code details table. Stores the quick codes defined for all the quick code types

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

ClaQcd_OUInstance

int

NOT NULL

The Organization unit at which user has logged in the system, and created the Claim details.

Yes

Yes

ClaQcd_Type

varchar(20)

NOT NULL

The applicable values for this filter are: Load the Quick Code Type combo with the values "Claim Category" (CLCAT) "Claim User Status " (CLURS) "Claim Implication" (CLIMP) "Expense Category" (EXCAT) "Correspondence Category" (CORCA) "Correspondence Status" (CORST) These values would be Pre defined

Yes

Yes

ClaQcd_Quick_Code

varchar(20)

NOT NULL

Any user enterable value that is to be associated with the above mentioned quick code type.

Yes

No

ClaQcd_Desc

varchar(20)

NULL

A brief description on that quick code

No

No

ClaQcd_Default_flag

varchar(20)

NULL

Provision to set the quick code as default for the quick code type selected above. This default value will be loaded automatically in the quick code type combo, in all the User Interfaces where it is used. This default value can later be reset, and some other quick code value could be made as default for the selected quick code type. Only one quick code could be set as default for each quick code type.

No

No

ClaQcd_Status

varchar(20)

NULL

Enables to set the selected quick code value as Active (A) or Inactive (I). Only active quick code values would be made available for quick code types during transactions Can be reset again.

No

No

ClaQcd_CreatedDate

datetime

NULL

Date on which Quick Code was created

No

No

ClaQcd_Created_By

varchar(20)

NULL

User who has created the Quick Code

No

No

ClaQcd_ModifiedDate

datetime

NULL

Date on which Quick code was modified

No

No

ClaQcd_Modified_By

varchar(20)

NULL

User who has modified the quick code

No

No

ClaQcd_Timestamp

int

NULL

This field holds the timestamp so that more than one user cant modified same record in the same time

No

No

Table Name Cla_ClaQch_Quick_Code_Hdr

Table Comment Quick Code Header table. This table stores mandatory flag for all the Quick code types

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

ClaQch_OUInstance

int

NOT NULL

The Organization unit at which user has logged in the system, and created the Claim details.

Yes

No

ClaQch_Type

varchar(20)

NOT NULL

The applicable values for this filter are: Load the Quick Code Type combo with the values "Claim Category", "Claim User Status ", "Claim Implication", "Expense Category", "Correspondence Category", "Correspondence Status" and " Ref. Doc Type " These values would be Pre defined

Yes

No

LibQch_Mandatory_Flag

varchar(20)

NULL

This field holds the mandatory "Yes" or "No" flag. Provision to set whether the Quick Code Type selected in header combo should be Mandatory or Non-mandatory, for the different User-Interfaces, in insurance Claim. The system would ensure that the Quick Code values of all the mandatory quick code types are specified during any transactions. Can be reset again.

No

No

ClaQch_Updated_Date

datetime

NULL

This field holds the date on which Quick code was modified

No

No

ClaQch_Updated_By

varchar(20)

NULL

This field holds the user who has modified the quick code

No

No

ClaQch_Timestamp

int

NULL

This field holds the timestamp so that more than one user cant modified same record in the same time

No

No

Table Name Cla_ClaRef_Reference_Dtl

Table Comment This table hold the Claim’s Reference details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

ClaRef_Document_ID

varchar(20)

NULL

This field holds the Document ID

No

No

ClaRef_Ref_Doc_Type

char(18)

NULL

This field holds the Reference document type

No

No

ClaRef_File_Name

varchar(20)

NULL

This field holds the File Name of reference details multiline

No

No

ClaRef_Remarks

char(18)

NULL

This field holds the Remarks of the reference details multiline

No

No

ClaRef_OUInstance

int

NOT NULL

The Organization unit at which user has logged in the system, and created the Claim Details.

Yes

Yes

ClaRef_Seq_No

int

NOT NULL

This field holds the Sequence number of the reference details multilne

Yes

No

ClaRef_Claim_No

varchar(20)

NOT NULL

The unique identifying reference allotted to the Claim. This is mandatory information.

Yes

Yes