KK_ALOG_PC_VW_1(SQL View) |
Index Back |
---|---|
Projects-KK Dist Status Prompt |
SELECT DISTINCT A.KK_DISTRIB_STATUS FROM PS_KK_SOURCE_HDR A , PS_KK_ACTIVITY_LOG B WHERE A.KK_TRAN_ID = B.KK_TRAN_ID AND A.KK_TRAN_DT = B.KK_TRAN_DT AND A.KK_SOURCE_TRAN IN ('PC_COLL' ,'PC_ENC' ,'PC_JOURNAL' ,'PC_PREENC' ) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | KK_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control
B=Budget Check C=Budget Create D=Distributed E=Posting Error K=Post to Commitment control N=None S=Security Error |