STL_SQL_DESC_VW

(SQL View)
 Index Back

Select current descriptions

selecting current descriptions for STL_NET_RULE

SELECT SQLID , DESCR , MARKET , DBTYPE FROM PSSQLDESCR A WHERE SQLTYPE = '0' AND SQLID LIKE ('STL_NET_RULE%') AND EFFDT = ( SELECT MAX(B.EFFDT) FROM PSSQLDESCR B WHERE B.SQLID=A.SQLID AND B.DESCR=A.DESCR AND B.MARKET=A.MARKET AND B.DBTYPE=A.DBTYPE AND B.EFFDT<=%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
    • 2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    4 DBTYPE Character(1) VARCHAR2(1) NOT NULL Database Type
    0=SQLBase
    1=DB2
    2=Oracle
    3=Informix
    4=DB2/UNIX
    5=AllBase
    6=Sybase
    7=Microsoft
    8=DB2/400