TL_SQL_OBJECT

(SQL Table)
 Index Back

High Level SQL Object Defn

This record is the highest level record of a SQL Object used within the Time and Labor Rules Framework.

  • Related Language Record: TL_SQL_OBJ_LANG

  • Parent Record Of TL_SQL_INSERT TL_SQL_JOIN TL_SQL_SEL_FLDS TL_SQL_TABLES TL_SQL_UPDATE TL_SQL_WHERE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SQL_ID Character(30) VARCHAR2(30) NOT NULL TL
    2 SQL_TYPE Character(1) VARCHAR2(1) NOT NULL SQL Object Type
    0=Delete
    1=Insert
    2=Select
    3=Update
    4=Expression Text
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TL_SQL_OBJECT.DESCR

    5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: %EDITTABLE

    6 DISTINCT_FLAG Character(1) VARCHAR2(1) NOT NULL Select Distinct

    Y/N Table Edit

    7 SELECT_TYPE Character(1) VARCHAR2(1) NOT NULL This field indicates the type of Select for a TL SQL Object. Into State refers to data being loaded inot AE State Records, Into Target refers to a Select used in an Insert...Select Statement. subquery means that the select is a subquery.
    0=Into State
    1=Insert...Select
    2=Subquery

    Default Value: 0

    8 EXISTS_FLAG Character(1) VARCHAR2(1) NOT NULL This Flag tells if we should use Exists, or Not Exists as a predicate prefixing the SubQuery.
    0=Exists
    1=Not Exists
    9 CORE_COMPONENT Character(1) VARCHAR2(1) NOT NULL Indicates whether the object is delivered by PeopleSoft.

    Y/N Table Edit

    Default Value: N

    10 DESCRLONG Long Character CLOB Long Description