Att 1 RRM_CalculationFlowChart.pdf

Order of Steps for DEHS Resource Requirement Methodology Calculation Calculating the Raw RRM, Institutional Base, Program Base, IP RRM, Program Amount and Combined Amount

SELECT Establishment_Type.Establishment_Type_Code, Establishment_Type.Establishment_Type_Description, Sum(Establishment_Type.Workday_Factor) AS SumOfRRMByEstablishmentType

FROM Establishment INNER JOIN Establishment_Type ON Establishment.Establishment_Type_Code = Establishment_Type.Establishment_Type_Code

WHERE Area_Code = ‘XX’ GROUP BY Establishment_Type.Establishment_Type_Code, Establishment_Type.Establishment_Type_Description, Establishment.allowed HAVING Establishment.allowed='Y' ORDER BY Establishment_Type.Establishment_Type_Code

Establishment Table Establishment_Type Table

Raw RRM Raw RRM is calculated

Step 1 Generate Raw RRM using the Establishment and Establishment_Type tables along with the sample SQL statement below. ‘XX’ is any SINGLE two digit IHS Area Code

Institutional Base = 40.5

Step 2

Program Amount = Raw RRM + Program Base + Institutional Base + IP RRM Program Amount is calculated

Step 5

Is this an Area-wide RRM caluculation for

Area_Code ‘30’ (Alaska)?

Combined Amount = Program Amount * 1.2

Combined Amount = Program Amount

Yes

No

Combined Amount is calculated

Step 6

If the Raw RRM calculated in Step 1 is not the Raw RRM for an entire Area, the process must stop at this point.

The remaining calculations do not take into account the filtering of an Area’s Raw RRM.

Program Base is calculated

Step 3

Program Base = (Raw RRM + Institutional Base) x .265

IP Table

SELECT IP_RRM

FROM IP

WHERE Area_Code = ‘XX’

IP RRM

is calculated

Step 4 Get IP RRM from the IP table using the sample SQL statement below. ‘XX’ is any SINGLE two digit IHS Area Code

Indian Health Service, Office of Environmental Health and Engineering, Division of Environmental Health Services

Institutional Base

Training = (Combined Amount x 5) / 220 Training is calculated

Travel = Combined Amount x .10 Travel is calculated

Administrative Time = Combined Amount x .25 Administrative Time is calculated

Office Support Staff = Combined Amount x .2 Office Support Staff is calculated

Administrative Amount = Training + Travel + Administrative Time + Office Support Staff Administrative Amount is calculated

Step 7 Steps 1 through 6 on page 1 are used to generate the Combined Amount. The Combined Amount is used in Step 7 to generate the four parts that make up the Administrative Amount.

Order of Steps for DEHS RRM Calculation (continued)

Calculating Administrative Amount and Total RRM

Raw RRM

+ Institutional Base

+ Program Base

+ IP RRM

+ Administrative Amount

Total Area RRM

Step 8 All of the values listed below are added to generate the Total Area RRM.

Document History for RRM_FlowChart.vsd

3/28/2011 – Document created. (D. Buchanan)

3/14/2012 – Step 3 modified to correct the following error: Program Base = (Raw RRM) x .265. Institutional Base should have been added to the Raw RRM. The corrected calculation is Program Base = (Raw RRM + Institutional Base) x .265. (D. Buchanan)

August 2021 – Step 2 simplified to state standard institutional base (S. Piontkowski/M. Reed)

O:\OEHE\DEHS\New DEHS O drive\Administration\Contracts\WebEHRS COTS 2021-2026/Acquisition Plan 2021\Suppor tDocuments/RRM_CalculationFlowChart.pdf