PC_BI_MNGMT_VW (SQL View)	Index Back
SQL View Used by BI Management

PC_BI_MNGMT_VW

(SQL View)

SQL View

Used by BI Management

SELECT AGM.ANALYSIS_GROUP , BI.BUSINESS_UNIT , BI.PROJECT_ID , BI.ACTIVITY_ID , BI.CONTRACT_NUM , BI.CUST_ID , BI.FOREIGN_CURRENCY ,%Round(SUM(%DecMult(BI.FOREIGN_AMOUNT, AGM.SIGNED_VALUE)), 2) ,BI.CA_FEE_STATUS FROM PS_PC_BI_MNGMT BI , PS_PROJ_AN_GRP_MAP AGM , PS_SET_CNTRL_GROUP GRP WHERE AGM.ANALYSIS_GROUP IN ('BLD','UNBLD') AND BI.BUSINESS_UNIT = GRP.SETCNTRLVALUE AND GRP.REC_GROUP_ID = 'PC_01' AND GRP.SETID = AGM.SETID AND AGM.ANALYSIS_TYPE = BI.ANALYSIS_TYPE GROUP BY BI.BUSINESS_UNIT, BI.PROJECT_ID, BI.ACTIVITY_ID, BI.CONTRACT_NUM, BI.CUST_ID, BI.FOREIGN_CURRENCY, BI.CA_FEE_STATUS, AGM.ANALYSIS_GROUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ANALYSIS_GROUP Character(5) VARCHAR2(5) NOT NULL Analysis Group

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 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

6 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

7 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

8 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.

9 CA_FEE_STATUS Character(1) VARCHAR2(1) NOT NULL Cost Plus Fee Status for Governement Contracts
1=Fee Generated
2=Bil Actual Fee
3=Bil Additional Award Fee
4=Rev Actual Fee
5=Rev Additional Award Fee

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ANALYSIS_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Analysis Group
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	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
6	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
7	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
8	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
9	CA_FEE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Cost Plus Fee Status for Governement Contracts 1=Fee Generated 2=Bil Actual Fee 3=Bil Additional Award Fee 4=Rev Actual Fee 5=Rev Additional Award Fee