PJF Field
Mandatory.
Specify the name of the predetermined join field.
No check is made on the Predetermined Join Field's suitability to hold the required information.
Rules
- It must exist in the repository.
- It must not already exist as a Predetermined Join, Virtual or Real field on the file.
- It must be of the type allowed by PJF Type. Field type must be numeric if the PJF Type is Total, Maximum, Minimum, Average or Count.
- It must be a suitable type to match the PJF Source Field.
Tips & Techniques
- The Predetermined Join Field may have the same name as the PJF Source Field as long as it complies with the defined rules.
- It is your responsibility to check that Predetermined Join Field is suitable to hold the required information. For example, ensure fields that hold counts or totals are large enough.