| Worksheet ID: |
641 |
| Record Location: |
James K Polk Building Suite 1000
505 Deaderick Street
Nashville, TN 37243 |
| File Arrangement: |
Numeric |
| Media Format Generated: |
Electronic |
| Media Format Stored: |
Electronic/Film |
| Date Range: |
1993 to current |
| Annual Accumulation: |
35 gigabytes |
| Current Volume: |
3500 gigabytes |
| Record Value: |
Administrative, Fiscal, Legal |
| Audit Requirements: |
State |
| Reference Frequency: |
| Current Year per Month: |
5 |
| Past Year: |
5 |
| 2 - 5 Years: |
0 |
| Over 5 Years:
|
0 |
|
| Data Update Frequency: |
Yearly |
| Information Shared Outside of State: |
Yes |
| If Shared, List Agencies: |
Attorney General |
| Essential Record: |
Yes - Original |
| Essential Record Stored: |
Tennessee Department of Transportation |
| Essential Record Media Type: |
Electronic |
| Confidential: |
No |
| Confidential Legal Citation: |
|
| Media Recommendation: |
Current Format |
| Media Recommendation Other: |
Electronic |
| Agency Retention: |
10 years |
| Agency Retention - Years Active: |
10 |
| Agency Retention - Years Inactive: |
0 |
| Records Center Retention Period: |
0 |
| Final Disposition after Retention Expires: |
Destroy |
| Legal Citation: |
|
| Record Sample: |
No Sample |
| Legal Documentation: |
No Legal Documentation |
| Electronic Records Plan Inventory |
| System Name: |
TRIMS Database |
| IT-ABC Number: |
|
| Hardware Description: |
The Titan Database is a data exchange module for the TRIMS database, both of which are housed on Oracle Database Server (ODBS) that physically resides and runs on an HP DL380 class server. |
| Software Description: |
The Titan Database is a data exchange module for the TRIMS database, both of which are housed on the Oracle Database Server which currently runs Microsoft Server 2008 R2 as an operating system with the Oracle Database running Enterprise 11G. |
| System Location: |
The Titan Database is located in the Oracle Database Server which currently resides at OIR’s South Data Center, located in Smyrna Tennessee, hosts the servers that will be utilized for the storage to comply with both the Statewide and TDOT Electronic Records Policy. |
| Backup Procedures: |
OIR will conduct backup procedures. These procedures consist of daily incremental backups and weekly total backups on the weekend. The process for Backing Up the data from OIR’s South Data Center is to mirror the information at OIR’s North Data Center, and then create a weekly backup tape that is currently stored by the Vendor: Iron Mountain Incorporated, Iron Mountain Nashville, 6005 Dana Way, Nashville, TN 37013, Ph. 800-899-4766 |
| Disaster Recovery: |
OIR conducts disaster recovery. This procedure is a prioritized process of enabling critical and essential applications first and then continuing through the priority list to less significant applications. Disaster Recovery begins with the utilization of the OIR’s North Data Center for both operations and data. If both OIR’s South Data Center and OIR’s North Data Center are out of operation, new operations will begin by acquiring appropriate hardware and software from a third party supplier, and restoring data from the offline tape backups stored with the current vendor: Iron Mountain Incorporated. |
| Data Migration Description: |
Data Migration will occur when support for the existing file format moves from Current to Twilight or Obsolete, or when software or hardware systems changes require the movement of RDA electronic data from a specified format to a different file format. Annual reviews will be conducted by the TDOT Records Officer and the TDOT IT Director in accordance with the Section 3 of the TDOT ERP. Additionally, the TDOT IT Director will provide information and guidance to the TDOT Records Officer at the time of discovery regarding functional and operational performance of software and hardware that will change the status of file formats from Current to Twilight or Obsolete.
The annual review process of file formats status and the level of in those file formats confidence, with regards to specific RDA retention requirements, will result in the generation of a File Type Confidence Report. Time for measuring the required three year limit for migration completion of affected data will begin at the time of discovery of the file format status change to Twilight or Obsolete, even if it is outside the annual review where it is reported with time remaining.
The TDOT IT Director will advise and develop a solution to move the data to a Current file format that is appropriate to the RDA retention requirement for the specific data. This may include translation of the data to a Current file format, conversion to an acceptable Current File format to preserve the integrity of the information of the data, or movement of the data to a legacy architecture that maintains the environment where the file format is considered Current as long as this effort has full functional and operational support. |
| Metadata Description: |
Content Subject/Title: TITAN Database -Crash Data. Crash Data records are filled out by law enforcement at crash locations. These records are used for statistical analysis of roads to identify high hazard areas that may need repair or some other change to lower crash rates.
Date Created: 1993
Format: This is a dynamic Oracle Database, and the data resides in an Oracle .dbf format.
Content Size: 120 GB
Location: South Data Center, located in Smyrna, TN. The TITAN Crash Database on the Oracle Database Server JJ01SDCWB00000
|
