PSXPDATASRC

Return to Index

Data Source definition table for BI Publisher

  • Related language record: PSXPDATASRCLNG
  • Parent record of PSXPDATASRC_WK2
  • PeopleSoft Field NameField TypeDescription
    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

    Prompt Table: %EDITTABLE

    OPRIDVARCHAR2(30) NOT NULLA user's ID
    DESCRVARCHAR2(30) NOT NULLDescription
    ACTIVE_FLAGVARCHAR2(1) NOT NULLActive Flag
    A=Active
    I=Inactive
    SCHEMAFILEVARCHAR2(128) NOT NULLSchema File
    SAMPLEDATFILEVARCHAR2(128) NOT NULLSample Data File
    REGISTERED_BYVARCHAR2(30) NOT NULLRegistered By
    REGISTERED_DTTMDATERegistered Date/Time
    OBJECTOWNERIDVARCHAR2(4) NOT NULLObject owner identifier translate values
    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