PC_ATVPROF_TAO (SQL Table)	Index Back
Activity Profit Detail Cache This is a cache table that holds the calculated results for the Project Profitability Details report at the Activity drill down level.

PC_ATVPROF_TAO

(SQL Table)

Activity Profit Detail Cache

This is a cache table that holds the calculated results for the Project Profitability Details report at the Activity drill down level.

# 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 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

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

6 ACTIVITY_TYPE Character(5) VARCHAR2(5) NOT NULL Activity Type
A=Activity Type
E=Entry Type
G=Group Type/Origin
O=Activity Type/Origin
R=Entry Type/Reason

7 PC_ACT_OWNER Character(11) VARCHAR2(11) NOT NULL Activity Owner - The employee id of the individual who is responsible for the execution of an activity or a group of activities.

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

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	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	ACTIVITY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Activity Type A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason
7	PC_ACT_OWNER	Character(11)	VARCHAR2(11) NOT NULL	Activity Owner - The employee id of the individual who is responsible for the execution of an activity or a group of activities.
8	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
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.