R-PMS System Use Cases : Model . R-PMS System - Q1 : System
Use Case - T03-04 Start loading TCR data link
Properties |
Name | Value | ||||||||
Description |
Transverse cracking is a pavement surface distress that demands attention. It is a driver for many pavement action decisions, but it is not easily reported from the Integrator Software in a manner that works for PMS. PMS developed a separate procedure to extract the relevant TCR data directly from the XML files and store it in the PMS Oracle database. This data table then becomes the input to other tools to allow PMS to report and incorporate information about TCR into the KDOT management process. |
||||||||
Transit From |
|
||||||||
Id | UC24 | ||||||||
Abstract | false | ||||||||
Leaf | false | ||||||||
Root | false | ||||||||
Stereotypes | UseCase, PMS Activity | ||||||||
Business Model | false | ||||||||
Status | Identify | ||||||||
Rank | Unspecified |
Relationships Summary |
Name | Begin | End | |||
|
|
|
Use Case Note |
■ Inputs or Prior Activities | |||
• KHS and NHS have been scanned by LCMS | |||
• Pavemetrics software tool has been used to generate reports as XML data files | |||
• Inputs: | |||
♦ XML files for each route collected | |||
♦ Currently use RVE Routes fields to link back to CMPs (and possibly PMS IDs) - most likely this needs to be done later and is not necessary for this Use Case | |||
• Code to read the XML files | |||
• Code to write the data to the PMS.LCMSTRANSCRACKS database table | |||
• Queries to complete the load process | |||
■ Actions | |||
• Create a listing of routes | |||
• Fire off the scripts to load the routes | |||
■ Outputs | |||
• Populated data table with TCR data in the PMS.LCMSTRANSCRACKS database table |
Scenario |
Steps | |||
1. ![]() |
|||
1.1. creates a set of routes for TCR data loads creating a script identifying the data | |||
1.2. submits the scripts for data processing and loading | |||
2. SYSTEM | |||
2.1. Reads the specified XML data files from the route set | |||
2.2. Extracts the TCR data from the XML files | |||
2.3. Load the TCR data into the PMS.LCMSTRANSCRACKS database table |
Details |
Name | Value | ||
Level | |||
Complexity | |||
Use Case Status | |||
Implementation Status | |||
Preconditions | |||
Post-conditions | |||
Author | Rick Miller | ||
Assumptions |
Tagged Values |
Name | Type | Value | |||
Level | Ad Hoc Enumeration | Summary | |||
Complexity | Ad Hoc Enumeration | ||||
Use Case Status | Ad Hoc Enumeration | ||||
Preconditions | Multi-line Text | ||||
Post-conditions | Multi-line Text | ||||
Author | Text | ||||
Assumptions | Multi-line Text |
References |
File Name | Description | ||
|
Relationships Detail |
Name | Value | ||
Name | |||
From |
|
||
To |
|
||
Visibility | Unspecified | ||
Stereotypes | Include |
Appears In |
Diagram | |||
|