PTEXTSRCNAMEPTEXTDEPINDEXNAMEPTEXTDATASRCNAMESP=Stop
ST=Start
PTEXTXMGR_VW(SQL View) |
Index Back |
|---|---|
External source Index Manager |
| SELECT DISTINCT PTEXTSRCNAME ,PTEXTDEPINDEXNAME ,PTEXTDATASRCNAME ,PTEXTDEPCOUNT , PTEXTDEPUPDDTTM , PTEXTIDXSTATUS FROM PS_PTEXTXMGR_R /* WHERE PTEXTSRCNAME <> ' ' */ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTEXTSRCNAME |
Character(128) | VARCHAR2(128) NOT NULL | Definition |
| 2 | PTEXTDEPINDEXNAME |
Character(65) | VARCHAR2(65) NOT NULL | Index Name |
| 3 | PTEXTDATASRCNAME |
Character(128) | VARCHAR2(128) NOT NULL | Data Source Name |
| 4 | PTEXTDEPCOUNT | Number(10,0) | DECIMAL(10) NOT NULL | Count |
| 5 | PTEXTDEPUPDDTTM | DateTime(26) | TIMESTAMP | Created On |
| 6 | PTEXTIDXSTATUS | Character(2) | VARCHAR2(2) NOT NULL |
Status
SP=Stop ST=Start |