GM_RATE_LN_SET (SQL View)	Index Back
Rate Ln and Set View

GM_RATE_LN_SET

(SQL View)

Rate Ln and Set View

SELECT DISTINCT A.BUSINESS_UNIT , A.RATE_PLAN , A.RATE_PLAN_TYPE , C.PC_TEMPLATE_ID , C.TEMPLATE_TYPE , C.RATE_DEF_TYPE FROM PS_PC_RATE_PLAN_LN A ,PS_PC_RATE_PLAN_EF B ,PS_PC_RATE_SET C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RATE_PLAN = B.RATE_PLAN AND A.RATE_PLAN_TYPE = B.RATE_PLAN_TYPE AND A.RATE_PLAN_TYPE = 'R' AND A.EFFDT = B.EFFDT AND B.EFF_STATUS = 'A' AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PC_TEMPLATE_ID = C.PC_TEMPLATE_ID AND %EffdtCheck(PC_RATE_PLAN_LN SA, A, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

2 RATE_PLAN Character(15) VARCHAR2(15) NOT NULL Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line.

3 RATE_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Rate plan type determines whether a rate plan is created from Projects or Contracts.
C=Contract
R=Standard

4 PC_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Rate Template ID

5 TEMPLATE_TYPE Character(3) VARCHAR2(3) NOT NULL Used to identify what document/transaction is associated with a particular template. This is a translate table field whose value is either expense sheet or travel authorization. Cash advances do not use templates. Projects is using types are R and C.
C=Contract
E=Expense Report
R=Standard
T=Travel Authorization

6 RATE_DEF_TYPE Character(1) VARCHAR2(1) NOT NULL Rate Definition Type
B=Billing
C=Cost
M=Cost / Billing
R=Revenue

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
2	RATE_PLAN	Character(15)	VARCHAR2(15) NOT NULL	Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line.
3	RATE_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Rate plan type determines whether a rate plan is created from Projects or Contracts. C=Contract R=Standard
4	PC_TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Rate Template ID
5	TEMPLATE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Used to identify what document/transaction is associated with a particular template. This is a translate table field whose value is either expense sheet or travel authorization. Cash advances do not use templates. Projects is using types are R and C. C=Contract E=Expense Report R=Standard T=Travel Authorization
6	RATE_DEF_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Rate Definition Type B=Billing C=Cost M=Cost / Billing R=Revenue