FO_T_ORDER_VW

(SQL View)
Index Back

SELECT ORDER_TYPE , USER_ORDER_TYPE FROM PS_FO_ORDER_TYPE WHERE ORDER_TYPE = 'T'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ORDER_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Order
C=Career Order
T=Temporary Order
2 USER_ORDER_TYPE Character(5) VARCHAR2(5) NOT NULL User Order Type