EODU_REC_TBL_VW

(SQL View)
 Index Back

View SQL Table Records


SELECT A.RECNAME ,A.RECDESCR ,A.OBJECTOWNERID FROM PSRECDEFN A WHERE A.RECTYPE = 0 AND A.RECNAME NOT LIKE '%_TMP%' AND A.RECNAME NOT LIKE '%_AET' AND A.RECNAME NOT LIKE '%_TEMP' AND A.RECNAME NOT LIKE '%_WRK' AND A.RECNAME NOT LIKE '%_SELO%' AND A.RECNAME NOT LIKE '%_SEL1%' AND A.RECNAME NOT LIKE '%_SEL2%' AND A.RECNAME NOT LIKE '%_SEL3%' AND A.RECNAME NOT LIKE '%_TAO%' AND A.RECNAME NOT LIKE '%_TA0%' AND A.RECNAME NOT LIKE '%_TA1' AND A.RECNAME NOT LIKE '%_TA2' AND A.RECNAME NOT LIKE '%_TA3' AND A.RECNAME NOT LIKE '%_TBL0%' AND A.RECNAME NOT LIKE '%_TEO' AND A.RECNAME NOT LIKE '%_TEO1' AND A.RECNAME NOT LIKE '%_TEO2' AND A.RECNAME NOT LIKE '%_TEO3' AND A.RECNAME NOT LIKE '%_LNG' AND A.RECNAME NOT LIKE '%_LANG' AND A.RECNAME NOT LIKE '%_LG' AND EXISTS ( SELECT 'X' FROM PSRECFIELDDB B , PSDBFIELD C WHERE A.RECNAME = B.RECNAME AND B.FIELDNAME = C.FIELDNAME AND C.FIELDTYPE IN (4, 6))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier