| Worksheet ID: |
696 |
| Record Location: |
Davy Crockett Bldg., 500 James Robertson Pkwy. Nashville, TN 37243 |
| File Arrangement: |
Alphabetical |
| Media Format Generated: |
Both |
| Media Format Stored: |
Paper/Electronic |
| Date Range: |
2000 to current |
| Annual Accumulation: |
2-3 cu ft/1MB |
| Current Volume: |
20-25 cu ft/10MB |
| Record Value: |
Administrative, Fiscal |
| Audit Requirements: |
State |
| Reference Frequency: |
| Current Year per Month: |
10 |
| Past Year: |
5 |
| 2 - 5 Years: |
2 |
| Over 5 Years:
|
9 |
|
| Data Update Frequency: |
Monthly |
| Information Shared Outside of State: |
No |
| If Shared, List Agencies: |
|
| Essential Record: |
Yes - Original |
| Essential Record Stored: |
Paper/Electronic |
| Essential Record Media Type: |
Electronic |
| Confidential: |
No |
| Confidential Legal Citation: |
|
| Media Recommendation: |
Current Format |
| Media Recommendation Other: |
|
| Agency Retention: |
10 years |
| Agency Retention - Years Active: |
1 Year |
| Agency Retention - Years Inactive: |
9 Years |
| Records Center Retention Period: |
0 |
| Final Disposition after Retention Expires: |
Destroy |
| Legal Citation: |
TCA 56-4-205, 56-4-206, 56-4-207, 56-4-208, 56-4-215, 56-13-114, 56-14-113, and 56-45-110. |
| Record Sample: |
No Sample |
| Legal Documentation: |
No Legal Documentation |
| Electronic Records Plan Inventory |
| System Name: |
NAIC ‘OPT-IN’ |
| IT-ABC Number: |
N/A |
| Hardware Description: |
Hardware Environment •SERFF and OPTins– HP Itanium based RX and RP servers for frontend (web), backend (batch) and database •SBS – Virtualized Servers running on CISCO UCS blade environment |
| Software Description: |
SERFF and OPTins – HP-UX 11.31 Server OS with Frontend utilizing Oracle OHS/OAS environment for java 1.5 code and C++ CGIs. Backend mainly C++ and java 1.5 applications and database using Oracle 10G RDBMS •SBS – Windows 2003 for Frontend running SunOne server for Java 1.4 applications and HP-UX 11.31 Server running Oracle 10G RDBMS for database. Batch applications run on RDBMS server |
| System Location: |
Main Processing Center – NAIC Central Office – 1100 Walnut, Kansas City, MO •Co-Location/DR Center – Arsalon Technologies - 15721 College Boulevard, Lenexa, KS |
| Backup Procedures: |
Daily, weekly and monthly hot database backups are conducted along with archive logs enabling point-in-time recovery; monthly backups are retained for seven months. Daily and monthly Exchange backups are conducted; monthly backups are retained for thirteen months. Other non-database backups are conducted on a daily, weekly and monthly basis; monthly backups are retained for thirteen months. Backups are replicated to our disaster recovery site for redundancy purposes. All backups are written to disk arrays using de-duplication. |
| Disaster Recovery: |
Replication to redundant systems utilizing hardware at Co-Location Facility. |
| Data Migration Description: |
All the data associated with SBS is contained in the SBS-TN database housed at the NAIC. All data contained in the SBS-TN database is the property of the state. Data was migrated from the state’s legacy systems when TN transitioned to SBS in February 2010. Currently this data is kept on a permanent basis. |
| Metadata Description: |
Date, NAIC number, name of company |
