PTRS_SRCHQRYVW

(SQL View)
 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 , D.PRCSNAME , A.PRCSOUTPUTDIR , A.TRANSFERINSTANCE , B.FILENAME , D.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.CONTENTID = B.CONTENTID AND A.CONTENTID = C.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 PeopleSoft Field Type Database Column Type Description
    1 CONTENT_DESCR Character(254) VARCHAR2(254) NOT NULL Report Description
    2 DISTNODENAME Character(15) VARCHAR2(15) NOT NULL Report Distribution Node Name
    3 CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID
    4 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
    5 ENDDTTM DateTime(26) TIMESTAMP End Date/Time
    6 EXPIRATION_DATE Date(10) DATE Expiration Date
    7 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
    8 LOGFILEONLY_FLAG Character(1) VARCHAR2(1) NOT NULL Log File Only Flag
    9 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)
    10 OUTPUTDIR Character(100) VARCHAR2(100) NOT NULL Output Directory
    11 PRCSBURSTRPT Character(1) VARCHAR2(1) NOT NULL Flag to indicate this is a bursted report
    12 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    13 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
    14 PRCSOUTPUTDIR Character(254) VARCHAR2(254) NOT NULL Process Output Directory
    15 TRANSFERINSTANCE Number(15,0) DECIMAL(15) NOT NULL Transfer Instance
    16 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
    17 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
    18 PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name
    19 RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
    20 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
    21 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    22 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    23 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    24 DISTID Character(30) VARCHAR2(30) NOT NULL Distribution ID
    25 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name