XPQRYRPTDEF_VW2

index back

SELECT REPORT_DEFN_ID , DESCR , DS_ID , OPRID , PT_TEMPLATE_TYPE , BURST_FIELDNAME , TMPLCTRL_FIELDNAME , SECURITY_FIELDNAME FROM PSXPRPTDEFN WHERE DS_TYPE IN ('QRY', 'CQR') AND PT_REPORT_STATUS = 'A'

  • Related language record: XPQRYRPTDLG_VW2
  • PeopleSoft Field NameField TypeColumn TypeDescription
    REPORT_DEFN_IDCharacter(12)VARCHAR2(12) NOT NULLReport Name (see PSXPRPTDEFN).
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DS_IDCharacter(30)VARCHAR2(30) NOT NULLData Source ID
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    PT_TEMPLATE_TYPECharacter(3)VARCHAR2(3) NOT NULLTemplate Type
    ETX=eText
    PDF=PDF
    RTF=RTF
    XSL=XSL

    Default: RTF

    Prompt Table: PSXPTMPLTYPE

    BURST_FIELDNAMECharacter(30)VARCHAR2(30) NOT NULLBurst Field Name

    Prompt Table: PSXPFLDLIST_VW

    TMPLCTRL_FIELDNAMECharacter(30)VARCHAR2(30) NOT NULLTemplate Control Field Name
    SECURITY_FIELDNAMECharacter(30)VARCHAR2(30) NOT NULLSecurity Field Name
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19