PeopleTools Tables related to BI/XML Publisher

PeopleTools Tables related to BI/XML Publisher

9 Comments , , Edit

  • PSXPDATASRC - Data Source definition table for BI Publisher
  • PSXPRPTCAT - Report Category table, which controls author access to the report definition
  • PSXPRPTCATAUTH - Authorization definition for report categories.
  • PSXPPRTDEFN - Report definition table for BI Publisher
  • PSXPPRTOUTFMT - Defines output format allowed and default output format for each report definition
  • PSXPRPTSCOPEFLD - Stores information required for bursting
  • PSXPRPTSRCHKEYS - This table defines extra search keys available in BIP report manager after report output is published.
  • PSXPRPTTTMPL - Defines association between report definition and template definition.
  • PSXPRPTTMPLCTRL - This table defines values that control template selection at report runtime.
  • PSXPRPTVIEWER - Defines per-report viewer access
  • PSXPSCHEMAFLMN - Schema files
  • PSXPSMPLDTMN - Sample XML data
  • PSXPTMPLDEFN  - This table stores template (including sub-template) definition for BI Publisher. Template definition has effective-dated template files as a child object.
  • PSXPTMPLFIELDEF - This table stores template file definition.
  • PSXPTMPLOUTFMT - This table stores the output formats for templates
  • PSXPTMPLTRINFO - Manage information associated with transaction files (XLIFF) for templates
  • PSXPTMPLTYPE - This table stores template types. The output type for each template type is stored in a child table: PSXPTMPLOUTTYPE
  • PSXP_FILEURL - Stores the URLs of XMLP output files
  • PSXP_RATTR_TBL - Report attributes table to store Name Value pairs of a report. Used in report folder implementations
  • PSFILEDEFN - Stores template file information
  • PSFILEDATA - Stores template file information
  • XPQRYRUNCNTL -Run control table for Query-based XMLP reports
  • XPQRYRUNPARM - XMLP Query run control parameters


SHARE

Ayesha Wee

    Blogger Comment
    Facebook Comment

9 comments :

  1. Unknown8 October 2015 at 13:08

    Thanks a lot for sharing such a usefull information and tutorials on Peoplesoft HRMS Functional Online Training

    ReplyDelete
  2. Darcy8 February 2019 at 12:30

    Typo Identified
    The Report definition table for BI Publisher is PSXPRPTDEFN

    ReplyDelete
  3. Darcy8 February 2019 at 12:32

    Report definition table for BI Publisher is misspelled, should be: PSXPRPTDEFN

    Thanks for this information - I repeated come back to this page

    ReplyDelete
  4. Anonymous16 May 2019 at 22:02

    PSXPTMPLFIELDEF - This table stores template file definition.

    Please change the table name from PSXPTMPLFIELDEF to PSXPTMPLFILEDEF.

    ReplyDelete
  5. Unknown19 November 2019 at 16:40

    This is excellent; thank you. You might want to reverse some letters in PSXPPRTDEFN to make it PSXPRPTDEFN.

    ReplyDelete
  6. meenati20 November 2019 at 05:12

    Its very informative blog and useful article thank you for sharing with us , keep posting learn
    more about Microstrategy OnlineTraining
    Power BI Online Training

    ReplyDelete
  7. Shu21 July 2020 at 07:15

    Thanks for sharing.

    There are spelling mistakes:
    Example: [PSXPTMPLFIELDEF] is incorrect, correct name is [PSXPTMPLFILEDEF]
    *** "FILE" is mis-spelled as "FIEL".

    ReplyDelete
  8. Darcy10 September 2020 at 03:50

    PSXPRPTTTMPL is miss-spelled. Should be PSXPRPTTMPL
    Has an extra 'T' in it

    ReplyDelete
  9. Darcy10 September 2020 at 03:57

    PSXPTMPLFIELDEF is misspelled - should be PSXPTMPLFILEDEF

    ReplyDelete

Subscribe to: Post Comments ( Atom )