PC_DTLPROF_TAO (SQL Table)	Index Back
Project Profit Detail Cache This is a cache table that holds the calculated results for the Project Profitability Details report.

PC_DTLPROF_TAO

(SQL Table)

Project Profit Detail Cache

This is a cache table that holds the calculated results for the Project Profitability Details report.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

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

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment

6 PROJECT_MANAGER Character(11) VARCHAR2(11) NOT NULL Project Manager

7 NAME Character(50) VARCHAR2(50) NOT NULL Name

8 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

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

10 BUDGET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL BUDGET_AMT

11 REV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Reveune Amount

12 COST_AMT Number(27,3) DECIMAL(26,3) NOT NULL Cost Amount

13 MARGIN Signed Number(28,3) DECIMAL(26,3) NOT NULL Margin

14 PROFIT_MARGIN Signed Number(27,2) DECIMAL(25,2) NOT NULL Profit Margin Percent

15 VAR_AMOUNT_01 Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	PROJECT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Type A=Activity G=Grant H=Phase P=Project S=Segment
6	PROJECT_MANAGER	Character(11)	VARCHAR2(11) NOT NULL	Project Manager
7	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
8	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	BUDGET_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	BUDGET_AMT
11	REV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Reveune Amount
12	COST_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Amount
13	MARGIN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Margin
14	PROFIT_MARGIN	Signed Number(27,2)	DECIMAL(25,2) NOT NULL	Profit Margin Percent
15	VAR_AMOUNT_01	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.