Data dictionary › Insurance, eligibility & authorizations

MC_PLAN_DETAILS

Population

File
data/MC_PLAN_DETAILS.csv
Category
reference
Primary key
VISIT_CLASS, COMPANY_CODE
Columns
9

01Relates to the patient

reference data (no patient link)

Single-patient export: not included (not referenced by patient records).

02References

  • COPAY_CODE, CODING_METHOD → PROCEDURES.PROC_CODE, CODING_METHOD
  • PROC_GROUP_CODE → PROC_GROUPS.PROC_GROUP_CODE
  • COMPANY_CODE → MC_PLANS.COMPANY_CODE

03Columns

#ColumnTypeSource typeNullNotes
1VISIT_CLASS PKstringvarchar(15)no
2AUTH_REQstringchar(1)yes
3REF_REQstringchar(1)yes
4COVEREDstringchar(1)yes
5ALWAYS_COPAYstringchar(1)yes
6COPAY_CODEstringvarchar(20)yes
7CODING_METHODstringvarchar(5)yes
8COMPANY_CODE PKstringvarchar(20)no
9PROC_GROUP_CODEstringvarchar(15)yes