Patient Navigator Demonstration Program Evaluation - Patient Level

PNDP Common Data Elements
Data Dictionary
TABLE 1: Patient Socio-Demographics
Var Name
Var Label
SubjectID
ID code for each
patient
1.
Source of
2. DataSource
demographic
data

3.

OtherSource

4.

Gender

5.

BirthYear

6.

Ethnicity

7.

WhiteRace

Patient’s Race =
White

8.

BlackRace

9.

AsianRace

Patient’s Race =
Black/African
American
Patient’s Race =
Asian

10. PacIslandRace

Other source of
demographic
data
Patient’s gender
Calendar year of
birth
Patient’s
ethnicity

Patient’s Race =

Var Definition

Response Values
<<8-digit code>>

Var Type
Numeric

Var Length Var Range
8

1=Self-report by patient
2=Report by patient
representative
3=Administrative data
4=Other
Description

<>

Numeric

1

<>

Text

50

1=Male
0=Female
Year

<>

Numeric

1

0-1

<>

Numeric

4

1910-1990

1=Hispanic or Latino
0=Non-Hispanic
8=Refused

<>

Numeric

1

0-1

1=Yes
0 = No
8 = Refused
1=Yes
0 = No
8 = Refused
1=Yes
0 = No
8 = Refused
1=Yes

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

1-4

Page 1 of 1

PNDP Common Data Elements
Data Dictionary
Var Name

11. AmerIndRace

12. PrimLang

13. OtherLang
14. Education

15. Household Size

16. HHIncome

Var Label
Hawaiian/Pacific
Islander
Patient’s race =
American
Indian/Alaska
Native
Preferred
language spoken
at home

Var Definition
0 = No
8 = Refused
1=Yes
0 = No
8 = Refused
1=English
2=Spanish
3=Other

Other preferred
Description
language
Highest
1=8th grade or less
educational level 2=Some high school
3=Some
college/vocational
4=Associate degree
5=College degree
7=Graduate or
professional degree
8=Refused
Number of
Number
people including
self
Household
1=Less than $10,000
Income
2=$10,000 to $19,000
3=$20,000 to $29,000
4=$30,000 to $39,000
5=$40,000 to $49,000

Response Values

Var Type

Var Length Var Range

<>

Numeric

2

1-8

<>

Numeric

1

1-3

<>

Texr

50

<>

Numeric

2

1-8

<>

Numeric

2

1-25

<>

Numeric

2

1-8

Page 2 of 2

PNDP Common Data Elements
Data Dictionary
Var Name

17. ZipCode

Var Label

Var Definition
6=$50,000 or more
8=Refused
Zip code

5-digit zip of
residence
Patient’s Health Insurance Status
Patient has no
1=Yes
18. InsNone
health insurance 0=No
Patient has
1=Yes
19. InsMedicare
Medicare
0=No
Patient has
1=Yes
20. InsMedicaid
Medicaid
0=No
Patient has
1=Yes
21. InsPrivate
private health
0=No
insurance
Patient has
1=Yes
22. InsSingle
Single Service
0=No
plan
Patient has other Description
23. InsOther
form of
insurance
Patient receives 1=Yes
24. PharmAssist
pharmacy
0=No
assistance
Chronic Disease That is the Focus of Patient’s Navigation
Breast cancer is 1=Yes
25. DBrCancer
disease focus
0=No
Cervical cancer
1=Yes
26. DCerCancer
is disease focus
0=No
Colorectal
1=Yes
27. DColCancer

Response Values

Var Type

Var Length Var Range

<>

Numeric

5

0-99999

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Text

50

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

Page 3 of 3

PNDP Common Data Elements
Data Dictionary
Var Name

Var Label
Var Definition
cancer is disease 0=No
focus
DProCancer
Prostate cancer
1=Yes
28.
is disease focus
0=No
Diabetes is
1=Yes
29. DDiabetes
disease focus
0=No
Obesity is
1=Yes
30. DObesity
disease focus
0=No
Cardiovascular
1=Yes
31. DCardiovas
disease is the
0=No
focus
Hypertension is 1=Yes
32. DHypertens
the disease focus 0=No
Asthma is the
1=Yes
33. DAsthma
disease focus
0=No
Another disease 1=Yes
34. DOther
is the focus
0=No
Other disease
Description
35. OtherDis
that is the focus
PNDP
Date
36. EnrollDate
enrollment date
Patient in
1=Yes
37. OutreachRes
program due to
0=No
outreach
Stage of
Description
38. DStage
navigation-focus
disease
Comorbid Conditions That Could Complicate Navigation
Myocardial
1=Yes
39. CoMyocard

Response Values

Var Type

Var Length Var Range

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Text

50

<>

Numeric

10

<>

Numeric

1

<>

Text

50

<>

Numeric

1

0-1

0-1

Page 4 of 4

PNDP Common Data Elements
Data Dictionary
Var Name

40. CoConges

41. CoVas
42. CoCerebVas

43. CoDementia
44. CoCOPD
45. CoTrauma

46. CoUlcer
47. CoLiverMil

48. CoLiverSev

49. CoDM
50. CoCompDM

Var Label
infarction is
comorbidity
Congestive heart
failure is
comorbidity
Vascular disease
is comorbdity
Cerebral
vascular
accident is
comorbidity
Dementia is
comorbidity
COPD is
comorbidity
Cumulative
trauma is
comorbidity
Ulcer is
comorbidity
Mild liver
disease is
comorbidity
Severe liver
disease is
comorbidity
Diabetes is
comorbidity
Diabetes with

Var Definition
0=No

Response Values

Var Type

Var Length Var Range

1=Yes
0=No

<>

Numeric

1

0-1

1=Yes
0=No
1=Yes
0=No

<>

Numeric

1

0-1

<>

Numeric

1

0-1

1=Yes
0=No
1=Yes
0=No
1=Yes
0=No

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

1=Yes
0=No
1=Yes
0=No

<>

Numeric

1

0-1

<>

Numeric

1

0-1

1=Yes
0=No

<>

Numeric

1

0-1

1=Yes
0=No
1=Yes

<>

Numeric

1

0-1

<>

Numeric

1

0-1

Page 5 of 5

PNDP Common Data Elements
Data Dictionary
Var Name

51. CoHemi
52. CoRenal
53. CoAIDS
54. CoTumor
55. CoLeuk
56. CoLymph
57. CoSolTumor
58. CoMental
59. CoPain
60. Severity

61. DiagDate

Var Label
complications is
comorbidity
Hemi/paraplegia
is comorbidity
Renal disease is
comorbidity
AIDS is
comorbidity
Any tumor is
comorbidity
Leukemia is
comorbidity
Lymphoma is
comorbidity
Any solid tumor
is comorbidity
Mental illness is
comorbidity
Chronic pain is
comorbidity
Comorbidity
interference
degree
Date of
diagnosis/screen
start

Var Definition
0=No

Response Values

Var Type

Var Length Var Range

1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

Date

<>

Date

10

Page 6 of 6

PNDP Common Data Elements
Data Dictionary
TABLE 2: Patient Tracking Log
Var Name
Var Label
1.
2.
3.
4.
5.

SubjectID
PNID
ActivDate
StartTime
CommType

6.

CommOther

ID code for each subject
ID code for navigator
Date of action
Start time of activity
Type of communication

Specify other type of
communication
Person(s) Involved in Communication
7. CommPatien
Communication was
with patient
8. CommSocial
Communication with
social network
9. CommHCProv
Communication with
healthcare provider
10. CommHCStaff
Communication with
healthcare staff
11. CommResStaff
Communication with

Var Definition

Date
Time
1=Telephone call
2=Home meeting
3=Face-to-face meeting
at clinic
4=Accompaniment to
social services site
6=Accompaniment to
community organization
7=Written
communication/email
8=Other
Description

1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes

Response Values

Var
Type
<<8-digit code>> Numeric
<<5-digit code>> Numeric
<> Date
<>
Time
<>
Numeric

Var
Length
8
5
10
5
1

Var
Range

<>

Text

50

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

1-8

Page 7 of 7

PNDP Common Data Elements
Data Dictionary
Var Name

Var Label

community resource
staff
12. CommOther
Communication with
other person
13. OtherComm
Specify other person
involved
Reason for Communication Activity
14. ReasRemind
Reason is reminder call
15. ReasEdu

Reason is patient
education
16. ReasHCSched
Reason is to schedule
healthcare appointment
17. ReasOthSched
Reason is to schedule
other appointment type
18. ReasMedRec
Reason to is arrange for
medical records
19. ReasTrans
Reason is to arrange
transportation
20. ReasOther
Reason is for other
arrangements
21. OtherReas
Specify other reason for
communication
Patient Navigator Activities
22. ActCoord
Coordinate healthcare
services/referrals
23. ActFacilit
Facilitate involvement
of community

Var Definition

Response Values

Var
Type

Var
Length

Var
Range

1=Yes
0=No
Description

<>

Numeric

1

0-1

<>

Text

50

1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
Description

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Text

50

1=Yes
0=No
1=Yes
0=No

<>

Numeric

1

0-1

<>

Numeric

1

0-1

0=No

Page 8 of 8

PNDP Common Data Elements
Data Dictionary
Var Name

Var Label

Var Definition

Response Values

Var
Type

Var
Length

Var
Range

1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

1=Yes
0=No
Barrier is housing
1=Yes
0=No
Barrier is
1=Yes
social/practical support
0=No
Barrier is
1=Yes
language/interpreter
0=No
Barrier is literacy
1=Yes
0=No
Barrier is childcare
1=Yes
issues
0=No
Barrier is adult care
1=Yes
0=No
Barrier is location of HC 1=Yes
facility
0=No
Barrier is lack of
1=Yes
insurance or high co0=No

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

organizations
Notify about clinical
trials
25. ActBarriers
Assist in overcoming
barriers
26. ActCoverage
Coordinate health care
coverage
27. ActPrevent
Assist in seeking
preventative care
Barriers Addressed by Activity
28. BTrans
Barrier is transportation
24. ActTrials

29. BHousing
30. BSocial
31. BLang
32. BLit
33. BChild
34. BAdult
35. BLocation
36. BIns

Page 9 of 9

PNDP Common Data Elements
Data Dictionary
Var Name

37. BFinan
38. BEmployment
39. BComm

40. BFear
41. Bcomorb

Var Label
pays
Barrier is financial
problems
Barrier is employment
issues
Barrier is
communication
concerns with medical
personnel
Barrier is fear

47. BOther

Barrier is
medical/mental health
comorbidity
Barrier is patient
disability
Barrier is that patient is
out of town
Barrier is patient’s belief
re: treatment
Barrier is system
problems with
scheduling
Barrier is attitudes
toward providers
Other type of barrier

48. BNone

No barrier identified

42. BDisability
43. BOut
44. BBelief
45. BSys

46. BAttitude

Var Definition

Response Values

Var
Type

Var
Length

Var
Range

1=Yes
0=No
1=Yes
0=No
1=Yes
0=No

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

1=Yes
0=No
1=Yes
0=No

<>

Numeric

1

0-1

<>

Numeric

1

0-1

1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

1=Yes
0=No
1=Yes
0=No
1=Yes

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

Page 10 of 10

PNDP Common Data Elements
Data Dictionary
Var Name

Var Label

49. OtherB

Specify other type of
barrier
Referrals Facilitated By Activity
50. RefScreen
Screening referral
51. RefTreat

Treatment referral

52. RefPharm

Pharmacy assistance
referral
Health care coverage
referral
Social services referral

53. RefCover
54. RefSocial
55. RefRes
56. RefTrial

Community resource
staff referral
Clinical trial referral

57. RefOther

Other type of referral

58. OtherRef

Specify other type of
referral
Status of navigation for
specific patient

59. PtStatus

Var Definition

Response Values

Var
Type

Var
Length

Var
Range

0=No
Description

<>

Text

50

1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
Description

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Text

50

1=Navigation in progress
2=Patient refused
navigation
3=Patient cannot be
reached/Lost to
navigation

<>

Numeric

1

1-4

Page 11 of 11

PNDP Common Data Elements
Data Dictionary
Var Name

60. ReasCompl

Var Label

Reason why navigation
is complete

Report of Patient Actions Since Last Contact
61. RepScreen
Approximate date of
screening visit
62. RepSpec
Approximate date of
specialist visit
63. RepPrimary
Approximate date of
primary care visit
64. RepER
Approximate date of
emergency room visit
65. RepHosp
Approximate length of
hospital stay
66. RepTrial
Approximate date of
clinical trial attempt
67. RepSocial
Approximate date of
social services visit
68. RepRes
Approximate date of
community org. meeting

Var Definition
4=Navigation complete
1=Screening complete;
negative finding
2=Followup test
complete; negative
finding
3=Completed treatment
4=Achieved other target

Response Values

Var
Type

Var
Length

Var
Range

<>

Numeric

1

1-4

Date

<> Date

10

Date

<> Date

10

Date

<> Date

10

Date

<> Date

10

Number of days

<>

3

Date

<> Date

10

Date

<> Date

10

Date

<> Date

10

Numeric

1-100

Page 12 of 12

PNDP Common Data Elements
Data Dictionary
TABLE 3: Patient Navigator Socio-Demographic Characteristics
Var Name
Var Label
Var Definition

Response Values

1.

PNID

2.

PNGender

3.

PNBirthYr

4.

PNEth

5.

PNWhite

Navigator’s Race =
White

6.

PNBlack

7.

PNAsian

Navigator’s Race =
Black/African
American
Navigator’s Race =
Asian

8.

PNPacIsland

9.

PNAmerInd

10. PNLang

Unique ID code for
each Patient Navigator
Patient Navigator’s
gender
Patient Navigator’s
birth year
Patient Navigator’s
ethnicity

Navigator’s Race =
Hawaiian/Pacific
Islander
Navigator’s race =
American
Indian/Alaska Native
Patient Navigator’s
primary language

Var
Length
5

Var
Range

<<5-digit code>>

Var
Type
Numeric

1=Male
0=Female
Year

<>

Numeric

1

0-1

<>

Numeric

4

0=Non-Hispanic
1=Hispanic or Latino
8 =Choose not to answer
1=Yes
0 = No
8 = Refused
1=Yes
0 = No
8 = Refused
1=Yes
0 = No
8 = Refused
1=Yes
0 = No
8 = Refused
1=Yes
0 = No
8 = Refused
1=English
2=Spanish
3=Other

<>

Numeric

2

0-98

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

2

1-8

<>

Numeric

1

1-3

Page 13 of 13

PNDP Common Data Elements
Data Dictionary
Var Name
11. PNLangOther

12. PNAddlLang

Var Label

Var Definition

Response Values

Patient Navigator’s
primary language if
other
Additional languages
spoken by PN

Description

Additional Education/Training
13. PNEdu
PN’s highest level of
education

14. PNEduNone
15. PNEduRN

PN has no additional
education
PN is RN

16. PNEduLPN

PN is LPN

17. PNEduAide

PN is medical
assistant/Nurses aide
PN is social worker

18. PNEduSocial

<>

Var
Type
Text

Var
Length
50

Var
Range

Description

<>

Text

50

1=8th grade or less
2=Some high school
3=High school diploma
(including equivalency)
4=Some
college/vocational after
high school
5=Associate degree
6=College graduate
7=Graduate of
professional degree
98=Choose not to answer
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No

<>

Numeric

2

1-98

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

Page 14 of 14

PNDP Common Data Elements
Data Dictionary
Var Name

Var Label

Var Definition

Response Values

19. PNEduPhleb

PN is phlebotomist

20. PNEduRadio

PN is radiology
technologist
PN is mammography
technologist
PN has navigator
certification
PN has CHW
certification
PN is certified medical
interpreter
PN is spiritual or
alternative HC
provider
PN has other additional
education
Specify other
additional education
5-digit zip code of
PN’s residence

1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No
1=Yes
0=No

21. PNEduMamm
22. PNEduCert
23. PnEduCHW
24. PNEduInterp
25. PNEduAlt

26. PNEduOther
27. OtherPNEdu
28. PNZip

<>

Var
Type
Numeric

Var
Length
1

Var
Range
0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

<>

Numeric

1

0-1

1=Yes
0=No
Description

<>

Numeric

1

0-1

<>

Text

50

5-digit ZIP

<>

Numeric

5

Page 15 of 15

PNDP Common Data Elements
Data Dictionary
TABLE 4: Health Care Visit Data
Var Name
Var Label
1.

SubjectID

2.

VisitID

3.
4.

VisitDate
VisitType

5.

OtherVisit

Unique ID code for
each subject
Unique identifier for
visits assigned by
grantee
Date of visit
Type of visit
(where/who provided
care?)

Specify other type of
visit

Var Definition

Response Values

Var
Type
Numeric

Var
Length
8

8-digit code

<<8-digit code>>

10-digit code

<<10-digit
code>>

Numeric

10

Date
1=Screening visit
2=F/u abnormal screen
3=Primary care visit
4=Health education visit
5=Behavioral health visit
6=Cardiology visit
7=Endocrinology visit
8=Pulmonology visit
9=Oncology visit
10=Lab visit
11=Urgent care visit
12=ER visit
13=Hospital stay
14=Other visit
Description

<> Date
<>
Numeric

10
2

<>

50

Text

Var
Range

1-14

Page 16 of 16

PNDP Common Data Elements
Data Dictionary
TABLE 6: Appointment Data
Var Name
Var Label
1.

SubjectID

2.
3.

ApptDate
ApptType

4.

OtherAppt

Unique ID code for each
subject
Date of appointment
Type of visit (where/who
provided care?)

Specify other type of visit

Var Definition

Response Values

Var
Type
Numeric

8-digit code

<<8-digit code>>

Date
1=Screening visit
2=F/u abnormal
screen
3=Primary care visit
4=Health education
visit
5=Behavioral health
visit
6=Cardiology visit
7=Endocrinology
visit
8=Pulmonology visit
9=Oncology visit
10=Lab visit
11=Urgent care visit
12=ER visit
13=Hospital stay
14=Other visit
Description

<> Date
<>
Numeric

10
2

<>

50

Text

Var
Length
8

Var
Range

1-14

Page 17 of 17

PNDP Common Data Elements
Data Dictionary
TABLE 7: Alternative Appointment Data
Var Name
Var Label
1.

SubjectID

2.

NumBroken

3.

EndDate

Unique ID code for each
subject
Appointments broken b/t
start and end of navigation
Date on which number
broken counted

Var Definition

Response Values

8-digit code

<<8-digit code>>

Var
Type
Numeric

Number

<>

Numeric

Date

<> Date

Var
Length
8

Var
Range

10

Page 18 of 18

PNDP Common Data Elements
Data Dictionary
TABLE 8: Health Care Coverage
Var Name
Var Label
1.

SubjectID

2.

FinalCov

3.

FinalOther

4.

Date

Unique ID code for each
subject
Health care coverage at
last HC visit

Specify other type of
health care coverage
Date on which coverage
was assessed

Var Definition

Response Values

Var
Length
8

Var
Range

<<8-digit code>>

Var
Type
Numeric

8-digit code
1=Private
2=Medicare
3=Medicaid
4=VA/Tricare/Other
Federal
5=Free care (partial
or complete)
6=Self pay
7=Other
Description

<>

Numeric

1

1-7

<>

Text

50

Date

<> Date

10

Page 19 of 19

PNDP Common Data Elements
Data Dictionary
TABLE 9: Baseline Measures Relevant to Navigated Population
Var Name
Var Label
Var Definition

Response Values

Var
Type
Numeric

Var
Length
1

Var
Range
1-6

Text

50

Numeric

3

0-100

1.

SiteID

ID of site providing data

Number

2.

TargetPop

Description

3.

ScreenRate

Percentage

<>

4.
5.

DateCalc
HCVisitRate

Date
Percentage

<> Date
<>
Numeric

10
3

0-100

6.
7.

DateCalc
Noshow

Target population for
navigation
Screening rate for target
population
Dates calculated
Rate of health care visits
for population
Dates calculated
Rate of appointment noshows
Dates calculated
ER visit rate
Dates calculated

1=Goodwin
2=Lutheran
3= NE Valley
4=Palmetto
5=South Broward
6=Texas
<>

Date
Percentage

<> Date
<>
Numeric

10
3

0-100

Date
Percentage
Date

<> Date
<>
Numeric
<> Date

3
3
10

8. DateCalc
9. ERrate
10. DateCalc

0-100
0-100

Page 20 of 20