XPQRYRPTDEFN_VW

index back

SELECT REPORT_DEFN_ID , DESCR , REPORT_CATEGORY_ID , DS_ID , OBJECTOWNERID FROM PSXPRPTDEFN WHERE DS_TYPE = 'QRY' AND PT_REPORT_STATUS = 'A'

  • Related language record: XPQRYRPTDLNG_VW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    REPORT_DEFN_IDCharacter(12)VARCHAR2(12) NOT NULLReport Name (see PSXPRPTDEFN).
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    REPORT_CATEGORY_IDCharacter(18)VARCHAR2(18) NOT NULLReport Category ID

    Prompt Table: PSXPRPTCAT

    DS_IDCharacter(30)VARCHAR2(30) NOT NULLData Source ID
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19