Worksheet ID: |
1902 |
Record Location: |
615 Mainstream Drive, 1st floor Nashville TN |
File Arrangement: |
Chronological |
Media Format Generated: |
Both |
Media Format Stored: |
Paper/Electronic |
Date Range: |
2007 to present |
Annual Accumulation: |
.5 cu ft
.5 gigabytes |
Current Volume: |
3 cu ft
2 gigabytes |
Record Value: |
Administrative, Fiscal, Legal |
Audit Requirements: |
State |
Reference Frequency: |
Current Year per Month: |
2 |
Past Year: |
1 |
2 - 5 Years: |
0 |
Over 5 Years:
|
0 |
|
Data Update Frequency: |
Weekly |
Information Shared Outside of State: |
No |
If Shared, List Agencies: |
|
Essential Record: |
No |
Essential Record Stored: |
|
Essential Record Media Type: |
|
Confidential: |
Yes |
Confidential Legal Citation: |
TCA: 71-5-2601 and 40-30-102 |
Media Recommendation: |
|
Media Recommendation Other: |
|
Agency Retention: |
5 |
Agency Retention - Years Active: |
0 |
Agency Retention - Years Inactive: |
5 |
Records Center Retention Period: |
0 |
Final Disposition after Retention Expires: |
Destroy |
Legal Citation: |
TCA: 71-5-2601 and 40-30-102 |
Record Sample: |
No Sample |
Legal Documentation: |
No Legal Documentation |
Electronic Records Plan Inventory |
System Name: |
Database AGCTSPRD in the Oracle Shared Environment |
IT-ABC Number: |
|
Hardware Description: |
OIR Oracle Shared Environment Servers |
Software Description: |
Oracle database |
System Location: |
OIR Data Centers (replicated across South Data Center (Smyrna)and North Data Center (Nashville)) |
Backup Procedures: |
archive logs
daily incremental backups
weekly full backup
DDR to tape every 30 days
tapes offsite biweekly |
Disaster Recovery: |
replication across data centers and archive logs facilitates a one-hour point-in-time recovery |
Data Migration Description: |
A home-grown windows application (Case Tracking System (CTS)) is installed on appropriate client machines. It is through the CTS software that data is moved to the oracle database. |
Metadata Description: |
A central table contains the case record, including detail about general complaints, TennCare recipient complaints, TennCare provider complaints. Full table description is available from the OIR DRM group. Archive logs also provide metadata (who added/changed/deleted what data when). |