ID

19463

Descripción

OMOP Common Data Model (CDM) Payer Plan Period The PAYER_PLAN_PERIOD table captures records that detail the period of time that a person is continuously enrolled under a specific health plan benefit structure from a given payer. Each Person receiving health care and covered by a health benefits is subject to a Plan defined by the Payer for the Person or her family. For a given benefit policy, there may be one or more Plans that are active for certain periods of time (e.g. before and after the deductible is reached), determining the cost of health services provided. The Observational Medical Outcomes Partnership (OMOP) was a public-private partnership established to inform the appropriate use of observational healthcare databases for studying the effects of medical products. © 2014 Observational Health Data Sciences and Informatics This work is based on work by the Observational Medical Outcomes Partnership (OMOP) and used under license from the FNIH at http://omop.fnih.org/publiclicense.

Link

http://omop.fnih.org/publiclicense

Palabras clave

  1. 4/1/17 4/1/17 -
  2. 13/3/19 13/3/19 -
Subido en

4 de enero de 2017

DOI

Para solicitar uno, por favor iniciar sesión.

Licencia

Creative Commons BY-NC 3.0

Comentarios del modelo :

Puede comentar sobre el modelo de datos aquí. A través de las burbujas de diálogo en los grupos de elementos y elementos, puede agregar comentarios específicos.

Comentarios de grupo de elementos para :

Comentarios del elemento para :

Para descargar modelos de datos, debe haber iniciado sesión. Por favor iniciar sesión o Registrate gratis.

OMOP Common Data Model (CDM) Payer Plan Period

OMOP Common Data Model (CDM) Payer Plan Period

Payer Plan Period
Descripción

Payer Plan Period

Alias
UMLS CUI-1
C2348942
UMLS CUI-2
C0015576
UMLS CUI-3
C1301732
UMLS CUI-4
C1948053
Payer plan period ID
Descripción

An identifier for each unique combination of payer, plan, family code and time span.

Tipo de datos

integer

Alias
UMLS CUI [1,1]
C2348942
UMLS CUI [1,2]
C0015576
UMLS CUI [1,3]
C1301732
UMLS CUI [1,4]
C1948053
UMLS CUI [1,5]
C1300638
Person ID
Descripción

A foreign key identifier to the person covered by the payer. The demographic details of that person are stored in the person table.

Tipo de datos

integer

Alias
UMLS CUI [1]
C2348585
Payer Plan Period start date
Descripción

The start date of the payer plan period.

Tipo de datos

date

Alias
UMLS CUI [1,1]
C0680264
UMLS CUI [1,2]
C1301732
UMLS CUI [1,3]
C1948053
UMLS CUI [1,4]
C0011008
Payer Plan Period end date
Descripción

The end date of the payer plan period.

Tipo de datos

date

Alias
UMLS CUI [1,1]
C0680264
UMLS CUI [1,2]
C1301732
UMLS CUI [1,3]
C1948053
UMLS CUI [1,4]
C0011008
Payer source value
Descripción

The source code for the payer as it appears in the source data.

Tipo de datos

text

Alias
UMLS CUI [1,1]
C2348942
UMLS CUI [1,2]
C0449416
Plan source value
Descripción

The source code for the person's coverage plan as it appears in the source data.

Tipo de datos

text

Alias
UMLS CUI [1,1]
C1301732
UMLS CUI [1,2]
C0449416
Family source value
Descripción

The source code for the person's family as it appears in the source data.

Tipo de datos

text

Alias
UMLS CUI [1,1]
C0015576
UMLS CUI [1,2]
C0449416

Similar models

OMOP Common Data Model (CDM) Payer Plan Period

Name
Tipo
Description | Question | Decode (Coded Value)
Tipo de datos
Alias
Item Group
Payer Plan Period
C2348942 (UMLS CUI-1)
C0015576 (UMLS CUI-2)
C1301732 (UMLS CUI-3)
C1948053 (UMLS CUI-4)
Payer plan period ID
Item
Payer plan period ID
integer
C2348942 (UMLS CUI [1,1])
C0015576 (UMLS CUI [1,2])
C1301732 (UMLS CUI [1,3])
C1948053 (UMLS CUI [1,4])
C1300638 (UMLS CUI [1,5])
Person ID
Item
Person ID
integer
C2348585 (UMLS CUI [1])
Payer Plan Period start date
Item
Payer Plan Period start date
date
C0680264 (UMLS CUI [1,1])
C1301732 (UMLS CUI [1,2])
C1948053 (UMLS CUI [1,3])
C0011008 (UMLS CUI [1,4])
Payer Plan Period end date
Item
Payer Plan Period end date
date
C0680264 (UMLS CUI [1,1])
C1301732 (UMLS CUI [1,2])
C1948053 (UMLS CUI [1,3])
C0011008 (UMLS CUI [1,4])
Payer source value
Item
Payer source value
text
C2348942 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
Plan source value
Item
Plan source value
text
C1301732 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
Family source value
Item
Family source value
text
C0015576 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])

Utilice este formulario para comentarios, preguntas y sugerencias.

Los campos marcados con * son obligatorios.

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial