PTRS_SRCHQRYVW

index back

Reporting search query view

This records constitutes the main search query used in reporting search.
SELECT A.CONTENT_DESCR , A.DISTNODENAME , A.CONTENTID , A.DISTSTATUS , A.ENDDTTM , A.EXPIRATION_DATE , A.GENPRCSTYPE , A.LOGFILEONLY_FLAG , A.OUTDESTFORMAT , A.OUTPUTDIR , A.PRCSBURSTRPT , A.PRCSINSTANCE , A.PRCSNAME , A.PRCSOUTPUTDIR , A.TRANSFERINSTANCE , B.FILENAME , A.PRCSTYPE , A.PSRF_FOLDER_NAME , A.RQSTDTTM , B.DTTM_CREATED , C.URL , D.RUNCNTLID , D.OPRID , E.DISTID , C.DBNAME FROM PS_CDM_LIST A , PS_CDM_FILE_LIST B , PSRF_RINFO_TBL C , PSPRCSRQST D , PS_CDM_AUTH E WHERE A.PRCSINSTANCE = B.PRCSINSTANCE AND A.PRCSINSTANCE = C.PRCSINSTANCE AND A.PRCSINSTANCE = D.PRCSINSTANCE AND A.CONTENTID = E.CONTENTID AND A.LOGFILEONLY_FLAG = '0' AND B.CDM_FILE_TYPE NOT IN ('STDOUT', 'TRC', 'LOG', 'OUT', 'AET') AND C.FILENAME IS NOT NULL

  • Related language record: PTRS_QRYLANGVW
  • Parent record: CDM_LIST
  • PeopleSoft Field Name Field Type Column Type Description
    CONTENT_DESCR Character(254) VARCHAR2(254) NOT NULL Report Description
    DISTNODENAME Character(15) VARCHAR2(15) NOT NULL Report Distribution Node Name
    CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID
    DISTSTATUS Character(2) VARCHAR2(2) NOT NULL Distribution Status
    0=None
    1=Scheduled
    2=Processing
    3=Generated
    4=Unable to Post
    5=Posted to Web
    6=Delete
    7=Posting
    9=Pending for Approval
    ENDDTTM DateTime(26) TIMESTAMP End Date/Time
    EXPIRATION_DATE Date(10) DATE Expiration Date
    GENPRCSTYPE Character(2) VARCHAR2(2) NOT NULL Generic Process Type
    0=Other
    1=SQR
    2=PeopleSoft COBOL
    3=Crystal Report
    4=Winword Macro
    5=Application Engine
    6=Cube Builder
    7=nVision
    8=Data Mover
    9=PSJob
    LOGFILEONLY_FLAG Character(1) VARCHAR2(1) NOT NULL Log File Only Flag
    OUTDESTFORMAT Character(3) VARCHAR2(3) NOT NULL Process Request output format
    0=Any
    1=(None)
    10=Postscript (*.lis)
    11=Crystal Report (*.rpt)
    12=Rich Text File (*.rtf)
    13=SQR Portable Format (*.spf)
    14=Text Files (*.txt)
    15=Other
    16=Default
    17=XML Format(*.xml)
    18=Data Mover Data File (*.dat)
    19=Crystal Report Explorer(*.rpt)
    2=Acrobat (*.pdf)
    20=XMLP
    21=Atom
    22=Transformation
    23=Printer Command Lang. (*.pcl)
    24=PostScript (*.ps)
    3=Comma delimited (*.csv)
    4=HP Format (*.lis)
    5=HTML Documents (*.htm)
    6=Line Printer Format (*.lis)
    7=Lotus 1-2-3 Files (*.wks)
    8=Microsoft Excel Files (*.xls)
    9=Microsoft Word (*.doc)
    OUTPUTDIR Character(100) VARCHAR2(100) NOT NULL Output Directory
    PRCSBURSTRPT Character(1) VARCHAR2(1) NOT NULL Flag to indicate this is a bursted report
    PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
    PRCSOUTPUTDIR Character(254) VARCHAR2(254) NOT NULL Process Output Directory
    TRANSFERINSTANCE Number(15,0) DECIMAL(15) NOT NULL Transfer Instance
    FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
    PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
    PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name
    RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
    DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
    URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    DISTID Character(30) VARCHAR2(30) NOT NULL Distribution ID
    DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19