DS_TYPECPQ=Composite Query
CQR=Connected Query
QRY=Query
RST=Rowset
XMD=XMLDoc Object
XML=XML File
DS_IDOPRIDA=Active
I=Inactive
R=Private
U=Public
Default: U
PSXPDSSRCH_VW |
index back |
|---|
| SELECT DS_TYPE , DS_ID , OPRID , DESCR , ACTIVE_FLAG , OBJECTOWNERID , 'U' FROM PSXPDATASRC |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| 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 |
| DS_ID |
Character(30) | VARCHAR2(30) NOT NULL | Data Source ID |
| OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive |
| OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier translate values |
| PSXPDSOWNER | Character(2) | VARCHAR2(2) NOT NULL |
Data Source Owner
R=Private U=Public Default: U |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |