In order to add a Predetermined Join Column to a table definition, the field has to first be defined in the Repository. In this step, you will create two field definitions which you will use when creating your Predetermined Join Columns.
1. Create two fields called iiiTotalSalaryPJC and iiiDeptDescPJC. The iiiTotalSalaryPJC field will contain the total value based on the iiiSalary field. The iiiDeptDescPJC field will hold the Department Description based on the iiiDeptDescription field.
2. In the most efficient means possible, create the following fields with the basic characteristics listed below. (Reminder: iii=your initials.)
|
|
