| # |
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
|
| 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 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
FOEMPLDATA_UPG
|
| 6 |
START_DATE |
Date(10) |
DATE NOT NULL |
Start Date for Gen Standing PO
|
| 7 |
START_TIME |
Time(15) |
TIMESTAMP |
Start of Shift
|
| 8 |
ASSIGN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Assign Status
D=Assigned
O=Open
P=SO Pending
S=Soft Booked
U=Unassigned
|
| 9 |
SCHEDULE_COMMENT |
Character(254) |
VARCHAR2(254) NOT NULL |
Comment
|
| 10 |
WEEKLY_HOURS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Schedule Hours
|
| 11 |
END_EST_DATE |
Date(10) |
DATE |
Estimated End Date
|
| 12 |
END_ACTUAL_DATE |
Date(10) |
DATE |
Actual End Date
|
| 13 |
END_TIME |
Time(15) |
TIMESTAMP |
End of Shift
|
| 14 |
END_EST_COMMENT |
Character(254) |
VARCHAR2(254) NOT NULL |
Estimated End Comment
|
| 15 |
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
|
| 16 |
END_ACTUAL_COMMENT |
Character(254) |
VARCHAR2(254) NOT NULL |
End Comment
|
| 17 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODETBL_UPG
|
| 18 |
SALARY |
Number(12,3) |
DECIMAL(11,3) NOT NULL |
Salary Accepted
|
| 19 |
CAREER_FEE |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Career Fee
|
| 20 |
COMPENSATION |
Number(12,3) |
DECIMAL(11,3) NOT NULL |
Compensation
|
| 21 |
ACTUAL_FEE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Actual Fee Pct
|
| 22 |
ACTUAL_FLAT_FEE |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Actual Fee
|
| 23 |
BILL_DATE |
Date(10) |
DATE |
Fall Off Credit Date
|
| 24 |
INCOME |
Number(11,3) |
DECIMAL(10,3) NOT NULL |
Income
|
| 25 |
OT_PERCENT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Overtime Percentage
Default Value: FOCUSTOMER_UPG.OT_PERCENT
|
| 26 |
MARGIN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Margin
|
| 27 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
FO_CUST_WS_SCH3
|
| 28 |
FO_CSF_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Definition ID
Prompt Table:
FO_CSF_DEFN_VW
|
| 29 |
SERVICE_AREA |
Character(6) |
VARCHAR2(6) NOT NULL |
Line of Business
Prompt Table:
FO_LINE_BUSINES
|
| 30 |
MARKUP_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Markup Code
|
| 31 |
PB_MARKUP |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Mark Up %
|
| 32 |
FALL_OFF_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Fall Off Code
Prompt Table:
FALL_OFF_SRCH
|
| 33 |
RETURN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Type
|
| 34 |
DAY_LEN |
Number(3,0) |
SMALLINT NOT NULL |
day length
|
| 35 |
FO_PERMANENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Temp To Hire
Default Value: N
|
| 36 |
FALL_OFF_AMT |
Number(11,3) |
DECIMAL(10,3) NOT NULL |
Fall Off Amount
|
| 37 |
FEE_SCHEDULE |
Character(50) |
VARCHAR2(50) NOT NULL |
Fee Schedule
Prompt Table:
POTENTIAL_VW
|
| 38 |
FEE_SCHEDULE_SENT |
Date(10) |
DATE |
Fee Schedule Sent
|
| 39 |
FEE_SCHEDULE_SIGN |
Date(10) |
DATE |
Fee Schedule Sign
|
| 40 |
GUARANTEE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Guarantee Days
|
| 41 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 42 |
CA_PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Internal PO ID
Prompt Table:
FO_PO_HDR_VW
|
| 43 |
AWAITING_PO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Awaiting PO
Y/N Table Edit
|
| 44 |
FO_PUBLISH_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Publish Assignment
Default Value: Y
|
| 45 |
FO_PUBLISH2_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Publish Schedule
Default Value: Y
|
| 46 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 47 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 48 |
FO_FALL_OFF |
Character(1) |
VARCHAR2(1) NOT NULL |
Fall Off
|
| 49 |
TAX_LOCATION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code
Prompt Table:
%EDITTABLE
|
| 50 |
WORKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Workgroup
Prompt Table:
TL_WRKGRP_TBL
|
| 51 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUPTBL_UPG
|
| 52 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Group
Prompt Table:
GP_PYGRP
|
| 53 |
TASKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Taskgroup
Prompt Table:
TL_TASKGRP_TBL
|
| 54 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
%EDITTABLE2
|
| 55 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
FO_VND_LOC_SCRL
|
| 56 |
FO_TARGET_MARGIN |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Target Margin
|
| 57 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
%RECNAME_EDIT
|
| 58 |
BUSINESS_UNIT_HR |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit HR
|
| 59 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|