TRN_INQUIRY_VW

(SQL View)
Index Back

Transfers Inquiry View


SELECT TRN_BU, TRN_ID, WS_DISTRIB_STATUS FROM PS_TRN_CONTROL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRN_BU Character(5) VARCHAR2(5) NOT NULL Transfer Business Unit
2 TRN_ID Character(15) VARCHAR2(15) NOT NULL Transfer Worksheet ID
3 WS_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Worksheet Distribution Status
G=Generated
N=Not Generated