FOORDER_UPG

(SQL Table)
Index Back

Front Office Orders

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPRDEFTBL_UPG.BUSINESS_UNIT

Prompt Table: SP_BUAO_NONVW

2 ORDER_ID Character(25) VARCHAR2(25) NOT NULL Order ID

Default Value: NEXT

Prompt Table: FO_ORDER_VW

3 ORDER_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Order
C=Career Order
T=Temporary Order
4 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: FO_CST_ALL_A1_V

5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: %RECNAME_EDIT

6 ORDER_STATUS Character(3) VARCHAR2(3) NOT NULL Order Status
C=Closed
O=Open
P=Pending
X=Canceled

Default Value: Q

7 USER_STATUS Character(6) VARCHAR2(6) NOT NULL User Status

Prompt Table: USER_STATUS_VW

8 REPORT_TO Character(40) VARCHAR2(40) NOT NULL Report To

Prompt Table: FO_CONT_ORDR_VW

9 CALLER_NAME Character(40) VARCHAR2(40) NOT NULL Caller Name

Prompt Table: FO_CONT_ORDR_VW

10 MANAGER_CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Order Contact

Prompt Table: FO_CONT_SRC_VW2

11 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

Default Value: %datetime

12 OPEN_DT Date(10) DATE Date Opened
13 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

14 ORDER_REASON_CD Character(2) VARCHAR2(2) NOT NULL Order Reason
IN=Interviewing for Permanent
IP=Internal Replacement/Perm
MC=Marketing Call
ML=Medical/Maternity Leave
NI=Not Investigated
NP=New Position/Perm
OS=Other Service Unable
OT=Other
PK=Peak Period
R1=Replacement: Other Service
R2=Replacement
SP=Special Project
VR=Vacation Replacement
15 START_TIME Time(15) TIMESTAMP Start of Shift
16 START_DATE Date(10) DATE Start Date for Gen Standing PO
17 SCHEDULE_COMMENT Character(254) VARCHAR2(254) NOT NULL Comment
18 WEEKLY_HOURS Number(6,2) DECIMAL(5,2) NOT NULL Schedule Hours
19 END_EST_DATE Date(10) DATE Estimated End Date
20 END_TIME Time(15) TIMESTAMP End of Shift
21 END_EST_COMMENT Character(254) VARCHAR2(254) NOT NULL Estimated End Comment
22 END_ACTUAL_DATE Date(10) DATE Actual End Date
23 END_ACTUAL_REASON Character(2) VARCHAR2(2) NOT NULL End Reason
C1=Cancelled: Rate too High
C2=Cancelled: Slow in Response
C3=Cancelled: Job Delayed
C4=Cancelled: Order Not Needed
C5=Cancelled: Unknown or Other
CF=Competitor Filled Position
D1=Declined: Work Hazard
D2=Declined: Credit Problem
D3=Declined: Undesirable
D4=Declined: Unknown or Other
E1=Employee Dissatisfaction
F1=Unable to Fill: Candidate N/A
F2=Unable to Fill: Skills N/A
F3=Unable to Fill: Undesirable
FP=Filled Position
IC=Inquiry Closed
OC=Order Closed
OT=Other Reason
S1=Satisfactory: Work Completed
U1=Unsatisfactory: Employee Perf
U2=Unsatisfactory: Employ No Show
24 END_ACTUAL_COMMENT Character(254) VARCHAR2(254) NOT NULL End Comment
25 QTY_NEEDED Number(4,0) SMALLINT NOT NULL Quantity Needed
26 QTY_ACTIVE_CNT Number(4,0) SMALLINT NOT NULL Active Count
27 QTY_SHORT Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Short
28 ESSENTIAL_FUNCTION Character(254) VARCHAR2(254) NOT NULL Essential Functions
29 DESCR Character(30) VARCHAR2(30) NOT NULL Description

Prompt Table: FO_JOBSUP_SRCH2

30 WORKSITE_COMMENT Character(254) VARCHAR2(254) NOT NULL Worksite Comment
31 FO_PUBLISH_PB Character(1) VARCHAR2(1) NOT NULL Publish Assignment

Default Value: N

32 SALES_TYPE Character(1) VARCHAR2(1) NOT NULL Sales Type
33 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: JOBCODETBL_UPG

34 REG_BILL_RATE Number(19,6) DECIMAL(18,6) NOT NULL Bill Rate
35 REG_PAY_RATE Number(19,6) DECIMAL(18,6) NOT NULL Pay Rate
36 MIN_H0URS_WAIVED Character(1) VARCHAR2(1) NOT NULL Minimum Hours Waived

Y/N Table Edit

37 PROCESSING_COMMENT Character(254) VARCHAR2(254) NOT NULL Processing Comment
38 SERVICE_AREA Character(6) VARCHAR2(6) NOT NULL Line of Business

Prompt Table: FO_LINE_BUSINES

39 CAREER_PLACEMENT Character(2) VARCHAR2(2) NOT NULL Career Placement
40 MIN_YEARS_EXP Number(2,0) SMALLINT NOT NULL Minimum Years Experience
41 CONFIDENCE_CD Character(2) VARCHAR2(2) NOT NULL Confidence
AL=Advanced
BL=Beginner
IL=Intermediate
NI=Not Investigated
42 CLIENT_JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Client Job Title
43 SALARY_RANGE_MAX Number(11,2) DECIMAL(10,2) NOT NULL Maximum Salary Range
44 SALARY_RANGE_MIN Number(11,2) DECIMAL(10,2) NOT NULL Salary Range
45 METHOD_OF_PAYMENT Character(3) VARCHAR2(3) NOT NULL Method of Payment
46 TEMP_TO_HIRE_FEE Number(11,2) DECIMAL(10,2) NOT NULL Temp to Hire Fee
47 CAREER_FEE Number(11,2) DECIMAL(10,2) NOT NULL Career Fee
48 UC_STATE Character(6) VARCHAR2(6) NOT NULL UC State

Prompt Table: STATE_NAMES_TBL

49 TAX_SCHEDULE Character(1) VARCHAR2(1) NOT NULL Sales Tax
50 TAX_SCHEDULE_BASIS Character(3) VARCHAR2(3) NOT NULL Sales Tax Basis
51 COMMISSION_USER Character(30) VARCHAR2(30) NOT NULL Commission User

Prompt Table: OPRID_VW

52 JOB_CAT Character(3) VARCHAR2(3) NOT NULL Job Category

Prompt Table: FO_JOBTITLE_HDR

53 FO_JOBTITLE Character(9) VARCHAR2(9) NOT NULL Job Title Code

Prompt Table: FO_JOBTITLE_VW2

54 INDUSTRY Character(4) VARCHAR2(4) NOT NULL Industry
CORE=Core
EDUC=Education
FNSV=Financial Services
GOVT=Government
HLTH=Health Care
RETL=Retail
TRAN=Transportation
UTIL=Utilities

Prompt Table: INDSTRY_CODE_VW

55 PO_NUMBER Character(20) VARCHAR2(20) NOT NULL PO Number
56 SIZZLE_COMMENTS Character(254) VARCHAR2(254) NOT NULL Sizzle Comments
57 RELOCATE Character(1) VARCHAR2(1) NOT NULL Willing to Relocate

Y/N Table Edit

58 CO_OP Character(1) VARCHAR2(1) NOT NULL CO-OP Order

Y/N Table Edit

59 COMMENT2 Character(254) VARCHAR2(254) NOT NULL Comments
60 INITIAL_COMP Number(11,2) DECIMAL(10,2) NOT NULL Compensation
61 FO_ORDER_SOURCE Character(3) VARCHAR2(3) NOT NULL Order Source
62 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: FO_CUST_WS_SCH3

63 JOB_DESCR Long Character CLOB Job Description
64 CAREER_ASSIGNMENT Character(1) VARCHAR2(1) NOT NULL Career Assignment?
N=Not-Placed on a Career Order
P=Placed On a Career Order

Default Value: N

65 CONFIDENTIAL Character(1) VARCHAR2(1) NOT NULL Confidential Order
66 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments
67 SALES_OPRID Character(30) VARCHAR2(30) NOT NULL Sales Operator

Prompt Table: OPRID_VW

68 SERVICE_OPRID Character(30) VARCHAR2(30) NOT NULL Service Operator

Prompt Table: OPRID_VW

69 INVOICE_STATUS Character(2) VARCHAR2(2) NOT NULL Invoice Status
0=Submitted to Enterprise
1=Generated
10=Canceled
11=Adjusted
2=Approved
3=Processed
4=Paid
5=Submitted
6=Denied
7=Submitted to Supplier
8=Approved by Supplier
9=Denied by Supplier
70 APPROVAL_ACTION Character(1) VARCHAR2(1) NOT NULL Approval Action
71 FO_CSF_ID Character(15) VARCHAR2(15) NOT NULL Definition ID

Prompt Table: FO_ORDR_CSF_VW

72 ADDR_BILL_SEQ_NUM Number(5,0) INTEGER NOT NULL Bill to Address

Prompt Table: FO_CST_ADR_BI_V

73 ORDER_EVENT_GROUP Character(10) VARCHAR2(10) NOT NULL Order Event Group

Prompt Table: FOORDREVENT_UPG

74 BILL_TO_CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Bill To Contact ID

Prompt Table: FO_CONT_SRC_VW3

75 FO_PERMANENT Character(1) VARCHAR2(1) NOT NULL Temp To Hire
76 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

77 FO_MARKUP Character(4) VARCHAR2(4) NOT NULL Markup
NSTD=Non Standard Markup
STD=Standard Markup
78 FO_TARGET_MARGIN Number(7,3) DECIMAL(6,3) NOT NULL Target Margin