Coverage

Introduction #

The Coverage model represents insurance coverage linked to Patients. Coverages are linked to Patient instances, as well as Transactor instances, which represent the issuer for the corresponding coverage.

Usage #

The Coverage model can be used to find all of the coverages defined in a Canvas instance, whether overall or for a particular patient. For example, to find all of the current coverages for a patient, the Patient.coverages method can be used:

>>> import arrow
>>> from canvas_sdk.v1.data.patient import Patient
>>> patient_1 = Patient.objects.get(id="a74592ae8a6c4d0ebe0799d3fb3713d1")
>>> patient_1_current_coverages = patient_1.coverages.filter(coverage_end_date__gt=arrow.now().date().isoformat())
>>> print([coverage.issuer.name for coverage in patient_1_current_coverages])
['AVALON HEALTHCARE SOLUTIONS CAPITAL BLUE CROSS']

Alternatively, to find all of the Coverage instances issed by a particular issuer/transactor, the Transactor model can be queried:

>>> from canvas_sdk.v1.data.coverage import Coverage, Transactor
>>> transactor_1 = Transactor.objects.get(payer_id="AVA03")
transactor_coverages = Coverage.objects.filter(issuer=transactor_1)
>>> print(transactor_coverages)
<QuerySet [<Coverage: id=89793979-dbff-4a53-b928-75db973c2bdc>, <Coverage: id=423c0f77-8083-4cc1-8e29-2c7d348281e4>]>
>>>

Filtering #

The filter method can be used to filter by desired attributes. The following examples show commonly used operations to filter coverage data:

Show a Patient’s Coverages in order of Rank (Primary, Secondary, etc.)

>>> from canvas_sdk.v1.data.patient import Patient
>>> patient_1 = Patient.objects.get(id="aebe4d3f5d18410388dc69c4b5169fc3")
>>> patient_coverages = patient_1.coverages.all().order_by("coverage_rank")
>>> print([(coverage.issuer.name, coverage.coverage_rank,) for coverage in patient_coverages])
[('AVALON HEALTHCARE SOLUTIONS CAPITAL BLUE CROSS', 1), ('Blue Cross Blue Shield of Arizona Advantage', 2)]

Find All Expired Coverages

>>> import arrow
>>> from canvas_sdk.v1.data.coverage import Coverage
>>> expired_coverages = Coverage.objects.filter(coverage_end_date__lt=arrow.now().date().isoformat())
>>> print([f"{coverage.issuer.name} expired {coverage.coverage_end_date.isoformat()}" for coverage in expired_coverages])
['Blue Cross Blue Shield of Arizona Advantage expired 2025-01-10']

Attributes #

Coverage #

Field NameType
idUUID
dbidInteger
createdDateTime
modifiedDateTime
patientPatient
guarantorPatient
subscriberPatient
patient_relationship_to_subscriberCoverageRelationshipCode
issuerTransactor
id_numberString
planString
sub_planString
groupString
sub_groupString
employerString
coverage_start_dateDate
coverage_end_dateDate
coverage_rankInteger
stateCoverageState
plan_typeCoverageType
coverage_typeTransactorCoverageType
issuer_addressTransactorAddress
issuer_phoneTransactorPhone
commentsText
stackCoverageStack

Transactor #

Field NameType
dbidInteger
payer_idString
nameString
typeString
transactor_typeTransactorType
clearinghouse_payerBoolean
institutionalBoolean
institutional_enrollment_reqBoolean
professionalBoolean
professional_enrollment_reqBoolean
eraBoolean
era_enrollment_reqBoolean
eligibilityBoolean
eligibility_enrollment_reqBoolean
workers_compBoolean
secondary_supportBoolean
claim_feeBoolean
remit_feeBoolean
stateString
descriptionString
activeBoolean
use_provider_for_eligibilityBoolean
use_for_submissionTransactor
used_for_submission_byTransactor[]
coverage_typesTransactorCoverageType[]
addressesTransactorAddress[]
coveragesCoverage[]
phonesTransactorPhone[]

TransactorAddress #

Field NameType
idUUID
dbidInteger
createdDateTime
modifiedDateTime
line1String
line2String
cityString
districtString
state_codeString
postal_codeString
useAddressUse
typeAddressType
longitudeFloat
latitudeFloat
startDate
endDate
countryString
stateAddressState
transactorTransactor
coveragesCoverage[]

TransactorPhone #

Field NameType
idUUIDField
dbidInteger
createdDateTime
modifiedDateTime
systemString
valueString
useContactPointUse
use_notesString
rankInteger
stateContactPointState
transactorTransactor
coveragesCoverage[]

Enumeration types #

CoverageStack #

ValueLabel
IN_USEIn use
OTHEROther
REMOVEDRemoved

CoverageState #

ValueLabel
activeActive
deletedDeleted

CoverageType #

ValueLabel
commercialCommercial
workerscompWorkers Comp
bcbsBlue Cross Blue Shield
champusTricare/Champus
medicaidMedicaid
medicareMedicare
otherOther
tpaThird Party Administrator
motorvehicleMotor Vehicle
lienAttorney/Lien
pipPersonal Injury

CoverageRelationshipCode #

ValueLabel
18Self
01Spouse
19Natural Child, insured has financial responsibility
43Natural Child, insured does not have financial responsibility
17Step Child
10Foster Child
15Ward of the Court
20Employee
21Unknown
22Handicapped Dependent
39Organ donor
40Cadaver donor
05Grandchild
07Niece/Nephew
41Injured Plaintiff
23Sponsored Dependent
24Minor Dependent of a Minor Dependent
32Mother
33Father
04Grandparent
53Life Partner
29Significant Other
G8Other

TransactorCoverageType #

ValueLabel
ANNUannuity policy
AUTOPOLautomobile
CHARcharity program
COLcollision coverage policy
CRIMEcrime victim program
DENTALdental care policy
DENTPRGdental program
DISdisability insurance policy
DISEASEdisease specific policy
DRUGPOLdrug policy
EAPemployee assistance program
EWBemployee welfare benefit plan policy
ENDRENALend renal program
EHCPOLextended healthcare
FLEXPflexible benefit plan policy
GOVEMPgovernment employee health program
HIPhealth insurance plan policy
HMOhealth maintenance organization policy
HSAPOLhealth spending account
HIRISKhigh risk pool program
HIVAIDSHIV-AIDS program
INDindigenous peoples health program
LIFElife insurance policy
LTClong term care policy
MCPOLmanaged care policy
MANDPOLmandatory health program
MENTPOLmental health policy
MENTPRGmental health program
MILITARYmilitary health program
payPay
POSpoint of service policy
PPOpreferred provider organization policy
PNCproperty and casualty insurance policy
DISEASEPRGpublic health program
PUBLICPOLpublic healthcare
REIreinsurance policy
RETIREretiree health program
SAFNETsafety net clinic program
SOCIALsocial service program
SUBSIDIZsubsidized health program
SUBSIDMCsubsidized managed care program
SUBSUPPsubsidized supplemental health program
SUBPOLsubstance use policy
SUBPRGsubstance use program
SURPLsurplus line insurance policy
TLIFEterm life insurance policy
UMBRLumbrella liability insurance policy
UNINSMOTuninsured motorist policy
ULIFEuniversal life insurance policy
VETveteran health program
VISPOLvision care policy
CANPRGwomen’s cancer detection program
WCBPOLworker’s compensation

TransactorType #

ValueLabel
commercialCommercial
workerscompWorkers Comp
champusTricare/Champus
medicaidMedicaid
medicareMedicare
medicare_advantageMedicare Advantage
CHIPCHIP
automobileAutomobile
employerEmployer
direct_careDirect Care
bcbsBlue Cross Blue Shield