PSXPDSSRCH_VW

index back

SELECT DS_TYPE , DS_ID , OPRID , DESCR , ACTIVE_FLAG , OBJECTOWNERID , 'U' FROM PSXPDATASRC

PeopleSoft Field NameField TypeColumn TypeDescription
DS_TYPECharacter(3)VARCHAR2(3) NOT NULLData Source Type
CQR=Connected Query
QRY=Query
RST=Rowset
XMD=XMLDoc Object
XML=XML File
DS_IDCharacter(30)VARCHAR2(30) NOT NULLData Source ID
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
ACTIVE_FLAGCharacter(1)VARCHAR2(1) NOT NULLActive Flag
A=Active
I=Inactive
OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
PSXPDSOWNERCharacter(2)VARCHAR2(2) NOT NULLData Source Owner
R=Private
U=Public

Default: U

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19