payer_plan_period

Standardized Health Economics data Table, currently empty

Table Columns

field	type	required	phi	phi scrubbing operation
payer_plan_period_id	INTEGER	Yes		Not Stable between Data Refreshes
person_id	INTEGER	Yes		Sub
payer_plan_period_start_date	DATE	Yes	Yes	Jitt
payer_plan_period_end_date	DATE	Yes	Yes	Jitt
payer_concept_id	INTEGER	Yes
payer_source_value	STRING	No	Yes
payer_source_concept_id	INTEGER	Yes
plan_concept_id	INTEGER	Yes
plan_source_value	STRING	No	Yes	Del
plan_source_concept_id	INTEGER	Yes
sponsor_concept_id	INTEGER	Yes
sponsor_source_value	STRING	No
sponsor_source_concept_id	INTEGER	Yes
family_source_value	STRING	No	Yes
stop_reason_concept_id	INTEGER	Yes
stop_reason_source_value	STRING	No	Yes
stop_reason_source_concept_id	INTEGER	Yes

Columns Description

payer_plan_period_id

A unique identifier for each unique combination of a Person, Payer, Plan, and Period of time.

person_id

The Person covered by the Plan. The demographic details of that Person are stored in the PERSON table.

payer_plan_period_start_date

The start date of the payer plan period.

payer_plan_period_end_date

The end date of the payer plan period.

payer_concept_id

This field represents the organization who reimburses the provider which administers care to the Person. This field refers to a standard Payer concept identifier in the Standarized Vocabularies.

payer_source_value

The source code for the payer as it appears in the source data. Currently it is “payer_ SOPT Desc | SOPT ID | Epic Payer Name| Epic Payor ID | Epic Financial Class Name | Epic Financial Class ID”. SOPT is the payer type standard that provides a mechanism for consistent reporting of payer data to public health agencies for health care services and research

payer_source_concept_id

A foreign key to a payer concept that refers to the code used in the source. It is the OMOP concept id corresponding to the source code.

plan_concept_id

A foreign key that refers to a standard plan concept identifier that represents the health benefit plan in the Standardized Vocabularies.

plan_source_value

The source code for the Person’s health benefit plan as it appears in the source data. Currently it is “Epic Plan Name| Epic Plan ID”.

plan_source_concept_id

A foreign key to a plan concept that refers to the plan code used in the source data.

sponsor_concept_id

A foreign key that refers to a concept identifier that represents the sponsor in the Standardized Vocabularies.

sponsor_source_value

The source code for the Person’s sponsor of the health plan as it appears in the source data.

sponsor_source_concept_id

A foreign key to a sponsor concept that refers to the sponsor code used in the source data.

family_source_value

The source code for the Person’s family as it appears in the source data.

stop_reason_concept_id

A foreign key that refers to a standard termination reason that represents the reason for the termination in the Standardized Vocabularies.

stop_reason_source_value

The reason for stop-coverage as it appears in the source data.

stop_reason_source_concept_id

A foreign key to a stop-coverage concept that refers to the code used in the source