ANET_TP_IDPrompt Table: ANET_TP_REG
PRCSINSTANCEPrompt Table: HPYP_PRCINST_VW
1=Success
2=Error
3=Staged
4=Processing
5=Reversal Initiated
6=Reversal Failed
7=Reversed
HPYP_PRCINST_VW(SQL View) |
Index Back |
|---|---|
TP View for Process InstanceTP View for Process Instance |
| SELECT DISTINCT A.ANET_TP_ID ,A.PRCSINSTANCE ,A.POSTING_DATE ,A.HPYP_TP_STATUS ,C.PRCSNAME ,C.DESCR FROM PS_HPYP_TP_MONITOR A , PSPRCSRQST B , PS_PRCSDEFN C WHERE B.PRCSINSTANCE = A.PRCSINSTANCE AND C.PRCSNAME = B.PRCSNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ANET_TP_ID |
Character(6) | VARCHAR2(6) NOT NULL |
Touchpoint Id
Prompt Table: ANET_TP_REG |
| 2 | PRCSINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Prompt Table: HPYP_PRCINST_VW |
| 3 | POSTING_DATE | Date(10) | DATE | Posting Date |
| 4 | HPYP_TP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Touch Point Status
1=Success 2=Error 3=Staged 4=Processing 5=Reversal Initiated 6=Reversal Failed 7=Reversed |
| 5 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |