Op Ex Daily Open Items
AcId: 103332
Tables
Table
Alias
Join condition
Type
Incident Performance
inc_performance
 
 
Incidents
incidents
inc_performance.i_id = incidents.i_id
Inner
Threads
threads
incidents.i_id = threads.i_id
Inner
Accounts
accounts
inc_performance.acct_id = accounts.acct_id
Inner
Filters
Logical Expression: asdasd AND Department AND Open Date Span AND Exception AND Status AND Mini-Bid
Type
Name
Prompt
Expression
Operator
Value
Data Type
Fixed
Department
Department
incidents.assgn_group_id
in list
Procurement Support, Accounts Payable, P2P Contact Center, P2P Operational Excellence, SDC Procurement, SOBO/ROBO, SCM Master Data
Menu
Fixed
Open Date Span
Open Date Span
incidents.created
between
06/20/2012 12:05 AM to +1 Days Rounded
Date Time
Fixed
Exception
Exception
incidents.c$incident_type
not equals
Exception Invoice
Menu
Fixed
Status
Status
incidents.status_id
in list
Pending, Reviewing, Unresolved, Updated, Waiting on Customer, Confirmed, Send to AP, Send to Business Systems Support, Send to Communications & Change, Send to Continuous Improvement, Send to Emp Services, Send to HRIS, Send to IT315, Send to Org Hierarchy, Send to Overpayments, Send to Strategic Procurement, Send to SUS, Send to Payroll - Tier 1, Send to Payroll - Tier 2, Send to HR Specialist, Send to Performance Management, Send to Procurement, Send to Procurement - Global, Send to Tactical Procurement, Send to Procurement Support, Send to Procurement Support - Tier 2, Send to QA, Send to USFP, Solved PCD, Transfer to COE, Send to SRM Admin, Send to Resolver, Send to ARIBA, Send to P2P Reporting, Send to Vendor Master, Send to Payments, Send to P-Card, Send to Work Stoppage, Send to Contract Master, Send to SM PSC, Send to Shared Metering, MDM Revision Needed
Menu
Fixed
Mini-Bid
Mini-Bid
incidents.queue_id
not equals
MSA Mini-bid
Menu
Run-time selectable
asdasd
asdasd
inc_performance.intv_type
equals
Create to Final Resolved
Menu
Variables
Type
Name
Prompt
List Type
Value
Data Type
Replacement Value
$CustomerNote
$CustomerNote
 
min(if(threads.entry_type= 1, threads.entered))
Date Time
Replacement Value
$StatusChange
$StatusChange
 
min(if(incidents.status_type=3, incidents.updated))
Date Time
Level: Grid Report
Columns
Heading
Expression
Data Type
Description
Sort Order
Sort Direction
Reference #
incidents.ref_no
Text
 
 
None
Assigned Account
incidents.assgn_acct_id
Menu
 
 
None
Subject
incidents.subject
Text
 
 
None
Category ID
incidents.cat_id
Menu
 
 
None
Date Created
incidents.created
Date Time
 
 
None
Date 1st Resp
nvl($CustomerNote, $StatusChange)
Date Time
 
 
None
Status
incidents.status_id
Menu
 
 
None
Pending Reason
incidents.c$pending_reason
Menu
 
 
None
Days Open
avg(inc_performance.rel_time)
Float
 
1
Descending
Resp. Days
date_diff(nvl($CustomerNote, $StatusChange) ,incidents.created)/86400
Float
 
 
None
Exceptions
Name
Expression
Operator
Value
Display Reference
> 24 hr Response
date_diff(nvl($CustomerNote, $StatusChange) ,incidents.created)/86400
greater than
1.00
Resp. Days
No Response
date_diff(nvl($CustomerNote, $StatusChange) ,incidents.created)/86400
is null
 
Resp. Days
> 30 Days
avg(date_diff(sysdate(),incidents.created))/86400
greater than
30.00
Entire Row
> 10 Days
avg(date_diff(sysdate(),incidents.created))/86400
greater than
10.00
Entire Row