TL_SQL_JOIN

(SQL Table)
 Index Back

TL SQL Object AutoJoins

Join information for TL SQL Objects

  • Parent record: TL_SQL_OBJECT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SQL_ID Character(30) VARCHAR2(30) NOT NULL TL
    2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    3 LEFT_CORR_ID Character(4) VARCHAR2(4) NOT NULL Table Alias - Correlation ID
    A=A
    B=B
    C=C
    D=D
    E=E
    F=F
    G=G
    H=H
    I=I
    J=J
    4 LEFT_RECNAME Character(15) VARCHAR2(15) NOT NULL Left Record (Table) Name
    5 RIGHT_CORR_ID Character(4) VARCHAR2(4) NOT NULL Table Alias - Correlation ID
    A=A
    B=B
    C=C
    D=D
    E=E
    F=F
    G=G
    H=H
    I=I
    J=J
    6 RIGHT_RECNAME Character(15) VARCHAR2(15) NOT NULL Right Record (Table) Name
    7 JOIN_TYPE Character(1) VARCHAR2(1) NOT NULL Join Type
    1=Common Keys
    2=Common Fields
    8 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

    Prompt Table: %EDITTABLE2

    9 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Fieldname 2

    Prompt Table: %EDITTABLE2

    10 FIELDNAME3 Character(18) VARCHAR2(18) NOT NULL Field Name

    Prompt Table: %EDITTABLE2

    11 FIELDNAME4 Character(18) VARCHAR2(18) NOT NULL Field Name 4

    Prompt Table: %EDITTABLE2

    12 FIELDNAME5 Character(18) VARCHAR2(18) NOT NULL Field Name 5

    Prompt Table: %EDITTABLE2