| Worksheet ID: |
33 |
| Record Location: |
505 Deaderick Street, Suite 1800
Nashville, TN 37243 |
| File Arrangement: |
Alpha-Numeric |
| Media Format Generated: |
Both |
| Media Format Stored: |
Paper/Electronic |
| Date Range: |
Year 2010 to Current. |
| Annual Accumulation: |
1/2 Cubic feet paper
5 Gigabytes |
| Current Volume: |
1 Cubic Foot
8 Gigabyates |
| Record Value: |
Administrative, Legal |
| Audit Requirements: |
None |
| Reference Frequency: |
| Current Year per Month: |
20 |
| Past Year: |
14 |
| 2 - 5 Years: |
10 |
| Over 5 Years:
|
0 |
|
| Data Update Frequency: |
Daily |
| Information Shared Outside of State: |
Yes |
| If Shared, List Agencies: |
Class 1 Railroads i.e. CSX Transportation, Norfolk Southern, Candian National and Burlington Northern Santa Fe. All Shortline Railroads i.e. Caney Fork and Western, Chattooga and Chickamauga, RJ Corman, East Tennessee Railway, Heritage Railroad, Hiwassee River, Knoxville and Holston River, KWT, Nashville and Eastern, Nashville and Western, Sequatchie Valley, South Central Tennessee, Tennessee Southern, Tennessee Valley Railroad Museum, Tennken Walking Horse and Eastern and West Tennessee. |
| Essential Record: |
Yes - Original |
| Essential Record Stored: |
505 Deaderick Street, Suite 1800
Nashville, TN 37243 |
| Essential Record Media Type: |
Electronic |
| Confidential: |
No |
| Confidential Legal Citation: |
|
| Media Recommendation: |
Current Format |
| Media Recommendation Other: |
|
| Agency Retention: |
5 years |
| Agency Retention - Years Active: |
3 years |
| Agency Retention - Years Inactive: |
2 years |
| Records Center Retention Period: |
None |
| Final Disposition after Retention Expires: |
Destroy |
| Legal Citation: |
Attached to this RDA is a pdf file showing the Federal Railroad Safety Administration Directive N1-399-08-12. This federal directive is not authoritative for the State of Tennessee. However, TDOT adheres to federal retention schedule for the purposes of keeping Tennessee consistent with the national standard for retention of the type of records governed by this RDA. |
| Record Sample: |
No Sample |
| Legal Documentation: |
No Legal Documentation |
| Electronic Records Plan Inventory |
| System Name: |
JJ01SDCWB00000 Railroad Safety Inspection System Database |
| IT-ABC Number: |
|
| Hardware Description: |
The Railroad Safety Inspection System is an Oracle Database which is housed on The Oracle Database Server (ODBS) physically resides and runs on an HP DL380 class server. |
| Software Description: |
The Railroad Safety Inspection System is an Oracle Database which is housed on The Oracle Database Server (ODBS) which currently runs Microsoft Server 2008 R2 as an operating system with the OAS running 11G. |
| System Location: |
The Railroad Safety Inspection System is an Oracle Database which is housed on The Oracle Database Server which resides at OIR’s South Data Center, located in Smyrna Tennessee, and 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 back-up servers are Hitachi and EMC SANs.
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
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: The Railroad Safety Inspection System. Daily Railroad Inspector\'s Report- Inspection report is created after inspector completes inspection at a railroad crossing. The inspection report is then filed alphabetically by inspectors name with case type, case number and year complaint was opened.
Date Created: January 1, 2006 [?/?/2010]
Format: This is a dynamic Oracle Database, and the data resides in an Oracle .dbf format.
Content Size: 8 GB
Location: South Data Center, located in Smyrna - Railroad Safety Inspection System Database on the Oracle Database Server JJ01SDCWB00000 |
