4 7 3 PJF Example using Personnel System

Visual LANSA

4.7.3 PJF Example using Personnel System

Consider the Department and Section files which are part of the Personnel System Application database.

Imagine that you want to be able to make the Department Description field in the Department file part of the Section file. You also want to derive the Section Count field by counting the sections for a specific department in Section file. PJFs will be created to make these two fields part of the Department file.

First, two new virtual fields are created in the repository:

  • Description of Department
  • Section Count

Based on the access routes between the Section file and the Department file, a PJF is added to the Section file so that the Description of Department field is a file lookup to the Department Description in the  Department File. Description of Department is a virtual field. When it is used by a function, the repository will actually access the Department file to get the required data since it does not really exist in the Section file. The access route is used to determine how to access the data.

Based on the access routes between the Department file and the Section file, a PJF is added to the Department file so that the Section Count field is calculated  by counting the appropriate sections in the Section file. Section Count is a virtual field. When it is used by a function, the repository will actually access the Section file to get and total the data.

Also See

Personnel Demonstration Application

Ý 4.7 Predetermined Join Field Development