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