RS_SNR_ROLE_RT (SQL View)	Index Back
Role Rate View SCP - Used to get the role rate for each role in the RS_SUP_DTL_WS Scroll of Scenario Supply Details Page.

RS_SNR_ROLE_RT

(SQL View)

Role Rate View

SCP - Used to get the role rate for each role in the RS_SUP_DTL_WS Scroll of Scenario Supply Details Page.

SELECT A.SETID , A.PROJ_ROLE , A.REGION_CD , A.COST_RATE , A.UNIT_OF_MEASURE , A.CURRENCY_CD FROM %Table(PC_RATE_ROLERGN) A WHERE A.UNIT_OF_MEASURE IN ('MDY','MHR','DAY') AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM %Table(PC_RATE_ROLERGN) A_ED WHERE A_ED.SETID = A.SETID AND A_ED.PROJ_ROLE = A.PROJ_ROLE AND A_ED.REGION_CD = A.REGION_CD AND A_ED.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

3 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

4 BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate

5 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role
3	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
4	BILL_RATE	Number(27,3)	DECIMAL(26,3) NOT NULL	Billing Rate
5	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code