TL_SQL_WHERE

(SQL Table)
Index Back

Expressions in a Where Clause

Expression for a where clause are stored in this table. this is functionality for T&L 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 EXPRESSION_TYPE Character(1) VARCHAR2(1) NOT NULL Expression Type
    0=General
    1=Join
    2=Effdt
    3=Having

    Default Value: 0

    4 TL_LOGICAL_OP Character(1) VARCHAR2(1) NOT NULL Logical Expression Operands
    0=OR
    1=AND
    2=WHERE
    3=HAVING
    9=NONE
    5 EXPRESSION_SRC Character(1) VARCHAR2(1) NOT NULL Use Conditional Prompts

    Y/N Table Edit

    Default Value: Y

    6 LEFT_PAREN Character(1) VARCHAR2(1) NOT NULL Left Parenthesis
    1=(
    2=((
    3=(((
    4=((((
    5=(((((
    6=((((((
    7=(((((((
    7 LEFT_EXPR_TYPE Character(1) VARCHAR2(1) NOT NULL Left Expression Type
    0=Record.Field
    1=Constant
    2=State Variable
    3=MetaSQL
    4=SubQuery
    5=Bind
    6=Template
    8 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
    9 LEFT_RECNAME Character(15) VARCHAR2(15) NOT NULL Left Record (Table) Name

    Default Value: TL_SQL_OBJECT.RECNAME

    10 LEFT_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Left Field Name

    Prompt Table: TL_L_RECFLD_VW

    11 L_AGGR_FUNC_TYPE Character(1) VARCHAR2(1) NOT NULL Aggregate Function
    0=MIN
    1=MAX
    2=AVG
    3=SUM
    4=COUNT
    5=COUNT(*)
    6=NONE
    12 LEFT_CONSTANT Character(35) VARCHAR2(35) NOT NULL Left Constant
    13 LEFT_STATEVAR Character(35) VARCHAR2(35) NOT NULL Left State Variable

    Prompt Table: TL_STATE_VARS

    14 L_META_SQL Character(30) VARCHAR2(30) NOT NULL Left MetaSQL

    Prompt Table: TL_META_WHR_VW

    15 L_META_SQL_PARM1 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 1
    16 L_META_SQL_PARM2 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 2
    17 L_META_SQL_PARM3 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 3
    18 L_META_SQL_PARM4 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 4
    19 L_META_SQL_PARM5 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 5
    20 L_META_SQL_PARM6 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 6
    21 L_META_SQL_PARM7 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 7
    22 LEFT_SQL_ID Character(30) VARCHAR2(30) NOT NULL Left SQL Object ID

    Prompt Table: TL_SQL_SUBQ_VW

    23 COND_OPERATOR Character(4) VARCHAR2(4) NOT NULL Conditional Operator
    <=<
    <==<=
    <>=<>
    ===
    >=>
    >==>=
    EXST=EXISTS
    IN=IN
    NTEX=NOT EXISTS
    NTIN=NOT IN
    24 RIGHT_PAREN Character(1) VARCHAR2(1) NOT NULL Right Parenthesis
    1=)
    2=))
    3=)))
    4=))))
    5=)))))
    6=))))))
    7=)))))))
    25 RIGHT_EXPR_TYPE Character(1) VARCHAR2(1) NOT NULL Right Expression Type
    0=Record.Field
    1=Constant
    2=State Variable
    3=MetaSQL
    4=SubQuery
    5=Bind
    6=Template
    26 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
    27 RIGHT_RECNAME Character(15) VARCHAR2(15) NOT NULL Right Record (Table) Name

    Default Value: TL_SQL_OBJECT.RECNAME

    28 RIGHT_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Right Field Name

    Prompt Table: TL_R_RECFLD_VW

    29 R_AGGR_FUNC_TYPE Character(1) VARCHAR2(1) NOT NULL Aggregate Function
    0=MIN
    1=MAX
    2=AVG
    3=SUM
    4=COUNT
    5=COUNT(*)
    6=NONE
    30 RIGHT_CONSTANT Character(35) VARCHAR2(35) NOT NULL Right Constant
    31 RIGHT_STATEVAR Character(35) VARCHAR2(35) NOT NULL Right State Variable

    Prompt Table: TL_STATE_VARS

    32 R_META_SQL Character(30) VARCHAR2(30) NOT NULL Right MetaSQL

    Prompt Table: TL_META_WHR_VW

    33 R_META_SQL_PARM1 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 1
    34 R_META_SQL_PARM2 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 2
    35 R_META_SQL_PARM3 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 3
    36 R_META_SQL_PARM4 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 4
    37 R_META_SQL_PARM5 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 5
    38 R_META_SQL_PARM6 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 6
    39 R_META_SQL_PARM7 Character(20) VARCHAR2(20) NOT NULL MetaSQL Parameter 7
    40 RIGHT_SQL_ID Character(30) VARCHAR2(30) NOT NULL Right SQL Object ID

    Prompt Table: TL_SQL_SUBQ_VW

    41 EXPRESSION_TXT Character(254) VARCHAR2(254) NOT NULL Expression Text