FOASGNTMPLT_UPG

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ORDER_ID Character(25) VARCHAR2(25) NOT NULL Order ID
3 ORDER_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Order
C=Career Order
T=Temporary Order
4 FO_ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Assignment ID
5 FO_TEMPLATE_TYPE Character(4) VARCHAR2(4) NOT NULL Form Type

Prompt Table: %EDITTABLE

6 TEMPLATE_CODE Character(6) VARCHAR2(6) NOT NULL Form Code

Prompt Table: FO_TEMPLATE_HDR

7 FO_DATE Date(10) DATE Date