| Worksheet ID: |
2187 |
| Record Location: |
Records are located at the TDHS State office and 31 District offices across the State. |
| File Arrangement: |
Alpha / Numeric |
| Media Format Generated: |
Both |
| Media Format Stored: |
Paper/Electronic |
| Date Range: |
1980 - current |
| Annual Accumulation: |
146 cubic feet / 76 Gigabytes |
| Current Volume: |
995 cubic feet / 922 Gigabytes |
| Record Value: |
Administrative, Fiscal, Legal |
| Audit Requirements: |
Both |
| Reference Frequency: |
| Current Year per Month: |
999 |
| Past Year: |
999 |
| 2 - 5 Years: |
999 |
| Over 5 Years:
|
999 |
|
| Data Update Frequency: |
Daily |
| Information Shared Outside of State: |
Yes |
| If Shared, List Agencies: |
Federal Department of Health and Human Services, Office of Child Support Enforcement |
| Essential Record: |
Yes - Original |
| Essential Record Stored: |
IBM ZOS 1.13 Mainframe / IBM Data Center Boulder, Colorado |
| Essential Record Media Type: |
Electronic |
| Confidential: |
Yes |
| Confidential Legal Citation: |
45 CFR 302.15 / 45 CFR 303.11(d) / 45 CFR 75.361 – 75.365 / T.C.A. 71-1-131 Confidentiality of Records |
| Media Recommendation: |
Current Format |
| Media Recommendation Other: |
|
| Agency Retention: |
5 years 0 months |
| Agency Retention - Years Active: |
|
| Agency Retention - Years Inactive: |
|
| Records Center Retention Period: |
|
| Final Disposition after Retention Expires: |
Destroy |
| Legal Citation: |
45 CFR 302.15 / 45 CFR 303.11(d) / 45 CFR 75.361 – 75.365 / T.C.A. 71-1-131 Confidentiality of Records |
| Record Sample: |
No Sample |
| Legal Documentation: |
No Legal Documentation |
| Electronic Records Plan Inventory |
| System Name: |
Tennessee Child Support Enforcement System (TCSES) |
| IT-ABC Number: |
|
| Hardware Description: |
IBM ZOS 1.13 Mainframe |
| Software Description: |
DB2 Data Base; COBOL, CA;Gen Software |
| System Location: |
IBM Data Center Boulder, Colorado |
| Backup Procedures: |
TCSES is a DB2 data base system which is backed up nightly by O.I.R. and taken to an offsite storage vault in Iron Mountain, CO. The data is kept in the storage vault for fourteen days. Weekly backups of TCSES disk packs are made over the weekend and sent to the storage vault. Recovery jobs, along with all daily, weekly, and monthly job listings, are attached. Database tables containing FTI are backed up, labeled and stored separately from other DB2 Tables. |
| Disaster Recovery: |
The goal of the Disaster Recovery Plan is to allow necessary functions to continue in the event of a temporary failure at the Data Center. Plans have been developed to permit an alternate form of issuance for child support payments in the event TCSES is not operational within three days. Preparations have been made to allow Child Support offices to react manually to the necessary case management and legal actions required to conduct business. The local Judicial Offices will continue working via the use of paper forms. It is obvious that these actions will not allow employees to achieve the volume associated with a normal workload. It will be the responsibility of the Information System Managers to determine the exact system recovery point when data processing functions resume. |
| Data Migration Description: |
All modifications and enhancements to TCSES programs or the database must be made in the Development region. Unit testing is performed in this same region, using test data created by the programmers. Once a program has been successfully unit tested by the programmers it is migrated to System Test and functional tests created by the analysts are performed. Once a program has been successfully unit tested by the programmers and functional tests created by the analysts the program is compiled into the acceptance test region for testing by User Acceptance Test staff from Child Support Program.
A program must pass formal acceptance testing before it can be moved into the production region. The migration of all new or changed code is controlled through the Production Migration form which must be signed by the TCSES Area Director or backup, the Acceptance Testers, the Developers, the Analysts and Supervisors. The code can then only be migrated by the DBA Group.
|
| Metadata Description: |
• In TCSES, the data is stored in tables
• DB2 is a relational database management system that houses all of the tables
• These DB2 tables consist of multiple attributes
• These attributes may exist on more than one table
• More than one table may populate a screen
• Table names in TCSES are in the format of FMAXXX (i.e. FMA250 is the name of the CASE table).
• Screens may update data directly or store the update request for batch processing
• Screens are grouped by menus
Data is divided into the following areas:
• Case
• Case Initiation
• Locate
• Case Management
• Interstate
• Legal
• Establishment
• Enforcement
• Delinquency
• Financial
• Collections
• Distribution
• Disbursement
• Management Reporting
• Performance Measures
• Federal Reporting – OCSE 34A, OCSE 157
|
