Layout Of the DEPARTMENT Record

This appendix presents the layout and configuration of the sample DEPARTMENT record. DEPARTMENT is defined in the non-SQL defined demonstration database that can be installed with the system.

Definition

As defined at installation time:

The DEPARTMENT record owns the EMPLOYEE record.
In order to delete a department that owns employees, you must either disconnect or delete the department's employees. To delete a department along with its employees, you use a process command like:
```
ERASE DEPARTMENT ALL MEMBERS.
```
The DEPARTMENT record is defined in the ORG-DEMO-REGION.

Sample DEPARTMENT Record Layout

What is below shows the layout of the DEPARTMENT record as defined at installation time.

Note: The demonstration database and the DEPARTMENT record may be defined differently at your site.

 Record:  DEPARTMENT             Version:  100

   Location mode:  CALC
   CALC field...:  DEPT-ID-0410
   Duplicates records are not allowed

      Element:  DEPT-ID-0410

              Picture:  9(4)
              Usage..:  Display

      Element:  DEPT-NAME-0410

              Picture:  X(45)
              Usage..:  Display

      Element:  DEPT-HEAD-ID-0410

              Picture:  9(4)
              Usage..:  Display