TL_CONDITIONS

(SQL Table)
 Index Back

Time Admin Conditions

Conditions are used to define business rules in the WHERE clause of SQL text of AE Sections.

  • Related Language Record: TL_CONDS_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONDITION_ID Character(12) VARCHAR2(12) NOT NULL Condition ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TL_CONDITIONS.DESCR

    4 DESCRLONG Long Character CLOB Long Description
    5 CORE_COMPONENT Character(1) VARCHAR2(1) NOT NULL Indicates whether the object is delivered by PeopleSoft.

    Y/N Table Edit

    Default Value: N

    6 L_COND_EXPRESSION Character(1) VARCHAR2(1) NOT NULL Expression Type
    0=Record.Field
    1=Constant
    2=State Variable
    3=Meta SQL
    4=Sub-Query
    5=Expression Text
    6=Rule Template
    7 LEFT_RECNAME Character(15) VARCHAR2(15) NOT NULL Left Record (Table) Name

    Prompt Table: TL_WORK_TABLES

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

    Prompt Table: TL_LEFT_RF_VW

    9 LEFT_AGGR_FUNC Character(1) VARCHAR2(1) NOT NULL Left Aggregate Function
    0=MIN
    1=MAX
    2=AVG
    3=SUM
    4=COUNT
    5=COUNT(*)
    10 LEFT_CONSTANT Character(35) VARCHAR2(35) NOT NULL Left Constant
    11 LEFT_STATEVAR Character(35) VARCHAR2(35) NOT NULL Left State Variable

    Prompt Table: TL_STATE_VARS

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

    Prompt Table: TL_METASQL_TBL

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

    Prompt Table: TL_SQL_SCALR_VW

    21 L_EXPRESSION_TXT Character(254) VARCHAR2(254) NOT NULL Left Expression Text to be used in a Condition. It is a free form text and will not be edited by the Rule Compiler.
    22 COND_OPERATOR Character(4) VARCHAR2(4) NOT NULL Conditional Operator
    <=<
    <==<=
    <>=<>
    ===
    >=>
    >==>=
    EXST=EXISTS
    IN=IN
    NTEX=NOT EXISTS
    NTIN=NOT IN
    23 R_COND_EXPRESSION Character(1) VARCHAR2(1) NOT NULL Expression Type
    0=Record.Field
    1=Constant
    2=State Variable
    3=Meta SQL
    4=Sub-Query
    5=Expression Text
    6=Rule Template
    24 RIGHT_RECNAME Character(15) VARCHAR2(15) NOT NULL Right Record (Table) Name

    Prompt Table: TL_WORK_TABLES

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

    Prompt Table: TL_RIGHT_RF_VW

    26 RIGHT_AGGR_FUNC Character(1) VARCHAR2(1) NOT NULL Right Aggregate Function
    0=MIN
    1=MAX
    2=AVG
    3=SUM
    4=COUNT
    5=COUNT(*)
    27 RIGHT_CONSTANT Character(35) VARCHAR2(35) NOT NULL Right Constant
    28 RIGHT_STATEVAR Character(35) VARCHAR2(35) NOT NULL Right State Variable

    Prompt Table: TL_STATE_VARS

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

    Prompt Table: TL_METASQL_TBL

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

    Prompt Table: TL_SQL_SCALR_VW

    38 R_EXPRESSION_TXT Character(254) VARCHAR2(254) NOT NULL Right Expression Text to be used in a Condition. It is a free form text and won't be validated by the Rule Compiler process.