HCSC_SS_XRPT_VW (SQL View)	Index Back
BI Publisher Report view Self Service Framework specific view. This view retrieves 1. Reports with ateast one EMPLID as query Bind parameter. 2. Reports with data source other than QRY and QCR

HCSC_SS_XRPT_VW

(SQL View)

BI Publisher Report view

Self Service Framework specific view. This view retrieves 1. Reports with ateast one EMPLID as query Bind parameter. 2. Reports with data source other than QRY and QCR

SELECT RPT.REPORT_DEFN_ID , RPT.DS_TYPE , RPT.DESCR FROM PSXPRPTDEFN RPT WHERE RPT.DS_TYPE IN ('QRY','XML')

# 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 DS_TYPE Character(3) VARCHAR2(3) NOT NULL Data Source Type
CPQ=Composite Query
CQR=Connected Query
QRY=Query
RST=Rowset
XMD=XMLDoc Object
XML=XML File

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	DS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Data Source Type CPQ=Composite Query CQR=Connected Query QRY=Query RST=Rowset XMD=XMLDoc Object XML=XML File
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description