KLS Keeping Law Simple Legislation in plain English

Straight-ahead summaries built from the official bill text. We keep the source links front and center and leave the decision up to you.

Back to District of Columbia

CA26-0753 • 2025

Proposed Contract with Microsoft Corporation to Contract No. DCRL-2023-F-0071

Proposed Contract with Microsoft Corporation to Contract No. DCRL-2023-F-0071

Children
Active

The official status still shows this bill as active or still awaiting another formal step.

Sponsor
at the request of the Mayor
Last action
2026-05-21
Official status
Under Council Review
Effective date
Not listed

Plain English Breakdown

The official source material did not provide specific details on compliance requirements beyond tax status, which was confirmed by Clean Hands Certification.

Proposed Contract with Microsoft for Child Welfare System

The bill proposes to extend a contract between the District of Columbia and Microsoft Corporation for an enhanced child welfare information system.

What This Bill Does

  • Extends the existing contract (DCRL-2023-F-0071) with Microsoft Corporation by adding option year three from June 30, 2026 to June 29, 2027.
  • Microsoft will continue to work on an enhanced Comprehensive Child Welfare Information System (CCWIS).
  • The contract amount for this extension is $1,329,625.
  • Includes a labor hour contract with cost reimbursement components as set forth in the Price Schedule.

Who It Names or Affects

  • The District of Columbia government, specifically the Child and Family Services Agency (CFSA).
  • Microsoft Corporation.

Terms To Know

Comprehensive Child Welfare Information System (CCWIS)
A system designed to manage information related to child welfare services in a comprehensive manner.
Labor Hour Contract
A type of contract where payment is based on the number of hours worked by the contractor.

Limits and Unknowns

  • The exact details for option year four are not determined yet and will be evaluated later.
  • The bill does not specify how this extension affects other stakeholders or the public directly.

Bill History

  1. 2026-05-21 Council of the District of Columbia LIMS

    Retained by the Council with comments from the Committee on Youth Affairs

  2. 2026-05-20 Council of the District of Columbia LIMS

    CA26-0753 Introduced by Chairman Mendelson at Office of the Secretary

Official Summary Text

Proposed Contract with Microsoft Corporation to Contract No. DCRL-2023-F-0071

Current Bill Text

Read the full stored bill text 
MURIELBOWSERMayor
May20,2026
HonorablePhilMendelson
Chairman
CounciloftheDistrictofColumbia
JohnA.WilsonBuilding
1350PennsylvaniaAvenue,NW, Suite504
Washington,DC 20004
DearChairmanMendelson:
Pursuanttosection451oftheDistrictofColumbiaHomeRuleAct(D.C.OfficialCode§ 1-204.51)andsection202oftheProcurementPracticesReformActof2010(D.C.OfficialCode§2-352.02),enclosedforconsiderationandapprovalbytheCounciloftheDistrictofColumbiaisproposedModificationNo.M021 toContractNo.DCRL-2023-F-0071withMicrosoftCorporationtoexerciseoptionyearthreeintheamountof$1,329,625.TheperiodofperformanceisfromJune30,2026,throughJune29,2027,
Undertheproposedmodification,MicrosoftCorporationwillcontinuetoimplementanenhancedComprehensiveChildWelfareInformationSystem.
My administrationisavailabletodiscussanyquestionsyoumayhaveregardingtheproposedcontractmodification.Inordertofacilitatearesponsetoanyquestionsyoumayhave,pleasehaveyourstaffcontactEbonyTerrell,AgencyChiefContractingOfficer,ChildandFamilyServices,at(202)724-7415.
1lookforwardtotheCouncil’sfavorableconsiderationofthiscontractmodification.
Sincerely,
Mfriel Bwser
1

GOVERNMENT OF THE DISTRICT OF COLUMBIA
Office of Contracting and Procurement

Pursuant to section 202(c-3) of the Procurement Practices Reform Act of 2010, as amended, D.C.
Official Code § 2-352.02(c-3), the following contract summary is provided:

COUNCIL CONTRACT SUMMARY
(Options)

(A) Contract Number: DCRL-2023-F-0071

Proposed Contractor: Microsoft Corporation

Proposed Contractor’s Principals: Satya Nadella (Chairman & CEO) and Brad Smith (Vice
Chairman & President)

Contract Amount: $1,329,625

Unit and Method of Compensation: Labor Hour contract with a cost reimbursement component

Term of Contract: June 30, 2026 through June 29, 2027

Type of Contract: Labor Hour contract with a cost reimbursement
component as set forth in the Price Schedule

Source Selection Method: Cooperative Agreement

(B) For a contract containing option periods, the contract amount for the base period and for
each option period. If the contract amount for one or more of the option periods differs from
the amount for the base period, provide an explanation of the reason for the difference:

Base Period Amount: $11,902,280 (CA25-0462- deemed approved on October 28, 2023)

Option Period 1 Amount: $11,856,800 (CA25-0740 – deemed approved on June 7, 2024)
$3,688,350 (CA26-0079 – deemed approved on March 13, 2025)

Option Period 2 Amount: $6,274,510 (CA26-0196) – deemed approved on June 5, 2025.
$49,045 (Mod 16a executed on August 29, 2025)
$2,999,385 (CA26-0584 – deemed approved on February 5, 2026)
Option Period 3 Amount:

The price for services in modification M021 differs from the base year price to further support the
completion of CCWIS STAAND system stabilization services that directly support CFSA’s mission
critical objectives and help achieve the required Federal regulatory compliance.

Option Period 4 Amount: TBD - The District will re-evaluate the contract regarding the option
year's pricing prior to the exercise of option.

(C) A statement that Citywide Clean Hands database indicates that the proposed contractor is
current with its District taxes. If the Citywide Clean Hands Database indicates that the
proposed contractor is not current with its District taxes, either: (1) a certification that the
contractor has worked out and is current with a payment schedule approved by the District;
or (2) a certification that the contractor will be current with its District taxes after the District
recovers any outstanding debt as provided under D.C. Official Code § 2-353.01(b):

The contractor is in compliance with the District’s taxes as evidenced by its Clean Hands
Certification, dated May 1, 2026.

(D) A statement that the proposed contract is within the appropriated budget authority for the
agency for the fiscal year and is consistent with the financial plan and budget adopted in
accordance with D.C. Official Code §§ 47-392.01 and 47-392.02:

The CFSA Agency Fiscal Officer has certified that the agency has in its approved budget for fiscal
year 2026 sufficient funds to meet the obligations of the proposed modification. The FY2027 funds
are subject to approval of the FY2027 budget.

*
*
* GovernmentoftheDistrictofColumbia

mmm OfficeoftheChitFinancialOfficer 1101Steet,SW[Emm OfficeofTaxandRevenue ‘Washington,DC20028
DateofNotice:May1,2026 NoticeNumber:10016462956
MICROSOFTCORPORATION FEIN:**.*#84442
1MICROSOFTWAY. ‘CaseID:18961309REDMONDWA 98052-6399

CERTIFICATEOF CLEAN HANDS
AsreportedintheCleanHandssystem,theabovereferencedindividual/entityhasnooutstandingliabilitywiththeDistrictofColumbiaOfficeofTaxandRevenueortheDepartmentofEmploymentServices.Asofthedateabove,theindividual/entityhascompliedwithDCCode§47-2862,thereforethisCertificateofCleanHandsisissued.

TITLE47.TAXATION,LICENSING,PERMITS,ASSESSMENTS,AND FEESCHAPTER28GENERALLICENSESUBCHAPTERII.CLEANHANDS BEFORERECEIVINGA LICENSEOR PERMIT
D.C.CODE §47-2862(2006)§47-2862PROHIBITIONAGAINSTISSUANCEOFLICENSEOR PERMIT

‘AuthorizedByMelindaJenkins
BranchChief,CollectionandEnforcementAdministration
Tovalidatethiscertificate,pleasevisitMyTax.DC.gov.OntheMyTaxDC homepage,clickthe
“ValidateaCertificateofCleanHands”hyperlinkundertheCleanHandssection.

"101athSireetSW,SuiteW270,Washingion,DC2024/Phone:202)724-S048MVTaxDCgov
/i255
/i255
/1/2/3 /4 /5 /6 /7/4 /6 /8 /i255 /2/9 /i255 /8 /10/4 /i255 /11 /12 /13 /8 /5 /12 /14 /8 /i255 /2/9 /i255 /14 /2/15 /16 /7/17 /12 /18 /i255
/19 /20 /21 /22 /23 /i255 /25 /26 /23 /i255 /27 /25 /28/21 /22 /29 /i255 /30 /31 /32 /33 /21 /34 /31 /35 /i255 /36 /37 /31 /26 /34 /29 /i255
/i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255 /i255/i255
/i255
/39 /31 /25 /23 /40 /41 /25 /32 /42 /31 /32 /35 /43 /i255 /44 /45 /45 /i255 /46 /i255 /30 /42 /32 /31 /31 /42 /47 /i255 /30 /48 /i255 /49 /i255 /50/25 /35 /20 /21 /26 /37 /42 /51 /26 /47 /i255 /52 /53 /19 /53 /i255 /44 /45 /45 /45 /54 /i255 /49 /i255 /44 /45 /44 /55 /56 /56 /44 /55 /57 /58 /45 /45 /i255
/59 /59 /59 /53 /34 /60 /35 /25 /53 /23 /34 /53 /37 /51 /33 /i255 /49 /i255 /20 /42 /42 /61 /43 /62 /62 /23 /34 /53 /28/25 /26 /23 /25 /42 /31 /23 /32 /31 /61 /51 /32 /42 /31 /32 /53 /51 /32 /37 /i255 /i255
/i255
/i255
/63 /60 /60 /21 /34 /31 /i255 /51 /60 /i255 /27 /21 /26 /25 /26 /34 /31 /i255
/7/4 /7/2 /5 /18 /6 /11 /16 /7/i255
/i255
/8 /2/64 /i255/i255 /65 /25 /26 /29 /25 /i255 /65 /32 /21 /34 /31 /i255 /65 /51 /32 /32 /31 /35 /i255
/52 /21 /32 /31 /34 /42 /51 /32 /i255
/i255/i255 /19 /20 /21 /22 /23 /i255 /25 /26 /23 /i255 /27 /25 /28/21 /22 /29 /i255 /30 /31 /32 /33 /21 /34 /31 /35 /i255 /36 /37 /31 /26 /34 /29 /i255
/i255 /i255
/9 /5 /2/7 /64 /i255 /66 /41 /35 /42 /21 /26 /i255 /67 /51 /61 /34 /25 /i255
/36 /37 /31 /26 /34 /29 /i255 /27 /21 /35 /34 /25 /22 /i255 /63 /60 /60 /21 /34 /31 /32 /i255
/i255/i255 /19 /20 /21 /22 /23 /i255 /25 /26 /23 /i255 /27 /25 /28/21 /22 /29 /i255 /30 /31 /32 /33 /21 /34 /31 /35 /i255 /36 /37 /31 /26 /34 /29 /i255
/i255
/11 /18 /8 /4 /64 /i255 /i255 /i255
/i255
/13 /16 /17 /68 /4 /14 /8 /43 /i255 /i255/19 /31 /32 /42 /21 /60 /21 /34 /25 /42 /21 /51 /26 /i255 /51 /60 /i255 /27 /41 /26 /23 /35 /i255 /36 /33 /25 /21 /22 /25 /69 /21 /22 /21 /42 /29 /i255 /i255
/i255
/i255 /65 /51 /42 /25 /22 /i255 /19 /51 /26 /42 /32 /25 /34 /42 /i255 /70 /25 /22 /41 /31 /43 /i255 /71 /58 /47 /54 /44 /72 /47 /57 /44 /73 /i255 /74 /75/51 /23 /21 /60 /21 /34 /25 /42 /21 /51 /26 /i255 /75/45 /44 /58 /76 /i255
/i255
/65 /20 /31 /i255 /63 /60 /60 /21 /34 /31 /i255 /51 /60 /i255 /42 /20 /31 /i255 /19 /20 /21 /31 /60 /i255 /27 /21 /26 /25 /26 /34 /21 /25 /22 /i255 /63 /60 /60 /21 /34 /31 /32 /i255 /20 /31 /32 /31 /69 /29 /i255 /34 /31 /32 /42 /21 /60 /21 /31 /35 /i255 /42 /20 /25 /42 /i255 /42 /20 /31 /i255 /35 /41 /28/i255 /51 /60 /i255 /71 /77 /45 /73 /47 /45 /45 /45 /i255 /21 /35 /i255 /21 /26 /34 /22 /41 /23 /31 /23 /i255 /21 /26 /i255 /42 /20 /31 /i255
/78 /79 /80 /81 /82 /79 /83 /81 /84 /80 /i255 /86 /87 /88 /89 /90 /81 /i255 /91 /92 /88 /i255 /93 /79 /92 /91 /92 /83 /79 /91 /94 /i255 /95 /94 /91 /92 /i255 /96 /97 /82 /i255 /93 /79 /80 /83 /91 /94 /i255 /98 /90 /91 /82 /i255 /99 /100 /99 /57 /i255 /74 /66 /41 /26 /31 /i255 /54 /45 /47 /i255 /44 /45 /44 /57 /i255 /42 /20 /32 /51 /41 /37 /20 /i255 /30 /31 /61 /42 /31 /28/69 /31 /32 /i255 /54 /45 /47 /i255 /44 /45 /44 /57 /76 /i255 /25 /26 /23 /i255
/27 /21 /35 /34 /25 /22 /i255 /101 /31 /25 /32 /i255 /44 /45 /44 /77 /i255 /74 /30 /41 /69 /102 /31 /34 /42 /i255 /42 /51 /i255 /42 /20 /31 /i255 /25 /33 /25 /21 /22 /25 /69 /21 /22 /21 /42 /29 /i255 /51 /60 /i255 /60 /41 /26 /23 /35 /i255 /55 /i255 /58 /45 /62 /58 /62 /44 /57 /i255 /42 /20 /32 /51 /41 /37 /20 /i255 /66 /41 /26 /31 /i255 /44 /72 /47 /i255 /44 /45 /44 /77 /76 /i255 /42 /51 /i255 /60 /41 /26 /23 /i255 /42 /20 /31 /i255 /34 /51 /35 /42 /35 /i255
/91 /80 /80 /97 /83 /79 /91 /81 /90 /88 /i255 /103 /79 /81 /104 /i255 /81 /104 /90 /i255 /105 /93 /106 /107 /84 /80 /i255 /83 /97 /92 /81 /82 /91 /83 /81 /i255 /103 /79 /81 /104 /i255 /108/79 /83 /82 /97 /80 /97 /96 /81 /i255 /105 /97 /82 /109 /97 /82 /91 /81 /79 /97 /92 /i255 /96 /97 /82 /i255 /81 /104 /90 /i255 /105 /97 /110/109 /82 /90 /104 /90 /92 /80 /79 /111 /90 /i255 /105 /104 /79 /94 /88 /i255 /112/90 /94 /96 /91 /82 /90 /i255
/46 /26 /60 /51 /32 /28/25 /42 /21 /51 /26 /i255 /30 /29 /35 /42 /31 /28/i255 /74 /19 /19 /50/46 /30 /62 /30 /65 /36 /36 /113 /52 /76 /53 /i255 /65 /20 /21 /35 /i255 /34 /31 /32 /42 /21 /60 /21 /34 /25 /42 /21 /51 /26 /i255 /35 /41 /61 /61 /51 /32 /42 /35 /i255 /42 /20 /31 /i255 /75/21 /34 /32 /51 /35 /51 /60 /42 /i255 /19 /51 /32 /61 /51 /32 /25 /42 /21 /51 /26 /i255 /34 /51 /26 /42 /32 /25 /34 /42 /i255
/23 /41 /32 /21 /26 /37 /i255 /42 /20 /31 /i255 /61 /31 /32 /21 /51 /23 /i255 /60 /32 /51 /28/i255 /66 /41 /26 /31 /i255 /54 /45 /47 /i255 /44 /45 /44 /57 /i255 /42 /20 /32 /51 /41 /37 /20 /i255 /66 /41 /26 /31 /i255 /44 /72 /47 /i255 /44 /45 /44 /77 /53 /i255 /65 /20 /31 /i255 /60 /41 /26 /23 /i255 /25 /22 /22 /51 /34 /25 /42 /21 /51 /26 /i255 /21 /35 /i255 /25 /35 /i255 /60 /51 /22 /22 /51 /59 /35 /43 /i255 /i255
/i255
/3 /114 /115 /116 /117 /118 /64 /i255 /75/21 /34 /32 /51 /35 /51 /60 /42 /i255 /19 /51 /32 /61 /51 /32 /25 /42 /21 /51 /26 /i255 /i255 /i255/i255/i255/i255/i255/14 /117 /115 /119 /118 /120 /121 /119 /i255 /122 /64 /i255 /52 /19 /123 /124 /55 /44 /45 /44 /54 /55 /27 /55 /45 /45 /77 /58
/i255/i255 /i255
/9 /125 /126 /121 /120 /127 /i255 /128 /114 /120 /118 /i255 /129 /130 /129 /131 /i255/9 /132 /115 /116 /125 /115 /133 /64 /i255 /131 /134 /135 /130 /134 /129 /131 /i255 /119 /136 /118 /117 /132 /133 /136 /i255 /137 /134 /135 /130 /134 /129 /131 /i255 /i255 /i255 /i255 /i255 /i255
/18 /133 /114 /115 /121 /138 /i255/139 /118 /117 /140 /114 /121 /119 /i255 /18 /141 /120 /118 /116 /i255/13 /132 /142 /143 /8 /120 /126 /144 /i255/18 /121 /121 /117 /132 /115 /119 /i255/9 /132 /115 /116 /i255/139 /118 /133 /145/i255 /14 /117 /126 /119 /i255 /14 /119 /118 /i255 /18 /145/117 /132 /115 /119 /i255
/123 /124 /45 /i255 /i255
/58 /45 /45 /72 /57 /77 /i255
/i255
/54 /45 /45 /45 /44 /44 /73 /i255
/i255
/45 /58 /53 /45 /56 /i255
/i255
/77 /58 /54 /44 /45 /45 /58 /i255
/i255
/54 /45 /54 /45 /54 /45 /56 /i255
/i255
/58 /45 /45 /45 /77 /58 /i255
/i255
/77 /45 /54 /72 /73 /i255
/i255
/71 /77 /45 /73 /47 /45 /45 /45 /i255
/i255
/i255
/9 /125 /126 /121 /120 /127 /i255 /128 /114 /120 /118 /i255 /129 /130 /129 /146 /i255/9 /132 /115 /116 /125 /115 /133 /64 /i255 /147 /130 /134 /147 /134 /129 /131 /i255 /119 /136 /118 /117 /132 /133 /136 /i255 /131 /134 /129 /137 /134 /129 /146 /i255 /i255 /i255 /i255 /i255 /i255
/i255
/148 /109 /97 /92 /i255 /91 /109 /109 /82 /97 /111 /91 /94 /i255 /97 /96 /i255 /81 /104 /90 /i255 /78 /79 /80 /81 /82 /79 /83 /81 /84 /80 /i255 /149 /97 /83 /91 /94 /i255 /86 /87 /88 /89 /90 /81 /i255 /91 /92 /88 /i255 /93 /79 /92 /91 /92 /83 /79 /91 /94 /i255 /95 /94 /91 /92 /i255 /150 /151 /i255 /81 /104 /90 /i255 /105 /97 /87 /92 /83 /79 /94 /i255 /91 /92 /88 /i255 /81 /104 /90 /i255 /108/91 /151 /97 /82 /i255 /96 /87 /92 /88 /80 /i255 /103 /79 /94 /94 /i255
/69 /31 /i255 /35 /41 /60 /60 /21 /34 /21 /31 /26 /42 /i255 /42 /51 /i255 /61 /25 /29 /i255 /60 /51 /32 /i255 /60 /31 /31 /35 /i255 /25 /26 /23 /i255 /34 /51 /35 /42 /35 /i255 /25 /35 /35 /51 /34 /21 /25 /42 /31 /23 /i255 /59 /21 /42 /20 /i255 /42 /20 /31 /i255 /34 /51 /26 /42 /32 /25 /34 /42 /53 /i255 /65 /20 /31 /32 /31 /i255 /21 /35 /i255 /26 /51 /i255 /60 /21 /35 /34 /25 /22 /i255 /21 /28/61 /25 /34 /42 /i255 /25 /35 /35 /51 /34 /21 /25 /42 /31 /23 /i255
/59 /21 /42 /20 /i255 /42 /20 /31 /i255 /34 /51 /26 /42 /32 /25 /34 /42 /53 /i255
/i255
/65 /20 /31 /i255 /42 /51 /42 /25 /22 /i255 /51 /61 /42 /21 /51 /26 /i255 /29 /31 /25 /32 /i255 /54 /i255 /113 /51 /42 /55 /42 /51 /55 /48 /152 /34 /31 /31 /23 /i255 /25 /28/51 /41 /26 /42 /i255 /21 /35 /i255 /71 /58 /47 /54 /44 /72 /47 /57 /44 /73 /53 /i255 /i255 /i255
/i255
/30 /20 /51 /41 /22 /23 /i255 /29 /51 /41 /i255 /20 /25 /33 /31 /i255 /25 /26 /29 /i255 /40 /41 /31 /35 /42 /21 /51 /26 /35 /47 /i255 /61 /22 /31 /25 /35 /31 /i255 /34 /51 /26 /42 /25 /34 /42 /i255 /28/31 /i255 /25 /42 /i255 /44 /45 /44 /55 /77 /44 /77 /55 /77 /54 /153 /54 /53 /i255
/18 /133 /114 /115 /121 /138 /i255/139 /118 /117 /140 /114 /121 /119 /i255 /18 /141 /120 /118 /116 /i255/13 /132 /142 /143 /8 /120 /126 /144 /i255/18 /121 /121 /117 /132 /115 /119 /i255/9 /132 /115 /116 /i255/139 /118 /133 /145/i255 /14 /117 /126 /119 /i255 /14 /119 /118 /i255 /18 /145/117 /132 /115 /119 /i255
/123 /124 /45 /i255/58 /45 /45 /72 /57 /77 /i255 /54 /45 /45 /45 /44 /44 /73 /i255 /i255
/45 /58 /53 /45 /56 /i255
/i255
/77 /58 /54 /44 /45 /45 /58 /i255
/i255
/54 /45 /54 /45 /54 /45 /56 /i255
/i255
/58 /45 /45 /45 /77 /58 /i255
/i255
/77 /45 /54 /72 /73 /i255
/i255
/71 /57 /44 /56 /47 /57 /44 /73 /i255

GOVERNMENT OF THE DISTRICT OF COLUMBIA
Child and Family Services Agency
CONTRACTS AND PROCUREMENT ADMINISTRATION
Glasford Hall, Jr.
Microsoft Delivery Executive
Microsoft Corporation
12012 Sunset Hills Road
Reston, VA 20190 REF: Letter Contract
DCRL-2023-F-0071 CCWIS/STAAND
Dear Mr. Hall, Jr.:
1. This is a letter contract between the District of Columbia Government; hereinafter, referred
to as the District and Microsoft Corporation hereinafter referred to as the contractor wherein the
contractor agrees to perform the services set forth in the Scope of Work, Attachment A.
2. This letter contract has time and materials components. The District will pay Microsoft Corporation
for the development, configuration and customization of the Intake Module for the Comprehensive
Child Welfare Information System (CCWIS)/Stronger Together Against Abuse and Neglect in DC
(STAAND) system within supported development standards (following the Dynamics 365 SDK) so
that features will be within the upgrade path for product upgrades. Development of the new data
model for the Intake Module, based on the Price Schedule, Attachment J.5 and the Statement of
Work, Attachment J.3.
3. The term of this letter contract is from June 30, 2023, through October 27, 2023. The District
intends to definitize this letter contract within one hundred twenty (120) days of award of this
letter contract (the date the Contracting Officer signs this letter contract), at which time this letter
contract shall merge with the definitized contract. Before the expiration of the one hundred
twenty (120) days, the Contracting Officer may authorize an additional period in accordance
with Sections §2425.9 of the Procurement Regulations and 27 DCMR §2425.9. If the District
does not definitize this letter contract within one hundred twenty (120) days of the award of this
letter contract or any extensions thereof, this letter contract shall expire. In the event of the
expiration of this letter contract, or any extension thereof, the District shall pay the contractor for
services performed under this letter contract in an amount not to exceed $998,980. In no event
1

Doc ID: 4c380824faae1993f6292875121e0c7f74e14a30
shall the amount paid under this letter contract or any extensions thereof, exceed $1,000,000.00,
without approval from the DC Council.
4. The duration of the definitized contract shall be three hundred, sixty-six (366) days from award
of this letter contract (June 30, 2023, through June 29, 2024). The District shall pay the
contractor for the services performed during the duration of the definitized contract in an amount
not to exceed $998,980.
5. The contractor shall perform under this letter contract pursuant to the term of the following
documents, which are hereby incorporated by reference and made a part of this letter contract. A
conflict in language shall be resolved by giving precedence to the document in the highest order
of priority that contains language addressing the issue in question. The following documents are
incorporated into the contract by reference and made a part of the contract in the following order
of precedence:
(a) This letter contract:
(b) The Scope of Work dated 6/19/23, Attachment J.3;
(1) Contract Terms and Conditions, Attachment J.5;
(2) The Pricing Schedule, Section 2 of the Letter Contract
(3) Work Order# GVS0235-434536-549249, dated June 19, 2023, Attachment J.4.
(c) VITA Contract (VA-160304-MCS) and all Amendments
6. The letter contract shall be subject to the following:
(a) Appropriation of funds;
(b) The approval by the Council of the District of Columbia, in accordance with D.C.
Official Code, §2-352.02, if this letter contract is of a value in excess of one million
dollars. However, if this letter contract is not in excess of one million dollars, but the
value of the subsequent definitized contract, (which includes the value of this letter
contract) is in excess of one million dollars, the definitized contract must be approved by
the Council in accordance will D.C. Official Code, §2-353.02. If the Council disapproves
the subsequent definitized contract, all performance under the letter contract shall
terminate and the liability of the District shall be limited to the amount set forth in
provision number 3, above, of the letter contract.
2

Doc ID: 4c380824faae1993f6292875121e0c7f74e14a30
DISTRICT OF COLUMBIA
Signature of CFSA Interim Agency Chief Contracting Officer Date
CONTRACTOR
Jun 27, 2023 / Delivery Management Executive Glasford Hall (Jun 27, 2023 18:40 EDT)
Signature of Microsoft Corporation Date
3

06 / 29 / 2023
Doc ID: 4c380824faae1993f6292875121e0c7f74e14a30

AMENDMENT OF SOLICITATION / MODIFICATION OF CONTRACT
1. Solicitation / Contract No. Page of Pages
DCRL-2023-F-0071 1 1
2. Amendment/Modification
Number
3. Effective Date 4. Requisition/Purchase Request No. 5. Solicitation Caption

M021

June 30, 2026

RK326895
Comprehensive Child Welfare
Information System/Stronger
Together Against Abuse and Neglect
in DC (CCWIS/STAAND)
6. Issued by: Code RL0 7. Administered by (If other than line 6)
Government of the District of Columbia
Child and Family Services Agency
Contracts and Procurement Administration
200 I Street, S.E., Suite 2031
Washington, DC 20003
Government of the District of Columbia
Child and Family Services Agency
Child Information Systems Administration
200 I Street SE, 3rd Floor
Washington, D.C. 20003
8. Name and Address of Contractor (No. street, city, county,
state, and zip code):

Microsoft Corporation
12012 Sunset Hill Road – 5th Floor
Reston, VA 20190
POC: Daryl Derkowski
Phone: (516) 749-4484
Email: daderkow@microsoft.com

9A. Amendment of Solicitation No.

9B. Dated (See Item 11)

X
10A. Modification of Contract/Order No.

DCRL-2023-F-0071

10B. Dated (See Item 13)
June 30, 2023
11. THIS ITEM ONLY APPLIES TO AMENDMENTS OF SOLICITATIONS
The above numbered solicitation is amended as set forth in item 14. The hour and date specified for receipt of Offers is extended. is not extended.
Offers must acknowledge receipt of this amendment prior to the hour and date specified in the solicitation or as amended, by one of the following methods:
(a) By completing Items 8 and 15, and returning _________ copies of the amendment; or (b) By acknowledging receipt of this amendment on each copy of the
offer submitted. FAILURE OF YOUR ACKNOWLEDGMENT TO BE RECEIVED AT THE PLACE DESIGNATED FOR THE RECEIPT OF OFFERS PRIOR TO
THE HOUR AND DATE SPECIFIED MAY RESULT IN REJECTION OF YOUR OFFER. If by virtue of this amendment you desire to change an offer already
submitted, such may be made in accordance with the solicitation and is received prior to the opening hour and date specified.
12. Accounting and Appropriation Data (If Required)
13. THIS ITEM APPLIES ONLY TO MODIFICATIONS OF CONTRACT/ORDERS ,
IT MODIFIES THE CONTRACT/ORDER NO. AS DESCRIBED IN ITEM 14
A. This change order is issued pursuant to (Specify Authority): 27 DCMR, Chapter 36, Contract Modifications
The changes set forth in Item 14 are made in the contract/order no. in item 10A.
B. The above numbered contract/order is modified to reflect the administrative changes (such as changes in paying office, appropriation data
etc.) set forth in item 14, pursuant to the authority of 27 DCMR, Chapter 36, Section 3601.2.
C. This supplemental agreement is entered into pursuant to authority of:
X D. Other (Specify type of modification and authority) DCMR Section 27-2008. EXERCISE OF OPTIONS

E. IMPORTANT: Contractor is not required to sign this document.
14. Description of Amendment/Modification (Organized by UCF Section headings, including solicitation/contract subject matter where feasible.)

In accordance with 27 DCMR, Section 2008, exercise of options, the District hereby exercises option year three of
Contract No. DCRL-2023-F-0071, Comprehensive Child Welfare Information System (CCWIS)/Stronger Together
Against Abuse and Neglect in DC (STAAND):

1. Pursuant to Section F.1.2, Option to Extend the Term of the Contract, the District hereby exercises
option year three for the period of June 30, 2026, through June 29, 2027, in the NTE amount of
$1,329,625.

2. All other terms and conditions remain unchanged.
Except as provided herein, all other terms and conditions of the document is referenced in Item 9A or 10A remain unchanged and in full force
and effect.
15A. Name and Title of Signer (Type or print) 16A. Name of Contracting Officer
Ebony Terrell
15B. Name of Contractor

(Signature of person authorized to sign)
15C. Date Signed 16B. District of Columbia

(Signature of Contracting Officer)
16C. Date Signed

‘== | GOVERNMENTOFTHEDISTRICTOFCOLUMBIA, (> | ChildandFamilyServicesAgency(CFSA)

4,Caption Pageof Pages
SOLICITATION,OFFER,ANDAWARD —_[ComorehensiveChiWaleinfomationSystem(CCW) 7] 82.ContractNumber 5.Typeof Solicitation 6.Typeof Market
[DCRL-2023-F-0071 SealedBid(FB) & Open
3.SolicitationNumber ‘SealedProposals(RFP) C1 SetAside
C1 SdleSource 1_OpenvithSub-ContacingSetAsideX CooperativeAgreements “t % %4, Date Issued NOTE: Insealedbidsolicitations"offer"and *offeror’
O_ Emergency means"bid"and"bidder.
T.lssuedBy: AddressOfferto: Delivery
‘ConrecsandProcurementAdminsvalon| ConlaclsandProcurementAdminisaton| Chl rfomalionSystemsAaiinsraionChildandFamilyServicesAgency(CFSA) Childand FamilyServicesAgency(CFSA) Childand FamilyServicesAgency(CFSA)
200|Street,S.E.Suite2031 200| Street,S.E.Suite2031 200! Street,SE-3* Floor
Washington,DC20003 Washington,0¢20003, Washington,D¢20008(202)724-5300 (202)724-5300 (202)724-5300
‘A.SOLICITATIONCONTRACTFORM
‘9.SubmissionDeadline DateDue. NIA Time Due NA
CAUTION:LaeSuomen,MediatorsandWibsanalSoe27DOMRchaps15&16apleabeAlerasjeaallesandcolonsconnedieoko,10.Agency Contact ‘A.Name B.Telephone ‘Extension| C.E-mailAddress
FSA DanyelFiley,ConralSpecialist20-72-1588 DanyelRleyiodagonTH.TableofContents | Section|Description PageNo.
00)|Section|Description PageNo.|X |G_| ContractAdministrationData 8
x A ‘Solicitation/ContractForm 1 x H ‘SpecialContractRequirements 7
x B ‘SuppliesorServicesand Price/Cost 4a x T ContractClauses cy
x Cc ‘SpecificationsWork Statement 6 x J ListofAttachments 8
x D Packagingand Marking 62. x K Representations,certificationsandotherstatementsofofferors NA
x E InspectionandAcceptance 62 x L Instructions,conditions&noticesto offerors NA
x F PeriodofPerformance/Deliverables62 x M Evaluationfactorsforaward NA
OFFER
412.In.compliancewiththeabove,theundersignedagrees,Ithisofferisacceptedwithin21calendardaysfromthedateforreceiptofoffersspecifiedabove,tofurnishanyorallitemsuponwhichpricesareofferedatthepricesetoppositeeachitem,deliveredatthedesignatedpoint(s),withinthetimespecifiedherein.

13.DiscountforPromptPayment2 |10Calndardays|_% |20Calendardays| ot|S0Calendardays|% | __Calndardays| __‘b414.AcknowledgementofAmendments|_AmendmentNumber [Date[AmendmentNumber [Date[AmendmentNumber| —Date
(TheofferoracknowledgesreceiptofamendmentstotheSOLICITATION):
75.OfferorContactInformation PersonAuthorizedtoSignOfferiContract| PersonAuthorizedtoSignOfferiContract
IfOfferorisaJointVenture,add A.Name DianeBoettcher
Sonatinasofetonalgenerate, Tile iefofStaff,SLGE,MicrosoftIndustrySolutions|
Par Ppropriate.Tc.address 6518MeadowridgeRd
City,State,Zip| Elkridge,Md21075
heckemitanceadresis, |D.Phone (667)274-1121fiferentfromadressto theright -“RefertoSectionG. 17.Signature| DianeBoettcher
18,OfferDate| Nov13,2023
‘AWARD(TOBECOMPLETEDBYGOVERNMENT)

19,AcceptedasfoRomsNumbered Ta0.Amount|$17,902.280.00| 24.AccountingandAppropriation-SeeSectionG
22:NameofContractingOfficer(TypeorPrint) Za.SignaturofContractingOfficer 24,AwardDate
EbonyTerrell,InterimAgencyChiefContractingOfficer ChongTete” 14/14/2023
DocID:034810a316a0324020f8cf15540567978123871
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page2of69

Table of Contents
SECTION B CONTRACT TYPE, SUPPLIES OR SERVICES AND PRICE .... seesecencenrennnan
B2 TYPEOFCONTRACT.
B3 PRICESCHEDULE
SECTIONC —_SPECIFICATIONS/WORKSTATEMENT......
ca, ‘ScoPt
C2. ‘APPLICABLEDOCUMENTS

ca, BACKGROUND... ntnteatenensese
cs. CONTRACTREQUIREMENTS...
C6 PROJECTMANAGEMENT...
7. KEYPERSONNE!
ca REQUIREMENTSMANAGEMENT.....
C9,
C10.
ci. DATACONVERSIONAND MIGRATION.....
C12. ‘TRAININGANDKNOWLEDGETRANSFER...
C13. TIMELINE.
cia. AREASOUTOFSCOPE
C16. EXISTINGSYSTEMDESCRIPTION
17. ARCHITECTURE 53
C18. ‘SYSTEMINTEGRATION... 54
C19. ‘SECURITYANDSYSTEMROLES 55
C20.
C22. AUTHORITYTOOPERATEREQUIREMENTS.
C23. APPLICATIONPROGRAMMINGINTERFACE
C24. FINALBUSINESSPRODUCTPERMODULE...
C25. REQUIREMENTSTRACEABILITYMATRIX..
C26. CCWISTECHNICALASSISTANCEPROCESS.

SECTIOND—_ PACKAGINGANDMARKING.....
SECTIONE_ INSPECTIONANDACCEPTANCE...

SECTIONF PERIODOFPERFORMANCEANDDELIVERABLES.
Fa ‘TERMOFCONTRACT...
OPTIONTOEXTENDTHETERMOFTHECONTRACT...
F2 DELIVERABLES

SECTIONG
Gi
G2
G3
GA
Gs
G6
G7
Gs
G10
Gat
SECTIONH
Ha
H2
SECTION!
SECTIONS
da
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page3of69
CONTRACTADMINISTRATION..

INVOICEPAYMENT.

THEQUICKPAYMENTACT.....
CONTRACTINGOFFICER(CO)...
AUTHORIZEDCHANGESBYTHECONTRACTINGOFFICER..
CONTRACTADMINISTRATOR(CA)..
(RESERVED)..
HIPAAPRIVACYCOMPLIANCE....

HOURLYRATECEILING...
‘SPECIALCONTRACTREQUIREMENTS..

ATTACHMENTS
USTING..
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page4of69
SECTION B
Bl
B2
B21
CONTRACT TYPE, SUPPLIES OR SERVICES AND PRICE
PURPOSE
TheDistrictofColumbia(“District”),ChildandFamilyServicesAgency(“CFESA”)isenteringintoacontractwithMicrosoftCorporation(Microsoft)toimplementanenhancedComprehensiveChildWelfareInformationSystem(CCWIS).CFSAcurrentlyusesasystemcalled“FACES”thatrunsonoutdatedtechnologyandarchitecturetomeettherequirementsoftheAdministrationforChildrenandFamilies(ACF).InFebruary
2023,partsofthenewCCWISStrongerTogetherAgainstAbuseandNeglectDC(STAAND),referredtoasRelease|(R1)wentliveincludingtheresourceparentlicensingportal,ayouthportal(smallportion)and9serviceslinesfortheCFSAOfficeofWellBeing.
TheremainderofDistrictCCWIS(STAAND)solution,ReferredtoasRelease2(R2)istobebuiltaspartofthiscontractleveragingthefollowingtechnologies.MicrosoftDynamics365platformaugmentedbyadditionalMicrosoftAzureandothercomponents.Thesystemshallbeamodern,modular,andcompletechildwelfaresystemmadeto
streamlineCFSA’sbusinessprocessesandworkflows,integratewithsystemsanddatarepositories,andpresentanintuitive,secure,reliableandaccurateuserinterfacesupportingcase,clientandfamily-centricviewofthestateoftheircarewhereverourstaff,clients,andcommunityneedaccesstotheinformationthatservesandprotectsourchildrenandfamiliesinneed.CFSA’sgoalsare:
Thefirstgoalistoobtaincoretechnologythatismodularandconfigurabletoprovideflexibilitytomeettheever-changingchildwelfarepoliciesandstreamlineCFSA’s
businessprocessesandworkflows.
Thesecondgoalistoreducedataentrybysocialworkersandguideuserstotheirperspectivegoals.
The thirdgoalistopresentan intuitive,secure,reliableand accurateuserinterface
thatsupportscase,clientand family-centricviews of CFSA’s clientcareand staff
workload.
ThefourthgoalistopromotetransparencyandaccountabilitythroughcompliancewithfederalandDistrictpoliciesandconsistencyoftheapplicationofrules.
Thefifthgoalistomeetandexceeddataexchange,andsecurityrequirementsset
forthbythefederalregulations.
The sixthgoalistoseamlesslytransitionfrom CFSA’ currentCCWIS builtand
maintainedfor20 yearscalled“FACES” totheenhanced CCWIS.
TYPE OF CONTRACT
LABOR HOURS
TheDistrictcontemplatesawardofa LaborHourcontract,withcostreimbursementcomponents.ContractLineItemsnumbered0001through0O11areidentifiedinthe
PriceSchedule(SectionB.3.3).
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page5of69
B22
B3
B31
B32
B33.1
COST REIMBURSEMENT
B.2.2.1TheDistrictwillreimbursetheContractorforcostsinaccordancewiththeactualcostsincurred.ThepaymentforasneededtravelexpenseswillbemadeasareimbursementtotheContractor,inaccordancewiththeFederalGSAPerDiemrates.
B.2.2.2TheCostReimbursementinvoicesshallbesubmittedmonthly.SupportingdocumentationisrequiredandwillbepaidwithoutregardtooverageoftheGSAPerDiemallowance.
B.2.2.3TheContractorshallnotmark-upthecostreimbursementallowable
expensesonthiscontractwithindirectcostofoverhead,general,andadministrativecost.Profitsmaynotbechargedagainstcostreimbursementexpensesunderthis,contract.
PRICE SCHEDULE
The priceschedule forcontractDCRL-2023-F-0071 Comprehensive Child Welfare
InformationSystem/StrongerTogetherAgainstAbuseandNeglectinDC(CCWIS/STAAND)isincludedasSectionB.3.3.
ThepricescheduleforthiscontractislistedinSectionB.3.3.AsstatedinSectionG,thelaborhourrates,allocatedbycontractyear,forCLINs0001—through0010,asproposedinSectionB.3.3andincorporatedintheawardedCCWISSTAANDcontract,willbeusedfordeterminingprogressforthepurposeofestablishingthepaymentamountforeachmonthlyinvoicingperiod.Intheeventthereisadiscrepancyprice
scheduleinSectionB.3.3andMicrosoft’spricescheduleinMicrosoft'sVITAcontract,theDistrictwillselectthemostadvantageousoption.

PRICE SCHEDULE
LETTERCONTRACT(June30,2023~October27,2023)
cun| Resource Rate Hours| TotalCLIN
0001| PrincipalConsultant $330| _374| $123,420.00
0002| AssociateConsultant $245| 680 $166,600.00
0003| ProgramDirector $340| 374 $127,160.00
(0004| MSFTGDConsulting-Offshore $35| 4284| $364,140.00
0005| MSFTGDConsulting-Onshore $230| 680 $156,400.00
0006| CostReimbursement $61,260.00 1 $61,260.00
NotToExceed $998,980.00
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page6of69
B33.1.1
DEFINITIZEDCONTRACT(October28,2023-June29,2024)

cUN | Resource Rate Hours| TotalCLIN
0001_| PrincipalConsultant $345| 3360| _$1,159,200.00
0002__|AssociateConsultant $255| 1680 $428,400.00
0003_| ProgramDirector $425| 2000 ‘$850,000.00
0004_| MSFTGDConsulting-Offshore $25| 49140 |__$4,176,900.00
0005_| MSFTGDConsulting-Onshore $240| 5040| _$1,209,600.00
0006_| Consultant $295|_ 6720 $1,982,400.00
0007__|SeniorProjectManager $330| 1680 $554,400.00
0008_| SeniorConsultant $330| 1680 $554,400.00
0009_| ConsultingProductManager $330| 740 $244,200.00
00010_| DomainSolutionArchitect $355| 436 $154,780.00
00011_| CostReimbursement $588,000.00 1 $588,000.00
NotToExceed| _ $11,902,280.00
TotalBaseYearNottoExceed| $12,901,260.00
B.3.3.2OPTION YEAR 1 PRICE SCHEDULE RESERVED
B.3.3.3OPTION YEAR 2PRICE SCHEDULE RESERVED
B.3.3.4OPTION YEAR 3 PRICE SCHEDULE RESERVED
B.3.3.5OPTION YEAR 4 PRICE SCHEDULE RESERVED
B34 TheDistrictwillre-evaluatethecontractatthe6-monthmarkregardingtheoptionyear’spricingfromthestartdateofJune30",2023.Ifthepartiescannotreachamutuallyagreeableresolutionastothepriceschedule,thepartiesmaydecidenotto
exercisetheupcomingOptionPeriod.
**END SECTION B**
SECTIONC SPECIFICATIONS/WORK STATEMENT
CA.
CLL
C12
SCOPE
The Scope of Work forcontractDCRL-2023-F-0071 isdelineatedinthisSection.
TheDistrictofColumbia(“District”),ChildandFamilyServicesAgency(“CFSA”)isenteringintoacontractwithMicrosoftpursuanttoVirginiaInformationTechnologyAgreement(VITA)toimplementanenhancedComprehensiveChildWelfareInformationSystem(CCWIS)usingtheMicrosoftDynamics365platform
augmentedbyMicrosoftAzureandothercomponents.CCWISshallusemoderntechnology,bemodularinitsdesign,andserveCFSAholistically.Thegoalismulti-
faceted.Thefirstgoalistoobtaincoretechnologythatismodularandconfigurabletoprovideflexibilitytomeettheever-changingchildwelfarepoliciesandstreamlineCFSA’sbusinessprocessesandworkflows.Thesecondgoalistoreducedataentrybysocialworkersandguideuserstotheirperspectivegoal.Thethirdgoalisto
presentanintuitive,secure,reliableandaccurateuserinterfacethatsupportscase,
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page7of69

C14
cls
C16
clientandfamily-centricviewsofCFSA’sclientcareandstaffworkload.ThefourthgoalistopromotetransparencyandaccountabilitythroughcompliancewithfederalandDistrictpoliciesandconsistencyoftheapplicationofrules.Thefifthgoalistomeetandexceeddataexchange,andsecurityrequirementssetforthbythefederalregulations.ThesixthgoalistoseamlesslytransitionfromCFSA’currentCCWISbuiltandmaintainedfor20yearscalled“FACES”totheenhancedCCWIS.ThesegoalsareCFSAgoalsandnotMicrosoftdeliveryobjectives.
MicrosoftwillprovideServices,inanAgilecapacitymanner,tocompletethe
followingsolutioncomponents.Allcomponentsmaynotbecompletedwithinthecapacitydefined.CFSAwillprioritizeuserstories,withsupportfromMCS ProgramandTechnicalLeadershipteamandMicrosoftwillexecuteagainstthoseprioritizeduserstorieswithinthecapacity.Microsoftwillconfigureandcustomizethe
Dynamics365systemfollowingsupporteddevelopmentstandards,sothatfeatureswillbewithintheupgradepathforproductupgrades.Developmentofthenewdatamodelforthein-scopemodules.
ModulesincludedinthisCCWISDevelopmentcontractinclude:
Intake(addingontoLetterContractdevelopment)
ProviderInvestigations
CaseManagementEligibility
FinanceModule‘Common/Foundational(addingontoprior(LetterContractdevelopment)
LettercontractIntakephaseretrospective:
ThiswillactasaretrospectivefortheIntake(LetterContractdevelopment).Lessonslearnedfromthe(LetterContractdevelopment)willbejointlydevelopedwithCFSA.
Ifimprovementsareidentifiedbasedontheselearnings(velocity,capacity,andtechnicaldebt),arequestwillbedevelopedtomodifytheremainderoftheengagement.ThiscouldbeaCR thatwillrealignanyupdatesthatarerequiredtobemadetoplanningandimplementationforthecurrentfuturephasesdefinedinthisdocument.
MicrosoftunderstandsthattheCFSAisseekingtoengagemoredeeplywiththefamiliesitserves,promotethesafetyandwell-beingofchildren,empowertheircaseworkerswithmoreefficientsolutions,achievegreatertransparency,improvedecision-makingwithadvancedanalytics,anddrivepositiveoutcomesformore
childrenandfamilies.Microsoftwilldrivea‘configure-first’approachwithCFSA,endeavoringtomeetrequirementsanduserstorieswithoptionsthatleverageconfigurationoftheplatform,minimizingtheneedforcustomcodedevelopment.
ThegoalofthisprojectphaseistoprovideCFSAwithaTimeandMaterials(T&M)capacity-baseddeliveryteamtoworkonadditionalmodulesfortheCCWISsystem.
AsthisisanAgileproject,theprioritizeduserstoriesdefinedbyCFSAandmaintainedintheAzureDevOpstool(ADO)backlogwillbesourceforalldetailedscopeandchangestoprioritizationcanbeincorporatedforfutureSprints.AddingnewscopemaycauseworktoexceedtheT&M capacityestimatedinthisphase.
DCRL-2023-F-0071 Comprehensive ChildWelfareInformationSystem (CCWIS) Page 8 of 69
C17 Forclarity,itismutuallyunderstoodandagreedthat:
Microsoftrecommendsa fullengagementwithuseracceptancetesting(UAT)acceptedsolutionanddeploymenttoproduction;however,theeffortandrelatedfundingforthisengagementareonlysufficienttocarryoutthenext42weeksoftheprojectasdescribedinthedefinitizedcontract.Thisincludeseffortsforalimitedamountofbuildsprintsonlyanddoesnotincludeend-to-endsolutiontesting,UAT,deployment,orsupport.Fullprogrambenefitswillberealizedafterfutureprojectphasesarefundedforitemsnotincludedinthisfunding.
C18 TheCFSA(CFSA)willprovidesubjectmatterexperts(SMEs),program
managementandworkitemprioritization.Microsoftwillprovideteamsofhighly
qualifiedresourcesincludingprojectmanagement,solutionarchitecture,functional
expertise,dataconversionexpertise,qualityassurance,securityand engineering
resourcestocompletetasksrelatedtouserstories.
C19 Businessoutcomes
C.1.10 ThebusinessoutcomeofthisprojectaretoworkonprioritizeduserstoriesthatsupportaDC-centricCCWISSystemthatwillallowtheagencytostreamlineCFSA’sbusinessprocessesandworkflows,withinthecapacityoftheengagement.ToachievethisoutcomeMicrosoftwillprovideresourcecapacitytoworkonuserstoriesprioritizedbyCFSA.Thisfunctionalitywillbedefinedinfinalbusiness
processflowsanduserstories,approvedandstoredinAzureDevOps.
Prue cory

Work on additionalCCWIS modules _ Buildingon work from priorrelatedCCWIS
engagements,theremainingmoduleswillbedevelopedbased on prioritizeduserstoriesfrom CFSA, utilizing
Microsoftteamsthatwillbeengagedontheproject.
Configuredanddevelopedfeatureswillbe
demonstratedinanon-productionenvironmentatthe
endofeachbuildsprint.
C2. APPLICABLE DOCUMENTS
C24 ThedocumentssharedinthissectionareavailabletotheContractorviathePublic
Internet.EachdocumenttitlehasanembeddedhyperlinkthatwillprovidethedocumenttotheContractor.CFSAproductownerswillberesponsibleforcreating,approving,andprioritizinguserstoriesinAzureDevOps(ADO)basedonthefollowingdocuments:

ItemNo. Document Date
1 FourPillarsStrategicFramework 2012
2 CESAFourPillarsScorecard 2022
3 CCWISFinalRuleOverview 2016
4 CFSAOlderYouthServicesPolicy 2014
5 Childand Family ServicesImprovement and InnovationAct (H.R.2883) 2011
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page9of69

6 DC LanguageAccessActMunicipalRegulations 2014
7 FederalChildWelfarePolicyManual 2017
8 ‘MandatedReporterTraining 2008
9 MandatedReporters 2015
10 NationalYouthinTransitionDatabase(NYTD) 2012
u OlderYouthBenchmarks 2018
12 PreventingSexTraffickingandStrengtheningFamiliesAct (P.L.113-183) 2014
ItemNo. Document Date
13, Title29DC MunicipalRegulations,Chapter60 2015
14 AdoptionandSafeFamiliesActof1997 1997
15 D.C.Law13-136,AdoptionandSafeFamiliesAmendmentActof2000 2000
16 DC FamilyCourtActof 2001 2001
7 FosteringConnectionstoSuccessandIncreasingAdoptionsActof2008 2008
18 IndianChildWelfareAct 1978
19 TimelyInterstatePlacementofFosteringChildrenActof2006 2006
20 SuperiorCourtGeneralRulesoftheFamilyCourt 2017
2 DC SuperiorCourtAdministrativeOrder07-22 2006
2 CFSA EstablishmentAct 2001
23 PatientProtectionandAffordabilityAct 2010
24 StephanieTubbsJonesChildWelfareServices:TitleIV-B,Subpart1oftheSocial 2012SecurityAct
25 DC LanguageAccessActMunicipalRegulations 2014
26 DC OfficeofDocumentsandAdministrativeIssuances:Chapter60PublicWelfare 2018
27 Codeof MarylandRegulations 2018
28 AdoptionandFosterCareAnalysisandReportingSystem(AFCARS) 2012
29 BillofRightsforChildrenandYouthinFosterCare 2013
30 TitleIV-EFosterCare 2012
31 TheChildinNeedofProtectionAmendmentActof2004 2001
32 PreventionofChildAbuseandNeglectActof1977 1977
33 DC CodeTitle4PublicCareSystems 2019
34 DC AttendanceAccountabilityAmendmentAct 2013
% SafeChildrenandSafeNeighborhoodsEducationalNeglectMandatoryReporting 2010AmendmentActof2010
36 H.R.253-FamilyFirstPreventionServicesActof2017 2017
37 TechnicalBulletinspertainingtoCCWIS 2019
C3.

DEFINITIONS
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page10of69
C31
C311
C312
C313
C314
C315
C3.1.6
C3.1.7
C318
C319
C3.1.10
These termswhen used inthiscontracthave thefollowingmeanings:
AssistantAttorneyGeneral(AAG)isaCFSAstaffmemberthatrepresentsthe
agencyunderthedirectionoftheattomeygeneral.

‘AdministrationforChildrenandFamilies(ACF)-isadivisionoftheDepartmentof
HealthandHumanServices.ACFpromotestheeconomicandsocialwell-beingofchildren,families,individuals,andcommunitieswithleadershipandresourcesforcompassionate,effectivedeliveryofhumanservices.
AutomatedClearingHouse(ACH)isanelectronicnetworkforfinancialtransactionsintheUnitedStates.ACH processeslargevolumesofcreditanddebittransactionsinbatches.ACHcredittransfersincludedirectdeposit,payrollandvendorpayments.
‘AdvancedPlanningDocument(APD)andAdvancedPlanningDocumentUpdate
(APDU)aredocumentscreatedbyCFSAandsubmittedtoACFinordertoobtainapprovalforFederalfinancialparticipationinthecostofacquiringautomateddataprocessingequipmentandservices.ThisCCWISfinalruleforreplacingexistingChildWelfareinformationsystemsreducesthesubmissionrequirementsforlower-riskinformationtechnology(IT)projectsandprocurementsandincreasesoversightoverhigher-riskITprojectsandprocurementsbymakingtechnicalchanges,conforming
changesandsubstantiverevisionsinthedocumentationrequiredtobesubmittedbyStates,counties,andterritoriesforapprovaloftheirInformationTechnologyplansandacquisitiondocuments.
AnotherPlannedPermanentLivingArrangement(APPLA),alsoknownasOtherPlannedPermanentLivingArrangement(OPPLA),iswherethechildwelfareagencymaintainscareandcustodyoftheyouthandarrangesalivingsituationinwhichtheyouthisexpectedtoremainuntiladulthood.APPLAorOPPLAisapermanencyoptiononlywhenotheroptionssuchasreunification,relativeplacement,adoption,or
legalguardianshiphavebeenruledout.
DC ChildandFamilyServicesAdministration(CFSA)isthepublicchildwelfareagencyintheDistrictofColumbiaresponsibleforprotectingchildvictimsandthoseatriskofabuseandneglectandassistingtheirfamilies.
ChildInformationSystemsAdministration(CISA)isadivisionwithinCFSAthatisresponsibleforalltechnologyassetsfortheAgency.
ChildWelfareContributingAgency(CWCA)is“apublicorprivateentitythat,bycontractoragreementwiththetitleIV-Eagency,provideschildabuseandneglectinvestigations,placements,orchildwelfarecasemanagement(oranycombinationofthese)tochildrenandfamilies.
Commercial-Off-The-Shelf(COTS)isanadjectivethatdescribessoftwareorhardwareproductsthatareready-madeandavailableforsaletothegeneralpublic.
ComprehensiveChildWelfareInformationSystem(CCWIS)isacasemanagementinformationsystemthatstateandtribaltitleIV-Eagenciesmaydeveloptosupporttheirchildwelfareprogramneeds.IfatitleIV-EagencyelectstobuildaCCWIS,thefederalgovernmentwillprovideamorefavorable
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page11of69
C3111
C3112
C3.1.13

C3115
C3.1.16
C3.1.17
C3.1.18
reimbursementthanisprovidedfornon-CCWISaslongasthesystemmeetsfederalrequirementsandisdesignedtosupportsocialworkers’needsto
organizeandrecordqualitycaseinformationaboutthechildrenandfamiliesreceivingchildwelfareservices.
ChildProtectiveServices(CPS)isadivisionofCFSAthatinvestigatesreportsofeglectandabuse.
Districtof Columbia (District,DC) referstotheGovernmentofthe Districtof Columbia.
FamilyEducationalRightsandPrivacyActof1974(FEPRA)isthefederallawthatprotectstheprivacyofstudenteducationrecords.Thelawappliestoallschoolsthat
receivefundsunderanapplicableprogramoftheU.S.DepartmentofEducation.FEPRAregulationsapplytoeducationalrecordsobtainedfromtheStateEducationAgencyforthepurposeofsupportingafamilyandchildinthecareofCFSA,aswellasforde-identifieddatausedforlongitudinalanalysis.
FinancialManagementSystem(FMS)-issoftwarethatanorganizationusestooverseeandgovernitsincome,expenses,andassetswiththeobjectivesofmaximizing
profitsandensuringsustainability.FortheDC Government,thesoftwareisDistrictIntegratedFinancialSystemDistrict(DIFS).
TheHealthInsurancePortabilityandAccountabilityActof1996(HIPAA)isthefederalregulationthatprotectshealthinsurancecoverageforworkersandtheirfamilies
whentheychangeorlosetheirjobs.TitleIIofHIPAA,knownastheAdministrativeSimplification(AS)provisions,requirestheestablishmentofnationalstandardsforelectronichealthcaretransactionsandnationalidentifiersforproviders,healthinsuranceplans,andemployers.TheAdministrativeSimplificationprovisionsalsoaddressthesecurityandprivacyofhealthdata.Thestandardsaremeanttoimprovethe
efficiencyandeffectivenessofthenation'shealthcaresystembyencouragingthewidespreaduseofelectronicdatainterchangeintheU.S.healthcaresystem.
IndividualswithDisabilitiesEducationAct(IDEA)isthefederallawthatmakesavailableafreeappropriatepubliceducationtoeligiblechildrenwithdisabilities
throughoutthenationandensuresspecialeducationandrelatedservicestothosechildren.TheIDEAgovernshowstatesandpublicagenciesprovideearlyintervention,specialeducation,andrelatedservicestomorethan6.5millioneligibleinfants,toddlers,children,andyouthwithdisabilities.
InterstateCompactonthePlacementofChildren(ICPC)isacontractamongall50U.S.states,theDistrictofColumbiaandtheVirginIslandsprovidingforprotectionandsupportservicesforchildrenmovedbetweenU.S.statesforbirthparentunificationorreunificationwhenthecourthasjurisdictionoverthechild.TheICPCensuresthatthe
sendingagencyorindividualdoesnotlosejurisdictionoverthechildoncethechildmovestothereceivingstate.AnICPCcaseisclosedwhena childisadopted,reachestheageofmajority,orbecomesself-supportingorwhentheappropriateauthoritiesinthesendingstateandreceivingstateagreethattheICPCcasecanbeclosed.
NationalInstituteofStandardsandTechnology(NIST)isameasurementstandardslaboratory,andanon-regulatoryagencyoftheUnitedStatesDepartmentofCommerce.Itsmissionistopromoteinnovationandindustrialcompetitiveness.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page12of69
C3.1.19
C3.1.20
C3.1.21
3.1.22
3.1.23,
C3.1.24
C3.1.25
3.1.26
C3.1.27
C3.1.28
3.1.29
C3.1.30
Withinthecontextofthisdocument,NISTsetssecuritystandardsforpublictechnologyprojects.
Online ServicesistheMicrosoft-hostedservicesidentifiedas Online Servicesin
MicrosoftProductTerms. Online Servicesarenotofferedunder thescope of this
Contract.
PersonallyIdentifiableInformation(PII)isdefinedasanyinformationthatcanbeusedonitsownorwithotherinformationtoidentify,contact,orlocateasingleperson,ortoidentifyanindividualincontext.
ProductisallproductsidentifiedintheProductTerms, such as allSoftware,Online
Servicesand otherweb-based services,includingpre-releaseor betaversions.
ProductTerms isthedocumentthatprovidesinformationaboutMicrosoftProducts.The
ProductTerms document ispublishedon theVolume LicensingSiteand isupdatedfrom
time totime.
ProductOwnerAdvisoryCommittee(POAC)isagroupofCFSAstaffidentifiedtoact
asproductownersforCCWISmodulesidentifiedinthisdocument.Mostmoduleshavemorethanoneproductowner.ThePOACispartoftheCCWISgovernancestructuretominimizerisksandelevateissuestoSteeringCommitteeandagencyexecutiveleadership.
ProjectManagementOffice(PMO)isagroupordepartmentwithinabusiness,agencyorenterprisethatdefinesandmaintainsstandardsforprojectmanagementwithintheorganization.ThePMOstrivestostandardizeandintroduceeconomiesofrepetitionintheexecutionofprojects.
Response Time isthe periodof time between notificationof an issueand when the
vendorrespondstoresolvetheissue.
ResolutionTimeistheamountoftimebetweenthevendorstartingworkontheissueandactuallyresolvingtheissue.
ServiceLevelAgreement(SLA)isacommitmentbetweenaserviceproviderandaclient.Particularaspectsoftheservice—quality,availability,andresponsibilities—areagreedbetweentheserviceproviderandtheserviceuser.
ServiceOrientedArchitecture(SOA)isasoftwaredesignandsoftwarearchitecturedesignpatternbasedonstructuredcollectionsofdiscretesoftwaremodules,knownasservices,thatcollectivelyprovidethecompletefunctionalityofa largesoftwareapplication.
Software”meanslicensedcopiesofMicrosoftsoftwareidentifiedontheProductTerms.SoftwaredoesnotincludeOnlineServicesorServicesDeliverables,butSoftwaremaybepartofanOnlineService.
StatewideorTribalAutomatedChildWelfareInformationSystem(S/TACWIS)isthecommonnameforfederallylegislatedinformationsystemsstatesdevelopedandimplementedtosupportchildwelfareactivities.Thesoftware’srequirementsareoutlineinlegislationofthesamenamethatrequiredanddefinedalargefunction-based
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page13of69
C3131
3.1.32
3.1.33
3.1.34
C3.1.35
C3.1.36
3.1.37
C3.1.38
C3.1.39
applicationthatallsocialworkers would use totrackand manage theirchildwelfare
caseloads.
‘SubjectMatterExperts(SMEs)isapersonwhoisanauthorityinaparticularareaortopic.
‘SupplementalNutritionAssistanceProgram(SNAP)providesfinancialassistancefor
purchasingfoodtolow-andno-incomepeoplelivingintheU.S.Itisafederalaidprogram,administeredbytheU.S.DepartmentofAgriculture,thoughbenefitsaredistributedbyindividualU.S.states.
SupervisorySocialWorker(SSW)overseesateamofsocialworkerswithinCSFAand
monitorsservicedeliveryforstaffcompliancewithstatutoryguidelines,regulationsandCFSApoliciesandprocedures.
‘SystemofCare(SOC)isatermforaspectrumofeffective,community-basedservicesandsupportsforchildrenandyouthwithoratriskformentalhealthorotherchallengesandtheirfamilies,thatisorganizedintoacoordinatednetwork,buildsmeaningfulpartnershipswithfamiliesandyouth,andaddresstheirculturalandlinguisticneeds,inordertohelpthemtofunctionbetterathome,inschool,inthecommunity,andthroughoutlife.
‘TemporaryAssistanceforNeedyFamilies(TANF)Programhelpsmoverecipientsintoworkandturnwelfareintoaprogramoftemporaryassistance.IndividualsreceivingassistancethroughTANFarecategoricallyeligibletoreceivepaidmealservices.
TitleIV-BistheFederalWelfareProgramTitleIV-Bthatgovernstheprovisionofchild
welfareservicesthatcanbeusedforpreventionofandresponsetochildabuseandneglect.Protectandpromotethewelfareofallchildren.Itdoessobyfundingservicesandprogramswhich:
a. Preventtheneglect,abuse,orexploitationofchildren;b. Supportat-riskfamiliesthroughserviceswhichallowchildren,whereappropriate,toremainwiththeirfamiliesorreturntotheirfamiliesinatimelymanner;
©. Promotethenationalgoalsofsafety,permanenceandwell-beingofchildreninfostercareandadoptivefamilies;a Providetraining,professionaldevelopmentandsupporttoensureawell-qualifiedworkforce;ande. Promoteandsupportadoption.
TitleIV-E-TheFederalFosterCareProgramhelpstoprovidesafeandstableout-of-
homecareforchildrenuntilthechildrenaresafelyreturnedhome,placedpermanentlywithadoptivefamilies,orplacedinotherplannedarrangementsforpermanency.Nameisreferencetothefederalcodesectionthatauthorizesit.
UseRightsrefersto,withrespecttoanyProductlicensingprogram,theuserightsortermsofserviceforeachProductpublishedontheVolumeLicensingSiteandupdatedfromtimetotime.TheUseRightssupersedethetermsofanyenduserlicenseagreementthataccompaniesaProduct.TheUseRightsforSoftwarearepublishedbyMicrosoftintheProductTerms.TheUseRightsforOnlineServicesarepublishedintheOnlineServicesTerms.
VolumeLicensingSitemeanshttp://wwwmicrosoft.com/licensing/contractsora‘successorsite.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page14of69
C4. BACKGROUND
CAL Mission
C441 CFSAistheDistrictofColumbia’spublicchildwelfareagencyresponsibleforinvestigatingchildabuseandneglectandprovidingservicestochildandyouthvictimsandthoseatriskofabuseandneglectandtheirfamiliesintheDistrict.CFSA’sprimary
missionistoimprovethesafety,permanence,andwell-beingofabusedandneglectedchildren/youthandtohelpstrengthentheirfamilies.CFSAbelieveschildrenthrivewithinfamilysettingsandwithcontinuityandsupportinthemostnormalizingenvironmentpossible.
C412 CFSAisfirmlycommittedtochildren,youthandfamiliesreceivingthehighestquality
servicesandsupportnomatterwheretheyareplaced.Asaresult,theDistrictisnowseekingaContractorthatwillberequiredtoprovideservicestopregnantandparentingyouthandtheirchild(ren)servedbytheDistrict’sfostercaresystemregardlessoftheirassessedlevelofneed.ThegoalisthatthroughoneContractortheDistrictwill
accomplishmoreconsistentpractice,standardizationofprocessandbetterpermanencyoutcomesforchildrenandtheirfamilies.
C413 OnJune2,2016,AdministrationforChildrenandFamilies(ACF)publishedafinalrule
fortheComprehensiveChildWelfareInformationSystems(CCWIS)(seeC.2.1Item3).TherulewasdesignedtoallowstateadministrationstoupgradetheirStatewideorTribalAutomatedChildWelfareInformationSystem(S/TACWIS),asoriginallymandatedin

1993.
CA2 Four PillarsStrategicFramework
C421 In 2012 CFSA developeda strategicframework —the “Four Pillars”— and CFSA’s work
isgroundedinthisvalues-basedfoundationtosupportstrategiesthatachievespecific
outcomes.The Four Pillarsinclude:
1. Front Door: Children/youth deserve to grow up with theirfamiliesand
should be removed from theirbirthhomes only as the lastresort.Child
welfare getsinvolved only when familiescannot or willnot take careof
children/youththemselves.Whenwemustremoveachild/youthforsafety,weseektoplacewithrelativesfirst.
2.TemporarySafeHaven:Fostercareisanecessaryinterimplaceforchildren/youthtolivewhileweworktogetthembacktoapermanent
homeasquicklyaspossible.Planningforasafeexitbeginsassoonasachild/youthentersthesystem.Ifarelativecaregivercannotbeidentifiedimmediately,continuedexplorationandengagementofkintakesplacethroughoutthechild’s/youth’sexperienceinfostercare.
3.WellBeing:Everychild/youthhasarighttoanurturingenvironmentthatsupportshealthygrowthanddevelopment,goodphysicalandmental
health,andacademicachievement.Institutionsdonotmakegoodparents,butwhenwemustbringchildren/youthintocarefortheirsafety,wegivethemexcellentsupport.
4,ExittoPermanence:Everychild/youthexitsfostercareasquicklyas
DCRL-2023-F-0071 Comprehensive ChildWelfareInformationSystem (CCWIS) Page 15 of 69
possibletoasafe,well-supportedfamilyenvironmentorlife-longconnection.Olderyouthhavetheskillstheyneedtosucceedasadults.
C43 Core Values
a.Allchildrenandyouthhavetherighttobesafe.b.Familieshavetherighttobeunderstood,valued,encouraged,andempowered.Familiesalwayshaveavoiceindecisionsthataffectthem.
c.Communitypartnershipsareessentialtokeepingchildrenandyouthsafe.d.Childwelfarepracticeandservicesdrawuseastrengths-basedapproachtohelpchildren,youth,andfamiliesachievepositiveoutcomes.e.Childrenandyouthdeservenormalizedopportunitiestogrow,develop,bephysicallyandmentallyhealthy,learn,andprepareforsuccessful
adulthood.f Childrenandyouthhaveanurgentneedtoachievepermanenceasquicklyaspossiblewithafamilythatlovesthemunconditionally.g.Children,youth,andfamiliesdeserveunderstandingandrespectwithinthecontextoftheirhistory,traditions,andculture.
h.BestpracticesandcontinuousqualityimprovementthroughoutthechildwelfaresystemsupportmakingapositivedifferenceinthelivesofthoseCFSAserves.
i,Firstplacementisthebestplacement,withapreferenceforkin,andplacementwithsiblings.j.Keepsiblingstogetherandpreservetiestofamily,schoolandcommunity.k.Youthandfamilyvoicesarecriticalcomponentsintheircaseplanning.
C44 PhilosophicalStatementonPermanency
CAA.1 CFSAbelievesthatchildrenthrivewhenraisedintheirfamilyoforigin.We separatechildrenfromtheirparentsonlywhentherearenoothersupportsthatmightallowthe
childtoremainsafelyinthehome.Ifwehavetoremovea child,welookforkinshipsupportsfirsttokeepthechildwithintheextendedfamily.Whenthoseoptionsarenotavailable,weensurethatchildrenareplacedinsafe,nurturingfosterhomes.We believethateverychilddeservestogrowupinasafeandstableenvironmentwithloving,caringadults.Ifachildcannotbereunifiedwiththeirbirthfamily,itisourresponsibilitytofind
apermanent,caringhomeforthemthroughadoptionorguardianship.
C45 ‘Trauma-InformedPractice
CAS. CFSAworksfromthepremisethatallchildrenandyouthinout-of-homecarehaveexperienced,ataminimum,thetraumaofseparationfromfamilyandcommunity.CFSA
hasadoptedTraumaSystemsTherapy(TST)asacorecomponentofitspracticeinordertobuildatrauma-informedsystem.
C46 ServicePartnerships
C4641 CFSAisthelocalchildwelfareagency,notthechildwelfaresystem.CFSAhassignificantrelationshipsandservicedeliverypartnershipswithotherDistrictHealthandHumanServiceAgenciestoprovideservicesinsupportofstrengtheningfamiliesandprotectingchildrenandyouth.
CAT GeographicLandscape
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page16of69
CATA
C472
C48

C113
C114
C1LS
C116
C117
C118
C119
TheDistrictofColumbiaisanurbanjurisdictioncomprisedofeightwardswithin68.3squaremilesandofa populationofover700,000residents.
TheDC OfficeofPlanningandDC KidsCounthavemoreinformationabouttheDistrict’swardsandneighborhoodsathttps://planning.dc.gov/page/wards-district-columbiaandhttps://www.deactionforchildren.org/our-issues/de-kids-count/2015-ward-
snapshots.
SystemFunctions
The Districthasdevelopedbusinessprocesses,providedinAttachmentJ.15thatlayout
thecorebusinessfunctionsof CFSA. The system functionsfortheCCWIS areincluded
asAttachment J.17and J.18 tothiscontract.Highlightsof thesystem functionsinclude:
TheIntakeofcalltotheCFSAHotlineandroutingtoappropriateresponseunits;
DocumentationoftheInvestigation,familyassessment,andREDteamdeterminationprocesses,bothintheofficeandinthefield,whichincludetheincident(s),contactorinterviewswithsphereofinfluenceindividuals,determinationsandoutcomes,andprovidedservices.Additionally,themodulewillsupporttheChildProtectiveRegistrarfunctionality.
ComprehensiveCaseManagementtosupportintegratedviewsofcase,client,andfamilydata,workflowandevent-basedtoolsthatassistinthemanagementofindividualcases,andcross-functionalcasemanagementcapabilitiesacrosstheprovidedservices.
PermanencyandExit/Post-PermanencySupportmanagement,thatallowsCFSAandclientstomanagethecompletionofactivitiesthatresultinapermanenthomeplacementthroughreunification,adoption,orotherexitpathways,accesstoclosedclientrecordstoprovidetemporaryservicestoavoidanynewdisruptions,andlongitudinaldataanalysisacrossCFSAandDistrictdatasources.
Providerrecruitment,licensing,trainingmonitoring,thecaptureofplacementmatchingdatapointstofacilitatestrategicplacementandmonitoringofactiveprovidersacrossthechildwelfarespectrum.FinancialManagementprocessesthatinformsand/orintegratewiththeDistrict’s
EnterprisePurchasingand/orFinancialManagementSystems.Processesincludeeligibilitydeterminations,claimsprocessing,paymentmanagement,accounting,andcontractsandgrantsmanagement.
Cross-functionalEventsManagement,whichcreatesacentralrepositoryofinterviews,meetings,assessments,hearings,andothereventsacrossallworkflows,providesstreamlinedfunctionalityforschedulingandcalendaringfunctions,andprovidescentralviewsofeventsforspecificuser,case,family,courtheadings,and/orotherusergroupsandroles.
ComprehensiveAssessmentManagement,whichprovidesstreamlinedtoolsetformanagingandadministeringvariousassessmentsthatmayberequiredforaspecificclientorcase,allowsprogramstafftoadministereachassessment,andintegratewithclient,case,andfamilyviewsacrossallassessments.
QualityassurancepersonneltoMonitor,reviewandformallyAuditvarioussetsofdataanddocumentsthroughthesystem,includingbutnotlimitedtocaseandserviceplans,
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page17of69

CALI
C1112

C5.
C51
C52
C521
C5.2.2
servicerecords,clientdocumentation,providerrecords,financialrecords,andinvestigationdocuments.
Developorintegratewitha3rdpartysolutionforlearningmanagementandtrainingmonitoring.CFSAenvisionsthatsolutionwillgeneratetrainingmonitoringandcompliancereports,tietrainingcompletiondatabothworkflowprocessesanduser
authorizationandprovidedatatosupportannualrenewalandstafftrainingrequirements.
TheautomatedsubmissionofReportsbycreatingandpublishingtherequireddata
reports,managingtheworkflowtoreview,approval,andsubmitthedata,andintegrating
toreportingsystems.
CFSAenvisionsasolutionthatwillaligntoCFSA’suniquebusinessneedsinthemostcost-effectivestrategyavailable.CFSAmayconsideratransfersystemfromanotherstategovernment,aslongasthesolutioncanbecustomizedforCFSAspecificprocessesand
canbeupdatedviaconfigurationratherthancustomdevelopment.
TheContractor’ssolutionsshallprovideuserswithasinglelook-and-feelthatwillbeestablishedthroughCCWIScoresoftware.TheSystemshallintegrateintoCFSA’spublicfacingcontentmanagementsystem,Drupal,forpublishingcontent,forms,reports,and/orevents,asdeterminedbytheCFSACIO.Publicandinternallyfacingsystem
pagesandmobileapplicationsmayleverageauniquelook-and-feel,asapprovedbytheagencyCIOand/orotherCFSAexecutivestaff.Additionally,thesoftwareshallnotrequirethedisplayofprivatecompanylogos,branding,orotheridentifiableinformation.TheContractorshallbeabletorenderitssolutionstosupportauniformpresentationlayer.
CONTRACT REQUIREMENTS
The Contractorshallprovidetheservicesdefinedbelow and referencedsectionC.
Solution Overview
AspartoftheCCWISModernizationinitiative,DCCFSAaimstoreplaceitslegacychildwelfaresolutioncalledFACES,whichisacustom.NETapplicationwithSaaSbasedimplementationthatisCCWIScompliantandachievesagency’sbusinessoutcomes.
As-ls:AspartoftheR1andR2phasesoftheSTAANDproject,featureshavebeenimplementedontopofDynamics365andMicrosoft’sbaselinechildwelfaresolution(cws).
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page18of69
5.2.3

C524
C525
C53
C6.

To-Be:Development/testteamswilloperateinparalleltoincreasevelocity(e.g.,Intake,Investigations,CaseManagement,Eligibility,andFinance).

‘STAANDModules
Ea ™~ —_
[seweerJfbanaonse||eevee J[eonpce|| nerning|
[ we ]

TheFollowingrepresentsthesolutioncomponentsthatwillserveasareferencefordesignandbuildactivitiesforthisprojectphase.
SummaryofObjectivesThissectionoutlinestheworkandactivitiesrequiredtoaccomplishthegoalsset
forthinthisprojectinsectionC.1.2ofthiscontract.
ThisisaTimeandMaterialsstatementofwork.UnderthedirectionofjointMCS-CFSAProgramManagementOffice,ifCFSAisnotabletomeetanyoftheirresponsibilitiesandrequirementslistedinthisSOWwithinthetimeframesrequested,re-prioritizationofthebacklogmaybeneededtocompletetheobjectivesasdescribed,inthechangemanagementprocessSectionC.6.8.
‘Thisapproachdoesnotguaranteethatallobjectivesdefinedinthiscontractwillbecompletedwithinthecapacityanddurationassigned.ShouldCFSAdecidetocontinue
workafterengagementcompletiondescribed,CFSAmaymakeachangerequest,asdescribedinchangemanagementprocessdescribedinchangemanagementprocessSectionC.6.8.
ServiceRequirements
ThefollowingsectionsdescribetheservicestobeperformedbytheContractorastheydesign,configureand/orbuild,test,anddeploytheCCWISinaniterativeandincrementalmanner.TheactivitiesdescribedbelowaligntotheCLINSinSectionB3.3.
PROJECTMANAGEMENT
TheprojectwillbemanagedbyMicrosoftprogramand/orprojectmanager(s),whowillworkwiththeCFSAprojectmanager.TheMicrosoftprogramand/orprojectmanager(s)willberesponsiblefortheoveralldeliveryofMicrosoftasspecifiedin
DCRL-2023-F-0071 Comprehensive ChildWelfareInformationSystem (CCWIS) Page 19 of 69
thefollowingtable.Theprojectmanager(s)willreporttotheprojectmanagementofficeorthesteeringcommittee,whichwillconsistoftheCFSAsponsors,theCFSA
programmanager,Microsoftprogrammanager,andtheMicrosoftdeliveryleader.
IfconcernsareraisedtoMicrosoftaroundresourcesperformanceorproductivity,
concernswillbeaddressedwithin3businessdayswithgo-forwardactionplan.
IfMicrosoftvoluntarilyreassignsateammembertoanotherprojectorviaa
reductioninforcereleasesateammember,Microsoftwillcover2weeksofnon-billabletransitiontimetorampupthenewresource.IfateammembertakesanewroleorleavesMicrosoft,thetransitiontimewillbebillabletoCFSA.
Thegovernancestructuresandprocessestheteamwilladheretofortheprojectaredescribed in the following sections.
COL Sprintceremonies
rtd ay a ae ra
Dailystandups © Updateonstatus. Daily 15minutesProjectteam
© Flagimpedimentstoget members
helpresolvingthem.
SprintplanningPlantheworkforthesprintOnceper 4-6hours Productowner
aheadbyassigninguser_ sprint * Scrummasterstoriesandtaskstothe © Project
Sprintandconfirmingthe manager
orderofpriority(sizeand © Productdifficulty)andformally Manager
committotheSprintplan. © Architect
* Functionallead
* Technicallead
© Testinglead
© SMEs(as
needed)
Backlog Develophigh-valueuser. Onceperweek 1hour * Productowner
refinement storiesforclaritywiththe orasneeded © Scrum master
teamtopreparethemforthe basedonthe © Project
upcomingsprintsandto _sizeofthe manager
improveestimates. backlog © Product
Manager
e Architect
Functionallead
* Technicallead
© Testinglead
© SMEs(as
needed)

C62
C63
Page20of69
Sprintdemo © DemonstratethefeaturesOnce per 1-2hours Projectcoreteam
Sprint
builtforacceptance.sprint andstakeholders© Comparethecompletedfeatureswiththegoalsofthesprintandevaluatethesuccessofthesprintonthatbasis.© Receivefeedbackfrom
stakeholders.
Reviewtheprogressand Onceper 2hours Projectcoreteamretrospectivesuccessoftheteamduringsprintthesprintandselect1-3areasforimprovementforthenextsprint.
MetricsDuringtheSprintphaseofthisproject,wewillusethefollowingmetriestotrackprogressovertimefortheReleaseandSprints.
© ReleaseBurn-upchart
© SprintBurn-downchart
© ADO dashboards
© Backlogreadiness
© SprintprogressbyStages
© Defectdensity(numberofdefectsfoundperunitofcodeorfunctionality)
co Testsuccessrate(percentageof Testcasespassed)
© Scheduleadherence(comparisonofactualvs.plannedmilestones)
© DataMigrationMetrics
© DataMapping/transformationProgress/completionmetrics
© DatacleansingProgress/completionmetrics
© On-track/overdueareasperModules/businessarea
© Bottleneck/errorcategories
© SecurityMetrics
© ProactiveInfosec/TQAscanandmitigationresults© OCTO/Third-partySecurityAssessment/findingsresolution
ArchitectureReviewBoard(ARB)
Technicalgovernanceandsolutionoversightfortheprojectwillbe providedby an
architecturereviewboard,whichwillconsistofthefollowingkeytechnical

ProgramManager CFSA
DCRL-2023-F-0071Co1 sive
C64

WeeklyTimesheet
C65

‘WelfareInformationSystem(CCWIS) Page21of69

OCMLead CFSA
DatabaseLead CFSA
ProgramManager Microsoft
DeliveryArchitect Microsoft
TechnicalLead Microsoft
Thearchitecturereviewboardwillholdweeklymeetingsandproduceminutesforallmeetings.TheCFSAandMicrosoftmanagerswillsharejointresponsibilityfor‘managementandtrackingofarchitecturalchanges,issues,risks,anddecisions.
The architectureboardisresponsibleforthefollowing:
Conductingmeetingsinordertoreviewandaddressarchitecturaldecisions.This
includesimplicationsandpossibleimpactsofdecisionsandanyresultingchangesto
thesolutionorprojectpl
Providingsolutionanddirectionoversight.Thisincludesmanagingproblemsandrisks
escalatedbythesolutionworkstreams,including:
Infrastructuredecisions(design,sizing,availability,andconfiguration)
Datamigration,interfaces,reporting,andsecuritydesign
Technicalsolutionarchitecture(components,mapping,andintegration)
Functionalsolutiondesign(fits,customizations,andISVs)
Designstandards,technicaldocumentationstandards,andprogrammingstandards
Facilitatingcross-workstreamcollaborationamongtechnicalstakeholdersandserving
asasingleplatformthroughwhichkeytechnicaldiscussionsareaddressed.

WeeklyTimesheet
Duringtheproject,theMicrosoftprojectmanagerwillcompilethepreviousweek’stimecardsforeachteammemberintoaweeklyExcelfileforCFSA’sreviewand
rete
erie
«The weeklyExceltimecardtemplatewillincludea © Yes
descriptionofworkcompletedeachdayincludinganyADOuserstoryandtasknumbersworkedonfromtheprioritizedbacklog.

Projectcommunication
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page22of69
C6.6
Thefollowingwillbeusedtocommunicateduringtheproject.
© UserStoryandBusinessProcessClarifications:Ifthedevelopmentteamneeds
clarificationaboutauserstoryorbusinessprocess,theFunctionalleadwilldiscuss
withthePOandmutuallyagreeonatimeframetoresolveandanswerthequestion.
Ifthisbecomesariskorissuetocompletethedevelopment,aRAIDitemwillbe
openedperprocessbelow.
© Communicationplan:Thisdocumentwilldescribethefrequency,audience,and
contentofcommunicationwiththeteamandstakeholders.Itwillbedevelopedby
MicrosoftandCFSAaspartofprojectplanning.
© Statusreports:TheMicrosoftteamwillprepareandissueregularstatusreportsto
projectstakeholdersperthefrequencydefinedinthecommunicationplan.
«Statusmeetings:TheMicrosoftteamwillscheduleregularstatusmeetings,perthe
frequencydefinedinthecommunicationplan,toreviewtheoverallprojectstatus,
theacceptanceofdeliverables,andreviewopenissuesandrisks.
DecisionManagementProcess
Throughouttheproject,MicrosoftwillsubmitrequestsfordecisionsthattheCFSA.mustmake.Decisionsareassignedduedates,anditisassumedthatCFSAwillprovidetherequiredfeedbackormakedecisionseitherbytheagreed-uponduedateorwithinthreebusinessdaysofsubmittal.
SomedecisionsrequestedwillbedeterminedbyMicrosoftascriticalpathdecisionswithkeydependencies,andthesewillbesubmittedwithadecision(DR)request,asaRAIDlogiteminAzureDevOps.IftheDR isnotactedonbytheduedate,itmayaffecttheprojectcriticalpath,includingthetimeandeffortrequiredtocompletetheplannedobjectives.
Thefollowingprocessshallbefollowedwhenaformaldecisionrelatedtothemanagementanddeliveryoftheprojectisrequired:
* “DecisionRequest” refersto a formalrequest,viaADO RAID log item,fora decision
fromtheCFSArequiredbyMicrosofttohelpkeeptheProjectontrackandavoid
potentialrework or scheduledelays.
* A RAIDlogitem(Decision)shallbesubmittedbytheMicrosoftProjectManagerfor
requestingaformaldecisionfromtheCFSAProjectManager.TheDR shallincludea
descriptionofthedecisionrequested,therecommendation,andtheimpactofthe
tecommendation.
© The RAID logDecisionshallbe respondedtoby theCFSA with thedecisionreached
withinthree(3)consecutivebusinessdays(oragreeduponduedate).
IftheDR isnotrespondedtoandnotreturnedwithinthistimeframe,therecommendationincludedintheDR shallbetreatedasacceptedbytheCFSA,to
avoidapotentialCFSA-imposedprojectdelay.ItismutuallyunderstoodandagreedthatasubsequentfuturechangeintheMicrosoftrecommendationordecisionformallycommunicatedbytheCFSAmayhaveanimpactonthecostand/orscheduleoftheproject.Shouldthissituationarise,theimpactshallbehandledusing
aMicrosoft-initiatedChangeRequest.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page23of69
C6.7
C68
C69
RiskandIssueManagement
Thefollowinggeneralprocedurewillbeusedtomanageactiveprojectissuesand
risksduringtheproject.
© Identify:Identifyand document projectissuesand risks(potentialissuesthatcould
affecttheproject).
Analyzeandprioritize:Assessthepotentialimpactanddeterminethehighestpriority
risksandissuesthatwillbeactivelymanaged.
«Plan andschedule:Determinethestrategyformanagingpriorityrisksandissuesand
identifyaresourcewhocantakeresponsibilityformitigationandremediation.
© Track and report:Monitorandreportthestatusofrisksandissues.
«Escalate:Escalatetoprojectsponsorsthehigh-impactissuesandrisksthattheteamis
unabletoresolve.
© Control:Review theeffectivenessof riskand issuemanagement actions.
Activeissuesandriskswillberegularlymonitoredduringtheproject.
ChangeManagementProcess
Duringtheproject,eitherpartycanrequest,inwriting,additions,deletions,ormodificationstotheServicesdescribedinthisSOW (“change”).Approvedchangeswillbemanagedthroughcontractamendmentsandcouldleadtoadditionalcostsandscheduleimpacts.We shallhavenoobligationtocommenceworkinconnectionwith
anychangeuntilthedetailsofthechangeareagreeduponinacontractamendmentsignedbytheauthorizedsignatoriesfrombothparties.
Withinthreeconsecutivebusinessdaysofreceiptoftheproposedcontractamendment,youmusteitherindicateacceptanceoftheproposedchangebysigningtheamendmentoradviseusnottoperformthechange.Ifyouadviseusnottoperformthechange,wewillproceedwiththeoriginalagreed-uponServicesonly.Intheabsenceofyouracceptanceorrejectionwithinthepreviouslynotedtimeframe,wewillnotperformtheproposedchange.
Businessgovernance
Duringtheproject,theCFSAwillberequiredtodecidewhethertoacceptthe
customizationofout-of-the-boxsolutionfunctionalitytoaddressbusinessrequirements.Thiswillrequiredetailedunderstandingandevaluationofthebusinessneedthatdrivestherequestforcustomization,andofthecostandpossibleimpacttotheprojectifthecustomizationisaccepted.TheCFSAisresponsibleforevaluationandacceptanceofthecustomizationinsteadofotheralternativestomodifyingbusiness
processesorimplementingprocessworkarounds.Thebusinessgovernancestepsare:
TheMicrosoftprojectteamwillidentifytherequestforcustomizationandprovide
estimatesandalternativesintheformofprocessmodificationsorworkaroundsthatwill
makeuseofout-of-the-boxfunctionalitypossible.
TheCFSAbusinessprocesslead,oranalystwillperformabusinesscaseevaluationto
weighthepotentialbenefitsofthecustomizationagainstitscostandimpactontheproject
andwillevaluatethealternatives.
DCRL-2023-F-0071 Comprehensive ChildWelfareInformationSystem (CCWIS) Page 24 of 69
* TheCFSAwillpresentthiscustomizationtotheProductOwnerAdvisoryCommittee
(POAC)forreviewandinitialapproval.
© TheCFSAprojectsponsorwilldeterminewho,attheappropriateleveloftheCFSA.
organization,hastheauthoritytoapprovebusinesscasesandacceptthecustomizationat
thestartoftheproject.
* TheCFSAProductOwnerwillthenupdatetheReleasebacklogprioritizationand
correspondingFeatureandUserStories.
C.6.10 ExecutiveSteeringCommitteeTheexecutivesteeringcommitteeprovidesoverallseniormanagementoversightandstrategicdirectionfortheproject.
FundingandChangeManagement

BusinessAlignmentandDecisionMaking

‘racking,Planning,Controlling,Reporting SolutionManagement/DesignAuthority
ve hagoI ndete Agnentietin

‘Theoperatingcommitteewilltakerecommendationsfromtheprojectmanagementteamandarchitecturereviewboardtoalignwiththebusiness.Theagreeddecisionsfromthe
operatingcommitteewillbesenttotheexecutivesteeringcommitteeforapproval.
‘Theexecutivesteeringcommitteefortheprojectwillmeetperthefrequencydefinedinthecommunicationplanandwillincludetheroleslistedinthefollowingtable.Theresponsibilitiesforthecommitteeinclude:
* Makingdecisionsabouttheproject’sstrategicdirection.
* Servingasafinalarbiterofprojectissues.
* Approvingsignificantchangerequests.

Role
Projectsponsor CFSA
Projectmanager CFSA
Deliverymanagementexecutive Microsoft
ProgramManager Microsoft
Projectmanager Microsoft
DCRL-2023-F-0071 ee ChildWelfareInformation— aac: Page25of69
C611
C612
C.6.13
C614
ProductManager Microsoft
EscalationPath
TheMicrosoftprojectmanagerwillworkcloselywiththeCFSAprojectmanager,sponsor,andotherdesigneestomanageprojectissues,risks,andchangerequestsasdescribedpreviously.TheCFSAwillprovidereasonableaccesstothesponsororsponsorstoexpediteresolution.Thestandardescalationpathforreview,approval,ordisputeresolutionisasfollows:
Projectteammember(MicrosoftortheCFSA)
Projectmanager(MicrosoftandtheCFSA)
Microsoftdeliverymanagementexecutive
MicrosoftandtheCFSAprojectsponsor
Executivesteeringcommittee
CriticalPathDecisionsThroughouttheproject,MicrosoftwillsubmitrequestsfordecisionsthattheCFSAmust
make.Decisionsareassignedduedates,anditisassumedthattheCFSAwillprovidetherequiredfeedbackormakedecisionsbythemutuallyagreed-uponduedate.SomedecisionsrequestedwillbedeterminedbyMicrosoftascriticalpathdecisionswithkeydependencies,andthesewillbesubmittedwithawrittennoticeofdecision(NOD)request.IftheNOD requestisnotactedonbytheduedate,itmayaffecttheprojectcriticalpathand
willbeaddressedasaprojectchangerequestandsubmittedthroughthechangemanagementprocess.
ProjectCompletion
MicrosoftwillprovideServicesdefinedinthiscontracttotheextentofthefeesavailableand
theperiodofperformancespecifiedinthesectionB.3PriceSchedule.IfadditionalServices
arerequired,thechangemanagementprocesswillbefollowed,andthecontractmodified.
Theprojectwillbeconsideredcompletewhenatleastoneofthefollowingconditionshas
been met:
AllfeesavailablehavebeenutilizedforServicesdeliveredandexpensesincurred.
‘Theperiodofperformance(Term)oftheprojecthasexpired.
AllMicrosoftactivitiesandin-scopeitemshavebeencompleted.
Thecontracthasbeenterminated.
cee
ProjectOrganization
Theprojectwillbeorganizedasdepictedinthefollowingdiagram.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page26of69

DeliveryTeams SupportTeams
*ESC=Executivesteeringcommittee
C615 ProjectRolesandResponsibilities
Thekeyprojectandleadershiprolesandtheresponsibilitiesareasfollows.ThefollowingrolesandresponsibilitiesarebeingaddedinadditiontothosefoundinAttachmentJ3-ComprehensiveChildWelfareSystem(CCWIS)-Intake2.0.
Crag

CFSAprojectsponsor * Makekeyprojectdecisions,serveasapointof Part-time—escalation,andclearprojectroadblocks. 10%
CFSAprojectmanager _‘Serveastheprimarypointofcontactforthe Full-time
Microsoftteam.
‘©Manageandcoordinatetheoverallprojectto
deliveritaccordingtoschedule.
© TakeresponsibilityforCFSAresourceallocation,
riskmanagement,projectpriorities,and
communicationwithexecutivemanagement.
© Coordinatedecisionswithinthreebusinessdays,or
withinanotherwiseagreed-upontimeline.
© Supporttheproductownerandteam.
© Serveasliaisonbetweenproductownerandthe
teamtoclarifysolutionrequirementsanddeliverypriority.
© Actasthelinkbetweentheproductownerand
team,coachonhowtoachievethegoals,adapttochanges,andreprioritizethebacklog.
‘©Supportsprintplanningandreviewsandprovide
support/inputwhenneeded.Makesureblockersareresolvedbyinvolvingthe
appropriatepeopleandresourcesneeded.
DCRL-2023-F-0071Comp
Productowner
BusinessOwner
Technicalleador technical
manager
OCM lead
Businessprocessownerorbusinessanalyst
Page27of69
peereeins ParnesCrag
© Providetheestimatedprojectcommitment: UptoFull-
© Manageandprioritizetheproductbacklog. time
© Serveastheprimarypersonresponsibleforuser
storyscopedecisionsduringsprintplanning.
© Defineacceptancecriteriaforworkitems,
especiallyuserstories.
© Activelyparticipateinallsprintreviews.
* Serveasthesinglepointofcontactfordecisions
aboutproductbacklogitemsandprioritization.
© Makedecisionsregardingsolutionprocesses,
customizations,andworkarounds.
* Serveasaliaisontothebroaderteamandtake
responsibilityforstreamliningandstandardizing
processes.
* SupporttestingandprovideappropriateCFSA
resourcesacrosssprintsfortesting.
© Prepareandexecutetheend-to-endandfeature
demosbackthebusinesssothatbusinessowner
understandshowthebusinessprocesswas
implementedinSTAAND
© Approvethebusinessprocessflow Part-time—up
© Resolveescalationsandquestionsaboutbusiness_t010%process
© Approvebusinessprocesschangestominimize
needforcustomizations
© Attendthefeatureandend-to-enddemostoverify
STAANDsolutionenablesbusinessprocess
© Serveasprimarytechnicalpointofcontactforthe Full-time
team,
© Reviewprojectmatricesandescalateperformance
issues

© TakeresponsibilityforOCM,includingstrategyPart-time—
andplanning,leadershipengagement,user
communicationsandtraining,andadoption
measurement,

implementation
© Provideadvicetotheprojectteam relatedto Full-time
technicalprocesses,workflows,andrequirements.
DCRL-2023-F-0071Comp Page28of69
Perens ParrCry
* Workwiththebusinessleadtocoordinatewiththe
broaderteamandtakeresponsibilityfor
streamliningandstandardizingprocesses.
© Partnerwiththedatamigrationdeveloperor
analysttoassistwithdatamigrationandcoordinate
testingandvalidation.
© Developtestscriptsandscenariosandperform
tests.
SubjectMatterExpert © Advise theprojectteam on businessprocesses, Part-time—
(SME) workflows,andrequirements. 25% (maybe
© Developtestscriptsandscenariosandperform full-timefortesting. complexprocesses)
ScrumMaster © FacilitateScrumevents,includingdailystand-ups,Fulltime
sprintplanning,sprintreview,andretrospective.
© GuidetheteaminimplementingCCWIS
(ComprehensiveChildWelfareInformation
System)requirementsandbestpractices.
© Collaboratewithstakeholderstogatherand
prioritizeCCWISuserstoriesandbacklogitems
* AdvocateforcontinuousimprovementinCCWIS
implementationprocesses,identifyingareasfor
optimizationandsuggestingadaptations
C.6.15.2 Microsoft rolesand responsibilities
The coreskillsetand yearsof experiencerequiredfortheContractorroleslistedinthetablebelow
areincludedinAttachment J.14ofthis contract.
ney

MicrosoftprojectsponsorMakedecisionsabouttheengagementstrategicdirection.Serveasapointofescalationtosupportclearingengagementroadblocks.
Deliverymanagement © LeadstheexecutivesteeringcommitteewithMicrosoftprogram
executive manager.
Programmanager © Servesastheprimarypointofcontactandtakesaccountabilityfor
servicedelivery.
© Servesasthepointofcontactforcontractextensions,personnel
matters,andbilling.
* AlignMicrosoft-recommendedprojectandengagementpractices
acrossMicrosoftDynamicsengagements.

Functionalconsultantsor
functionalleads
Releasemanager
Technicallead
Developmentlead
Developers
Page29of69
Monitorprojectmatrices,resolvebottlenecksandresource
performanceissues.Regularprogressreportstoincludemetricsand
analysisofprojectperformanceagainstthedefinedKPIs.
Facilitateperiodicprojectreviewsandmeetingstodiscuss
performance,addressconcerns,andensurecontinuousimprovement.
CommunicatewithandadviseMicrosoftandCFSAexecutive
leadershipregardingprojectrisksandmitigations,developdelivery
strategies,andfacilitatecollaborationandcommunicationbetween
executivestakeholders.
Managetheescalationprocessandinteractwiththestakeholderswho
willhaveresponsibilityfortheoverallprogram.
Validatethattheprojecthasbeenfulfilledwithinestablished
standardsacrossbothpartnerandMicrosoftresources.
EstablishandsendagendaformeetingswithPOandSMEsin
advanceofmeetings
ScheduletimewithCFSA teammembers 1week inadvancewhen
applicable
ParticipateintheimplementationfromanalyzingtheCFSA’s
businessrequirementstoconfiguringtheMicrosoftDynamics365
application.
AssisttheCFSAwiththeplanningandimplementationofthetest
strategy,includingintegrationtests,datamigrationtests,user
acceptancetests,trainingmaterial,anddeliveryofcoreteamtraining.
Trackandcontrolsolutioncodeversionsthroughthetestand
productionenvironments.
Planandperformsolutionandcustomizationcodechanges.
Prioritizeconfigurationovercustomcode
CoordinatetheassignmentofMicrosofttechnicalconsultants.
Takeresponsibilityfortheoverallqualityoftechnicalactivities.
MonitorsolutionforcustomizationsandescalatetoARBandPOAC
fordiscussion.
Takeresponsibilityfortechnicalarchitectureandcodedeliverables.
‘Analyzetimetakenforeachdevelopmentphase
CoordinateCFSA,projectteam,andoffshoredevelopmentresources.
Takeresponsibilityforoveralldevelopmentquality,processes,and
tracking.
Coordinatewiththereleasemanagerandotherrolesonworkstream
tasksanddependencies.
Evaluateworkcompletedforqualityandefficiencyofcode
Write and unit-testcoded customizations.

Testlead
Testconsultants
ConsultingProductManager
BusinessAnalyst
SolutionArchitect
Data Lead
DataConsultant
ReportsLeadorReportDeveloper
Page30of69
Designandconfiguredataintegrationswithexternalsystems
CollaboratewithCFSAtodefinetheteststrategy.
CollaboratewithCFSAtestleadtoidentifytestscenarios.
ManageMicrosofttestteamactivities.
Conducttesting.
Buildtestscripts.
Conducttesting.
SetupandguidetheProductCouncilineffectiveprioritizationof
businessoutcomesandtradeoffs
CoachProductOwnersinAgileandbacklogprioritization
TransitionProductCounciltoLeadProductOwner
Providesknowledgetransferofthefunctionalityofsolutionfor
productandbusinessownersaswellasthetesting& trainingteam
AssistsPOindevelopmentanddocumentationofbusinessprocess
flows
AssistsPOinupdatinganddocumentationinADO
Providesarchitecturereviewanddirectionforthesolution
Reviewescalationsondesignreview
Overseesinfosecandqualityreviews
ResearchesandresolvesARBissues
ProvidesystemarchitecturedocumentationintheWiki.
DeveloptheConceptual,Logical,andPhysicalDatamodel
PromoteMasterDataManagementframeworktoincludeprocesses
andtoolsfordevelopingandmaintainingGoldensourceRecord,
analytical& reportingneeds
ImplementDataqualitycontrolsandprocessestomaintainData
Security,integrity,cleanliness,andscorecard
Documentthedatamodelandthedatadictionary
WorkswithCFSAdataengineerforsourcetodestination
transformation
Writedatascriptsfordatamigrationandtransformation
Runfunctionaltestandreportonerrorsfromdatamigration
Rundatacutoversforbuildandtestingphase
AssistCFSAwithmockdataruns
Troubleshootandresolvedatarelatedbugs
Designingreportpatternsbasedonreportuserstories
Overseeingreportdeveloperswork

Test Lead
UI/UX Consultant
Page31of69
© Workingwiththedataandreportingteamtodesignanddevelop
reports
© Developacomprehensivetestingstrategydefiningtestobjectives,
scope,andtimelines,andrecommendedpracticesforvarioustesting
types.
¢ Establishstandardsandproceduresformanualandautomated
functionaltesting,processtesting,End-to-Endtesting,integration
testing,datamigrationtesting,anduseracceptancetesting.
* Providetrainingandcoachingontestingrecommendedpracticesand
testingtemplatestodriveconsistencyandefficiencyintheteam’s
testingefforts.ImplementAzureDevOps testDashboardandmetrics
tomonitorprogress,identifyissues,andreportontheoveralltesting
status.
© Reviewprototypesandwireframesforapplicationofbrandingand
stylingguidelines,providesuggestionsforimprovementstomenus,
layout,andnavigationconsistentwithDynamics365platform.
© UpdatesingleCSSthemeforPowerPagesportal.
© Interactwithproductowners
C6.16 CFSAResponsibilitiesandProjectAssumptions
_ yrsolution a
BusinessProcessFlows,UserStoriesUserstoriesandbusinessprocessflowswillbecreatedandapprovedbyCFSAbytheendoftheproductplanningphase.Ifuserstoriesorbusinessprocessflowsarechangedaftertheyareapproved,eitheraspartofSprintclarification
orperCFSALeadershiprequest,theywillneedtobeprioritizedbyCFSAandwillconsumeavailablecapacityinsprints.
DataMigration CFSA willbe responsibleforthe extractionofdata from source systems,
performinganydatacleansing/de-duplicationnecessary,andloadingdataintoSQLtables.MicrosoftwillconfiguretheSQLtablesandprovideCFSAtheschema. Microsoft willthen load data intothe Dataverse database from SQL
intoa non-production environment. Data migration willneed to be re-testedand
re-executedforUAT andProductionpurposesaspartofa futureengagement.
Futurephases ThefinalbuildsprintwillconsistoffinalizingADO documentation/wikisandnotnewfeaturedevelopment.IfCFSAdoescontractthenextphaseofworkcontiguoustothisengagementviaanadditionalchangerequest,thefinalbuildsprintcanincludefeaturedevelopment.
Legacyapplications
CFSAisresponsibleforchangemanagementwithrespecttoFACESoranyotherlegacyCFSAsystems.Changestothoseenvironmentsthatimpact
configuration/developmentoftheSTAANDsolutionmayrequireachangerequest.

Prioritization
Page32of69
CFSAisresponsibleformakingallscopeandprioritizationdecisions.
AgileCoaching IfCFSArequiresadditionalagiletraining/coaching,achangerequestwillberaisedforadditionalresources.

TestdatawillbeprovidedbyCFSAbeforetheBuildSprintTestingbegins;CFSAwillberesponsibleforprovidingscrubbedrepresentativedata.
MCS Developershallcreatetestdataduringunit/functionaltestingandCFSAcanproviderepresentativedatasamplesfor
reference.
Testingwillbeperformedononeoperatingsystemandonebrowser,andonlyversionsdefinedintheSoftwareproductsand
technologiessectionwillbeused.
NomultilingualtestingwillbeperformedbyMicrosoft;validationoffieldcontentcorrectnessisnotinscope;CFSAwillberesponsibleforverifyingtheaccuracyofall
translations.
Onlysamplebasetestingwillbeperformed
onthelatestsupportedversionsofthethird-
partyFirefoxbrowser.
AnoffshoreMicrosofttestteamwillperformE2Esystemtestingonthedevelopmentenvironment.
The testenvironmentshouldbe areplicaof| Datashouldbe anonymizedwithPIIremoved by CFSA
thereal-timeCFSA environment.

Numberof 10instances
Datacenter NorthAmerica
Clients Webclient
Languages USEnglish(base)
Currencies USDollar
Applications CFSAService
C619 CFSAandMicrosofttaskassignments
Cc, InterfacesandIntegrati
Page33of69

Defineinterfacerequirementsandsecurity.
Createsampleinterfaceagreements
Createsamplewebservicedefinitionlanguageorstubs.
Integratetestdata. x
PerformdatamappingofDynamics365. X
Createdatamappingwithexternalend xpoints.
Defineformatanddatatypes. x
Senddatatotheagreed-uponinterfaceor —-XmiddlewarefromMicrosoftDynamics.
TheendoftheSprintExecution-Analysisactivityset.
TheendoftheBuild-Design
activityset.
TheendoftheSprintExecution-Designactivityset.
TheendoftheSprintExecution-Designactivityset.
TheendoftheSprintExccution-Developmentactivityset.
TheendoftheSprintExecution-Developmentactivityset.
TheendoftheSprintExecution-Developmentactivityset.
TheendoftheSprintExecution-Developmentactivityset.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page34of69

Microsoft CFSA eee
Receivedatafromtheagreed-uponinterfaceX x TheendoftheSprintormiddlewaretoMicrosoftDynamics. Execution-Developmentactivityset.
Senddatatotheagreed-uponinterfaceor X x TheendoftheSprintmiddlewarefromexternalsystems. Execution-Developmentactivityset.
Receivedatafromtheagreed-uponinterfaceX x TheendoftheSprint
ormiddlewaretoexternalsystems. Execution-Developmentactivityset.
Testandvalidateintegrateddata. x TheendoftheSprinttestingactivityset.
C.6.19.2 Securit

Securityimplementationresponsibilities|Microsoft| CFS bay dtd
ProvideguidancerelatedtothestandardX Buildsprintsroles,duties,andprivilegesinMicrosoftDynamics365.
Provideguidancerelatedtotheuseof x Buildsprints
standardMicrosoftDynamics365-basedtoolswithinthesoftwareforconfigurationandmanagementofsecurity.
Provideguidancerelatedtothemappingof X Buildsprints
organizationalrolestoMicrosoftDynamics365.
Identifyexistingorganizationalrolesand x Buildsprintsresponsibilities.
Provideadescriptionofthedesiredduties x Buildsprintstobeallowedforeachrole.
CollaboratewithMicrosofttomaprolesand x BuildsprintsresponsibilitiestoMicrosoftDynamics365
standardrolesandduties.
Configuresystemuserswithintheir x x Buildsprintsappropriatesecurityroles.

Page35of69
Allnon-prodenvironments-sharedbetween
MS and CFSA.
AllProd environmentsareCFSA only
ManagethephysicalsecurityofCFSAsites. x Buildsprints
C7.
C11
CTL
C712
C713
C7131
KEY PERSONNEL
Thekeypersonnelspecifiedinthecontractareconsideredtobeessentialtotheworkbeing
performedhereunder.
Priortodivertinganyofthespecifiedkeypersonnelforanyreason,theContractorshallnotifytheCO atleastthirty(30)calendardaysinadvanceandshallsubmitjustification,includingproposedsubstitutions,insufficientdetailtopermitevaluationoftheimpactupon
the contract.
Circumstancesmayarise,however,whichnecessitatekeypersonneltobesubstitutedduringtheprogressofworkduetopromotions,termination,sickness,vacation,juryduty,personalhardshiporothersimilarmaterialchangeintheemploymentcircumstanceofthe
employee,allofwhichareoutofMicrosoft’scontrolandareplacementofcomparablebackgroundandexperiencemaybesubstituted.TheContractorshallobtainwrittenapprovalfromtheCO foranyproposedsubstitutionofkeypersonnel.
Contractorshallsubmitthekeypersonnelresumeswithin30calendardaysofContractawarddateforthefollowingkeypersonnel:
(One)ProgramManager
(© Servesastheprimarypointofcontactandtakesaccountabilityforservicedelivery.
© Servesasthepointofcontactforcontractextensions,personnelmatters,and
billing.
© AlignMicrosoft-recommendedprojectandengagementpracticesacrossMicrosoft
Dynamicsengagements.
© Monitorprojectmatrices,resolvebottlenecksandresourceperformanceissues.
Regularprogressreportstoincludemetricsandanalysisofprojectperformance
againstthedefinedKPIs.
© Facilitateperiodicprojectreviewsandmeetingstodiscussperformance,address
concerns,andensurecontinuousimprovement.
© CommunicatewithandadviseMicrosoftandCFSAexecutiveleadershipregarding
projectrisksandmitigations,developdeliverystrategies,andfacilitate
collaborationandcommunicationbetweenexecutivestakeholders.
© Managetheescalationprocessandinteractwiththestakeholderswhowillhave
responsibilityfortheoverallprogram.
© Validatethattheprojecthasbeenfulfilledwithinestablishedstandardsacrossboth
partnerandMicrosoftresources.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page36of 69
C7132
C8.
C81
C82
C83
C84
C85
C86
(Two)TechnicalLeads
©.Prioritizeconfigurationovercustomcode
© CoordinatetheassignmentofMicrosofttechnicalconsultants.
© Takeresponsibilityfortheoverallqualityoftechnicalactivities.
© MonitorsolutionforcustomizationsandescalatetoARBandPOACfor
discussion.
Takeresponsibilityfortechnicalarchitectureandcodedeliverables.
© Analyzetimetakenforeachdevelopmentphase
°
REQUIREMENTS MANAGEMENT
TheContractorandCFSAwillbejointlyresponsibleforreviewingandclarifyinguserstoriesdevelopedbyCFSAtodefinebusinessoperationsandpreparethemforconfiguration.
InAttachmentsJ.18FunctionalReferenceFramework,J.17TechnicalReference
Framework-andJ.15CFSABusinessProcesses,CFSAdescribesthehigh-levelbusinessprocesses,majorfunctionalandtechnicalcomponentsoftheSystem.ThesesetsofrequirementsshallformthefoundationoftheRequirementsTraceabilityMatrix(RTM).‘ThemanagementoftheRTM isofstrategicandoperationalimportancetotheeffortanda‘majorinputforhowCFSAplanstomanagechange.TheRTM willbemanagedinAzureDevOpsasEpics,Features,andUserStories.
CFSAexpectthedetailsofourrequirementswillchange,eitherduetotimeelapsingfromthetimeofwritingtheCooperativeAgreementtoaward,theresultsfromCFSA’sLeanbusinessprocessimprovementactivitiesorthedetailtobeelicitedfromCFSAstaffand
partnersbytheContractor.Ifthechangeinrequirementsleadstoachangeintheestimatedeffortofanundevelopeduserstory,orreworkofa previouslydevelopeduserstory,thiswillreducetheavailabledevelopmentcapacitywithinthebuildsprints.
Changesmayalsobeinspiredbychangesinprogrampractice,theAcceptanceCriteriafor
theuserstoriestobedevelopedfromtherequirements,andfactorscommontotechnologyengagementsofthissize.Thus,itisexpectedthatuserstoriesanddetailedrequirementswillbecontinuouslydeveloped,andtheRTM becontinuallyupdatedaspartoftheexpectedagilehybridimplementationapproach.Ifthechangeinrequirements(includingacceptancecriteria)leadstoachangeintheestimatedeffortofanundevelopeduserstory,orreworkof
apreviouslydevelopeduserstory,thiswillreducetheavailabledevelopmentcapacitywithinthebuildsprints.
‘Aspartofchangecontrolmanagement,theContractorshallbringchangesthatrequiresignificantcustomcodeand/orconfigurationchangesthatarerequestedbyCFSAand/or
identifiedbytheirownteamdocumentchangesandraise.TheassessmentofthechangeshallincludespecificimpactstobothscheduleandcoststotheArchitecturalControlBoardforreview.
ProposedchangeswithintheoverallscopeoftheCCWISSystemmayberequestedbythe
CFSAprogrammanagerortheContractor'sprojectmanager.IfCFSAapprovesthechangestotechnicalorfunctionalrequirementswhichaffectcost,theContractingOfficer(CO)shallissueaChangeOrder.AnysuchchangesshallbeformallymodifiedintheContractfollowingtheCFSAOfficeofProcurement(OP)ContractModificationProcess.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page37of69
C87
C88
C89
(on
C91
C.10.
C101
Ifmodificationsdo notresultina Change Order ormodificationof cost,theagreedto
modificationsshallnotbe requiredtobe formallymodifiedthroughOP’s Contract
ModificationProcess.
DecisionsregardingchangeswillbedeterminedbytheCO,inconsultationwiththePMO.Intheeventthatadecisioncannotbedetermined,theCFSACIOandtheprojectContract
Administratorwillmakethefinaldecisionformodificationstotherequirements.
Slightrewordingorotherminorchangesthatdonotmateriallychangetherequirementshallnotberequiredtogothroughfullchangecontrolprocesses.
DEVELOPMENT
Thisserviceinvolvesplatformand/orproductconfigurationsand/oranycustomdevelopmentoftheCCWISbasedonaccepteddesigns.MicrosoftwillprioritizeconfigurationovercustomizationunlessotherwisedirectedbyPOAC.Developmentincludescomponent(orunit)testingofindividualmodules,andassemblytestingof
connectedmodules.Thesetestactivitiesareprecursorstosystemtesting.
TESTING
Thefollowingtableprovidesinformationaboutthetypesoftesting,responsibilities,and
environmentstobeusedforconductingtestingactivities.
The followingtestingisincludedintheengagement.
Teena Perera

(em ay
Rca rorCMD rantCoM corCod
Cea at
Breeyzasd
UnittestingDonetodetermine MicrosoftMicrosoftMicrosoft.CFSA(Development)_ whetheraunitofcode

functionsaccordingtothetechnical
requirementsofthesolution.Includeinitialaccessibilitytesting.
Functional Focuses on functionality Microsoft | CFSA CFSA CFSA
testing(QA)meetingthedesign.(Thiswillalsoinclude
datamigrationmapping
testingusingnon-prod
dataaswellastesting
developedintegration
features
ProcesstestingTheprocesstesthelpstoCFSA CFSA —CFSA Microsoft
(QA) validateeachprocess
testscriptfor
DCRL-2023-F-0071Comp

(environment)
Integration
testing(QA)

Accessibility
testing(QA)
Performance
andscalability
testing
(Performance)
CAL.
CAL.
pet
orton
POSatLey
confirmationofthebusinessprocessesrequiredinthesolution,Processtestingdoesnotfocusonend-to-endscenarios.(Thiswillalsoincludedatamigrationmapping
testingusingnon-proddata)
Donetovalidatetheintegrationof
componentsdevelopedaspartofthesolutionbyrunningautomatedteststocompareagainst
technicalspecifications(ormockupsofexternalorthird-partysystems).
Integrationtestingmayincludeintegrationwithexternalorthird-party
componentsorsystems.
Donetovalidatethe
usabilityofthesolution
whilemeeting
accessibilitystandards.
CFSA CFSA.
CFSA, CFSA,
Donetomeasurethe Microsoft.© CFSA.
performanceand
scalabilityofthe
deliveredsolution
againstnonfunctional
requirements.Testcases
arebasedonthe
functionalspecification
document,which
definesperformance
criteria.
DATA CONVERSION AND MIGRATION
Page38of69
Rees
arated
Peresandsupport
Saucy
aed
CESA Microsoft
CFSA Microsoft
Microsoft CFSA
Thedatamigrationrequirementswillbedevelopedduringproductplanning,anddeveloped,migrated,andunit-testedusingAzureDataFactory/SSIS.DatamigrationSMEswillbe
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page39of69
C112
Porc Dee Rui
writingandcapturingrequirementsinuserstoriesthatwillbeaddedtothebacklogandprioritizedbyCFSA.Datawillbemigratedseparatelyforeachmoduledeveloped.Datawill
bemigratedintoonlythedatamigrationsandboxenvironmentfortesting/reviewpurposesduringthisengagement.AdditionaleffortwillberequiredtomigrateandfullytestdatainaUAT andProductionenvironmentduringafutureengagement.AdditionaleffortwillberequiredtomigrateandfullytestdatainaUATandProductionenvironmentduringafutureengagement.
Microsoftwillloadthedatathatistobemigratedintothedatamigrationenvironmenttotestthedatamigrationloadprocessandscripts.TheCFSAwillassigntherequiredfunctionalandtechnicalresourcestoworkwithMicrosoftfunctionalandtechnicalresources
toassist,shadow,andlearnthedataconversiontoolsandprocesses.
CFSA isresponsibleforvalidatingtheconverteddataaftereach testdataload,and for
making thenecessarycorrectionsassociatedwith each testdataloadviaa TBD dataload
tool.
MicrosoftdatamigrationactivitieswillbecompletedbasedontheMicrosoftteamcapacityavailable.Additionalcapacitycanbeaddedviatothechangemanagementprocessdescribedinthiscontract.Uponcompletionoftheproductiondatamigrationload,theresultswillbedeemedaccepted.
Thefollowingdatamigrationobjectiveissubjecttothedatamigrationapproachandrolesand responsibilitiesdefinitions.

CFSA OracleSQL tables 400 GB Azure Data
C.12.
C121
C122
C.12.3
C.13.
C131
Factory/SSIS
TRAINING AND KNOWLEDGE TRANSFER
Formaltrainingisout-of-scopeforthisengagement.CFSAisresponsiblefortraining
materialdevelopmentandexecution,andCFSAwillembedbusinessanalystresourceswithintheteamstoassistwithtrainingandOrganizationalChangeManagement.
InformalknowledgetransferbetweenMicrosoftteammembersandCFSAmayoccurthroughoutthisphase.Anyinformalknowledgetransfermaysubtractfromtheteam
members’availablecapacitytodevelopadditionalfeaturesinSprintsandthesetaskswillbetrackedasknowledgetransfertasksinAzureDevOps(ADO)systemusedfortrackingprojecttasks,risksandoverallimplementationofthesystem.
CFSAwillberesponsibleforAdoptionandOrganizationalChangeManagementduringthis
engagement.Asdescribedabove,CFSAwillembedbusinessanalystresourcesineachteamwhowillberesponsibleforthedevelopmentofdocumentationtosupportAdoptionandOrganizationalChangeManagement.
TIMELINEDuringprojectplanning,adetailedtimelinewillbedeveloped.Thefollowingtimelineisahigh-levelrepresentation,andalldatesanddurationsarerelativetotheprojectstartdateand
DCRL-2023-F-0071 Comprehensive ChildWelfareInformationSystem (CCWIS) Page 40 of 69
areestimatesonly.Iftheprojecttimelinechangessignificantly,achangerequestmaybeissuedfollowingthechangemanagementprocessdescribedinthisSOW.

=p —: == see =v
. x ~s

Datessubjecttochange.FinaldateswillbepublishedontheADO Wiki.
C14, AREAS OUT OF SCOPE
AnyareanotexplicitlyincludedintheProjectobjectivessectionasinscope,isoutofscopeforMicrosoftduringthisproject.Areasoutofscopeforthisprojectincludethefollowing.
Wi
Product licenses Product licenses(Microsoftor non-Microsoft) and cloud
servicesubscriptionsarenotincluded,unlessotherwisenotedintheSoftwareproductsandtechnologiessection.
Med
Hardware Microsoftwillnotprovidehardwareforthisprojectasthereisnohardwareprocurementrequiredforthisproject.
Infrastructuresetup Infrastructuresetup(requiredhardwareandsoftware),includingsetupofahighavailability,disasterrecovery,or load-balancedenvironment, isnot inthe scopeof this
contract.
Legacysystems Microsoftwillnotberesponsibleforsupportinglegacyclientsystems.
Requirementsgathering Microsoftwillanalyzethefunctionalrequirementsdocumented and collectthenecessaryinformationto
movetheUserStorytodevelopmentreadystatefor
processesidentifiedasinscope;thegatheringof
requirementsisnotinscopeunderthiscontract.
Documentation Preparationofdocumentationregardingexistingprocesses,previousstandards,policies,orexistingguidelinesisoutsidethescopeofthiscontract.

PlatformUpgrades,updates,
patches,andfixes
Globalsolutionneeds
Performancetesting
Page41of69

Upgrades,updates,patches,andfixesarenotincludedinthisscopeofwork,specifically:
* Operatingsystemversions,updatedservicepacks,or
hotfixes.
* MicrosoftDynamics365componentversions,
updatedservicepacks,hotfixes,orDCR.
* Otherserverorclientframeworkcomponent
versions.
© Customcodingtoavoidtheapplicationofhotfixesis
outofscope.(Ifafixorpatchisidentifiedasrequired
afierthestartoftheproject,anassessmentwillbe
madebytheprojectmanagementteamfrom
MicrosoftandtheCFSAastotheneedforsuchafix.
Ifthefixisdeemedneededbybothpartiesto
implementthefunctionalityrequiredbytheCFSA,
thechangewillgothroughthechangemanagement
process.)
© Ifbasedonaplatformupgradeafunctioncreatedby
theMicrosoftteamnolongerworks,theteamwill
immediatelyaddressitifprioritizedbyCFSA.
Note:Ifafixorpatchisneededbecauseofdefectsinthe
Microsoftsoftware,theCFSAwilluseitsMicrosoft
Premiercontractorthird-partysupportprovidertoapplythefixorpatch.
Languageimplementationsthatarenotpartofthecoreproductwillnotbeappliedaspartofthiscontract.
Thefollowingareasareoutofscopeforperformance
testing:
© Architecturalanddesignrecommendationsorchanges.
«Networkemulationandnetworkvolumetesting.
© Testdatacreationforperformancetestingof
masterentitiesandtransactionaldata.
* Identificationofperformanceproblems in
integratedexternalsystems.
© Anytypeofdataimportorfeedfrom,orto,an
externalsysteminterface.
© Performanceremediationof,orimprovementsto,
anycustomizedandout-of-the-boxfeaturesthatwerenecessitatedbyproblemsinthelocalCFSA.
hardwareornetworklayer.
© Whiletheengagementwillendeavortocreate
optimizedconfigurationsandcode,attainmentof
Page42of69

specificperformancemetricsorservice-level
agreements(SLAS)isout-of-scope(ex.“aformwillloadinXX seconds”).UserstoriesmaybeaddedtothebacklogandprioritizedbyCFSAtoaddressperformanceissuesdiscovered.ThiswillbelimitedtoDynamics365configurationsand
customizationscreatedforCFSA,anddoesnotapplytothebaseproduct
Processre-engineering Designingfunctionalbusinesscomponentsandbusiness
processesofthesolutionisnotincluded.
DeploymenttoProduction DeploymentoftheDynamicssolutiontoproductionis
notincludedinthisengagement.
C141

Unlessspecifiedotherwise,deliverableslistedwillbe producedby Microsoft.
rae eens eta
Productplanning ‘©CFSAbusinessawareness:Theteamshould Deliverables:+ StaffingplansandhaveaclearunderstandingoftheCFSA
businessandthe“bigpicture"purposeofthe resource
projectfromaCFSAperspective. assignment.+ Contractawareness:Theprojectgovernance * Productroadmapandprojectdeliveryteamsshouldclearly updatedwithunderstandthecontract,andthelimitations themesandmappedtohigh-andassumptionsmadeduringthepre-salesoye.‘* Projectteamalignment:TheCFSAand
levelprocesses,user stories,and
internalprojectdeliveryteamsshouldbe (eauirementsalignedontheobjectivesoftheproject, . competeddeliveryapproach,estimatedtimelines,
resourcerequirements,andotherprojectassumptions.
* CompletedUS
AuditChecklist
‘* Staffingcheckpoints:Theresourcemodel . yon point
requiredfortheprojectasdefinedinthe ___Template
contractshouldbeidentifiedand Assumptions:
communicated.Makesurestaffing * Thesedeliverables
checkpointsarediscussedandtheprocess. donotrequirestarts. CFSA acceptance.
‘Releaseplanningkickoffpreparation:MakesuretheteamisreadyfortheReleaseplanningkickoffworkshop.
+ Productroadmap:TheProductroadmapshouldbeupdatedwiththemesandmappedtohigh-levelprocesses,userstories,andrequirements.

DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page43of69
BoC eend

Releaseplanning Releaseplancompleted:Thereleaseplan Deliverables:shouldbecreatedforthecurrentand * Releaseplan
upcomingreleases. * Sprintplan‘+Sprintplancompleted:Adetailedsprintplan * Delivery
shouldbecreatedforatleasttwoupcoming methodology,sprintsintherelease. RACI
‘©Cleardeliveryapproachandteamalignment: * BacklogTheentireprojectteamshouldclearly prioritization
understandthemethodology,teamstructure, process
responsible,accountable,consulted,informed «Definitionofsprint
(RAC),andescalationpaths. ceremonies* Governanceplancompleted:Theproject
governanceprocessshouldbeestablishedandupdatedwiththerhythmofthebusiness
(ROB)fortherelease.
* Projectgovernance
planandROB
* TestingandQA

© Completedenvironmentandtoolssetupfor plan
projectimplementation:Thetoolsand + Deliveryenvironmentsrequiredfortheprojectshould environmentsand
besetup.Theseincludethepreproduction tools.
environments,AzureDevOps,andTeams. * RefinedProduct
‘* Strategydocumentcompleted:TheStrategy Backlog(Readyfor
documentsshouldbecreatedbasedonthe Sprintplanning)
productroadmapandstrategyworkshops * TaskTemplate
outcomes. * DataModel
‘©TestingandQAplancreated:Thetestingplan Scorecard
orscheduleshouldbecreatedorupdatedfor Template
theentireproductorsolution.TheCFSA
shouldbefamiliarwithalltestingandQA ‘Assumptions:
processes. © These deliverablesdo not
ProductbacklogRefinement: requireCFSAacceptance.Thedevelopmentteamwillreviewanddiscusstheproductbacklogitems.Theywillreview
the acceptance criteriaand estimate the effort
requiredforeachitem.Itisimportantto
refinetheproductbacklogitemsbeforetheycanbeincludedinthesprintplanning
process.
+ "Conditionsofsatisfaction”accepted:Makesurethe
MicrosoftandCFSAteamsreviewtheconditionsof
satisfaction,andthattheCFSAacceptstheconditions
ofsatisfaction,namelywhatisbeingdelivered,and

howitisbeingdelivered.
sprints TheBuildstageisdividedintoBuildsprints,each Deliverabl
definedforaparticularsetoffunctionalities:Each * Prioritizedprocess
Buildsprintwillcontainthefollowingactivitysets: scenariosanduser
+ Sprintplanning stories
© Analysis * Updatedsprint
Design capacityplanand
schedule
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page44of69
BoC eend

* Development .
+ Sprinttesting
Sprintplanning
+ Prioritizedprocessscenariosanduserstories:The
processscenariosanduserstoriesshouldbe
prioritizedandreviewedwiththeCFSAwhen
assigninguserstoriestothesprint.
+ Alluserstoriesshouldbeestimatedtodeterminethe
levelofeffortrequiredforeachone. .
+ Anupdatedsprintcapacityplanandschedule:The
sprintcapacityplanandscheduleshouldbeupdated .
forthesprintbasedonprojectteaminput,including .
capacityconstraintsanduserstoryestimations.
+ Analysisworkshopsreadiness:Theanalysisworkshops
shouldbeaddedtothecalendarwithrequired
attendeesandapreviewoftheprocessesanduser .
storiesorrequirementstobedetermined.
‘BuildsprintROBreviewed:ReviewtheROBandmake
surethatallcalendarinvitationsforthecurrentsprint
aresentout.
«Finalizeoperationalprocesses,setups,sprint

Requirements
categorizations
StoryPointTemplate
Setupofarchitect
reviewboardto
supportthereviewof
requirements,approval
ofgaps,andsolution
alignment
Alignmentofsolution
toproductroadmap
Functionaltestscripts
Functionality
walkthrough
completionduring
sprintdemonstration
CFSAsign-offand
acceptancethatthe
sprintdemonstration
meetsthefunctionality
definedintheuser
storiesselectedand
ceremonymeetings,dailystandups,go/no-go approvedduringsprint
ings,deliverytools,andprogresstracking planning.burndowncharts. + Sprinttesting| completionandAnalysis outcomesdocument* Categorizerequirements:Allrequirementsshouldbe + Updatedcategorizedanddocumented. configurations+ Setuparchitectreviewboard:Thearchitectreview * Updatedbacklogboardshouldbesetuptofacilitaterequirements + Sprintincrement
review,gapapproval,andsolutionalignment. deployedtotheCFSA* Alignsolution:Makesurethatallrequirementsalign QAenvironmentwiththeproductroadmapfortheproject. + CompletedTask* Demonstratefunctionality:Fitrequirementsshouldbe Details(using
includedinthebaselineconfigurationand Template)demonstrated to the CFSA.
. ‘Assumptions:Design + Feedbackfromsprint‘*Approvethedesign:Thedesignshouldbeapproved
basedoninformationcapturedinAzureDevOps.
© Completefunctionaltestscripts:Allfunctionaltest,
scriptsforgapsinthesprintshouldbedocumented
and reviewed with the development team.
Makedataavailablefortesting:Alldatafortesting
gapsshouldbeavailable.
Development .
demonstrationsmay
leadtoadditional
effortthatneedstobe
addressedinachange
requestorisdelivered
inafuture
engagement
Withtheexceptionof
theSprint
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page45of69
BoC eend

© Completefunctionalitydevelopment:ThefunctionalityDemonstration
identifiedforthecurrentsprintshouldbecompleted Acceptance,these
andavailableforfunctionaltesting. deliverablesdonot
* Rununittestscripts:Theunittestscriptsforthe requireCFSA
functionalityshouldberunandcodereviews acceptance
completedpriortoreleasingthecodetothe
functionalteam.Unittestsshouldberunbythe
developerworkingonthecode.
* Completefunctionalitywalkthrough:Thedeveloper
shouldwalkthroughthefunctionalitydevelopedwith
thefunctionalteam.Thiswillallowthefunctional
teamtogetaninitialviewofthefunctionalityand
providefeedbackandpreparefortesting.
Sprinttesting
‘*CompleteSprinttesting:Bothunitandfunctional
testingofsprintcomponentsshouldbecompleted.
Integrationtestscriptsshouldberunasthesolution
componentsarecompleted,
‘* Documentoutcomes:Outcomesshouldbe
documentedinWikiandAzureDevOpsworkitem
* Updatethebacklog:Thebacklogshouldbeupdated
toincludedocumenteddefectsandprioritizedby
Product Owner.
+ Updateconfigurations:Sprintcomponent
configurationsshouldbeupdated,retested,and
appropriatelydocumented.

Processtesting
+ Runprocesstestscripts:Processtestscriptsshouldbe
runforallprocessesdeliveredbythelatestBuild
sprint.
* Validatefunctionality:Alltestablefunctionaland
nonfunctionalrequirementspersprintshouldbe
tested.
* Updatethebacklog:Thebacklogshouldbeupdated
toincludeanyopendefectsidentifiedandtestcases
thatcouldnotberun.
«Update trainingcontent:Thetrainingcontentshould
beupdatedwithoutcomesanddeliverablesfromthe
currentTestsprint.

Performancetesting
+ Runperformancetestscripts:Performancetestscripts
shouldberunforallcriticalE2Eprocessscenarios
deliveredduringthelatestBuildsprint.
* Updatethebacklog.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page46of 69

C15.
CASA
Deo eend
* Updatetrainingcontent.
Regressiontesting
«Run regressiontestscripts:Regressiontestscripts
shouldberunforallcriticalE2Eprocessscenarios
deliveredduringthelatestBuildsprint.
‘+Stabilizethesystem:Validatethatthesystemand
functionalityareworkingasintendedbytheCFSA
subjectmatterexperts(SMEs).
* Updatethebacklog.
REGULATIONS
CFSAproductownerswillberesponsiblefordeveloping,approving,andprioritizinguserstoriesthatmeetCCWISrequirements(showninTable2CCWISRegulations)andbeinformedbytheguidancecontainedintechnicalbulletins(currentlynumbering6)releasedbytheACFregardingallCCWIS-administeredchildwelfareprogramsavailableat:
hitps://vww.acf.hhs.gov/cb/laws-policies/technical-bulletins/ccwis.ThesechangesmayincludemutuallyagreeduponLegislation,Regulations,andProgramPolicyidentifiedontheAFC’swebsite,locatedathttps://www.acf.hhs.gov/.
Table2CCWIS,a
(@)Effcien,economical,andeffectiverequirement.ThettleIV-Eagency'sCCWISmustsupporttheelfcient,economical,andeffectiveadministrationofthetitleTV-BandTV-Eplanspursuanttosection474(a)(3(C\iv)oftheAct

(1)Improvingprogrammanagementandadministrationbymaintainingallprogramdatarequiredbyfederal,stateortriballaworpolicy;
2)Appropriatelyapplyinginformationtechnology;
(3)Notrequiringduplicativeapplicationsystemdevelopmentorsoftwaremaintenance;and
(4)Ensuringcostsarereasonable,appropriate,andbeneficial
(b)CCWISdatarequirements.ThettleIV-Eagency'sCCWISmustmaintain:
(1)TitleTV-Bandtitle1V-Edatathatsupportstheefficient,effective,andeconomicaladministrationoftheprogramsoe
(@Datarequiredforongoingfederalchildwelfarereports;
Gi)DatarequiredforttleIV-Eeligibilitydeterminations,authorizationsofservices,andexpendituresunderIV-BandIV-E;
10 ii)Datatosupportfederalchildwelfarelaws,regulations,andpolicies;and
n iv)Casemanagementdatatosupportfederalaudits,reviews,andothermonitoringactivities;
2 (2)Datatosupportstateortribalchildwelfarelaws,regulations,policies,practices,reportingrequirements,audits,programevaluations,andreviews;
G)Forstates,datatosupportspecificmeasurestakentocomplywiththerequirementsinsection422(b)(9)oftheActregardingthestate'scompliancewiththeIndianChildWelfareAct;and
4 (4)Foreachstate,datafortheNationalChildAbuseandNeglectDataSystem.
(©)Reportingrequirements,ThetitleIV-Eagency'sCCWISmustusethedatadescribedinparagraph(b)ofthissectionto:
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page47of69
16 (1)Generate,orcontributeto,requiredttleIV-BorIV-Efederalreportsaccordingtoapplicableformattingandsubmissionrequirements;and
(2)Generate,orcontributeto,reportsneededbystateortribalchildwelfarelaws,regulations,policies,practices,reporting

17| requirements,audits,andreviewsthatsupportprogramsandservicesdescribedintteIV-Bandtile1V-E
18| (@)Dataqualityrequirements.
19_|(1)COW!Sdatadescribedinparagraph(b)ofthissectionmust:
20| (i)Meetthemostrigorousoftheapplicablefederal,andstateortribalstandardsforcompleteness,timeliness,andaccuracy;
21| Gi)BeconsistentlyanduniformlycollectedbyCCWISand,ifapplicable,childwelfarecontributingagencysystems;
(Gi)Beexchangedandmaintainedinaccordancewithconfidentialityrequirementsinsection471(a)(8)oftheAct,and4522| CER205.50,and42U.S.C.$106a(b\(2\B)viii)through(x)oftheChildAbusePreventionandTreatmentAct,ifapplicable,andotherapplicablefederalandstateortriballaws
Gv)Supportchildwelfarepolicies,goals,andpractices;and
24| (¥)GeneratereportsofcontinuingorunresolvedCCWISdataqualityproblems.
25| (@)Thetttle1V-EagencymustimplementandmaintainautomatedfunctionsinCCWISto:
26| (i)RegularlymonitorCCWISdataquality;
27__|(i)Alenstafftocollet,update,correct,andenterCCWISdata,
2g_| (ii)SendelectronicrequeststochildwelfarecontributingagencysystemstosubmitcurentandhistoricalCCWISdatatotheCcwIs;
29| (iv)Prevent,totheextentpracticable,theneedtore-enterdataalreadycapturedorexchangedwiththeCCWIS;and
30| (v)GeneratereportsofcontinuingorunresolvedCCWISdataqualityproblems.
31| @)ThetitleIV-Eagencymustconductbiennialdataqualityreviewsto:
‘32__|(Determineifthetitle1V-Eagencyand,ifapplicable,childwelfarecontributingagencies,meettherequirementsofparagraphs(b),(4)(1),and(€)(2)ofthissection;and
433__|(i)Confirmthatthebi-directionaldataexchangesmeettherequirementsofparagraphs(e)and()ofthissection,andotherapplicableACFregulationsandpolicies.
‘34.| @Thetitle1V-EagencymustenhanceCCWISortheelectronicbi-directionaldataexchangesorbothtocorrectanyfindingsfromreviewsdescribedatparagraph(d)(3)ofthissection.
(5)ThettleIV-Eagencymustdevelop,implement,andmaintainaCCWISdataqualityplaninamannerprescribedbyACF35| andincludeitaspartofAnnualorOperationalAPDssubmittedtoACFasrequiredin45CFR95.610.CCWISdataqualityplanmus:
136| (Describethecomprehensivestrategytopromotedataqualityincludingthestepstomeettherequirementsatparagraphs(@(1)through(3)ofthissection;and
37_| i)Reportthestatusofcompliancewithparagraph(4)(1)ofthissection.
38| (©)Bisdirectionaldataexchanges
39| (1)CCWISmustsupporefficient,economical,andeffectivebi-directionaldataexchangestoexchangerelevantdatawith:
‘40.|(@SystemsgeneratingthefinancialpaymentsandclaimsfortitlesTV-BandIV-Eperparagraph(b)1)\(i)ofthissection,ifapplicable;
a i)Systemsoperatedbychildwelfarecontributingagenciesthatarecollectingotusingdatadescribedinparagraph(b)ofthis,section,ifapplicable
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page48of69
(Gil)EachsystemusedtocalculateoneormorecomponentsofttleIV-Eeligibilitydeterminationsperparagraph(b)1}(i)of.thissection,ifapplicable;and

a
43| (iv)BachsystemexternaltoCCWISusedbytitleIV-EagencystafftocollectCCWISdata,ifapplicable,
(2)Totheextentpracticable,thetitle1V-Eagency'sCCWISmustsupportonebi-directionaldataexchangetoexchange44|relevantdata,includingdatathatmaybenefitIV-Eagenciesanddataexchangepartnersinservingclientsandimproving‘outcomes,witheachofthefollowingstateortribalsystems:

45| ()Childabuseandneglectsystems);
46| (ii)System(s)operatedunderttleIV-AoftheAct;
47| Gili)SystemsoperatedunderttleXIXoftheActincluding:
48_|(A)SystemstodetermineMedicaideligibilitydescribedin42CFR433.111(>)2)i)(A);and
49| (B)MedicaidManagementInformationSystemsasdefinedat42CFR433.111(b\2)(i)(B);

50| Gv)SystemsoperatedunderttleIV-DoftheAct,
‘31.| (©)Systemsoperatedbythecourt(s)ofcompetentjurisdictionovertitleV-Efostercare,adoption,andguardianshipPrograms;
52_|(vi)Systemsoperatedbythestateortribaleducationagency,orschooldistricts,orboth.

(0Dataexchangestandardrequirements.ThettleIV-Eagencymustuseasingledataexchangestandardthatdescribes

83| data,definitions,formats,andotherspecificationsuponimplementingaCCWIS:
(1)Forbi-directionaldataexchangesbetweenCCWISandeachchildwelfarecontributingagency;and
55| (2)Fordataexchangeswithsystemsdescribedunderparagraph(¢)(1)(iv)ofthissection.
36| (g)Automatedeligibilitydeterminationrequirements.
57| (DAstatetitleTV-EagencymustusethesameautomatedfunctionorthesamegroupofautomatedfunctionsforaltleTV-E eligibilitydeterminations.

(Q)AtribalttleIV-Eagencymust,totheextentpracticable,usethesameautomatedfunctionorthesamegroupofautomatedfunctionsforallttleIV-Eeligibilitydeterminations.
(h)Softwareprovisionrequirement.ThettleIV-Eagencymustprovideacopyoftheagency-ownedsoftwarethatis59°| designed,developed,orinstalledwithFFPandassociateddocumentationtothedesignatedfederalrepositorywithintheDepartmentuponrequest.
60| (i)Submissionrequirements.

61| (1)BeforeclaimingfundinginaccordancewithaCCWIScostallocation,attle[V-EagencymustsubmitanAPDor,ifbelowtheAPDsubmissionthresholdsdefinedat45CFR95.611,aNoticeofIntentthatincludes:

9)AdescriptionofhowtheCCWISwillmeettherequirementsinparagraphs(a)through(h)ofthissectionand,ifapplicable§1355.54;
i)AlistofallautomatedfunctionsincludedintheCCWIS;and
ii)Anotationofwhethereachautomatedfunctionlistedinparagraph(i(1)(i)ofthissectionmeets,orwhenimplementeditwillmeetthefollowingrequirements:

65| (A)Theautomatedfunctionsupportsatleastonerequirementofthissectionor,ifapplicable§1355.54;
(B)TheautomatedfunctionisnotduplicatedwithintheCCWISorsystemssupportingchildwelfarecontributingagenciesandisconsistentlyusedbyallchildwelfareusersresponsiblefortheareasupportedbytheautomatedfunction;and
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page49of69
(©TheautomatedfunctioncomplieswiththeCCWISdesignrequirementsdescribedunder§1355,53(a),unlessexemptedinaccordancewith§1355.53(b).

o
68| (2)AnnualAPDUpdatesandOperationalAPDsforCCWISprojectsmustinclude:
a (@AnupdatedlistofallautomatedfunctionsincludedintheCCWIS;
(i)Anotationofwhethereachautomatedfunctionlistedinparagraph(i)(2)i)ofthissectionmeetstherequirementsofparagraph(i)(1)(iii)(B)ofthissection;and
ii)Adescriptionofchangestothescopeorthedesigncriteriadescribedat§1355.53(a)foranyautomatedfunctionlistedin
paragraph(i)(2)(i)ofthissection.

1
© Otherapplicablerequirements.Regulationsat45CFR95.613through95.621and95.626through95.641areapplicabletoallCCWISprojectsbelowtheAPDsubmissionthresholdsat45CFR95.611

70.| (Gi)Anotationofwhethereachautomatedfunctionlistedinparagraph(i)(2)(i)ofthissectionmeetstherequirementsofparagraph(i)(1)(iii)(B)ofthissection;and

(ii)Adescriptionofchangestothescopeorthedesigncriteriadescribedat§1355.53(a)foranyautomated

71| functionlistedinparagraph(i)(2)()ofthissection.
qn.| @Otherapplicablerequirements.Regulationsat45CFR95.613through98.621and95.626through95.641areapplicabletoallCCWISprojectsbelowtheAPDsubmissionthresholdsat45CFR95.611
C152 Additionally,theContractor'ssolutionshallmeet allofthe applicablerequirementsand
applicabledataprivacyandsecurityguidancecontainedintheregulationsbelow:
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS)
Entity
Federal
Federal
Federal
ACF
ACF
ACF
‘ACF88888 8
Regulation,Guidance,or
Statute
Timelyinterstate
PracementofFostering
ChildrenActof2008
PreventingSexTrafficking
andStrengtheningFamilies
Act
‘Section504
Title1V-EFosterCare
FederalGuidanceontheNationalYouthinTransitionDatabase
(NYTD)
FosteringConnectionsto
SuocessandIncreasing
‘AdoptionsActof2008
‘AdoptionandFosterCare
‘AnalysisandReporting
‘System(AFCARS)
TheChildinNeedof
ProtectionAmendmentActof
2004
DCCodeTitle4PublicCareSystems
DCAttendance
‘Accountabilty
‘AmendmentAct
SafeChildrenandSafe
"NeighborhoodsEducational
NeglectMandatoryReporting
‘AmendmentActof2010
D.C.Law13-136,AdoptionandSafeFamilies‘Amendment
‘Actof2000.
CFSAEstablshmentActof
2001
DCMRTitle29
Chapter59
Chapter60
Chapter61
UR
TWwwwapo.gov
wwwcongress.govt13/plaws/pub!183/PLAW-11:
Page50of69
LAW-f09 pubI239/pdfiPLAW-109pub/230
ubl183
httos:/Avwnv.wrightstaw.comvlaw/504/sec504regslinkedpdf
httos:/Avww.acfhs gov/cb/resourceftile-ve-foster-care
wwwacthhs.govicblresoutidence
:lwwwact hhs.govl140-354
https:/hvww.acfhs govleblresourceleuidance
https:beta.codedocouncilus/de/councillaws/docs/15-341pdf
https:fbeta.codedocouncilus/d/counci/codeities/4/
hitto:/timsdocouncl.us/Download/29228/820-0072-SignedActpdf
https:beta.codedocouncilus/de/councillaws/docs/18-242.pdf
hittps:Ibeta.codedocouncilus/dc/oouncillaws/13-136him!
hittps://ctsa.de.gov/sites/defaulfiles/dlsites/ofsa/publication/attachments/foster_home.pdf
https//dcregs.dc.goviCommor/DCMRIChapter“istaspx7titleld=27
lider
slider
httos:ider
is.dc. govlCommon/DCMR/RuleList.asy
3do. qovlCommon/DCMRRulelist.aspx?
is.dc. qovlCommon/DCMR/RuleLisLasy
lum=29-59&Chapterid=2232
lum=29-608Chapterid=2233
lum=29-61&Chapterid=2234
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page51of69

Enfity Regulation,Guidance,or URL
Statute
Dc Chapter 8
Dc ‘Chapter63 Idoregs.de.ymorvDCMRRuleList.aspx?ChapterNNum=29-638Chapterid=2237
Dc FosterParentsStatementshilo:decouncius/Download’3527/B21-0603-SianedActpdf
ofRightsand
Responsibilities
‘AmendmentActof2016
CFSA BillofRightsfor silosde.cov ilkrights-cisa
ChildrenandYouthinFoster
Care
CFSA——_CFSAOfficialPolicies. 38lcfsa.de.qovipagelctsa-online-policy-manual
Courts LaShawnvBary... Ia. 5 Bspecalc LaShawnvBowser... .courtistene
LaShawnConsentDecree_htps:/awjusia.concasestfederalappelate-courslcado'94-7227194-72273-2011.03-24him
Courts DCSuperiorCourtRuleshits:ivwwdecourtsgovisuperor-courtules
GoverningNeglectand
‘AbuseProceeding
Courts SuperiorCourtRulesfor Iw.docourts.qovisuperior-courvrules
DomesticViolence
Courts SuperiorCourtRules hitps:thww.decourtsgovisuperior-courtules
GoverningJuvenile
Proceedings
Courts ‘SuperiorCourtGeneral bhttps:/Awww.decourts.gov/superior-courtirules
RulesoftheFamilyCourt
Courts DCSuperiorCourt hits:hvww.decourtsgovisites/deaultiles/2017-03/07-22.pd
AdministrativeOrder07-22
Other CodeofMaryland http:/ib.quides.umdedulmdlawresourcesiCOMARRegulations
Other InterstaleCompactonthe Hiepestater nfo!
PlacementofChildren.
(icPc)
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page52of69
C16. EXISTINGSYSTEMDESCRIPTIONC161 FACESistheprimarysourceofdataentered,used,andexchangedbyCFSAstaffandour
local,regional,nationalandfederalpartners.CFSAiseagertogainefficienciesandcostsavingswithanewCCWIS.
C.16.2 CFSA’sprocessesarecurrentlysupportedbyacombinationofformalandinformalsystems,centeredon a web-based .NET solution,FACES. This system isused formost of CFSA’s
businessprocessesand isCFSA’s currentCCWIS.
‘©Manyprocesseshoweverareperformedusinginformalsystems(Google
Spreadsheets,QuickBase,paper).© ManyworkersuseFACESasanafter-the-factinformationrepository,rather
thanatoolthatsupportstheirworkdayinreal-time.
* Crucialinteragencyinteractions(e.g.,Federalreporting,communicationswith
thecourts)happenviathedatabaselayerofFACES.
SeeFigure|foradepictionofthecurrentFACESarchitecture.
Allup -IncludingConnectivityand Access

‘ApplicationServersUsingOracleDatabaseEternalgay@~
Users:

Pee radeDatabase‘OnAzureVMlaaSi
a
sh omePielInternal= f OracleDatabase
Users = ‘OnAzureVM laaS

+AllusersareinAD
+VMsatedomainJoined
FigureIFACESArchitecture
C163 FACESiscomprisedofover500functionalscreens,80+userroles,over300reportsfor
approximately400regularusersandover1000totalaccounts.Itisexpectedthatthenew
CCWIS shalldramaticallyreducethenumber ofscreens,duplicativereports,and userroles.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page53of69
C164
C165,
C.16.6
C.17.
CATA
FACES2017Statistics
Tainingfe 15)SystemAdministration‘StatServeReportsProviderWebProviderPlacementEElgbtyInvestigationInacuoraianship‘nance‘courtcontact‘commonFramework‘lentosePian‘Adoption

Module

0 1 2 2% 4 50 6 70 8 9 100NumberofSereens
Figure2FACESStatisties2017
FACEShasgrownorganicallyovertime.FACES’sdatamodeloriginatedfromavendorprojectinOklahomaaspartofaPowerBuilderapplicationinthelate1990s.In2006,anoverhaulportedtheUIfromPowerBuildertoNET.Thedatamodelremainedintact.TheNETimplementationwasuptodatefor2006(ASP.NETpresentationlayer,ADO.NETpersistencelayer,alargelyweb-formsapproachtointeractivity),whichmeansthereisnouseofthemoremodernEntityFramework(introducedin2008).Overtime,thisapproachledtomountingtechnicaldebt,increasingthecomplexityofthesystem.TheFACESdatabasenowhasover1000tables.Therearejustshortofa millionlinesofC#andJavaScriptcodeinthesystem,withalmost200filesthatcontainmorethanathousandlinesofcode.
FamilyFirst
‘AspartoftheenactmentoftheFamilyFirstPreventionServicesAct(FamilyFirst),CFSAneededatooltoreferfamiliestoEvidence-BasedPractice(EBP)providersandtransfercasesandreferralstoCommunityCollaboratives.TheinitialreleasewasmadeOctober1,2019.Atthattime,thereweretwenty-oneEBPProvidersandfiveCollaborativesengaged.Thecustom-builtsolutioninterfaceswithFACES,employsamodular,microservicesorientedarchitecture,andusesReactfortheUserInterface.
ARCHITECTURE
UnderCCWISregulations,statesareencouragedtoleveragemoderntechnologies,
recommendedpracticesandplatformstocreatemodularsystemstailoredtomeettheneedsoftheirrespectivejurisdictions.CFSAisenthusiasticaboutleveragingcurrenttechnologiesandbestpracticesbyworkingwiththeContractortoalignthenewSystemtosupportCFSA’sorganizationalstructure,clinicalpractice,andoperationalprocedures.ThedepictionofthefuturestatearchitectureisrepresentedinFigure3.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS)‘CFSAENHANCEDNOTIONALFUTURE.
®
orstaigy
Page54of69RCHITECTURE
LBS
‘AFCARSNYTO.NCANOSNECE.
ChapinHai
econo
Sa crise

rcitecueChances Modular :
Figure3FutureStateNotionalArchitecture

c.172 CCWISsolutionneedstosupportandbetestedagainstchromebrowser.
C173 MicrosoftshallprepareanddeliverthedesignfortheCCWIS,includingthearchitecture,application,database,andnetworkneedsoftheCCWISwithinAzureDevOps(ADO)userstoriesandwikientries.
C174 ForeachmoduletheContractorwillupdateAzureDevOps(ADO)userstorieswithfunctionalandtechnicaldesignelementsrequiredtocompletetheuserstory.
C18. SYSTEM INTEGRATION
C181 Aspartoftheengagement,integrationswillbedesignedanddevelopedusingAzure

DC AccessSystem(DCAS)
Odyssey(formerlyCourtview)
RXNH ElectronicHealthRecords (CHR)
IntegrationServicesandAzureAppServices.Integrationslistedbelow,oradditionalintegrationsaddedviaadditionaluserstories,aretobeprioritizedbyCFSAandcompletedascapacityallows.
AY Ce

Eligibility
Investigation& CaseManagement
Investigation,Services& CaseManagement
TheCommunityPartnership(TCP)-HomelessCaseManagement

OfficeofAttorneyGeneral(OAG)Case CaseManagementManagementSystemAbacus
ChildandAdolescentFunctionalAssessmentCaseManagement
Scale(CAFAS)/PreschoolandEarlyChildhoodFunctionalAssessmentScale(PECFAS)-MHS
NationalElectronicInterstateCompact Placement/Case Management
Enterpris«e(NIECE)
Officeof StateSuperintendedforEducation —_Services/Case Management
(OSSE)
DistrictIntegratedFinancialSystem(DIFS)Finance
‘US Bank Finance
WellsFargo Finance
TBD
C.19.
C191
Learning(Training)ManagementSystem
SECURITY AND SYSTEM ROLES
‘Thefollowingwillbeobjectivesofdesignanddevelopment.1,MicrosoftDynamics365SecurityModel—BusinessUnits,Hierarchy,Teams(Ownerships),
ModernBUs
2.MicrosoftDynamics365securityroles& webroles
3.MicrosoftDynamics365Security& Auditconfiguration
4, Supporting3"partyaudit
CFSAwillmakeuseofnativeMicrosoftDynamics365securitybymappingexistingorganizationalrolestothesecuritymodelprovidedwithinthesoftware.MicrosoftwillassistinmappingrolestostandardMicrosoftDynamics365securityrolesandcreatecustom
securityrolesasdefinedinthebusinessprocessflowsinbacklog.TheseneedtobefinalizedbeforethestartoftheprojectsothataDC-centricsecuritymodelcanbecreated.
For3rdpartyauditsupport,CFSAwillprioritizethenecessaryuserstoriesandMicrosoftwillcompleteascapacityallows.ThiswillapplytoCFSA-specificconfigurationsand
customizationsthatMicrosoftdevelops.SecurityauditresultsagainstthebaseDynamics365platformwillneedasupportticketcreatedbyCFSA.
Theoverallsecuritydesignwillalsosupporttherestrictedmodelforrole-basedaccessandmanaginghighprofilecasesandlimitingvisibilitytorestrictedfieldssuchasSSN.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page56of69
C.20.
C21.
C211
C212
REPORTING
1.TheContractorshalldevelopthedataqueriesandanalysisneededtofulfilCFSA’sfederalreportingmandateslistedbelow.AllotherreportsanddashboardsaredevelopedbyCFSAwithdataanalystandbusinessanalystsupportfromtheContractor.Allreportsrequiredwillbedocumentedwithinuserstoriesdeveloped,approved,andprioritizedbyCFSA,withintheengagementcapacity.
2.TheAdoptionandFosterCareAnalysisandReportingSystem(AFCARS)isadataquerythateachstatemustcompletebasedonthefederalstandardsbiennially.ThedataobtainedfromstatesareconsolidatedandreportedbytheChildren’sBureau.FiscalYear2021federalreportcanbefoundathttps://www.acf.hhs.gov/cb/report/afcars-report-29
3.TheNationalChildAbuseandNeglectDataSystem(NCANDS)isadataquerythateachstatemustcompletebasedonthefederalstandardsannually.https://www.acf.hhs.gov/cb/fact-sheet/about-neands
4. CaseworkerVisitation
© TechnicalBulletin#2:SystemsIssuesRelatedtoReportingandEvaluatingCaseworkerVisits(hhs.gov)
© Thenationalyouthintransitiondatabase(NYTD)https://www.acfhhs.gov/cb/nytd-reviews-final-reports
5.FamilyFirst—PreventionServicesdatareporting,TitleIV-EPreventionProgram|TheAdministrationforChildrenandFamilies(hhs.gov)
ENVIRONMENTS
Theenvironmentslistedinthefollowingsectionwillbeneededtodeliverthisproject.InstallationresponsibilitypertainstotheinstallationofMicrosoftDynamics365.ThelatestMicrosoftDynamics365implementationguideoutlinessystemrequirementsthataretheCFSA’sresponsibilities(suchasinfrastructureprovisioning,platformprovisioning,andtheinstallationofsoftwareprerequisites).Thisinformationisavailable
onhttps://docs.microsoft.com/en-us/dynamics365/.
Additionally,itistheCFSA’sresponsibilitytoverifythattheenvironmenthasbeenprocuredandsetupintimetomeettheschedulesetforthintheprojectplan.Anydelaystotheprojectschedulecausedbydelaysinavailabilityofhardwareorsoftwareare
subjecttothechangemanagementprocessdescribedinthiscontract.Microsoftwillgive1weeks’noticetotheCFSApriortoanyinfrastructurerequestsforeachoftheenvironmentslistedinthefollowingtable.
MicrosoftwillworkwiththeCFSA’sITstafftocompletethesizingexerciseduring
Productplanning.Thesizingrecommendationfortheenvironmentswillbebasedonthedevelopmentenvironmentconfigurationandquantity.ThiswillbereviewedandacceptedbyboththeCFSAandMicrosoft.
Thefollowingenvironmentswillberequiredtodelivertheproject.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page57of69
EnvironmentType enttg S Pan choy
installation (eos
eros! 7

ConfigEnvironments-Dynamics365 CFSA MicrosoftDevelopDataStartoftheR2 Modeland engagementBusinessLogic
GoldenSource-R2__Dynamics365 CFSA MicrosoftCentral StartoftheConfigurationengagementRepo
DM-R2 Dynamics365 CFSA MicrosoftData StartoftheMigrationengagementSandbox
QAR? Dynamics365 CFSA Microsoft!QASandboxStartoftheengagement
Training-R2 Dynamics365 CFSA MicrosoftCFSA StartoftheTraining engagementenvironment
Performance-R2Dynamics365 CFSA MicrosofPerformanceStartoftheTest engagement
Environment
Note:ItistheCFSA’sresponsibility,withguidancefromMicrosoftTechnicalResourcesandUnifiedEnterpriseSupport,toprovidesupportforenvironmentoperations.MicrosoftwillsetupandconfigureMicrosoftDynamics365andISVsolutionsasapplicable.
C22. AUTHORITY TO OPERATE REQUIREMENTS
C24 Security
22 TheAuthoritytoOperate(ATO)processwillbecoordinatedandownedbyCFSA.MicrosoftwillsupportCFSA’scertificationteamwithdocumentationsupport.RequestsforATOdocumentationwillbecreated,approved,andprioritizedasADOuserstoriesbyCFSA.
23 TheProjectwilluseasingle,comprehensive,integratedrisk-basedframeworkwithprocesses,tools,technology,standardsandbestpracticestodesign,implement,manage,administer,andgovernthesecurityandprivacyofCCWISanddata.
22.4 ThesolutionshallprovideapplicationcontrolstopreventunauthorizeduseofCCWIS,maintainsystemprocesscontrols,andlogalltransactionsandaccesstodata.Inaddition,CCWISshallprovidesecuritytolimitavailabilitytoapplicationfunctionality,software
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page58of69
C225
C.22.6
C227
C228
C229
C2210
C.23,
C231
C232
screens,datarecords,dataelements,anddataelementvalueswhereappropriate.
TheProjectwilluseanapproachforintegratingsecuritywithoverallsystemsecurityusingasinglesign-onbetweensolutionsystems(ifmultiplesystemsareleveragedinthesolution).
TheProjectwillfullydescribetheapproachtosecurity,includingbutnotlimitedtotheuseoffirewallhardwareandsoftware,intrusiondetection/preventionsystems,otherprotectivemeasures,andothermeasuresthatprovideindepthdefensefortheproposedsolution.
Audit
TheProjectwilldesign,develop,andimplementauditingfunctionalitythatmonitorsCCWIS’saccuracyandcompleteness.CCWISshallhavetheabilitytogeneratereportsthatprovidetheDistrictwiththenecessarydatatoconductqualitycontrol,research,andadministrationofprograms.CCWISshallhavetheabilitytoprovidereportsonusers,
securitygroups,roles,settings,passwordsandduplicateIDs.CFSAwilldevelop,approve,andprioritizeuserstorieswiththeseauditrequirements.
‘Audittrailsshallbeavailabletotraceuser-andsystem-initiatedactionsforallupdateandinquirytransactions.Theaudittrailsshallbeavailableforonlineinquiryforuptothree
(3)yearsafterthelastauditableactiononacase.Nomodificationofaudittraildataispermitted.Audittrailsmaybestoredofflineonmachine-readablemediaafterthree(3)yearsfromthelastactivityonacaseorclient.Storeddatashallbereadilyaccessibleinthecaseofaudit,appeals,orlitigation.CFSAwilldevelop,approve,andprioritizeuser
storieswiththeseauditrequirements.
CCWISshallprovidepoint-in-timedisplayofalldataforaudit,verificationandprogramintegritypurposes.CCWISshalldisplaythedatathatwereusedtoapprovelicensesandrenewals,approveclearances,determinesplacement,documentsdiligentsearchefforts,capturesandmanagescaseplanningandoutcomes,particularlyforcaseswherecareis
mandatedbythecourt,documentcontactswithclients,calculateclaimsandrepayments,andgeneratevariousoutputs,includingfinancialtransactions,notices,agreementsandformalnotifications,andestimationreportsforthepointintimethattheparticularactiontookplace.CFSAwilldevelop,approve,andprioritizeuserstorieswiththeseauditrequirements,
APPLICATION PROGRAMMING INTERFACE
CCWISwillsupportthevisionofan integratedtechnicalsolutionthatleveragesanenterprisedataandarchitectureapproach.Thetechnicalsolutionarchitecturewillemployamodulardesign,basedonmicroservicesandAPIs.TheContractorwillimplementasystem
architecturethatisconsistentwiththevisionofCCWISbasedonuserstoriesdeveloped,approved,andprioritizedbyCFSA.
CFSAconsidersamodularbusiness/functionalAPIasacriticalrequirementforde-riskingtheabilitytoreceivethefunctionalandregulatorvaluesoughtandthetechnicalapproachfromthevendor.ThemodularitysoughtistoallowCFSAto:
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page59of69
C233,
C2331
C.23.3.2
C24,
C241
C242
C.24.3
C25.
‘©Changeacomponentinamodulewithouthavingtostartfromthebeginning
ofmodulardevelopment.
The dataflow between modules can be changed withoutintroducing
defects.
SpecificInterfaces
CFSAhasidentifiedsystemsthatshallbeleveragedassystemofrecordsourcesanddescribedintheSystemIntegrationsectionofthisContract,Whilethislistisextensive,duringYear1,additionalinterfaceopportunitiesmaybeidentified.IftheDistrictorders
implementationofan additionalinterfaceandtheimplementationimpactsthetimelineand/orincreasesthecostsorscope,thenContractorisentitledtosubmitachangeorder.
TheContractorwillworkwithCFSACISATechnicalstafftodesignanddevelopappropriate
interfacestosupportthetransmissionofdatabothinandoutofCCWIS.CFSAwillberesponsibleforobtainingnecessarytechnicalinterfacespecificationsandaccessauthorizationfromsystemowners.NotethattheselectedContractorwillnotberesponsibleformodifyingthesystemswithwhichCCWISwillinterfacetoenabletheseinterfacestofunction;however,thecapabilitiesoftheothersystemsshallbetakenintoaccountwhentheinterfacesare
designed.CFSAwilldevelop,approve,andprioritizeuserstorieswiththeseinterfacerequirements.
FINAL BUSINESS PRODUCT PER MODULE
Basedoncreated,approved,andprioritizeduserstories,theContractorshallprovideCFSAdocumentationoftheCCWISsolutiondeliveredforeachmodulerelease,includinghosting
andlicensedsoftwareanddata.
EachModulemaybeaccompaniedbythefollowingdocumentation:
Modulenameandnumericidentification;
Modulenarrative,includingeachfunctionorfeatureofthemodule;
Moduleflowcharts,identifyingeachinput,output,anddata;
Listingsofeditsandauditsappliedtoeachinputitem,includingdetailededitlogic,affecteddata,suspenseandoverridedata,andcorrespondingerrormessages;program.documentation;DetailedlogicforallclaimsorsubsidypaymentsprocessedbytheSystem;
Lists,byidentifyingnames,ofallfiles,inputs,andoutputswithcross-referencestotheprogramsinwhichtheyareused.
eeeau
AzureDevOpswillcontainacomprehensivedataelementdictionaryforallmodules,builtover time and in synch with the deliverywillinclude,for each data element:
A uniguedataclementnumber
A standarddataelementname
A narrativedescriptionofthedataelementA listofdatanamesusedtodescribethedataelement,
Atableofvaluesforeachdataelement
yaene
REQUIREMENTS TRACEABILITY MATRIX
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page60of 69

C251 TheRequirementsTraceabilityMatrixistheultimateartifacttorepresentallofthetraceabilitymaintainedsincetheprojectstartedandshouldbecontinuouslyupdatedtomatchwhatisactuallybeingputintoproduction.TheRequirementsTraceabilityMatrixshouldthusbecomprehensiveandconclusive.CFSAandMicrosoftwillworkonthisastheprogramprogressesandCFSAwillvalidateforcompleteness.TheRTM willbedocumentedinAzureDevOpsasEpics,Features,andUserStories.
C.26. CCWIS TECHNICAL ASSISTANCE PROCESS
C261 TheContractormayassistongoingTechnicalAssistance(TA)providedthroughthe
AdministrationforChildrenandFamilies(ACF)activitiesandTA monitoringreviewsmay
occurthroughouttheprojectlifecycle(planning,development,implementation,and
operations)andarelargelybasedonkeymilestones,automatedfunctions,andscheduled
activitiesapprovedintheagency’sAPD.ACF providessuchongoingreviews,assessments,
andinspectionsthroughacollaborativeTA processthattypicallyoccursduringregular
monthlyteleconferencesbutmay alsobe offeredthroughwebinars,remotesystem
demonstrations,training,agency-specificrequests,andscheduledonsiteorvirtualvisits
(calledhereafterthe“TAprocess,”“TAactivities,”and“TAmonitoringreviews”).AnyTA
activitieswillbedocumentedasuserstoriesinAzureDevOpsandapprovedTAuserstories
willconsumeavailableengagementcapacity.
26.2 ThegoalsandfunctionsofTA activitiesandTA monitoringreviewsarenotmutually
exclusiveandmayoverlapbasedontimingortypeofproject.Table1belowprovidessome
examplesoftheTA activitycategories.
263 Table1:CategoriesofTechnicalAssistanceActivities
TA Activities Self-Assessment Tools | TA Monitoring CCWIS Assessment
Reviews Review(CAR)
‘Capacitybuilding ‘Complianceandsystem|OperationalizesEarlyidentificationof_|integration
regulationsand potentialcompliance
programrequirements_| issues
‘©AgencyorACF | Voluntary © Point-in-time, ‘Typically
initiatedtoexplore| ¢ Sixprogramtools team-basedreview completedonetoTAoptionsor * Ninesystemtools| * Iterative twoyearsaftera
trainingneeds © Can beusedin © Onsiteorremote CCWIS isfully
* Asneededor planningthrough | Onemoduleor operational
planned, post-production many * Buildson+ Varietyofmediums| Includesresources| Designand/or observationsfrom
(phonecalls, andadditional program TAmonitoring
demonstrations, considerations © Focusofreviewis reviews
webinars,etc.) © Strengthensthe negotiated © Interviewswith
+ Technology, connectionbetween| ¢ Interviewsheld stakeholdersandProject programand whenpossible endusers
‘management, technology © Summaryletter| * Focusisonand/orprogram issued outstandingissuesrelated
C264 ‘ACFhasdesignedtheTA andTA monitoringreviewprocesstobeflexibleandsome
differenceswillexistinthetimingandscopeofactivitiesdependingontheagencies’choice
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page61of69
totransitionorbuildanewsystem.
**END SECTION C**
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page62of69
SECTION D PACKAGING AND MARKING
See Attachment J.6-Terms and Conditions
**END SECTION D**
SECTION E INSPECTION AND ACCEPTANCE
See Attachment J.6 - Terms and Conditions
**END SECTION E**
SECTION F PERIOD OF PERFORMANCE AND DELIVERABLES
Fl TERM OF CONTRACT
Fld The termof this contractshallbe fora periodof one (1)base years from the date of
award,subjecttotheavailabilityoffundsforanyperiodbeyondtheendoftheDistrict’sfiscalyear,whichbeginsonOctober1,inwhichthiscontractisawarded.
OPTION TO EXTEND THE TERM OF THECONTRACT
Faz TheDistrictmayextendthetermofthiscontractforaperiodofFour(4)one-yearoptionperiods,orsuccessivefractionsthereof,bywrittennoticetotheContractorbeforetheexpirationofthecontract;providedthattheDistrictwillgivetheContractorpreliminarywrittennoticeofitsintenttoextendatleastthirty(30)daysbeforethecontractexpires.ThepreliminarynoticedoesnotcommittheDistricttoanextension.
Theexerciseofthisoptionissubjecttotheavailabilityoffundsatthetimeoftheexerciseofthisoption.TheContractormaywaivethethirty(30)daypreliminarynoticerequirementbyprovidingawrittenwaivertotheContractingOfficerpriortoexpirationof the contract.
FA3 IftheDistrictexercisesthisoption,theextendedcontractshallbeconsideredtoincludethisoptionprovision.
Fd ThepricefortheoptionperiodshallbeasspecifiedinSectionBofthecontract.Foroptionyears,theDistrictacknowledgesthatcostsforthatoptionyearwillbeMicrosoft’s
then-currentpublishedpricelistrates.
FAS Thetotaldurationofthiscontract,includingtheexerciseofanyoptionsunder
thisclause,shallnotexceedfive(5)years.
F2 DELIVERABLES
P21 TheContractorshallperformtheactivitiesrequiredtosuccessfullycompletetheDistrict’srequirementsand submiteach deliverabletotheContractAdministrator
(CA) identifiedinsectionG inaccordancewiththefollowingtableofdeliverables:

DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page63of69

pete eBay poets Ds
No. (CLIN) Name
0001-00010; C 3.14 Timesheet Timesheet Labor Timesheet Weekly
**END SECTION F**
SECTION G CONTRACT ADMINISTRATION
G1 INVOICEPAYMENT
Gal TheDistrictwillmakepaymentstotheContractor,uponthesubmissionofproperinvoices,atthepricesstipulatedinthiscontract,servicesperformedandaccepted,lessanydiscounts,allowancesoradjustmentsprovidedforinthiscontract.
Giz TheDistrictwillpaytheContractoronorbeforethe30 dayafterreceivingaproperinvoicefromtheContractor.
G2 INVOICE SUBMITTAL
G24 TheContractorshallcreateandsubmitpaymentrequestsinanelectronicformat
throughtheDC VendorPortal,HTT PS://VENDORPORTAL.DC.GOV
G22 TheContractorshallsubmitproperinvoicesonamonthlybasisorasotherwise
specifiedinSectionG.
G23 TheinvoiceswillbesupportedbyweeklytimecardsapprovedbyCFSA.
G24 Toconstituteaproperinvoice,theContractorshallenterallrequiredinformation
intothePortalafterselectingtheapplicablepurchaseordernumberwhichislistedontheContractor'sprofile.
G3 PAYMENT
Unlessotherwisespecifiedinthiscontract,paymentwillbemadeonpartialdeliveriesofservicesacceptedbytheDistrictif:
@) Theamountdueonthedeliverieswarrantsit;or
b) TheContractorrequestsitandtheamountdueonthedeliveriesisinaccordancewiththefollowing:
* ForCLINs0001through00010,paymentwillbemadebased
onhoursconsumedinaccordancewithSectionB.3.3,andasdetailedin the Attachment J.10 Work Order# GVS0235-434536-
549249,August 28,2023 (10/28/23—6/29/24).
* ForCLIN00011,paymentforasneededtravelexpenseswill
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page64of69
GA
G41
GALL
GALA
G4Al12
G4121
GA13
G5
G31
G6
G61
G62
be made as a reimbursementto the Contractor,in accordance
with the FederalGSA Per Diem rates,and as detailedin the
AttachmentJ.10WorkOrder##GVS0235-434536-549249,August
28,2023(10/28/23-6/29/24).
©) Presentationofa properlyexecutedinvoice.
THE QUICK PAYMENT ACT
InterestPenaltiestoContractors
TheDistrictwillpayinterestpenaltiesonamountsduetotheContractorundertheQuickPaymentAct,D.C.OfficialCode§2-21.01etseq.,asamended,fortheperiodbeginningonthedayaftertherequiredpaymentdateandendingonthedateonwhich
paymentoftheamountismade.Interestshallbecalculatedattherateofatleast1%permonth,Nointerestpenaltyshalllbepaidifpaymentforthecompleteddeliveryoftheitemofpropertyorserviceismadeonorbeforetherequiredpaymentdate.Therequiredpaymentdateshalllbe:
Thedateonwhichpaymentisdueunderthetermsofthiscontract;30calendardays,excludinglegalholidays,afterreceiptofa properinvoicefortheamountofthepaymentdue.
NointerestpenaltyshallbeduetotheContractorifpaymentforthecompleteddeliveryofgoodsorservicesismadeonorbefore:
15thdayafteranyotherrequiredpaymentdate.
Anyamountofaninterestpenaltywhichremainsunpaidattheendofany30-dayperiodshallbeaddedtotheprincipalamountofthedebtandthereafterinterestpenaltiesshallaccrue on the added amount.
CONTRACTING OFFICER (CO)
ContractswillbeenteredintoandsignedonbehalfoftheDistrictonlybycontracting
officers.ThecontactinformationfortheContractingOfficeris:EbonyTerrell
AgencyChiefContractingOfficerChildandFamilyServicesAgency
200IStreet,SE,Suite2031Washington,DC 20003Ebony.Terrell@dc.gov
AUTHORIZED CHANGES BY THE CONTRACTING OFFICER
TheCO istheonlypersonauthorizedtoapprovechangesinanyoftherequirementsofthiscontract.
TheContractorshallnotcomplywithanyorder,directiveorrequestthatchangesormodifiestherequirementsofthiscontract,unlessissuedinwritingandsignedbytheCO.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page65of69
G63
G7
G71
G72
G73
G74
GIS
G76
G77
G78
G.781
G.782
G783
G.784
G785
IntheeventtheContractoreffectsanychangeattheinstructionorrequestofanypersonotherthantheCO,thechangewillbeconsideredtohavebeenmadewithout
authorityandnoadjustmentwillbemadeinthecontractpricetocoveranycostincreaseincurredasaresultthereof.
CONTRACT ADMINISTRATOR (CA)
TheCA isresponsibleforgeneraladministrationofthecontractandadvisingtheCOastotheContractor’scomplianceornoncompliancewiththecontract.TheCA hastheresponsibilityofensuringtheworkconformstotherequirementsofthecontractand
suchotherresponsibilitiesandauthoritiesasmaybespecifiedinthecontract.Theseinclude:
KeepingtheCO fullyinformedofanytechnicalorcontractualdifficultiesencounteredduringtheperformanceperiodandadvisingtheCOofanypotentialproblemareasunderthecontract;
CoordinatingsiteentryforContractorpersonnel,ifapplicable;
ReviewinginvoicesforcompletedworkandrecommendingapprovalbytheCOiftheContractor’scostsareconsistentwiththenegotiatedamountsandprogressissatisfactoryandcommensuratewiththerateofexpenditure;
Reviewingandapprovinginvoicesfordeliverablestoensurereceiptofgoodsandservices.Thisincludesthetimelyprocessingofinvoicesandvouchersinaccordance
withtheDistrict’spaymentprovisions;and
Maintainingafilethatincludesallcontractcorrespondence,modifications,recordsofinspections(site,data,equipment)andinvoiceorvouchers.
The addressandtelephonenumber oftheCA is:
SureshChandran,CCWISProgramManager
200IStreetSESuite3404Washington,DC 200032027278095Suresh.chandran@dc.gov
The CA shallNOT have theauthorityto:
Award,agreeto,orsignanycontract,deliveryorderortaskorder.OnlytheCOshallmake contractualagreements, commitments or modifications;
Grant deviationsfrom or waive any of theterms and conditionsof thecontract;
Increasethedollarlimitofthecontractor authorizework beyond thedollarlimitof
thecontract,
AuthorizetheexpenditureoffundsbytheContractor;
Changetheperiodofperformance;or
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page66of 69
G.786
G19
G8
G9
G10
Gil
GALL
GA12
GAL3
GAL4
GALS
G16
GALT
‘AuthorizetheuseofDistrictproperty,exceptasspecifiedunderthecontract.
TheContractorwillbefullyresponsibleforanychangesnotauthorizedinadvance,in
writing,bytheCO;maybedeniedcompensationorotherreliefforanyadditionalworkperformedthatisnotsoauthorized;andmayalsoberequired,atnoadditionalcosttotheDistrict,totakeallcorrectiveactionnecessitatedbyreasonoftheunauthorizedchanges.
(RESERVED)
(RESERVED)
HIPAAPRIVACYCOMPLIANCE
HOURLY RATE CEILING
TheceilingsforspecifiedhourlyrateitemsaresetforthinSectionB.3.3
(PriceSchedule)forallcontractyears.
The hourlyratesinthiscontractshallbe fullyloadedand includewages,overhead,generaland
administrativeexpenses,and profitand thetotalcosttotheDistrictshallnot exceed theceilings
specifiedinSectionB.3.3(PriceSchedule)travelcostarenot includedinthehourlyrate.
TheContractoragreestouseitsbesteffortstoperformtheworkspecifiedinthis,contractandtomeetallobligationsunderthiscontractwithinthehourlyrate
ceilings.
TheContractormustnotifytheCO,inwriting,wheneverithasreasontobelievethatthetotalcostforthehourlyrateitemsofthiscontractwillbeeithergreaterorsubstantiallylessthanthehourlyrateceilings.
As partofthenotification,theContractormust providetheCOa revised estimateof
thetotalcostof thehourlyrateitemsof thiscontract.
TheDistrictisnotobligatedtoreimbursetheContractorforhourlyratesincurredinexcessofthehourlyrateceilingsspecifiedinSectionB.3.3,andtheContractorisnotobligatedtocontinueprovidinghourlyrateitemsunderthiscontract(includingactions
undertheTerminationclausesofthiscontract),orotherwiseincurcostsinexcessofthehourlyrateceilingsspecifiedinSectionB.3.3),untiltheCO notifiestheContractor,inwriting,thattheestimatedcosthasbeenincreasedandprovidesrevisedhourlyrateceilingsforthehourlyrateitemsinthiscontract.

Nonotice,communication,orrepresentationinanyformfromanypersonotherthantheCO shallchangethehourlyrateceilings.Intheabsenceofthespecifiednotice,theDistrictisnotobligatedtoreimbursetheContractorforanycostsinexcessofthe
hourlyrateceilings,whethersuchcostswereincurredduringthecourseofcontractperformanceorasaresultoftermination,
IfanyhourlyrateceilingspecifiedinSectionB.3.3(PriceSchedule)isincreased,anycoststheContractorincursbeforetheincreasethatareinexcessoftheprevioushourlyrateceilingsshallbeallowabletothesameextentasifincurredafterward,unlesstheCOissuesaterminationorothernoticedirectingthattheincreaseissolelytocoverterminationorotherspecifiedexpenses.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page67of69
GAL8 ‘Achangeordershallnotbeconsideredanauthorizationtoexceedtheapplicablehourly
rateceilingsspecifiedinSectionB.3.3(PriceSchedule),unlessthechangeorderspecificallyincreasesthehourlyrateceiling.
** END SECTION G **
SECTION H SPECIAL CONTRACT REQUIREMENTS
Hl
HAA
HA2
HA3
14
HAS
16
‘HA1.7
HAS
HAS
‘H.1.10
HALAL
DISTRICT RESPONSIBILITIES
The Districtwillmonitor the Contractor’seffortsand account forallwork to
beperformedbyContractorpersonnel.
TheDistrictwillprovideworkingspaceandwillassignworktobedoneona full-time
basisto supportpost-turnoveractivity.
TheDistrictreservestherighttoapproveordisapprovereplacementofkeypersonnel(asdescribedinsectionC.7.1)priortotheirassignmenttoCCWISproject.
TheDistrictwillhavetherighttorequiretheContractortoremoveanypersonnelfromassignmenttothisprojectforfailuretoperformtheirdailyfunctions,asagreedbetweentheDistrictandtheContractor.TheDistrictwillprovidea10-businessdaynoticefortheContractortoworkwiththeresourceonanimprovementplanandifnoimprovementontheagreedimprovementplan,thecontractorPMOwillremovetheresource.
TheDistrictwillmaintainCrystalReportsforFACES,untilsuchtimeastheAgencycantransitiontoanotherBIplatform.
The DistrictwillnotifytheContractorifthegovernance structureof CFSA evolves.
TheDistrictwillmakesubjectmatterexperts(SMEs)availabletoprovidecontentknowledgefromafunctional,businessandtechnicalperspective.
Forkeypersonnel(asdescribedinsectionC.7.1)theDistrictwill,withinfive(5)businessdaysafterreceiptoftheproposedreplacementcandidateresume,contacttheProjectManagertostateifaproposedcandidatehasbeenrejecteduponreviewoftheirresume,andinterviewifapplicable.
The Districtwillprovidelimitedofficespaceand facilitiestotheContractor,as needed.
The Districtwillmanage thecommunication withACF relatedto
CCWISimplementation.
‘TheDistrictwillprovideaSharePointsiteformanagementofprojectdocumentationandcalendar.
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page68of69
#H.1.12
HLL.13
H2
H21
H23
H25
26
TheDistrictandtheContractorkeepallinformationrelatingtoanyemployeeorCFSA
oftheDistrictortheContractorinconfidenceandwillnotusetheinformationinconnectionwithanyothermatters;norwillitdiscloseanysuchinformationtoanyotherperson,firmorcorporation,inaccordancewiththeDistrictandfederallawsgoverningtheconfidentialityofrecords.
The Districtwillconductelectronicauditspursuantto Section18of theSCP.
CONTRACTOR RESPONSIBILITIES
The Contractorshallprovideateam ofskilledresourcestomeet theneeds of
thecontract.
TheContractorprojectmanagementteamshallincludequalifiedandexperiencedprojectmanagersthatwillbeabletoprovidereal-timestatusofallactivitiestotheDistrictteam.
TheContractorshallprovideresourcesbasedondirectionofCFSAleadershipincludingprojectmanagement,architecture,design,engineering,systemsecurity,testing,documentation,andconfigurationmanagement.
TheContractorshallmakeallsubmissionson-time,ifthisisnotpossible,theContractorwillprovidetheDistrictaminimumof7-daysadvancenoticethatwillincludeconsequencesandreasonsforthedelay.
TheContractorshallmaketimelypaymentstoanyconsultantsandsubcontractors.
TheContractorshallprovidespace,equipmentandtoolsfortheirteamtoperform
tasksfortheproject.
** END SECTION H **
SECTIONI CLAUSES
See Attachment J.6-Terms and Conditions
** END SECTION I **
DCRL-2023-F-0071ComprehensiveChildWelfareInformationSystem(CCWIS) Page69of69
SECTION J ATTACHMENTS

SA LISTING
JAA Thefollowinglistofattachmentsisincorporatedintothecontractbyreference:
Attachment De t
Number rocument
‘GovernmentoftheDistrictofColumbiaStandardContractProvisionsforUsewiththeSuppliesJA andServicesContracts(July2010)availableatwww.ocp.de.govclickon“SolicitationDocuments”
US.DepartmentofLaborWageDeterminationNo.:2015-4281RevisionNo.:27,datedJ2 June30,2023
J3 ScopeofWorkdated6/19/23(6/30/23—10/27/23)
V4 WorkOrder##GVS0235-434536-549249,datedJune19,2023fortheCCWIS/STAANDLetterContract
Js PriceSchedule(6/30/23—10/27/23)
J6 TermsandConditions
WW ‘WaytoWorkAmendmentActof2006-LivingWageNoticeavailableatwww.ocp.de.gov_clickon“SolicitationDocuments”
18 ‘WaytoWorkAmendmentActof2006-LivingWageFactSheetavailableatwww.ocp.de.govclickon“SolicitationDocuments”
I9 MicrosoftCorporation’sResponsetoCFSAQuestionsReferenceVITATermandConditions
J.10 WorkOrder##GVS0235-434536-549249,August28,2023(10/28/23—6/29/24)
Jl RESERVED
Jaz CFSACCWISStaffingWorksheet
S13 ACF TechnicalReview
S14 PersonnelExperience
J.15 CFSACurrentBusinessProcesses
16 DC CFSA DC DataPolicy
SAT TechnicalReferenceFrameworkv2
518 FunctionalReferenceFrameworkv2
**END SECTION J**