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 NameField TypeColumn TypeDescription
    REPORT_DEFN_IDCharacter(12)VARCHAR2(12) NOT NULLReport Name
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    PT_REPORT_STATUSCharacter(1)VARCHAR2(1) NOT NULLReport Status
    A=Active
    I=Inactive
    P=In Progress

    Default: P

    REPORT_CATEGORY_IDCharacter(18)VARCHAR2(18) NOT NULLReport Category ID

    Prompt Table: PSXPRPTCAT

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

    Default: QRY

    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

    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    IS_EDITABLECharacter(1)VARCHAR2(1) NOT NULLEditable?
    N=No
    Y=Yes

    Y/N Table Edit

    UNIQUEBURSTVALUECharacter(1)VARCHAR2(1) NOT NULLEnforce Unique Burst Value
    N=No
    Y=Yes
    OUTDESTTYPECharacter(3)VARCHAR2(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
    9=IB Node

    Default: 0

    Prompt Table: PSXPOUTDSTYP_VW

    PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name

    Prompt Table: PRCSDEFNFLDR_VW

    USERFILENAMECharacter(64)VARCHAR2(64) NOT NULLFile Name
    OUTDESTCharacter(127)VARCHAR2(127) NOT NULLProcess Scheduler Output Destination
    DESTPRINTERCharacter(127)VARCHAR2(127) NOT NULLDestination Printer
    ARCHIVE_ONDate(10)DATEArchive On
    PSXP_ARCHIVE_UNITCharacter(1)VARCHAR2(1) NOT NULLArchive Unit
    0=None
    1=Years
    2=Months
    3=Days
    4=Hours
    5=Minutes
    6=Seconds
    PSXP_ARCHIVE_VALUENumber(3,0)SMALLINT NOT NULLDays Before Purge
    PSXP_ARCHIVEVALUE4Number(4,0)SMALLINT NOT NULLField to keep BI Publisher Retention Days number - added for using 4 digits value. Prev used PSXP_ARCHIVE_VALUE has only 3 digits
    PSXP_EMAIL_OPTIONCharacter(1)VARCHAR2(1) NOT NULLEmail Option
    0=Report as attachment
    1=URL to report manager

    Default: 0

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

    Prompt Table: PSXPFLDLIST_VW

    SEC_JOIN_TABLECharacter(15)VARCHAR2(15) NOT NULLSecurity Join Table

    Prompt Table: PSXPJOINTBL_VW

    SECURITY_FIELDNAMECharacter(30)VARCHAR2(30) NOT NULLSecurity Field Name
    SECIDTYPECharacter(1)VARCHAR2(1) NOT NULLSecurity ID Type
    2=User ID
    4=Permission List
    TMPLCTRL_FIELDNAMECharacter(30)VARCHAR2(30) NOT NULLTemplate Control Field Name
    RTEMAILMODCharacter(1)VARCHAR2(1) NOT NULLRecipient address entry

    Y/N Table Edit

    RTVIEWERMODCharacter(1)VARCHAR2(1) NOT NULLViewer ID assignment

    Y/N Table Edit

    REGISTERED_BYCharacter(30)VARCHAR2(30) NOT NULLRegistered By
    REGISTERED_DTTMDateTime(26)TIMESTAMPRegistered Date/Time
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    LASTUPDOPRIDCharacter(30)VARCHAR2(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.
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19