CS_PSRECDFN_VW

(SQL View)
 Index Back

View on PSRECDEFN

View to figure out the number of keyfields for a tablename

SELECT DISTINCT A.RECNAME ,A.RECDESCR , B.FIELDNAME , 1 FROM PSRECDEFN A , PSRECFIELDDB B WHERE A.RECTYPE IN (0,1) AND A.RECNAME = B.RECNAME AND B.USEEDIT > 2080 AND B.FIELDNAME = ( SELECT K.FIELDNAME FROM PSRECFLDKEYSVW K WHERE K.RECNAME = A.RECNAME AND 1 = ( SELECT COUNT(*) FROM PSRECFLDKEYSVW K2 WHERE K2.RECNAME = A.RECNAME AND K2.RECNAME = K.RECNAME))

  • Related Language Record: CS_PSRECDFNLNG

    • # 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
    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    4 CS_KEYCOUNT Number(3,0) SMALLINT NOT NULL Key Count