PSPTADSADMINRPT

(SQL Table)
Index Back

Record for ADS admin reports

This record is used to define ADS administrator report

  • Related Language Record: PSPTADSRPT_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTADSRPTNAME Character(30) VARCHAR2(30) NOT NULL Report Name
    2 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

    Prompt Table: PSRECDEFN

    3 PTADSRPTGRP Character(4) VARCHAR2(4) NOT NULL ADS report category
    EXT=Extended
    GRP=Groups
    PROP=Properties
    REL=Relations
    RLR=Languages
    SEC=Security
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description