DS_TYPECQR=Connected Query
QRY=PS Query
RST=Rowset
XMD=XMLDoc Object
XML=XML File
Default: QRY
DS_IDPrompt Table: %EDITTABLE
OPRIDA=Active
I=Inactive
PSXPDATASRC |
| PeopleSoft Field Name | Field Type | Description |
|---|---|---|
| DS_TYPE | VARCHAR2(3) NOT NULL | Data Source Type CQR=Connected Query QRY=PS Query RST=Rowset XMD=XMLDoc Object XML=XML File Default: QRY |
| DS_ID | VARCHAR2(30) NOT NULL | Data Source ID Prompt Table: %EDITTABLE |
| OPRID | VARCHAR2(30) NOT NULL | A user's ID |
| DESCR | VARCHAR2(30) NOT NULL | Description |
| ACTIVE_FLAG | VARCHAR2(1) NOT NULL | Active Flag A=Active I=Inactive |
| SCHEMAFILE | VARCHAR2(128) NOT NULL | Schema File |
| SAMPLEDATFILE | VARCHAR2(128) NOT NULL | Sample Data File |
| REGISTERED_BY | VARCHAR2(30) NOT NULL | Registered By |
| REGISTERED_DTTM | DATE | Registered Date/Time |
| OBJECTOWNERID | VARCHAR2(4) NOT NULL | Object owner identifier translate values |
| VERSION | DECIMAL(10) NOT NULL | Version |
| LASTUPDOPRID | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| LASTUPDDTTM | DATE | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 06 February 2013 |