1 / 51

PTAGIS - TDS Tag Distribution System

PTAGIS - TDS Tag Distribution System. Doug Clough 2 December 2008. Database Overview. Core tables + TPA (TDI) Tagging and Interrogation Data ALRS Where Tagging & Interrogation take place PPO Who receives the tags. WHAT PTAGIS does. WHERE it happens. WHO is involved.

jamese
Download Presentation

PTAGIS - TDS Tag Distribution System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PTAGIS - TDSTag Distribution System Doug Clough 2 December 2008

  2. Database Overview • Core tables + TPA (TDI) • Tagging and Interrogation Data • ALRS • Where Tagging & Interrogation take place • PPO • Who receives the tags WHAT PTAGIS does WHERE it happens WHO is involved

  3. Database Overview • Core tables • Tagging and Interrogation Data • Site Configuration • TPA (TDI) • Distributing PIT tags to projects • ALRS • Where Tagging & Interrogation take place • PPO • Who receives the tags

  4. ALRS Schema: Modeling PTAGIS Activities

  5. ‘Core’ Tables: “What” ALRS: “Where” WQB = PTAGIS Web Query Builder ALRS Schema How would this help? Greater convenience and flexibility for PTAGIS user community Original PTAGIS Tables

  6. But where do the tags come from?!!?

  7. But where do the tags come from?!!? The missing activity!! Distributing

  8. Distributing PIT Tags • TDI (Tag Distribution & Inventory) • Used for over 10 years • New requirements arose (ISRP) • Maintain history of project personnel through time • Provide linkage between people, projects, and activities • Business process changed • BPA now purchases PIT tags • New technology gave new opportunities

  9. Distributing PIT Tags • TDS (Tag Distribution System) • Production deployment September 2008 • Interacts with PPO tables to help … • Maintain history of project personnel through time • Keep linkages between people, projects, and organizations up to date • Supports streamlined business process • Requests and approvals entered on-line • Eliminates PDRF forms • TDI data will be copied into the TPA tables

  10. TDS Automates the Tag Distribution Process

  11. TDS Automates the Tag Distribution Process

  12. PPO Schema: Modeling PTAGIS Participants

  13. PPO Tables Associate … • Offices with addresses and organizations • People with offices • Organizations with people and projects • People with project-specific roles Relationships are tracked through time

  14. PPO Tables … • Populate drop-down lists • Participant names • Addresses for selected person • Capture participant roles • Tag Requester • Tag Recipient • Any number of roles for one person • Tracked through time (In TDS – Other uses in other sub-systems)

  15. TDS Automates the Tag Distribution Process

  16. TPA Schema: Models PIT Tag Distributing The missing activity!!

  17. TPA Tables Capture … • PIT tag requests • Quantity by month and type • Recipient names and addresses • PIT tag purchases and initial custody • PTAGIS inventory • Other: USACE • PIT tag approvals • PIT tag distributions to projects • User interaction with TDS identifies • Who requests tags • Who receives tags

  18. TPA Tables Capture … • PIT tag requests • Quantity by month and type • Recipient names and addresses • PIT tag purchases and initial custody • PTAGIS inventory • Other: USACE • PIT tag approvals • PIT tag distributions to projects • User interaction with TDS identifies • Who requests tags • Who receives tags PPO TPA proj_id

  19. TDS Automates the Tag Distribution Process

  20. Project POC enters anticipated tag quantities … 3 Roles Basic, Approval, Inventory

  21. Project POC enters anticipated tag quantities … Project list populated from PPO tables

  22. Project POC enters anticipated tag quantities … Note: This project has been “pre-approved”

  23. Project POC enters anticipated tag quantities … Click here if no tags are required

  24. Approvals can be entered before or after requests … Exercising the Approval Role

  25. Approvals can be entered before or after requests … Blue highlighting indicates un-saved changes

  26. Project POC Identifies Recipients (last names beginning with ‘mar’) … Exercising the Basic role again PPO tables provide names and addresses

  27. Corresponding Addresses, Plus ‘Other’ … Select an address, then click the button …

  28. Initially, all tags assigned to one recipient …

  29. Two assigned recipients, red arrows mean incomplete details …

  30. Details expanded, incomplete items in red … Stored in TPA tables Stored in TPA tables

  31. Shipment details complete; SaveChanges Enabled …

  32. Blue highlighting goes away when changes have been saved …

  33. (Before or after) BPA administrator approves requested quantities …

  34. Project POC checks approval and adjusts quantities as necessary …

  35. Exercising the Inventory Role: Distribute tab … Exercising the Inventory role No project is selected Number of shipments (Number of tags in ‘tool tip’)

  36. List of recipients and tag quantities; read-only … Click a ‘cell’ to see shipment details

  37. Shipment details for one of the recipients; read-only …

  38. List of recipients and tag quantities; read-only … Check the checkbox Click the button

  39. 30,000 Tags; 3 full boxes … Pick list generated from data in TPA tables

  40. Pick List: “Retrieve from Inventory” …

  41. Shipment is Packed; Must save changes …

  42. Packing lists showing “Ready for Shipment” … Shipment containing boxes and vials

  43. Inventory Role: Distribution “Packed” and “Sent” … P – Packed S – Sent R – Received

  44. Basic Role: Distribution “Packed” and “Shipped” … Exercising the Basic role again P & S – Read-only R can be ‘checked’

  45. Anticipating arrival of tags from DestronFearing …

  46. Receiving tags into PTAGIS inventory …

  47. But wait! There’s more … • Automated registration of tag shipments • Backbone is built and in use • Need to build e-mail enabled driver • Email alerting of significant events • IMMEDIATE alert of approval and shipping • Built and in use • LAZY alert of request / recipient changes • Built and undergoing pre-deployment tests

  48. TDS Automates the Tag Distribution Process Email

  49. (and just a little more) … • Automated registration of tag shipments • Backbone is built and in use • Need to build e-mail enabled driver • Email alerting of significant events • IMMEDIATE alert of approval and shipping • Built and in use • LAZY alert of request / recipient changes • Built and undergoing pre-deployment tests

More Related