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 IN (0,1,5,6) AND NOT EXISTS ( SELECT 'Is Related Language Record?' FROM PSRECDEFN L WHERE L.RELLANGRECNAME = C.RECNAME ) 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) )

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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19