TL_SQL_BINDS

(SQL Table)
 Index Back

Bind Mappings for Where Exprs

This table holds Bind mappings for a Sub-Query used as an operand in a where expression.

  • Parent record: TL_SQL_WHERE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SQL_ID Character(30) VARCHAR2(30) NOT NULL TL

    Prompt Table: TL_SQL_OBJECT

    2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    3 BINDNUM Character(2) VARCHAR2(2) NOT NULL Bind Number - Used for TL Sub Queries
    1=:1
    2=:2
    3=:3
    4=:4
    5=:5
    6=:6
    7=:7
    8=:8
    9=:9
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 CORR_ID Character(4) VARCHAR2(4) NOT NULL Table Alias
    A=A
    B=B
    C=C
    D=D
    E=E
    F=F
    G=G
    H=H
    I=I
    J=J
    6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: TL_RECFIELD_TBL