PSXPRPTDEFN

index back

BIP Report Definition

Report definition for BI Publisher

  • Related language record: PSXPRPTDEFNLNG
  • Parent record of PSXPRPTPROP PSXPRPTSCOPEFLD PSXPRPTSRCHKEYS PSXPRPTTMCTL_VW PSXPRPTTMPL PSXPRPTTMPLCTRL PSXPRPTTMPL_VW1 PSXPRPTVIEWER
  • PeopleSoft Field Name Field Type Column Type Description
    REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    PT_REPORT_STATUS Character(1) VARCHAR2(1) NOT NULL Report Status
    A=Active
    I=Inactive
    P=In Progress

    Default: P

    REPORT_CATEGORY_ID Character(18) VARCHAR2(18) NOT NULL Report Category ID

    Prompt Table: PSXPRPTCAT

    DS_TYPE Character(3) VARCHAR2(3) NOT NULL Data Source Type
    CPQ=Composite Query
    CQR=Connected Query
    QRY=Query
    RST=Rowset
    XMD=XMLDoc Object
    XML=XML File

    Default: QRY

    DS_ID Character(30) VARCHAR2(30) NOT NULL Data Source ID
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    PT_TEMPLATE_TYPE Character(3) VARCHAR2(3) NOT NULL Template Type
    ETX=eText
    PDF=PDF
    RTF=RTF
    XLS=Excel
    XSL=XSL

    Default: RTF

    Prompt Table: PSXPTMPLTYPE

    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    IS_EDITABLE Character(1) VARCHAR2(1) NOT NULL Editable?
    N=No
    Y=Yes

    Y/N Table Edit

    UNIQUEBURSTVALUE Character(1) VARCHAR2(1) NOT NULL Enforce Unique Burst Value
    N=No
    Y=Yes
    OUTDESTTYPE Character(3) VARCHAR2(3) NOT NULL Process Request output destination type.
    0=Any
    1=(None)
    2=File
    3=Printer
    4=Window
    5=Email
    6=Web
    7=Default
    8=Feed
    9=IB Node

    Default: 0

    Prompt Table: PSXPOUTDSTYP_VW

    PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name

    Prompt Table: PRCSDEFNFLDR_VW

    USERFILENAME Character(64) VARCHAR2(64) NOT NULL File Name
    OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination
    DESTPRINTER Character(127) VARCHAR2(127) NOT NULL Destination Printer
    ARCHIVE_ON Date(10) DATE Archive On
    PSXP_ARCHIVE_UNIT Character(1) VARCHAR2(1) NOT NULL Archive Unit
    0=None
    1=Years
    2=Months
    3=Days
    4=Hours
    5=Minutes
    6=Seconds
    PSXP_ARCHIVE_VALUE Number(3,0) SMALLINT NOT NULL Days Before Purge
    PSXP_ARCHIVEVALUE4 Number(4,0) SMALLINT NOT NULL Field to keep BI Publisher Retention Days number - added for using 4 digits value. Prev used PSXP_ARCHIVE_VALUE has only 3 digits
    PSXP_EMAIL_OPTION Character(1) VARCHAR2(1) NOT NULL Email Option
    0=Report as attachment
    1=URL to report manager

    Default: 0

    BURST_FIELDNAME Character(30) VARCHAR2(30) NOT NULL Burst Field Name

    Prompt Table: PSXPFLDLIST_VW

    SEC_JOIN_TABLE Character(15) VARCHAR2(15) NOT NULL Security Join Table

    Prompt Table: PSXPJOINTBL_VW

    SECURITY_FIELDNAME Character(30) VARCHAR2(30) NOT NULL Security Field Name
    SECIDTYPE Character(1) VARCHAR2(1) NOT NULL Security ID Type
    2=User ID
    4=Permission List
    TMPLCTRL_FIELDNAME Character(30) VARCHAR2(30) NOT NULL Template Control Field Name
    RTEMAILMOD Character(1) VARCHAR2(1) NOT NULL Recipient address entry

    Y/N Table Edit

    RTVIEWERMOD Character(1) VARCHAR2(1) NOT NULL Viewer ID assignment

    Y/N Table Edit

    REGISTERED_BY Character(30) VARCHAR2(30) NOT NULL Registered By
    REGISTERED_DTTM DateTime(26) TIMESTAMP Registered Date/Time
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies 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.
    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 25-NOV-20