FO_ASGN_RT2_STG (SQL Table)	Index Back
Front-Office-ASSIGN_EARN_DTL FO_ASGN_RT2_STG is used as a staging table in moving over Assignment information from the Front Office. No information is actually stored within the table. The table's only function is to have the same structure so that messages can be processed for application messaging. All inserts into the BO are done via the subscription code for the Assignment.

FO_ASGN_RT2_STG

(SQL Table)

Front-Office-ASSIGN_EARN_DTL

FO_ASGN_RT2_STG is used as a staging table in moving over Assignment information from the Front Office. No information is actually stored within the table. The table's only function is to have the same structure so that messages can be processed for application messaging. All inserts into the BO are done via the subscription code for the Assignment.

# 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

11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

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

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 FO_MARKUP_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Markup %

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

#	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
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
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
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	FO_MARKUP_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Markup %
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