Defining Table Relationships

To define table relationships, use the Relationship Definitions (TL_RELATIONSHIP) component.

Defining table relationships consists of joining fields on different record tables.

Page Name

Definition Name

Usage

Relationship Definitions Page

TL_RELATIONSHIP

Create relationships between tables.

Use the Relationship Definitions page (TL_RELATIONSHIP) to create relationships between tables.

Navigation

Set Up HCM > System Administration > Utilities > Build Time and Labor Rules > Relationship Definitions > Relationship Definitions

Image: Relationship Definitions page

This example illustrates the fields and controls on the Relationship Definitions page. You can find definitions for the fields and controls later on this page.

Relationship Definitions page

Fields

Field or Control

Definition
Join Fields 1-5

Enter the fields from each table that the system must use to create a relationship between the tables.

Define a relationship definition when you use a condition that references a field that is not part of the updated record.

Example

If a time reporter belongs to Union 'ABC' and reports more than eight hours per day under TRC REG, change REG to DBL.

The action for this statement is:

UPDATE PS_TL_IPT1
SET TRC = 'DBL'

The two conditions for this statement are:

WHERE PS_TL_IPT1.TRC = 'REG'
AND PS_JOB.UNION_CD = 'ABC'

To identify the correct effective-dated row and sequence from the JOB table, we would need several additional lines of code comparing the employee IDs, employee record numbers, and dates in the TL_IPT1 and JOB tables. Setting up a relationship definition eliminates the need to code this relationship individually.