TL_SQL_SCALR_VW

(SQL View)
 Index Back

Scalar SQL Objects

View of SQL Objects returing only 1 field per row. Really not a scalar, but only in the sense that it is returning 1 thing for use in our Actions.

SELECT A.SQL_ID , A.DESCR ,A.DESCRSHORT ,A.DESCRLONG FROM PS_TL_SQL_OBJECT A WHERE A.SQL_TYPE = '2' AND 1 = ( SELECT COUNT(*) FROM PS_TL_SQL_SEL_FLDS B WHERE B.SQL_ID = A.SQL_ID)

  • Related Language Record: TL_SQL_OBJ_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SQL_ID Character(30) VARCHAR2(30) NOT NULL TL
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 DESCRLONG Long Character CLOB Long Description