BI_XPRPTDEF_VW

(SQL View)
 Index Back

Report Definition Prompt View

Prompt view for XML Publisher report definition.

SELECT A.REPORT_DEFN_ID , A.DESCR , A.PT_REPORT_STATUS FROM PSXPRPTDEFN A , PSXPDATASRC B WHERE A.DS_TYPE = B.DS_TYPE AND A.DS_ID = B.DS_ID AND A.PT_REPORT_STATUS <> 'I' AND B.OBJECTOWNERID ='DBI'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 PT_REPORT_STATUS Character(1) VARCHAR2(1) NOT NULL Report Status
A=Active
I=Inactive
P=In Progress