A. What is your idea?
1) Classification
Opportunity for improvement
2) Brief description
When a Task is pointed at a system slot, a requirement advisory standard message is;
| Requirement Completion Advisory | “The requirement task_task.task_cd (task_task.task_name) was completed on inv_inv.serial_no_oem. Notes: task_advisory.advisory_ldesc” |
ISSUE:
- inv_inv.serial_no_oem on a sys slot is always ‘XXX’
- When the task is TRK Slot or PNB this returns only the SN of the Inventory.
IMPROVEMENT IDEA:
- For PNB/TRK slot requirements, users would benefit the message to include eqp_part_no.part_no_oem as well as inv_inv.serial_no_oem.
- Update the message to Include the INV_AC_REG for SYS Tasks
- Add the Task Barcode, in the name.
- (Possible update) Update core logic that all inv_inv.inv_class = ‘SYS’ has the same serial number as the H_INV instead of ’XXX’ (The two can never be separate entities)
RESULT:
| Requirement Completion Advisory | “The requirement task_task.task_cd (task_task.task_name [sched_stask.barcode_sdesc]) was completed on -Inventory Serial Number if the task is TRK/PNB, or null (-Part Number if TRK/PNB Task, or null) or -Serial Number of Aircraft when SYS task, or null (Aircraft Registration Number, or null) , Notes: task_advisory.advisory_ldesc” |
I know there is a fancy code way of writing that, but that not my forte…. still learning.
Currently looks like this, line 1 is an SYS Task, Line 2 is a TRK Slot task.
Suggested Enhancement
B. Context and scope
1) Who is affected?
Internal users
2) Frequency
Frequently
C. Value and impact
1) What is the business outcome?
- Improves productivity or efficiency
- Reduces cost or manual effort
- Enhances user experience
- Enables new capability
- Supports compliance or reduces risk
2) Impact scale
4 — Company-wide
3) Workaround
Custom Jasper Reports, External BI Tools, Database Interrogation or “death by clicks”
D. Evidence and examples
Attached
E. Additional details
1) Enter support ticket ID reference (If applicable)
Previous Enhancement changed the alert from returning ‘INV_AC_REG’ as when it was PNB, the alerts came in with NA, and users needed to check for task completions manually.
Circa version 8, 2015 maybe.
2) Would you like to participate in validation or early testing?
Yes, but also suggest other operators/users deserve input if this enhancement has merit or needs to be altered.