| # |
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 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 6 |
DETAIL_NO |
Number(3,0) |
SMALLINT NOT NULL |
Detail Number
|
| 7 |
TIME_RPTG_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code
|
| 8 |
REG_PAY_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Pay Rate
|
| 9 |
REG_BILL_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Bill Rate
|
| 10 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Default Value: MHR
|
| 11 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 12 |
RATE_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Rate Option
ABI=Activity Bill Rate
ACO=Activity Cost Rate
AML=Mark Up/Down Labor
AMN=Mark Up/Down Non-labor
AMT=Quantity Rate
CRB=Custom Bill Rate
CRC=Custom Cost Rate
EBI=Employee Bill Rate
ECO=Employee Cost Rate
FIX=Fixed Amount
JBI=Job Code Bill Rate
JCO=Job Code Cost Rate
MUP=Markup Rate
NON=Bill at Cost
RBI=Project Role Bill Rate
RCO=Project Role Cost Rate
TBI=MM Tools Usage Bill Rate
TCO=MM Tools Usage Cost Rate
WBI=Work Order Labor Bill Rate
WCO=Work Order Labor Cost Rate
|
| 13 |
MARGIN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Margin
|
| 14 |
FO_DFLT_RATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Rate
Y/N Table Edit
|
| 15 |
FO_RATE_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Action
A=Pay and Bill
B=Bill Only
M=Mark-up
P=Pay Only
|
| 16 |
FO_HR_PAY_RATE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Employee Pay Rate
|
| 17 |
PAY_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
The holding currency for a bank account on the disbursing side of a settlement transaction.
|
| 18 |
FO_AVE_PAY_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Contractor Pay Rate
|
| 19 |
FO_AVE_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 20 |
MARKUP |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Markup Percent
|
| 21 |
RATE_PROFILE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Profile Type
S=Salaried Staff
T=Temporary Staff
V=Associated Supplier
|
| 22 |
FO_PAY_RATE_FACTOR |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Rate Factor
Default Value: 1
|