PSPTDEFSECTYP_V

(SQL View)
 Index Back

Definition Security Def Types


SELECT A.OBJNAME ,A.DESCR ,A.RECNAME ,A.OBJECTTYPE FROM %Table(APP_DES_OBJECTS) A WHERE A.OBJECTTYPE < 9999

  • Related Language Record: PSPTDEFSECTYPLV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OBJNAME Character(30) VARCHAR2(30) NOT NULL Object Name
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    4 OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type