Claims Claimant Log Query Feed (Excel Only)

Policy effective date.

Policy producer name.

Policyholder name.

Policy contract number.

Policyholder state.

Policy carrier name.

Policy underwriting treaty.

Underwriting treaty year.

Name of the individual making the claim.

Diagnosis code and description for the claim.

Claim ID number.

Whether or not the claim triggers a notice.

Specific deductible for the claim.

Deductible if the claimant is lasered.

Maximum specific benefit for the claimant.

Contract type for the specific policy.

When the claim was received

When the claim was reserved.

When the claim was paid.

Amount the TPA was paid on the claim.

Requested amount for the claim.

Amount denied on the claim.

Amount pending on the claim.

Percent excess reimbursement.

Pending reimbursement.

Claim reimbursement amount.

Outstanding amount on the claim.

Reserve amount available.

Aggregating Specific deductible.

Total amount of aggregating specific deductible applied to the claim.

Amount of aggregating specific deductible used on the claim.

Claim administrator name.

PPO network name.