Overview

CA ADS Batch Sample Applications › Overview

Overview

This appendix implements the following CA ADS Batch sample applications:

Employee-record archive application──Archives selected employee records and their associated coverage records from an CA IDMS/DB database to an output file
Employee-record restore application──Restores selected employee records and their associated coverage records from the archive file to the database
Employee-record report application──Produces a report of employees by department

Subschema

All applications access the employee subschema. The subschema includes the following database records.

Database record	Description
EMPLOYEE	Stores employee records. The CALC key for EMPLOYEE is EMP-ID-0415.
COVERAGE	Stores insurance coverage records for each employee. Several COVERAGE records can be associated with an EMPLOYEE record. The relationship is described by the EMP-COVERAGE set.
DEPARTMENT	Stores information about the company's departments. The CALC key for DEPARTMENT is DEPT-ID-0410. Each employee belongs to a department. The relationship is described by the DEPT-EMPLOYEE set.
OFFICE	Stores information about the company's offices. The CALC key for OFFICE is OFFICE-CODE-0450. Each employee belongs to an office. The relationship is described by the OFFICE-EMPLOYEE set.

Copyright © 2013 CA. All rights reserved.