| Worksheet ID: |
165 |
| Record Location: |
Nashville Central Office |
| File Arrangement: |
Alpha, Numeric |
| Media Format Generated: |
Both |
| Media Format Stored: |
Paper/Electronic |
| Date Range: |
1975 through current. |
| Annual Accumulation: |
0.50 cu. ft. (0.22 gb.) |
| Current Volume: |
0.25 cu. ft. (0.11 gb.) |
| Record Value: |
Administrative |
| Audit Requirements: |
State |
| Reference Frequency: |
| Current Year per Month: |
2 |
| Past Year: |
24 |
| 2 - 5 Years: |
72 |
| Over 5 Years:
|
0 |
|
| Data Update Frequency: |
Yearly |
| Information Shared Outside of State: |
No |
| If Shared, List Agencies: |
|
| Essential Record: |
Yes - Original |
| Essential Record Stored: |
WRC Division - Labor Standards Unit
220 French Landing Drive, 2B
Nashville, TN 37243 |
| Essential Record Media Type: |
Paper |
| Confidential: |
No |
| Confidential Legal Citation: |
T.C.A 10-7-503 |
| Media Recommendation: |
Current Format |
| Media Recommendation Other: |
Not applicable. |
| Agency Retention: |
5 years |
| Agency Retention - Years Active: |
3 years |
| Agency Retention - Years Inactive: |
2 years |
| Records Center Retention Period: |
|
| Final Disposition after Retention Expires: |
Destroy |
| Legal Citation: |
|
| Record Sample: |
No Sample |
| Legal Documentation: |
No Legal Documentation |
| Electronic Records Plan Inventory |
| System Name: |
Oracle |
| IT-ABC Number: |
|
| Hardware Description: |
Surveys - Record Series is stored on a 2012 Virtual Machine Server, located in the 220 French Landing Drive, Nashville, TN 37243 building, First Floor. The record series may be accessed via desktop computers safely stored in the Labor Standards Unit area in the same building. The record series is password protected. |
| Software Description: |
Surveys - The software used to store the data is an Oracle database, accessed via a desktop application which is only accessible from desktop computers safely stored in the Labor Standards Unit area located at 220 French Landing Drive, Nashville, TN 37243. The database is password protected. There is also a NIC interface which links directly to the Oracle database and is password protected. Additionally, the NIC application is only accessible to input data during the month of October each year. |
| System Location: |
220 French Landing Dr, 2B, Nashville, TN |
| Backup Procedures: |
Surveys - The data is backed up daily by the standard daily incremental process, to tape, and also has a weekly full backup on Friday each week. The backup is located in the 220 French Landing Drive Building, First Floor, Nashville, TN 37243 and is also sent off to Iron Mountain weekly. Additionally, each year's data is backed up to a separate file prior to loading the next year's data to the Oracle database. |
| Disaster Recovery: |
Surveys - The data is backed up at the State Disaster Recovery site. In the event of a disaster, the data would be retrieved using standard procedures. This application has been assigned a Bronze Level for Disaster Recovery. Therefore, recovery in a disaster situation could take between one (1) and three (3) weeks. Ops Planner is now the state's sole repository for Disaster Recovery/Business Continuity (DR/BC) documentation. |
| Data Migration Description: |
The data is stored in a set of tables which are regenerated each year for the purpose of storing current tables. The previous year's data is copied and saved in the same database, but is not used. The information is not migrated to another system, or used elsewhere - all data is used internally in one database, one system, for one purpose. We are in the process of creating a new system, and the data will be migrated from the current location to a new location, but maintained in the same way.
|
| Metadata Description: |
The data consists of business addresses and contact information, stored in an Oracle database. It does not contain PII. It is inserted into the database each year (see Migration) and then copied and retained as historical data. The data contains one quarter's worth of wages paid, voluntarily entered by businesses who work in Tennessee, for the purpose of determining Prevailing Wage. The tables kept are:
contract information (the contract number); classification information (what type of job); the location; the hours; and the rates paid.
|
