PSXPRPTSRCH_VW

index back

SELECT A.REPORT_DEFN_ID , A.DESCR , A.DS_TYPE , A.DS_ID , A.OPRID , 'U' , A.PT_TEMPLATE_TYPE , A.REPORT_CATEGORY_ID , A.OBJECTOWNERID , A.PT_REPORT_STATUS , A.BURST_FIELDNAME FROM PSXPRPTDEFN A , PSXPDATASRC B WHERE A.DS_TYPE = B.DS_TYPE AND A.DS_ID = B.DS_ID AND A.OPRID = B.OPRID AND B.ACTIVE_FLAG = 'A'

PeopleSoft Field NameField TypeColumn TypeDescription
REPORT_DEFN_IDCharacter(12)VARCHAR2(12) NOT NULLReport Name (see PSXPRPTDEFN).
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
DS_TYPECharacter(3)VARCHAR2(3) NOT NULLData Source Type
CQR=Connected Query
QRY=Query
RST=Rowset
XMD=XMLDoc Object
XML=XML File

Default: QRY

DS_IDCharacter(30)VARCHAR2(30) NOT NULLData Source ID
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
PSXPDSOWNERCharacter(2)VARCHAR2(2) NOT NULLData Source Owner
R=Private
U=Public
PT_TEMPLATE_TYPECharacter(3)VARCHAR2(3) NOT NULLTemplate Type
ETX=eText
PDF=PDF
RTF=RTF
XSL=XSL
REPORT_CATEGORY_IDCharacter(18)VARCHAR2(18) NOT NULLReport Category ID

Prompt Table: PSXPRPTCAT

OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
PT_REPORT_STATUSCharacter(1)VARCHAR2(1) NOT NULLReport Status
A=Active
I=Inactive
P=In Progress
BURST_FIELDNAMECharacter(30)VARCHAR2(30) NOT NULLBurst Field Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19