TL_RLTNSHP_DEFN(SQL Table) |
Index Back |
|---|---|
T&L Relationship DefinitionThis table is used to store the relationships between tables. These relationships help facilitate the joins in rule definitions. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LEFT_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Left Record (Table) Name
Prompt Table: TL_LEFT_REC_VW |
| 2 | RIGHT_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Right Record (Table) Name
Prompt Table: TL_WORK_TABLES |
| 3 | R1F1 | Character(18) | VARCHAR2(18) NOT NULL |
Join Fields 1
Prompt Table: TL_RECFLD_L_VW |
| 4 | R2F1 | Character(18) | VARCHAR2(18) NOT NULL |
Record 2 Field 1
Prompt Table: TL_RECFLD_R_VW |
| 5 | R1F2 | Character(18) | VARCHAR2(18) NOT NULL |
Join Fields 2
Prompt Table: TL_RECFLD_L_VW |
| 6 | R2F2 | Character(18) | VARCHAR2(18) NOT NULL |
Record 2 Field 2
Prompt Table: TL_RECFLD_R_VW |
| 7 | R1F3 | Character(18) | VARCHAR2(18) NOT NULL |
Join Fields 3
Prompt Table: TL_RECFLD_L_VW |
| 8 | R2F3 | Character(18) | VARCHAR2(18) NOT NULL |
Record 2 Field 3
Prompt Table: TL_RECFLD_R_VW |
| 9 | R1F4 | Character(18) | VARCHAR2(18) NOT NULL |
Join Fields 4
Prompt Table: TL_RECFLD_L_VW |
| 10 | R2F4 | Character(18) | VARCHAR2(18) NOT NULL |
Record 2 Field 4
Prompt Table: TL_RECFLD_R_VW |
| 11 | R1F5 | Character(18) | VARCHAR2(18) NOT NULL |
Join Fields 5
Prompt Table: TL_RECFLD_L_VW |
| 12 | R2F5 | Character(18) | VARCHAR2(18) NOT NULL |
Record 2 Field 5
Prompt Table: TL_RECFLD_R_VW |