Attachment I-26 2 (Business Rules-FM).pdf

RELEASED - Printed documents may be obsolete; validate prior to use.

National Aeronautics and Space Administration

NSSC ServiceNow – Financial Management

Metrics and Utilization

Accounts Payable – 98% on time

Document Version V.2

Date Last Modified 10/01/2020

Reference: Contract Attachment I-26 Business Rules

NASA Shared Services Center Building 1111, Jerry Hlass Road Stennis Space Center, MS 39529

ServiceNow Requirements NASA Shared Services Center

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 2 of 13

OVERVIEW:

Brief Description:

The following ServiceNow Business Rules outline the requirements in order to process the report data requirements and also provides the supporting information/documentation for validation/verification purposes which allow for:

Metrics

Utilization Performance Analytics

Note: See Appendix A – Work Instructions

If applicable:

If this is being updated as the result of a Change, please provide the following information:

Effective Date of Change:

Description of Change:

Contract Modification:

Impact to existing Metrics/Utilization/Transactions:

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 3 of 13

REPORTING SUMMARY :

Suggested Report Title for Metric and Utilization:

I.3_FA_PWS Element Metric: 3.1.1 Accounts Payable Payments

Global Setting:

Y/N

Yes

Functional Area: Finance

PWS Section: 3.1.1

Performance

Area:

Accounts Payable

SO/SME

TYPE:

SLI/PM/OTHER

SLI

Dependencies or impacts on other Areas/ Functional Areas:

I-3 Reportable

Contract

Modification

SN Story

Number/Date Submitted

STRY0286546

SN PA Story/Date Submitted

Approval – CS/SP

Metrics Team Review

Metric I-3

Process 98 % of payments on time

Tech Doc Location/Date Archived

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 4 of 13

REPORT REQUIREMENTS: METRICS AND UTILIZATION

Name of Report AP - Count of Payments by Center - Summary by Document Type

Report Content

Tab Summaries:

1. Count of payments per Center. Totals at right. (no breakout – just totals by center)

2. Breakout by Document Type

Count of payments per Center (on top), per Document Type (on left). Totals at right and bottom.

FY15 Forward:

• Credit Card Payments

• Vendor Invoice (KR)

• Invoice – Gross (RE)

• Credit Card (ZD)

• GBL Invoice (ZG)

• Shipping Invoice (ZN)

• Credit Card (ZT-ZO)

• Earned Award Fee (RM)

Pre FY15

• Credit Card (ZD)

• Credit Card (ZT-ZO-ZU)

• GBL Invoice (ZG)

• Invoice – Gross (RE)

• Invoice – Utility( RU)

• ARRA Invoicing (RF)

• MM – Utility Payment (KU)

• Shipping Invoice (ZN)

• Vendor Invoice (KR)

Detail Fields:

• Business Area/Center

• Payment Run ID

• Cleared Document Number (5600 and 1900)

• Vendor Number

• Vendor Name

• Reference

• Schedule Number

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 5 of 13

• Document Type

• Payment Method

• Payment Document

• Clearing Document Number (1300)

• Invoice Gross Amount

• Net Amount

• Discount / Penalty Amount

• Document Date

• Posting Date

• Payment Run Date

• Clearing Date

Count of Payments excluding Credit Card Payments Non-credit card payments identified by: FY15 Forward: Payment Method = C D, or F Pre FY15: Payment Method C, D, or X Document Type NOT KG, RZ, or KW Clearing Document (first four positions) <> 2000 Payment Run Id (first two positions) not NS or NM FY15 Forward:

Payment Run Id (position 2) NOT IN (X,L,E,R) Pre FY15: Payment Run Id (position two) NOT IN (X, L, E) Vendor Number does not start with 900000 Do not count if:

“Net Amount” is less than $0 and “Debit/Cred” is “S”

Count of Credit Card Payments Credit card payments identified by: Pre

FY15:

Payment Run Id (position two) = X Payment Method = D or X Clearing Document (first four positions) <> 2000 Document Type <> KG or KW Document Type <> RE if Negative Dollar Amount FY15

Forward:

Payment Run ID (position 2) = X

Count distinct Payment Run ID Numbers; (each number should be counted one time only (that is, if the same Payment Run ID was used for more than one invoice, it should only be counted as one payment – for credit cards only)

Pre FY15: Where multiple document types are found for one

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 6 of 13 payment run id, report the payment under the document type which is most often used.

Input Parameters

Document type is one of KR, RE, RF, ZD, ZG, ZN, ZT, ZO, RM

Payment distinct doc type is not null Payment clearing date on last month Data from SAP Payments {u_bidw_sap_payments}

Output

Parameters

Payment distinct doc type by center

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 7 of 13

Name of Report AP - WSR Count and Sum of Interest Payments by Center - Summary Count

Paid is determined by payment Clearing Date is not null.

Interest payment is determined by positive discount penalty amount in Disc/Pen Amount field.

Do not include discounts on credit memos – identified by Document type RE, RM, KR, ZN, ZG and net amount < 0

Payment Method must be:

C –Treasury Check D – Bank Transfer (ACH) F - A/P Foreign with US Bank (IAT) X

– Credit Card

Payment Run ID where:

• The first 2 digits do not equal “NS”

For Count only:

• If the second digit of the Payment Run ID is “X” – Duplicate Payment Run IDs must be rolled up and counted as 1

Manual Adjustments supersede1300 clearing document requirement.

Table is SAP Payments {u bidw sap payments} Payment clearing date is on last month Penalty amount is not emplty USD Payment method is one of C, D, F and X

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 8 of 13

Payment month description by center

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 9 of 13

ServiceNow Data – Metric Definition Template

Placement / Location:

Dashboard: P & U - Internal - FM Dashboard / P & U - FM Dashboard ( Both internal &

External )

Dashboard Tab: AP

Dashboard Group: Performance And Utilization - Internal / Performance And Utilization ( Both Internal & External )

Name of Analytic: 3.1.1 Accounts Payable Payments

Data Source: Table:

• SAP Payments [u_bidw_sap_payments]

Existing Reports:

• AP - Count of Payments by Center - Summary by Document Type

• AP - WSR Count and Sum of Interest Payments by Center - Summary Count

Dates to show trend: Payment Clearing date

Frequency: Monthly

SLI: (Formula)

Count of AP - Count of Payments by Center Summary by Document Type

Count of AP - WSR Count and Sum of Interest Payments by Center - Summary Count

Conditions:

For AP - Count of Payments by Center - Summary by Document Type

Payment distinct doc type is not blank

Clearing date on Last Month

Document Type is one of KR, RE, RF, ZD, ZG, ZN, ZT, ZO, RM

For AP - WSR Count and Sum of Interest Payments by Center - Summary Count

Payment Clearing date on Last Month

Penalty Amount is not empty

Payment Method is one of "C, D, F, X"

Penalty Amount is greater than 0 USD

SLI Percentage Calculation = ((AP - Count of Payments by Center -

Summary by Document Type "minus" AP -

WSR Count and Sum of Interest Payments by Center -

Summary Count) "divided by" (AP - Count of Payments by Center -

Summary by Document Type)) by center and total.

• If the metric calculation is => 98%, the SLI is met

• If the metric calculation is

• Stoplight is displayed of the top of the Analytic

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 10 of 13

Type of Visualization:

Bar Graph – Displays Count Payments on Time by Center for the Month

• Breakdown will have the one categories:

Payments on Time by Center

Breakdown by Center Met/Not Met

SLI Calculation – Placed above the existing Bar Graph

• Breakdown the metric score by month for current FY to last month

• y-axis should show the percentage on the left and the counts on the right

Also with the percentages being on the left, adjusting the percentage range to have the mon thly SLI data points high on the chart.

• Add a threshold line (for the SLI)

Single Score – Placed to the top might margin of the analytic window

- Display current SLI score with Met or Not-Met

Hover Over Information: Process 98 % of payments on time

DEVELOPMENT:

1. INDICATOR SOURCES

a. P&U BIDW SAP Payments.All.Monthly.Monthly

2. AUTOMATED INDICATORS

A. INTERNAL

1. P&U INT FM WSR Count & Sum of Interest Payments - Monthly

2. P&U INT FM Dollar Amount of Paid Invoices - Monthly

3. P&U INT FM AP Count of Payments by Center - Monthly

4. P&U INT FM AP - WSR Count and Sum of Interest Payments by Center -

Summary Count - Monthly

B. EXTERNAL

1. P&U EXT FM WSR Count & Sum of Interest Payments - Last Month

2. P&U EXT FM Dollar Amount of Paid Invoices - Last Month

3. P&U EXT FM AP Count of Payments by Center - Last Month

4. P&U EXT FM AP - WSR Count and Sum of Interest Payments by Center -

Summary Count - Last Month

3. FORMULA INDICATORS

1. Accounts Payable - On Time Payments: >=98%

B. EXTERNAL

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 11 of 13

2. Accounts Payable - On Time Payments: >=98%

4. BREAKDOWN SOURCES

A. BIDW SAP Late Reason Description

B. BIDW SAP Document Types

C. BIDW SAP Payment Method

D. BIDW SAP Payment Dollar Doc Type

E. BIDW SAP Payment Center

5. AUTOMATED BREAKDOWN

A. Late Reason Description

B. Document Type

C. Payment Method

D. Payment Dollar Doc Type

E. SAP Payment Center

5. JOBS (EXISTING)

A. [PA BIDW SAP Payments] Historical Data Collection - P&U INTERNAL

B. [PA BIDW SAP Payments] Daily Data Collection - P&U INTERNAL

C. [PA BIDW SAP Payments] Daily Data Collection - P&U EXTERNAL

D. [PA BIDW SAP Payments] Historical Data Collection - P&U EXTERNAL

6. WIDGETS

1. FM AP Payments - Monthly SLI

2. 3.1.1 Accounts Payable Payments

3. FM AP Payments - Monthly Total

4. FM AP Paid Invoices - Monthly Total

B. EXTERNAL

1. FM AP Payments - Monthly SLI

2. 3.1.1 Accounts Payable Payments

3. FM AP Payments - Monthly Total

4. FM AP Paid Invoices - Monthly Total

7. INDICATOR GROUPS

A. P&U INT FM Accounts Payable

B. P&U EXT FM Accounts Payable

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 12 of 13

APPENDIX A: PROCESS WORK INSTRUCTIONS

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 13 of 13

APPENDIX B: SERVICE NOW USER STORIES

Accounts Payable Interest Payments – 3.1.1

9/28/2020 Page 2 of 13

9/28/2020 Page 3 of 13

I.3_FA_PWS Element Metric: Accounts Payable Interest Payments

Y/N

Yes

Functional Area: Finance

PWS Section: 3.1.1

Performance

Area:

Accounts Payable

SO/SME

TYPE:

SLI/PM/OTHER

SLI

Dependencies or impacts on other

Submitted

STRY0288647

Pay no more than $200 in interest penalties per $1,000,000 in payments

9/28/2020 Page 4 of 13

Summary Dollars breakout – just totals by center)

2. Breakout by Document Type

• Vendor Invoice (KR)

• Invoice – Gross (RE)

• Credit Card (ZD)

• GBL Invoice (ZG)

• Shipping Invoice (ZN)

• Credit Card (ZT-ZO-ZU)

• GBL Invoice (ZG)

• Invoice – Gross (RE)

• Invoice – Utility( RU)

• ARRA Invoicing (RF)

• MM – Utility Payment (KU)

• Business Area/Center

• Payment Run ID

• Cleared Document Number (5600 and 1900)

• Vendor Number

• Vendor Name

9/28/2020 Page 5 of 13

• Payment Document

• Clearing Document Number (1300)

• Invoice Gross Amount

• Net Amount

• Discount / Penalty Amount

• Document Date

• Posting Date

Forward: Payment Method = C D, or F Pre FY15: Payment Method C, D, or X Document Type NOT KG, RZ, or KW Clearing Document (first four positions) <> 2000 Payment Run Id (first two positions) not NS or NM FY15 Forward: Payment Run Id (position 2) NOT IN (X,L,E,R) Pre FY15: Payment Run Id (position two) NOT IN (X, L, E) Vendor Number does not start with 900000 Do not count if:

Credit card payments identified by:

Pre FY15:

Payment Run Id (position two) = X Payment Method = D or X Clearing Document (first four positions) <> 2000 Document Type <> KG or KW Document Type <> RE if Negative Dollar Amount

Count distinct Payment Run ID Numbers; (each number should be counted one time only (that is, if the same Payment Run ID was used for more than one invoice, it should only be counted as one payment – for credit cards only)

9/28/2020 Page 6 of 13

Table is SAP Payments {u_bidw_sap_payments}

Payment clearing date is on Last month

Payment method is one of C, D, F or X Penalty amount is not empty USD

Output

9/28/2020 Page 7 of 13

Name of Report Dollar Amount of Paid Invoices

D – Bank Transfer (ACH) F - A/P Foreign with US Bank (IAT) X – Credit Card

Payment clearing date on Last month Document type is one of KR, RE, RF, RM, ZD, ZO, or KG

9/28/2020 Page 8 of 13

Payment method is one of C, D, X or F Payment dollars document type is not empty Manually adjusted is M or Payment clearing document starts with 1300

Payment dollars document type by center

9/28/2020 Page 9 of 13

Placement / Location:

Dashboard: P & U - Internal - FM Dashboard / P & U - FM Dashboard ( Both internal &

External )

Dashboard Tab: AP

Name of Analytic: 3.1.1 Accounts Payable Interest Payments

• AP - WSR Count and Sum of Interest Payments by Center - Summary Dollars

• Dollar Amount of Paid Invoices

SLI: (Formula)

Count of AP - WSR Count and Sum of Interest Payments by Center - Summary Dollars

Count of AP - Dollar Amount of Paid Invoices

Conditions:

For Dollar Amount of Paid Invoices

Payment clearing date on last month

Document type is one of KR, RE, RF, RM, ZD, ZG, ZN, ZT, ZO, KG

Payment method is one of C, D, X or F

Payment dollars document type is not empty

Manually adjusted is M

Payment Clearing document starts with 1300

For AP - WSR Count and Sum of Interest Payments by Center - Summary Dollars

Payment Clearing date on Last Month

Penalty Amount is not empty USD

SLI Percentage Calculation = AP -

WSR Count and Sum of Interest Payments by Center -

Summary Dollars /(Dollar Amount of Paid Invoices/1,000,000)

• If the metric calculation is => $200, the SLI is NOT met

9/28/2020 Page 10 of 13

Bar Graph – Displays Interest penalties per

• Breakdown will have the one categories:

• y-axis should show the percentage on the left and the counts on the right

Also with the percentages being on the left, adjusting the percentage range to have the mon

Hover Over Information: Pay no more than $200 in interest penalties per $1,000,000 in pa yments

1. P&U INT FM WSR Count & Sum of Interest Payments - Monthly

2. P&U INT FM Dollar Amount of Paid Invoices - Monthly

B. EXTERNAL

1. P&U EXT FM WSR Count & Sum of Interest Payments - Last Month

2. P&U EXT FM Dollar Amount of Paid Invoices - Last Month

1. Accounts Payable - Int.

2. Dollar AMT Paid Invoices / 1M in Payments

B. EXTERNAL

1. Accounts Payable - Int.

2. Dollar AMT Paid Invoices / 1M in Payments

9/28/2020 Page 11 of 13

B. BIDW SAP Document Types

C. BIDW SAP Payment Method

B. Document Type

C. Payment Method

5. JOBS

B. [PA BIDW SAP Payments] Daily Data Collection - P&U INTERNAL

1. 3.1.1 Accounts Payable Interest Payments

2. FM AP Interest Payment

3. P&U FM Accounts Payable Stoplight Scores Monthly

B. EXTERNAL

1. 3.1.1 Accounts Payable Interest Payments

2. FM AP Interest Payment

3. P&U FM Accounts Payable Stoplight Scores Monthly

9/28/2020 Page 12 of 13

9/28/2020 Page 13 of 13

Accounts Payable Interest Payments – 3.1.1

9/28/2020 Page 2 of 13

9/28/2020 Page 3 of 13

I.3_FA_PWS Element Metric: Accounts Payable Interest Payments

Y/N

Yes

Functional Area: Finance

PWS Section: 3.1.1

Performance

Area:

Accounts Payable

SO/SME

TYPE:

SLI/PM/OTHER

SLI

Dependencies or impacts on other

Submitted

STRY0288647

Pay no more than $200 in interest penalties per $1,000,000 in payments

9/28/2020 Page 4 of 13

Summary Dollars breakout – just totals by center)

2. Breakout by Document Type

• Vendor Invoice (KR)

• Invoice – Gross (RE)

• Credit Card (ZD)

• GBL Invoice (ZG)

• Shipping Invoice (ZN)

• Credit Card (ZT-ZO-ZU)

• GBL Invoice (ZG)

• Invoice – Gross (RE)

• Invoice – Utility( RU)

• ARRA Invoicing (RF)

• MM – Utility Payment (KU)

• Business Area/Center

• Payment Run ID

• Cleared Document Number (5600 and 1900)

• Vendor Number

• Vendor Name

9/28/2020 Page 5 of 13

• Payment Document

• Clearing Document Number (1300)

• Invoice Gross Amount

• Net Amount

• Discount / Penalty Amount

• Document Date

• Posting Date

Forward: Payment Method = C D, or F Pre FY15: Payment Method C, D, or X Document Type NOT KG, RZ, or KW Clearing Document (first four positions) <> 2000 Payment Run Id (first two positions) not NS or NM FY15 Forward: Payment Run Id (position 2) NOT IN (X,L,E,R) Pre FY15: Payment Run Id (position two) NOT IN (X, L, E) Vendor Number does not start with 900000 Do not count if:

Credit card payments identified by:

Pre FY15:

Payment Run Id (position two) = X Payment Method = D or X Clearing Document (first four positions) <> 2000 Document Type <> KG or KW Document Type <> RE if Negative Dollar Amount

Count distinct Payment Run ID Numbers; (each number should be counted one time only (that is, if the same Payment Run ID was used for more than one invoice, it should only be counted as one payment – for credit cards only)

9/28/2020 Page 6 of 13

Payment clearing date is on Last month

Payment method is one of C, D, F or X Penalty amount is not empty USD

Output

9/28/2020 Page 7 of 13

Name of Report Dollar Amount of Paid Invoices

D – Bank Transfer (ACH) F - A/P Foreign with US Bank (IAT) X – Credit Card

Payment clearing date on Last month Document type is one of KR, RE, RF, RM, ZD, ZO, or KG

9/28/2020 Page 8 of 13

Payment method is one of C, D, X or F Payment dollars document type is not empty Manually adjusted is M or Payment clearing document starts with 1300

Payment dollars document type by center

9/28/2020 Page 9 of 13

Placement / Location:

Dashboard: P & U - Internal - FM Dashboard / P & U - FM Dashboard ( Both internal &

External )

Dashboard Tab: AP

Name of Analytic: 3.1.1 Accounts Payable Interest Payments

• AP - WSR Count and Sum of Interest Payments by Center - Summary Dollars

• Dollar Amount of Paid Invoices

SLI: (Formula)

Count of AP - WSR Count and Sum of Interest Payments by Center - Summary Dollars

Count of AP - Dollar Amount of Paid Invoices

Conditions:

For Dollar Amount of Paid Invoices

Payment clearing date on last month

Document type is one of KR, RE, RF, RM, ZD, ZG, ZN, ZT, ZO, KG

Payment method is one of C, D, X or F

Payment dollars document type is not empty

Manually adjusted is M

Payment Clearing document starts with 1300

For AP - WSR Count and Sum of Interest Payments by Center - Summary Dollars

Payment Clearing date on Last Month

Penalty Amount is not empty USD

SLI Percentage Calculation = AP -

WSR Count and Sum of Interest Payments by Center -

Summary Dollars /(Dollar Amount of Paid Invoices/1,000,000)

• If the metric calculation is => $200, the SLI is NOT met

9/28/2020 Page 10 of 13

Bar Graph – Displays Interest penalties per

• Breakdown will have the one categories:

• y-axis should show the percentage on the left and the counts on the right

Also with the percentages being on the left, adjusting the percentage range to have the mon

Hover Over Information: Pay no more than $200 in interest penalties per $1,000,000 in pa yments

1. P&U INT FM WSR Count & Sum of Interest Payments - Monthly

2. P&U INT FM Dollar Amount of Paid Invoices - Monthly

B. EXTERNAL

1. P&U EXT FM WSR Count & Sum of Interest Payments - Last Month

2. P&U EXT FM Dollar Amount of Paid Invoices - Last Month

1. Accounts Payable - Int.

2. Dollar AMT Paid Invoices / 1M in Payments

B. EXTERNAL

1. Accounts Payable - Int.

2. Dollar AMT Paid Invoices / 1M in Payments

9/28/2020 Page 11 of 13

B. BIDW SAP Document Types

C. BIDW SAP Payment Method

B. Document Type

C. Payment Method

B. [PA BIDW SAP Payments] Daily Data Collection - P&U INTERNAL

1. 3.1.1 Accounts Payable Interest Payments

2. FM AP Interest Payment

3. P&U FM Accounts Payable Stoplight Scores Monthly

B. EXTERNAL

1. 3.1.1 Accounts Payable Interest Payments

2. FM AP Interest Payment

3. P&U FM Accounts Payable Stoplight Scores Monthly

9/28/2020 Page 12 of 13

9/28/2020 Page 13 of 13

Working Capital Fund Advances – 3.1.1

9/28/2020 Page 2 of 12

9/28/2020 Page 3 of 12

I.3_FA_PWS Element Metric: Working Capital Fund Advances

Y/N

Yes

Functional Area: Finance

PWS Section: 3.1.1

Performance

Area:

Accounts Payable

SO/SME

TYPE:

SLI/PM/OTHER

PM

Dependencies or impacts on other

Submitted

STRY0291079

95% of advances with complete funds commitment documents are processed within four business days by NSSC AP

Tech Doc

9/28/2020 Page 4 of 12

Name of Report Working Capital Fund

Summary Graph: Stacked bar chart. Total Dollar amount (left) per Center (bottom).

Crosstab: Dollar amount per Center (top) per Month (left).

Totals at right and bottom.

Crosstab: Total Count per Center per Month. Totals at right and bottom.

• Business Area/Center

• Stat (Status)

• User

• Text

• Clrng doc

• Document No

• Account (Vendor Number)

• Reference

• Type (Document Type)

Report Content

• PM (Payment Method)

• LC amnt (Net Amount)

• Pstng Date

Count of WCF Advance Transactions – Count of WCF

Advance transactions where the clearing date and clearing document number (1500*) are not null and the first two positions of the user id are NS. Count is to be only the transactions with clearing document numbers.

No dollar amount to be reported.

Identified by:

Vendor #’s 146217 157375 167746 167747 167748 167749

9/28/2020 Page 5 of 12

167750 167751 169067

KD – Vendor Down Payment And

Clearing doc # starts with 1500*

Count and Sum of WCF Liquidation Transactions –Count and Sum of WCF Liquidation transactions (Doc Type KR) where the posting date, document number (1900*), and Special G/L Indicator of “Q” are not null and the first two positions of the user id are NS. The 1900* document number transactions that have the same 1900* doc number are to be counted as one (1) transaction.

Total dollar amount for liquidations (Doc Type KR) based on “LC amnt” and to be multiplied by negative 1 so that dollar amount appears positive for reporting purposes.

Identified by:

• Vendor #’s

• 146217

• 157375

• 167746

• 167747

• 167748

• 167749

• 167750

• 167751

• 169067

KR – Vendor Invoice

Doc # starts with 1900*

Special G/L Indicator of “Q”

9/28/2020 Page 6 of 12

Document type is KD

Posting date on Last month

Posting month year by Center

9/28/2020 Page 7 of 12

Placement / Location:

Dashboard: P & U - Internal - FM Dashboard / P & U - FM Dashboard ( Both internal &

External )

Dashboard Tab: Performance Measures

Name of Analytic: 3.1.1 Accounts Payable Payments

• SAP FBL1N Data [u_sap_fbl1n_data]

• Count of Working Capital Fund (WCF) Advance Transactions

Dates to show trend: Posting date

SLI: (Formula)

Count of completed Working Capital Fund (WCF) Advance Transactions by center, proces sed

Conditions:

Document Type is KD

Posting Date on Last month

Performance Measure Calculation = Number of advances with complete funds commitm ent documents that are processed within 4 business days/Total number of advances with co mplete funds commitment documents that are processed

• If the metric calculation is => 95%, the Performance Measure is met

• Breakdown will have the one categories:

Performance Measure Calculation – Placed above the existing Bar Graph

9/28/2020 Page 8 of 12

• y-axis should show the percentage on the left and the counts on the right

Also with the percentages being on the left, adjusting the percentage range to have the mon thly Performance Measure data points high on the chart.

• Add a threshold line (for the Performance Measure)

- Display current Performance Measure score with Met or Not-Met

Hover Over Information: 95% of advances with complete funds commitment documents a re processed within four business days by NSSC AP

• Breakdown will have the one categories:

• y-axis should show the percentage on the left and the counts on the right

Also with the percentages being on the left, adjusting the percentage range to have the mon

Hover Over Information: Process 98 % of payments on time

a. P&U SAP FBL1N Data.PostingDate.ThisMonth

b. P&U FM Scripted Metric Instances

1. P&U INT FM SAP FBL1N Data - Monthly

2. P&U INT FM WCF Advances - Monthly

9/28/2020 Page 9 of 12

3. P&U INT FM WCF Advances Met - Monthly

1. P&U EXT FM SAP FBL1N Data - Last Month

2. P&U EXT FM WCF Advances - Last Month

3. P&U EXT FM WCF Advances Met - Last Month

1. Working Capital Fund Advances: >=95%

2. Working Capital Fund Advances: >=95%

A. Core Location.Center Abbreviation

B. Metric Instance Met / Not Met

C. Locations

A. Center Abbreviation

B. Metric Center Abbreviation

C. Metric Met / Not Met

D. Metric Location

1. [PA Metric.All] Daily Data Collection - P&U INTERNAL

2. [PA Metric.All] Historical Data Collection - P&U INTERNAL

3. [PA SAP FBL1N Data] Daily Data Collection - P&U EXTERNAL

4. [PA SAP FBL1N Data] Historical Data Collection - P&U EXTERNAL

B. EXTERNAL

1. [PA Metric.All] Daily Data Collection - P&U EXTERNAL

2. [PA Metric.All] Historical Data Collection - P&U EXTERNAL

3. [PA SAP FBL1N Data] Daily Data Collection - P&U EXTERNAL

4. [PA SAP FBL1N Data] Historical Data Collection - P&U EXTERNAL

1. FM WCF Advances - Monthly PM

2. 3.1.1 Working Capital Fund - Advances

B. EXTERNAL

1. FM WCF Advances - Monthly PM

2. 3.1.1 Working Capital Fund - Advances

A. P&U INT FM Performance Measures

B. P&U EXT FM Performance Measures

9/28/2020 Page 10 of 12

C. P&U INT Performance Measures

D. P&U EXT Performance Measures

8. INDICATOR GROUPS:

A. N/A

9. Metric Definition

A. 3.1.1 Working Capital Fund Advances

10. Fix Script

A. Metric - Working Capital Fund Advances

11. FORM UPDATE / FORM LAYOUT

A. Table: metric_instance

9/28/2020 Page 11 of 12

9/28/2020 Page 12 of 12

Grants – Advance reconciliation – 3.1.1.2

9/28/2020 Page 2 of 9

9/28/2020 Page 3 of 9

I.3_FA_PWS Element Metric: Grants – Advance reconciliation

Y/N

Yes

Functional Area: Finance

PWS Section: 3.1.1.2

Performance

Area:

Accounts Payable

SO/SME

TYPE:

SLI/PM/OTHER

PM

Dependencies or impacts on other

Submitted

STRY0520410

STRY0539851

98% of the advances shall be reconciled by the end of the month with the balance reconciled before the end of the following period.

Tech Doc

9/28/2020 Page 4 of 9

Name of Report 3.1.1.2 Grants Advance Reconciliation

From SNOW, create a Performance Metric report with the following criteria:

- Name:

3.1.1.2 Grants Advance Reconciliation

- Table:

Finance Case [ u_finance_case ]

- Report Filter Criteria:

Category = Grants

Subcategory = CMP

Status = Created (current month)

Short Description Contains = "Grants" or "2B.1"

- Sharing:

Publish

Report output:

- [Case number]

- [Task Number}

- [Created}

- [Status]

- [Category]

- [SubCategory]

- [Short Description]

9/28/2020 Page 5 of 9

Category is GRANTS

SubCategory is CMP Created on This month

Short Description contains Grants or Short Description contains 2b.1

Number Created

Status (state) Category

SubCategory

Short Description Closed

9/28/2020 Page 6 of 9

- Dashboard Name:

P & U - Internal - FM Dashboard

- Dashboard Group:

Performance And Utilization - Internal

- Dashboard Tab:

FM Performance Measures

- Data Source Table:

Finance Case [ u_finance_case ]

- Name of Analytic on Internal Dashboard:

- Existing Report:

- Dates to show trend:

Created On

- Frequency:

Monthly

- Current Definition Name (If Used )

N/A

- Met/Not Met Definition Reference

When the criteria is satisfied for 10 cases, report as "Met"

If the above criteria is not satisfied or if all 10 cases are not satisfied, report as "Not

Met"

- PM Percentage Calculation:

If the metric calculation is >= 10, the PM is met

If the metric calculation is < 10, the PM is not met

- Stoplight is displayed at the top of the top of the Analytic

- Type of Visualization:

Bar Graph – Displays Count for the Month

Y-axis should show the percentage on the left and the counts on the right

Breakdown: Center & Met/Not Met

Add a threshold line (for the PM)

9/28/2020 Page 7 of 9

- Hover Over Information:

98% of the advances shall be reconciled by the end of the month with the balance reconciled before the end of the following period.

1. Using existing Indicator Source: P&U FM Case.Created.All.Monthly

2. Using existing Scheduled Data Collections

a. [PA Case] Daily Data Collection - P&U INTERNAL

b. [PA Case] Historical Data Collection - P&U INTERNAL

3. Add to existing Indicator Group: P&U INT FM Performance Measures

[https://nasadev.service-now.com/nav_to.do?uri=pa_tags.do?sys_id=f75d2c50db6cd3008f8a74131f96193b]

4. NEW Automated Indicator

a. P&U INT FM Case CMP All - Monthly [ https://nasadev.service-now.com/nav_to.do?uri=pa_indicators.do?sys_id=20a171f8db658890f8707c031f961947%

26sysparm_view=automated ]

5. NEW Formula Indicator

a. FM - Grants Advance Reconciliation Cases - 98% [ https://nasadev.service-now.com/nav_to.do?uri=pa_indicators.do?sys_id=ff837db0dba58890f8707c031f9619bb%

26sysparm_view=formula ]

6. NEW Target

a. https://nasadev.service-now.com/nav_to.do?uri=pa_targets.do?sys_id=9654bdb4dba58890f8707c031f961967

7. NEW Widgets

a. 3.1.1.2 Grants Advance Reconciliation [ https://nasadev.service-now.com/nav_to.do?uri=pa_widgets.do?sys_id=01757578dba58890f8707c031f96195e ]

b. FM CMP Cases - Monthly PM [ https://nasadev.service-now.com/nav_to.do?uri=pa_widgets.do?sys_id=ead6ee3cdbe98890f8707c031f961938 ]

8. ADD Widgets to existing Dashboard: P & U - Internal - FM Dashboard, FM

Performance Measures tab

9/28/2020 Page 8 of 9

9/28/2020 Page 9 of 9

Process Collections – 3.1.2

8/18/2022 Page 2 of 8

8/18/2022 Page 3 of 8

I.3_FA_PWS Element Metric: Process Collections

Y/N

Yes

Functional Area: Finance

PWS Section: 3.1.2

Performance

Area:

Accounts Receivable

SO/SME

TYPE:

SLI/PM/OTHER

PM

Dependencies or impacts on other

Submitted

STRY0495331 complete but additional data needed for completion of PM

Post 98% of collections (direct and reimbursable) without error.

8/18/2022 Page 4 of 8

8/18/2022 Page 5 of 8

Name of Report

Manual – SAP report

Validate Report 'AR - Collection Reversals - Last Month' pulling from data source AR following:

-Doc Types: DG, DW, DX, and DZ

-Reason: D1, V3, X1, X2, X3, Y1, Y5, Z1, Z2, C1, C2, C3, C4, C5, C6, V2, V4, Z5, V5, Z7

Reason Codes as of 8.30.2019.docx' for reference)

Validate that Doc Types: DG, DW, DX, and DZ are not captured for the following:

1. Report: AR NSSC Errors By Center

2. Report: AR Center Errors by Center

3. Widget: FM - Accounts Receivable - 98% Error free (Internal & External)

4. Widget: P&U AR Center Errors

5. Widget: P&U AR NSSC Errors

NOTE: To calculate performance measure for Collection SLA: (collection reversals)/(t

=(percentage) (100 – (percentage) = (%)

Collection reversals = AR - Collection Reversals - Last Month

Total Collections = AR - IPAC Collections + AR - Non-IPAC Collections

MET CONDITION: Percentage of calculation above is equal to or greater than 98%.

Report

Content

ServiceNow

1. UPDATE Reason [u_reason] field to dropdown

a. NEW Choices

2. NEW Report

a. AR - Collection Reversals - Last Month [ https://nasadev.service-now.com/sys_report_template.do?jvar_report_id=fe701b2cdb994c10ed6934cc7c961

3. UPDATE Reports to add 'DR' & 'WO' to additional conditions

a. AR NSSC Errors By Center [ https://nasadev.service-now.com/sys_report_template.do?jvar_report_id=0ce4121fdba43a008f8a74131f961

b. AR Center Errors by Center [ https://nasadev.service-now.com/sys_report_template.do?jvar_report_id=01b5161fdba43a008f8a74131f961

4. UPDATE Indicators to add 'DR' & 'WO' to additional conditions

a. External: P&U AR NSSC Errors - Last Month [ https://nasadev.service-now.com/nav_to.do?uri=pa_indicators.do?sys_id=6949c155db420f008f8a74131f961

b. External: P&U AR Center Errors - Last Month [ https://nasadev.service-

8/18/2022 Page 6 of 8 now.com/nav_to.do?uri=pa_indicators.do?sys_id=4d8c5e1ddb420f001475ff621f9619

c. Internal: P&U AR NSSC Errors [ https://nasadev.service-now.com/nav_to.do?uri=pa_indicators.do?sys_id=bec71077dbbd83001475ff621f961

d. Internal: P&U AR Center Errors [ https://nasadev.service-now.com/nav_to.do?uri=pa_indicators.do?sys_id=d3a61437dbbd83001475ff621f961

5. UPDATE Indicators to add 'DR', 'RV', 'WO', 'WV'

a. External: P&U AR Total Receivables - Last Month [ https://nasadev.service now.com/nav_to.do?uri=pa_indicators.do?sys_id=d2d8c155db420f008f8a74131f961

b. Internal: P&U AR Total Receivables [ https://nasadev.service-now.com/nav_to.do?uri=pa_indicators.do?sys_id=dc203db7db1ecb408f8a74131f961

Database

6. BIDW: UDPATE Package NSSC_STAGE.load_sap_receivables, procedur into Reversal

Data from external table – sum 'Amount' for multiple entries

7. BIDW: ADD 'V4 Incorrect Amount Collection' into WAREHOUSE_LOOKUP

8. DBUS: UPDATE View BIDW_SAP_BILLING_ERROR_RCVB_VW Script, a

Input

No report, manual process.

8/18/2022 Page 7 of 8

No report, manual process.

No analytic at this time

8/18/2022 Page 8 of 8

8/18/2022 Page 9 of 8

Execute Dunning Process – 3.1.2

Date Last Modified 12/07/2021

9/28/2020 Page 2 of 10

The following ServiceNow Business Rules outline the requirements in order to process the report data requirements and also provides the supporting information/documentation for validation/verification purposes which allow for:

9/28/2020 Page 3 of 10

I.3_FA_PWS Element Metric: Execute Dunning Process

Y/N

Yes

Functional Area: Finance

PWS Section: 3.1.2

Performance

Area:

Accounts Receivable

SO/SME

TYPE:

SLI/PM/OTHER

PM

Dependencies or impacts on other

STRY0791146

Process delinquent demand (dunning) letters with no more than 5 instances per month processed late or with errors.

Tech Doc

9/28/2020 Page 4 of 10

Report

FM - AR Metrics - I-3 3.1.2 - Execute Dunning Process

Generate a report from the Service Now table u_quality_control: The query condition

- group by aggregate counts

- pivot report

DEVELOPMENT

Create New Report Name: 'FM - AR Metrics - I-3 3.1.2 - Execute Dunning Process'

***TESTER***

To Create a new Quality Control Record:

1. Go to any FAR Record

2. Go to the Finance Request Task

3. Quality Controls at the bottom, create new, fill in mandatory fields, Error Reason

Table is Quality Control {u_quality_control}

Type contains Finance RequestTask

Error Reason is DUNNING LETTERS

Created on Last month

9/28/2020 Page 5 of 10

Category

Error Reason

9/28/2020 Page 6 of 10

Placement / Location:

Dashboard: P & U - Internal - FM Dashboard / P & U - FM Dashboard (Both internal & External) Dashboard Tab: FM Performance Measures - SNTR Dashboard Group: Performance And Utilization - Internal / Performance And Utilization

Name of Analytic: I3 – 3.1.2 Execute Dunning Process Data Source: Table:

• Quality Control [u_quality_control]

• FM - AR Metrics - I-3 3.1.2 - Execute Dunning Process Dates to show trend: Created

On

Performance Measure: (Formula) No more than 5 instances of dunning letters per month processed late OR with errors.

Count of Quality Errors with error reason being DUNNING LETTERS. (over 5)

Type contains Finance Task Sub Cat is Dunning Letters Error Reason is DUNNING LETTERS Created on Last month

Performance Measure = Count of Processed delinquent demand (dunning) letters with no more than 5 instances per month processed late or with errors.

• If the Performance measure calculation is = <5 instances per month, the

Performance Measure is met (green)

• If the Performance measure calculation is over 5 then it is not met (red)

• Stoplight is displayed at the top of the top of the Analytic

Bar Graph – Displays Count of 5 instances per month by Center for the Month

• Breakdown will have one category Breakdown by Center Met/Not Met

9/28/2020 Page 7 of 10

• y-axis should show the counts on the left

Hover Over Information: Process delinquent demand (dunning) letters with no more than 5 instances per month processed late or with errors.

For I3 – 3.1.2 Execute Dunning Process, insert and stay on P&U INT FM Dunning Process - Monthly while changing the conditions to check for Type contains "Finance Request Task". Put newly created indicator on formula FM - Execute Dunning Process

- Not To Exceed 5, adding to already existing formula and Insert and Stay.

For report FM - AR Metrics - I-3 3.1.2 - Execute Dunning Process, add OR condition below Type for Type contains "Finance Request Task"

Create new Widgets I3 – 3.1.2 Execute Dunning Process, and FM Dunning Process - Monthly PM by Insert and Stay, and add new formula from above to them.

DEVELOPMENT CONFIGURATIONS

Adjusted existing report to include 'Finance Request Task' as a condition […/nav_to.do?uri=%2Fsys_report_template.do%3Fjvar_report_id%3D7b14cc84dba50 7401475ff621f961951%26jvar_selected_tab%3DallReports%26jvar_list_order_by%3D %26jvar_list_sort_direction%3D%26sysparm_reportquery%3DFM%20- %20AR%20Metrics%20-%20J-3%203.1.2%20- %20Execute%20Dunning%20Process%26jvar_search_created_by%3D%26jvar_searc h_table%3D%26jvar_search_report_sys_id%3D%26jvar_report_home_query%3D]

Dashboard:

Created new Automated Indicator "P&U INT FM Dunning Process - Monthly - SNTR […/nav_to.do?uri=pa_indicators.do?sys_id=0ff381f01bc3b81026a442e2b24bcb63%26 sysparm_view=automated]

Created new Formula Indicator to include the new one above […/nav_to.do?uri=pa_indicators.do?sys_id=476545b41bc3b81026a442e2b24bcbfd%2 6sysparm_view=formula]

Created New Chart Widget for I3 - 3.1.2 Execute Dunning Process - INTERNAL -

SNTR

9/28/2020 Page 8 of 10

[…/nav_to.do?uri=pa_widgets.do?sys_id=3b3785f81bc3b81026a442e2b24bcbb8]

Created New Score Widget for FM Dunning Process - FY to Date - SNTR […/nav_to.do?uri=pa_widgets.do?sys_id=7978c5bc1bc3b81026a442e2b24bcbc8]

9/28/2020 Page 9 of 10

a. P&U Quality Controls.Created.ThisMonth

1. P&U INT FM Dunning Process - Monthly

1. P&U EXT FM Dunning Process - Last Month

1. Execute Dunning Process:

2. Execute Dunning Process:

A. Core Location.Center Abbreviation

A. Center Abbreviation

6. JOBS

A. [PA Quality Control] Historical Data Collection - P&U INTERNAL B. [PA Quality Control] Daily Data Collection - P&U INTERNAL C. [PA Quality Control] Historical Data Collection - P&U EXTERNAL D. [PA Quality Control] Daily Data Collection - P&U EXTERNAL

7. WIDGETS

• INTERNAL

• I3 – 3.1.2 Execute Dunning Process

• FM Dunning Process - Monthly PM

• EXTERNAL

• I3 – 3.1.2 Execute Dunning Process

• FM Dunning Process - Monthly PM

• INDICATOR GROUPS

• P&U INT FM Performance Measures

• P&U EXT FM Performance Measures

• P&U INT Performance Measures

• P&U EXT Performance Measures

9/28/2020 Page 10 of

9/28/2020 Page 11 of

RELEASED - Printed documents may be obsolete; validate prior to use.

Accounts Receivable Billings – 3.1.2

Date Last Modified 9/29/2021

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 2 of 19

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 3 of 19

I.3_FA_PWS Element Metric: Accounts Receivable Billings

Y/N

Yes

Functional Area: Finance

PWS Section: 3.1.2

Performance

Area:

Accounts Receivable

SO/SME

TYPE:

SLI/PM/OTHER

SLI

Dependencies or impacts on other

STRY0216460, STRY0275269, STRY05398, STRY0803436,

STRY0803477

98 % of bills will be created without error attributed to the NSSC

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 4 of 19

Name of Report AR - New Receivables – Last Month

Summary:

Graph: Stacked bar chart. Count of bills of collection, by center, by document type and by reporting period.

Crosstab: Count of bills of collection by center, by document type and by reporting period.

FBL5N Detail:

Account (customer number) Assignment Document No.

Type (document type) Clrng doc (clearing document) BusA (business area) User Name Doc. Date (document date) Amt in loc. Cur (amount in local currency) FBL3N Detail:

Report Content Assignment Document No (document number) BusA (business area) PK (posting key) User Name Doc. Date (document date) Amt in loc. Cur. (amount in local currency) Text field

Bills of collection identified by document types DR, RV, WO, and WV. Bills of collection identified by document type WT* as stipulated in item #3 below.

Reporting period is determined by Posting Date.

• Exclude transactions associated with the following

Customer Numbers: 1784, 1785, 1816, 1817, 1818, 1819, 1820, 1821, 1822, 1823, 3578, 3586, 3587, 3589, 3590, 3591, 3592, 3594, 3618, 3619, 4881, 4931, 5102, 5103, 5104, 5105, 5116, 5117, 5297, 5553, 5851, 5852, 5853, 5854 and 5855. These

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 5 of 19 should be excluded because they are transactions executed by NSSC I3PBO and BAD. (FBL5N)

• Count each unique document number one time only per document type within a given fiscal year. If a document number appears multiple times for a given document type in the same fiscal year, remove the multiples and only count once. (FBL5N and FBL3N)

• Include transactions with document type WT with a User ID beginning with “NS” AND where the Text Field begins with “Travel”. Document type WT is being used by NSSC AR for Travel Debts $75 and under. These transactions should be billed to the government by the Service Provider but should not be charged in the Centers utilization. (FBL3N)

Exclude transactions for document types DR, WO, WV and RV when the User ID does not begin with “NS”. Centers use the listed document types and their transactions should not be counted in the utilization. (FBL5N)

Table is SAP Receivables {u_sap_receivables} Posting date on Last month

Document type starts with DR or

Document type starts with RV or Document type starts with WO or

Document type starts with WV Account is not javascript: new u_nssc_sap_receivables_methods().accountExcludes()

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 6 of 19

Document type by Center

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 7 of 19

Name of Report AR NSSC Errors By Center

Table is AR Billing Reversals {u_ar_billing_reversals} Type is pivot table Row is Reason Column is Center Aggregation is Count No. groups is System Default

Error Group start with NSSC Reversal posting date on Last month Document type is one of DR or WO

Reason by Center

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 8 of 19

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 9 of 19

Placement / Location:

Dashboard Name: FM Dashboard

Dashboard Tab: AR

Dashboard Group: Performance and Utilization - Internal

Name of Analytic: I3 – 3.1.2 Accounts Receivable Billing & AR Doc Types -

Performance by Center

Data Source: Table:

• SAP Receivables [u_sap_receivables]

• AR Billing Reversals [u_ar_billing_reversals]

• AR - New Receivables - Last Month

• AR - IPAC Collections

• The AR – Non-IPAC Collections Report and the FM Accts Receivable-

Advances by Center (Doc Type DP)

• AR Center Errors by Center

• AR NSSC Errors By Center

Dates to show trend: Posting Date, Reversals Posting Date

SLI: (Formula)

• Metric Calculation Percentage = AR-NSSC Errors by Center Report [Total] / AR-

New Receivables-Last Month Report [Total]

• If the metric calculation is => 98%, the SLI is met

Bar Graph – Displays All Doc Types for current FY to last month

• Breakdown will have the three categories:

• New Receivable Total o Breakdown by Center

• IPAC by Center Total o Breakdown by Center

• Collections on Receivables o Breakdown by Center

SLI Calculation – Placed above the Bar Graph

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 10 of 19

Breakdowns:

When drilling down on the bar graph:

• New Receivable Total o Breakdown by Center

• IPAC by Center Total o Breakdown by Center

• Collections on Receivables o Breakdown by Center

When drilling down on the SLI Met or Not Met:

• AR-NSSC Errors Total o Breakdown by Center

• AR-Center Errors Total o Breakdown by Center

DEVELOPMENT: (See attached for formatted Tech Design Documentation

PA DASHBOARD GROUPS: [ pa_dashboards_group ] ( Do a *.list on these tables for qui ck navigation )

1. Performance & Utilization – Internal

a. Order = 300

2. Performance & Utilization

a. Order = 100 b.

Visible to = Groups And Users, with the intent to convert to alternative choice of "Everyon e" at a later date.

PA DASHBOARDS: [ pa_dashboards ]

1. P & U – Internal – Overall

a. Order = 100

b. Sharing:

i. Can View – pa_viewer

ii. Can Edit – pa_contributor

c. Dashboard Properties

i. Restrict to roles

1. pa_viewer, pa_contributor

d. Owner = Matthew Drudy

2. P & U – Internal – FM Dashboard

a. Order = 300

b. Sharing:

i. Can View – pa_viewer

ii. Can Edit – pa_contributor

c. Dashboard Properties

i. Restrict to roles

1. pa_viewer, pa_contributor

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 11 of 19

d. Owner = Matthew Drudy

e. Tabs:

i. FM Performance Measure

1. Order = 100

ii. AR

1. Order = 200

3. P & U – Overall ( Public Facing )

a. Order = 100

b. Sharing:

i. Can View ( none with the exception of the OTB access governance )

1. No roles added

a. The following users are still provided access

i. Admin

ii. PA Admin / PA Power User

iii. Matthew Drudy – Dashboard Owner

ii. Can Edit – ( same as above)

c. Dashboard Properties

i. Restrict to roles

1. ( none )

d. Owner = Matthew Drudy

4. P & U – FM Dashboard ( Public Facing )

a. Order = 300

b. Sharing

i. Can View ( none with the exception of the OTB access governance )

1. No roles added

a. The following users are still provided OTB access

i. Admin

ii. PA Admin / PA Power User

iii. Matthew Drudy – Dashboard Owner

ii. Can Edit – Admin

c. Dashboard Properties

i. Restrict to roles

1. ( none )

d. Owner = Matthew Drudy

PA INDICATOR SOURCES:

1. INTERNAL:

a. P&U SAP Receivables.All.Monthly

i. Condition:

1. Posting Date – This Month.

b. P&U AR Billing Reversals.All.Monthly

i. Condition:

1. Reversal Posting Date – This Month

2. EXTERNAL:

a. P&U SAP Receivables.All.Monthly.LastMonth

i. Condition:

1. Posting Date – This Month

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 12 of 19

b. P&U AR Billing Reversals.All.Monthly.LastMonth

i. Condition:

1. Reversal Posting Date – This Month

PA INDICATORS:

1. INTERNAL

a. P&U AR – New Receivables – Monthly

i. Type = Automated

ii. Conditions

1. Taken from Report Named "AR – New Receivables – Last Month"

b. P&U AR – IPAC Collections – Monthly

i. Type = Automated

ii. Conditions:

1. Taken from Report Named "AR – IPAC Collections"

c. P&U AR – NON IPAC Collections – Monthly

i. Type = Automated

ii. Conditions:

1. Taken from Report Named "AR – Non-IPAC Collections Report"

d. P&U AR Center Errors

i. Type = Automated

ii. Conditions:

1. Error Group – Starts With - Center

e. P&U AR NSSC Errors

i. Type = Automated

ii. Conditions:

1. Error Group – Starts With – NSSC

f. P&U AR - All Doc Types

i. Type – Automated

1. Conditions = None

a. Keeping all to be seen by a scripted bucket group

g. P&U AR – Total Receivables

i. Type – Automated

ii. Conditions:

1. Error Group – is empty

iii. Aggregate

1. Sum

2. Field – Receivables counter

h. Accounts Receivable – 98% Error Free

i. Type – Formula

ii. Description

1. P&U INT – AR – Accounts Receivable 98% Error Free

iii. Direction:

1. Maximize a.

Note: This indicator is trying to communicate if we are above 98%, therefore we are showing the act of MAX values which are used to color against our target color scheme ranges that we have defined.

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 13 of 19

2. EXTERNAL:

a. P&U AR Center Errors – Last Month

i. Type – Automated

b. P&U AR – All Doc Types – Last Month

i. Type – Automated

c. P&U AR NSSC Errors – Last Month

i. Type – Automated

d. P&U AR Total Receivables – Last Month

i. Type – Automated

e. Accounts Receivable – 98% Error Free

i. Type – Formula

ii. Description:

1. P&U EXT – AR – Accounts Receivable 98% Error Free

iii. Direction

1. Maximize

Note: This indicator is trying to communicate if we are above 98%, therefore we are showing the act of MAX values which are used to color against our target color scheme ranges that we have defined.

INDICATOR GROUPS:

1. P&U EXT FM AR Stoplight Scores Monthly

a. Indicator(s)

i. Accounts Receivable – 98% Error Free (EXTERNAL FORMULA INDICATOR)

ii. Order = 100

2. P&U INT FM AR Stoplight Scores Monthly

a. Indicator(s)

i. Accounts Receivable – 98% Error Free (INTERNAL FORMULA INDICATOR)

ii. Order = 100

PA BREAKDOWN SOURCE / BREAKDOWN

1. SAP Centers [ u_sap_receivables.u_center ]

a. Facts Table = sys_choice

i. Table = u_sap_receivables

ii. Element = u_center

iii. Inactive = false

2. SAP Document Type [ u_sap_receivables.u_document_type ]

a. Facts Table = sys_choice

i. Table = u_sap_receivables

ii. Element = u_document_type

iii. Inactive = false

3. SAP Receivables.Document Type.Scripted

a. Facts Table = pa_buckets

i. Bucket Group = AR – All Doc Type Indicators

PA BUCKET GROUP

1. AR – All Doc Type Indicators

a. Result 1 = New Receivables Total

i. Range – ( 0 – 2)

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 14 of 19

b. Result 2 = IPAC by Center Total

i. Range – (2 – 3)

c. Result 3 = Collections on Receivables

i. Range – (3 – 4)

PA BREAKDOWNS

1. AR – Breakdown By Indicator

a. Breakdown Source

i. SAP Receivables.Document Type.Scripted

b. Breakdown Mappings

i. u_sap_receivables

1. Script – AR – Indicator Buckets – SAP Receivables

2. SAP Center

a. Breakdown Source

i. SAP Center [u_sap_receivables.u_center]

b. Breakdown Mappings

i. u_sap_receivables

1. Field – u_center

3. SAP Document Type

a. Breakdown Source

i. SAP Document Type

b. Breakdown Mappings

i. u_sap_receivables

1. Field – u_document_type

PA SCRIPTS

1. AR – Indicator Bucket – SAP Receivables

a. Fields: Account, Center, Document type, User name, Document date

b. Facts Table: u_sap_receivables

PA JOBS:

1. INTERNAL JOBS USED FOR MOST RECENT SCORES TO DATE

a. [PA AR Billing Reversals] Historical Data Collection – P&U INTERNAL

i. Runs: onDemand

b. [PA SAP Receivables] Historical Data Collection – P&U INTERNAL

i. Runs: onDemand

c. [PA SAP Receivables] Daily Data Collection – P&U INTERNAL

i. Runs: 07:00:00

1. As: PA Data Collector

d. [PA AR Billing Reversals] Daily Data Collection – P&U INTERNAL

i. Runs: 07:00:00

1. As: PA Data Collector

2. EXTERNAL JOBS USED TO ONLY SCORE UP TO LAST MONTH

a. [PA AR Billing Reversals] Historical Data Collection – P&U EXTERNAL

i. Runs: onDemand

b. [PA SAP Receivables] Historical Data Collection – P&U EXTERNAL

i. Runs: onDemand

c. [PA SAP Receivables] Daily Data Collection – P&U EXTERNAL

i. Runs: 07:00:00

RELEASED - Pr9i/n2t8e/d20d2o0cuments may be obsolete; validate prior to use. Page 15 of 19

1. As: PA Data Collector

d. [PA AR Billing Reversals] Daily Data Collection – P&U EXTERNAL

i. Runs: 07:00:00

1. As: PA Data Collector

PA WIDGETS:

1. INTERNAL (Lookup Name Contains P&U INT)

a. P&U – AR – New Receivables

i. Type: Score

b. P&U – AR – NON-IPAC Collections

i. Type: Score

c. P&U – AR – IPAC Collections

i. Type: Score

d. P&U AR Center Errors

i. Type: Score

e. P&U AR NSSC Errors

i. Type: Score

f. P&U AR – Monthly SLI

i. Type: Score / Dial

1. Used to display Target & Target Color Scheme +/- 98% [ Green / Red ]

g. I3 – 3.1.2 Accounts Receivable Billing & AR Doc Types - Performance by Center

i. Type: Time Series

h. P&U FM AR Stoplight Scores Monthly

i. Type: List

1. Indicator Group

a. P&U INT FM AR Stoplight Scores Monthly

2. EXTERNAL (Lookup Name Contains P&U EXT)

a. P&U AR Monthly SLI

i. Type: Score / Dial

1. Used to display Target & Target Color Scheme +/- 98% [ Green / Red ]

b.