PTADSREC_CHL_VW

(SQL View)
 Index Back

SELECT P.RECNAME PARENTRECNAME , C.RECNAME RECNAME , C.RECDESCR RECDESC , %NumToChar(C.RECTYPE) RECTYPE_CHAR FROM PSRECDEFN P , PSRECDEFN C WHERE C.RECTYPE = 0 AND P.RECTYPE = 0 AND EXISTS ( SELECT 'Parent Key is subset of Child Key' FROM PSRECFLDDBKEYVW CK WHERE CK.RECNAME = C.RECNAME AND CK.FIELDNAME IN ( SELECT PK1.FIELDNAME FROM PSRECFLDDBKEYVW PK1 WHERE PK1.RECNAME = P.RECNAME) GROUP BY CK.recname HAVING COUNT(CK.fieldname) = ( SELECT COUNT(PK2.fieldname) FROM PSRECFLDDBKEYVW PK2 WHERE PK2.RECNAME=P.RECNAME) ) AND (NOT EXISTS ( SELECT 'Is RLR' FROM PSRECDEFN L WHERE L.RELLANGRECNAME = C.RECNAME) OR EXISTS ( SELECT 'Parent points to its RLR?' FROM PSRECDEFN L WHERE L.RELLANGRECNAME = C.RECNAME AND L.RECNAME=P.RECNAME))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PARENTRECNAME Character(15) VARCHAR2(15) NOT NULL Parent Record Name
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
3 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
4 RECTYPE_CHAR Character(1) VARCHAR2(1) NOT NULL Record Type denoted in character for translate purpose.
0=SQL Table
1=SQL View
2=Derived/Work
3=SubRecord
5=Dynamic View
6=Query View
7=Temporary Table