Business Requirements - Home | California Dept. of Social ...



Business RequirementsThis section contains all business requirements to support the design, development, testing, implementation, and maintenance of the CECRIS. The State will be responsible to fulfill the business requriements. The business requirements are divided into the following requirements sets: CECRIS Claim Template Capture County Allocations Administrative and Assistance Claim Expenditure Coding Structure Calculate and Distribute Advances Submit Claim Receive and Audit Claim Process Payments Year End Processing State and Federal Fiscal Year Close OutReportingUser AccessData MigrationEach requirements set begins with a background discussion that provides the general information and context for the particular requirements set. The requirements are presented in table format, and there is a table for each requirements set. Some requirements sets are further subdivided as appropriate.CECRIS Claim TemplateThis section presents business requirements related to the claim format and associated data elements.Where applicable, the specific claim type is identified. If claim or claims is used without specifying a type, it applies to all claim types.The counties submit claims for assistance costs and administrative costs. Assistance costs refer to the actual benefit payments issued to recipients. Monthly claims for assistance costs are submitted monthly by the 20th following the reporting month. Approved, audited costs are paid within forty days after submission or the 20th.The counties submit, on a quarterly basis, an administrative claim for expenses associated with managing these programs. Cost categories include, but are not limited to, staff salaries and benefits, training, information technology services and equipment, client services and facilities. Quarterly administrative claims are submitted no later than 30 days after the end of the reporting quarter. The audited costs are approved and paid within 75 days after submission.In both claim types, costs are captured primarily by aid code (assistance) or program code (PC) (administrative). Depending on the assistance or administrative claim, additional information is needed such as caseload, person count, etc. In addition, each aid code or PC has a sharing ratio (federal share, state share, realignment share, reimbursement share and/or county share) and that sharing ratio can differ amongst aid code and PC. Finally, because not all counties are eligible for submitting costs for a specific aid code or PC, controls must be in place to prevent a county from submitting unallowable costs.Due to changes in state and federal statute and regulations, the claim data elements can change. This can include the addition, deletion or modification of an aid code or PC, sharing ratio, eligible counties and other elements. The system must allow authorized users to modify aspects of claim data elements.Because counties may have missed costs in a previous claim or need to correct costs in previously submitted claims, the system must retain the entire history of an audited claim in the event costs must later be submitted for a period in the past (e.g., amend the quarterly administrative claim nine (9) months after the due date of the original claim, or amend the monthly assistance claim no later than 18 months after the submittal of the original claim). Therefore, the system must ensure the correct aid code or PC and their associated business rules are still present for previous periods. The system must also ensure the correct codes and business rules are present for the return of funds beyond this period in the event of an audit finding.Claim Template Requirements#RequirementThe system shall implement monthly Claim Templates in a manner that allows dynamic addition, expiration and modification of fields and layout by authorized system users.Where possible, the fields and attributes described in following requirements of the Claim Templates shall be implemented in a dynamic fashion, allowing addition, expiration and modification of the Claim Templates from month to month.Field codes shall be implemented in a manner that allows for dynamic addition, expiration and modification of codes.The system shall contain a template for each of the following monthly assistance claim types, including at a minimum:Monthly assistanceSupplemental monthly assistanceType of Program claim (i.e., CalWORKs, Foster Care, Extended Foster Care, etc.)Projected monthly assistanceYear-end and close-out monthly assistancei. Federalii. Stateiii. Calendar YearTitle IV-E Waiver claimOut of sequence claim (SOC 812, etc.)Pilot Project Claims (RBS, etc.)The system shall contain a template for each of the following quarterly administrative claim types, including at a minimum:Quarterly administrative expenseSupplemental quarterly administrative expenseQuarterly Pilot program (e.g. RBS, IV-E Waiver) and future pilot program expenses Quarterly Administrative Title IV-E Waiver claimProjected quarterly administrative expenseYear-end and close-out administrative expenseState Fiscal YearFederal Fiscal YearCalendar YearOut of sequence Claim (e.g., SOC 812, etc.)For each monthly assistance and quarterly administrative claim type, the system shall capture the following county data elements:County Name County Number Fiscal year (State and Federal) and calendar year– 4 digitClaim month and year/quarter and yearSubmission date by countyClaim typeName of county welfare director including signatureName of county auditor including signatureName of county contactName of county claim preparerTelephone number of county contactE-mail address of county contactCounty’s USPS mailing addressTotal expenditure by federal, state and county shareFor each monthly assistance and quarterly administrative claim type, the system shall capture the following reporting period information:Fiscal year (State and Federal) or Calendar YearReporting periodClaim type (e.g., original, adjustment, supplemental, etc.)The system shall allow a county to submit a positive or negative retroactive claim. The system shall limit the period and frequency in which a county may submit retroactive positive adjustment claims up to 18 months (assistance) or nine (9) months (administrative) after the original reporting period. The system shall allow an authorized user to override the claiming period if necessaryThe system shall not limit the period in which a county may submit a retroactive (or corrected) negative claim after the original reporting period.The system shall allow an authorized user to produce a certification letter for the claim and allow that user to print the cover letter upon demand.The system shall retain an electronic copy of the certification letter and associate it to the specific claim.For each aid code within an assistance claim, the system shall capture one or more of the following data elements:Program nameAid code nameAid code numberAid code type (federal program/non-federal program)Benefit costAdministrative costCost by payrollCost by cancelled paymentCase typePerson countCase countTime Study hoursFunding sourceSummary by funding Sharing RatioRate calculation formulaRecovery of aid / OverpaymentsNumber of federal assistance unitsAssistance unitCosts by grant paymentsCosts by wage subsidyCosts by periodFacility typeCost for prior month negative adjustmentCost for prior month positive adjustmentCost for monitoring adjustment by periodCost by overpayment statusBudget allocation amountOverpayment codeWaiver/Non-Waiver codeAny new requirements as a result of regulatory or statutory changesState budgetary information/federal budgetary informationFor each facility within a monthly assistance claim, the system shall capture one or more of the following data elements:Facility/group home nameCost by PeriodType of cost (admin/non-admin)Person countSharing ratio (fed/non-fed)ProgramPayment typeLocationAid code nameAid code numberCase typeCase countGroup home facility numberFoster Family Agency facility numberFoster Family Agency Social Worker Time Study hoursTransitional Housing Placement Program Plus (THP+FC)Facility rateFacility approved bed countAny new requirements as a result of regulatory or statutory changesFor each quarterly administrative claim, the system shall capture costs for the following functions:Social ServicesCalWORKS (California Work Opportunity and Responsibility to Kids)Other Public WelfareChild CareNon-welfareGenericAny new function category as a result of regulatory or statutory changesThe system shall allow a state authorized user to add, delete, activate, deactivate and/or modify an aid and/or program code.The system shall allow a state authorized user to add, delete and/or modify funding sources within an aid and/or program code.For each quarterly administrative claim, the system shall capture any of the following data elements for each function:Caseload typeCaseload count (fed/non-fed)Person count (fed/non-fed)CFAP – Single countCalWork Case loadTwo parent families CaseloadPublic Asisstance Cal-Fresh CasesSupport staff costsGeneral administrationProgram administrationClericalSSTRP support staff hoursNon-SSTRP support staff salariesDirect charge/cluster program codesFull time equivalent calculationsSupport operating costsTravelSpaceOther operating costsPurchase of servicePublic/private agency direct bill-non CCAPInformation technology costsProgram titleProgram codeDevelopment costMaintenance costSACWIS (Statewide Automated Child Welfare Information System) costNon-SACWIS costStaff development costsPersonal services/operatingPurchase of service/direct cost of traineesExtraneous costsTime study hours Caseworker Salary and BenefitsCaseworker ratioFull-Time Equivalent CountDirect costProgram codeProgram nameProgram typeApproved plans (e.g., A-87, SSTRP, APDs, ATPs, Training Plans, Letter of Intent) that must be received prior to incurring expenditures.Cluster codes for support staffWaiver/Non-Waiver costDiscount RatioAny new requirements as a result of regulatory or statutory changesAddendums Emergency and Disaster costs and/or codesThe system shall capture the following information for each county technology maintenance project:Project nameProject numberProject costProject allocation (approved budget amount)Project time limitProject running balanceAdministrative costThe system shall capture the following information for each technology maintenance project:Project nameProject numberProject costProject allocationProject time limitProject running balanceAdministrative costThe system shall capture APD approval letters to record authority to spend.The system shall allow for expandability in order to accommodate regulatory and statuory changes.The system shall capture the following for each aid or program code:Effective start dateEffective end dateCommentDate of addition, edit or deletionProgram cost account codeFederal Catalogue NumberFunding sharing ratioFunding ratio validationApplicable program/claimWaiver identifierEligible countiesTitle XXDifferentiate and separate staff development and training from goods and servicesFunctionMaintenance of Effort (MOE) or Non-MOEAssistance or Non-AssistanceLedger(s) associated with the Program Code or Aid CodeTime Study Codes associated with Program CodePINs associated with Program CodeSingle Funding Crosswalk TitleAdmin or Non-AdminCounty Welfare Department or Probation identifier Suspension Period Direct to Program costsAny new requirements as a result of regulatory or statutory changesThe system shall record amounts in whole dollars.The system shall round calculations to the nearest whole dollar.The system shall based on the business rules calculate the appropriate ratio. The system shall based on business rules disburse the charges accordingly. For example should $99 be entered and the ratio is 50/50 then $49 shall be billed to the federal government and $50 to the State. The system shall allow overriding of calculated values to account for rounding errors. The system shall allow an authorized user to add, delete, activate, deactivate and modify data elements on a claim template. This includes the ability to add, delete, activate, deactivate and modify and disable cost allocation methodologies and case/persons counts and associated ratios.The system shall allow an authorized user to verify edits, additions, inactivations and/or deletions to claim before saving them.The system shall allow an authorized user to save a modified claim template.The system shall track changes to claim templates and data elements within a claim including, at a minimum:Type of changeDate of changeUser making changeReason for change (including, at a minimum audit findings, state or federal statute change)Each version of a claim shall have an effective county completion and submission date.When an authorized user selects a claim reporting period, the system shall present the claim template that is effective for that reporting period.The system shall allow an authorized user to test a claim template with sample data. This includes testing Program Request Form changes to the system prior to implementation.Capture County AllocationsEach county is given a fiscal year allocation for most programs it provides. These budget allocations are calculated using a methodology that is jointly developed by the CDSS and the County Welfare Directors Association. The resulting allocations will be captured in CECRIS and used as the starting balance for future county costs that are claimed for the State or Federal fiscal year.During the course of a fiscal year, there may be changes to the State budget that may result in changes to the county allocation. Changes to a county’s individual budget allocation can also occur as a result of redistribution of funds between counties.County Allocation Requirements#RequirementThe system shall store the total statewide budget allocation for a program.The system shall store a county’s program budget allocation.The system shall record debits and credits to a county program budget allocation and maintain the running total of a county and statewide program budget allocation.Upon user request, the system shall identify budget allocations not being expended by:Program (statewide)CountyThe system shall record and monitor a program budget allocation amount for state-level and federal-level operations.The system shall allow a State user to add, delete and modify a county’s program budget allocation and capture:AmountType of allocation (augmentation, calculated, redistribution, etc.)Date of journal entryReason UserApproved byThe system shall allow an authorized user to compare current fiscal year budget allocations to previous years’ budget allocations by:Program (statewide)CountyThe system shall allow an authorized state user to upload budget allocations from a data file in formats including but not limited to CSV and Microsoft Excel. The system shall generate an automatic reminder to authorized users to update budget allocations annually.The system shall generate an automatic reminder to close out allocations.Administrative and Assistance Claim Expenditure Coding StructureThis section presents information on how expenditures are currently captured and associated requirements.The highest level of how funds are budgeted is called an appropriation. Currently, the CDSS has at least 13 appropriations. Within an appropriation are one or more Program Cost Accounts (PCA) codes. Within a PCA, codes are either program or aid codes. A PCA code will never contain both a program and an aid code. Counties use program codes and aid codes to enter administrative expense and assistance claim costs, respectively. Within a program code, there are several sub-codes that counties use to report expenditures:Time study code: A program code may contain one (1) or more time study codesSupport staff code: A program code may contain one (1) or more support staff codesProgram identifier number code: A program code may contain one (1) or more program identifier number codesGeneric code: Costs that are general administrative in nature, have department-wide benefit, or costs that cannot be reasonably identified as benefiting a specific program or group of programsCounties use aid codes to report assistance costs. Although aid codes currently do not have any sub-codes, solution must have the ability to configure to add sub-codes or an expanded field. The table below presents information on the various codes used.Table 6.1, Current Administrative and Assistance Claims CodesTerm (Acronym)Administrative or AssistanceDefinitionCurrent StructureAppropriationBothThe line item in the budget where the funding is. There are currently at least 13 appropriations. Expenditures are paid from the appropriation.Fund (4 digits) +Ref number (3 digits) + Program (2 digits) + Element (3 digits)Program Cost Account Code(PCA Code)BothA code to track expenditures in CALSTARS. A PCA code can have many program or aid codes.5 digitsCatalog of Federal Domestic Assistance Number(CFDA number)BothA federal code used to identify a specific federal program.The same CFDA number can have many PCA codes.5 digitsProgram Code (PC)AdministrativeA specific administrative expense. This code is used by counties.3 digitsState Use Only Code (SUO)AdministrativeA SUO program code. For example, Title XX or the MOE code do not have any sub-codes (i.e., time study, PIN, support or generic).3 digitsAid CodeAssistanceA specific assistance expense. This code is used by counties.2 alphanumeric charactersTime Study CodeAdministrativeA code used to account for county staff daily work activities during a specified period of time. This code is used by counties.4 digitsprogram code + 1 digitType of Expense Code(TOE Code)AdministrativeAn identifier that indicates a type of direct charge such as an activity or service provided including the following examples:traveltransportationmedical costsdependent care2 digitsProgram Identifier Number Code(PIN Code)AdministrativeA code established for direct costs. This code is used by counties.6 digitstime study code + TOE codeSupport Staff CodeAdministrativeStaff who perform generic or support-related activities, (e.g., personnel, administration, or direct support of the caseworker) The codes are:A=Social ServicesB=CalWORKSC=Other public welfareD=Child CareThis code is used by counties.One alpha character and at least one, but no more than two, digits.The diagrams below illustrate the hierarchy of the various codes used to capture administrative expense and assistance costs.Figure 1, CA 800 Assistance Claim Expenditure HierarchyFigure 6.2, CEC Administrative Claim Expenditure Code HierarchyProgram and aid codes have a funding sharing ratio (federal share, state share, realignment share, reimbursement share, and, in some instances, county share). The sharing ratio can differ amongst aid and program codes. Finally, because not all counties are eligible for submitting costs for a specific aid or program code, controls must be in place so that a county welfare department does not submit an unallowable cost.Depending on the assistance or administrative claim, additional information may be needed such as caseload, person count, etc.Due to changes in state and federal statute and regulation, the claim data elements can change. This can include the addition, expiration or modification of an aid or program code, sharing ratios, eligible counties and other elements. The system shall support the ability to easily modify aspects of claim data elements.It is also important to note that the structure of these elements may change as a result of the implementation of FI$Cal, the replacement system for CALSTARS.Expenditure Coding Structure Requirements#RequirementFor assistance costs, the system shall maintain a hierarchical structure of aid code to program cost account code to appropriation.For administrative expenses, the system shall maintain a hierarchy of program identifier number codes, support staff codes, generic costs, and time study codes to program code and to program cost account code to appropriation.The system shall maintain a crosswalk of program cost account codes to the Catalog of Federal Domestic Assistance codes.The system shall maintain appropriation codes.The system shall maintain program cost account codes that, at a minimum roll up to an appropriation.The system shall maintain aid codes that, at a minimum:Roll up to a program cost account codeHave an embedded sharing ratioThe system shall maintain sub-codes that roll up to an aid code.The system shall maintain program codes that, at a minimum:Are at least three (3) digitsRoll up to a program cost account codeHave an embedded sharing ratioThe system shall maintain time study codes that, at a minimum roll up to a program code.The system shall maintain all types of expense codes.The system shall maintain program identifier number codes. At a minimum, based on business rules these codes shall roll up to a program code.The system shall maintain support staff codes. Based on business rules these codes shall, at a minimum, roll up to a program code.The system shall maintain generic cost codes. These codes shall, at a minimum:Capture general administrative costs that cannot be identified as benefitting a specific program or group of programsRoll up to a program code based on business rulesThe system shall maintain and track total expenditure amounts by program codes and program cost account codes.For administrative expenses, the system shall collect expenditures by time study codes, program identifier number codes, support staff codes and generic cost code and roll up those amounts to the program codes and program cost account code.For assistance costs, the system shall collect costs by aid code and roll up those amounts to the program cost account code.The system shall maintain a Catalog of Federal Domestic Assistance (CFDA) numbers.The system shall allow one or more program codes to be linked to a program cost account code.The system shall allow one or more aid codes to be linked to a program cost account code.The system shall allow one or more sub-codes to be linked to an aid code.The system shall not allow an aid code and program code to be linked to the same program cost account code.For each item listed below, the system shall allow one or more to be linked to a program code:Time study codeProgram identifier number codeSupport staff codeGeneric cost codeCalculate and Distribute AdvancesTo assist counties with cash flow, CDSS provides monthly cash advances for specific programs. These advances are recovered from the respective quarterly administrative or monthly assistance claims’ audited expenditures. The net amount will result in either a payment to the county or a recovery of funds from the county.The CDSS uses historical audited expenditure data to assist in calculating the amount of the advances. First a statewide total is developed and then allocated to each county.For the quarterly administrative claims, CDSS will calculate the advance for each program by quarter. To do this, CDSS will look at the following:For the respective quarter by each fund, gather the actual expenditures out of the quarterly administrative claim over the last three fiscal years.Determine that quarter’s percentage of the total yearly expenditures for each of the last three fiscal years.Determine the average percentage across the last three fiscal years (for allocated programs only).Apply that average percentage to the current year’s allocated amount.The CDSS policy dictates a ten percent holdback to prevent over advancing to one county at the expense of another county. To meet this policy the calculated advance amount is multiplied by 90 percent. This will be the statewide advance amount for the counties.The advance is then divided by three to determine the amount of the advance to be paid out each month.The example below illustrates how CDSS would calculate the allocated or capped advance amount for the CalFresh program for Los Angeles County for the March quarter. A similar process is used to determine the advance amount of a non-allocated (not capped) fund.Figure 3, Calculation of General Fund AdvanceProgramCalFreshCurrent year allocation (FY 2013-14) $2,000,000 QuarterMarch 2014FYCountyQtr Exp.% of TotalTotal AnnualCalFresh Exp. for One ApprovalQtrs % of Total2012-13Alameda$10,0008 $1,500,0008Los Angeles$50,00040(125,000/1,500,000)Riverside$40,00032Sacramento $25,00020Total $125,0002011-12Alameda$8,0008 $1,000,00010Los Angeles$42,00044(95,000/1,000,000)Riverside $30,00032Sacramento $15,000 16Total $95,0002010-11Alameda $9,0009$1,000,00011Los Angeles $48,00051(112,000/1,000,000)Riverside $35,00037Sacramento $20,00021Total$112,000Average Qtr %10March 2014 Quarter Advance (Statewide)$180,000Current year allocation times x Average Qtr % x 90% =$2,000,000 x 10% x 90%Los Angeles Advance (40%) $72,000March Quarter Advance x FY 2012-13 L.A. county percentage of quarter =$ 180,000 x 40%The State uses historical data from its quarterly administrative claim to provide the actual expenditure data which analysts then input into Excel spreadsheets to determine and track the advances and actual expenditure data.Advances are not provided for Programs classified as Cash Claims, since annual projected cash needs or historical expenditures do not meet the minimum required threshold for an advance. The monthly assistance claim advance methodology is basically the same as the quarterly administrative claim methodology. The monthly assistance claims use the recent 11 months of audited expenditure data; whereas the quarterly administrative claim uses three years of historical data to determine the advance amount.The methodology used for programs such as the California Work Opportunity and Responsibility to Kids (CalWORKs) assistance program is different due to the 2011 Realignment and the Maintenance of Effort (MOE) requirements. Advances Requirements#RequirementThe system shall calculate the quarterly administrative expenditure advances by program by county.The system shall calculate the monthly assistance advances by program by county.The system shall allow authorized users to record/update the annual budget/allocation amounts by program by funds.The system shall allow authorized users to modify the calculated advance.After required state approvals, the system shall record the advance in the appropriate ledger with the appropriate chart of accounts.The system shall allow authorized users to record supplemental advances and post them to the appropriate ledger with the appropriate chart of accounts.The system shall allow authorized user to identify which programs are eligible for advances and which are classified as Cash Claims and not eligible for advances.The system shall establish multi-level state approvers (e.g. spending authority, federal funds and management approval) The system shall allow authorized user to record in the budget/allocation amounts for each program and then calculate the federal and state portions.The system shall allow authorized users to generate, upon request, an AA190 – Statement of Cash Advance, detailed payment report for a county.The system shall allow authorized user to record funds not provided to counties by CDSS (e.g., Realignment Subaccounts).The system shall allow users to record or upload the claim schedule numbers and warrant release dates for advances paid and recovered.The system shall allow an authorized user to suspend an advance payment:For an entire statewide amountA portion of a statewide amountAn individual county amountSubmit ClaimThis section presents requirements related to the preparation and submission of county quarterly administrative claims and monthly assistance claims. Business rules for required fields and allowable values will enable a county to correct data entry errors during the claim preparation process.Where applicable, the specific claim type is identified. If claim or claims is used without specifying a type, it applies to all claim types.Submit Claim Requirements#RequirementThe system shall allow an authorized user to create or complete a new quarterly administrative claim.The system shall allow an authorized user to create or complete a new monthly assistance claim.The system shall allow an authorized user to create or complete an amended quarterly administrative claim no later than nine (9) months after the due date of the original claim.The system shall allow an authorized user to create or complete an amended monthly assistance claim no later than 18 months after the due date of the original claim.The system shall auto-populate common data fields that are shared between the administrative and assistance claim (e.g., case count).The system shall allow an authorized user to upload data to an assistance or administrative claim in lieu of entering the data manually.The system shall allow a user, at a minimum, the following formats for uploading assistance or administrative claim data:Web form (entry)XMLThe system shall run all business rules and data for an assistance or administrative claim that has been manually entered into the claim.The system shall run all business rules and data for an assistance or administrative claim that has been uploaded into the claim.The system shall display all errors, as a result of running the business rules and data, related to the assistance or administrative claim, allowing an authorized user to make corrections.Following the upload of assistance or administrative claim data, the system shall allow an authorized user to preview the uploaded data in the claim template.The system shall allow an authorized user to edit data on an assistance or administrative claim prior to submittal.The system shall allow an authorized user to save an assistance or administrative claim that is in progress.Upon saving an assistance or administrative claim, the system shall update all program ledgers, including funding shifts.The system shall allow an authorized user to submit an assistance or administrative claim for an authorized user to review.The system shall record the date and time of submission of an assistance or administrative claim.The system shall allow a state or county user to withdraw an assistance or administrative claim that has been submitted in the system.The system shall record the withdrawal date, time, and reason of a withdrawn assistance or administrative claim.If an assistance or administrative claim is withdrawn and resubmitted, the system shall record the date and time of resubmission. The system shall allow the county user to withdraw a claim prior to resubmission. The system shall reject a claim if it is does not balance.If a claim is withdrawn and resubmitted, the system shall retain the original date and time of submission in addition to the date and time of the resubmission. A history of all submission dates will be maintained by the system.The system shall allow an authorized user to print an assistance or administrative claim that has been captured in the system.The system shall allow an authorized user to print any assistance or administrative claim submitted by any county.The system shall record an electronic signature of the county auditor and welfare services director when submitting and resubmitting an assistance or administrative claim.The system shall allow an authorized user to print a signature page for each claim.The system shall allow an authorized user to create a mock assistance or administrative claim that allows that user to see projected federal, state or county costs.The system shall allow an authorized user to edit a county’s budget allocation for a program when preparing a mock assistance or administrative claim.The system shall allow an authorized user to name the mock assistance or administrative claim.The system shall enforce all business rules for a mock assistance or administrative claim for the period of time in which the claim is being created.The system shall enable an authorized user to create and save no more than a total of 20 mock assistance and administrative claims at a time.When creating a mock assistance or administrative claim, the system shall allow an authorized user to use a prior submitted claim for the mock claim’s data.When creating an assistance or administrative claim that will be submitted, the system shall allow an authorized user to use a saved mock claim for the claim’s data.The system shall allow an authorized user to delete an unsubmitted assistance or administrative claim or remind users that it has not been submitted.The system shall perform all calculations and auto-populate fields.The system shall allow an authorized user to see Maintenance of Effort and set up the appropriate relationships with the program and between programs.The system shall allow an authorized user to submit a negative adjustment claim at any time.The system shall allow an authorized user to delete a mock assistance or administrative claim.Receive and Audit ClaimOnce a county has submitted its monthly assistance or quarterly administrative claim to the State, the next steps are to record receipt of the claim and conduct the audit of the submitted claim. The desk audit staff retrieves a claim and conducts the desk audit process.Upon receipt of a claim, CECRIS will record the date and time of claim receipt and store the submitted claim in a work queue. At this stage, the claim is “locked” and may not be edited by the county that submitted it. In the desk audit step, the objective is to identify information within the claim that is allowable and/or unallowable to ultimately approve or correct a claim. A CDSS desk auditor can deny specific costs, make comments and/or enter corrections (depending on user role). Once approved, the claim amounts for each program are updated to the program ledger for that county. Approved claims may not be altered.Receive and Audit Claim Requirements#RequirementThe system shall retain a copy of the claim as originally submitted by each county.The system shall record the date and time of claim receipt.The system shall track and display which counties have and have not submitted a claim, by type. The system shall not allow a county to submit a claim after its due date without state approval.The system shall allow an authorized user to enable a county to submit a claim after its due date. Second level approval shall be required to make this submissionThe system shall track the desk audit status of a claim.The system shall have the following features for the status of the desk audit:ReceivedDesk Audit InitiatedDesk Audit in Progress by PercentagePending Response from CountyDesk Audit CompletedApprovedApproved with RevisionsReturned for ResubmittalDeniedThe system shall allow individual county claims to be assigned to specific desk auditors by a manager or lead staff person.The system shall capture the following information for desk audit data:Name of desk auditor.Date when certification was received from the county welfare department signed by the director and auditor controller certifying under penalty of perjury the accuracy of the costs claimed.Date the Claiming/Cover Letter was received (only applies for adjustment claims – not needed if system can generate a summary report of the adjustments being made).Date when authorized signatures were verified.Audit start date.Audit completion date.The system shall calculate the difference between the Expenditures Certification Before Ledger Processing of the Current Audited Claim and the Adjustment quarter submitted by County (this applies to adjustment claims only).The system shall validate the difference equal to the amount of the Scheduled difference certification pages before ledger processing.The system shall display the original, adjusted and total claimed amount for the quarter for each adjusted PC and total expenditure claimed.The system shall record person counts, case type, and assistance unit counts by program by reporting period for a county.The system shall calculate the quarterly (three-month) person count by program for a county based upon data within the assistance claim and include that amount in that county’s administrative claim. The system shall validate Public Assistance CalFresh (PACF) ratios by county.The system shall compare costs from the previous reporting period with the current reporting period to identify an increase or decrease in a cost, time study hours and/or person count.The system shall allow an authorized user to set the variance percentage that identifies an increase or decrease in a cost with second level approval.The system shall require users to enter a justification for input of credits (or negative amounts) to current quarter or monthly claims. The system shall require users to enter a justification for input of costs or amounts that result in a variance beyond that acceptable range.The system shall compare expenditures from the adjustment administrative claim with the previously submitted claim for the same corresponding period to identify any increase or decrease in costs for each function. Prior period assistance claim shall be compared to expenditures and/or person counts to the corresponding current monthly assistance claim to identify any increase or decrease in costs for each aid code.The system shall generate quarterly or as needed a Claim Summary Variance Report presenting all variances for a county and program.The system shall enforce percentage of cost relationships between program codes.The system shall allow an authorized user to modify data on a county’s claim.The system shall allow an authorized user to disallow a specific cost on a claim.The system shall allow an authorized user to create comments associated to a claim.The system shall track changes to a submitted claim including:Type of changeDate of changeUser making changeReason for change (e.g., audit finding, federal statute change)The system shall provide, upon request, a report of changes to a county’s quarterly administrative claim and monthly assistance claim to authorized users prior to auditing each county claim.The system shall capture and validate which foster care and group home facilities are active and licensed including the facility’s Data Universal Numbering System (DUNS) number. This requirement shall extend to out of state group homes.The system shall capture and validate data based on foster care and group home levels of services.The system shall allow an authorized user to approve a claim.The system shall allow a claim to be escalated for a second level review.The system shall allow an authorized user to return a claim for correction.The system shall generate a desk audit summary that includes:Desk auditor nameDate of claim submissionDesk audit dateBookmark on Status/Progress of Audit Changes made to the claimComments made to the claimDenied/Disallowed costs due to changesThe system shall verify all Reconciliations balance. The system shall conduct an automated ledger analysis to validate no new data was entered or any data is missing from prior quarter.The system shall generate a claim approval/denial letter which includes:Total amount of expenditures claimedAdjustments to expendituresCorrects made by state staffTotal amount of approved expendituresPayment dateAudit findingsAny other mandated verbiageThe system shall allow a state user to send the claim letter to the county electronically.Process PaymentsThis section of the business requirements presents information and requirements on processing payments to counties for their approved, audited monthly assistance claim and quarterly administrative claim costs.After a county has submitted a claim and the claim has been audited, it is then processed for payment by PCA and fiscal year. This payment process includes taking all audited and approved costs, including:Subtracting any advances given to the county for the corresponding periodSubtracting reimbursement costs that are paid separatelySubtracting any deferral payments for the countySubtracting any Local Revenue Fund counties received from the State Controller’s Office (SCO)Adding any advances for the next reporting period. (Advances are program-specific. Not all programs have an advance payment. Programs meeting certain criteria/threshold may be advanced funds.)These activities determine the final net payment due to or recovery from the county. The system will generate an AA-190 Statement of Cash Advance Report for each county presenting the final payment or recovery by program and the detail activities that results in that net payment/recovery. These must be reviewed and approved by authorized State personnel before the claim schedule is actually produced. The system will also generate a remittance advice for each county that details the net of the payments by program. After approval of the payment amounts, the system will generate a claim schedule with all payments and the funding source from which that payment should come from (CA 504). This claim schedule data is uploaded to CALSTARS (this will become FI$Cal in the future). Payments for the administrative and assistance claims are made separately. Within the payments processes, the county could receive a separate payment for each program by appropriation or other criteria. The nature of some programs (e.g., Title IV-E Waiver) requires costs in this area to be paid separately.If applicable, SCO will also receive a banking schedule that defines special handling requests such as courier pick-up, etc.Process Payments Requirements#RequirementThe system shall track total expenditure amounts by county, PCA, program and period (month and/or quarter).The system shall track the advance amount disbursed to a county by program, PCA, period by month and quarter (administrative expense) and by month (assistance expense).The system shall calculate the net amount to be paid to each county by quarter and by month. The system shall be able to flag any negative net amount per county and record it as a credit.The system shall allow authorized users to manually record amounts to be debited or credited to a program based on sources outside of CECRIS (e.g., new state or federal legislation that changes claim limits).The system shall track payments to all counties that are to be issued via SCO warrants or Electronic Funds Transfer (EFT). The system shall generate monthly claim schedules according to a pre-determined schedule that will be sent to SCO for payment.The system shall allow an authorized user to generate a claim schedule upon request.The system shall generate claim schedules specifically for EFT payments.The system shall allow an authorized user to add or modify payment methods (e.g., warrant vs. EFT) and which financial institution each county uses.The system shall allow an authorized user to update county treasurer, county auditor controller, county mailing and physical addresses, contact phone numbers and email addresses.The system shall allow an authorized user to control the release of a payment.The system shall allow an authorized user to schedule payments in accordance with SCO requirements.The system shall generate monthly Claim Schedule face sheets (STD 218) on a predetermined schedule for SCO and State Treasure Office warrant payments.The system shall allow an authorized user to generate a claim schedule face sheet (STD 218) upon request.The system shall generate monthly EFT Claim Schedule face sheets (STD 218EFT) on a pre-determined schedule for EFT payments.The system shall generate an EFT Claim Schedule face sheet (STD 218 EFT) upon request.The system shall generate a Transfer Request Form (CA 504) on a pre-determined schedule for SCO warrant payments or EFT payments.The system shall generate a Remittance Advice (RA) that meets the format and guidelines defined by SCO for individual payments processed through CECRIS and recorded on a claim schedule.The system shall track and display the status of the payment from the point the audited claim is sent to the CDSS Payment Section for processing, to the stages of generating a claim schedule package and sending to SCO, to the final warrant/EFT payment being sent by SCO.The system shall generate and assign an annually prescribed claim schedule number and Welfare Payment Unit (WPU) number to a payment when processing the payment transaction.The system shall assign the claim schedule number and record the SCO payment date to the county.The system shall generate an AA190 per claim schedule, per county and statewide.The system shall allow authorized users to generate a county listing which summarizes the total amount of payments to each county by claim schedule.The system shall allow an authorized user to access reimbursement data for billing purposes.The system shall allow an authorized user to access pending payments by county and by period (monthly or quarterly).The system shall allow an authorized user to access pending reimbursement by program and by period (monthly or quarterly).The system shall allow an authorized user to generate the electronic direct claim schedule, face sheet and RA to be printed and/or downloaded for electronic submission.The system shall allow end users to generate and assign a batch number for a series of payments made within a reporting month and generate a batch for every schedule.The system shall maintain all payment history required for business operations.The system shall maintain appropriation balances including payments to the counties.The system shall allow end users to generate a payment summary for each generated claim schedule.The system shall allow end users to generate a federal draw report by claim schedule, CFDA and by reporting period.Year End ProcessingAt the end of each state fiscal year, the State is responsible for “closing the books.” This closing of the books involves two main processes:Determining accruals.Preparing year-end statements.Accruals refer to expenditures incurred that are not yet paid. Both quarterly administrative and monthly assistance claims have accruals. Accruals are recorded by state fiscal year. An accrual can be for current or prior state fiscal year expenditures. Because not all claims have been submitted and/or audited, the State must estimate the expenditures for the un-submitted and/or unaudited claims less the amount of advances. To estimate these expenses, the following methodologies are used:Quarterly Administrative Claim: The prior three fiscal year expenditure trends and allocation balances.Monthly Assistance Claim: The prior 11 most recent monthly claim submissions.This accrual data is included in the State’s Financial Statements. Therefore, CECRIS must generate reports that capture all expenditures by Program Cost Account (PCA) code. Year End Processing Requirements#RequirementThe system shall allow an authorized user to define the methodology used to calculate the June quarterly administrative claim and the monthly assistance claim that includes, but is not limited to the following: Three (3) fiscal years audited expenditure trends by quarter for the administrative claim and prior six (6) month paid for the assistance claims.By programBy fundBy PCABy state fiscal yearThe system shall automatically assign a unique accrual identification number by fiscal year, program, fund and PCA.The system shall allow an authorized user to analyze the accrual data and make appropriate actions.The system shall total all estimated outstanding administrative expenses by program less the amount of any un-recovered advances by PCA and by fiscal year.The system shall total all estimated monthly assistance claim expenses by program less the amount of any un-recovered advances by PCA and by fiscal year.The system shall allow users to create a statewide year-end administrative claim expenses report by program code and PCA code.The system shall allow an authorized userusers to create a statewide year-end assistance claim report of expenditures by aid code and PCA code.The system shall, for the purpose of transmitting required data with CALSTARS, create data data and reports which in CALSTARS’ file format which can be exported and uploaded to CALSTARS.The system shall, for the purpose of transmitting required data to Fi$Cal, create data and reportsin Fi$Cal’s file format which can be uploaded to Fi$Cal.State and Federal Fiscal Year Close OutThe Close Out process redistributes surplus funds to eligible counties for both the administrative and assistance claims. CECRIS will maintain each county’s expenses or credits via a redistribution calculation.The Close Out process for administrative claim commences nine months after the last quarter of each fiscal year. Counties who have a surplus allocation (unused funds) are redistributed to counties which have exceeded their allocation. Different distribution methodologies are used by each program to redistribute the surplus allocations. The Close Out process for assistance claim commences two months after the last month of each fiscal year. At the end of each state fiscal year, the monthly assistance claim is used to determine if each county has expended its full assistance allocation by program. Close Out Requirements#RequirementThe system shall allow an authorized user to create a close out claim template. The system shall determine which ledgers require close out and which sequence of the ledgers to closeThe system shall reconcile expenditures with the ledgers that require close out.The system shall calculate which counties are surplus for each program ledger.The system shall calculate which counties are deficit for each program ledger.The system shall generate and update ledgers with redistributed fund amounts.The system shall provide a report of all funds redistributed.The system shall provide a report of all ledgers that may be closed out by State and federal fiscal year.The system shall generate close-out claim letters to counties that include the amount redistributed by programs.ReportingThis section presents reporting requirements for CECRIS. The state’s reporting needs are significant as they relate to the data retained in CECRIS. The range of report users is large and their reporting needs vary. Many user groups will benefit from standardized reports and an equal number of users are seeking a powerful ad hoc reporting tool.Reporting Requirements#RequirementThe system shall generate all reports currently produced by the State and new reports as defined by the State. Refer to the Reports Inventory in the Bidders’ Library.Where possible, the system reports shall conform to a standardized report template that includes a standard header and footer, title page, report content and location for summary data.The system shall provide a browser-based reports application that allows authorized users to view, create and download reports.The reports application shall allow authorized users to download reports in Portable Document Format (i.e., PDF), text or Microsoft Excel.The reports application shall maintain online descriptions and definitions of each report that are easily accessible by authorized users.The reports application shall provide a statewide and county version of each standard report.The reports application shall provide a county version of each standard report containing county-level data for a single county selected by the user. Multiple counties may be selected for a report.Monthly and quarterly reports shall be available in the reports application within five business days after the last day of the reporting period.The reports application shall allow access to standard reports for at least three years.The reports application shall allow authorized users to easily add and stop production of reports, as required by federal, state and local laws, rules, regulations, ordinances, guidelines, directives, policies and procedures.The reports application shall produce reports that include duplicated and/or unduplicated counts, as specified by CDSS, and include a clear identification of the report run date, “as of” date, period of system data date and print date.The reports application shall include the ability to produce standard and ad hoc reports for any time period back to the commencement date of implementation of the system.The reports application shall include the ability to export a report in CSV XML, PDF, and MS Excel.The reports application shall include an ad hoc reporting component that allows an authorized user to execute a custom query or report that can be made available to other authorized users.The reports application shall allow access to ad hoc reports for at least three months.User AccessCECRIS is expected to have approximately 350 users. Users include:Counties: county users are anticipated to create and submit claims. These same users would check on the status of a claim and access county-level reports.CDSS: The range of CDSS users varies. There will be users who review and approve claims and/or execute payments. Some CDSS users will only use reports and others will serve as system administrators.External: The group of external users is expected to use reports only.Department of Health Care ServicesState Controller’s OfficePublic: There will be no public access to the system for users outside of those defined above.User access refers to identifying CECRIS users, gathering the needed information to establish the individual as a CECRIS user and developing and assigning a security role. The system shall capture user information and create all initial users. During Maintenance and Operations, the State will add or modify any users.User Access Requirements#RequirementUser accounts including a log-in and password shall be created for all initial CECRIS users.Data Migration Data migration is widely considered to be a critical activity in any information technology project. The importance of the quality of the incoming data and its ability to work with processes in the new system should never be underestimated. The migration of data into CECRIS is no exception and, therefore, the Contractor must migrate only the most recent three fiscal years of data migrate the three state fiscal years of CEC and CA 800 summary data. The stored data will encompass the three most recent full claiming cycles and will enable the State to begin calculating advances through the new system using historical data.Data Migration Requirements#RequirementThe most recent three (3) fiscal years of data in the existing administrative (CEC) and local assistance (CA800) toolsets shall be migrated for use with CECRIS. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download