PTCHPLC_SRM2_VW

(SQL View)
Index Back

SELECT SQLID , SQLTYPE FROM PSSQLDEFN WHERE SQLTYPE IN ('0','1','2','3','4')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL SQL Id
2 OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL SQL Type