April 2018 Technical Documentation for Licensure and Workforce Survey Data 4
Specialists (CNS), and Licensed Practical Nurses (LPN). Each record contains information on
license type (RN, ARNP, CNS, or LPN), license status (e.g., active, suspended), date of birth,
gender, race/ethnicity, year of initial licensure in Florida, application type (i.e. examination
or endorsement), and mailing and/or practicing addresses.
An extract of Workforce Survey data is provided to the Center as a separate file along with
the monthly licensure data extract. The questionnaire used is presented in Appendix A.
Because nurses renew biennially, it takes two years of renewals to amass a complete cohort’s
survey data from all renewing nurses choosing to take the survey. Renewal cycles are based
on the licensee’s expiration date of either April 30
th
or July 31
st
.
In even years (e.g. 2016),
approximately two-thirds of RNs and ARNPs are expected to renew between January and
July. In odd years (e.g. 2017), the remaining one-third of RNs and ARNPs renew from January
through April and all LPNs renew from March through July.
Data used for the current analyses intend to represent all renewals and new licenses
between January 1, 2016 and December 31, 2017. Data extracts are received by the Center
on the 21
st
of every month. For analyses of the 2016-2017 cohort, the Center compared and
combined December 2017 and January 2018 extracts to best represent the population of
licensees as of December 31
st
.
This cutoff represents the transition to the next biennial
renewal cohort, beginning on January 1 of the next even year (e.g. 2018).
The licensure data extract was merged with Workforce Survey data collected during 2016
and 2017 using an MQA generated file number as the unique identifier to join records.
Though surveys are completed throughout the two-year period, we treat survey data as
representing the best possible estimate of a nurse’s work status at the end of the renewal
cycle. Each record in the potential nurse workforce is assigned an estimated work status
(using their practicing address provided through the MQA renewal process when survey
responses are not available). A full-time equivalent (FTE) value is estimated for all survey
respondents and weighted to more closely represent the total population, including non-
respondents. Thus, the merged dataset contains the best possible estimate of the workforce
as of January 2018.
With the exception of Temporary Military Active licenses which expire exactly one year from the date received.
Nurses practicing in the state of Florida with non-expired temporary military licenses are included in this sample.
The December 21
st
data extract is the primary source of data. To avoid excluding any renewal records and survey
responses between December 21
st
and December 31
st
, data from the January extract are incorporated when a) no record
is found for that nurse in the December file or b) the nurse’s license or active status changed between December and
January. In both situations, only nurses whose records indicate a license expiration date consistent with the current
cohort of interest are included. For instance, 2016-2017 renewals should have an expiration date of 2018 or 2019. Any
nurses whose expiration date was after July 31, 2019 as of the January data extract was excluded from the sample and
will be analyzed with the next cohort. This approach provides the added benefit of capturing renewals and new licenses
through the end of the calendar year of the renewal cohort, allowing for inclusion of new licensees graduating in
December, and allows nurses who missed their renewal deadlines an additional five to seven months to complete
renewal for inclusion in the sample. This approach is new as of the 2018 reporting cycle and may affect response rates.