Average Days Outstanding metric

Identifies operational performance of receivables.

Details of the metric Description
Name Average Days Outstanding
Category Operational
Analysis objective Determines which payment issues exist, including bad creditors. Can be used to indicate whether to terminate a contract.
Description Lease receivables that are measured in average days outstanding.
Source Customer Focus Group
Measurement Average of Outstanding Receivables (TODAY – Payment Due Date)
Dependent data that is calculated Payment Line Items:
  • Outstanding Receivables = Payment Line Items, where due date less than or equal to TODAY AND date paid is NULL
  • Payment Due Date
  • Paid Date
Roles RE Contract Manager
Display chart types
  • Value-based: Horizontal Grouped Bar (percent) Chart
  • (Capture Period: Vertical Grouped Bar (percent) Chart)
Thresholds
  • Low Threshold: 10
  • High Threshold: 30
  • Range 1: Good/Positive/Green
  • Range 2: On Target/Caution/Yellow
  • Range 3: Poor/Negative/Red
Fact details Module: triMetricFact

Business Object: triREPaymentFact

Metric Queries: triREPaymentFact - Metric - Average Days Outstanding
Drill paths
  • Organization
  • Payment Type
  • Contract Name
  • Contract Type
  • Capture Period
Interactive filters
  • Organization
  • Contract Name
  • Payment Type
  • Contract Type
Static filters
  • Payment Line Items paid in data point refresh period
  • RE Contracts filtered to Active User (USERID) = Contract Administrator
Suppress zero values
  • Yes, suppress graphic display of zero values
  • Yes, suppress interactive filters list or drill-path list with zero values
Time Months
Data point refresh rate Monthly
License dependency
  • Real Estate
  • Facilities
Functional dependency
  • Space Use Agreements (Real Estate)
  • Space Allocations (Facilities)