Form 1 Enrollment and Service Log Data Dictionary

OMB No.: 0970-0444
Expiration date: 03/31/2017

September 29, 2015

Regional Partnership Grants Cross-Site
Evaluation and Evaluation-Related
Technical Assistance

Regional Partnership Grants Cross-Site
Evaluation Data Collection System

Enrollment and Service Log (ESL)
Data Dictionary
Version 4

Regional Partnership Grants Cross-Site
Evaluation Data Collection System:
Enrollment and Service Log (ESL) Data Dictionary
Version 4
Contract Number:
HSP233201250024A

September 29, 2015
Juliette Henke
Michael M. Kerachsky
Caroline Massad Francis
Emily Snoek

Mathematica Reference Number:
40170.058
Submitted to:
Office on Child Abuse and Neglect
Children’s Bureau, ACYF, ACF, HHS
8th Fl. No. 8111, 1250 Maryland Ave., SW
Washington, DC 20024
Project Officer: Elaine V. Stedt
Submitted by:
Mathematica Policy Research
P.O. Box 2393
Princeton, NJ 08543-2393
Telephone: (609) 799-3535
Facsimile: (609) 799-0005
Project Director: Debra A. Strong
OMB No.: 0970-0444
Expiration Date: 03/31/2017
Suggested citation:

Henke, Juliette, Michael M. Kerachsky, Caroline Massad Francis, Emily Snoek, “Regional Partnership Grants
Cross-Site Evaluation Data Collection System: Enrollment and Service Log (ESL) Data Dictionary, Version 4.”
Children’s Bureau, Administration for Children and Families, U.S. Department of Health and Human Services.
September 29, 2015. Contract No.: HSP233201250024A. Available from Mathematica Policy Research, Princeton, N.J.

Regional Partnership Grants
and Cross-Site Evaluation

OMB No.: 0970‐0444  
Expiration date: 03/31/2017  

Public reporting burden for this collection of information is estimated to average 20 minutes per 
response, including the time for reviewing instructions, maintaining the data needed, and for reviewing 
and electronically uploading records. An agency may not conduct or sponsor, and a person is not 
required to respond to, a collection of information unless it displays a currently valid OMB control 
number. Send comments regarding this burden estimate or any other aspect of this collection of 
information, including suggestions for reducing this burden, to: Elaine Voces Stedt, 1250 Maryland Ave, 
SW, 8th Floor #8125, Washington, DC 20024. Attn: OMB‐PRA (0970‐0444). 

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

CONTENTS
Revision History ............................................................................................................................................ 1
Introduction ................................................................................................................................................... 2
Features of the ESL ...................................................................................................................................... 2
Content of the ESL Data Dictionary .............................................................................................................. 2
ESL Data Extracts ......................................................................................................................................... 3
A. Grantee Information ........................................................................................................................ 5
B. RPG Case Enrollment .................................................................................................................... 6
C. Demographics on Individuals in the RPG Case ............................................................................. 7
D. RPG Case Member Roles and Relationships .............................................................................. 12
E. RPG Case Closure ....................................................................................................................... 14
F. Enrollment in and Exit from Specific EBPs ................................................................................... 16
G. Service Contact Information ......................................................................................................... 19
H. Activities Conducted During Service Contact ............................................................................... 23
I.

Session Alignment with Session Plans ......................................................................................... 25

J.

Substantive Areas Covered During Service Contact .................................................................... 27

K. Topics Covered During the Session: Parents’/Other Adults’ Substance Use Disorder
Treatment...................................................................................................................................... 29
L. Topics Covered During the Session: Parents’/Other Adults’ Parenting Skills .............................. 32
M. Topics Covered During the Session: Parents’/Other Adults’ Personal Development .................. 34
N. Topics Covered During the Session: Youth Therapy and Development ...................................... 36
O. Topics Covered During the Session: Education of Youth on Substance Use Disorders
and Recovery ................................................................................................................................ 38
P. Topics Covered During the Session: Education of Other Relatives on Substance Use
Disorders and Recovery ............................................................................................................... 39
Q. Engagement Rating ...................................................................................................................... 40
R. Service Contact Check if No Contact Data Entered for Two Weeks ............................................ 41

iii

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

Revision History
Revised

Changes

9/23/2015

Version 4 aligns with additional changes implemented in ESL version 1.7. This version includes
the following changes:

5/7/2015

6/12/2014



Removed unnecessary variable GranteeId (A.0)



Indicated that the EBP Exit Date is included in additional extracts



Added CaseEBPID

Version 3 aligns with ESL 1.7. This version includes the following changes:


Added variables to record whether focal child was in family functioning adult’s care at
enrollment and exit



Added system-generated variables



Updated variable names to align with updated ESL extracts

Version 2 aligns with ESL 1.0. This version includes the following changes:


Added several variables in Sections A through Q to reflect first release of online ESL



Removed variable list from Section R that was not included in ESL 1.0

1

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

Introduction

RPG grantees will share data for the RPG Cross-Site Evaluation through the RPG Data
Collection System. Mathematica Policy Research and its partner WRMA, Inc. (Mathematica/
WRMA), along with Synergy Enterprises, are developing this Data Collection System. The RPG
Data Collection System will consist of two components: (1) an Enrollment and Service Log
(ESL), where grantees will enter enrollment and case information along with information on
their RPG clients’ participation in the evidence-based programs and practices (EBPs) they
provide through RPG; and (2) an Outcome and Impact Study Information System (OAISIS),
where grantees will upload outcome data from standardized instruments and administrative
sources.
This data dictionary has been developed to guide system designers and to provide a resource
for grantees to use in preparing and submitting data, as well as for analyzing their own data. This
document (version 3) contains specifications for the data elements included in the ESL.
Features of the ESL

The basic features of the system are:


The ESL consists of a brief series of data entry screens grantees will use to enter data,
accessed by clicking on relevant hyperlinks.



The system is configured so that grantees will be able to download only their own data.



The system includes convenience features. For instance, staff can enter case member names
into the system. Entering names (or initials or nicknames, if your IRB will not allow you to
use names) can facilitate data entry by other staff. For example, it will be easier to select
names, rather than ID numbers, from a list. However, researchers at Mathematica will not
be able to download any names entered into the system.



The ESL is housed on a secure server maintained by Mathematica’s subcontractor, Synergy
Enterprises, and adheres to all security requirements for the project.

Content of the ESL Data Dictionary

For each item included in the ESL, the data dictionary provides the name of the data field, a
description of the field, and valid values for that field. For text and alpha-numeric fields, the
valid values column also indicates the number of characters the field will contain, or the
maximum number of characters allowed. Some items also include requirements or conditions, as
well as additional comments, such as information indicating that certain responses will take users
to a related screen for additional information.
For ease of use, the dictionary is divided into several sections. Section A contains basic
information about the grantee. Sections B through E describe data elements collected upon RPG
case enrollment and closure. Section F describes data elements to be collected whenever an RPG
case member is enrolled in any of the EBPs provided as part of a grantee’s RPG program, and
one item collected when those case members exit the EBP. Sections G through R describe data

2

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

elements collected only when RPG case members are enrolled in one of the ten focal EBPs.1
Sections G through J describe data elements collected for each session of a focal EBP. Sections
K through P contain data elements collected on focal EBPs on topics covered within each of six
substantive areas covered in a session (selected in Section J). Section R (to be completed in
subsequent versions) includes a reminder screen that will appear if no service or contact data
have been entered for two weeks on a case enrolled in a focal EBP. The dictionary also notes
which data extracts from the ESL include which fields. The data extracts are discussed below.
For assistance with the ESL (data elements, submission, or downloads), grantees have
several TA resources available, including:


RPG help line: 855-558-5528



RPG help desk: [email protected]



RPG ESL User Guide



RPG cross-site evaluation liaison

ESL Data Extracts

Grantees can export their data from the ESL as a series of .csv files. Four groups of extract
files are available for export, including seven total extract files. Each extract file contains data
specific to only the requesting grantee. Common data elements used to link the extract files
together include RPG Case ID, RPG Enrollment Date, Individual ID, and where applicable, EBP,
EBP Enrollment Date, and Date of Service and (system-generated) Service Log ID number. The
extracts available include:
1. RPG Enrollment and Exit: The extract includes one record (or observation) for each
individual entered within an RPG case, for each RPG case created. This extract includes all
data related to RPG case enrollment and exit, individual case member demographics, and
relationships between individuals in a case. See sections B through E for more information
on these fields.
2. EBP Enrollment and Exit: The extracts record EBP enrollments and exits in RPG. Three
EBP enrollment and exit extract files are available to export based on the level of
observation. All three extracts include the following fields: RPG Case ID, RPG Enrollment
Date, EBP, and EBP Enrollment Date. See sections B and F for more information on the
fields within these extracts.
a. Case file: The extract includes one record (or observation) for each EBP in which
a case is enrolled. In addition to the fields noted above, this extract includes the
EBP Exit Date.

1

To reduce the burden on grantees of providing service data, the implementation study will collect service data on
10 focal EBPs among the more than 50 EBPs being implemented across the grantees. The focal EBPs are:
(1) Celebrating Families!, (2) Child-Parent Psychotherapy, (3) Cognitive Behavioral Therapy, (4) Hazelden Living
in Balance Program, (5) Matrix Model Program, (6) Nurturing Parenting Programs, (7) Parent and Child Interactive
Therapy, (8) Seeking Safety, (9) Strengthening Families Program, and (10) Trauma-Focused Cognitive Behavior
Therapy.

3

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

b. Individual file: The extract includes one record for each Individual ID. The
extract records which individual case members were enrolled in an EBP (related
to a specific EBP Enrollment Date).
c. Caseworker file: The extract includes one record for each caseworker. The
extract records which caseworker(s) were assigned to provide an EBP for each
RPG Case. The extract also includes the Caseworker Start Date, and Caseworker
End Date for the EBP assignment.
3. Focal EBP Service Logs: The extracts record Service Logs created for each focal EBP. Two
Focal EBP Service Log extract files are available to export based on the level of observation.
Both extracts contain the following fields: RPG Case ID, RPG Enrollment Date, EBP, EBP
Enrollment Date, and Date of Service. See sections B, F, and G through P for more
information on the fields within these extracts.
a. Session file: The extract includes one record for each service log. The extract
records all session-related data for each focal EBP session provided to each case.
These data elements include: location, duration, activities, session alignment, and
session topics.
b. Individual file: The extract includes one record for each Individual ID. This
extract records which individuals were in attendance for a give service log
(related to a given Date of Service and EBP).
4. Focal EBP Participant Engagement: The extract includes one record per assessment of
participant engagement for each focal EBP. The extract records the two assessments of
participant engagement for each focal EBP provided to an RPG Case. The extract includes
the Date of Service (for either the second or final service log), as well as a system-generated
service log ID number that matches the ID number assigned to a record in the Focal EBP
Service Logs-Session File. The extract also includes the RPG Case ID, RPG Enrollment
Date, EBP and EBP Enrollment Date. See sections B, F, G, and Q for more information on
the fields within these extracts.

4

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

A. Grantee Information
Section A includes grantee information fields (grantee ID, name, and address) and user
information fields (name, email, phone number, and user role). The grantee-level fields will
automatically populate based on the user’s login credentials. As described in the user guide, ESL
administrators will fill in the user-level fields when creating new accounts. The grantee ID
number fields are included in all data extracts; other fields in this section are available in the ESL
user interface but are not included in any extract files.
Grantee Information
#

Field

Long
name

Description

Valid
values

Required or
conditional field

A.1

GRANTEE_ID_NO

Official
Grantee ID

Grantee
identification number
provided by the
Children's Bureau to
the grantee

Alpha-numeric (8)

Required

A.2

GRANTEE NAME

Grantee Name

Name of grantee

Text (45)

Required

A.3

GRANTEE ADD 1

Grantee
Address 1

First address line of
grantee

Text (50)

A.4

GRANTEE ADD 2

Grantee
Address 2

Second address line
of grantee

Text (50)

A.5

GRANTEE CITY

Grantee City

City of residence of
grantee

Text (50)

A.6

GRANTEE STATE

Grantee State

State of residence of
grantee

Text (40)

A.7

GRANTEE ZIP

Grantee Zip
Code

Zip code of grantee

Text (15)

A.8

USER FIRST

User First
Name

First name of user

Text (50)

Required

A.9

USER LAST

User Last
Name

Last name of user

Text (50)

Required

A.10

USER EMAIL

User email

Email address of
user

Text (80)

Required

A.11

USER PHONE

User Phone
Number

Phone number of
user

Text (20)

A.12

USER ROLE

User role

User role

 Grantee Admin
 Caseworker

5

Required

Comment
Included in all
extracts

Only one may
be selected

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

B. RPG Case Enrollment
Sections B through E describe data elements collected upon RPG case enrollment and
closure. Fields in sections B through E (except for RPG Case Surname and First Name) are
included in RPG Enrollment and Exit-Extract 1. Two fields in Section B, Case ID and RPG
Enroll Date, are included in all extracts to help users link data across extracts.
This section includes fields the grantee staff member will enter at the time of RPG case
enrollment: the RPG case ID, the surname for the case, and the RPG enrollment date. The ESL
User Guide provides instructions for how to handle cases with multiple surnames. Each grantee
will have to define the “RPG case” for their specific RPG program for the purposes of entering
enrollment data into the ESL.
RPG Case Enrollment
#

Field

Long
name

Description

Valid values

Required or
conditional field

Comment

B.1

CASE_ID

Case ID

Identification
number assigned
to each case

Alpha-numeric (6)

Required

Included in all
extracts

B.2

SURNAME

RPG Case
Surname

Last name of case
or other identifiable
information

Text (25)

Required

Names are only
visible in the
web-based ESL.
They do not
appear in any
extracts.

B.3

RPG_ ENROLL_
DATE

RPG
Enrollment
Date

Date that case
enrolled in RPG
program

Date format
MM/DD/YYYY
RPG ENROLL
DATE >= 1/1/2014
and <= [Today’s
Date]

Required

Included in all
extracts

6

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

C. Demographics on Individuals in the RPG Case
#

Field

Long
name

Description

Valid
values

Required or
conditional field

Comment

C.1

IND_ID

Individual ID

Each individual has
a unique ID. An
individual present in
more than one case
should have the
same ID across
cases.

Alpha-numeric (6)

Required

Included in
multiple extracts:
RPG Enrollment
and Exit-Extract
1, EBP
Enrollment and
Exit, Individual
file-Extract 2b,
and Focal EBP
Service Logs,
Individual fileExtract 3b

C.2

FIRST NAME

Individual
Name

First name of
individual or other
identifying
information such as
initials or a
pseudonym

Text (24)

Required

Names are only
visible in the webbased ESL. They
do not appear in
any extracts.

C.3

Date of Birth

Date of Birth

Date of birth of
individual

Date format Month,
Day, Year

Required

C.4

Gender

Gender

Sex of individual

 Male

Required

 Female
C.5

C.6

C.7

C.8

C.9

C.10

C.11

PersonType

Person Type

Indicator of whether
person is an adult
or child

 Adult

RACE_AMER_IND_
OR_AK_NAT

Race:
American
Indian or
Alaska Native

Indicator the
individual is
American Indian or
Alaska Native

 Yes

RACE_ASIAN

Race: Asian

Indicator the
individual is Asian

 Yes

Indicator the
individual is black or
African American

 Yes

RACE_BLACK

Race: Black

 Blank

 Blank

 Blank

RACE_NAT_HI_
OR_OTH_PAC_
ISLE

Race: Native
Hawaiian or
Other Pacific
Islander

Indicator the
individual is Native
Hawaiian or Other
Pacific Islander

 Yes

RACE_WHITE

Race: White

Indicator the
individual is white

 Yes

Ethnicity
identification of
individual

 Hispanic or
Latino

Ethnicity

Ethnicity

Required

 Child

 Blank

 Blank

 Not Hispanic or
Latino

Users may
indicate multiple
races
Users may
indicate multiple
races
Users may
indicate multiple
races
Users may
indicate multiple
races
Users may
indicate multiple
races
Only one
response may be
selected

 Blank
C.12

PrimaryLanguage

Primary
Language
Spoken at
Home

Language individual
primarily speaks at
home

7

 English
 Spanish
 Other

Only one
response may be
selected

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#

Field

Long
name

Description

MATHEMATICA POLICY RESEARCH

Valid
values

C.13

PRIMARY_HOME_L
ANG_SPEC

Primary
Language
Spoken at
Home
Specification

Specification if
Primary Language
Spoken at Home is
“Other”

Text (240)

C.14

CurrentResidence

Current Type
of Residence

Current type of
residence for
individual

 Primary
residence of case
member(s)

Required or
conditional field

Comment

Required if C.12 (Primary
Language) = Other

Only one
response may be
selected

 Treatment facility
 Correctional
facility/prison
 Homeless/
shelter
 Foster parent's
residence
 Foster/group
home
 Other
 Blank
C.15

CURRENT_RESIDE
NCE_SPECIFY_
IF_OTHER

Current Type
of Residence
Specification

Specification if
current type of
residence is “Other”

Text (240)

Required if C.14
(CurrentResidence) =
Other

C.16

HighestEducation

Highest
Education
Level

Highest/last level of
education attained

 Up to 8th grade

Asked only if C.5
(PersonType) = Adult

 Some high
school
 High school
diploma/GED

Adult only; this
field will be a
legitimate skip
where Person
Type=Child
Only one
response may be
selected

 Some
vocational/technical
 Vocational/
technical diploma
 Some college
 Associate's
degree
 Bachelor's
degree
 Some graduate
or professional
school
 Master's degree
 Doctorate
degree
 Professional
degree (M.D., J.D.,
D.D.S., etc.)
 Blank
C.17

IncomeLevel

Annual
Income (past
12 months)

Annual monetary
amount received by
individual

 $0-9,999
 $10,000-19,000
 $19,001-24,999
 $25,000-34,999
 $35,000-49,999

8

Asked only if C.5
(PersonType) = Adult

Adult only; this
field will be a
legitimate skip
where
PersonType=
Child

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#

Field

Long
name

Description

MATHEMATICA POLICY RESEARCH

Valid
values

Required or
conditional field

 Blank
C.18

C.19

C.20

INCOME_SOURCE_
WAGE_SALARY

Income
Source:
Wages/ salary

Indicator the
individual receives
income from wages/
salary

 Yes

INCOME_SOURCE_P
UB_ASS

Income
Source: Public
assistance

Indicator the
individual receives
income from public
assistance

 Yes

INCOME_SOURCE_
RETIR_PENS

Income
Source:
Retirement/
pension

Indicator the
individual receives
income from
retirement/ pension

 Yes

 Blank

 Blank

 Blank

Comment
Only one
response may be
selected

 $50,000 or
higher
Asked only if C.5
(PersonType) = Adult

Adult only; this
field will be a
legitimate skip
where
PersonType=
Child
Users may
indicate multiple
income sources

Asked only if C.5
(PersonType) = Adult

Adult only; this
field will be a
legitimate skip
where
PersonType=
Child
Users may
indicate multiple
income sources

Asked only if C.5
(PersonType) = Adult

Adult only; this
field will be a
legitimate skip
where
PersonType=
Child
Users may
indicate multiple
income sources

C.21

C.22

INCOME_SOURCE_
DISAB

Income
Source:
Disability

Indicator the
individual receives
income from
disability

 Yes

INCOME_SOURCE_
OTHER

Income
Source: Other

Indicator the
individual receives
income from other
sources

 Yes

 Blank

 Blank

9

Asked only if C.5
(PersonType) = Adult

Adult only; this
field will be a
legitimate skip
where
PersonType=
Child
Users may
indicate multiple
income sources

Asked only if C.5
(PersonType) = Adult

Adult only; this
field will be a
legitimate skip
where
PersonType=
Child
Users may
indicate multiple
income sources

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#
C.23

Field

Long
name

INCOME_SOURCE_
NONE

Income
Source: None

Description
Indicator the
individual receives
no income

MATHEMATICA POLICY RESEARCH

Valid
values
 Yes
 Blank

Required or
conditional field
Asked only if C.5
(PersonType) = Adult

Comment
Adult only; this
field will be a
legitimate skip
where
PersonType=
Child
Users may
indicate multiple
income sources

C.24

INCOME_SOURCES
PECIFY_IF_ OTHER

Other Income
Source
Specification

Specification if the
individual receives
income from an
“other” source

 Text (240)

Asked only if C.5
(PersonType) = Adult
Required if
C.22 (INCOME SOURCE
OTHER) = Yes

Adult only; this
field will be a
legitimate skip
where
PersonType=
Child

C.25

EmploymentStatus

Employment
Status

Individual's
Employment Status

 Full-time
employment

Asked only if C.5
(PersonType) = Adult

Adult only; this
field will be a
legitimate skip
where
PersonType=
Child
Only one
response may be
selected

Asked only if C.5
(PersonType) = Adult

Adult only; this
field will be a
legitimate skip
where
PersonType=
Child

 Part-time
employment
 Self-employed
 Unemployed
 Not in labor
force
 Blank
C.26

RelationshipStatus

Relationship
Status

Individual's
domestic
relationship status
upon enrollment

 Single
(unmarried and not
cohabiting)
 Married to focal
child's biological
parent

Only one
response may be
selected

 Married to other
individual
 Cohabiting with
focal child’s
biological parent
 Cohabiting with
other individual
 Divorced/
separated/
widowed
 Blank
C.27

C.28

TREATMENT
ASSIGNMENT

SYSTEM_
TIMESTAMP_IND

Treatment
Assignment

System
Timestamp:
Date case
enrollment
data saved

Treatment
assignment for
grantees
participating in the
impact sub study
Web ESL system
timestamp for date
that add new case
member information
screen was added
(includes data
elements in section
C)

10

Numeric
 Treatment group
=1

Required

Only one
response may be
selected

 Comparison
group = 2
 Date format
MM/DD/YYYY

Auto-generated
by system

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

At case enrollment, the grantee staff member will enter demographic information for each
member of the RPG case. Some information will only be entered for adult case members. Fields
in section C (except for First Name) are included in RPG Enrollment and Exit-Extract 1. The
Individual ID field is included multiple extracts to help users link data across extracts.

11

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

D. RPG Case Member Roles and Relationships
Grantee staff will indicate which RPG case member is the focal child (using an established
rule), which case member is the family functioning adult, and which case member is the recovery
domain adult (see the ESL User Guide for more information on these roles). Grantee staff also
indicate each RPG case member’s relationship to the focal child. Fields in section D are included
in RPG Enrollment and Exit-Extract 1.
RPG Case Member Roles and Relationships
#
D.1

D.2

Field
FOCAL_CHILD_YN

RelationshipTo Focal

Long
name
Focal Child

Relationship to
Focal Child

Required or
conditional field

Description

Valid values

Indicator that child
is the focal child

 Yes
 Blank

Yes response required for
one case member

Exactly one
child per case
must be coded
as the focal
child

The relationship
between individual
case member and
focal child

 Biological parent

Required

Only one
response may
be selected
Note: this will be
a legitimate skip
where
FOCAL_CHILD
_YN (D.1)=Yes

 Adoptive parent
 Step-parent by
marriage
 Foster parent
 Grandparent
 Aunt/uncle

Comment

 Parent’s partner
 Biological sibling
 Adopted sibling
 Other stepsibling by marriage
 Cousin
 Other
D.3

RELATIONSHIP_
TO_FOCAL_CHILD_I
F_OTHER

Relationship to
Focal Child
Specification

Specification if
RelationshipToFo
cal is “Other”

Text (240)

Required if D.2
(RelationshipToFocal) =
Other

D.4

FAMILY_
FUNCTIONING_
ADULT_YN

Family
Functioning
Adult

Indicator for adult
who is the family
functioning adult

 Yes

Yes response required for
one case member

Exactly one
adult per case
must be coded
as the family
fun-ctioning
adult.
May be the
same as the
recovery
domain adult

RECOVERY_DOMAI
N_ADULT_YN

Recovery
Domain Adult

Indicator for adult
who is the
recovery domain
adult

 Yes

Yes response required for
one case member

Exactly one
adult per case
must be coded
as the recovery
domain adult.
May be the
same as the
family
functioning adult

D.5

12

 Blank

 Blank

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#
D.6

Field
FOCAL CHILD FFA
CARE ENRL

MATHEMATICA POLICY RESEARCH

Long
name

Description

Valid values

Required or
conditional field

Focal Child in
Family
Functioning
Adult’s Care at
Enrollment

Indicator that focal
child was in family
functioning adult’s
care at time case
enrolled in RPG

 Yes

Required

13

 No
 Don’t know

Comment

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

E. RPG Case Closure
When an RPG case leaves the program, staff will indicate the date and reason for case
closure. Grantees have established rules to identify inactive cases that should be closed even if
not all services have been completed. Fields in section E are included in RPG Enrollment and
Exit-Extract 1.
RPG Case Closure
#

Field

E.1

RPG_CLOSE_DATE

Long
Name
RPG Case
Closure Date

Description

Valid values

Date case was
closed

Date format
MM/DD/YYYY

Required or
conditional field

Comment

Required (at case closure)

E.1 (RPG_
CLOSE_ DATE) >=
B.3 (RPG_
ENROLL_ DATE)
and
E.1 (RPG_
CLOSE_ DATE) >=
F.3 (EBP_
EXIT_DATE) for all
EBPs associated
with the case
RPG_CLOSE_DAT
E >= 1/1/2014 and
<= [Today’s Date]
Blank until case
closes out of RPG
program.
E.2

E.3

E.4

E.5

COMPLETED_
PROGRAM

Reason for
Case Closure:
Successfully
completed
RPG program

Indicator for case
closed due to
successful
completion of
RPG program

 Yes

FAMILY_MOVE

Reason for
Case Closure:
Family moved
out of area

Indicator for case
closed because
the family or case
members moved
out of the service
area

 Yes

UNABLE_TO_
LOCATE

Reason for
Case Closure:
Unable to
locate

Indicator for case
closed because
the grantee was
unable to locate
the family

 Yes

UNRESPONSIVE

Reason for
Case Closure:
Excessive
missed
appointments/
unresponsive

Indicator for case
closed due to
excessive missed
appointments or
because the case
became
unresponsive

 Yes

14

 Blank

 Blank

 Blank

 Blank

At least one field in E.2E.10 must = Yes (in other
words, all nine fields
cannot be blank)

Users may
indicate multiple
closure reasons

At least one field in E.2E.10 must = Yes

Users may
indicate multiple
closure reasons

At least one field in E.2E.10 must = Yes

Users may
indicate multiple
closure reasons

At least one field in E.2E.10 must = Yes

Users may
indicate multiple
closure reasons

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

Long
Name

Description

Valid values

Reason for
Case Closure:
Family
declined
further
participation

Indicator for cases
closed because
the family or case
members declined
to participate
further in RPG

 Yes

Reason for
Case Closure:
Transferred to
another service
provider

Indicator for case
closed because it
was transferred to
another service
provider

 Yes

MISC_OR_CHILD_
DEATH

Reason for
Case Closure:
Miscarriage or
fetal/child
death

Indicator for case
closed due to
miscarriage or
fetal or child death

 Yes

PARENT_DEATH

Reason for
Case Closure:
Parental death

Indicator for case
closed due to
parent’s death

 Yes

CASE_CLOSE_
OTHER

Reason for
Case Closure:
Other

Indicator for cases
closed due to
another reason

 Yes

E.11

SPECIFY_RPG_CAS
E_CLOSE

Reason for
Case Closure
Specification

Specification if the
user indicates an
“other” closure
reason

Text (240)

Required if E.10 (CASE_
CLOSE_OTHER) = Yes

E.12

FOCAL CHILD FFA
CARE EXIT

Focal Child in
Family
Functioning
Adult’s Care at
Exit

Indicator that focal
child was in family
functioning adult’s
care at time case
exited from RPG

 Yes

Required

#

Field

E.6

FAMILY_DECLINED

E.7

E.8

E.9

E.10

TRANSFERRED

15

 Blank

 Blank

 Blank

 Blank

 Blank

 No
 Don’t know

Required or
conditional field

Comment

At least one field in E.2E.10 must = Yes

Users may
indicate multiple
closure reasons

At least one field in E.2E.10 must = Yes

Users may
indicate multiple
closure reasons

At least one field in E.2E.10 must = Yes

Users may
indicate multiple
closure reasons

At least one field in E.2E.10 must = Yes

Users may
indicate multiple
closure reasons

At least one field in E.2E.10 must = Yes

Users may
indicate multiple
closure reasons

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

F. Enrollment in and Exit from Specific EBPs
Section F describes data elements that will be collected when at least one member of an
RPG case is enrolled in an EBP provided as part of a grantee’s RPG program, and one item
collected when the case members exit the EBP. For each EBP the grantee is implementing,
grantee staff will enter the enrollment and exit dates, the individual case members enrolled, and
caseworker information. “Caseworker” is intended as a generic term to refer to staff who
implement EBPs, including therapists, social workers, and others providing services directly to
RPG cases. Fields in Section F are included in EBP Enrollment and Exit-Extracts 2a, 2b, and 2c.
The EBP Enroll Date field is included in extracts 2 and 3 to link across extracts.
Enrollment and Exit into Specific EBPs
#
F.1

Field
EBPName

Long
name
EBP Name

Description
Name of EBP

Valid values
The set of RPG EBPs

Required or
conditional field
Required

Comment
Only one may
be selected.
Included in all
EBP Enrollment
and Exit
extracts (2a, 2b,
and 2c)

F.2

F.3

EBP_ENROLL_ DATE

EBP_EXIT_DATE

EBP
Enrollment
Date

Date case
members enrolled
in EBP

Date format
MM/DD/YYYY

EBP Exit Date

Date case
members exited
EBP

Date format
MM/DD/YYYY

Required

Included in
multiple
extracts: all EBP
Enrollment and
Exit extracts
(2a, 2b, and 2c)
and all Focal
EBP Service
Logs extracts
(3a and 3b)

Required to complete
RPG case closure
(Section E)

Included in
multiple
extracts: EBP
Enrollment and
Exit, Case fileExtract 2a and
Focal EBP
Service LogsCase file Extract
3a

Required

Users must
indicate that at
least one case
member is
participating in
the EBP.

F.2
(EBP_ENROLL_DAT
E) >= B.3 (RPG_
ENROLL_DATE)
EBP_ENROLL_DATE
>= 1/1/2014
and <= [Today’s Date]

F.3
(EBP_EXIT_DATE)
>= F.2
(EBP_ENROLL_DAT
E)
and F.3 (EBP EXIT
DATE) >= F.7
(CaseWorker_ExitDat
e)
EBP_EXIT_DATE
>= 1/1/2014
and <= [Today’s Date]
Blank until case exits
EBP.

F.4

IND_ID

Individual ID
(Case
Members
Participating
in EBP)

Individual IDs of
case members
participating in
EBP

Case members’
Individual IDs

16

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#

Field

Long
name

MATHEMATICA POLICY RESEARCH

Description

Valid values

Required or
conditional field

Comment
Users may
select multiple
case members.
Included in EBP
Enrollment and
Exit, Individual
file-Extract 2b.

F.5

F.6

CaseworkerName

CaseWorker_
StartDate

Caseworker(s
)
implementing
selected EBP
to RPG Case

Caseworker
Start Date

Name of
caseworker for
EBP

Date caseworker
began
assignment with
EBP and case

Caseworkers (all
grantee admin and
caseworker accounts
for the grantee)
Combination of A.8
(USER FIRST) and
A.9 (USER LAST)

Required

Date format
MM/DD/YYYY

Required

Each
caseworker
selected will
have a start
date
Included in EBP
Enrollment and
Exit,
Caseworker fileExtract 2c

Required if EBP exit date
is not blank

Each
caseworker
selected will
have an end
date.
Included in EBP
Enrollment and
Exit,
Caseworker fileExtract 2c

Users may
select multiple
caseworkers
Included in EBP
Enrollment and
Exit,
Caseworker fileExtract 2c

(CaseWorker_
StartDate) <= F.3
(EBP_EXIT_DATE)
F.6 (CaseWorker_
StartDate) <= F.7
(CaseWorker_ExitDat
e)
CaseWorker_StartDat
e
= 1/1/2014 and
<= [Today’s Date]

F.7

CaseWorker_ExitDate

Caseworker
End Date

Date Caseworker
completed
assignment with
EBP and case

Date format
MM/DD/YYYY
F.7
(CaseWorker_ExitDat
e) <= F.3
(EBP_EXIT_DATE)
nd F.7
(CaseWorker_ExitDat
e) >= F.6
(CaseWorker_
StartDate)
CaseWorker_
ExitDate <= [Today’s
Date]
Blank until case exits
EBP or caseworker
stops providing EBP
to the case.

17

At least one
caseworker
must be
associated with
each EBP
enrollment.

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#

Field

Long
name

MATHEMATICA POLICY RESEARCH

Description

Valid values

Required or
conditional field

Comment

F.8

CaseWorkerID

ID number for
Caseworker
implementing
selected EBP
to RPG Case

Systemgenerated ID
number for
caseworker for
EBP

Integer > 0

Auto-generated
by system
Included in EBP
Enrollment and
Exit,
Caseworker fileExtract 2c

F.9

CaseEBPID

EBP
Enrollment ID
number

Systemgenerated unique
numeric identifier
or each instance
of a case enrolling
into an EBP

Integer > 0

Auto-generated
by system

18

Included in
multiple
extracts: all EBP
Enrollment and
Exit extracts
(2a, 2b, and 2c),
all Focal EBP
Service Logs
extracts (3a and
3b), and Focal
EBP Participant
EngagementExtract 4

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

G. Service Contact Information
Sections G through R provide data elements collected only when RPG case members are
enrolled in one of the ten focal EBPs. Sections G through P consist of service contact
information collected for each session of each focal EBP, including the date of service, case
members present, session location, session duration, others present during the session, topics
covered, session activities, and the staff person’s assessment of the extent to which the session
went as planned. Fields in sections G through P are included in Focal EBP Service Logs, Session
file-Extract 3a, or Focal EBP Service Logs, Individual file-Extract 3b. Fields in section Q are
included in Participant Engagement-Extract 4.
Service Contact Information
#
G.1

Field
DATE_OF_SERVICE

Long
name
Date of
Service

Description
Date service was
rendered

Valid values
Date format
MM/DD/YYYY

Required or
conditional field
Required

Included in
multiple extracts:
Focal EBP
Service LogsExtracts 3a and
3b and
Participant
EngagementExtract 4

Required

When the user
adds a service log
to an EBP
enrollment, the
system will
automatically
associate the
correct focal EBP
with the service
log.

DATE OF SERVICE
>= 1/1/2014 and
<= [Today’s Date]

G.2

EBPName

EBP Name

Focal EBP
delivered during
session

Subset of all available
EBPs:
 Celebrating
Families!
 Child-Parent
Psychotherapy (CPP)
 Cognitive Behavior
Therapy (CBT)
 Hazelden Living in
Balance Program
(LIB)
 Matrix Model
Program
 Nurturing
Parenting Programs
(NPP)
 Parent and Child
Interactive Therapy
(PCIT)
 Seeking Safety
 Strengthen-ing
Families Program
 Trauma Focused
Cognitive Behavior
Therapy (TF-CBT)
 If a grantee has
requested to track
additional EBPs in the
ESL for its local
evaluation, other EBP
names may be
available in this field.

19

Comment

Included in
multiple extracts:
Focal EBP
Service LogsExtracts 3a and
3b and Participant
EngagementExtract 4

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#
G.3

Field
SESSION_
LOCATION

Long
name
Session
Location

MATHEMATICA POLICY RESEARCH

Description
Location where
services were
provided

Valid values
Numeric

Required or
conditional field
Required

 Residential
treatment facility = 1

Comment
Only one
response may be
selected

 Outpatient clinic =
2
 Primary residence
of case member(s) =
3
 Community site = 4
 Local government
site = 5
 School = 6
 Court = 7
 Adult’s workplace =
8
 Correctional facility
=9
 Hospital = 10
 Other (specify) =
11
 Blank
G.4

SESSION_
LOCATION_
SPECIFY_IF_
OTHER

Session
Location
Specification

Specification if
Session Location
is "Other"

Text (240)

Required if G.3
(SESSION_LOCATION_F
K) = 11 (Other)

G.5

SESSION_MINUTES

Session
Length

Session length in
minutes

Integer > 0 AND <
1000

Required

G.6

IND_ID

Individual ID
(Case
Members
Present at
Session)

Individual IDs of
case members
participating in
session

Case members’
Individual IDs

Required

Users must
indicate that at
least one case
member
participated in the
session.
Users may select
multiple case
members.
Included in Focal
EBP Service
Logs, Individual
file-Extract 3b.
Though users
select from a list
of names, only
Individual IDs
appear in the
extract.

G.7

OTHERS_PRESENT
_FOST_PRNT_
GUARD_YN

Others
present:
Foster parent/
guardian

Others individuals
in session: Foster
parent/guardian

 Yes
 Blank

20

Users may
indicate multiple
other individuals
in session

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#
G.8

Field

Long
name

MATHEMATICA POLICY RESEARCH

Description

Valid values

OTHERS_PRESENT
_INTERPRETER_YN

Others
present:
Interpreter

Others individuals
in session:
Interpreter

 Yes

OTHERS_PRESENT
_GRANT_STAFF_
MEMB_YN

Others
present: Other
grantee staff
member

Others individuals
in session: Other
grantee staff
member

 Yes

OTHERS_PRESENT
_OTH_RELAT_YN

Others
present: Other
relative of
case
member(s)

Others individuals
in session: Other
relative of case
member(s)

 Yes

OTHERS_PRESENT
_RPG_PART_
STAFF_YN

Others
present: RPG
partner staff

Others individuals
in session: RPG
partner staff

 Yes

OTHERS_PRESENT
_FID_OBS_YN

Others
present: Staff
conducting
fidelity
observation

Others individuals
in session: Staff
conducting fidelity
observation

 Yes

OTHERS_PRESENT
_HLTH_PROF_YN

Others
present:
Health
professional
(nurse, early
interventionist
/ Part C staff)

Others individuals
in session: Health
professional
(nurse, early
interventionist /
Part C staff)

 Yes

OTHERS_PRESENT
_SUPERVIS_YN

Others
present:
Supervisor

Others individuals
in session:
Supervisor

 Yes

OTHERS_PRESENT
_OTH_PROF_
STAFF_YN

Others
present: Other

Others individuals
in session: Other

 Yes

G.16

OTHERS_PRESENT
_SPECIFY_IF_
OTHER

Individuals in
Session
Specification

Specification if
Others present:
Other is indicated

Text (240)

G.17

SYSTEM_
TIMESTAMP_SL

System
Timestamp:
Date Service
Log
Completed

Web ESL system
timestamp for
date that the
service log screen
(which includes
data elements in
sections G – P)
was saved

Date format
MM/DD/YYYY

G.9

G.10

G.11

G.12

G.13

G.14

G.15

Required or
conditional field

Users may
indicate multiple
other individuals
in session

 Blank

Users may
indicate multiple
other individuals
in session

 Blank

Users may
indicate multiple
other individuals
in session

 Blank

Users may
indicate multiple
other individuals
in session

 Blank

Users may
indicate multiple
other individuals
in session

 Blank

Users may
indicate multiple
other individuals
in session

 Blank

Users may
indicate multiple
other individuals
in session

 Blank

Users may
indicate multiple
other individuals
in session

 Blank

21

Comment

Required if G.15
(OTHERS_ PRESENT
OTH_ PROF_ STAFF) =
Yes
Auto-generated
by system
Included in both
Focal EBP
Service Logs
extracts (3a and
3b)

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#

Field

Long
name

MATHEMATICA POLICY RESEARCH

Description

Valid values

Required or
conditional field

Comment

G.18

ServiceID

ID number for
service
contact record

System-generated
ID number for
service contact
record

Integer > 0

G.19

CaseworkerName

Caseworker(s)

Name of
caseworker who
entered the
service log

Caseworkers (all
grantee admin and
caseworker accounts
for the grantee)
Combination of A.8
(USER FIRST) and
A.9 (USER LAST)

Required

The name of the
caseworker who
enters the service
log is
automatically
associated with
the entry.
Included in Focal
EBP Service
Logs, Session
file-Extract 3a

G.20

CaseworkerID

Caseworker
ID number

System-generated
ID number for
caseworker who
entered the
service log

System-generated
caseworker ID
numbers

Required

The ID of the
caseworker who
enters the service
log is automatically associated
with the entry.
Included in Focal
EBP Service
Logs, Session
file-Extract 3a

22

Auto-generated
by system
Included in
multiple extracts:
Focal EBP
Service Logs,
Session fileExtract 3a and
Participant
EngagementExtract 4

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

H. Activities Conducted During Service Contact
For each session of a focal EBP, staff completing the service log indicate all activities
completed during the session, such as group discussions or family meetings. Fields in Section H
are included in Focal EBP Service Logs, Session file-Extract 3a.
Activities Conducted During Service Contact
#

Field

Long
name

H.1

SESSION_
ACTIVITIES_GRP_
DISC_YN

Session
Activity: Group
discussion

Group discussion
was included in
service contact

 Yes

SESSION_
ACTIVITIES_IND_DI
SC_YN

Session
Activity: Oneon-one
discussion

One-on-one
discussion was
included in service
contact

 Yes

SESSION_
ACTIVITIES_FAM_A
CT_INTER

Session
Activity: Case
activity/
interaction

Case
activity/interaction
was included in
service contact

 Yes

SESSION_
ACTIVITIES_FAM_
MTNG

Session
Activity: Family
meeting

Family meeting
was included in
service contact

 Yes

SESSION_
ACTIVITIES_
ROLE_PLAY

Session
Activity: Role
playing

Role playing was
included in service
contact

 Yes

SESSION_
ACTIVITIES_
REENACT

Session
Activity: Reenactments

Re-enactments
was included in
service contact

 Yes

SESSION_
ACTIVITIES_EXP_A
CT

Session
Activity:
Exposure to
trauma-related
triggers

Exposure to
trauma-related
triggers was
included in service
contact

 Yes

SESSION_
ACTIVITIES_
GAMES

Session
Activity:
Games/play

Games/play was
included in service
contact

 Yes

SESSION_
ACTIVITIES_
WORKSHEET

Session
Activity:
Worksheets

Worksheets was
included in service
contact

 Yes

SESSION_
ACTIVITIES_
WATCH_VID

Session
Activity:
Watching
videos

Watching videos
was included in
service contact

 Yes

SESSION_
ACTIVITIES_
GOAL_SET

Session
Activity: Goal
setting/plannin
g

Goal
setting/planning
was included in
service contact

 Yes

H.2

H.3

H.4

H.5

H.6

H.7

H.8

H.9

H.10

H.11

Description

Valid values
 Blank

 Blank

 Blank

 Blank

 Blank

 Blank

 Blank

 Blank

 Blank

 Blank

 Blank

23

Required or
conditional field

Comment

At least one field in H.1H.20 must = Yes (In other
words, all 20 fields cannot
be blank)

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#
H.12

H.13

H.14

H.15

H.16

H.17

H.18

H.19

H.20

H.21

Field

Long
name

MATHEMATICA POLICY RESEARCH

Description

Valid values

SESSION_
ACTIVITIES_
GUID_PRAC

Session
Activity:
Guided
practice

Guided practice
was included in
service contact

 Yes

SESSION_
ACTIVITIES_
COACH_FEED

Session
Activity:
Coaching/
feedback

Coaching/feedback
was included in
service contact

 Yes

SESSION_
ACTIVITIES_
PROV_EMOT_SUP
P

Session
Activity:
Provision of
emotional
support

Provision of
emotional support
was included in
service contact

 Yes

SESSION_
ACTIVITIES_
CRIS_INTER

Session
Activity: Crisis
intervention

Crisis intervention
was included in
service contact

 Yes

SESSION_
ACTIVITIES_
PRNT_SKILL_SCR

Session
Activity:
Parenting
skills
screening

Parenting skills
screening was
included in service
contact

 Yes

SESSION_ACTIVITI
ES_CHILD_DEV_S
CR

Session
Activity: Child
development
screening

Child development
screening was
included in service
contact

 Yes

SESSION_
ACTIVITIES_HLTH_
ASS

Session
Activity: Health
assessment

Health assessment
was included in
service contact

 Yes

SESSION_
ACTIVITIES_
MENT_HLTH_SUB_
ABUSE

Session
Activity:
Mental health/
substance use
disorder
screening

Mental
health/substance
use disorder
screening was
included in service
contact

 Yes

SESSION_
ACTIVITIES_
OTHER

Session
Activity: Other

Other activity was
included in service
contact

 Yes

SESSION_ACTIVITI
ES_SPECIFY_
OTHER

Activities
Conducted in
Session
Specification

Specification if
Session Activity:
Other is indicated

 Text (240)

 Blank

 Blank

 Blank

 Blank

 Blank

 Blank

 Blank

 Blank

 Blank

24

Required or
conditional field

Comment

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

At least one field in H.1H.20 must = Yes

Users may
indicate multiple
session
activities

Required if H.20
(SESSION_ACTIVITIES_O
THER) = Yes

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

I.

MATHEMATICA POLICY RESEARCH

Session Alignment with Session Plans

Section I includes a staff rating of how well the session plan aligned with what was actually
accomplished during the session. If the session was not “very well aligned” (that is, if it was only
somewhat aligned or not well aligned), then the staff member indicates one or more reasons for
this departure from plans. Fields in Section I are included in Focal EBP Service Logs, Session
file-Extract 3a.
Session Alignment with Session Plans
#
I.1

Field
SESSION_
ALIGNMENT

Long
name
Session
Alignment with
Plans

Description
Assessment of how
session
accomplishments
aligned with plans

Valid values
Numeric

Required or
conditional field

Comment

Required

 Very well aligned =
3
 Somewhat aligned
=2
 Not well aligned =
1

I.2

I.3

I.4

I.5

I.6

REASON_NOT_ALIG
N_FAM_CRIS

Reason Not
Well-Aligned:
Crisis among
case members

Session was not
well-aligned with
plans because of a
crisis among case
members

 Yes

REASON_NOT_ALIG
N_PART_NOT_ENG
AGE

Reason Not
Well-Aligned:
Participants
not engaged in
activity

Session was not
well-aligned with
plans because the
participants were
not engaged in the
activity

 Yes

REASON_NOT_ALIG
N_PART_INTER_OT
H_TOP

Reason Not
Well-Aligned:
Participants
interested in
topic other
than one
planned

Session was not
well-aligned with
plans because the
participants were
interested in topic
other than one
planned

 Yes

REASON_NOT_ALIG
N_PRES_OTH_IND_I
NHIB_SESS

Reason Not
Well-Aligned:
Presence of
other
individuals
inhibited
session
activities

Session was not
well-aligned with
plans because of
the presence of
other individuals
who inhibited
session activities

 Yes

REASON_NOT_ALIG
N_PART_SICK

Reason Not
Well-Aligned:
Participant(s)
were sick

Session was not
well-aligned with
plans because the
participant(s) were
sick

 Yes

 Blank

 Blank

 Blank

 Blank

 Blank

25

IF I.1 (SESSION
ALIGNMENT) = 2
(Somewhat aligned) or 1
(Not well aligned), then at
least one field in I.2-I.8
must = Yes (in other
words, all 7 fields cannot
be blank)

Users may
indicate multiple
reasons

IF I.1 (SESSION
ALIGNMENT) = 2 or 1, at
least one field in I.2-I.8
must = Yes

Users may
indicate multiple
reasons

IF I.1 (SESSION
ALIGNMENT) = 2 or 1, at
least one field in I.2-I.8
must = Yes

Users may
indicate multiple
reasons

IF I.1 (SESSION
ALIGNMENT) = 2 or 1, at
least one field in I.2-I.8
must = Yes

Users may
indicate multiple
reasons

IF I.1 (SESSION
ALIGNMENT) = 2 or 1, at
least one field in I.2-I.8
must = Yes

Users may
indicate multiple
reasons

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

Long
name

MATHEMATICA POLICY RESEARCH

#

Field

I.7

REASON_NOT_ALIG
N_PHYSC_CONST

Reason Not
Well-Aligned:
Physical space
constraints

Session was not
well-aligned with
plans because of
physical space
constraints

 Yes

REASON_NOT_ALIG
N_OTHER

Reason Not
Well-Aligned:
Other

There was another
reason the session
was not wellaligned with goals

 Yes

SPECIFY_REASON_
NOT_ALIGN

Reason
Session not
Well-Aligned
Specification

Specification if
reason not well
aligned: other is
indicated

Text” (240)

I.8

I.9

Description

Valid values
 Blank

 Blank

26

Required or
conditional field

Comment

IF I.1 (SESSION
ALIGNMENT) = 2 or 1, at
least one field in I.2-I.8
must = Yes

Users may
indicate multiple
reasons

IF I.1 (SESSION
ALIGNMENT) = 2 or 1, at
least one field in I.2-I.8
must = Yes

Users may
indicate multiple
reasons

Required if I.8 (REASON
NOT ALIGN OTHER) =
Yes

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

J. Substantive Areas Covered During Service Contact
For each session of a focal EBP, staff will indicate whether any of six substantive areas were
covered with case members in attendance. Sessions of focal EBPs will typically address topics in
at least one of the six areas. For each substantive area covered, a user provides more detailed
information on the extent to which individual topics in that area were discussed, via separate
topic grids. The data elements for the topic grids are shown in sections K through P, as
indicated in the comments. Fields in Section J are included in Focal EBP Service Logs, Session
file-Extract 3a.
Topics Covered During Service Contact
Long
name

Description

ADULT_TOPICS_S
UD

Parents’/Other
Adults’
Substance Use
Disorder
Treatment

Substantive areas
covered with adult
in session –
Substance Use
Disorder Treatment

 Yes

ADULT_TOPICS_P
RNT_SKILLS

Parents’/Other
Adults’
Parenting
Skills

Substantive areas
covered with adult
in session –
Parenting Skills

 Yes

ADULT_TOPICS_P
ERS_DEV

Parents’/Other
Adults’
Personal
Development

Substantive areas
covered with adult
in session –
Personal
Development

 Yes

YOUTH_TOPICS_T
HERAPY

Youth Therapy
and
Development

Substantive areas
covered with child
in session –
Therapy and
Development

 Yes

YOUTH_TOPICS_S
UD_ED

Education of
Youth on
Substance Use
Disorders and
Recovery

Substantive areas
covered with child
in session –
Education on
Substance Use
Disorders and
Recovery

 Yes

#

Field

J.1

J.2

J.3

J.4

J.5

Valid values

Required or
conditional field
Required

If this field =
Yes, the user will
be prompted to
fill out another
screen showing
several potential
subtopics. See
Section K.

Required

If this field =
Yes, the user will
be prompted to
fill out another
screen showing
several potential
subtopics. See
Section L.

Required

If this field =
Yes, the user will
be prompted to
fill out another
screen showing
several potential
subtopics. See
Section M.

Required

If this field =
Yes, the user will
be prompted to
fill out another
screen showing
several potential
subtopics. See
Section N.

Required

If this field =
Yes, the user will
be prompted to
fill out another
screen showing
several potential
subtopics. See
Section O.

 Blank

 Blank

 Blank

 Blank

 Blank

27

Comment

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#

Field

J.6

OTHREL_TOPICS_
SUD_ED

Long
name

Description

Education of
Parents/Other
Adults Not
Receiving
Substance Use
Treatment on
Substance Use
Disorders and
Recovery

Substantive areas
covered with other
adults in or related
to the case in
session –
Education on
Substance Use
Disorders and
Recovery

MATHEMATICA POLICY RESEARCH

Valid values
 Yes
 Blank

28

Required or
conditional field
Required

Comment
If this field =
Yes, the user will
be prompted to
fill out another
screen showing
several potential
subtopics. See
Section P.

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

K. Topics Covered During the Session: Parents’/Other Adults’
Substance Use Disorder Treatment
Fields in Section K indicate the extent to which the below topics related to substance use
disorder treatment were covered with adult case members during the session. These fields are
included in Focal EBP Service Logs, Session file-Extract 3a.
Substance Use Disorder Treatment, Parents, or Other Adults in RPG Case
Topics
#

Field

K.1

ADULT_SUD_T1

Long
name
Parents’/Other
Adults’
Substance Use
Disorder
Treatment
Topic 1

Description
Acknowledging a
substance use
problem

Valid values

Required or
conditional field
Only asked if J.1 (ADULT_
TOPICS_ SUD) = Yes.
Required if asked

If J.1 =Yes,
default for each
item in Section
K is “Did not
discuss”.
If J.1= blank, all
items in Section
K remain blank

Only asked if J.1 (ADULT_
TOPICS_ SUD) = Yes.
Required if asked

If J.1 =Yes,
default for each
item in Section
K is “Did not
discuss”.
If J.1= blank, all
items in Section
K remain blank

 Primary topic for
session

Only asked if J.1 (ADULT_
TOPICS_ SUD) = Yes.

 One of several
topics

Required if asked

If J.1 =Yes,
default for each
item in Section
K is “Did not
discuss”.
If J.1= blank, all
items in Section
K remain blank

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

K.2

ADULT_SUD_T2

Parents’/Other
Adults’
Substance Use
Disorder
Treatment
Topic 2

Discussing
readiness to
change

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

K.3

ADULT_SUD_T3

Parents’/Other
Adults’
Substance Use
Disorder
Treatment
Topic 3

Discussing past
successful
behavioral
changes

 Touched on topic
 Did not discuss
 Blank

K.4

ADULT_SUD_T4

Parents’/Other
Adults’
Substance Use
Disorder
Treatment
Topic 4

Identifying and
preventing
destructive
behaviors

 Primary topic for
session
 One of several
topics

Only asked if J.1 (ADULT_
TOPICS_ SUD) = Yes.
Required if asked

 Touched on topic
 Blank

ADULT_SUD_T5

Parents’/Other
Adults’
Substance Use
Disorder
Treatment
Topic 5

Identifying triggers
and cravings

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

29

If J.1 =Yes,
default for each
item in Section
K is “Did not
discuss”.
If J.1= blank, all
items in Section
K remain blank

 Did not discuss
K.5

Comment

Only asked if J.1 (ADULT_
TOPICS_ SUD) = Yes.
Required if asked

If J.1 =Yes,
default for each
item in Section
K is “Did not
discuss”.
If J.1= blank, all
items in Section
K remain blank

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#

Field

K.6

ADULT_SUD_T6

Long
name
Parents’/Other
Adults’
Substance Use
Disorder
Treatment
Topic 6

Description
Enacting plan for
change and
recovery

MATHEMATICA POLICY RESEARCH

Valid values
 Primary topic for
session
 One of several
topics

Required or
conditional field
Only asked if J.1 (ADULT_
TOPICS_ SUD) = Yes.
Required if asked

If J.1 =Yes,
default for each
item in Section
K is “Did not
discuss”.
If J.1= blank, all
items in Section
K remain blank

Only asked if J.1 (ADULT_
TOPICS_ SUB_ABUSE) =
Yes.
Required if asked

If J.1 =Yes,
default for each
item in Section
K is “Did not
discuss”.

 Touched on topic
 Did not discuss
 Blank

K.7

ADULT_SUD_T7

Parents’/Other
Adults’
Substance Use
Disorder
Treatment
Topic 7

Developing a
relapse plan

 Primary topic for
session
 One of several
topics
 Touched on topic

If J.1= blank, all
items in Section
K remain blank

 Did not discuss
 Blank
K.8

ADULT_SUD_T8

Parents’/Other
Adults’
Substance Use
Disorder
Treatment
Topic 8

Fostering honesty
and responsibility

Only asked if J.1 (ADULT_
TOPICS_ SUD) = Yes.
Required if asked

If J.1 =Yes,
default for each
item in Section
K is “Did not
discuss”.
If J.1= blank, all
items in Section
K remain blank

Only asked if J.1 (ADULT_
TOPICS_ SUD) = Yes.
Required if asked

If J.1 =Yes,
default for each
item in Section
K is “Did not
discuss”.
If J.1= blank, all
items in Section
K remain blank

 Primary topic for
session

Only asked if J.1 (ADULT_
TOPICS_ SUD) = Yes.

 One of several
topics

Required if asked

If J.1 =Yes,
default for each
item in Section
K is “Did not
discuss”.

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

K.9

ADULT_SUD_T9

Parents’/Other
Adults’
Substance Use
Disorder
Treatment
Topic 9

Fostering self-help
skills

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

K.10

ADULT_SUD_T10

Parents’/Other
Adults’
Substance Use
Disorder
Treatment
Topic 10

Providing
information on
abuse and trauma

 Touched on topic

If J.1= blank, all
items in Section
K remain blank

 Did not discuss
 Blank
K.11

ADULT_SUD_T11

Parents’/Other
Adults’
Substance Use
Disorder
Treatment
Topic 11

Developing
understanding of
substance use
disorders and their
effects

 Primary topic for
session
 One of several
topics

Only asked if J.1 (ADULT_
TOPICS_ SUD) = Yes.
Required if asked

If J.1 =Yes,
default for each
item in Section
K is “Did not
discuss”.
If J.1= blank, all
items in Section
K remain blank

Only asked if J.1 (ADULT_
TOPICS_ SUD) = Yes.
Required if asked

If J.1 =Yes,
default for each
item in Section
K is “Did not
discuss”.

 Touched on topic
 Did not discuss
 Blank

K.12

ADULT_SUD_T12

Parents’/Other
Adults’
Substance Use
Disorder
Treatment
Topic 12

Addressing guilt,
loss, and grief

Comment

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss

30

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#

Field

Long
name

Description

MATHEMATICA POLICY RESEARCH

Valid values

Required or
conditional field

K.13

ADULT_SUD_T13

Parents’/Other
Adults’
Substance Use
Disorder
Treatment
Topic 13

Developing support
networks

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

31

Comment
If J.1= blank, all
items in Section
K remain blank

 Blank

Only asked if J.1 (ADULT_
TOPICS_ SUD) = Yes.
Required if asked

If J.1 =Yes,
default for each
item in Section
K is “Did not
discuss”.
If J.1= blank, all
items in Section
K remain blank

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

L. Topics Covered During the Session: Parents’/Other Adults’
Parenting Skills
Fields in Section L indicate the extent to which the below topics related to parenting skills
were covered with adult case members during the session. These fields are included in Focal
EBP Service Logs, Session file-Extract 3a.
Parenting Skills, Parents or Other Adults in RPG Case Topics
#
L.1

Field
ADULT_
PARENT_
SKILLS_T1

Long
name
Parents’/Other
Adults’
Parenting Skills
Topic 1

Description
Fostering parent’s
ability to effectively
communicate with
child

Valid values

Required or
conditional field

 Primary topic for
session

Only asked if J.2 (ADULT_
TOPICS_

 One of several
topics

PRNT_SKILLS) = Yes.
Required if asked

 Touched on topic
 Blank
ADULT_
PARENT_
SKILLS_T2

Parents’/Other
Adults’
Parenting Skills
Topic 2

Teaching parent
how to develop
child’s
communication and
social skills

 Primary topic for
session
 One of several
topics

Only asked if J.2 (ADULT_
TOPICS_
PRNT_SKILLS) = Yes.
Required if asked

If J.2 =Yes,
default for each
item in Section
L is “Did not
discuss”.
If J.2= blank, all
items in Section
L remain blank

Only asked if J.2 (ADULT_
TOPICS_
PRNT_SKILLS) = Yes.

If J.2 =Yes,
default for each
item in Section
L is “Did not
discuss”.
If J.2= blank, all
items in Section
L remain blank

 Touched on topic
 Did not discuss
 Blank

L.3

ADULT_
PARENT_
SKILLS_T3

Parents’/Other
Adults’
Parenting Skills
Topic 3

Teaching parent
about child growth
and development

 Primary topic for
session
 One of several
topics

Required if asked

 Touched on topic
 Did not discuss
 Blank
L.4

ADULT_
PARENT_
SKILLS_T4

Parents’/Other
Adults’
Parenting Skills
Topic 4

Teaching parent
how to establish
care-giving routines

 Primary topic for
session

Only asked if J.2 (ADULT_
TOPICS_

 One of several
topics

PRNT_SKILLS) = Yes.
Required if asked

 Touched on topic
 Did not discuss
 Blank
L.5

ADULT_
PARENT_
SKILLS_T5

Parents’/Other
Adults’
Parenting Skills
Topic 5

Teaching parent to
serve as a secure
emotional base for
child

 Primary topic for
session
 One of several
topics

If J.2 =Yes,
default for each
item in Section
L is “Did not
discuss”.
If J.2= blank, all
items in Section
L remain blank

Only asked if J.2 (ADULT_
TOPICS_
PRNT_SKILLS) = Yes.

If J.2 =Yes,
default for each
item in Section
L is “Did not
discuss”.

 Did not discuss
 Blank
ADULT_
PARENT_
SKILLS_T6

Parents’/Other
Adults’
Parenting Skills
Topic 6

Fostering parent’s
understanding of
and ability to
develop child
autonomy

 Primary topic for
session
 One of several
topics

32

If J.2 =Yes,
default for each
item in Section
L is “Did not
discuss”.
If J.2= blank, all
items in Section
L remain blank

Only asked if J.2 (ADULT_
TOPICS_
PRNT_SKILLS) = Yes.
Required if asked

 Touched on topic

L.6

If J.2 =Yes,
default for each
item in Section
L is “Did not
discuss”.
If J.2= blank, all
items in Section
L remain blank

 Did not discuss
L.2

Comment

Required if asked

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#

Field

Long
name

Description

MATHEMATICA POLICY RESEARCH

Valid values

Required or
conditional field

 Did not discuss
 Blank
L.7

ADULT_
PARENT_
SKILLS_T7

Parents’/Other
Adults’
Parenting Skills
Topic 7

Teaching parent
strategies to
promote positive
family interactions

 Primary topic for
session
 One of several
topics

Only asked if J.2 (ADULT_
TOPICS_
PRNT_SKILLS) = Yes.
Required if asked

 Touched on topic
 Blank

L.9

ADULT_
PARENT_
SKILLS_T8

ADULT_
PARENT_
SKILLS_T9

Parents’/Other
Adults’
Parenting Skills
Topic 8

Parents’/Other
Adults’
Parenting Skills
Topic 9

Teaching parent to
manage child’s
misbehavior, foster
positive behavior,
and set
development-ally
appropriate rules
and consequences

 Primary topic for
session

Educating parent
about pre-teen and
teen sex and STIs

 Primary topic for
session

Only asked if J.2 (ADULT_
TOPICS_

 One of several
topics

PRNT_SKILLS) = Yes.
Required if asked

 One of several
topics

Only asked if J.2 (ADULT_
TOPICS_
PRNT_SKILLS) = Yes.
Required if asked

 Touched on topic
 Did not discuss
 Blank

 Touched on topic
 Did not discuss
 Blank
L.10

ADULT_
PARENT_
SKILLS_T10

Parents’/Other
Adults’
Parenting Skills
Topic 10

Educating parent
about child/
adolescent
substance use

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

33

If J.2 =Yes,
default for each
item in Section
L is “Did not
discuss”.
If J.2= blank, all
items in Section
L remain blank

 Did not discuss
L.8

Comment
If J.2= blank, all
items in Section
L remain blank

 Touched on topic

Only asked if J.2 (ADULT_
TOPICS_
PRNT_SKILLS) = Yes.
Required if asked

If J.2 =Yes,
default for each
item in Section
L is “Did not
discuss”.
If J.2= blank, all
items in Section
L remain blank
If J.2 =Yes,
default for each
item in Section
L is “Did not
discuss”.
If J.2= blank, all
items in Section
L remain blank
If J.2 =Yes,
default for each
item in Section
L is “Did not
discuss”.
If J.2= blank, all
items in Section
L remain blank

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

M. Topics Covered During the Session: Parents’/Other Adults’ Personal
Development
Fields in Section M indicate the extent to which the below topics related to personal
development were covered with adult case members during the session. These fields are included
in Focal EBP Service Logs, Session file-Extract 3a.
Personal Development, Parents or Other Adults in RPG Case Topics
#
M.1

Field
ADULT_
PERSONAL_
DEV_T1

Long
name
Parents’/Other
Adults’ Personal
Development
Topic 1

Description
Fostering
communication
and social skills

Valid values

Required or
conditional field

 Primary topic for
session

Only asked if J.2 (ADULT_
TOPICS_

 One of several topics

PERS_DEV) = Yes.
Required if asked

 Touched on topic
 Did not discuss
 Blank

M.2

ADULT_
PERSONAL_
DEV_T2

Parents’/Other
Adults’ Personal
Development
Topic 2

Fostering
resiliency

 Primary topic for
session

Only asked if J.2 (ADULT_
TOPICS_

 One of several topics

PERS_DEV) = Yes.
Required if asked

 Touched on topic
 Did not discuss

ADULT_
PERSONAL_
DEV_T3

Parents’/Other
Adults’ Personal
Development
Topic 3

Fostering
empathy and
kindness

 Primary topic for
session

Only asked if J.2 (ADULT_
TOPICS_

 One of several topics

PERS_DEV) = Yes.
Required if asked

 Touched on topic
 Did not discuss

ADULT_
PERSONAL_
DEV_T4

Parents’/Other
Adults’ Personal
Development
Topic 4

Learning to
identify and
express feelings

 Primary topic for
session

Only asked if J.2 (ADULT_
TOPICS_

 One of several topics

PERS_DEV) = Yes.
Required if asked

 Touched on topic
 Did not discuss

ADULT_ _
PERSONAL_
DEV_T5

Parents’/Other
Adults’ Personal
Development
Topic 5

Fostering skills to
manage emotions

 One of several topics

Only asked if J.2 (ADULT_
TOPICS_
PERS_DEV) = Yes.

 Touched on topic

Required if asked

 Primary topic for
session

 Did not discuss

34

If J.3 =Yes,
default for
each item in
Section M is
“Did not
discuss”.

If J.3 =Yes,
default for
each item in
Section M is
“Did not
discuss”.
If J.3= blank,
all items in
Section M
remain blank

 Blank

M.5

If J.3 =Yes,
default for
each item in
Section M is
“Did not
discuss”.

If J.3= blank,
all items in
Section M
remain blank

 Blank

M.4

If J.3 =Yes,
default for
each item in
Section M is
“Did not
discuss”.
If J.3= blank,
all items in
Section M
remain blank

If J.3= blank,
all items in
Section M
remain blank

 Blank

M.3

Comment

If J.3 =Yes,
default for
each item in
Section M is
“Did not
discuss”.

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#

Field

Long
name

Description

MATHEMATICA POLICY RESEARCH

Valid values

Required or
conditional field

M.6

ADULT_
PERSONAL_
DEV_T6

Parents’/Other
Adults’ Personal
Development
Topic 6

Developing life
management
skills

 Primary topic for
session

Only asked if J.2 (ADULT_
TOPICS_

 One of several topics

PERS_DEV) = Yes.
Required if asked

 Touched on topic
 Did not discuss
 Blank

M.7

ADULT_
PERSONAL_
DEV_T7

Parents’/Other
Adults’ Personal
Development
Topic 7

Fostering ability
and commitment
to making healthy
choices

 Primary topic for
session

Only asked if J.2 (ADULT_
TOPICS_

 One of several topics

PERS_DEV) = Yes.
Required if asked

 Touched on topic
 Did not discuss

ADULT_
PERSONAL_
DEV_T8

Parents’/Other
Adults’ Personal
Development
Topic 8

Fostering healthy,
safe relationships
and boundaries

 Primary topic for
session

Only asked if J.2 (ADULT_
TOPICS_

 One of several topics

PERS_DEV) = Yes.
Required if asked

 Touched on topic
 Did not discuss

ADULT_
PERSONAL_
DEV_T9

Parents’/Other
Adults’ Personal
Development
Topic 9

Processing
trauma and
developing a
trauma narrative

 Primary topic for
session

Only asked if J.2 (ADULT_
TOPICS_

 One of several topics

PERS_DEV) = Yes.
Required if asked

 Touched on topic
 Did not discuss
 Blank

35

If J.3 =Yes,
default for
each item in
Section M is
“Did not
discuss”.

If J.3 =Yes,
default for
each item in
Section M is
“Did not
discuss”.
If J.3= blank,
all items in
Section M
remain blank

 Blank

M.9

If J.3 =Yes,
default for
each item in
Section M is
“Did not
discuss”.
If J.3= blank,
all items in
Section M
remain blank

If J.3= blank,
all items in
Section M
remain blank

 Blank

M.8

Comment
If J.3= blank,
all items in
Section M
remain blank

 Blank

If J.3 =Yes,
default for
each item in
Section M is
“Did not
discuss”.
If J.3= blank,
all items in
Section M
remain blank

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

N. Topics Covered During the Session: Youth Therapy and
Development
Fields in Section N indicate the extent to which the below topics related to therapy and
development were covered with child case members during the session. These fields are included
in Focal EBP Service Logs, Session file-Extract 3a.
Youth Therapy and Development, Youth in RPG Case Topics
#
N.1

Field
YOUTH_
THERAPY_T1

Long
name
Youth Therapy
and
Development
Topic 1

Description

Valid values

Required or
conditional field

Fostering
communication and
social skills

 Primary topic for
session

Only asked if J.4 YOUTH_
TOPICS_ THERAPY) = Yes.

 One of several
topics

Required if asked

 Touched on topic
 Did not discuss

Comment
If J.4 =Yes, default
for each item in
Section N is “Did
not discuss”.
If J.4 = blank, all
items in Section N
remain blank

 Blank
N.2

YOUTH_
THERAPY_T2

Youth Therapy
and
Development
Topic 2

Fostering resiliency

 Primary topic for
session
 One of several
topics

Only asked if J.4 (YOUTH_
TOPICS_ THERAPY) = Yes.
Required if asked

If J.4 =Yes, default
for each item in
Section N is “Did
not discuss”.
If J.4 = blank, all
items in Section N
remain blank

 Touched on topic
 Did not discuss
 Blank
N.3

YOUTH_
THERAPY_T3

Youth Therapy
and
Development
Topic 3

Fostering empathy
and kindness

Only asked if J.4 (YOUTH_
TOPICS_ THERAPY) = Yes.
Required if asked

If J.4 =Yes, default
for each item in
Section N is “Did
not discuss”.
If J.4 = blank, all
items in Section N
remain blank

 Primary topic for
session

Only asked if J.4 (YOUTH_
TOPICS_ THERAPY) = Yes.

 One of several
topics

Required if asked

If J.4 =Yes, default
for each item in
Section N is “Did
not discuss”.
If J.4 = blank, all
items in Section N
remain blank

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

N.4

YOUTH_
THERAPY_T4

Youth Therapy
and
Development
Topic 4

Learning to identify
and express
feelings

 Touched on topic
 Did not discuss
 Blank
N.5

YOUTH_
THERAPY_T5

Youth Therapy
and
Development
Topic 5

Fostering skills to
manage emotions

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

36

Only asked if J.4 (YOUTH_
TOPICS_ THERAPY) = Yes.
Required if asked

If J.4 =Yes, default
for each item in
Section N is “Did
not discuss”.
If J.4 = blank, all
items in Section N
remain blank

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

#
N.6

Field
YOUTH_
THERAPY_T6

Long
name
Youth Therapy
and
Development
Topic 6

MATHEMATICA POLICY RESEARCH

Description

Valid values

Developing life
management skills

 Primary topic for
session

Required or
conditional field

Comment

Only asked if J.4 (YOUTH_
TOPICS_ THERAPY) = Yes.
Required if asked

If J.4 =Yes, default
for each item in
Section N is “Did
not discuss”.
If J.4 = blank, all
items in Section N
remain blank

 Primary topic for
session

Only asked if J.4 (YOUTH_
TOPICS_ THERAPY) = Yes.

 One of several
topics

Required if asked

If J.4 =Yes, default
for each item in
Section N is “Did
not discuss”.
If J.4 = blank, all
items in Section N
remain blank

 One of several
topics
 Touched on topic
 Did not discuss
 Blank

N.7

YOUTH_
THERAPY_T7

Youth Therapy
and
Development
Topic 7

Fostering ability and
commitment to
making healthy
choices

 Touched on topic
 Did not discuss
 Blank
N.8

YOUTH_
THERAPY_T8

Youth Therapy
and
Development
Topic 8

Fostering healthy,
safe relationships
and boundaries

 Primary topic for
session
 One of several
topics

Only asked if J.4 (YOUTH_
TOPICS_ THERAPY) = Yes.
Required if asked

If J.4 =Yes, default
for each item in
Section N is “Did
not discuss”.
If J.4 = blank, all
items in Section N
remain blank

 Touched on topic
 Did not discuss
 Blank
N.9

YOUTH_
THERAPY_T9

Youth Therapy
and
Development
Topic 9

Processing trauma
and developing a
trauma narrative

Only asked if J.4 (YOUTH_
TOPICS_ THERAPY) = Yes.
Required if asked

If J.4 =Yes, default
for each item in
Section N is “Did
not discuss”.
If J.4 = blank, all
items in Section N
remain blank

 Primary topic for
session

Only asked if J.4 (YOUTH_
TOPICS_ THERAPY) = Yes.

 One of several
topics

Required if asked

If J.4 =Yes, default
for each item in
Section N is “Did
not discuss”.
If J.4 = blank, all
items in Section N
remain blank

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

N.10

YOUTH_
THERAPY_T10

Youth Therapy
and
Development
Topic 10

Developing honesty,
responsibility, and
cooperation

 Touched on topic
 Did not discuss
 Blank
N.11

YOUTH_
THERAPY_T11

Youth Therapy
and
Development
Topic 11

Developing a
positive support
network

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

37

Only asked if J.4 (YOUTH_
TOPICS_ THERAPY) = Yes.
Required if asked

If J.4 =Yes, default
for each item in
Section N is “Did
not discuss”.
If J.4 = blank, all
items in Section N
remain blank

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

O. Topics Covered During the Session: Education of Youth on
Substance Use Disorders and Recovery
Fields in Section O indicate the extent to which the below topics related to education on
substance use disorders and recovery were covered with child case members during the session.
These fields are included in Focal EBP Service Logs, Session file-Extract 3a.
Education on Substance Use Disorders and Recovery, Youth in RPG Case
Topics
#
O.1

Field
YOUTH_SUD_ED
_T1

Long
name
Education of
Youth on
Substance Use
Disorders and
Recovery
Topic 1

Description
Discussing risk
factors for youth
developing
substance use
disorder

Valid values

Required or
conditional field
Only asked if J.5 (YOUTH_
TOPICS_SUD_ED) = Yes.
Required if asked

If J.5 =Yes,
default for each
item in Section
O is “Did not
discuss”.
If J.5 = blank,
all items in
Section O
remain blank

 Primary topic for
session

Only asked if J.5 (YOUTH_
TOPICS_SUD_ED) = Yes.

 One of several
topics

Required if asked

If J.5 =Yes,
default for each
item in Section
O is “Did not
discuss”.
If J.5 = blank,
all items in
Section O
remain blank

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

O.2

YOUTH_SUD_ED
_T2

Education of
Youth on
Substance Use
Disorders and
Recovery
Topic 2

Discussing impact
of substance use
disorders on family,
friends, and
relationships

 Touched on topic
 Did not discuss
 Blank

O.3

YOUTH_SUD_ED
_T3

Education of
Youth on
Substance Use
Disorders and
Recovery
Topic 3

Discussing relapse
prevention

Only asked if J.5 (YOUTH_
TOPICS_SUD_ED) = Yes.
Required if asked

If J.5 =Yes,
default for each
item in Section
O is “Did not
discuss”.
If J.5 = blank,
all items in
Section O
remain blank

Only asked if J.5 (YOUTH_
TOPICS_SUD_ED) = Yes.
Required if asked

If J.5 =Yes,
default for each
item in Section
O is “Did not
discuss”.
If J.5 = blank,
all items in
Section O
remain blank

 Primary topic for
session

Only asked if J.5 (YOUTH_
TOPICS_SUD_ED) = Yes.

 One of several
topics

Required if asked

If J.5 =Yes,
default for each
item in Section
O is “Did not
discuss”.
If J.5 = blank,
all items in
Section O
remain blank

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

O.4

YOUTH_SUD_ED
_T4

Education of
Youth on
Substance Use
Disorders and
Recovery
Topic 4

Educating on
biology of addiction

 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

O.5

YOUTH_SUD_ED
_T5

Education of
Youth on
Substance Use
Disorders and
Recovery
Topic 5

Educating on
medical effects of
substance use

Comment

 Touched on topic
 Did not discuss
 Blank

38

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

P. Topics Covered During the Session: Education of Other Relatives on
Substance Use Disorders and Recovery
Fields in Section P indicate the extent to which the below topics related to the education of
substance use disorders and recovery were covered with other adults in, or affiliated with, the
case but are not directly receiving substance use treatment during the session. These fields are
included in Focal EBP Service Logs, Session file-Extract 3a.
Education on Substance Use Disorders and Recovery, Other Relatives Not in
RPG Case Topics
#

Field

Long name

Description

P.1

OTHREL_SUD
_ED _ T1

Education of
Parents/Other
Adults Not
Receiving
Substance Use
Treatment on
Substance Use
Disorders and
Recovery Topic 1

Discussing impact
of substance use
disorders on family,
friends, and
relationships

Education of
Parents/Other
Adults Not
Receiving
Substance Use
Treatment on
Substance Use
Disorders and
Recovery Topic 2

Discussing relapse
prevention

Education of
Parents/Other
Adults Not
Receiving
Substance Use
Treatment on
Substance Use
Disorders and
Recovery Topic 3

Educating on
biology of addiction

Education of
Parents/Other
Adults Not
Receiving
Substance Use
Treatment on
Substance Use
Disorders and
Recovery Topic 4

Educating on the
medical effects of
substance use

P.2

P.3

P.4

OTHREL_SUD
_ED _ T2

OTHREL_SUD
_ED _ T3

OTHREL_SUD
_ED _ T4

Valid values
 Primary topic for
session
 One of several
topics

Required or
conditional field

Comment

Only asked if J.6
(OTHREL_
TOPICS_SUD_ED) = Yes.
Required if asked

If J.6 =Yes, default
for each item in
Section P is “Did
not discuss”.
If J.6 = blank, all
items in Section P
remain blank

Only asked if J.6
(OTHREL_
TOPICS_SUD_ED) = Yes.
Required if asked

If J.6 =Yes, default
for each item in
Section P is “Did
not discuss”.
If J.6 = blank, all
items in Section P
remain blank

Only asked if J.6
(OTHREL_
TOPICS_SUD_ED) = Yes.
Required if asked

If J.6 =Yes, default
for each item in
Section P is “Did
not discuss”.
If J.6 = blank, all
items in Section P
remain blank

Only asked if J.6
(OTHREL_
TOPICS_SUD_ED) = Yes.
Required if asked

If J.6 =Yes, default
for each item in
Section P is “Did
not discuss”.

 Touched on topic
 Did not discuss
 Blank
 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank
 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank
 Primary topic for
session
 One of several
topics
 Touched on topic
 Did not discuss
 Blank

39

If J.6 = blank, all
items in Section P
remain blank

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

Q. Engagement Rating
At two points during enrollment in a focal EBP—after the second service contact and at
exit from the EBP—staff are prompted to provide a rating of the participating case members’
engagement in the EBP. Fields in Section Q are included in Participant Engagement-Extract 4.
Engagement Rating (after second service contact and EBP exit)
#
Q.1

Field
ParticipantsEngage
mentScale

Long
name
Participant
Engagement
Rating

Description

Valid values

Rating of case's
engagement to
date in EBP

 4 - Participants
were consistently
highly involved in
services
 3 - Participants'
involvement
varied.

Required or
conditional field
Required

Comment
Delivered twice
during focal EBP
enrollment
Only one may
response be
selected

 2 - Participants'
involvement was
consistently low.
 1 - Participants
were minimally or
not involved at all.
Q.2

ENGAGEMENT
TIMESTAMP

System
Timestamp:
Date Participant
Engagement
Scale
Completed

Web ESL system
timestamp for date
that the
engagement scale
(Q.1) was
completed

40

Date format
MM/DD/YYYY

Auto-generated
by system
Included in
Focal EBP
Participant
EngagementExtract 4

RPG CROSS-SITE EVALUATION DATA COLLECTION SYSTEM:
ESL DATA DICTIONARY

MATHEMATICA POLICY RESEARCH

R. Service Contact Check if No Contact Data Entered for Two Weeks
The data related to this extract is currently not being collected in ESL Version 1.7.
Mathematica will provide a description of these data in future versions of the ESL.

41