ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
DictionaryDescriptionDate Range FieldStart DateThrough Date
2
Department of Human Services (DHS) Program Eligibility and Payments
3
Bridges_EligibilityBridges Eligibilty data for several programs by Eco_Id and Year MonthElig_Month_Date9/1/20165/1/2021
4
Bridges_PeoplePerson Table From Bridges DataN/AN/A
5
CCAP_Payment_MonthsPayments data for the DHS Child Care Assistance Program (CCAP)12/1/20198/1/2020
6
Rhode Island Department of Health
7
COVID_Cases_HospitalizationsCOVID Cases with a Hospizalization Indicator
Result_Or_Update_Date
3/1/20207/7/2021
8
COVID_TestsCOVID TestsResult_Date3/1/20207/7/2021
9
COVID_VaccinationsCOVID Vaccination data
Date_of_Administration
12/14/20206/29/2021
10
Medicaid_Enrollment_By_BandMedicaid Enrollment by Analysis Category, from January 2018 to date. Month_Start1/1/20186/1/2021
11
Over_Dose_DeathsA listing of all Rhode Island residents, who have died of an overdose. 12/1/20188/31/2020
12
Developmental Disabilities
13
CD_UniversalIdentifies information about the Developmental Disabilities population that is covered by a 2014 Consent Decree. This table is for use by that project only and is not updated.
First_Employment_Date
1/1/20123/31/2019
14
Department of Children, Youth and Families (DCYF)
15
DCYF_PeopleAll people who were the placed child in the [DCYF_Placements] table or the Victim or Perpetrator in the [DCYF_Indicated_Allegations] table. Note that there are older data in this table, but reliability is confirmed only from 1997 forward. 1/1/1997Up-to-date
16
DCYF_Indicated_Allegations1/1/1997Up-to-date
17
DCYF_Placements1/1/1997Up-to-date
18
DCYF_Summary_Year1/1/1997Up-to-date
19
Accountable Entities Attribution Data
Provided by EOHHS from the MMIS system via Gainwell Technologies
20
AE_StatusAccountable Entity provider plan information and member attributionEnroll_Start_Date_DTL7/1/20075/31/2021
21
Medicaid Claims and Related Data
22
ADL_ScoreActivities For Daily Living (ADL) Refence CodesN/AN/A
23
BH_BHDDH_CLAIMS_POPULATIONIdentifies Medicaid enrollees who have Behaorial Health Claims for a given month, as defined by Department of Behavorial Healthcare, Developmental Disabilities, and Hospitals (BHDDH)N/AN/A
24
Date_RefDate Dimension, only for use with Medicaid claims1/1/20009/25/2025
25
Diagnosis_CodeRef table with diag codes and descriptionsN/AN/A
26
Diagnosis_Code_CCSRClinical Classifications Software Refined (CCSR) for ICD-10-CM DiagnosesN/AN/A
27
Eco_ID_to_RE_UID_MapA lookup table from Eco_ID to RE_UID, the Medicaid datawarehouse anonymous ID. N/AN/A
28
ED_Visits_NYU_AlgorithmMedicaid Emergency Department Visits, based on a library of diagnosis codes developed by New York University (NYU)7/1/20137/9/2021
29
Head_Of_Household_XwalkRough approximation for Household links based on Medicaid Claims data. N/AN/A
30
LTSS_Interim_PaymentsData regarding the recoupment of Interim Payments made to Nursing HomesN/AN/A
31
LTSS_Application_BacklogA table used the EOHHS Medicaid Team to monitor LTSS Application backlogs. 5/4/2021 - Pending confirmation from Rebecca M. that this is still needed, before adding to the data dictionary.
32
Medicaid_Birth_CodesA set of Procedure and Diagnosis Codes that identify C Section and natural births. It is used to build the Medicaid Claims Table. N/AN/A
33
Medicaid_Chronic_ConditionsA member month table of Chronic Conditions, managed by Gainwell7/1/201511/1/2020
34
Medicaid_CRG3M Clinical Risk Groupings (CRG) for the Medicaid Population by Calendar YearCalendar Year1/1/201612/31/2018
35
Medicaid_Claim_Load_LagData on the historical lag between Medicaid Claims date of service and Load to Ecosystem.
36
Medicaid_Continuous_Enrollment_Eco_IDA simple Medicaid Continuous Enrollment table
37
Medicaid_Date_ReferenceA simple date reference table with corresponding month, calendar year, and fiscal year. For use in reporting. N/AN/A
38
Medicaid_Inpatient_ReadmissionsMedicaid readmission information. Generated internally based on claims data.Index_Admission_Date7/1/20136/8/2021
39
Medicaid_LTCSS_ClaimsFor EOHHS Medicaid Team - combines LTCSS Claims with Population Grid data, for clean, efficient reporting. N/AN/A
40
Medicaid_Medical_ClaimContains all Medical FFS and MC claims from HSDW tablesFirst_Service_Dt7/1/20137/9/2021
41
Paid_Dt7/10/20137/16/2021
42
Medicaid_Medical_Claim_Diagnosis_CodePivoted (tall not wide) Diagnosis codes for each Medicaid ClaimN/AN/A
43
Medicaid_Pharmacy_ClaimContains all RX FFS and MC claims from HSDW tables
First_Service_Dt_YearMo
7/1/20137/1/2021
44
Morphine Milligram EquivalentsList of Opiods by NDC with the morphine milligrams equivalents. Includes classes such as Muscle Relaxant, Stimulant, Benzo, OpiodN/AN/A
45
Neighborhood_Risk_Index_EcoNeighborhood Risk Index data by Medicaid enrollee, based on Risk Scores provided by Hassenfeld Institute.N/AN/A
46
PCP_AttributionPrimary Care Provider table Last_Date7/1/20137/6/2021
47
Procedure_CodeIncludes ICD9 and ICD10 diagnosis codes with overlaps.N/AN/A
48
Public_Health_Access_Employers_By_QuarterSupports State assessment on large employers with significant # of employees on Medicaid. First_Day_of_Month4/1/20204/1/2020
49
Public_Health_Beneficiaries_Employer_Report_EnrolleesSupports State assessment on large employers with significant # of employees on Medicaid. N/AN/A
50
Early Interventions
Provided by EOHHS directly from the Welligent system
51
Early_Intervention_EncountersEarly Interventions Encounters Details.Service_Dt1/2/20104/9/2021
52
Early_Intervention_EvaluationsEarly Inverventions Evaluations DetailsRBI_Date4/4/19974/9/2021
53
Early_Intervention_EpisodesEarly Interventions Episodes with Eligiblity and Enrollment informationReferral Date
54
Department of Labor and Training (DLT)
55
DLT_ABTDLT Wage and Employer DataWage_Year_QuarterQ1, 2010Q1,2021
56
DLT_Unemployment_LedgerDLT Unemployment Insurance (UI)N/AN/A
57
DLT_Unemployment_PaymentsDLT Unemployment PaymentsCheck_Date8/2/201712/31/2020
58
REAL_Activity_TargetREAL Jobs, REAL Pathways, and REAL Skills Program Targets
59
REAL_ParticipantsREAL Jobs, REAL Pathways, and REAL Skills ParticipantsModified_Date1/1/20167/13/2021
60
REAL_Participant_ActivityREAL Jobs, REAL Pathways, and REAL Skills Activity
Start_Date to End_Date
1/25/20165/24/2021
61
TDI_MasterDLT Temporary Disability Insurance (TDI) and Temporary Caregiver Insurance (TCI) Claim Master RecordN/AN/A
62
TDI_PaymentsDLT Temporary Disability Insurance (TDI) and Temporary Caregiver Insurance (TCI) PaymentsPayment_Date10/2/201712/31/2020
63
Population Grid
Generated by DXC based on enrollment data
64
Popuilation_GridA Medicaid Enrollment Member Month with one record per enrollee, per monthYear_Month_Date7/15/20136/15/2021
65
Aid_Category_CodeReference table that has information about Aid - description, funding etc.N/AN/A
66
KidsNet Data from DOH's Efforts to Outcomes system
67
First_Connections_ReferralsFirst Connection program information based on referralsVisit_Date7/9/19995/3/2021
68
First_Connections_RefusalsFirst Connection program information based on refusalsRefusal_Dt1/29/20017/15/2021
69
First_Connections_VisitsFirst Connection program information based on actual visitsVisit_Date7/9/19997/14/2021
70
Kidsnet_Child_OutreachKidsNet Child Outreach Program DataInitial_Screen_Date9/1/20147/14/2021
71
Kidsnet_Developmental_ScreenKidsNet Developmental Screening DataDev_Screen_Date10/2/20097/14/2021
72
ETO_Family_VisitingEfforts to Outcomes (ETO) Family Visiting DataEnrollment_Date7/30/201212/30/2020
73
Kidsnet_MetatableRollup of Kidsnet Info to the Child LevelFirst_Prenatal_Visit_Dt
74
Rhode Island Coalition to End Homelessness Data
75
RI_Homelessness_EpisodesRhode Island Homelessness episode (service) data Homeless_Entry_Date1/1/200310/6/2020
76
RI_Homelessness_Interview_AnswersAnswers to Interview questions of Rhode Islanders seeking homelessness services.N/AN/A
77
HMIS_ClientHMIS ClientN/AN/A
78
HMIS_EnrollmentHMIS EnrollmentEntry_Date1/1/20115/2/2021
79
HMIS_IncomeBenefitsHMIS IncomeBenefitsInformation_Date1/1/201112/8/2021
80
HMIS_IncomeBenefits_SummaryHMIS IncomeBenefits_SummaryN/AN/A
81
Vital Records from DOH's Rivers system.
82
RIVERS_BirthsBirth dataChild_Date_Birth1/1/19607/31/2021
83
RIVERS_DeathsDeath dataDate_Of_Death1/1/20107/31/2021
84
Rivers_XwalkLinkage of mother and father to child based on Births data1/1/19607/31/2021
85
Race and Ethnicity Data
86
Eco_Demographics_FullA combined set of person-level demographics from a variety of Eco system data sources.Depends on data source.N/AN/A
87
RIQI_Race and Ethnicity Data, provided by the Rhode Island Quality Institute (RIQI). This table is keyed on ECO_ID and is for general use. N/AN/A
88
RIQI_Race_Ethnicity_RE_UIDRace and Ethnicity Data, provided by the Rhode Island Quality Institute (RIQI). This table is keyed onRE_UID and is only for use by the EOHHS Medicaid Team.N/AN/A
89
Reference Tables
90
Age_CategoriesCategories for age
91
APCD_Hospital_Care_CategoryCategories of Hospital Care, taken from the APCD database for use with Medicaid Claims
92
APCD_Provider_MasterProvider data, taken from the APCD database for use with Medicaid Claims
93
NPI_Alt_AddressNational Provider Identifier (NPI) Alternate Address Table
94
NPI_NationalNational Provider Identifier (NPI) database
95
RedbookComprehensive Drug information from IBM Micomedex Red book, using the NDC codes.
96
ZipZip Code Related data such as Town, Long and Lat.
97
Neighborhood_Risk_IndexReference Table with Neighborhood Risk Index data, by GeoID, provided by Hassenfeld Institute.
98
99
100