PTSF_SBO_NAMEPrompt Table: PTSF_DEP_SBO_VW
PROCESS_INSTANCEPTSF_ES_DT_ERR_SEQPTSF_ES_DT_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT Q.PTSF_SBO_NAME , Q.PROCESS_INSTANCE , Q.PTSF_ES_DT_ERR_SEQ , Q.PTSF_SRCH_ENG_INS FROM PS_PTSF_ES_DT_ERR1 Q , PS_PTSF_ES_DT_ERR2 R WHERE Q.PTSF_SBO_NAME=R.PTSF_SBO_NAME AND Q.PROCESS_INSTANCE=R.PROCESS_INSTANCE AND Q.PTSF_ES_SEG_NO=R.PTSF_ES_SEG_NO AND Q.PTSF_ES_DT_ERR_SEQ = R.PTSF_ES_DT_ERR_SEQ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTSF_SBO_NAME |
Character(65) | VARCHAR2(65) NOT NULL |
Search Definition (see PSPTSF_SD).
Prompt Table: PTSF_DEP_SBO_VW |
| 2 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | PTSF_ES_DT_ERR_SEQ |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | PTSF_SRCH_ENG_INS | Character(30) | VARCHAR2(30) NOT NULL | Search Instance Name |