PC_CA_DETAIL (SQL View)	Index Back
View of Contract lines This view is a join between CA_DETAIL_PROJ and CA_RATE.

PC_CA_DETAIL

(SQL View)

View of Contract lines

This view is a join between CA_DETAIL_PROJ and CA_RATE.

SELECT DTL.CONTRACT_NUM , DTL.CONTRACT_LINE_NUM , DTL.BUSINESS_UNIT_PC , DTL.PROJECT_ID , DTL.ACTIVITY_ID , DTL.BILLED_TO_DATE , DTL.ACTIVITY_FLAG , DTL.RESOURCE_TYPE , DTL.RESOURCE_CATEGORY , DTL.RESOURCE_SUB_CAT , ( SELECT RTE.RATE_TMPL_OPTION FROM PS_CA_RATE RTE WHERE DTL.CONTRACT_NUM = RTE.CONTRACT_NUM AND DTL.CONTRACT_LINE_NUM = RTE.CONTRACT_LINE_NUM AND RTE.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CA_RATE RT1 WHERE RT1.CONTRACT_NUM = RTE.CONTRACT_NUM AND RT1.CONTRACT_LINE_NUM = RTE.CONTRACT_LINE_NUM )) , ( SELECT RTE.PC_TEMPLATE_ID FROM PS_CA_RATE RTE WHERE DTL.CONTRACT_NUM = RTE.CONTRACT_NUM AND DTL.CONTRACT_LINE_NUM = RTE.CONTRACT_LINE_NUM AND RTE.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CA_RATE RT1 WHERE RT1.CONTRACT_NUM = RTE.CONTRACT_NUM AND RT1.CONTRACT_LINE_NUM = RTE.CONTRACT_LINE_NUM )), ( SELECT RTE.RATE_PLAN FROM PS_CA_RATE RTE WHERE DTL.CONTRACT_NUM = RTE.CONTRACT_NUM AND DTL.CONTRACT_LINE_NUM = RTE.CONTRACT_LINE_NUM AND RTE.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CA_RATE RT1 WHERE RT1.CONTRACT_NUM = RTE.CONTRACT_NUM AND RT1.CONTRACT_LINE_NUM = RTE.CONTRACT_LINE_NUM )) FROM PS_CA_DETAIL_PROJ DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDITTABLE

6 BILLED_TO_DATE Signed Number(28,3) DECIMAL(26,3) NOT NULL Billed To Date

7 ACTIVITY_FLAG Character(3) VARCHAR2(3) NOT NULL Use all activities
ALL=All Activities
ONE=One Activity

8 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

9 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

10 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

11 RATE_TMPL_OPTION Character(4) VARCHAR2(4) NOT NULL Rate Option
CRTP=Contract Rate Plan
NSTD=Contract Rate Set
TMPL=Rate Set
URTP=Rate Plan

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

13 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
2	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
5	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDITTABLE
6	BILLED_TO_DATE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Billed To Date
7	ACTIVITY_FLAG	Character(3)	VARCHAR2(3) NOT NULL	Use all activities ALL=All Activities ONE=One Activity
8	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
9	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
10	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
11	RATE_TMPL_OPTION	Character(4)	VARCHAR2(4) NOT NULL	Rate Option CRTP=Contract Rate Plan NSTD=Contract Rate Set TMPL=Rate Set URTP=Rate Plan
12	PC_TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Rate Template ID
13	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.