Exhibit XIV Provider Census Report 2024.xlsm

XLSM spreadsheet 89 KB Posted

Attached to
Master Agreement AZ|CTR071439
Contract number
CTR071439
Issued by
Arizona

About this file

This document is an Exhibit XIV Provider Census Report for the Arizona Department of Child Safety (ADCS), specifically a congregate care census reporting template. The document is designed for tracking child placements in congregate care facilities, involving multiple providers, facilities, and placement sources including Arizona Department of Child Safety (ADCS), Arizona Juvenile Court (ADJC), and Tribal placements across various Arizona counties.

The report captures detailed information about child placements, including facility locations, licensed and contracted bed capacities, daily placement contacts, after-hours placement contacts, and comprehensive child placement data. Key tracking elements include child demographics, placement dates, exit dates, bed availability, facility specialties, contact information, and placement source details. The report requires daily submission by 5pm to OpenBeds@azdcs.gov, with providers required to update information about child placements, facility vacancies, and placement sources across different facility types and locations within Arizona's child welfare system.

View the file

Other files

File Type Posted
2-Attachment_3-D_-_Boycott_of_Israel_Disclosure_Redacted.pdf PDF
Congregate_Care_Services_Amendment.pdf PDF
Congregate_Care_Services_SOW_Amendment_2.pdf PDF
Exhibit CS0-1015A.pdf PDF
Exhibit II - Personalized Service Plan.pdf PDF
Exhibit III - Medication Log.pdf PDF
Exhibit IV - Medication Error Report.pdf PDF
Exhibit XII Bed Hold.pdf PDF
Congregate_Care_Services_SOW_2024_with_Terms_and_Conditions.pdf PDF
Contract_Amendment_4.pdf PDF
Directions_to_Procurement_File.docx DOCX document
Exhibit I - DCS 06-01 Limited English Proficiency.pdf PDF
Exhibit VI Fees Log.pdf PDF
Exhibit VII Clothing Allowance Ledger.pdf PDF
Exhibit X Returned Allowances Form.xlsx XLSX spreadsheet
Exhibit XV Discharge Summary.pdf PDF
Exhibit XVI Facility Modification Request.pdf PDF
Exhibit XXII ADJC Residential Services Invoice.docx DOCX document
License.Meraki.Amendment_9-12-2025_Redacted.pdf PDF
Op.Cert.Meraki.Marron.Amend.Eff_12-17-2024_Redacted.pdf PDF
Operating_Cert.Meraki.Amendment_09-12-2025_Redacted.pdf PDF
2-Attachment_3-E_-_Forced_Labor_of_Ethnic_Uyghurs_Ban_Redacted.pdf PDF
Congregate_Care_Services_Amendment_5.pdf PDF
Contract_Amendment_1.pdf PDF
Contract_Amendment_6.pdf PDF
Exhibit XI One on One Supervision.pdf PDF
Exhibit XIX ADJC Census Report.doc DOC document
Exhibit XVIII ADJC Monthly Attendance Report.doc DOC document
Operating_Certificate_Meraki_-Marron_Amendment_Effective_09-11-2025_Redacted.pdf PDF
24-24_COI-_Meraki_Youth_Homes__LLC_Redacted.pdf PDF
25-26_COI_-_State_of_Arizona_Redacted.pdf PDF
Congregate_Care_Services_SOW_Amendment_1.pdf PDF
Congregate_Care_Services_SOW_Amendment_3.pdf PDF
Contract_Amendment_2.pdf PDF
Contract_Amendment_7.pdf PDF
Exhibit IX Clothing and Property Inventory.pdf PDF
Exhibit V - Blood Sugar Log.pdf PDF
Exhibit VIII Personal Allowance Ledger.pdf PDF
Exhibit XVII Quarterly Report.xlsm XLSM spreadsheet
Exhibit XX ADJC-5002 ADJC Service Providers Protocol ADJC.doc DOC document
HITECH.pdf PDF
License_Meraki_-Marron_Amendment_Effective_09-11-2025_Redacted.pdf PDF
Offer_and_Acceptance_Redacted.pdf PDF
Show all 43

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Agency Face Sheet

Arizona Department of Child Safety
Congregate Face SheetV5
Provider
Provider NameLicense Information
Quick Connect #Contracted Population
Admin. Office AddressContracted Age Range
Daily Placement (7 days a week 8am-5pm)
Name (Main Contact)Name (Backup Contact)
Email Address (Main Contact)Email Address (Backup Contact)
Phone # (Main Contact)Phone Number (Backup Contact)
After Hour Placement (7 days a week 5pm-8am)
Name (Main Contact)Name (Backup Contact)
After Hours Placement Phone #After Hours Placement Phone # (Backup)
Facility Locations
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
Cohort and SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
DCS Contracted Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number
Facility NameFacility Name
Cottage/ Casita (If Applicable)Cottage/ Casita (If Applicable)
SpecialitySpeciality
Licensed BedsLicensed Beds
DCS Contracted BedsDCS Contracted Beds
Vacant BedsVacant Beds
Facility E-Mail Address (If applicable)Facility E-Mail Address (If applicable)
Facility Phone NumberFacility Phone Number

DCS Census Report

Due:Daily No later than 5pm.
Send to: OpenBeds@azdcs.govArizona Department of Child Safety

Congregate Care Census Report

**This roster shall contain only ADCS Congregate Care, ADJC and Tribal Placements**Current Date:
Length of Stay (Days)Child's AgeChild's Full Name
(Last, First)Placement Date
xx/xx/xxxxExit Date xx/xx/xxxxBed Hold End DateDestination Detail
(drop down)Child's GenderDOB
xx/xx/xxxxPerson ID #Case ID# or Assessment ID#Facility NameCottage/CasitaPlacement SourceSchool NameCounty for Dually AdjudicatedProbationProbation Officer Contact InformationComments
child agechild nameplacement dateexit datedetailschildrenchilddobfacilitysource
00AWOL
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00
00

DCS Exit Dates

Child's AgeChild's Full Name
(Last, First)Exit Date xx/xx/xxxxBed Hold End DateDestination Detail
(drop down)Child's GenderDOB
xx/xx/xxxxPerson ID #Facility NameCottage/Casita
child agechild nameexit datedetailschildrenchilddobfacility

Instructions

This User Guide is intended to provide helpful tips for completing the Agency Face Sheet, Census Report, and Subcontractor tabs.
ADCS Congregate Care Census Reports are due daily by 5pm.
Congregate Care Agency Face Sheet
Provider - This section is to obtain the Contractors information that they are both Licensed and Contracted for
Enter Provider name as it appears on your ADCS OLR License
Enter Quick Connect ID # as it appears on your Congregate Care Quick Connect profile
Enter the Administrative Office Address that matches your ADCS OLR License and AZ W9 on file
Enter the License Information- enter your ADCS Contracted population
Enter the Population which is your ADCS Contracted Gender(s)
Enter your Age Range that your are ADCS Contracted for
Daily Placement- this section is to enter the contact information from the Contractor for ADCS Placement Administration 7 days a week 8am-5pm for placement of children
Enter the Name of the person who will be point of contact
Enter the Email Address for receiving placement referrals and communication
Enter the Phone Number for receiving calls from ADCS Placement Administration
Enter the Name of the Back up Person who may support the main person
Enter the Back up Email of who may support the main email
Enter the Back up Phone number for receiving calls from ADCS Placement Administration
Facility Locations- this section is for the Provider to enter the ADCS Non QRTP Congregate Care Facilities only where children may be placed
Enter the Facility name as it appears on your ADCS OLR Operating Certificate or License
Enter the Cottage /Casita Name that accepts ADCS Non QRTP placements, Tribal or ADJC children
Enter the Cohort and Speciality for this Facility and or Cottage/Casita
Enter the Number of Licensed Beds for this Facility and or Cottage/Casita
Enter the Number of Contracted Beds for this Facility and or Cottage/Casita
Enter the Number of Vacant Beds for this facility and or Cottage/Casita, this should not include any current Bed Holds
Enter the Facility Email address if there is one
Enter the Facility Phone Number this should be a direct line for this location
Congregate Care Census Report
Census Report- this Tab is to updated and submitted daily for an accurate count of current ADCS, ADJC and Tribal placements and vacant beds available to the Department. This does not include QRTP, ORR, Private or AOC placements.
Length of Stay in Days will autopopulate when the placement date is entered
Child's Age will autopopulate when the Child's Date of Birth (DOB) is entered
Child Full Name shall be entered Last Name, First Name upon placement
Placement Date shall be the date the child was physically placed in the facility and correlate with the date on the child's Notice to Provider
Exit Date shall be the date the child left the facility permanently, this does not include a bed hold
Bed Hold End Date shall be the date child returned or exited the facility. Bed may then reflect as vacant
Destination Details shall be where the child went after they exited the facility
Child's Gender shall be what the child is assigned at birth and correlate with the gender on the Notice to Provider
DOB shall be the child's date of birth and entered accurately
Guardian Person ID Number shall be entered and match the Notice to Provider information
Facility Name shall be where the child was placed and should correlate with the Placement Referral and Notice to Provider
Cottage/Casita shall be entered only if an ADCS assigned and applicable to the Contractor
Placement Source shall be entered as ADCS, Tribal or ADJC
School Name shall be the child school of orgin when placed and updated if an approved move with a BID is held.
County for Dually Adjucated shall be the county the youth is assigned
Probation shall be entered if the child is currently on Probation
Probation Officer Contact Information shall include Name and Phone Number
Comments shall be for any information that needs to be entered but is unable to be

Drop Down

Drop Down Menu
Destination DetailsChild SexMeaningful ContactCFT ParticipationNormalcy ActivitiesMonths
Aged OutFYesYesYesAugust 1st to 31st (due 2nd Thursday in Sept.)
AWOLMNoNoNoSeptember 1st to 30th (due 2nd Thursday in Oct.)
DetentionNo contact permittedOther (does not apply) - see commentsChild exited agencyOctober 1st to 31st (due 2nd Thursday in Nov.)
DisruptionPlacement SourceChild exited agencyExtracurricular ActivitesCohort LimitationsNovember 1st to 30th (due 2nd Thursday in Dec.)
Foster HomeDCSNot placed these datesStudent GovernmentOther (does not apply) - see commentsDecember 1st to 31st (due 2nd Thursday in Jan.)
Group HomeADJCOther (does not apply) - see commentsMusic/ Art/ Culture ClubJanuary 1st to 31st (due 2nd Thursday in Feb.)
Higher Level CareAOCVolunteer WorkFebruary 1st to 29th(due 2nd Thursday in March)
HospitalORRAthletics / SportsMarch 1st to 31st (due 2nd Thursday in April)
Independent LivingTribalCohort LimitationsApril 1st to 30th (due 2nd Thursday in May)
KinshipPrivateInternshipMay 1st to 31st (due 2nd Thursday in June)
ReunificationAfter School ProgramJune 1st to 30th (due 2nd Thursday in July)
Other - see commentsSummer CampJuly 1st to 31st (due 2nd Thursday in August)
Child is under 7yrs old
Other activity - see comments
School statusIs staff information updated in quick connectOther (does not apply) - see comments
Changed Schools (with DCS specialist approval)Yes
Changed Schools ( W/O DCS approval)No - See comments
Remained in School of Origin
Not School Aged
Other - see commentsCounty for Dually AdjudicatedDually AdjudicatedDestination Details SUB CONTRACTEDPlacement Source
ApacheYesAged OutDCS
CochiseNoAWOLADJC
QRTPCoconinoDetentionTribal
YesGilaDisruption
GrahamFoster Home
GreenleeGroup Home
La PazHigher Level Care
MaricopaHospital
MohaveIndependent Living
NavajoKinship
PimaOther - see comments
PinalQRTP
Santa CruzReunification
Yavapai
Yuma

Totals

CFT
YesERROR:#REF!
NoERROR:#REF!
BlankERROR:#REF!ONLY for monthly reports
percentageERROR:#REF!
Extracurricular Activites
Student GovernmentERROR:#REF!
Music/ Art/ Culture ClubERROR:#REF!
Volunteer WorkERROR:#REF!
Athletics / SportsERROR:#REF!
Cohort LimitationsERROR:#REF!
InternshipERROR:#REF!
After School ProgramERROR:#REF!
Summer CampERROR:#REF!
Child is under 7yrs oldERROR:#REF!
Other actvity - see commentsERROR:#REF!
Other (does not apply) - see commentsERROR:#REF!
BlankERROR:#REF!
Percentage of participationERROR:#REF!
Meaninful
YesERROR:#REF!
NoERROR:#REF!
No contact permittedERROR:#REF!
Child exited agencyERROR:#REF!
Not placed these datesERROR:#REF!
Other (does not apply) - see commentsERROR:#REF!
BlankERROR:#REF!
TotalsERROR:#REF!
Normalcy
YesERROR:#REF!
NoERROR:#REF!
Child exited agencyERROR:#REF!
Cohort LimitationsERROR:#REF!
BlankERROR:#REF!
Other (does not apply) - see commentsERROR:#REF!
TotalERROR:#REF!
School of orgin
BlanksERROR:#REF!
changed schools (DCS Approval)ERROR:#REF!
changed schools (W/O Approval)ERROR:#REF!
Reamined in school of orginERROR:#REF!
Not school agedERROR:#REF!
total children in placementERROR:#REF!
% of children remaining in school of originERROR:#REF!

File details come from the government source that posted it. Updated .