Engels

Payer Plan Period

1 Formulieren  
  1. StudyEvent: ODM
    1. Payer Plan Period
Payer Plan Period
Beschrijving

Payer Plan Period

Alias
UMLS CUI-1
C2348942
UMLS CUI-2
C0018684
UMLS CUI-3
C0814225
UMLS CUI-4
C1301732
UMLS CUI-5
C1948053
Payer plan period ID
Beschrijving

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

Datatype

integer

Alias
UMLS CUI [1,1]
C2348942
UMLS CUI [1,2]
C1301732
UMLS CUI [1,3]
C1948053
UMLS CUI [1,4]
C1300638
Person ID
Beschrijving

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

Datatype

integer

Alias
UMLS CUI [1]
C2348585
Contract person ID
Beschrijving

A foreign key identifier to the person_id in person table, for the person who is the primary subscriber/contract owner for the record in the payer_plan_period table. Maybe the same person or different person, depending on who is the primary subscriber/contract owner. The contract_person_id is meant to refer to the owner of the plan, for instance, a parent who owns the plan under which the child is covered. Contract_person_id many times will be equal to person_id.

Datatype

integer

Alias
UMLS CUI [1,1]
C0332522
UMLS CUI [1,2]
C0027361
UMLS CUI [1,3]
C1300638
Payer Plan Period start date
Beschrijving

The start date of the payer plan period.

Datatype

date

Alias
UMLS CUI [1,1]
C0680264
UMLS CUI [1,2]
C1301732
UMLS CUI [1,3]
C1948053
UMLS CUI [1,4]
C0808070
Payer Plan Period end date
Beschrijving

The end date of the payer plan period.

Datatype

date

Alias
UMLS CUI [1,1]
C0680264
UMLS CUI [1,2]
C1301732
UMLS CUI [1,3]
C1948053
UMLS CUI [1,4]
C0806020
Payer concept ID
Beschrijving

A foreign key that refers to a standard Payer concept identifier in the Standarized Vocabularies

Datatype

integer

Alias
UMLS CUI [1,1]
C2348942
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Payer source value
Beschrijving

The source code for the payer as it appears in the source data. (Type varchar(50))

Datatype

text

Alias
UMLS CUI [1,1]
C2348942
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0805701
Payer source concept ID
Beschrijving

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

Datatype

integer

Alias
UMLS CUI [1,1]
C2348942
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Plan concept ID
Beschrijving

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

Datatype

integer

Alias
UMLS CUI [1,1]
C0018684
UMLS CUI [1,2]
C0814225
UMLS CUI [1,3]
C1301732
UMLS CUI [1,4]
C0178566
UMLS CUI [1,5]
C1300638
Plan source value
Beschrijving

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

Datatype

text

Alias
UMLS CUI [1,1]
C1301732
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0805701
Plan source concept ID
Beschrijving

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

Datatype

text

Alias
UMLS CUI [1,1]
C0018684
UMLS CUI [1,2]
C0814225
UMLS CUI [1,3]
C1301732
UMLS CUI [1,4]
C0449416
UMLS CUI [1,5]
C0178566
UMLS CUI [1,6]
C1300638
Contract concept ID
Beschrijving

A foreign key to a standard concept representing the reason justifying the contract between person_id and contract_person_id.

Datatype

integer

Alias
UMLS CUI [1,1]
C0332522
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Contract source value
Beschrijving

The source code representing the reason justifying the contract. Usually it is family relationship like a spouse, domestic partner, child etc.

Datatype

integer

Alias
UMLS CUI [1,1]
C0332522
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0805701
Contract source concept ID
Beschrijving

A foreign key to a concept that refers to the code used in the source as the reason justifying the contract.

Datatype

integer

Alias
UMLS CUI [1,1]
C0332522
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Sponsor concept IDSponsor concept ID
Beschrijving

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

Datatype

integer

Alias
UMLS CUI [1,1]
C1711305
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Sponsor source value
Beschrijving

The source code for the Person's sponsor of the health plan as it appears in the source data. (Type varchar(50))

Datatype

text

Alias
UMLS CUI [1,1]
C1711305
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0805701
Sponsor source concept ID
Beschrijving

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

Datatype

integer

Alias
UMLS CUI [1,1]
C1711305
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Family source value
Beschrijving

The source code for the person's family as it appears in the source data. (Type varchar(50))

Datatype

text

Alias
UMLS CUI [1,1]
C0015576
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0805701
Stop reason concept ID
Beschrijving

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

Datatype

integer

Alias
UMLS CUI [1,1]
C1283212
UMLS CUI [1,2]
C0566251
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Stop reason source value
Beschrijving

The reason for stop-coverage as it appears in the source data. (Type varchar(50))

Datatype

text

Alias
UMLS CUI [1,1]
C1283212
UMLS CUI [1,2]
C0566251
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C0805701
Stop reason source concept ID
Beschrijving

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

Datatype

text

Alias
UMLS CUI [1,1]
C1283212
UMLS CUI [1,2]
C0566251
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C0178566
UMLS CUI [1,5]
C1300638
Terug naar het begin van de pagina

Similar models

Payer Plan Period

1 Formulieren
  1. StudyEvent: ODM
    1. Payer Plan Period
Name
Type
Description | Question | Decode (Coded Value)
Datatype
Alias
Item Group
Payer Plan Period
C2348942 (UMLS CUI-1)
C0018684 (UMLS CUI-2)
C0814225 (UMLS CUI-3)
C1301732 (UMLS CUI-4)
C1948053 (UMLS CUI-5)
Payer plan period ID
Item
Payer plan period ID
integer
C2348942 (UMLS CUI [1,1])
C1301732 (UMLS CUI [1,2])
C1948053 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Person ID
Item
Person ID
integer
C2348585 (UMLS CUI [1])
Contract person ID
Item
Contract person ID
integer
C0332522 (UMLS CUI [1,1])
C0027361 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
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])
C0808070 (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])
C0806020 (UMLS CUI [1,4])
Payer concept ID
Item
Payer concept ID
integer
C2348942 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Payer source value
Item
Payer source value
text
C2348942 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0805701 (UMLS CUI [1,3])
Payer source concept ID
Item
Payer source concept ID
integer
C2348942 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Plan concept ID
Item
Plan concept ID
integer
C0018684 (UMLS CUI [1,1])
C0814225 (UMLS CUI [1,2])
C1301732 (UMLS CUI [1,3])
C0178566 (UMLS CUI [1,4])
C1300638 (UMLS CUI [1,5])
Plan source value
Item
Plan source value
text
C1301732 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0805701 (UMLS CUI [1,3])
Plan source concept ID
Item
Plan source concept ID
text
C0018684 (UMLS CUI [1,1])
C0814225 (UMLS CUI [1,2])
C1301732 (UMLS CUI [1,3])
C0449416 (UMLS CUI [1,4])
C0178566 (UMLS CUI [1,5])
C1300638 (UMLS CUI [1,6])
Contract concept ID
Item
Contract concept ID
integer
C0332522 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Contract source value
Item
Contract source value
integer
C0332522 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0805701 (UMLS CUI [1,3])
Contract source concept ID
Item
Contract source concept ID
integer
C0332522 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Sponsor concept ID
Item
Sponsor concept IDSponsor concept ID
integer
C1711305 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Sponsor source value
Item
Sponsor source value
text
C1711305 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0805701 (UMLS CUI [1,3])
Sponsor source concept ID
Item
Sponsor source concept ID
integer
C1711305 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Family source value
Item
Family source value
text
C0015576 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0805701 (UMLS CUI [1,3])
Stop reason concept ID
Item
Stop reason concept ID
integer
C1283212 (UMLS CUI [1,1])
C0566251 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Stop reason source value
Item
Stop reason source value
text
C1283212 (UMLS CUI [1,1])
C0566251 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C0805701 (UMLS CUI [1,4])
Stop reason source concept ID
Item
Stop reason source concept ID
text
C1283212 (UMLS CUI [1,1])
C0566251 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C0178566 (UMLS CUI [1,4])
C1300638 (UMLS CUI [1,5])
Terug naar het begin van de pagina