Worksheet ID: |
2442 |
Record Location: |
502 Deaderick Street, Nashville, TN 37243 |
File Arrangement: |
Chronologically |
Media Format Generated: |
Both |
Media Format Stored: |
Electronic: Text |
Date Range: |
2013-Present |
Annual Accumulation: |
.775 GB |
Current Volume: |
2.475 GB |
Record Value: |
Administrative, Legal |
Audit Requirements: |
State |
Reference Frequency: |
Current Year per Month: |
40 |
Past Year: |
20 |
2 - 5 Years: |
10 |
Over 5 Years:
|
5 |
|
Data Update Frequency: |
Daily |
Information Shared Outside of State: |
No |
If Shared, List Agencies: |
|
Essential Record: |
Yes - Original |
Essential Record Stored: |
Same |
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: |
1 year |
Agency Retention - Years Inactive: |
4 years |
Records Center Retention Period: |
0 |
Final Disposition after Retention Expires: |
Destroy |
Legal Citation: |
NO |
Record Sample: |
No Sample |
Legal Documentation: |
No Legal Documentation |
Electronic Records Plan Inventory |
System Name: |
TPUC Consumer Services Utility Complaint Database |
IT-ABC Number: |
None |
Hardware Description: |
Records are stored on a HP Proliant ML370 G5 file server utilizing RAID 5 storage. Access is through Windows XP or Windows 7.0 workstations. |
Software Description: |
Adobe Acrobat XI is used to produce the record. File is stored on a Windows 2003 file server, NTFS file system. Files are indexed in an Access 2010 database and retrieved via HTML. |
System Location: |
Tennessee Public Utility Commission, 502 Deaderick Street, Nashville, TN |
Backup Procedures: |
Records are backed up using the GFS tape rotation scheme. Tape drive is a HP LTO III drive. Records are backed up daily. Tapes are stored on site with at least one daily, one weekly, and all monthly stored off site. |
Disaster Recovery: |
Either the on site or off site tape would be recovered and the records restored to the recovered file server or a new file server. |
Data Migration Description: |
Records are scanned using industry standard Adobe Acrobat. The TRA will continue to upgrade Adobe as new versions emerge. PDFs can be converted to other formats if necessary. Documents are stored locally but could be migrated to any storage location/medium if required. Indexing databases are maintained in MS Access but will be migrated to SQL Lite if necessary. |
Metadata Description: |
Metadata collected consists of file name, file creation date, file modify date, Application, and PDF format.
|