RO_OB_LOG_VW(SQL View) |
Index Back |
|---|---|
Order Bridge ViewIt has been used to generate the main order bridge on fulfillment page |
| SELECT A.PRCSNAME ,A.PRCSTYPE ,A.RUNSTATUSDESCR ,A.PRCSINSTANCE ,B.CAPTURE_ID ,B.ACTIVITY_ID ,B.RC_TASK_ID ,B.RO_OB_EVENT_ID ,A.RUNDTTM ,B.BUS_PROC_INSTANCE FROM PS_PMN_PRCSLIST A , PS_RO_OB_LOG B WHERE A.RUNCNTLID =B.KEY_CHAR_30_01 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 2 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL | Process Type |
| 3 | RUNSTATUSDESCR | Character(10) | VARCHAR2(10) NOT NULL | Run Status |
| 4 | PRCSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 5 | CAPTURE_ID | Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 6 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Used in Contracts Integration, Activity Identifier |
| 7 | RC_TASK_ID | Character(15) | VARCHAR2(15) NOT NULL | Task ID used for Business Process tracking. |
| 8 | RO_OB_EVENT_ID | Number(18,0) | DECIMAL(18) NOT NULL | This is used in order bridge |
| 9 | RUNDTTM | DateTime(26) | TIMESTAMP | Run Date/Time |
| 10 | BUS_PROC_INSTANCE | Number(18,0) | DECIMAL(18) NOT NULL | Business Project Instance. This is the Business Project instance of a business project. |