PSXPRPTDEFN

Return to Index

Report definition for BI Publisher

  • Related language record: PSXPRPTDEFNLNG
  • Parent record of PSXPRPTPROP PSXPRPTSCOPEFLD PSXPRPTSRCHKEYS PSXPRPTTMCTL_VW PSXPRPTTMPL PSXPRPTTMPLCTRL PSXPRPTTMPL_VW1 PSXPRPTVIEWER
  • PeopleSoft Field NameField TypeDescription
    REPORT_DEFN_IDVARCHAR2(12) NOT NULLReport Name
    DESCRVARCHAR2(30) NOT NULLDescription
    PT_REPORT_STATUSVARCHAR2(1) NOT NULLReport Status
    A=Active
    I=Inactive
    P=In Progress

    Default: P

    REPORT_CATEGORY_IDVARCHAR2(18) NOT NULLReport Category ID

    Prompt Table: PSXPRPTCAT

    DS_TYPEVARCHAR2(3) NOT NULLData Source Type
    CQR=Connected Query
    QRY=PS Query
    RST=Rowset
    XMD=XMLDoc Object
    XML=XML File

    Default: QRY

    DS_IDVARCHAR2(30) NOT NULLData Source ID
    OPRIDVARCHAR2(30) NOT NULLA user's ID
    PT_TEMPLATE_TYPEVARCHAR2(3) NOT NULLTemplate Type
    ETX=eText
    PDF=PDF
    RTF=RTF
    XSL=XSL

    Default: RTF

    Prompt Table: PSXPTMPLTYPE

    OBJECTOWNERIDVARCHAR2(4) NOT NULLObject owner identifier translate values
    IS_EDITABLEVARCHAR2(1) NOT NULLEditable?
    N=No
    Y=Yes

    Y/N Table Edit

    UNIQUEBURSTVALUEVARCHAR2(1) NOT NULLEnforce Unique Burst Value
    N=No
    Y=Yes
    OUTDESTTYPEVARCHAR2(3) NOT NULLProcess Request output destination type.
    0=Any
    1=(None)
    2=File
    3=Printer
    4=Window
    5=Email
    6=Web
    7=Default
    8=Feed

    Default: 0

    Prompt Table: PSXPOUTDSTYP_VW

    PSRF_FOLDER_NAMEVARCHAR2(18) NOT NULLReporting Folder's Name

    Prompt Table: PRCSDEFNFLDR_VW

    USERFILENAMEVARCHAR2(64) NOT NULLFile Name
    OUTDESTVARCHAR2(127) NOT NULLProcess Scheduler Output Destination
    DESTPRINTERVARCHAR2(127) NOT NULLDestination Printer
    ARCHIVE_ONDATEArchive On
    PSXP_ARCHIVE_UNITVARCHAR2(1) NOT NULLArchive Unit
    0=None
    1=Years
    2=Months
    3=Days
    4=Hours
    5=Minutes
    6=Seconds
    PSXP_ARCHIVE_VALUESMALLINT NOT NULLDays Before Purge
    PSXP_EMAIL_OPTIONVARCHAR2(1) NOT NULLEmail Option
    0=Report as attachment
    1=URL to report manager

    Default: 0

    BURST_FIELDNAMEVARCHAR2(30) NOT NULLBurst Field Name

    Prompt Table: PSXPFLDLIST_VW

    SEC_JOIN_TABLEVARCHAR2(15) NOT NULLSecurity Join Table

    Prompt Table: PSXPJOINTBL_VW

    SECURITY_FIELDNAMEVARCHAR2(30) NOT NULLSecurity Field Name
    SECIDTYPEVARCHAR2(1) NOT NULLSecurity ID Type
    2=User ID
    4=Permission List
    TMPLCTRL_FIELDNAMEVARCHAR2(30) NOT NULLTemplate Control Field Name
    RTEMAILMODVARCHAR2(1) NOT NULLRecipient address entry

    Y/N Table Edit

    RTVIEWERMODVARCHAR2(1) NOT NULLViewer ID assignment

    Y/N Table Edit

    REGISTERED_BYVARCHAR2(30) NOT NULLRegistered By
    REGISTERED_DTTMDATERegistered Date/Time
    VERSIONDECIMAL(10) NOT NULLVersion
    LASTUPDOPRIDVARCHAR2(30) NOT NULLSpecifies 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.
    LASTUPDDTTMDATESpecifies 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 8.52

    Return to Index

    © David Kurtz  Last updated 01 August 2015