GP_ADM_REC_VW

(SQL View)
 Index Back

Prompt view for Def Admin Rslt

This view will return records and views that contain a column DESCR and has EMPLID, EFFDT, or SETID as keys plus one additional key.

SELECT DISTINCT A.RECNAME ,A.RECDESCR FROM PSRECDEFN A ,PSRECFIELD B ,PSDBFIELD C ,PSRECFLDKEYSVW D WHERE A.RECTYPE IN (0,1,6) AND A.RECNAME=B.RECNAME AND B.FIELDNAME=C.FIELDNAME AND C.FIELDTYPE = 0 AND A.RECNAME = D.RECNAME AND B.FIELDNAME = D.FIELDNAME AND 1 = ( SELECT 1 FROM PSRECFIELD E WHERE E.RECNAME = A.RECNAME AND E.FIELDNAME = 'DESCR') AND 1 >= ( SELECT COUNT(*) FROM PSRECFLDKEYSVW F WHERE F.RECNAME = A.RECNAME AND F.FIELDNAME NOT IN ('EMPLID', 'EFFDT','SETID'))

  • Related Language Record: GP_ADM_REC_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description