TL_SQL_WHRBINDS

(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 EXPRESSION_SIDE Character(1) VARCHAR2(1) NOT NULL A flag stating what side of the expression an operand takes in a TL SQL Object.
    0=Left
    1=Right
    4 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
    5 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 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