SSR_AC_SECLNGVW

(SQL View)
 Index Back

Activity Security Record View


SELECT A.RECNAME ,B.LANGUAGE_CD ,B.RECDESCR FROM PSRECDEFN A ,PSRECDEFNLANG B WHERE A.RECNAME = B.RECNAME AND A.RECTYPE IN (0,1,7) AND A.RECNAME IN ('PSROLEDEFN','ACAD_ORG_TBL')

  • Related Language Record for SSR_AC_SECRECVW

    • # 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