|Status||Set the status to 'Active' for joins that are being used|
|Base||The originating base|
|Base 2||The base to be joined|
|Name||A descriptive name usually including Base 2 and any other necessary descriptors of configuration options (e.g., Address By Rank Overall)|
There are three options.
|Memo||Should not be necessary but available if needed to better describe what is happening. Again, everything should be broken down in the such small, simple base units/joins, further description beyond the name should be unnecessary.|
|Join Clause||Base should be referenced in the join by it's key (e.g., a__JID_) while Base 2 will replace JID with XID (e.g., a__XID_) to allow joins back to the same table and the appropriate alias replacement conditions.|
|Operands, Operators, Where Prompts||Used to configure a join as before (e.g., filtering address by rank_overall)|