DOC002_CW D043 Reports Inventory.xlsb

Master Report List

Per CW-131, merge key statistics into new version called 'NCANDS Agency Summary Statistics'; see WAI and mtg notes for content. (PS 6/11/20)

No State response in pre-workgroup inventory review and no decision taken in CW-136. (PS 7/15/20) Excel Export: Y Print:

CGI App: Partial Mike J Comment: The legacy system has a very robust query tool that sits in front of the IV-E determination module that providers the upfront GUI to allow the export of a focused and meaningful result set. How refined the query can get will in great part dictate how useful this tool is. There is a lot of flexibility to manipulate IV-E data in Cognos, but to make that trade the warehouse data would need to be changed to a daily refresh of the determination data. This needs further discussion with the state and CGI

Johnson, Michael: Johnson, Michael:

This report has data to produce RPT1147, RPT0601, RPT1146 R0495 All Staff In FACTS Retain 09/22/2022: Legacy report IDs TRN0090, GEN0360, GEN0350, GEN0340 are merged into GEN0330. Joe Simms - Decision made to move from M&O to Cognos.

Changed Owner to M&O per 4/19/21 review by Jani/Satendra/Raghu. (PS 12/3/21) Optum recommends analysis for possible merge of RPT1146/R0386, RPT1147/R0387, RPT0601/TRN0090 and RPT1243/R0495.

MJ 4/7/20: Access and security audit.

Per CW-136: Audit Trail – sample provided 7/14/20, needed also by OIG. Should be accessible to management and supervisors—more analysis required. Action Item: Optum to work with administration team and Mike Stinebaugh on a global audit trail reporting design. (PS 7/16/20) MJ 4/7/20: This will be required by OIG. Changed status to retain per MJ synch.

Excel Export: Y Print:

CGI App: Partial Mike J Comment: This was a frequent request from state OIG investigators that spurred the development of this screen and export functionality. No explicit requirement to provide this but the system can and will be subpoenaed to produce this data if it exists. Needs further discussion with CGI and the state.

State review 'Retain - State would like to understand how this will be addressed'. (PS 11/5/20) Per CW-136: Action Item: Need to review details of how this functionality will be provided across all areas of PATH to meet OMB requirements. Consider related M&O/Admin reports on the inventory and leverage the mature FACTS process in this analysis. (Mike J)Note: This is an OMB requirement for Single Agency Audit. It demonstrates system access and security roles. Per Traci, this is both a list of users with permissions and also a process for supervisors to review this information. Today in FACTS the security/access profile can be printed and signed off.

Per Mike S, each user is associated with their security/access profiles and can be viewed on a screen. Their profile history is also available. PATH does not have a sign-off indicator. (PS 7/16/20) Excel Export: Y Print:

CGI App: Not Exist Mike J Comment: This is not a CGI child welfare specific functionality. Recommend retire and address with whatever tool PATH will incorporate to administer and manage the required annual security and access auditing. Out of CW scope.

Per CW-131: State to clarify Frequency (how often the data must be refreshed) and Report Period (what timeframe is shown on the report, i.e. a month, quarter or year); use current Cognos version to develop. (PS 7/6/20)

Per CW-131: CPS5170 is the newer version of the report in FREDI; CPS0206 is obsolete.

Optum Config Item: Modify frequency to refresh Weekly but keep current content which is a one month period. County = Worker County. Change this Type column to Program Type (CPS, YS). Default sort by Region, County, Supervisor, Worker, Case ID. (PS 7/6/20)

Per CW-131: Optum Config Item: For CPS5180 and CPS5181, add Select Start Month and End Month —timeframe is specific to grand jury schedule). (Note: FFA will need to be mapped to PATH version but column header can stay the same. Avoid any visible changes if possible. Mike Stubbs proposed PATH mappings. These are produced together and manually combined along with a third dataset. Needs to continue being done manually due to precise requirements.) (PS 7/6/20)

Per CW-131: Optum Config Item: For CPS5180 and CPS5181, add Select Start Month and End Month —timeframe is specific to grand jury schedule). (Note: FFA will need to be mapped to PATH version but column header can stay the same. Avoid any visible changes if possible. Mike Stubbs proposed PATH mappings. These are produced together and manually combined along with a third dataset. Needs to continue being done manually due to precise requirements.) (PS 7/6/20)

04/09/2021: Ganesh Rajagopal (Montrose), shared PATH Client Account Log export screen screenshot, which shows that withdrawal reason is now added in the excel export from PATH Client Account Log screen. Refer user story.

03/02/2021: Per meeting with Montrose team (Kevin Bell): OFS0594, will be delivered by Client Account Log screen in PATH. Will not be delivered as COGNOS report. Subledger current balance will not appear in the screen due to missing running balance functionality. Reason for Withdrawal appears in OFS0594 but not in Client Account Log screen. Kevin Bell confirmed that reason for Withdrawal will not appear in Client Account log screen but when a user exports client account log from client account log screen then in the excel export Reason for Withdrawal will appear.

Per State review, OFS0247 should be retained and not merged with OFS0594 and OFS251. Merge of OFS0594 and OFS251 may be possible depending on design. Review with State needed. (PS 11/3/20) Note: Mapped R0299/RPT1060 to OFS0594/RPT1316, deleted separate entry for RPT1060 as presented in CW-135. (PS 7/17/20) Per CW-135: Action Item: Review PATH functionality around these screens to determine whether a Cognos report is still needed as well (related to OFS0594, OFS0251). Include OFS0247 in merge analysis. Include OFS0244 in this analysis as well (currently doesn’t show a true beginning balance for clients starting mid-month).(Tammy L, Stacey J, Jacquelin Hoppe). Lake Furney to send info. Note that a screen solution would reflect near real time information while a report would at best be refreshed daily. Other discussion: Tammy L – this was discussed. Needs to include all subledger activity including closures and interest. Subledger closures work differently in PATH vs FACTS. Show all subledgers for a given client.

The report is needed in Cognos to include multiple clients.

PATH will also have a Client Account Log screen with robust filtering which could be the starting point for a screen export that is specific to the current client. There is also a view of activity across clients.

Per ‘Child Welfare Children Account Document Working Session Notes’ from 6/17/2020:

Client's Account Deposits or Withdrawals (ID# OFS-0251):

-This is a report, not a document, need to retire from the Document Inventory -Used to help with reconciliation process with JP Morgan and Chase banks; the deposits were completed -Used to verify the FREDI reports are correct -Need to follow up with Patience Sayler and Joe Simms that the report is on the inventory and on the agenda to review – Tammy Lawrence, Staci Jones are all primary users -PDF – no edits Client Account Activity Report (ID# OFS-0594):

-This is a report, not a document, need to retire from the Document Inventory -Mike Johnson proposed to merge the OFS-0594 and OFS-0251 reports -Internal Document -Is used by everyone for all different reasons - Tammy Lawrence, Candy Burdette, Staci Jones are all primary users -Need …the report is on the inventory and on the agenda to review – Tammy Lawrence, Staci Jones are all primary users

2. R0297

3. R0298 1. Client's Account Deposits or Withdrawals

2. The solution must produce a report of all deposits made into an individual's account.

3. The solution must produce a report of all disbursements for each client. Retain CA01 – Client Accounts 04/14/2021: Per Mike J, OFS0594 and OFS0251 will be delivered from PATH Client Account Log screen export. Refer user story.

Per State review, OFS0247 should be retained and not merged with OFS0594 and OFS251. Merge of OFS0594 and OFS251 may be possible depending on design. Review with State needed. (PS 11/3/20) Note: Mapped R0297/RPT1058 and R0298/RPT1059 to OFS0251/RPT1320, deleted separate entries for RPT1058 and RPT1059 as presented in CW-135. (PS 7/1/20) Per CW-135: Action Item: Review PATH functionality around these screens to determine whether a Cognos report is still needed as well (related to OFS0594, OFS0251). Include OFS0247 in merge analysis. Include OFS0244 in this analysis as well (currently doesn’t show a true beginning balance for clients starting mid-month).(Tammy L, Stacey J, Jacquelin Hoppe). Lake Furney to send info. Note that a screen solution would reflect near real time information while a report would at best be refreshed daily. Other discussion: Tammy L – this was discussed. Needs to include all subledger activity including closures and interest. Subledger closures work differently in PATH vs FACTS. Show all subledgers for a given client.

The report is needed in Cognos to include multiple clients.

PATH will also have a Client Account Log screen with robust filtering which could be the starting point for a screen export that is specific to the current client. There is also a view of activity across clients.

Per ‘Child Welfare Children Account Document Working Session Notes’ from 6/17/2020:

Client's Account Deposits or Withdrawals (ID# OFS-0251):

-This is a report, not a document, need to retire from the Document Inventory -Used to help with reconciliation process with JP Morgan and Chase banks; the deposits were completed -Used to verify the FREDI reports are correct -Need to follow up with Patience Sayler and Joe Simms that the report is on the inventory and on the agenda to review – Tammy Lawrence, Staci Jones are all primary users -PDF – no edits Client Account Activity Report (ID# OFS-0594):

-This is a report, not a document, need to retire from the Document Inventory -Mike Johnson proposed to merge the OFS-0594 and OFS-0251 reports -Internal Document -Is used by everyone for all different reasons - Tammy Lawrence, Candy Burdette, Staci Jones are all primary users -Need …the report is on the inventory and on the agenda to review – Tammy Lawrence, Staci Jones are all primary users

Per CW-135: Action Item: Review PATH functionality around these screens to determine whether a Cognos report is still needed as well (related to OFS0594, OFS0251). Include OFS0244 in this analysis as well (currently doesn’t show a true beginning balance for clients starting mid-month).(Tammy L, Stacey J, Jacquelin Hoppe). Lake Furney to send info. Note that a screen solution would reflect near real time information while a report would at best be refreshed daily. Other discussion: Tammy L – this was discussed. Needs to include all subledger activity including closures and interest. Subledger closures work differently in PATH vs FACTS. Show all subledgers for a given client.

The report is needed in Cognos to include multiple clients.

MJ 4/7/20: Cross check this with the list of CA reports.

Per CW-135: Action Item: State to verify whether report is needed. If retained, what is frequency needed? (Tammy L, may include Lesa M).

Report was retained for both CW and CC so the original entry was kept for CW and a new entry was created for CC on 3/24/20 (PS).

State CC Review Comments 3/4/2020: None

Per CW-135 on 7/17/20--Action Item: State to review possible merge of OFS5230 and OFS4990. (Tammy L) (PS 7/17/20)

State review 'Retain - will depend on interface'. (PS 11/5/20) Per CW-135, see Parking Lot item for possible modifications. Per CW-135: Replaced by PATH screen. (PS 7/10/20) Excel Export: Y Print:

CGI App: Not Exist Mike J Comment: The ability to Export the details is important to identity discovery and resolution. Recommend the client account functionality retain this Export functionality.

Per CW-136: Optum Config Item: Propose a draft report to merge R0336, R0337, R0335, R0338 with filters that would replicate the investigation subset and the program subset of workload as optional filters. Note: Current report (R0336, R0337) does not offer date prompt, just includes the current month in progress.

Per Naru Analysis: Retained without merge

SC: 09/21/2020: Retained as standalone without any merge.

Optum recommends analysis for possible merge with R0313, R0314, R0315, R0316, R0317, R0318.

SC: 09/23/2020: Retain as standalone without any merge.

Optum recommends analysis for possible merge with…