KK_SOURCE_TRANKK_TRAN_IDE=Errors Exist
I=Document in process
N=Process Unsuccessful
P=Provisionally Valid
V=No Errors or Warnings
W=Only Warnings Exist
X=Unrecorded Errors Exist
KK_TRAN_ID_VW4(SQL View) |
Index Back |
|---|---|
All 'V' or 'W' Tran ID's PrmptPrompt table for listing of all Tran_Id's. Used on the Acitity Log Inquiry Panel. Picks up only Valid or Warning Process Status's for a given Source Tran Type. |
| SELECT A.KK_SOURCE_TRAN ,A.KK_TRAN_ID ,A.KK_TRAN_DT ,A.KK_PROCESS_STATUS ,B.DESCR FROM PS_KK_SOURCE_HDR A ,PS_KK_SOURCE_TRAN B WHERE A.KK_PROCESS_STATUS IN ('V', 'W') AND A.KK_SOURCE_TRAN = B.KK_SOURCE_TRAN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | KK_SOURCE_TRAN |
Character(10) | VARCHAR2(10) NOT NULL | Source Transaction Type |
| 2 | KK_TRAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Commitment Control Foreign Key for Transaction Identification. |
| 3 | KK_TRAN_DT | Date(10) | DATE | Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID. |
| 4 | KK_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
E=Errors Exist I=Document in process N=Process Unsuccessful P=Provisionally Valid V=No Errors or Warnings W=Only Warnings Exist X=Unrecorded Errors Exist |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |