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 NameField TypeColumn TypeDescription
PARENTRECNAMECharacter(15)VARCHAR2(15) NOT NULLParent Record Name
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
RECDESCRCharacter(30)VARCHAR2(30) NOT NULLRecord Description
RECTYPE_CHARCharacter(1)VARCHAR2(1) NOT NULLRecord 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19