Department Home | Records Management Home | RDA List

Tennessee Secretary of State Tre Hargett
Records Management Division
RDA
RDA Management System
RDA Details
RDA
RDA: 11194
Database ID: 2158
Record Series Title: Pharmacy rebate and other pricing records
Record Series Abstract: These records consist of claims information, financial records, payments and correspondence involving the federal and state supplemental drug rebate program for Medicaid such as copies of quarterly invoices and documentation, as well as any other records related to drug pricing issues or analysis
Record Series Active: Yes
Cut Off at End of: Fiscal Year
If Other, Explain:
Total Retention: 10 Years 0 Months
Retention End Action: Destroy
Disposition Notes: Following the cut off paper records are kept and maintained by the agency. Electronic records are stored on Magellan maintained database hosted on an Oracle cluster.All records are maintained for 10 years after cut off and then destroyed by state approved methods
View Signed Form: Form Not Received
Worksheet
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.
Contact Information
Contact Name: Thomas K Grones
Job Title: Administrative Assistant 4
Address 1: 310 Great Circle Road
Address 2:
City: Nashville
Zip: 37243
Phone: 615-687-7971
Email: thomas.k.grones2@tn.gov
Agency: Division of TennCare
Agency Head: Wendy Long
Director: James Hailey
Allotment Code: 31865
Status
Action Requested: New RDA
Comments
  Date Comments
Records Management Division (RMD): 01-12-2017 No recommended changes
Tennessee State Libary and Archives: 02-04-2017 No recommended changes.
Comptroller Audit Review: 2017-01-18 We have reviewed RDA 11194 from an audit standpoint. We concur with the recommended retention and disposition specifications.
Agency: 02-06-2017 Agency Concurs
RMD Director Recomendations: 02-07-2017 RDA 11194 is a request for a new RDA. The retention period will be ten years and destroy. The format will be paper/electronic. Recommend approval of request to create RDA 11194.
Signed Form Received: 2017-02-06
PRC Meeting Date: 03-28-2017
PRC Comments: PRC approves RDA 11194
PRC Action: Approved
RDA History
ID RDA PRC Reviewed PRC Action
2158 11194 2017-03-28 Approved