OCFS Data WarehouseIBM Cognos 8:Predefined Report List

laurelsandwichΛογισμικό & κατασκευή λογ/κού

25 Νοε 2013 (πριν από 3 χρόνια και 11 μήνες)

98 εμφανίσεις

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

1

Predefined Reports

Last updated: 3/4/2011

Child Welfare Services Reports

Contains reports about children receiving services

W

Foster Care Roster

Provides a detailed list of children in the care and custody
of the county Departments of Social Service (DSS).

The
data in this report is from CCRS.

D

Tracked Child Roster

Provides a detailed list of tracked children in open Family
Services Stages in CONNECTIONS. There are VA and
LDSS versions of this report.

D

Tracked Child Roster
with Workers

Provides a detailed list of tracked children in open Famil
y
Services Stages in CONNECTIONS and the workers with a
current role in their stage. There are VA and LDSS
versions of this report.

W

Admissions to Foster
Care Summary

Provides summary information for foster care admissions
for a District/Agency during a
specific time period.

This
report contains a link to a detailed report with Case and
demographic information for each child.

W

Children with Admissions
During the Period


with
District Prompt

Provides Local Districts with a list of children admitted to
f
oster care during a specified period. This is a detailed
report to correspond with the Admissions to Foster Care
Summary Report.

W

Discharges from Foster
Care Summary

Provides summary information for children discharged
from foster care for a District/Age
ncy during a specific
time period.

This report contains a link to a detailed
report with Case and demographic information for each
discharged child.

W

Children with Discharges
During the Period


with
District Prompt

Provides Local Districts with a list o
f children discharged
from foster care during a specified period. This is a
detailed report to correspond with the Discharges from
Foster Care Summary Report.

W

In Care Summary Report

Provides summary information for children in
-
care and
absent for a Dist
rict/Agency during a specific month.

This
report contains a link to a detailed report with Case and
demographic information for each child.

W

In Care Detail Report

Provides detailed placement and family information for a
specific foster child currently in

care. A CIN is required at
the report prompt.

W

Legal Detail Report

Provides detailed legal history information for a specific
foster child currently in care. A CIN is required at the
report prompt.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

2

Predefined Reports

Last updated: 3/4/2011

Child Welfare Services Reports

Contains reports about children receiving services

W

CCRS Legal JD/PINS
Indicator Report

Provides
detaile
d JD/PINS information for c
hildren in

care
on the last day of a selected month,
as determined by
CCRS
l
egal
c
odes
.

W

ASFA Trends

Displays the number of children in care for at least 12 of
the last 22 months for each District. The count is a
snapshot of th
e ASFA population on August 31
st

of each
year.

W

ASFA Child Specific List

Lists the children, currently in care, who have been in
care for at least 12 of the last 22 months.

W

Children Placed Out of
State with Prompt

Provides a list of children in care
placed in facilities
located outside of New York State by District.

W

Children Placed Out of
State Congregate Care

Provides a list of children in care placed in congregate
care facilities located outside of New York State by
District.

W

Children In Care
by
District, Agency Where
Placed and LOC

Provides a count of children in placement (active and
absent) by the physical location of the facility in which
they were in care on the last day of the month entered in
the Date Prompt.

W

Foster Children Grouped
b
y In Care & IV
-
E Status

Provides the overall number of foster children currently in
one of the following categories: (1) in care & IV
-
E, (2) in
care & not IV
-
E, (3) absent & IV
-
E, and (4) absent & not
IV
-
E.

This report contains a link to a detailed report
with
placement and demographic information for each child.

W

Children in Care by
Agency
by

Facility Type

Provides the number of children in foster care for each
agency and facility type for a District during a specified
month.

This report contains a link
to a detailed report
with Case and demographic information for each child.

Q

Children and Youth in
Foster Care by Month

Provides summary information for children and youth in
foster care for all districts by region for the latest 12
months. This is run as

a PDF file and posted to the Child
Welfare Services Reports folder quarterly.

CCRS Cube Reports

Contains reports about children receiving services that allow users to make district and
agency comparisons at the summary level

W

In Care Summary Report
by
Year by District

Provides summary information for children in foster care
during the last five years for all Districts.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

3

Predefined Reports

Last updated: 3/4/2011

Child Welfare Services Reports

Contains reports about children receiving services

W

In Care Summary Report
by Year by Agency

Provides summary information for children in foster care
during the last five years for sel
ected Agencies.

W

Admissions Summary
Report by Year by
District

Provides summary information for foster care admissions
during the last five years for all Districts.

W

Admissions Summary
Report by Year by
Agency

Provides summary information for foster ca
re admissions
during the last five years for selected Agencies.

W

Discharges Summary
Report by Year by
District

Provides summary information for foster care discharges
during the last five years for all Districts.

W

Discharges Summary
Report by Year by
A
gency

Provides summary information for foster care discharges
during the last five years for selected Agencies.


AFCARS Reports

Contains reports based on the federal AFCARS data submission

M

Children Served with
Missing Clinical Diagnosis
Summary

Provide
s the overall number of children served during a
particular AFCARS submission who have a missing clinical
diagnosis in CONNECTIONS. This report contains a link to
a detailed report with Case, Stage, and Health
Responsibility information for each child.

The
re are VA
and LDSS versions of this report.


Child Protective Services

Contains reports about CPS allegations and investigations

W

Overdue Reports

Provides detail on CPS reports that are currently overdue
and/or overdue as of the date entered at the prom
pt.

W

ACS Reports Overdue

Provides detail on ACS CPS reports that are overdue as of
the date entered at the prompt.

W

ACS Reports Currently
Overdue

Provides detail on CPS reports that are currently overdue.

W

Report Determinations
by Allegation Type

Pro
vides the number of CPS reports Statewide with the
determinations for a specific allegation type and year.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

4

Predefined Reports

Last updated: 3/4/2011

Child Protective Services

Contains reports about CPS allegations and investigations

W

Report Determinations
by District, Allegation &
Year

Provides the number of CPS reports and determinations
for a specific allegation type and year

by District.

W

CPS Reports
Year to Year
Weekly Comparison

Provides a comparison of CPS Investigations assigned to
Districts during the same calendar week
in any two
consecutive years
.

W

Workers with More than
20 Open CPS Reports

Provides detail on worke
rs that currently have 21 or more
open CPS reports.

W

Workers with 25 or More
Open CPS Reports

Provides detail on workers that currently have at least 25
open CPS reports.

M

Consolidated
Investigations Summary
Report

Provides the total number of duplicat
e investigations that
were closed and consolidated into open, on
-
going CPS
investigations for each District. This report contains a link
to a detailed report with the consolidation information for
each investigation.

W

Current Secondary
Assignments Receiv
ed
Summary

Provides a summary of secondary assignments received,
grouped by the District that made the secondary
assignment.

W

Secondary Assignments
Received During a
Quarter

Provides a listing of secondary assignments received by
an LDSS, grouped by the
unit and worker to whom the
secondary assignment was made.

M

First Contacts

Allows CPS staff to identify how quickly first contacts are
being made by staff within significant categories of
contact persons during a particular month and year.

M

Total Conta
cts

Allows CPS staff to identify the total number of contacts
being made by staff within significant categories of
contact persons during a particular month and year.

M

Manager Reviews

Allows CPS supervisors/managers to identify the degree
of compliance w
ith NYC regulations concerning supervisor
and manager reviews.

M

Safety Assessments
Overdue

Provides a detailed list of Safety Assessments that were
approved more than 7 days after the Intake Start Date for
a particular month and year.

M

Safety Assessmen
t
Trends

Provides the number and percent of Safety Assessments
that were approved on time and those that were
approved late for each month and year.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

5

Predefined Reports

Last updated: 3/4/2011

Child Protective Services

Contains reports about CPS allegations and investigations

M

Risk Assessment Profile

Shows the relationship between Risk Assessment ratings,
report determinations, a
nd the decision to open CPS
cases for protective and/or preventive services.


CPS Cube Reports

Contains reports about CPS allegations and investigations that allow users to make district
and agency comparisons at the summary level

W

CPS Report
Determinat
ions During
the Period

Provides
summary
information on CPS report
determinations for a specific year.

W

CPS Reports Processed
During the Period

Provides
summary
information on the status of CPS
intakes and investigations processed for a specific year.

W

CPS Stages and Reports
Current Status

Provides
summary
information on the status of CPS
workloads for the current month.

W

CPS Reports Processed
and Determined
-

5
Years

Provides summary information on CPS report
determinations and the status of intakes a
nd
investigations for the past five years.


W

Allegations by Type

Provides
summary
information on substantiated,
unsubstantiated, Family Assessment Response, and
undetermined CPS allegations for a specific year.

W

Allegations by Type with
Nested Row

Prov
ides a version of the Allegations by Type report with

the ability to add another (i.e., nested) row of data.

FAR Reports

Contains reports about Family Assessment Response cases

W

FAR: Total and
Percentage of Familial
Reports Assigned to FAR
Track

Provide
s FAR counties with the number and percentage of
FAR reports as a subset of all familial reports for each
month in a specified time period.
This report contains a
link to the
FAR: Cases Summary Report by Worker report.

W

FAR: Cases Summary
Report by Worke
r

Provides FAR counties with the number and percentage of
FAR reports as a subset of all familial reports for a
specified time period with a breakdown by Unit and
Worker. This report contains a link to
a detailed report
with Case ID, Report ID, and start/e
nd date information
for each FAR case.

W

FAR: Allegations in FAR
Reports

Provides FAR counties with a breakdown of FAR
allegations for the specified time period.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

6

Predefined Reports

Last updated: 3/4/2011

Child Protective Services

Contains reports about CPS allegations and investigations

W

FAR: Total and
Percentage of Reporters
of Familial and FAR
Reports

Provides FAR counties w
ith a breakdown of FAR reporter
types for the specified time period.

W

FAR: Children in Familial
& FAR Reports,
Demographics

Provides FAR counties with a breakdown of demographics
for children in Familial and FAR reports for a specified
time period.

SCR

Highlights

Contains reports about Family Assessment Response cases


CPS Reports by
Reporting Source &
Region

Provides th
e number of CPS reports received during the
selected year from each mandated and non
-
mandated
reporting source.


Age & Gender of Abuse
d
or Maltreated Children

Provides the number of Indicated CPS reports opened
during the selected year with a breakdown by gender and
age range.


Race and Ethnicity of
Children



CPS Reports by
Perpetrator Age &
Gender



Reports of Suspected
Child Abuse
and
Maltreatment



FASP Reports

Contains reports about Family Assessment and Service Plans

M

FASP Status Summary

Provides the number and percentage of Initial,
Comprehensive, and Reassessment FASPs and their
respective statuses for a specific month.

Th
is reports if for
Districts only.

D

FASPs Due

Provides the number and percentage of Initial,
Comprehensive, and Reassessment FASPs that are
overdue or coming due within 60 days of the current date
across several “day ranges.” This report is for Districts

only.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

7

Predefined Reports

Last updated: 3/4/2011

FASP Reports

Contains reports about Family Assessment and Service Plans

D

FASPs Due Detail
organized by Worker

Provides a detailed list of FASPs that are currently
overdue or coming due within
9
0 days of the current
date. This report is organized by worker name.

There are
VA and LDSS versions of this report.

D

FASPs D
ue Detail
organized by Stage ID

Provides a detailed list of FASPs that are currently
overdue or coming due within
9
0 days of the current
date. This report is organized by Case ID and Stage ID.

There are VA and LDSS versions of this report.

D

Overdue FASP
Activities

Provides the number of submissions, rejections, and
approvals for FASPs overdue on a specified date. Also
includes the length of time the FASPs have been in the
submittal
-
approval process.

This

report contains a link to
a detailed list of submis
sion, rejection, and approval
activities for a selected FASP.

There are VA and LDSS
versions of this report.

D

Due FASP Activities

Provides the number of submissions, rejections, and
approvals for FASPs due during a specified date range.
Also includes the

length of time the FASPs have been in
the submittal
-
approval process.

This
report contains a link
to a detailed list of submission, rejection, and approval
activities for a selected FASP.

There are VA and LDSS
versions of this report.

D

Approved FASP Act
ivities

Provides the number of submissions, rejections, and
approvals for FASPs approved during a specified date
range. Also includes the length of time the FASPs have
been in the submittal
-
approval process.

This
report
contains a link to a detailed list o
f submission, rejection,
and approval activities for a selected FASP.

There are VA
and LDSS versions of this report.

D

Current Pending FASP
Activities

Provides the number of submissions, rejections, and
approvals for FASPs currently pending final approval
. Also
includes the length of time the FASPs have been in the
submittal
-
approval process.

This
report contains a link to
a detailed list of submission, rejection, and approval
activities for a selected FASP.

There are VA and LDSS
versions of this report.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

8

Predefined Reports

Last updated: 3/4/2011

FASP Reports

Contains reports about Family Assessment and Service Plans

D

Current Pending FASPs
-

Agency Pending With

Provides a list of FASPs in “Pending” status, including
FASP Submitter information and the name of the agency
with which the FASP is awaiting action.

There are VA and
LDSS versions of this report.

D

FASPs Due
Calendar

Provides a chronological li
st of FASPs in “Not Launched
,


“In Process
,
” and “Pending” statuses that are due during
a specified date range.

There are VA and LDSS versions of
this report.


SPR Reports

Contains reports about Service Plan Reviews

D

SPRs Outstanding Detail

Provides a detailed list of SPRs recorded in CONNECTIONS
that

have not been held.

D

SPR Summary Report


Scheduled

Provides
the number

of SPRs scheduled

in

CONNECTIONS
for

the date range selected.

This reports if for Districts
only
.

D

SPR Summary Report
-

Completed

Provides
the number

of SPRs
that have a “date

held”

entered
in
CONNECTIONS
for the

date range

selected
.

This reports if for Districts only.


Casework Contacts Reports

Contains reports about contacts between child welfar
e staff and tracked children/biological
parents

2
M

Tracked Child Contacts
by Worker

Provides a detailed list of tracked children and their
“Casework Contact” or “Attempted Casework Contact”
Progress Notes during a specified month. The report is
organized
by worker name.

There are VA and LDSS
versions of this report.

2
M

Tracked Child Contacts
by Case

Provides a detailed list of tracked children and their
“Casework Contact” or “Attempted Casework Contact”
Progress Notes during a specified month. The report
is
organized by Case ID.

There are VA and LDSS versions of
this report.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

9

Predefined Reports

Last updated: 3/4/2011

Casework Contacts Reports

Contains reports about contacts between child welfar
e staff and tracked children/biological
parents

2
M

Tracked Child Contacts
by Child Name

Provides a detailed list of tracked children and their
“Casework Contact” or “Attempted Casework Contact”
Progress Notes during a specified mon
th. The report is
organized by child name.

There are VA and LDSS versions
of this report.

2
M

Case Manager: Tracked
Child Contacts by Case

Similar to “Tracked Child Contacts by Case”, but includes
contacts by the Case Manager and all staff working with
the

Case Manger, regardless of agency. This report is for
districts only.

2
M

Case Manager: Tracked
Child Contacts by Child
Name

Similar to “Tracked Child Contacts by Child Name”, but
includes contacts by the Case Manager and all staff
working with the Case M
anger, regardless of agency. This
report is for districts only.

2
M

Case Manager: Tracked
Child Contacts Summary

Provides an overview of tracked children with and without
contacts from
any

district or agency staff member. There
are two sections of this rep
ort


one focusing on the
number of tracked children contacted and the other
focusing on the number of contacts attempted or made.
This report is for districts only
; t
he voluntary agency
version is called “Tracked Child Contacts Summary.”

2
M

Tracked Child

Contacts
Summary

Provides an overview of tracked children with and without
contacts from their agency staff. There are two sections of
this report


one focusing on the number of tracked
children contacted and the other focusing on the number
of contacts
attempted or made
.

This report is for
voluntary agencies only
; t
he district version is called
“Case Manager: Tracked Child Contacts Summary.”

2
M

Biological
Parent

Contacts by Worker

Provides a detailed list of the biological parents of tracked
children an
d their “Casework Contact” or “Attempted
Casework Contact” Progress Notes during a specified
month. The report is organized by worker name.

There
are VA and LDSS versions of this report.

2
M

Biological
Parent
Contacts by Case

Provides a detailed list of th
e biological parents of tracked
children and their “Casework Contact” or “Attempted
Casework Contact” Progress Notes during a specified
month. The report is organized by Case ID.

There are VA
and LDSS versions of this report.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

10

Predefined Reports

Last updated: 3/4/2011

Casework Contacts Reports

Contains reports about contacts between child welfar
e staff and tracked children/biological
parents

2
M

Biological
Parent
Contacts

by Parent Name

Provides a detailed list of the biological parents of tracked
children and their “Casework Contact” or “Attempted
Casework Contact” Progress Notes during a specified
month. The report is organized by parent name.

There
are VA and LDSS versi
ons of this report.

2
M

Case Manager: Biological
Parent Contacts by Case

Similar to “Biological Parent Contacts by Case”, but
includes contacts by the Case Manager and all staff
working with the Case Manger, regardless of agency. This
report is for distric
ts only.

2
M

Case Manager: Biological
Parent Contacts by
Parent Name

Similar to “Biological Parent Contacts by Parent”, but
includes contacts by the Case Manager and all staff
working with the Case Manger, regardless of agency. This
report is for districts

only.

2
M

Case Manager: Biological
Parent Contacts
Summary

Provides an overview of biological parents of tracked
children with and without contacts from
any

district or
agency staff member. There are two sections of this
report


one focusing on the numbe
r of biological parents
contacted and the other focusing on the number of
contacts attempted or made.
This report is for districts
only
; t
he voluntary agency version is called “Biological
Parent Contacts Summary.”

2
M

Biological Parent
Contacts Summary

Pro
vides an overview of biological parents of tracked
children with and without contacts from their agency
staff. There are two sections of this report


one focusing
on the number of biological parents contacted and the
other focusing on the number of contac
ts attempted or
made.

This report is for voluntary agencies only
; t
he
district version is called “Case Manager: Biological Parent
Contacts Summary.”

2
M

Foster Care Children


No Successful Contact
Summary

Provides the overall number of children with a
CON
NECTIONS Program Choice of 'C' (Placement) that
have been in
continuous
care
during the

month
selected
with
out a

successful
Progress
Note Casework Contact
entered.
This
report c
ontains a link to a d
etail report with
worker information for each child
.

There

are VA and LDSS
versions of this report.


OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

11

Predefined Reports

Last updated: 3/4/2011

CFSR Program Improvement Plan

Contains reports about the six federal safety and permanency indicators

2Y

Recurrence by District

Displays the success rate of the Recurrence of
Maltreatment indicator for each Dist
rict. If a September
date is selected at the prompt, the report is based on
data for Oct 1
-
Sept 30; if a March date is selected at the
prompt, the report is based on data for April 1

March 31.

This report contains a link to a detailed report with
recurrenc
e information for each child.

2Y

Maltreatment in Foster
Care

Displays the success rate of the Incidence of Abuse &
Neglect in Foster Care indicator for each District. If a
September date is selected at the prompt, the report is
based on data for Oct 1
-
Sep
t 30; if a March date is
selected at the prompt, the report is based on data for
April 1

March 31.

This report contains a link to a detailed
report with general information for each incident.


Out of Home Settings

Contains reports about facilities and fos
ter homes

W

Currently Active Certified
Foster Homes and
Parents by Location

Counts Certified Foster Homes and Foster Parents by the
county in which the foster home is located.

W

Facility Detail Report

Provides detailed information for each accepted
-
activ
e
and emergency congregate care facility and foster home
for a District/Agency.

W

Facility Summary List
Report

Lists all accepted
-
active and emergency congregate care
facilities and foster homes for a District/Agency.

W

Congregate Care
Summary List Repor
t

Lists accepted
-
active and emergency congregate care
facilities for a District/Agency.

W

Foster Home
Reauthorization Coming
Due

Lists accepted
-
active and emergency foster homes that
require reauthorization during a specific time period.

W

Facility Statu
s Change
with Closure Reason
Code

Provides a detailed list of when the status of a facility
changed.

W

Closed Facility Report

Lists congregate care facilities and foster homes that
closed in the past 3 months for a District/Agency.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

12

Predefined Reports

Last updated: 3/4/2011

Out of Home Settings

Contains reports about facilities and fos
ter homes

W

Out of Home Settings

with Therapeutic
Program Type

Lists facilities that have a therapeutic program. Note: Not
all children in these facilities receive therapeutic services.

W

Foster Parent Training

Lists the most recent training class that foster/adoptive
home members atten
ded and all trainings within 12
months of the most recent one. Only members over age
18 from Accepted
-
Active or Emergency status homes are
included.


Vacancy Control

Contains reports about temporarily unavailable beds and vacant beds in NYC

D

Temporarily

Unavailable
Beds Report 1
-

Borough
Community District
Summary

Displays the temporarily unavailable FBH beds for all
Community Districts within a specific Borough.

D

Temporarily Unavailable
Beds Report 2
-

Agencies
Within Community
District by Borough

Di
splays the temporarily unavailable FBH beds for all
agencies within a specific Community District.

D

Temporarily Unavailable
Beds Report 3
-

Agency
Facility Summary Within
Community District by
Borough

Displays the temporarily unavailable FBH beds for al
l
facilities associated with a specific agency.

D

Temporarily Unavailable
Beds Report 4
-

Agency
Organization Report by
Borough and Community
District

Displays the temporarily unavailable FBH beds for all
Community Districts associated with a specific ag
ency.

D

Temporarily Unavailable
Beds Report 5
-

Facility
Detail Report

Displays detailed temporarily unavailable FBH bed status
for a specific facility.

D

Temporarily Unavailable
Beds Report 6
-

Agency
Facility Within Borough
by Community District

Displ
ays the temporarily unavailable FBH beds that are
located within regular foster boarding homes (aka:
regular FBH)

for a specific Borough and Community
Districts.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

13

Predefined Reports

Last updated: 3/4/2011

Vacancy Control

Contains reports about temporarily unavailable beds and vacant beds in NYC

D

Vacancy Control Report 1
-

Borough Community
District Summary

Displays the vacant FBH beds
for all Community Districts
within a specific Borough.

D

Vacancy Control Report 2
-

Agencies Within
Community District by
Borough

Displays the vacant FBH beds for all agencies within a
specific Community District.

D

Vacancy Control Report 3
-

Agency Faci
lity
Summary Within
Community District by
Borough

Displays the vacant FBH beds for all facilities associated
with a specific agency.

D

Vacancy Control Report 4
-

Agency Organization
Report by Borough and
Community District

Displays the vacant FBH beds fo
r all Community Districts
associated with a specific agency.

D

Vacancy Control Report 5
-

Facility Detail Report

Displays detailed vacant FBH bed status for a specific
facility.

D

Vacancy Control Report 6
-

Agency Facility Within
Borough by Community
D
istrict

Displays vacant FBH beds that are located within regular
foster boarding homes (aka: regular FBH)

for a specific
Borough and Community Districts.


Security

Contains reports for Security Coordinators

W

Assignee Designee
Report

Provides

Security Co
ordinators
with a list of
Assignees
and Designees for each staff member.

W

Business Function Report

Provides
Security Coordinators
with

a list of staff
assigned

a specific business function.

There is also an ungrouped
version of this report
(“Business Fun
ction Report
Ungrouped”)
for easier Excel downloading.

W

Staff Security Report

Provides
Security Coordinators
with a

detailed
list of staff
members, their role, business functions,
assignees/designees, and CONNECTIONS login history.

There is also an ungro
uped version of this report

(“Staff
Security Report Ungrouped”)
for easier Excel
downloading.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

14

Predefined Reports

Last updated: 3/4/2011

Security

Contains reports for Security Coordinators

W

Unit Approver Report

Provides

Security Coordinators
with

a list of Unit
approvers and their In/Out
-
Assigned designation.

W

District Units by Unit
Specializati
on

Provides LDSS Security Coordinators with a detailed list of
sites, units, approvers, approver roles, and workers for
each Unit Specialization
.

W

Organizational Hierarchy

Displays the organizational hierarchy for a specific
agency.


Statewide and Regio
nal Office Reports

Contains reports specifically designed for State staff.

Adoption Specialists

Only

Contains reports for
Adoption Specialists

W

Adoption Now Report

Provides a detailed list of children in care that have been
completely freed for adoptio
n or placed in an adoptive
home for a specified region.

W

Children Adopted
Statewide by Region with
FFY Prompt

Provides overall numbers of
children legally adopted
in
each district f
or
a specified
Federal Fiscal Year
.

W

Children Adopted with
Year and Dis
trict Prompt

Provides a detailed list of children legally adopted for
a
specified year and district
.

W

Children Adopted with
Year and Region Prompt

Provides a detailed list of children legally adopted for
a
specified year an
d region.

W

Children Completel
y
Freed for Adoption
Discharged to Enter
Mental Health Facility

Provides a detailed list of children currently under age 21
that were completely freed for adoption with a
discharge/closing reason of “To Enter Child Mental
Institution” or “To Enter Dept. of

Mental Health Facility”
for
a specified
r
egion
.

C
asework Contact

Reports (for State Staff)

Contains reports about contacts between child welfare staff and
tracked
children

M

CCRS FC Contact
Summary

P
rovides an overview of
the number of
placed
c
hildren
(
per

CCRS
)

with and without
caseworker
contacts

during
a specified month
.

This report contains a
link

to

a
detailed
report with
Case and demographic
information

for each
child, as well as a link to a detailed report for children
with no contacts.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

15

Predefined Reports

Last updated: 3/4/2011

Statewide and Regio
nal Office Reports

Contains reports specifically designed for State staff.

Child Pro
tective Services Reports (for State Staff)

Contains reports about CPS allegations and investigations
; these reports are only available
to State and CQC staff with pre
-
approval from Shelley Murphy, Judith Rodriguez, and the
OCFS Data Warehouse team

W

OCFS
IAB Investigations

Provides overall numbers of CPS reports
with a
breakdown by year and investigation determination
for
OCFS facilities
.

W

OCFS IAB Investigations
with prompt

Provides overall numbers of CPS reports

with a
breakdown by investigation determ
ination

for the year(s)
and OCFS facilities selected at the prompt.

W

VA IAB Investigations
with prompts

Provides overall numbers of CPS reports with a
breakdown by investigation determination for the year(s)
and voluntary agency facilities selected at th
e prompt.

Child Welfare Services Reports (for State Staff)

Contains reports about children placed in foster care

W

Children Currently In
Care 4+ Years

Provides overall numbers of children currently in foster
care with a breakdown by district and time in
care (4 or
more years versus less than 4 years).
This report contains
a link to a detailed report with placement information.

FASP Reports (for State Staff)

Contains reports about Family Assessment and Service Plans

M

FASP Summary History

Provides the nu
mber of Initial, Comprehensive, and
Reassessment FASPs open at the beginning, opened
during, and approved on time for a specific month. This
report can be run for districts only.

M

Open FASPs Overdue by
Agency

Provides the number of FASPs in “Pending” or
“In
Process” status during the month selected that were also
due during the same month and not approved on time
.

This report can be run for districts only.

M

Open FASPs Overdue by
Agency


History

Provides the number of
Initial, Comprehensive, and
Reasses
sment
FASPs in “Pending” or “In Process” status
during the month(s) selected that were also due during
the same month and not approved on time.

This report
can be run for districts only.

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

16

Predefined Reports

Last updated: 3/4/2011

Statewide and Regio
nal Office Reports

Contains reports specifically designed for State staff.

M

Current FASPs Overdue
by Agency


with Banded
Drill
-
Thru

Provides
the number of
Initial, Comprehensive, and
Reassessment
FASPs in “Pending” or “In Process” status
during the current month that are also due during the
month and not approved on time.

This report contains a
link to another report which shows how overdue the

FASPs are. This report can be run for districts only.

D

Currently Overdue FASP
Reports WITH
Submission Activities

Provides a detailed list of submitted FASPs currently in
“Pending” and “In Process” statuses 60 days or more after
the FASP Due Date; includ
es list of submitters and
approvers. This report can be run for districts only.

D

FASPs Due Detail
Organized by Stage ID
Overdue 60+ Days

Provides a detailed list of FASPs that are currently
overdue more than 60 days. This report is organized by
Case ID a
nd Stage ID. A special prompt allows State staff
to run this report for any district or agency.

D

FASPs Due Detail
Organized by Worker
(VA/LDSS prompt)

Provides a detailed list of FASPs that are currently
overdue or coming due within 90 days of the curren
t
date. This report is organized by worker name. A special
prompt allows State staff to run this report for any district
or agency.

D

FASPs Due Calendar
(VA/LDSS prompt)

Provides a chronological list of FASPs in “Not Launched,”

“In Process,” and “Pending”

statuses that are due during
a specified date range. A special prompt allows State staff
to run this report for any district or agency.

D

FASPs Approved More
than 60 Days Late

Provides a detailed list of submitted FASPs that were due
during a specified t
ime period and approved more than 60
days after the FASP Due Date. This report can be run for
districts only.

CWCS Reports

Contains reports about
the tenure of currently placed children

W

CWCS


Permanency
Panels Data


Children in
Care

Provides a detail
ed list of children in the care and custody
of the county Departments of Social Service (DSS)
,
including the admission date and number of years in care
.

Multiple Person Reports

Contains reports about children with duplicate Person IDs in CONNECTIONS

OCFS Data Warehouse

IBM Cognos 8
:

Predefined Report List


The
header row of each section contains the name of the

f
older

in which the reports are located in Cognos.



Note:

The letter next to the report nam
e refers to whether the

data

for the report
is
refreshed daily (D), weekly (W),
bi
-
weekly

(
2W
)
,
monthly (M),
bi
-
monthly (2M),
quarterly (Q),

annually (Y)
, or bi
-
annually (2Y)
.


OCFS Data Warehouse


Page

17

Predefined Reports

Last updated: 3/4/2011

Statewide and Regio
nal Office Reports

Contains reports specifically designed for State staff.

2W

M
PR Statistics LDSS

Provides aggregate data on children in a specific district
with possible duplicate Person IDs in CONNECTIONS
based on an exact match of the primary name, gender,
and date of birth.

2W

MPR Statistics Statewide

Provides aggregate data on

children
across the state

with
possible duplicate Person IDs in CONNECTIONS based on
an exact match of the primary name, gender, and date of
birth.


Division of Juvenile Justice and Opportunities for Youth

Contains reports for searching CCRS case informa
tion for youth entering OCFS custody

These reports are available only to DJJOY users with pre
-
approval from DJJOY and the
OCFS Data Warehouse team

W

DJJOY Initial Inquiry

Displays a list of children in current CCRS cases based on
the search criteria enter
ed at the prompt. This
report
contains a link to a detail report with detailed information
about a child’s placement history and legal activities.

Division of Child Care Services

Contains reports for searching child welfare activities for day care provide
r applicants

These reports are available only to Local District users with pre
-
approval from DCCS and
the OCFS Data Warehouse team

W

Adoption Reportable
Events

Displays a list of cases with adoption activities related to
Mother's Parental Rights Terminate
d, Legal Father's
Rights Terminated, and Child Completely Freed for
Adoption based on the search criteria entered at the
prompt. This
report contains a link to a detail report with
information about the Case members.

W

Court Ordered Article 10
Removals

Di
splays a list of cases with legal activities related to
Removal, Article 10 hearings, and 1055 Court Review
hearings based on the search criteria entered at the
prompt. This
report contains a link to a detail report with
information about the Case members.

W

Termination of Parental
Rights

Displays a list of cases with legal activities related to 384b
Commitment of Guardianship and Custody proceedings
based on the search criteria entered at the prompt. This
report contains a link to a detail report with inf
ormation
about the Case members.