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 NameField TypeColumn TypeDescription
    CONTENT_DESCRCharacter(254)VARCHAR2(254) NOT NULLReport Description
    DISTNODENAMECharacter(15)VARCHAR2(15) NOT NULLReport Distribution Node Name
    CONTENTIDNumber(15,0)DECIMAL(15) NOT NULLReport ID
    DISTSTATUSCharacter(2)VARCHAR2(2) NOT NULLDistribution 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
    ENDDTTMDateTime(26)TIMESTAMPEnd Date/Time
    EXPIRATION_DATEDate(10)DATEExpiration Date
    GENPRCSTYPECharacter(2)VARCHAR2(2) NOT NULLGeneric 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_FLAGCharacter(1)VARCHAR2(1) NOT NULLLog File Only Flag
    OUTDESTFORMATCharacter(3)VARCHAR2(3) NOT NULLProcess 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)
    OUTPUTDIRCharacter(100)VARCHAR2(100) NOT NULLOutput Directory
    PRCSBURSTRPTCharacter(1)VARCHAR2(1) NOT NULLFlag to indicate this is a bursted report
    PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
    PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
    PRCSOUTPUTDIRCharacter(254)VARCHAR2(254) NOT NULLProcess Output Directory
    TRANSFERINSTANCENumber(15,0)DECIMAL(15) NOT NULLTransfer Instance
    FILENAMECharacter(80)VARCHAR2(80) NOT NULLFile Name
    PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
    PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name
    RQSTDTTMDateTime(26)TIMESTAMPRequest Date/Time
    DTTM_CREATEDDateTime(26)TIMESTAMPDatetime Created
    URLCharacter(254)VARCHAR2(254) NOT NULLInternet URL (Universal Resource Locator)
    RUNCNTLIDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    DISTIDCharacter(30)VARCHAR2(30) NOT NULLDistribution ID
    DBNAMECharacter(8)VARCHAR2(8) NOT NULLDatabase Name
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19