Worksheet ID: |
2159 |
Record Location: |
310 Great Circle Road |
File Arrangement: |
by date and then numeric |
Media Format Generated: |
Both |
Media Format Stored: |
Paper/Electronic |
Date Range: |
2001 to present |
Annual Accumulation: |
32 cubic ft, 200GB |
Current Volume: |
480 cubic ft, 3TB
|
Record Value: |
Administrative, Fiscal, Legal |
Audit Requirements: |
Both |
Reference Frequency: |
Current Year per Month: |
0 |
Past Year: |
0 |
2 - 5 Years: |
2 |
Over 5 Years:
|
0 |
|
Data Update Frequency: |
Daily |
Information Shared Outside of State: |
Yes |
If Shared, List Agencies: |
United States Department of Health & Human Services |
Essential Record: |
No |
Essential Record Stored: |
|
Essential Record Media Type: |
|
Confidential: |
|
Confidential Legal Citation: |
|
Media Recommendation: |
Current Format |
Media Recommendation Other: |
|
Agency Retention: |
10 years |
Agency Retention - Years Active: |
2 |
Agency Retention - Years Inactive: |
8 |
Records Center Retention Period: |
|
Final Disposition after Retention Expires: |
Destroy |
Legal Citation: |
42cfr447.510(f) |
Record Sample: |
No Sample |
Legal Documentation: |
No Legal Documentation |
Electronic Records Plan Inventory |
System Name: |
Erebate ( Magellan ) HP ( tenncare.intranet.sftp.tn.gov) |
IT-ABC Number: |
|
Hardware Description: |
(Magellan) Database hosted on the RAC cluster Production application server name: stlmoj2ee03/stlmoj2ee04
(HP) Solaris VM |
Software Description: |
The eRebate (Trade Mark). component of the Magellan Medicaid Administration (MMA) Pharmacy Benefits Management (PBM) system provides supports functionalities and business processes to produce drug rebate invoices for drug manufactures, as well as to record payments and disputes related to these invoices. The system supports contract management, the quarterly generation of rates and production of rebate invoices, receipt and reconciliation of payments, and dispute tracking and resolution.
(HP) Unix |
System Location: |
Magellan
St. Louis MO.
HP
STS Data Center South
901 5th AVE. North
Nashville,TN. 37243
|
Backup Procedures: |
Magellan " Backups are performed daily (incremental)and weekly(full save) for all mid range platforms. Full backups are performed nightly for Intel systems
HP
There are daily incremental backups along with weekly full backups with offsite storage and a full DR plan for the server independent of drug rebate or any other data group or fileset |
Disaster Recovery: |
Magellan contracted vendor will deliver tapes for the last 15 days. Backups along with pre-assembled recovery materials to the designated recovery site.
HP
There are daily incremental backups along with weekly full backups with offsite storage and a full DR plan for the server independent of drug rebate or any other data group or fileset
|
Data Migration Description: |
Magellan" The data resides in the Oracle database located in ST. Louis, MO. If migration was needed, it would be performed by database administrators"
Hewlett Packard Enterprise "Does migration through a Secure File Transfer Protocol over server tenncare.intranet.sftp.tn.gov |
Metadata Description: |
Electronic detail can be queried via SQL queries against the production database and /or via reporting tool.
Paper records can be retrieved from local facility via telephone call via box numbers.
HP
Via secured access to the SFTP server by authorized user ID. |