PTADSREC_CHL_VW

 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 Field Type Column Type Description
PARENTRECNAME Character(15) VARCHAR2(15) NOT NULL Parent Record Name
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
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
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20