RTM_SOURCE_TXNRTM_PROCESS_GROUPSEQ_NUMRTM_SRC_PRCS_VW(SQL View) |
Index Back |
|---|---|
Real-Time Process Grp Process |
| SELECT S.RTM_SOURCE_TXN , S.RTM_PROCESS_GROUP , G.SEQ_NUM , G.RTM_PROCESS_NAME FROM PS_RTM_SRC_PRCSGRP S , PS_RTM_PRCSGRP_DTL G WHERE S.RTM_PROCESS_GROUP=G.RTM_PROCESS_GROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RTM_SOURCE_TXN |
Character(10) | VARCHAR2(10) NOT NULL | Source Transaction |
| 2 | RTM_PROCESS_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | On-Demand Process Group |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | RTM_PROCESS_NAME | Character(12) | VARCHAR2(12) NOT NULL | On-Demand Process |