| Worksheet ID: |
1483 |
| Record Location: |
Microsoft SQL Application Server for Cert Pop |
| File Arrangement: |
Alpha & Numeric |
| Media Format Generated: |
Electronic |
| Media Format Stored: |
ELECTRONIC |
| Date Range: |
01/2000 to Current |
| Annual Accumulation: |
5 MB |
| Current Volume: |
60 MB |
| Record Value: |
Fiscal, Historic |
| Audit Requirements: |
State |
| Reference Frequency: |
| Current Year per Month: |
1200 |
| Past Year: |
2400 |
| 2 - 5 Years: |
200 |
| Over 5 Years:
|
200 |
|
| Data Update Frequency: |
Yearly |
| Information Shared Outside of State: |
Yes |
| If Shared, List Agencies: |
F&A, Revenue, Transportation, ABC, Comptroller of the Treasury, Speaker of the House, Lt. Governor, Treasury, Dept. of State |
| Essential Record: |
TRUE |
| Essential Record Stored: |
Microsoft SQL Application Server for Cert Pop |
| Essential Record Media Type: |
Electronic |
| Confidential: |
FALSE |
| Confidential Legal Citation: |
|
| Media Recommendation: |
Current Format |
| Media Recommendation Other: |
|
| Agency Retention: |
20 years |
| Agency Retention - Years Active: |
|
| Agency Retention - Years Inactive: |
|
| Records Center Retention Period: |
|
| Final Disposition after Retention Expires: |
Destroy |
| Legal Citation: |
34 CFR 80.42 |
| Record Sample: |
No Sample |
| Legal Documentation: |
No Legal Documentation |
| Electronic Records Plan Inventory |
| System Name: |
Microsoft SQL Application Server for Cert Pop |
| IT-ABC Number: |
|
| Hardware Description: |
Microsoft SQL Application Server running in a VMWare virtual server environment |
| Software Description: |
Microsoft Word, Excel, PowerPoint, and Adobe pdf docs, jpg photos and SQL database tables |
| System Location: |
Microsoft SQL Application Server located at the State of TN Data Center |
| Backup Procedures: |
Nightly incremental back up, weekly full back up on Friday night, monthly full back up on last Friday of the month. Magnetic tape and the tapes are stored off-site at Iron Mountain back up storage facility. |
| Disaster Recovery: |
If data becomes lost or corrupted, a RFS will be submitted to OIR requesting a data restoration from the backup tapes containing the lost or corrupted data to its original location on the file server. |
| Data Migration Description: |
All Microsoft Office and SQL database products allow for data files to be automatically upgraded to new version of software by opening and choosing to convert files on the first open with the new software versions. |
| Metadata Description: |
Cert Pop SQL Database, 60 MB, .mdb, .ldb, bak
Cert Pop Project Files, 2 MB, .doc, .xls, .ppt, .jpg, .pdf |
