GP_ADM_REC_VL

(SQL View)
 Index Back

Related Lang for GP_ADM_REC_VW

This is a related language view for GP_ADM_REC_VW.

SELECT DISTINCT A.RECNAME ,A.LANGUAGE_CD ,A.RECDESCR FROM PSRECDEFNLANG A ,PSRECFIELD B ,PSDBFIELD C ,PSRECFLDKEYSVW D WHERE 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 for GP_ADM_REC_VW

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