FO_RTPRFL_LN_VW (SQL View)	Index Back
Rate Profile Target View Excludes SEQ_NUM. This field is only needed to fit in with the way component processor handles key changes. This view excludes this field to make other processing more straightforward.

FO_RTPRFL_LN_VW

(SQL View)

Rate Profile Target View

Excludes SEQ_NUM. This field is only needed to fit in with the way component processor handles key changes. This view excludes this field to make other processing more straightforward.

SELECT SETID ,RATE_ELEMENT ,LINE_NO ,RATE_OPTION , RATE_AMOUNT ,DESCR20 ,OVERRIDE_SRC ,TO_CUR ,TGT_AN_TYPE , TGT_RES_TYPE ,TGT_RES_CATEGORY ,TGT_RES_SUB_CAT FROM PS_FO_RATE_ELEM_LN

Parent record: PC_RATE_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 RATE_ELEMENT Character(5) VARCHAR2(5) NOT NULL Rate Element

3 LINE_NO Number(3,0) SMALLINT NOT NULL Line Number
Default Value: 1

4 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

5 RATE_AMOUNT Number(11,4) DECIMAL(10,4) NOT NULL Rate Amount
Default Value: 1

6 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description 20

7 OVERRIDE_SRC Character(1) VARCHAR2(1) NOT NULL Override Source
Default Value: N

8 TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code
Prompt Table: CURRENCY_CD_TBL

9 TGT_AN_TYPE Character(3) VARCHAR2(3) NOT NULL Target Analysis Type
Prompt Table: PROJ_ANTYPE_TBL

10 TGT_RES_TYPE Character(5) VARCHAR2(5) NOT NULL Target Resource Type
Prompt Table: PROJ_RES_TYPE

11 TGT_RES_CATEGORY Character(5) VARCHAR2(5) NOT NULL Target Resource Category
Prompt Table: %EDITTABLE3

12 TGT_RES_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Target Resource SubCategory
Prompt Table: %EDITTABLE4

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	RATE_ELEMENT	Character(5)	VARCHAR2(5) NOT NULL	Rate Element
3	LINE_NO	Number(3,0)	SMALLINT NOT NULL	Line Number Default Value: 1
4	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
5	RATE_AMOUNT	Number(11,4)	DECIMAL(10,4) NOT NULL	Rate Amount Default Value: 1
6	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description 20
7	OVERRIDE_SRC	Character(1)	VARCHAR2(1) NOT NULL	Override Source Default Value: N
8	TO_CUR	Character(3)	VARCHAR2(3) NOT NULL	To Currency Code Prompt Table: CURRENCY_CD_TBL
9	TGT_AN_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Target Analysis Type Prompt Table: PROJ_ANTYPE_TBL
10	TGT_RES_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Target Resource Type Prompt Table: PROJ_RES_TYPE
11	TGT_RES_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Target Resource Category Prompt Table: %EDITTABLE3
12	TGT_RES_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Target Resource SubCategory Prompt Table: %EDITTABLE4