PSXPRPTDEFN

Return to Index

Report definition for XML Publisher

  • Related language record: PSXPRPTDEFNLNG

  • Parent record of PSXPRPTSCOPEFLD PSXPRPTSRCHKEYS PSXPRPTTMCTL_VW PSXPRPTTMPL PSXPRPTTMPLCTRL PSXPRPTTMPL_VW1 PSXPRPTVIEWER

    • PeopleSoft Field NameDescription
    REPORT_DEFN_IDReport Name
    DESCRDescription
    PT_REPORT_STATUSReport Status
    A=Active
    I=Inactive
    P=In Progress (default)
    REPORT_CATEGORY_IDReport Category ID

    Prompt Table: PSXPRPTCAT

    DS_TYPEData Source Type
    QRY=PS Query (default)
    RST=Rowset
    XMD=XMLDoc Object
    XML=XML File
    DS_IDData Source ID
    OPRIDA user's ID
    PT_TEMPLATE_TYPETemplate Type
    ETX=eText
    PDF=PDF
    RTF=RTF (default)
    XSL=XSL

    Prompt Table: PSXPTMPLTYPE

    OBJECTOWNERIDObject owner identifier translate values
    IS_EDITABLEEditable?
    N=No
    Y=Yes

    Y/N Table Edit

    OUTDESTTYPEProcess Request output destination type.
    0=Any (default)
    1=(None)
    2=File
    3=Printer
    4=Window
    5=Email
    6=Web
    7=Default

    Prompt Table: PSXPOUTDSTYP_VW

    PSRF_FOLDER_NAMEReporting Folder's Name

    Prompt Table: PRCSDEFNFLDR_VW

    OUTDESTProcess Scheduler Output Destination
    DESTPRINTERDestination Printer
    ARCHIVE_ONArchive On
    PSXP_ARCHIVE_UNITArchive Unit
    0=None
    1=Years
    2=Months
    3=Days
    4=Hours
    5=Minutes
    6=Seconds
    PSXP_ARCHIVE_VALUEDays Before Purge
    PSXP_EMAIL_OPTIONEmail Option
    0=Report as attachment (default)
    1=URL to report manager
    BURST_FIELDNAMEBurst Field Name

    Prompt Table: PSXPFLDLIST_VW

    SEC_JOIN_TABLESecurity Join Table

    Prompt Table: PSXPJOINTBL_VW

    SECURITY_FIELDNAMESecurity Field Name
    SECIDTYPESecurity ID Type
    2=User ID
    4=Permissioin List
    TMPLCTRL_FIELDNAMETemplate Control Field Name
    RTEMAILMODRecipient address entry

    Y/N Table Edit

    RTVIEWERMODViewer ID assignment

    Y/N Table Edit

    REGISTERED_BYRegistered By
    REGISTERED_DTTMRegistered Date/Time
    VERSIONInternal PeopleTools version to control reloading of XML Publisher Report Definition objects in cache.

    OBJECTTYPE = 'XRRDM', XML Publisher Report Definition.  Also on PSLOCK

    LASTUPDOPRIDSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDDTTMSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 03 September 2010