| # |
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
Default Value: NEXT
|
| 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.
|
| 5 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 6 |
ORDER_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Order Status
C=Closed
O=Open
P=Pending
X=Canceled
|
| 7 |
USER_STATUS |
Character(6) |
VARCHAR2(6) NOT NULL |
User Status
|
| 8 |
REPORT_TO |
Character(40) |
VARCHAR2(40) NOT NULL |
Report To
|
| 9 |
CALLER_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Caller Name
|
| 10 |
MANAGER_CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Order Contact
|
| 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).
|
| 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 |
WEEKLY_HOURS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Schedule Hours
|
| 18 |
END_EST_DATE |
Date(10) |
DATE |
Estimated End Date
|
| 19 |
END_TIME |
Time(15) |
TIMESTAMP |
End of Shift
|
| 20 |
END_ACTUAL_DATE |
Date(10) |
DATE |
Actual End Date
|
| 21 |
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
|
| 22 |
END_ACTUAL_COMMENT |
Character(254) |
VARCHAR2(254) NOT NULL |
End Comment
|
| 23 |
QTY_NEEDED |
Number(4,0) |
SMALLINT NOT NULL |
Quantity Needed
|
| 24 |
QTY_ACTIVE_CNT |
Number(4,0) |
SMALLINT NOT NULL |
Active Count
|
| 25 |
QTY_SHORT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Short
|
| 26 |
ESSENTIAL_FUNCTION |
Character(254) |
VARCHAR2(254) NOT NULL |
Essential Functions
|
| 27 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 28 |
PUBLISH_INTERNAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Publish to Internal Website
|
| 29 |
SALES_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Type
|
| 30 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 31 |
REG_BILL_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Bill Rate
|
| 32 |
REG_PAY_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Pay Rate
|
| 33 |
MIN_H0URS_WAIVED |
Character(1) |
VARCHAR2(1) NOT NULL |
Minimum Hours Waived
Y/N Table Edit
|
| 34 |
PERF_CALL_FREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Performance Frequency
|
| 35 |
SERVICE_AREA |
Character(6) |
VARCHAR2(6) NOT NULL |
Line of Business
|
| 36 |
CAREER_PLACEMENT |
Character(2) |
VARCHAR2(2) NOT NULL |
Career Placement
|
| 37 |
MIN_YEARS_EXP |
Number(2,0) |
SMALLINT NOT NULL |
Minimum Years Experience
|
| 38 |
CONFIDENCE_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Confidence
AL=Advanced
BL=Beginner
IL=Intermediate
NI=Not Investigated
|
| 39 |
CLIENT_JOB_TITLE |
Character(50) |
VARCHAR2(50) NOT NULL |
Client Job Title
|
| 40 |
SALARY_RANGE_MAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Maximum Salary Range
|
| 41 |
SALARY_RANGE_MIN |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Salary Range
|
| 42 |
METHOD_OF_PAYMENT |
Character(3) |
VARCHAR2(3) NOT NULL |
Method of Payment
|
| 43 |
TEMP_TO_HIRE_FEE |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Temp to Hire Fee
|
| 44 |
CAREER_FEE |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Career Fee
|
| 45 |
UC_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
UC State
|
| 46 |
TAX_SCHEDULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Tax
|
| 47 |
TAX_SCHEDULE_BASIS |
Character(3) |
VARCHAR2(3) NOT NULL |
Sales Tax Basis
|
| 48 |
COMMISSION_USER |
Character(30) |
VARCHAR2(30) NOT NULL |
Commission User
|
| 49 |
JOB_CAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Job Category
|
| 50 |
JOBTITLE |
Character(9) |
VARCHAR2(9) NOT NULL |
Job Title
|
| 51 |
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
|
| 52 |
PO_NUMBER |
Character(20) |
VARCHAR2(20) NOT NULL |
PO Number
|
| 53 |
INVOICE_FIELD_1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Invoice Field 1
|
| 54 |
INVOICE_FIELD_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Invoice Field 2
|
| 55 |
INVOICE_FIELD_3 |
Character(15) |
VARCHAR2(15) NOT NULL |
Invoice Field 3
|
| 56 |
RELOCATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Willing to Relocate
|
| 57 |
CO_OP |
Character(1) |
VARCHAR2(1) NOT NULL |
CO-OP Order
|
| 58 |
INITIAL_COMP |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Compensation
|
| 59 |
ORDER_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
02/2001 cel WV-802-1.0
10=Existing Purchase Order
20=Planned Purchase Order
|
| 60 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 61 |
JOB_DESCR |
Long Character |
CLOB |
Job Description
|
| 62 |
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
|
| 63 |
CONFIDENTIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Confidential Order
|
| 64 |
COMMENT1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Comments
|
| 65 |
SALES_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Sales Operator
|
| 66 |
SERVICE_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Service Operator
|
| 67 |
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
|
| 68 |
APPROVAL_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Action
|
| 69 |
FO_CSF_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Definition ID
|
| 70 |
ADDR_BILL_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Bill to Address
|
| 71 |
ORDER_EVENT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Event Group
|
| 72 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 73 |
FO_MARKUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Markup
NSTD=Non Standard Markup
STD=Standard Markup
|
| 74 |
FO_TARGET_MARGIN |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Target Margin
|